| outlaw621 |
11-05-2005 05:01 PM |
Quote:
Originally Posted by 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?
|
Did you try changing userid to usergroupid? I have not tested this yet. It is just a thought.
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 usergroupid NOT IN (8) ORDER BY posts DESC LIMIT 0, $displayrecords");
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 usergroupid NOT IN (8) ORDER BY posts DESC LIMIT 0, $displayrecords");
The above code MAY let you exclude by group instead of user. In the above examples, it should exclude group 8 which is the default banned users group. |
More Information