Announcement

Collapse
No announcement yet.

Check users posts in a certain time period

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Check users posts in a certain time period

    I am thinking to raffle off something and the winner will be whoever posted the most within the month I determine. Is there a way to check who has the most posts for the month or do I need an addon?

  • #2
    Anyone know? I just started a raffle so I am hoping I can find out who has the most posts within the next two months.

    Comment


    • #3
      Use phpmyadmin. Select the post table. Enter this SQL

      Code:
      SELECT userid, COUNT( userid ) AS total
      FROM `post`
      WHERE dateline > '1275350400'
      AND dateline < '1277856000'
      GROUP BY userid
      ORDER BY total DESC
      LIMIT 0 , 30
      In this example I selected the month of June 2010.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X