More "Realistic" Member Count on Forumhome
Mod Version: 1.00, by NTLDR
This modification is in the archives.
| vB Version: 3.0.0 | Rating:  (0 vote - 0 average) |
Installs: 13 |
| Released: 10 Jan 2004 | Last Update: Never | Downloads: 1 |
 Not Supported
|
||
Show Only Active/Certain Usergroups In Member Count
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:
Replace with (if you only want to exclude certain groups) (replace X and Y with the usergroupids to exclude):
or Replace with (if you only want to show members with X posts) (replace W with the number of posts a user must have):
or Replace with (for both of the above):
Find:
Replace with:
Please click install if you use this hack 
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");
PHP Code:
$members = $DB_site->query_first("SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user WHERE usergroupid NOT IN (X,Y)");
PHP Code:
$members = $DB_site->query_first("SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user WHERE posts >= W");
PHP Code:
$members = $DB_site->query_first("SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user WHERE usergroupid NOT IN (X,Y) AND posts >= W");
PHP Code:
// get newest member
$newuser = $DB_site->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members[max]");
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]");
Download
No files for download.