Get users’ received votes count

Hi, thanks!
That would be great! I’m stuck and cannot retrieve received votes across all of one user’s submissions. I’m starting with learning. Is the table wp_totalcontest_votes existing originally but just empty and all data then within table wp_totalcontest_log?
I appreciate any help 🙂

Thanks, that helped! Got it to work 🙂

function get_total_votes_count($user_id) {
    global $wpdb;
    
    // Query to retrieve the submissions of the given user
    $query = "SELECT p.ID
              FROM {$wpdb->posts} p
              INNER JOIN {$wpdb->postmeta} pm ON p.ID = pm.post_id
              WHERE p.post_author = %d
                AND p.post_type = 'contest_submission'
                AND pm.meta_key = '_tc_votes'";
    
    $submissions = $wpdb->get_col($wpdb->prepare($query, $user_id));
    
    $total_votes_count = 0;
    
    // Calculate the sum of votes for each submission
    foreach ($submissions as $submission_id) {
        $votes_count = get_post_meta($submission_id, '_tc_votes', true);
        $total_votes_count += intval($votes_count);
    }
    
    return $total_votes_count;
}

• This reply was modified 2 years, 8 months ago by jase347. Reason: marked as resolved