Updating leerlingen...
";
flush();
$query_llr = "SELECT `name`, `pass` FROM `login` WHERE `perms`=1";
$result_temp_llr = mysql_query($query_llr, $connection);
while($result_llr = mysql_fetch_assoc($result_temp_llr)){
$name = $result_llr['name'];
$salt = sprintf('$2a$%02d$%s', 10, strtr(str_replace('=', '', base64_encode(mt_rand(16, 16))),'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/','./ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'));
$hash = crypt($name, $salt);
$query_update = "UPDATE `login` SET `pass`='$hash' WHERE name='$name'";
if(mysql_query($query_update, $connection)){
$succes_llr++;
}
else{
$mislukt_llr++;
}
}
echo "$succes_llr leerlingen succesvol geupdate.
";
echo "$mislukt_llr leerlingen niet geupdate.
";
flush();
//Docenten
echo "Updating docenten...
";
flush();
$query_doc = "SELECT `name`, `pass` FROM `login` WHERE `perms`=2";
$result_temp_doc = mysql_query($query_doc, $connection);
while($result_doc = mysql_fetch_assoc($result_temp_doc)){
$name = $result_doc['name'];
$salt = sprintf('$2a$%02d$%s', 10, strtr(str_replace('=', '', base64_encode(mt_rand(16, 16))),'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/','./ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'));
$hash = crypt($name, $salt);
$query_update = "UPDATE `login` SET `pass`='$hash' WHERE name='$name'";
if(mysql_query($query_update, $connection)){
$succes_doc++;
}
else{
$mislukt_doc++;
}
}
echo "$succes_doc docenten succesvol geupdate.
";
echo "$mislukt_doc docenten niet geupdate.
";
flush();
//Alle email adressen verwijderen en de tabel resetten
echo "Resetting pass_forgot...
";
flush();
$query_res = "UPDATE `pass_forgot` SET `mail`=NULL, `mail_new`=NULL, `confirm_mail`=NULL, `pass_forgot`=0 WHERE 1";
if(mysql_query($query_res, $connection)){
echo "Alle cellen succesvol gereset.
";
}
else {
echo "Alle cellen niet gereset.
";
}
flush();
//Last Login en IP adressen verwijderen
echo "Resetting log...
";
flush();
$query_res = "UPDATE `login` SET `last_login`='0000-00-00 00:00', `last_login_ip`=NULL WHERE 1";
if(mysql_query($query_res, $connection)){
echo "Alle cellen succesvol gereset.
";
}
else {
echo "Alle cellen niet gereset.
";
}
flush();
//Verstuurde berichten verwijderen
echo "Resetting bericht...
";
flush();
$query_del = "TRUNCATE TABLE `bericht`";
if(mysql_query($query_del, $connection)){
echo "Table succesvol geleegd.
";
}
else {
echo "Table niet geleegd.
";
}
$query_del = "ALTER TABLE `bericht` AUTO_INCREMENT =1";
if(mysql_query($query_del, $connection)){
echo "Auto Increment succesvol gereset.
";
}
else {
echo "Auto Increment niet gereset.
";
}
echo "Reset Compleet...
";
?>