XF 1.5 How to find the poster of a special number of post

[teletubbi]

I am looking for a way to find the user who posted the x post in our forum.
We are close to 1.111.111 posts. I would like to give this user who wrote the last one to fulfill this number a special announcement.

Problem is that we have some parts in our forum where posts are not counting. So the DB and the history of the forum shown at frontend are not the same. In DB we have more than 1.5 million post. Including soft deleted.

Is there any way to get what i want?

 

[Paul B]

It's not really possible as it's a moving target.

What may be the 1 millionth visible post now may not be in an hour if posts are deleted, merged, etc.

All you can really do is go off the post ID, for example: https://xenforo.com/community/posts/1000000

 

[teletubbi]

That did the trick.

Thanks a lot.

 

[teletubbi]

It doesn't work.
Brings me to a post from November 2015.

 

[Jeremy P]

It doesn't work.
Brings me to a post from November 2015.

It's not really possible as it's a moving target.

What may be the 1 millionth visible post now may not be in an hour if posts are deleted, merged, etc.

 

[teletubbi]

I understand it.
Just was curious about the try yesterday with 1000000 post brought me to an actual post.
So i thought this might be a good approach.

But today with the number 1111111 shows up an old post. Between the try yesterday and today no posts was deleted, merged or altered in any way. Because i am ahead 6 hours of my moderators due different time zones.

Anyway. Was just an idea to mention a special amount of posts.
Nothing what is elementary needed for life.