Show comment number per author per day

Question

Is this possible? I've never seen it used, but I need it... I want to show for each author (if they are logged in) on their own profile page, the amount of comments they have posted today. If the day passes by, than the counter has to be 0 and the comment counter has to start again.

Answer 1

You can try this query that counts user comments by using the user_id field in the comments table as a filter:

function count_user_comments_today( $uid ){
    global $wpdb;
    $today = date('Y-m-d');
    $tomorrow = date('Y-m-d', time() + 86400);
    $count = $wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM {$wpdb->comments} WHERE user_id = %d  AND comment_date >= %s  AND comment_date < %s ", $uid, $today, $tomorrow  ));
    return $count;
}

where we use PHP to give the current date and we don't use any SQL date functions on each row.

You could also consider using the WP_Comment_Query class if you are looking for a more native solution.

Usage:

You can use it like this for the current logged in user:

global $current_user;
get_currentuserinfo();
echo count_user_comments_today( $current_user->ID );

and for the current author:

echo count_user_comments_today( get_the_author_meta('ID') );

in the loop in the template page author.php.

Outside the loop in author.php you can use:

global $wp_query;
$curauth = $wp_query->get_queried_object();
echo count_user_comments_today( $curauth->ID );

for the current author.

Answer 2

Yes it's definitely possible. Refer to http://codex.wordpress.org/Function_Reference/get_comment, you'll need to get the current server time in UNIX format and then convert comment_date_gmt from each returned be using a foreach loop

function current_user_comments_today() {
 global $comment;
 global $current_user;
 get_currentuserinfo();
 $all_user_comments = get_comments( array( 'comment_author_email' => $current_user-> user_email) );
 $today = strtotime('today GMT'); 
 $tomorrow = strtotime('today +1 GMT'); 
 $comment_count = 0;
 foreach ( $all_user_comments as $key => $comment ) {
    $comment_time = strtotime( $comment['comment_date_gmt'] );
    if ( $comment_time > $tomorrow && $comment_time < $today ) {
      $comment_count++;
    } else {
      continue;
    }
 }
 return $comment_count; 
}

Answer 3

I don't know of a way to directly pull this query with Core functions, but the SQL is simple.

$sql = "SELECT COUNT(comment_ID) 
        FROM {$wpdb->comments} 
        WHERE comment_author = 'admin' 
        AND DATE(comment_date) = FROM_UNIXTIME('".time()."')";
$a = $wpdb->get_var($sql);

You can alternately use something like AND DATE(comment_date) = FROM_UNIXTIME('".time()."')"; to pick out any particular date.