vb.org Archive - More "Realistic" Member Count on Forumhome

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - More "Realistic" Member Count on Forumhome (https://vborg.vbsupport.ru/showthread.php?t=59978)

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] :)

so u will appear to have less members than you do cos lets admit it our forums probally have not even a half of members that are active

Yep thats about right :)

Nice work Mr Lee :)

Satan

I have a 70% activity rate which isn't bad. I'd like to exclude users awaiting e-mails, as they basically can do nothing on my site. Thanks for this!

I would install this , but with only 318 members .. and probably only 25% of them are active ... well it dont look too good lol.

But if i manage to get lots more brides2be i will consider this :)

fine, but too "realistic" for me ... ;)

Quote:

Originally Posted by NTLDR

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.

Basing it on X Posts in X time wouldn't be very efficent, especially if you have alot of members and alot of posts. Basing it on say total posts and the last activity is easily doable though (replacing X with the total posts) this would get all users with X posts that have visted in the past week:

PHP Code:


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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (13)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01093 seconds Memory Usage 1,772KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (13)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: