Announcement

Collapse
No announcement yet.

How can i find the 1.000.000th post on my forum?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How can i find the 1.000.000th post on my forum?

    Hello,

    I had a contest on my forum but i couldn't find the winner. I want to find who has the owner of 1.000.000th post on my forum. Post id is greater than 1 million because of deleted posts.

    I used this sql code but i get me wrong result.

    Code:
    SELECT * FROM post ORDER BY postid LIMIT 1000000 , 1
    This code gets me a message that posted 12 days ago(ID is 1.063.664). But on my forumhome statistics, today i passed 1 million.

    So, i'm confused, how can i solve this and give the winner's prize?

  • #2
    There is no way to determine what post it is exactly.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API

    Comment

    Loading...
    Working...
    X