117 lines
3.8 KiB
PHP
117 lines
3.8 KiB
PHP
<?php
|
|
require('../php/connect.php');
|
|
|
|
|
|
$succes_llr = 0;
|
|
$mislukt_llr = 0;
|
|
|
|
$succes_doc = 0;
|
|
$mislukt_doc = 0;
|
|
|
|
//Hij heeft wel ff nodig
|
|
ini_set('max_execution_time', 0);
|
|
|
|
|
|
//Leerlingen
|
|
echo str_repeat(' ', 4096) . "<br><h2 style='display: inline;'><font color='#696A7A'>Updating leerlingen...</font></h2><br>";
|
|
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 <font color='#30D13E'>succesvol</font> geupdate.<br>";
|
|
echo "$mislukt_llr leerlingen <font color='#DB3232'>niet</font> geupdate.<br><br>";
|
|
|
|
flush();
|
|
|
|
|
|
//Docenten
|
|
echo "<h2 style='display: inline;'><font color='#696A7A' >Updating docenten...</font></h2><br>";
|
|
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 <font color='#30D13E'>succesvol</font> geupdate.<br>";
|
|
echo "$mislukt_doc docenten <font color='#DB3232'>niet</font> geupdate.<br><br>";
|
|
|
|
flush();
|
|
|
|
|
|
|
|
|
|
//Alle email adressen verwijderen en de tabel resetten
|
|
echo "<h2 style='display: inline;'><font color='#696A7A' >Resetting pass_forgot...</font></h2><br>";
|
|
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 <font color='#30D13E'>succesvol</font> gereset.<br><br>";
|
|
}
|
|
else {
|
|
echo "Alle cellen <font color='#30D13E'>niet</font> gereset.<br><br>";
|
|
}
|
|
|
|
flush();
|
|
|
|
|
|
//Last Login en IP adressen verwijderen
|
|
echo "<h2 style='display: inline;'><font color='#696A7A' >Resetting log...</font></h2><br>";
|
|
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 <font color='#30D13E'>succesvol</font> gereset.<br><br>";
|
|
}
|
|
else {
|
|
echo "Alle cellen <font color='#30D13E'>niet</font> gereset.<br><br>";
|
|
}
|
|
|
|
flush();
|
|
|
|
|
|
//Verstuurde berichten verwijderen
|
|
echo "<h2 style='display: inline;'><font color='#696A7A' >Resetting bericht...</font></h2><br>";
|
|
flush();
|
|
|
|
$query_del = "TRUNCATE TABLE `bericht`";
|
|
if(mysql_query($query_del, $connection)){
|
|
echo "Table <font color='#30D13E'>succesvol</font> geleegd.<br>";
|
|
}
|
|
else {
|
|
echo "Table <font color='#30D13E'>niet</font> geleegd.<br>";
|
|
}
|
|
|
|
$query_del = "ALTER TABLE `bericht` AUTO_INCREMENT =1";
|
|
if(mysql_query($query_del, $connection)){
|
|
echo "Auto Increment <font color='#30D13E'>succesvol</font> gereset.<br><br>";
|
|
}
|
|
else {
|
|
echo "Auto Increment <font color='#30D13E'>niet</font> gereset.<br><br>";
|
|
}
|
|
|
|
echo "<h2 style='display: inline;'><font color='#696A7A' >Reset Compleet...</font></h2><br>";
|
|
?>
|