Ryoko wrote:Gaigemasta wrote:very nice!
you should show us the algorithm for how people qualify not to be listed (of course not the code)
Originally it was
// $sql = "SELECT username, user_id, user_regdate, user_avatar, user_avatar_type, user_avatar_width, user_avatar_height,user_posts FROM users WHERE user_posts > 600 AND user_avatar <> '' AND user_id NOT IN (SELECT ban_userid FROM banlist) ORDER BY user_regdate ASC";
But after some thought, I decided it wasn't really proper to "pretend" banned people never existed or contributed to SRF at some point.
simple enough but yet effective. We appreciate it















