Exclude Users Posts in Some Forums from Stats?

[HeyMe]

Hello,

1st even if I mentioning a mod here, I don't think this issue belongs to mod support because there's nothing wrong with the mod.

I wanted the Top Posters stats in "Cyb's Advanced Stats" to show total posts excluding those made in the "Forums excluded from stats".

So with my very limited knowledge in PHP/mySQL, I opened the XML file & tried some things.

1st I found lines like these:

PHP Code:

$cybexclfids = ','.$vbulletin->options['cybtopstats_excl_forums']; 


PHP Code:

$cybexclforums_topforums = "AND thread.forumid NOT IN($cybexclfids)"; 


I tried to add a variable like $cybexclforums_topforums called $cybexclforums_toppost & added it here:

PHP Code:

                if ($cybstats_posters_tcenabled)
                {
                    $get_stats_posters = $vbulletin->db->query_read("
                        SELECT COUNT(post.postid) AS posts, post.userid, post.dateline, user.usergroupid, user.displaygroupid, user.username
                        FROM " . TABLE_PREFIX . "post AS post
                        LEFT JOIN " . TABLE_PREFIX . "user AS user ON (post.userid = user.userid)
                        LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid = post.threadid)
                        LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON (forum.forumid = thread.forumid)
                        WHERE user.userid > 0 AND posts > 0 AND post.visible= 1 AND (forum.options & 4096) $cybexclforums_toppost $cybexclgroups $cybtopstats_timecut_toppost
                        GROUP BY post.userid
                        ORDER BY posts DESC
                        LIMIT 0, $resultsnr
                    ");
                } 


I tried also to edit my $cybexclforums_toppost value, replacing thread.forumid with post.forumid then forumid , but it doesn't seem to work.


Any enlightenment?