Not show users name as latest registered member until....

[Gutspiller]

after their email, ip addie has been confirmed that they are not banned.

This would be a very useful hack to me as I have a few stirring up some trouble.

Can somebody look into this? My users and I would be very greatful.

Thanks.

[TWTCommish]

You mean someone who's followed the link in the confirmation email, basically?

[TWTCommish]

Alright, if you're referring to people who haven't activated their account via the email link yet, try this:

Open index.php and find this:

$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");

Replace it with this:

$getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE usergroupid != 3 ORDER BY joindate DESC LIMIT 1");

There ya go.

[Joshua Clinard]

Would this work for any usergroup, I.E. newest moderator?

[TWTCommish]

Nope...but, then again, how often do you make a member who just registered a Moderator? I was just going for a quick-as-heck fix for this guy.

[Joshua Clinard]

Actaully, not very often, but we do have a "Respected Members" usergroup that we add someone to quite often, and I would like to be able to do this. By the way, where have you been? You posted quite a bit on my forum for a little while, but then left.

[TWTCommish]

I don't know that that would interfere...I think it'd be okay. It should display the most recent member who isn't still pending via the email link. Are you saying you want a simple line of code to display the most recent member of a certain usergroup, INSTEAD of the most recent member, period?

[Joshua Clinard]

Yup, that's what I am saying. Do you think you could write a hack for that?

[TWTCommish]

Should be real, real easy. What usergroupid would it involve? That's all I really need to know.

[Joshua Clinard]

Great! The usergroup ID is 8.