8e38ca053fbc11f59744870313c4d36f23de8450
4 require_once 'connect.db.inc.php';
6 // Fetches the list of unregistered users.
8 "SELECT user_id, prenom, nom, promo
10 WHERE hruid IS NULL");
12 // Creates missing human readable uids.
13 while (list($user_id, $prenom, $nom, $promo) = $users->next()) {
14 $forlife = make_forlife($prenom, $nom, $promo);
15 $hruid = XDB
::query('SELECT * FROM auth_user_md5 WHERE hruid = {?} AND user_id != {?}', $forlife, $user_id);
16 if ($hruid->numRows() > 0) {
17 echo "WARNING: Duplicate forlife for user $user_id and forlife '$forlife'. Please check manually the entry.\n";
19 XDB
::execute('UPDATE auth_user_md5 SET hruid = {?} WHERE user_id = {?}', $forlife, $user_id);