- $res = XDB::query("SELECT p.uid
- FROM #forums#.profils AS p
- INNER JOIN #x4dat#.aliases AS a ON (p.uid = a.id)
- WHERE FIND_IN_SET('xface', p.flags) AND a.alias = {?}",
- $login);
+ $user = User::getSilent($login);
+ $res = XDB::query("SELECT pf.uid
+ FROM forum_profiles AS pf
+ WHERE pf.uid = {?} AND FIND_IN_SET('xface', pf.flags)",
+ $user->id());