plugins/admin/UserManager.php
changeset 149 42c6c83b8a00
parent 142 ca9118d9c0f2
child 166 d53cc29308f4
child 224 6a4573507ff8
equal deleted inserted replaced
144:380e55865f86 149:42c6c83b8a00
   284       return false;
   284       return false;
   285     }
   285     }
   286     $q = $db->sql_query('SELECT u.user_id AS authoritative_uid, u.username, u.email, u.real_name, u.signature, u.account_active, u.user_level, x.* FROM '.table_prefix.'users AS u
   286     $q = $db->sql_query('SELECT u.user_id AS authoritative_uid, u.username, u.email, u.real_name, u.signature, u.account_active, u.user_level, x.* FROM '.table_prefix.'users AS u
   287                            LEFT JOIN '.table_prefix.'users_extra AS x
   287                            LEFT JOIN '.table_prefix.'users_extra AS x
   288                              ON ( u.user_id = x.user_id OR x.user_id IS NULL )
   288                              ON ( u.user_id = x.user_id OR x.user_id IS NULL )
   289                            WHERE ( lcase(u.username) = \'' . $db->escape(strtolower($username)) . '\' OR u.username = \'' . $db->escape($username) . '\' ) AND user_id != 1;');
   289                            WHERE ( lcase(u.username) = \'' . $db->escape(strtolower($username)) . '\' OR u.username = \'' . $db->escape($username) . '\' ) AND u.user_id != 1;');
   290     if ( !$q )
   290     if ( !$q )
   291       $db->_die();
   291       $db->_die();
   292     
   292     
   293     if ( $db->numrows() < 1 )
   293     if ( $db->numrows() < 1 )
   294     {
   294     {