Commit | Line | Data |
---|---|---|
92b37ea3 VZ |
1 | #!/usr/bin/php5 |
2 | <?php | |
3 | ||
4 | require_once 'connect.db.inc.php'; | |
5 | require_once 'xorg.misc.inc.php'; | |
6 | ||
7 | // Fetches the list of unregistered users. | |
8 | $users = XDB::iterRow( | |
9 | "SELECT user_id, prenom, nom, promo | |
10 | FROM auth_user_md5 | |
11 | WHERE hruid IS NULL"); | |
12 | ||
13 | // Creates missing human readable uids. | |
14 | while (list($user_id, $prenom, $nom, $promo) = $users->next()) { | |
15 | $forlife = make_forlife($prenom, $nom, $promo); | |
16 | if (!XDB::execute("UPDATE auth_user_md5 SET hruid = {?} WHERE user_id = {?}", $forlife, $user_id)) { | |
17 | echo "WARNING: Duplicate forlife for user $user_id and forlife '$forlife'. Please check manually the entry.\n"; | |
18 | } | |
19 | } | |
20 | ?> |