Hi,
I'm trying to engage the members more in posting to facilitate community involvement. And I got this Idea but don't know how to achieve it.
My forum has about 980,000 posts and I want to run a contest where basically the members have to post and the one member who posts the post number 1 million gets the price. The question is how to identify which member posts the post number 1 million? Ideas?
That's one way to encourage spamming if you ask me
yoururlhere/index.php?msg=1000000
Quote from: Illori on June 04, 2019, 05:05:31 PM
yoururlhere/index.php?msg=1000000
Thanks, but it isn't working. This way shows somehow a fixed post ID and is giving me a post, even though my forum doesn't have yet that number of posts. I think it counts the deleted/removed posts too.
Custom code that checks when x post reached contact you with an Email or whatever about who made the post, etc.
You can view smf_messages table in phpmyadmin, sort id_msg so latest is first (click column title twice), that will give you id_member and poster_name of member who made the post.
Quote from: aksal on June 04, 2019, 06:52:18 PM
Quote from: Illori on June 04, 2019, 05:05:31 PM
yoururlhere/index.php?msg=1000000
Thanks, but it isn't working. This way shows somehow a fixed post ID and is giving me a post, even though my forum doesn't have yet that number of posts. I think it counts the deleted/removed posts too.
yes it does count deleted messages. there is no other way to get what you want. even looking in the database may not get you the correct message if you are looking at the id.
Quote from: Looking on June 04, 2019, 06:54:14 PM
Custom code that checks when x post reached contact you with an Email or whatever about who made the post, etc.
You are my man, buddy. I'll contact you when ready to get this done.
Thanks all you guys for the support.