[Kentaurus]

Originally Posted by NTLDR

[high]Show Only Active/Certain Usergroups In Member Count[/high]

Details:

Author: NTLDR
Version: 1.0.1
Requested by: kie (here) and xtremeathlonxp (here).

Description: This hack will alter the member count shown on the forums home page to exclude certain usergroups or only include members with X posts. PLEASE NOTE: the member count will only alter to effect the new totals when the stats update, ie when a new user registers.

Changes to make:

In includes/functions_databuild.php find:

PHP Code:

$members = $DB_site->query_first("SELECT COUNT(*) AS users, MAX(userid) AS max FROM " . TABLE_PREFIX . "user"); 


Replace with (if you only want to exclude certain groups) (replace X and Y with the usergroupids to exclude):

PHP Code:

$members = $DB_site->query_first("SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user WHERE usergroupid NOT IN (X,Y)"); 


or Replace with (if you only want to show members with X posts) (replace W with the number of posts a user must have):

PHP Code:

$members = $DB_site->query_first("SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user WHERE posts >= W"); 


or Replace with (for both of the above):

PHP Code:

$members = $DB_site->query_first("SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user WHERE usergroupid NOT IN (X,Y) AND posts >= W"); 


Find:

PHP Code:

// get newest member
$newuser = $DB_site->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members[max]"); 


Replace with:

PHP Code:

$members2 = $DB_site->query_first("SELECT MAX(userid) AS max FROM " . TABLE_PREFIX . "user");
// get newest member
$newuser = $DB_site->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members2[max]"); 


[high]Please click install if you use this hack[/high]

Maybe I would like a hack that behaves this way (but this is just my personal preference): display all users that have been active in the forum, where active means that they have posted at least 20 posts in the last week (that's the media for my forum).

Currently the lastactivity, lastpost and posts counters are pretty useless because a user may come to the forum, put 100 posts in it and then disappear for five months or so, that is not an active user for me. Also it is argueable that a user that only browses the forum but doesn't post is an active user.