58 lines
1.6 KiB
PHP
58 lines
1.6 KiB
PHP
<?php
|
|
exit();
|
|
|
|
include "db.php";
|
|
|
|
$AllAdminUserTypes = array('SuperUser','System Administrator','Application Administrator','Communications Administrator','Administration Team','Schedule Team','Financial','Financial Team');
|
|
$userTypes = implode("','",$AllAdminUserTypes);
|
|
|
|
$Users = array();
|
|
$query = "SELECT * FROM users WHERE type IN ('$userTypes')";
|
|
echo("$query\n");
|
|
|
|
$results = db_query($query);
|
|
while ($row = db_fetch_assoc($results)) {
|
|
$Users[] = $row;
|
|
}
|
|
|
|
$Databases = array(
|
|
"hotlunch_20250526",
|
|
"hotlunch_20250701",
|
|
"hotlunch_20250711",
|
|
"hotlunch_20250716",
|
|
"hotlunch_20250930",
|
|
"hotlunch_20251131",
|
|
"hotlunch_20260225",
|
|
"hotlunch_20260226",
|
|
"hotlunch_20260601",
|
|
"hotlunch_20260615",
|
|
"hotlunch_20260701",
|
|
"hotlunch_20260728",
|
|
"hotlunch_20260807",
|
|
"hotlunch_20260821",
|
|
"hotlunch_20260902",
|
|
"hotlunch_20260903",
|
|
"hotlunch_20260904",
|
|
"hotlunch_20260905",
|
|
"hotlunch_20260906",
|
|
"hotlunch_20260907",
|
|
);
|
|
|
|
for ($i = 0; $i < count($Databases); $i++) {
|
|
$DB = $Databases[$i];
|
|
echo("$DB\n");
|
|
db_query("USE $DB");
|
|
|
|
for ($j = 0; $j < count($Users); $j++) {
|
|
$user = $Users[$j];
|
|
|
|
$pwcrypt = $user['password_crypt'];
|
|
$rnum = $user['record_num'];
|
|
|
|
$query = "UPDATE users SET password_crypt = '$pwcrypt' WHERE record_num = $rnum";
|
|
db_query($query);
|
|
}
|
|
}
|
|
|
|
?>
|