[Lynne]

Doing a search of "post.userid, COUNT(*) AS replycount" in the files shows me this query:

PHP Code:

        $tachy_db = $vbulletin->db->query_read("
            SELECT post.userid, COUNT(*) AS replycount
            FROM " . TABLE_PREFIX . "post AS post
            INNER JOIN " . TABLE_PREFIX . "thread AS thread ON (post.threadid = thread.threadid)
            WHERE post.userid IN ($coventry)
                AND post.visible = 1
                AND thread.forumid = $forumid
            GROUP BY post.userid
        "); 


On line 166 in includes/functions_databuild.php The same query shows up on line 346 of the same file.

Perhaps you might want to consider taking some users out of coventry and using another banning method.