Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter vadik052

    (@vadik052)

    count likes to user post

    if(!function_exists('get_count_ratings_users_for_your_posts')) {
    	function get_count_ratings_users_for_your_posts($user_id) {
    		global $wpdb;
    		$ratings_users = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts LEFT JOIN $wpdb->ratings ON $wpdb->posts.ID = $wpdb->ratings.rating_postid WHERE $wpdb->posts.post_type = 'post' AND $wpdb->posts.post_status = 'publish' AND $wpdb->posts.post_author = '".$user_id."' AND $wpdb->ratings.rating_id != '0'");
    		return $ratings_users;
    	}
    }

    Thread Starter vadik052

    (@vadik052)

    count user likes:

    if(!function_exists('get_count_ratings_user')) {
    	function get_count_ratings_user($user_id) {
    		global $wpdb;
    		$ratings_users = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->ratings WHERE rating_userid = '".$user_id."'");
    		return $ratings_users;
    	}
    }

    Thread Starter vadik052

    (@vadik052)

    Hello.
    I do not know what I’m doing wrong, but the shortcode “[global: manage]” does not work (caused through the pages and WordPress code – “echo do_shortcode ( ‘[global: manage]’);”). But I’m not sure that this will help me all the shortcode as the user should not only view their lists, but also have the opportunity to unsubscribe or subscribe to selected. Yes, select the plug-in settings page subscription / unsubscribe, and then create a link to go seems like a good idea, but I need to display this list at the specified location (in front of him and goes after information). This is a problem that occurs to me. I rummaged through a pile of this plugin file, but did not find anything that could help me.
    Thanks again.

Viewing 3 replies - 1 through 3 (of 3 total)