[Gary King]

Today at 09:45 AM LadyBeth said this in Post #18
Can this be modified so that the Administrator is not included?
THanks!
Beth

Replace the

PHP Code:

// Top Posters Per Forum hack v1.0 by Gary W.
$topposter=$DB_site->query("SELECT COUNT(post.postid) AS posts,userid,username FROM post
    LEFT JOIN thread ON post.threadid = thread.threadid
    LEFT JOIN forum ON forum.forumid = thread.forumid
    WHERE forum.forumid=$forumid
    GROUP BY userid ORDER BY posts DESC LIMIT 0,$topposterno"); 


with

PHP Code:

// Top Posters Per Forum hack v1.0 by Gary W.
$topposter=$DB_site->query("SELECT COUNT(post.postid) AS posts,post.userid,post.username FROM post
    LEFT JOIN thread ON post.threadid = thread.threadid
    LEFT JOIN forum ON forum.forumid = thread.forumid
    LEFT JOIN user ON user.userid = post.userid
    WHERE forum.forumid=$forumid AND user.usergroupid != 6
    GROUP BY userid ORDER BY posts DESC LIMIT 0,$topposterno");