vb.org Archive - Dont want Users awaiting moderation to be welcomed

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

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Dont want Users awaiting moderation to be welcomed (https://vborg.vbsupport.ru/showthread.php?t=33368)

tkeil69575

12-19-2001 09:19 PM

Hi,

I have my board setup so that when someone new registers the are added to "users awaiting moderation". However as soon as they register the are welcomed on the index.php - but technically the are members yet because I havent activated their membership.

How must I change the index.php so that they

a) will not be welcomed and
b) are not added to the total number of member?

Any help much appreciated :)

greetings
Tina

bira	12-20-2001 06:37 AM

Open index.php and find (around about line 38):

Code:

$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');

Change that line to: (the change is highlighted)

Code:

$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user [high]WHERE usergroupid!=3[/high]');

This will ignore users who are in the 'Users Awaiting Email Confirmation' usergroup and will not include them in neither the 'Welcome to our newest member' nor in the total number of members.

All times are GMT. The time now is 08:57 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00913 seconds Memory Usage 1,707KB 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 (2)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: