[jluerken]

I found out how I can exclude users from the TOP Poster list.

In topXstats.php find:

PHP Code:

$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords"); 


and change to

PHP Code:

$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user WHERE userid NOT IN (1282,1) ORDER BY posts DESC LIMIT 0, $displayrecords"); 


I added a WHERE userid NOT IN (1282,1) which is an array of userid's.

In this example I excluded userid 1282 which is my RSS Bot and userid 1 which is the main Admin account.

In product-topXstats.xml find:

PHP Code:

$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords"); 


and change to:

PHP Code:

$getstats_posters = $db->query_read("SELECT userid, usergroupid, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid, username, posts FROM " . TABLE_PREFIX . "user WHERE userid NOT IN (1282,1) ORDER BY posts DESC LIMIT 0, $displayrecords"); 


Reupload the topXstats.php and
then go to your ADMINCP - PLUGIN SYSTEM - MANAGE PRODUCTS - ADD/IMPORT PRODUCT and upload the change .xml file.
Make sure that "Allow Overwrite" is set to YES

Thats it!

I did not find out how to exclude a whole group like the banned group.

@InfiniteWebby:
Could you please release a version 1.3 where we can also exclude single userids and whole groups?