More "Realistic" Member Count on Forumhome

[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]

[Wonko of Shinra]

NTLDR, last idea was the one I was about to suggest, this works much better for us with large forums and high member turn over.

only you got a few typos in that one

PHP Code:

$members = $DB_site->query_first("SELECT COUNT(*) AS users, MAX(userid) AS max FROM " . TABLE_PREFIX . "user WHERE posts >= X AND lastactivity >= ".(TIMENOW - (60 * 60 * 24 * 7)).""); 


*thud*
from 5000 members to 1000, boy do i feel hollow.

[ChuanSE]

As I see it now, only registered members (or awaiting email confirmation) are counted. Guest are not (according to my pphlogger unique visitors stats).
Is there a way to have a stat that counts every guest, but resets itself every 24hr?
(cause pphlogger doesn't reset)

thx