wpDiscuz - WordPress Comment Plugin
Adding a shortcode ...
 
Share:
Notifications
Clear all

Question [Solved] Adding a shortcode to display the number of likes of a user's comments

3 Posts
2 Users
2 Likes
46 Views
Posts: 3
Topic starter
(@mandegar266)
Active Member
Joined: 1 week ago

Hello
Good time everyone
I need a code that by placing it in the function of the template, I can display the total number of likes and dislikes of a user by placing a short code.
Thank you for helping me

2 Replies
Asti
Posts: 5779
 Asti
Support
(@asti)
Illustrious Member
Joined: 5 years ago

Hi @mandegar266,

Add this code to the functions.php file: 

add_shortcode('wpdiscuz_likes', 'wpdiscuz_current_user_likes');
function wpdiscuz_current_user_likes(){
    global $wpdb,$user_ID;
    if(!$user_ID){
        return;
    }    $like_count = (int)$wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM `{$wpdb->prefix}wc_users_voted` WHERE `vote_type` = 1 AND `user_id` = %d", $user_ID));
    $dislike_count = (int)$wpdb->get_var( $wpdb->prepare("SELECT COUNT(*) FROM `{$wpdb->prefix}wc_users_voted` WHERE `vote_type` = -1 AND `user_id` = %d", $user_ID));    echo 'Like Count - ' . $like_count .' Dislike Count - ' . $dislike_count;}

 

Then use the following shortcode: 

[wpdiscuz_likes]
Posts: 3
Topic starter
(@mandegar266)
Active Member
Joined: 1 week ago

I am extremely grateful for your guidance
I have worked with php language to some extent, but I am not familiar with WordPress and Discase functions, and this code of yours was very useful for me.
I wish you the best from Iran

Share: