Good one: Prevent non validated users from showing up on newest member line!

[howard007]

How do I prevent non validated (Registered users) from showing up on:
Welcome to our newest member, (Name). The problem I'm having is the low life people who register with bad names and don't get authenticated with the email verification. They shouldn't show up on the newest member list because they are not validated.

Thanks!!

[CyberAlien]

I'm not sure if this will work... open includes/functions_databuild.php, find this: // get newest member
$newuser = $vbulletin->db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members[maxid]");
and replace with this: // get newest member
$newuser = $vbulletin->db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE usergroupid = 2 ORDER BY userid DESC LIMIT 0,1");

[howard007]

Anyone try this? :)

[howard007]

Ok I tried that and I believe it works in that text box. However, once a bogus person registers he also appears on the linve above called Most Users ever online. How do I not show the bogus user until they are validated?

Most users ever online was 46, Yesterday at 08:24 AM.
(USER NAME HERE)

[Kirk Y]

That Replace should be this:
$newuser = $vbulletin->db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE usergroupid != 3 ORDER BY userid DESC LIMIT 0,1");

[howard007]

Thank you!

[howard007]

Some reason the code by cyberalien doesn't seem to be working. non verfied users are appearing on the new user line! How come?