1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Trying to determine member number . . .

Discussion in 'Forum Management' started by LuvMeSumZen, Nov 14, 2013.

  1. LuvMeSumZen

    LuvMeSumZen Active Member

    I hope this is the correct forum . . .

    I'm running a giveaway for my members, the winner will be the member who guesses when the 2000th member will join. We only need 10 more members so it could happen tomorrow night when none of our mods or myself are watching. I know the user/member numbers don't match because some spammers never got deleted and other reasons I don't really understand. How would it be possible for me to know who the member is that joins, and actually turns the 'counter' over to 2000 if none of us actually see it?

    If I wake up and there's 2003 members showing on the forum stats I can look at the Newest Members area and count back - is that the best (only?) way?
  2. AndyB

    AndyB Well-Known Member

    Use phpMyAdmin. Look at the xf_user table.

    Just hover your cursor over the members name and in the URL it will show their user_id number.
    Last edited: Nov 14, 2013
  3. Brogan

    Brogan XenForo Moderator Staff Member

    Surely the 2000th member who joins is ID 2000?

    Granted you may have less than 2000 currently registered members due to deleting spammers, etc. but the 2000th member who registered is still ID 2000.
  4. LuvMeSumZen

    LuvMeSumZen Active Member

    Not even close. We moved our database from mybb recently and maybe mybb did not count users the same because I had two admin accounts and a user account (mybb did not have a test permission feature so al us mods had a "user" account) - like I said they do not match.
  5. Digital Doctor

    Digital Doctor Well-Known Member

    AndyB is 1327

    LuvMeSumZen likes this.
  6. LuvMeSumZen

    LuvMeSumZen Active Member

    I don't get any hover-over data over a username. I'm looking for something maybe too "hard data" oriented.
  7. Digital Doctor

    Digital Doctor Well-Known Member

  8. LuvMeSumZen

    LuvMeSumZen Active Member

    Digi Doc - don't think that was the link you meant to give me - it's a member profile with no info
  9. AndyB

    AndyB Well-Known Member

    Which browser are you using?
  10. AndyB

    AndyB Well-Known Member

    I use Firefox. It displays the URL on the bottom when you hover over a link.

    However looking at the forum stats only shows the last person to register. The only way you can see who the 2000th registered member is to use phpMyAdmin.
  11. LuvMeSumZen

    LuvMeSumZen Active Member

    Andy I use Opera and FF both simultaneously. Doesn't work in either one. I will attempt the phpmyadmin but I never seem to be able to accomplish what I'm told to do in there without someone holding my hand. I guess I'm afraid in there.
  12. AndyB

    AndyB Well-Known Member

    It's very important that as an admin you get comfortable using phpmyadmin.

    1) Select the database on the left
    2) Select the xf_user table
    3) Click the user_id tab twice to sort with highest number shown at top
  13. LuvMeSumZen

    LuvMeSumZen Active Member

    That much I know. That's why I've asked numerous members here to tutor me and offered to pay for the privilege - you included. But I know we all have lives and it's catch as catch can. Just remember that about me too. I'll take what I can get with no complaints.
  14. Martok

    Martok Well-Known Member

    As Andy has stated, you'll need to use phpmyadmin to find the 2000th member.

    The OP is correct in that the 2000th user won't necessarily have ID 2000. I moved from phpBB and I have IDs 3 - 54 missing because they were robots (that's how phpBB created them). Also I delete any zero posters or those who don't confirm their registration if they haven't done so after a few months. That also leaves gaps in the ID numbers.
  15. CyclingTribe

    CyclingTribe Well-Known Member

    If new registrations are growing at a slow pace I suspect this will be the easiest way for you to approach it (especially if you're not comfortable with phpmyadmin).

    Just go to the newest registrations and work back. (y)
  16. digitalpoint

    digitalpoint Well-Known Member

    This query will do it.

    mysql> SELECT user_id, username, DATE_FORMAT(FROM_UNIXTIME(register_date), "%b %e, %Y - %H:%i:%s") AS register_date FROM xf_user ORDER BY user_id LIMIT 2000, 1;
    | user_id | username | register_date          |
    |    2191 | samuboy  | Nov 5, 2004 - 08:34:01 |
    1 row in set (0.01 sec)

Share This Page