Announcement

Collapse
No announcement yet.

Post Counts

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

  • Chris Etc
    replied
    Thanks, I'll try that.

    Leave a comment:


  • Jose Amaral Rego
    replied
    Code:
    SELECT count( * )AS num, username 
    FROM post
    WHERE 
    dateline >= unix_timestamp( '2007-06-01 12:00:00' ) AND 
    dateline <= unix_timestamp( '2007-07-22 23:59:59' ) 
    GROUP BY username
    ORDER BY num DES
    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:


  • Chris Etc
    started a topic Post Counts

    Post Counts

    Is there a way to determine post counts by user for a determined amount of time? Like all post counts per individual user for the last year for example?
Loading...
Working...
X