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

✦ Summarize Topic

How-to and Troubleshooting

Last Post by leo 3 years ago

3 Posts

2 Users

2 Reactions

1,936 Views

RSS

leo

(@leo69)

Posts: 18

Eminent Member

Topic starter

Translate ▼

[#6629]

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

Posted : 24/01/2023 2:57 pm

Topic Tags

Asti

(@asti)

Posts: 8260

Illustrious Member Support

Translate ▼

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]

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

Posted : 25/01/2023 1:12 pm

leo reacted

leo

(@leo69)

Posts: 18

Eminent Member

Topic starter

Translate ▼

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

Posted : 25/01/2023 2:20 pm

Asti reacted