+ if ($res->numRows()) {
+ _user_reindex($uid, $res->fetchOneRow(), array(1,1,1,0.2), array(true, true, true, false));
+ } else { // not in auth_user_quick => still "pending"
+ $res = XDB::query("SELECT prenom, nom, nom_usage FROM auth_user_md5 WHERE auth_user_md5.user_id = {?}", $uid);
+ if ($res->numRows()) {
+ _user_reindex($uid, $res->fetchOneRow(), array(1,1,1), array(true, true, true));
+ }
+ }
+}
+
+// }}}
+// {{{ function set_new_usage()
+
+function set_new_usage($uid, $usage, $alias=false)
+{
+ XDB::execute("UPDATE auth_user_md5 set nom_usage={?} WHERE user_id={?}",$usage ,$uid);
+ XDB::execute("DELETE FROM aliases WHERE FIND_IN_SET('usage',flags) AND id={?}", $uid);
+ if ($alias && $usage) {
+ XDB::execute("UPDATE aliases SET flags=flags & 255-1 WHERE id={?}", $uid);
+ XDB::execute("INSERT INTO aliases VALUES({?}, 'alias', 'usage,bestalias', {?}, null)",
+ $alias, $uid);
+ }
+ $r = XDB::query("SELECT alias FROM aliases WHERE FIND_IN_SET('bestalias', flags) AND id = {?}", $uid);
+ if ($r->numRows() == "") {
+ XDB::execute("UPDATE aliases SET flags = 1 | flags WHERE id = {?} LIMIT 1", $uid);
+ $r = XDB::query("SELECT alias FROM aliases WHERE FIND_IN_SET('bestalias', flags) AND id = {?}", $uid);
+ }
+ user_reindex($uid);
+ return $r->fetchOneCell();