Originally Posted by DrNet (Post 16478) lol , i found the same problem in v5.4.1

Originally Posted by DrNet (Post 16480) i don't know what's wrong , i hope some 1 will fix this soon

Originally Posted by Nightcrawler (Post 16482) what part?

Originally Posted by DrNet (Post 16483) (No user found!)

---

  if (isset ($_GET['searchby']))
  {
    if ($_GET['searchby'] == 'banned')
    {
      $query = '(u.enabled = \'no\' OR u.usergroup=' . UC_BANNED . ')';
    }
    else
    {
      if ($_GET['searchby'] == 'warned')
      {
        $query = '(u.warned = \'yes\' OR u.leechwarn = \'yes\')';
      }
      else
      {
        if ($_GET['searchby'] == 'donor')
        {
          $query = 'u.donor = \'yes\'';
        }
        else
        {
          if ($_GET['searchby'] == 'vip')
          {
            $query = 'u.usergroup = \'' . UC_VIP . '\'';
          }
          else
          {
            if ($_GET['searchby'] == 'poweruser')
            {
              $query = 'u.usergroup = \'' . UC_POWER_USER . '\'';
            }
            else
            {
              $query = 'u.usergroup = \'' . UC_USER . '\'';
            }
          }
        }
      }
    }
  }
  else
  {
    $query = 'u.usergroup = \'' . UC_USER . '\'';
  }
 
  (($res = sql_query ('SELECT COUNT(*) FROM users WHERE ' . str_replace ('u.', '', $query)) OR sqlerr (__FILE__, 110)) OR sqlerr (__FILE__, 110));
  $row = mysql_fetch_array ($res);
  $count = $row[0];
  $perpage = $ts_perpage;
  list ($pagertop, $pagerbottom, $limit) = pager ($perpage, $count, $_this_script_ . '&' . ($_GET['searchby'] ? 'searchby=' . htmlspecialchars ($_GET['searchby'] . '&') : ''));
  stdhead ('UsersList');
  if (mysql_num_rows ($res) == 0)
  {
    begin_main_frame ();
  }
 
  $users = number_format (tsrowcount ('id', 'users', 'usergroup=\'' . UC_USER . '\''));
  begin_frame ('' . 'Users List (' . $users . ')', true);
  begin_table (true);
  echo '

 









';
  ($res = sql_query ('' . 'SELECT u.*, p.canupload, p.candownload, p.cancomment, p.canmessage, p.canshout, g.namestyle FROM users u LEFT JOIN ts_u_perm p ON (u.id=p.userid) LEFT JOIN usergroups g ON (u.usergroup=g.gid) WHERE ' . $query . ' ORDER BY u.id DESC '.$limit) OR sqlerr (__FILE__, 137));
  if (1 <= mysql_num_rows ($res))
  {
    while ($arr = @mysql_fetch_array ($res))
    {
      $pic = get_user_icons ($arr);
      $cn = get_user_class_name ($arr['usergroup']);
      echo '






';
    }
 
    echo '
';
    echo '';
  }
  else
  {
    echo '';
  }

---

---

Originally Posted by Nightcrawler (Post 16484) theres nothing wrong with it you need to add a normal user for it to show it doesn't count staff. this is the code.... Code:   if (isset ($_GET['searchby']))   {     if ($_GET['searchby'] == 'banned')     {       $query = '(u.enabled = \'no\' OR u.usergroup=' . UC_BANNED . ')';     }     else     {       if ($_GET['searchby'] == 'warned')       {         $query = '(u.warned = \'yes\' OR u.leechwarn = \'yes\')';       }       else       {         if ($_GET['searchby'] == 'donor')         {           $query = 'u.donor = \'yes\'';         }         else         {           if ($_GET['searchby'] == 'vip')           {             $query = 'u.usergroup = \'' . UC_VIP . '\'';           }           else           {             if ($_GET['searchby'] == 'poweruser')             {               $query = 'u.usergroup = \'' . UC_POWER_USER . '\'';             }             else             {               $query = 'u.usergroup = \'' . UC_USER . '\'';             }           }         }       }     }   }   else   {     $query = 'u.usergroup = \'' . UC_USER . '\'';   }     (($res = sql_query ('SELECT COUNT(*) FROM users WHERE ' . str_replace ('u.', '', $query)) OR sqlerr (__FILE__, 110)) OR sqlerr (__FILE__, 110));   $row = mysql_fetch_array ($res);   $count = $row[0];   $perpage = $ts_perpage;   list ($pagertop, $pagerbottom, $limit) = pager ($perpage, $count, $_this_script_ . '&' . ($_GET['searchby'] ? 'searchby=' . htmlspecialchars ($_GET['searchby'] . '&') : ''));   stdhead ('UsersList');   if (mysql_num_rows ($res) == 0)   {     begin_main_frame ();   }     $users = number_format (tsrowcount ('id', 'users', 'usergroup=\'' . UC_USER . '\''));   begin_frame ('' . 'Users List (' . $users . ')', true);   begin_table (true);   echo '
Search: Show ALL | banned| warned | donor | vip | poweruser
ID	Username	e-mail	Joined	DELETE	BAN	UNBAN
' . $arr[id] . '	' . get_user_color ($arr['username'], $arr['namestyle']) . ' ' . $pic . ' (' . $cn . ') ' . (($arr['enabled'] == 'no' ? '(banned)' : $arr['usergroup'] == 9) ? '(banned)' : '') . (($arr['warned'] == 'yes' ? '(warned)' : $arr['leechwarn'] == 'yes') ? '(leechwarned)' : '') . '' . htmlspecialchars_uni ($arr['ip']) . '	' . $arr[email] . '	' . $arr[added] . '
' . $pagerbottom . '
	No user found!

Originally Posted by PRODIGY (Post 16518) i cant login to staff panel neither change the pincode.....

Originally Posted by Nightcrawler (Post 16519) did you set the pincode during installation?