PDA

View Full Version : Dont want Users awaiting moderation to be welcomed


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


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


Change that line to: (the change is highlighted)


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


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.