How-to and Troubleshooting
3
Posts
2
Users
2
Likes
524
Views
Jan 24, 2023 10:57 am
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
Jan 25, 2023 9:12 am
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]
Jan 25, 2023 10:20 am
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
