[Wolf42]

Originally posted by 69-FLy-gUy
Hm i have a little problem..

I also use the autoposter hack.. and the top thread starter is the autoposter. lol..

how do i code it so that it doesn't include the usergroup=0?

Find

PHP Code:

$toptstarter=$DB_site->query_first("SELECT COUNT(*) AS count,postuserid,postusername FROM thread GROUP BY postuserid ORDER BY count DESC LIMIT 1"); 


replace with

PHP Code:

$toptstarter=$DB_site->query_first("SELECT COUNT(*) AS count,thread.postuserid,thread.postusername,user.userid,user.usergroupid FROM thread,user WHERE thread.postuserid=user.userid AND user.usergroupid<>0 GROUP BY postuserid ORDER BY count DESC LIMIT 1"); 


Think that should word.