[Mini-Release 2.x.x:] Dont show unmoderated users under "the newest user"

[Stasik]

Hello all!

Many people asked me to do a project. Here it is! ;)
This hack allows you not to show unmoderated users in "the newest member" line on your vb page.

For: vb 2.x.x

To change: edit 1 file

Instructions: in txt right here.

You will get support in this post.

There are 2 versions in text file. 1 version (written by me) will not count the unmoderated users in "Total Members", 2nd (written by Firefly) will count them too

(C)2001 by Stasik the hack cant be edited or destrbuted without copyright notice.

[Stasik]

i have fixed it now....

[Admin]

It's still not right.

It will count only users that are not in usergroups 3 and 4.

[Stasik]

wait...... ups

[Admin]

This is what you need:
Replace
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=$numbersmembers['users'];
with
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users FROM user');
$numbermembers=$numbersmembers['users'];
$numbersmembers=$DB_site->query_first('SELECT MAX(userid) AS max FROM user WHERE usergroupid<>3 AND usergroupid<>4');
I think that'll work.

[Stasik]

add second version to txt file