How do i know who has made the 100,000 post?
 

My forum is close to reaching 100,000 posts. i'm wondering how i will be able to determine who the member is who has made the 100,000 post? Is there a hack or anything which would let me know.

an sql query would do the trick:

[sql]SELECT username
FROM post
ORDER BY dateline ASC
LIMIT 100000,1[/sql]

thanks mate

tht didn't actually do anything it just said:

Your SQL-query has been executed successfully

SQL-query : [Edit] [Explain SQL] [Create PHP Code]
SELECT username
FROM post
ORDER BY dateline ASC
LIMIT 100000 , 1

Make sure you have the semi colon on the end :)

- miSt

Your SQL-query has been executed successfully

well if you don't hav 100000 posts right now it wouldn't show anything :)

oh that will be why then. Thanks a gain for the quick reply