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

XF 1.4 Approaching 1 mil posts, how can I find out 1 millionth post?

Discussion in 'XenForo Questions and Support' started by surfsup, Mar 5, 2015.

  1. surfsup

    surfsup Well-Known Member

    Right now the last post direct url is; 967763 but our messages from sidebar stats says
    How can I find out which post would be the 1,000,000 post since they dont match up?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The post ID doesn't necessarily match the count due to deleted posts.

    The easiest way is to check in phpMyAdmin but even then, what may be the 1 millionth post at that particular time, won't necessarily always be it, if posts are subsequently deleted.

    It's really a pointless thing to do.
  3. surfsup

    surfsup Well-Known Member

    Not when you want to give away a secret prize ;)
    BoostN likes this.
  4. Harpers Tate

    Harpers Tate Well-Known Member

    The easiest thing, I guess, is for you to unilaterally decide that the millionth post (prize winner) will be the post that has the post ID =1 million. And then look for that. In other words your millionth post count will include posts no longer present because of deletions.

    Failing that, as you approach your milestone, calculate the difference (= number of deleted posts); keep it up to date with any new deletions, and look for post ID {1 million + difference}.

    The latter will be harder for a would-be prizewinner user to predict with any accuracy.
    surfsup likes this.
  5. Fred.

    Fred. Well-Known Member

    I would just use the post ID and tell your members deleted posts are also counted.
    It's still the 1 millionth post!

    Then it's easy to prove who made that post.
    The only thing is that the stats on your forum will show less posts because they are deleted.
    surfsup likes this.

Share This Page