Dont want Users awaiting moderation to be welcomed

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]

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