[platal.git] / upgrade / 0.10.0 / hruid.update.php

#!/usr/bin/php5
<?php

require_once 'connect.db.inc.php';

// Fetches the list of unregistered users.
$users = XDB::iterRow(
    "SELECT  user_id, prenom, nom, promo
       FROM  auth_user_md5
      WHERE  hruid IS NULL");

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