Help please with Hall of Fame

[Joel]

How do take my staff of the Hall of Fame, So its just the members on Hall of Fame, Please Help.

[Deisel80]

Re: Help please with Hall of Fame

I'm assuming you would be the owner or staff member at least. I dont know what your user_level numbering scheme is. By default i think admins are set to level 2 so you would use something like this...........

 

$q=mysql_query("SELECT u.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.user_level < 2 ORDER BY us.labour DESC,u.userid ASC LIMIT 20", $c);

 

 

That query may not be totally correct cuz its on the fly and im really tired lol. You really just need to add the red part into your HOF queries.