How to know who made the specific no. of post?

Discussion in 'Forum Management' started by glitto, May 31, 2009.

0
  1. #1
    Hi,

    On my forum I want to set a prize that whoever will make the specific no. of post (let say 10,000th post) he will win $10.

    But I don't know how to know WHO made the 10,000th post?

    Is there any way to know this?

    Thanks
     
    glitto, May 31, 2009 IP
  2. Vekseid

    Vekseid Peon

    Messages:
    124
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Vekseid, May 31, 2009 IP
  3. NickR25

    NickR25 Peon

    Messages:
    394
    Likes Received:
    18
    Best Answers:
    0
    Trophy Points:
    0
    #3
    That won't work because you have to take into consideration posts you have deleted. If you have posts 1-5 but deleted 6-10, the next post made is still going to be 11 even though there is no longer a post with ID 6. This screws things up, so:

    Try to run this query in phpMyAdmin
    SELECT * FROM `vb_post` ORDER BY `postid` ASC LIMIT 9999,1
    Code (markup):
    (if your prefix is different than vb, change it accordingly)

    We used 9999 since the limits start at 0 so considering 0 = 1 you have 9999 as 10000.

    Take the resulting post ID and append it to the appropriate URL: showpost.php?p=POSTID
     
    NickR25, Jun 1, 2009 IP
  4. Vekseid

    Vekseid Peon

    Messages:
    124
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #4
    The problem is that changes. Someone who made the 10,000th post at one moment by that metric may not be the next.
     
    Vekseid, Jun 2, 2009 IP