PDA

View Full Version : How do I take Administrators out of TOP POST


goingnova
06-09-2004, 06:40 PM
Hello, and thank you for trying to help me.

In PHP, there was an option to take Administrators out of the TOP POSTER count. Is there a way to take them out, or at least, certain users?

Brian
06-09-2004, 09:35 PM
Open forum/modules/stats.php and look for:

$topposter = $DB_site->query_first('SELECT username, posts, userid FROM ' . TABLE_PREFIX . 'user ORDER BY posts DESC LIMIT 1');

Replace that with:

$topposter = $DB_site->query_first('SELECT username, posts, userid FROM ' . TABLE_PREFIX . 'user WHERE usergroupid != 6 ORDER BY posts DESC LIMIT 1');

Our Sponsors
 

goingnova
06-10-2004, 05:04 AM
Shame on me, that was so OBVIOUS! LOL, thanks Brian. :)