No announcement yet.

Changing Newmembers displayed from "Users Awaiting Confirmation" to "Registered"

  • Filter
  • Time
  • Show
Clear All
new posts

  • Changing Newmembers displayed from "Users Awaiting Confirmation" to "Registered"

    My site's homepage is showing as the newest member the most recent person to begin the registration process (user group is "Users Awaiting Email Confirmation"). However, there are a number of steps to getting registered on my site:

    - e-mail verification (changes your user group to "Validated Users Awaiting Moderation");
    - payment of a nominal contribution, and finally
    - approval by an administrator ("moderation")

    Only after you are moderated (approved) are you in the "Registered" user group, and thereby properly registered.

    How do I modify the code to display only the most recent member to join the "Registered" user group?

    The existing code is:

    Welcome to our newest member, <a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$newuserid">$newusername</a>

    Thank you!

  • #2
    This requires hacking. You can make a request over at
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography

    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    • #3
      That's fairly easy to do:

      find this section in index.php:
      // get newest member
      $getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbersmembers[max]");

      replace it with this:

      // get newest member
      $numbercustom = $DB_site->query_first("SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE usergroupid=2");
      // 2 is the usergroupid of "registered", isn't it? Replace it with the correct one if it isn't.
      $getnewestusers=$DB_site->query_first("SELECT userid,username FROM user WHERE userid=$numbercustom[max]");


      Related Topics