Announcement

Collapse
No announcement yet.

Posts per Week

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

  • JD45
    replied
    Could this be moved to suggestions? A more full featured admin search would be nice.

    Leave a comment:


  • my3shadows
    replied
    Thank you! You have no idea how much easier you just made my day!

    Leave a comment:


  • Jake Bunce
    replied
    Code:
    SELECT COUNT(postid) AS count, user.username
    FROM post
    LEFT JOIN user ON (user.userid = post.userid)
    [color=blue]LEFT JOIN thread ON (thread.threadid = post.threadid)[/color]
    WHERE [color=blue]post.[/color]dateline > UNIX_TIMESTAMP('[color=red]2004-01-01[/color]') AND [color=blue]post.[/color]dateline < UNIX_TIMESTAMP('[color=red]2005-01-01[/color]')
    [color=blue]AND forumid NOT IN (X,Y,Z)[/color]
    GROUP BY post.username
    ORDER BY count
    DESC
    I added the blue code. X,Y,Z is a comma-separated list of excluded forumids.

    Leave a comment:


  • my3shadows
    replied
    What would I need to add to this sql statement to exclude certain forum ids? I want to do what the original poster is doing, except posts in certain forums don't count toward the prizes.

    Thanks!

    Rachael

    Leave a comment:


  • Jake Bunce
    replied
    This query should work:

    Code:
    SELECT COUNT(postid) AS count, user.username
    FROM post
    LEFT JOIN user ON (user.userid = post.userid)
    WHERE dateline > UNIX_TIMESTAMP('[color=red]2004-01-01[/color]') AND dateline < UNIX_TIMESTAMP('[color=red]2005-01-01[/color]')
    GROUP BY post.username
    ORDER BY count
    DESC
    Change the dates appropriately. This will return a list of usernames and post counts for the time period specified.

    You can run this query in your:

    Admin CP -> Import & Maintenance -> Execute SQL Query

    You must have permission to execute queries in your includes/config.php file:

    // ****** USERS WITH QUERY RUNNING PERMISSIONS ******
    // The users specified here will be allowed to run queries from the control panel.
    // See the above entries for more information on the format.
    // Please note that the ability to run queries is quite powerful. You may wish
    // to remove all user IDs from this list for security reasons.
    $canrunqueries = '';

    Leave a comment:


  • Lats
    replied
    Check this thread...

    http://www.vbulletin.com/forum/showthread.php?t=111997

    Leave a comment:


  • Wistow
    started a topic Posts per Week

    Posts per Week

    Hi

    Is there any way I can see which user made the most posts in a given date range? i am planning on giving domain names away every week to the highest posters, and need to know this information.

    I have checked in the admincp under stats but it doesn't seem to show this info, only the number of posts. (not who posted)

    Kind Regards,

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