Not Show New Member Name Right Away

[Erwin]

I agree you can't ban AOL's IPs (though I wish I can sometimes).

Unfortunately, AOL let's their users have multiple email addresses.

Report him to abuse@aol.com

Install hellban, or something similar to ban him.

I don't have time to look at this hack unfortunately.

[Diva]

Okay. Thank you very much for showing me the hack. That's half the battle. Take care.

[Erwin]

Try this:

Change:

PHP Code:

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid']; 


to this:

PHP Code:

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username,usergroupid FROM user WHERE userid=$numbersmembers[max] AND usergroupid=2 ORDER BY userid DESC");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid']; 


It should work. Xenon forgot to make the query look up usergroupid as well.

[Diva]

Is this in the index.php?

[Erwin]

Refresh the screen, I made a typo.

[Erwin]

Yes, it's in the index.php - it should work - only registered members will show up as newest members.

[Diva]

Sigh... Nope. Now no one shows up.... My luck, eh?

[Erwin]

Try this:

PHP Code:

// get newest member
$getnewestusers=$DB_site->query_first("SELECT userid,username,usergroupid FROM user WHERE userid<=$numbersmembers[max] AND usergroupid=2 ORDER BY userid DESC");
$newusername=$getnewestusers['username'];
$newuserid=$getnewestusers['userid']; 


[Diva]

AAAAA!!!!!! You RULE, Erwin!!!!! Now all I need is the whosonline part and he can sign up til the cows come home!!!

***BIG HUG***

[Erwin]

Who's Online part in index.php or in online.php? Also, credit goes to Xenon - I just fixed up his small mistake.