Advertisement:

Author Topic: Run a community contest  (Read 1311 times)

Offline aksal

  • Semi-Newbie
  • *
  • Posts: 48
    • Zerion.net on Facebook
    • @zerionnet on Twitter
    • Zeriyt - Forumi Shqiptar - Zerion
Run a community contest
« on: June 04, 2019, 04:40:50 PM »
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?

Offline SychO

  • Lead Customizer
  • SMF Hero
  • *
  • Posts: 1,523
  • Gender: Male
    • SychO9 on GitHub
    • SychO
Re: Run a community contest
« Reply #1 on: June 04, 2019, 05:01:13 PM »
That's one way to encourage spamming if you ask me

Imazighen

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,280
Re: Run a community contest
« Reply #2 on: June 04, 2019, 05:05:31 PM »
yoururlhere/index.php?msg=1000000

Offline aksal

  • Semi-Newbie
  • *
  • Posts: 48
    • Zerion.net on Facebook
    • @zerionnet on Twitter
    • Zeriyt - Forumi Shqiptar - Zerion
Re: Run a community contest
« Reply #3 on: June 04, 2019, 06:52:18 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.

Offline Looking

  • SMF Hero
  • ******
  • Posts: 2,371
  • SMF Customization
    • jeanborde on Facebook
    • SMF Custom Themes & Custom Coding
Re: Run a community contest
« Reply #4 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.

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 9,299
Re: Run a community contest
« Reply #5 on: June 04, 2019, 07:09:11 PM »
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.

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,280
Re: Run a community contest
« Reply #6 on: June 04, 2019, 07:39:51 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.

Offline aksal

  • Semi-Newbie
  • *
  • Posts: 48
    • Zerion.net on Facebook
    • @zerionnet on Twitter
    • Zeriyt - Forumi Shqiptar - Zerion
Re: Run a community contest
« Reply #7 on: June 05, 2019, 10:19:56 AM »
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.