Who made the 50,000th post?

[renee1]

I would like to know how I could know who made a post. Example being who made the 50,000th post to the forums.

any ideas? :o

[eva01_]

<a href="http://yoursite/xxx/showpost.php?p=#" target="_blank">http://yoursite/xxx/showpost.php?p=#</a>

[renee1]

Thanks
this is a true blonde moment
:o :nervous: :o

[eva01_]

i could always try and make it implemented into the admincp maybe that will be my spring break trial at hacks :P

[AN-net]

http://yoursite/xxx/showpost.php?p=#
not always true, as some forums may not count towards post count and also deleted posts. so that is completely true;)

[eva01_]

curse people and shooting down my moments of glory *cries* T_T

[AN-net]

curse people and shooting down my moments of glory *cries* T_T
sry i didnt mean too, i just wanted to make sure the correct information was provided

[Deaths]

Thanks
this is a true blonde moment
:o :nervous: :o
Never ditch the blonde! EVER!

[Imperial Fritz]

Totally not working for a board which originate as phpbb, was imported to vb, then imported back to phpbb and then imported again to vb. This over the course of more than two years. My postids now start at something like 70,000 and the board only has some 60,000 posts :D

[Tekton]

$the_post = $DB_site->query("SELECT * FROM ".TABLE_PREFIX."post ORDER BY dateline ASC LIMIT 49999, 1");
}


That may not work as-is. I don't have anything to look at correct syntax now. Wouldn't dateline be the best thing to go for though? As far as I know, editing the post doesn't change the dateline...

Also, that 49999 might have to be at 50000 since LIMIT could start counting at one.