30 )
$doneBefore = true;
}
dbi_free_result ( $res );
} else {
echo "Database error: " . dbi_error ();
exit;
}
if ( $doneBefore ) {
echo "Passwords were already converted to md5!\n
\n";
exit;
}
// See if webcal_user.cal_passwd will allow 32 characters
$sql = "DESC webcal_user";
$res = dbi_query ( $sql );
while ( $row = dbi_fetch_row ( $res ) ) {
if ($row[Field] == 'cal_passwd') {
preg_match ( "/([0-9]+)/", $row[Type], $match );
if ($match[1] < 32) {
$sql = "ALTER TABLE webcal_user MODIFY cal_passwd VARCHAR(32) NULL";
// Use the following on older MySQL versions
//$sql = "ALTER TABLE webcal_user CHANGE cal_passwd cal_passwd VARCHAR(32) NULL";
$res = dbi_query ( $sql );
if ($res) {
echo "Table webcal_user altered to allow 32 character passwords.\n" .
"
Converting passwords...\n
\n";
}
}
}
}
dbi_free_result ( $res );
// Convert the passwords
$sql = "SELECT cal_login, cal_passwd FROM webcal_user";
$res = dbi_query ( $sql );
if ( $res ) {
while ( $row = dbi_fetch_row ( $res ) ) {
$sql2 = "UPDATE webcal_user SET cal_passwd = '" .
md5($row[1]) . "' WHERE cal_login = '".$row[0]."'";
$res2 = dbi_query ( $sql2 );
if ($res2)
echo "Password updated for: ".$row[0]."
\n";
}
dbi_free_result ( $res );
echo "Finished converting passwords\n
\n";
echo "
\nDO NOT Run this script again!!!
\n
\n";
echo 'Delete this script if it ran successfully!!!
';
}
?>