xdb->execute("UPDATE auth_user_md5 set nom_usage={?} WHERE user_id={?}",$usage ,$uid); $globals->xdb->execute("DELETE FROM aliases WHERE FIND_IN_SET('usage',flags) AND id={?}", $uid); if ($alias && $usage) { $globals->xdb->execute("UPDATE aliases SET flags=flags & 255-1 WHERE id={?}", $uid); $globals->xdb->execute("INSERT INTO aliases VALUES({?}, 'alias', 'usage,bestalias', {?}, null)", $alias, $uid); } $r = $globals->xdb->query("SELECT alias FROM aliases WHERE FIND_IN_SET('bestalias', flags) AND id = {?}", $uid); if ($r->fetchOneCell() == "") { $globals->xdb->execute("UPDATE aliases SET flags = 1 | flags WHERE id = {?} LIMIT 1", $uid); } require_once 'user.func.inc.php'; user_reindex($uid); } // vim:set et sw=4 sts=4 sws=4 foldmethod=marker: ?>