Find user profile by its number

Wouldn't you like to know who your 500th member was? Your 1,000th member? Your 100,000th one (if you have that much! )?
With this hack, you can with ultra-ease!

To install this huge hack, open member.php and add this bit of code:

[high]  // "Find user profile by its number" hack by FireFly -->
  if (isset($number)) {
    $getuserid=$DB_site->query_first("SELECT userid FROM user ORDER BY joindate LIMIT ".(intval($number)-1).",1");
    $userid=$getuserid[userid];
  }
  // <-- End "Find user profile by its number" hack by FireFly[/high]

right before this line:

  if ($userid=="" and $username!="") {

and you're done!

Now, to find your 100th member, just go to this link (with your forum address, of course):
https://vborg.vbsupport.ru/member.ph...nfo&number=100

Have fun.

[Admin]

DarkReaper, that's actually why I created this hack in the first place:
https://vborg.vbsupport.ru/showthrea...threadid=34175

[Lesane]

Great Hack, Thnx.

[Bedhead]

Originally posted by Lucky
Is there anyway that you could incorporate this hack into the admin cp so that all you would just have to do is type in a number for example 69 and it would find the 69th member?
This would be even better.

Let me know.

Is this possible?

TIA

[Lionel]

... taht I think I am done, you come up with something else to good to resist... leased:

[Lucky]

Right on.

I'll be waiting!

[nafae]

*bump* any info about a form-based version? :?:

[Jawelin]

... and if I would retrieve the ordinal number of a specific user ?

I think I should retrieve his joindate and count the number of the user less or equal.
Is it right ?
Chen, do you think that info on welcome/forumhome should load too heavly the DB ?
Thanks