function likebtn_admin_votes() { global $likebtn_page_sizes; global $wpdb; wp_enqueue_script('jquery-ui-dialog'); wp_enqueue_style("wp-jquery-ui-dialog"); $query_parameters = array(); $likebtn_entities = _likebtn_get_entities(true); // Custom item $likebtn_entities[LIKEBTN_ENTITY_CUSTOM_ITEM] = __('Custom item'); // Multisite - available for super admin only $blogs = array(); $blog_list = array(); $votes_blog_id = ''; $prefix_prepared = $wpdb->prefix; if (is_multisite() && is_super_admin()) { global $blog_id; $blog_list = $wpdb->get_results("\n SELECT blog_id, domain\n FROM {$wpdb->blogs}\n WHERE site_id = '{$wpdb->siteid}'\n AND spam = '0'\n AND deleted = '0'\n AND archived = '0'\n ORDER BY blog_id\n "); // Place current blog on the first place foreach ($blog_list as $blog) { if ($blog->blog_id == $blog_id) { $blogs["{$blog->blog_id}"] = get_blog_option($blog->blog_id, 'blogname') . ' - ' . $blog->domain; break; } } foreach ($blog_list as $blog) { if ($blog->blog_id != $blog_id) { $blogs["{$blog->blog_id}"] = get_blog_option($blog->blog_id, 'blogname') . ' - ' . $blog->domain; } } // Add all $blogs['all'] = __('All Sites'); // Determine selected blog id if (isset($_GET['likebtn_blog_id'])) { if ($_GET['likebtn_blog_id'] == 'all') { $votes_blog_id = $_GET['likebtn_blog_id']; } else { // Check if blog with ID exists foreach ($blog_list as $blog) { if ($blog->blog_id == (int) $_GET['likebtn_blog_id']) { $votes_blog_id = (int) $_GET['likebtn_blog_id']; break; } } } } // Prepare prefix if this is not main blog if ($blog_id != 1) { $prefix_prepared = substr($wpdb->prefix, 0, strlen($wpdb->prefix) - strlen($blog_id) - 1); } } $entity_name = ''; if (!empty($_GET['likebtn_entity_name'])) { $entity_name = $_GET['likebtn_entity_name']; } $page_size = LIKEBTN_STATISTIC_PAGE_SIZE; if (isset($_GET['likebtn_page_size'])) { $page_size = LIKEBTN_STATISTIC_PAGE_SIZE; } $post_id = ''; if (isset($_GET['likebtn_post_id'])) { $post_id = trim(stripcslashes($_GET['likebtn_post_id'])); } $user_id = ''; if (isset($_GET['likebtn_user_id'])) { $user_id = trim(stripcslashes($_GET['likebtn_user_id'])); } $ip = ''; if (isset($_GET['likebtn_ip'])) { $ip = trim($_GET['likebtn_ip']); } $vote_type = ''; if (isset($_GET['likebtn_vote_type'])) { $vote_type = trim($_GET['likebtn_vote_type']); } // pagination require_once dirname(__FILE__) . '/likebtn_like_button_pagination.class.php'; $pagination_target = "admin.php?page=likebtn_votes"; foreach ($_GET as $get_parameter => $get_value) { $pagination_target .= '&' . $get_parameter . '=' . stripcslashes($get_value); } $p = new LikeBtnLikeButtonPagination(); $p->limit($page_size); // Limit entries per page $p->target($pagination_target); //$p->currentPage(); // Gets and validates the current page $p->prevLabel(__('Previous', LIKEBTN_I18N_DOMAIN)); $p->nextLabel(__('Next', LIKEBTN_I18N_DOMAIN)); if (!isset($_GET['paging'])) { $p->page = 1; } else { $p->page = $_GET['paging']; } $query_select = ''; $query_join = ''; // query for limit paging $query_limit = "LIMIT " . ($p->page - 1) * $p->limit . ", " . $p->limit; // query parameters $query_where = ''; // Post type and ID if ($entity_name && $post_id && $entity_name != LIKEBTN_ENTITY_CUSTOM_ITEM) { $query_where .= ' AND v.identifier = %s '; $query_parameters[] = $entity_name . '_' . $post_id; } elseif ($entity_name == LIKEBTN_ENTITY_CUSTOM_ITEM && $post_id) { $query_where .= ' AND i.ID is not NULL AND v.identifier = %s '; $query_parameters[] = $post_id; } elseif ($entity_name == LIKEBTN_ENTITY_CUSTOM_ITEM) { $query_where .= ' AND i.ID is not NULL '; } elseif ($entity_name) { $query_where .= ' AND v.identifier LIKE "' . esc_sql($entity_name) . '_%%" '; } elseif ($post_id) { $query_where .= ' AND v.identifier LIKE "%%_%d" '; $query_parameters[] = $post_id; } // Order by $query_orderby = ' ORDER BY created_at DESC '; // User ID if ($user_id) { $query_where .= ' AND v.user_id = %d '; $query_parameters[] = $user_id; } // IP if ($ip) { $query_where .= ' AND v.ip = %s '; $query_parameters[] = $ip; } // Vote type if ($vote_type) { $query_where .= ' AND v.type = %d '; $query_parameters[] = $vote_type; } // For Multisite $query = ''; if ($votes_blog_id && $votes_blog_id != 1 && $votes_blog_id != 'all') { $prefix = "{$prefix_prepared}{$votes_blog_id}_"; $query = _likebtn_get_votes_sql($prefix, $query_where, $query_orderby, $query_limit, 'SQL_CALC_FOUND_ROWS ' . $query_select, $query_join); $query_prepared = $wpdb->prepare($query, $query_parameters); } else { if ($votes_blog_id == 'all') { foreach ($blog_list as $blog) { if ($blog->blog_id == 1) { $prefix = $prefix_prepared; } else { $prefix = "{$prefix_prepared}{$blog->blog_id}_"; } $query_list[] = $wpdb->prepare(_likebtn_get_votes_sql($prefix, $query_where, '', '', $blog->blog_id . ' as blog_id, ' . $query_select, $query_join), $query_parameters); } $query_prepared = ' SELECT SQL_CALC_FOUND_ROWS * from (' . implode(' UNION ', $query_list) . ") query {$query_orderby} {$query_limit} "; } else { $query = _likebtn_get_votes_sql($prefix_prepared, $query_where, $query_orderby, $query_limit, 'SQL_CALC_FOUND_ROWS ' . $query_select, $query_join); if (count($query_parameters)) { $query_prepared = $wpdb->prepare($query, $query_parameters); } else { $query_prepared = $query; } } } // echo "<pre>"; // echo $query; // echo $query_prepared; // echo $wpdb->prepare($query, $query_parameters); // $wpdb->show_errors(); // exit(); $votes = $wpdb->get_results($query_prepared); $total_found = 0; if (isset($votes[0])) { $query_found_rows = "SELECT FOUND_ROWS() as found_rows"; $found_rows = $wpdb->get_results($query_found_rows); $total_found = (int) $found_rows[0]->found_rows; $p->items($total_found); $p->calculate(); // Calculates what to show $p->parameterName('paging'); $p->adjacents(1); // No. of page away from the current page } else { $votes = array(); } $loader = _likebtn_get_public_url() . 'img/ajax_loader_hor.gif'; likebtn_admin_header(); ?> <script type="text/javascript"> var likebtn_msg_ip_info = '<?php _e("IP Info", LIKEBTN_I18N_DOMAIN); ?> '; </script> <div> <a href="javascript:jQuery('#likebtn_no_vts').toggle();void(0);"><?php _e('Do not see votes?', LIKEBTN_I18N_DOMAIN); ?> </a> <div id="likebtn_no_vts"> <p class="description"> ● <?php _e('Votes for Custom items appear in the list after synchronization.', LIKEBTN_I18N_DOMAIN); ?> </p> </div> <br/><br/> <form action="" method="get" id="votes_form" autocomplete="off"> <input type="hidden" name="page" value="likebtn_votes" /> <div class="postbox statistics_filter_container"> <div class="inside"> <label><?php _e('Item Type', LIKEBTN_I18N_DOMAIN); ?> :</label> <select name="likebtn_entity_name" > <option value="">-- <?php _e('Any', LIKEBTN_I18N_DOMAIN); ?> --</option> <?php foreach ($likebtn_entities as $entity_name_value => $entity_title) { ?> <option value="<?php echo $entity_name_value; ?> " <?php selected($entity_name, $entity_name_value); ?> ><?php _e($entity_title, LIKEBTN_I18N_DOMAIN); ?> </option> <?php } ?> </select> <label><?php _e('Item ID', LIKEBTN_I18N_DOMAIN); ?> :</label> <input type="text" name="likebtn_post_id" value="<?php echo htmlspecialchars($post_id); ?> " size="10" /> <br/><br/> <label><?php _e('User ID', LIKEBTN_I18N_DOMAIN); ?> :</label> <input type="text" name="likebtn_user_id" value="<?php echo htmlspecialchars($user_id); ?> " size="10" /> <label><?php _e('IP'); ?> :</label> <input type="text" name="likebtn_ip" value="<?php echo htmlspecialchars($ip); ?> " size="20"/> <label><?php _e('Vote Type', LIKEBTN_I18N_DOMAIN); ?> :</label> <select name="likebtn_vote_type" > <option value="">-- <?php _e('Likes & Dislikes', LIKEBTN_I18N_DOMAIN); ?> --</option> <option value="1" <?php selected((int) $vote_type, 1); ?> ><?php _e('Likes', LIKEBTN_I18N_DOMAIN); ?> </option> <option value="-1" <?php selected((int) $vote_type, -1); ?> ><?php _e('Dislikes', LIKEBTN_I18N_DOMAIN); ?> </option> </select> <input class="button-secondary" type="button" name="reset" value="<?php _e('Reset filter', LIKEBTN_I18N_DOMAIN); ?> " onClick="jQuery('.statistics_filter_container :input[type!=button]').val(''); jQuery('#votes_form').submit();"/> </div> </div> <?php if ($blogs) { ?> <label><?php _e('Site', LIKEBTN_I18N_DOMAIN); ?> :</label> <select name="likebtn_blog_id" > <?php foreach ($blogs as $blog_id_value => $blog_title) { ?> <option value="<?php echo $blog_id_value; ?> " <?php selected($votes_blog_id, $blog_id_value); ?> ><?php echo $blog_title; ?> </option> <?php } ?> </select> <?php } ?> <label><?php _e('Page Size', LIKEBTN_I18N_DOMAIN); ?> :</label> <select name="likebtn_page_size" > <?php foreach ($likebtn_page_sizes as $page_size_value) { ?> <option value="<?php echo $page_size_value; ?> " <?php selected($page_size, $page_size_value); ?> ><?php echo $page_size_value; ?> </option> <?php } ?> </select><br/><br/> <input class="button-primary" type="submit" name="show" value="<?php _e('View', LIKEBTN_I18N_DOMAIN); ?> " /> <?php _e('Votes Found', LIKEBTN_I18N_DOMAIN); ?> : <strong><?php echo $total_found; ?> </strong> </form> <br/> <form method="post" action="" id="votes_actions_form"> <input type="hidden" name="bulk_action" value="" id="stats_bulk_action" /> <?php if (count($votes) && $p->lastpage > 1) { ?> <div class="tablenav"> <div class="tablenav-pages"> <?php echo $p->show(); ?> </div> </div> <?php } ?> <table class="widefat" id="votes_container"> <thead> <tr> <?php /*<th><input type="checkbox" onclick="statisticsItemsCheckbox(this)" value="all" style="margin:0"></th>*/ ?> <?php if ($blogs && $votes_blog_id == 'all') { ?> <th><?php _e('Site'); ?> </th> <?php } ?> <th colspan="2"><?php _e('User', LIKEBTN_I18N_DOMAIN); ?> </th> <th>IP</th> <th><?php _e('Date', LIKEBTN_I18N_DOMAIN); ?> </th> <th><?php _e('Type', LIKEBTN_I18N_DOMAIN); ?> </th> <th><?php _e('Item', LIKEBTN_I18N_DOMAIN); ?> </th> </tr> </thead> <tbody> <?php foreach ($votes as $votes_item) { ?> <?php $entity_info = _likebtn_parse_identifier($votes_item->identifier); $avatar_url = ''; if ($votes_item->user_id) { $avatar_url = _likebtn_get_avatar_url($votes_item->user_id); } $user_url = ''; if ($votes_item->user_id) { $user_url = _likebtn_get_entity_url(LIKEBTN_ENTITY_USER, $votes_item->user_id); } $item_title = ''; $item_url = ''; if ($votes_item->item_id) { $item_title = $votes_item->identifier; $item_url = $votes_item->url; $entity_type_name = __('Custom Item', LIKEBTN_I18N_DOMAIN); } else { if ($entity_info['entity_name'] && $entity_info['entity_id']) { $item_title = _likebtn_get_entity_title($entity_info['entity_name'], $entity_info['entity_id']); $item_title = _likebtn_prepare_title($entity_info['entity_name'], $item_title); $item_url = _likebtn_get_entity_url($entity_info['entity_name'], $entity_info['entity_id'], '', $votes_blog_id); } $entity_type_name = _likebtn_get_entity_name_title($entity_info['entity_name']); } if ((int) $votes_item->type == 1) { $entity_vote_type = 'like'; } else { $entity_vote_type = 'dislike'; } ?> <tr id="vote_<?php echo $votes_item->id; ?> "> <?php /*<td><input type="checkbox" class="item_checkbox" value="<?php echo $votes_item->post_id; ?>" name="item[]" <?php if ($blogs && $votes_item->blog_id != $blog_id): ?>disabled="disabled"<?php endif ?>></td>*/ ?> <?php if ($blogs && $votes_blog_id == 'all') { ?> <td><?php echo get_blog_option($votes_item->blog_id, 'blogname'); ?> </td> <?php } ?> <?php if ($avatar_url) { ?> <td width="32"> <a href="<?php echo $user_url; ?> " target="_blank"><img src="<?php echo $avatar_url; ?> " width="32" height="32" /></a> </td> <?php } ?> <td <?php if (!$avatar_url) { ?> colspan="2"<?php } ?> > <?php if ($votes_item->user_id) { ?> <a href="<?php echo $user_url; ?> " target="_blank"><?php echo _likebtn_get_entity_title(LIKEBTN_ENTITY_USER, $votes_item->user_id); ?> </a> <?php } else { ?> <?php echo __('Anonymous', LIKEBTN_I18N_DOMAIN); ?> <?php } ?> </td> <td><a href="javascript:likebtnIpInfo('<?php echo $votes_item->ip; ?> ');" class="likebtn_ttip" title="<?php _e('View IP info', LIKEBTN_I18N_DOMAIN); ?> "><?php echo $votes_item->ip; ?> </a></td> <td><?php echo date("Y.m.d H:i:s", strtotime($votes_item->created_at)); ?> </td> <td> <img src="<?php echo _likebtn_get_public_url(); ?> img/thumb/<?php echo $entity_vote_type; ?> .png" alt="<?php _e(ucfirst($entity_vote_type), LIKEBTN_I18N_DOMAIN); ?> " title="<?php _e(ucfirst($entity_vote_type), LIKEBTN_I18N_DOMAIN); ?> " class="likebtn_ttip" /> </td> <td><a href="<?php echo $item_url; ?> " target="_blank"><?php echo $item_title; ?> </a> <?php if ($entity_type_name) { ?> — <?php echo $entity_type_name; ?> <?php } ?> </td> </tr> <?php } ?> </tbody> </table> </form> <?php if (count($votes) && $p->lastpage > 1) { ?> <div class="tablenav"> <div class="tablenav-pages"> <?php echo $p->show(); ?> </div> </div> <?php } ?> </div> <div id="likebtn_ip_info" class="likebtn_ip_info hidden"> <div class="likebtn_ip_info_map"></div> <table class="widefat"> <tr> <th><strong>IP</strong></th> <td class="likebtn-ii-ip" width="50%"><img src="<?php echo $loader; ?> " /></td> </tr> <tr> <th><strong><?php _e('Country', LIKEBTN_I18N_DOMAIN); ?> </strong></th> <td class="likebtn-ii-country"><img src="<?php echo $loader; ?> " /></td> </tr> <tr> <th><strong><?php _e('City', LIKEBTN_I18N_DOMAIN); ?> </strong></th> <td class="likebtn-ii-city"><img src="<?php echo $loader; ?> " /></td> </tr> <tr> <th><strong><?php _e('Lat/Long', LIKEBTN_I18N_DOMAIN); ?> </strong></th> <td class="likebtn-ii-latlon"><img src="<?php echo $loader; ?> " /></td> </tr> <tr> <th><strong><?php _e('Postal Code', LIKEBTN_I18N_DOMAIN); ?> </strong></th> <td class="likebtn-ii-postal"><img src="<?php echo $loader; ?> " /></td> </tr> <tr> <th><strong><?php _e('Network', LIKEBTN_I18N_DOMAIN); ?> </strong></th> <td class="likebtn-ii-network"><img src="<?php echo $loader; ?> " /></td> </tr> <tr> <th><strong><?php _e('Hostname', LIKEBTN_I18N_DOMAIN); ?> </strong></th> <td class="likebtn-ii-hostname"><img src="<?php echo $loader; ?> " /></td> </tr> </table> <div class="ui-dialog-buttonpane ui-widget-content ui-helper-clearfix"> <div class="ui-dialog-buttonset"> <button type="button" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-only button-secondary likebtn-button-close" role="button"><span class="ui-button-text"><?php _e('Close', LIKEBTN_I18N_DOMAIN); ?> </span></button> </div> </div> </div> <script async defer src="https://maps.googleapis.com/maps/api/js?v=3.exp&callback=showMap"> </script> <?php _likebtn_admin_footer(); }
function widget($args, $instance = array()) { global $wpdb; global $likebtn_nonpost_entities; global $likebtn_bbp_post_types; $has_posts = false; $post_types_count = 0; if (is_array($args)) { extract($args); } $instance = LikeBtnLikeButtonMostLikedWidget::prepareInstance($instance); if (is_array($instance)) { extract($instance); } if (empty($instance['entity_name'])) { $instance['entity_name'] = array(LIKEBTN_ENTITY_POST); } if (empty($instance['exclude_categories'])) { $instance['exclude_categories'] = array(); } // Author $author_in = ''; if (!empty($instance['author'])) { $author_in = "'" . implode("','", explode(",", preg_replace("/[^0-9,]/", '', $instance['author']))) . "'"; } // Add bbPress $nonpost_entities = $likebtn_nonpost_entities; $nonpost_entities[] = LIKEBTN_ENTITY_BBP_POST; foreach ($instance['entity_name'] as $entity_index => $entity_name) { $instance['entity_name'][$entity_index] = str_replace("'", '', trim($entity_name)); if (!in_array($entity_name, $nonpost_entities)) { $has_posts = true; } } $query_limit = ''; if (isset($instance['number']) && (int) $instance['number'] > 0) { $query_limit = "LIMIT " . (int) $instance['number']; } // getting the most liked content $query = ''; // Posts if ($has_posts) { $query_post_types = "'" . implode("','", $instance['entity_name']) . "'"; $query_exclude_categories = ''; if (count($instance['exclude_categories'])) { $query_exclude_categories = "'" . implode("','", $instance['exclude_categories']) . "'"; } $query_attachment = ''; if (in_array(LIKEBTN_ENTITY_ATTACHMENT, $instance['entity_name'])) { $query_attachment = " OR (p.post_type = 'attachment') "; } $query .= "\n SELECT\n DISTINCT p.ID as 'post_id',\n p.post_title,\n p.post_date,\n CONVERT(pm_likes.meta_value, UNSIGNED INTEGER) as 'likes',\n CONVERT(pm_dislikes.meta_value, UNSIGNED INTEGER) as 'dislikes',\n CONVERT(pm_likes_minus_dislikes.meta_value, SIGNED INTEGER) as 'likes_minus_dislikes',\n p.post_type,\n p.post_mime_type,\n '' as url\n FROM {$wpdb->prefix}postmeta pm_likes\n LEFT JOIN {$wpdb->prefix}posts p\n ON (p.ID = pm_likes.post_id)\n LEFT JOIN {$wpdb->prefix}postmeta pm_dislikes\n ON (pm_dislikes.post_id = pm_likes.post_id AND pm_dislikes.meta_key = '" . LIKEBTN_META_KEY_DISLIKES . "')\n LEFT JOIN {$wpdb->prefix}postmeta pm_likes_minus_dislikes\n ON (pm_likes_minus_dislikes.post_id = pm_likes.post_id AND pm_likes_minus_dislikes.meta_key = '" . LIKEBTN_META_KEY_LIKES_MINUS_DISLIKES . "') \n WHERE\n pm_likes.meta_key = '" . LIKEBTN_META_KEY_LIKES . "'\n AND ((p.post_status = 'publish'\n AND p.post_type in ({$query_post_types})) {$query_attachment}) "; if ($query_exclude_categories) { // ".($query_exclude_categories ? " // LEFT JOIN {$wpdb->term_relationships} t_rel ON (t_rel.object_id = p.ID) // LEFT JOIN {$wpdb->term_taxonomy} t_tax ON (t_tax.term_taxonomy_id = t_rel.term_taxonomy_id)" : '')." $query .= " AND NOT EXISTS (\n SELECT t_tax.term_id\n FROM {$wpdb->term_relationships} t_rel\n LEFT JOIN {$wpdb->term_taxonomy} t_tax ON (t_tax.term_taxonomy_id = t_rel.term_taxonomy_id)\n WHERE t_rel.object_id = p.ID AND t_tax.term_id IN ({$query_exclude_categories})\n ) "; } if (!empty($instance['time_range']) && $instance['time_range'] != 'all') { $query .= " AND p.post_date >= '" . $this->timeRangeToDateTime($instance['time_range']) . "' "; } if ($author_in) { $query .= " AND p.post_author IN (" . $author_in . ") "; } $post_types_count++; } // Comments if (in_array(LIKEBTN_ENTITY_COMMENT, $instance['entity_name'])) { if ($post_types_count > 0) { $query .= " UNION "; } $query .= "\n SELECT\n p.comment_ID as 'post_id',\n p.comment_content as post_title,\n p.comment_date as 'post_date',\n CONVERT(pm_likes.meta_value, UNSIGNED INTEGER) as 'likes',\n CONVERT(pm_dislikes.meta_value, UNSIGNED INTEGER) as 'dislikes',\n CONVERT(pm_likes_minus_dislikes.meta_value, SIGNED INTEGER) as 'likes_minus_dislikes',\n '" . LIKEBTN_ENTITY_COMMENT . "' as post_type,\n '' as post_mime_type,\n '' as url\n FROM {$wpdb->prefix}commentmeta pm_likes\n LEFT JOIN {$wpdb->prefix}comments p\n ON (p.comment_ID = pm_likes.comment_id)\n LEFT JOIN {$wpdb->prefix}commentmeta pm_dislikes\n ON (pm_dislikes.comment_id = pm_likes.comment_id AND pm_dislikes.meta_key = '" . LIKEBTN_META_KEY_DISLIKES . "')\n LEFT JOIN {$wpdb->prefix}commentmeta pm_likes_minus_dislikes\n ON (pm_likes_minus_dislikes.comment_id = pm_likes.comment_id AND pm_likes_minus_dislikes.meta_key = '" . LIKEBTN_META_KEY_LIKES_MINUS_DISLIKES . "')\n WHERE\n pm_likes.meta_key = '" . LIKEBTN_META_KEY_LIKES . "' \n AND p.comment_approved = 1 "; if (!empty($instance['time_range']) && $instance['time_range'] != 'all') { $query .= " AND comment_date >= '" . $this->timeRangeToDateTime($instance['time_range']) . "'"; } if ($author_in) { $query .= " AND p.comment_author IN (" . $author_in . ") "; } $post_types_count++; } // Custom items if (in_array(LIKEBTN_ENTITY_CUSTOM_ITEM, $instance['entity_name'])) { if ($post_types_count > 0) { $query .= " UNION "; } $query_post_types = "'" . implode("','", $instance['entity_name']) . "'"; $query .= "\n SELECT\n p.ID as 'post_id',\n p.identifier as 'post_title',\n '' as 'post_date',\n p.likes,\n p.dislikes,\n p.likes_minus_dislikes,\n '" . LIKEBTN_ENTITY_CUSTOM_ITEM . "' as 'post_type',\n '' as 'post_mime_type',\n url\n FROM {$wpdb->prefix}" . LIKEBTN_TABLE_ITEM . " p\n WHERE\n 1 = 1 "; $post_types_count++; } // BuddyPress Member if (_likebtn_is_bp_active() && in_array(LIKEBTN_ENTITY_BP_MEMBER, $instance['entity_name'])) { if ($post_types_count > 0) { $query .= " UNION "; } $query .= "\n SELECT\n p.ID as 'post_id',\n p.display_name as post_title,\n p.user_registered as 'post_date',\n CONVERT(pm_likes.meta_value, UNSIGNED INTEGER) as 'likes',\n CONVERT(pm_dislikes.meta_value, UNSIGNED INTEGER) as 'dislikes',\n CONVERT(pm_likes_minus_dislikes.meta_value, SIGNED INTEGER) as 'likes_minus_dislikes',\n '" . LIKEBTN_ENTITY_BP_MEMBER . "' as post_type,\n '' as post_mime_type,\n '' as url\n FROM {$wpdb->prefix}bp_xprofile_meta pm_likes\n LEFT JOIN {$wpdb->prefix}users p\n ON (p.ID = pm_likes.object_id AND pm_likes.object_type = '" . LIKEBTN_BP_XPROFILE_OBJECT_TYPE . "')\n LEFT JOIN {$wpdb->prefix}bp_xprofile_meta pm_dislikes\n ON (pm_dislikes.object_id = pm_likes.object_id AND pm_dislikes.object_type = '" . LIKEBTN_BP_XPROFILE_OBJECT_TYPE . "' AND pm_dislikes.meta_key = '" . LIKEBTN_META_KEY_DISLIKES . "')\n LEFT JOIN {$wpdb->prefix}bp_xprofile_meta pm_likes_minus_dislikes\n ON (pm_likes_minus_dislikes.object_id = pm_likes.object_id AND pm_likes_minus_dislikes.object_type = '" . LIKEBTN_BP_XPROFILE_OBJECT_TYPE . "' AND pm_likes_minus_dislikes.meta_key = '" . LIKEBTN_META_KEY_LIKES_MINUS_DISLIKES . "')\n WHERE\n pm_likes.meta_key = '" . LIKEBTN_META_KEY_LIKES . "' \n AND p.user_status = 0 "; if (!empty($instance['time_range']) && $instance['time_range'] != 'all') { $query .= " AND p.user_registered >= '" . $this->timeRangeToDateTime($instance['time_range']) . "'"; } $post_types_count++; } // BuddyPress Activities if (_likebtn_is_bp_active() && (in_array(LIKEBTN_ENTITY_BP_ACTIVITY_POST, $instance['entity_name']) || in_array(LIKEBTN_ENTITY_BP_ACTIVITY_UPDATE, $instance['entity_name']) || in_array(LIKEBTN_ENTITY_BP_ACTIVITY_COMMENT, $instance['entity_name']) || in_array(LIKEBTN_ENTITY_BP_ACTIVITY_TOPIC, $instance['entity_name']))) { if ($post_types_count > 0) { $query .= " UNION "; } $query .= "\n SELECT \n p.id as 'post_id',\n CONCAT( IF(p.action != '', p.action, IF(p.content !='', p.content, IF(p.primary_link != '', p.primary_link, p.type))), IF(p.content != '' && p.type != 'bbp_topic_create' && p.type != 'new_blog_post', CONCAT(': ', p.content), '') ) as 'post_title',\n p.date_recorded as 'post_date',\n CONVERT(pm_likes.meta_value, UNSIGNED INTEGER) as 'likes',\n CONVERT(pm_dislikes.meta_value, UNSIGNED INTEGER) as 'dislikes',\n CONVERT(pm_likes_minus_dislikes.meta_value, SIGNED INTEGER) as 'likes_minus_dislikes',\n IF (p.type = 'bbp_topic_create',\n '" . LIKEBTN_ENTITY_BP_ACTIVITY_TOPIC . "',\n IF (p.type = 'new_blog_post',\n '" . LIKEBTN_ENTITY_BP_ACTIVITY_POST . "',\n '" . LIKEBTN_ENTITY_BP_ACTIVITY_UPDATE . "'\n )\n ) as post_type,\n '' as post_mime_type,\n '' as url\n FROM {$wpdb->prefix}bp_activity_meta pm_likes\n LEFT JOIN {$wpdb->prefix}bp_activity p\n ON (p.id = pm_likes.activity_id)\n LEFT JOIN {$wpdb->prefix}bp_activity_meta pm_dislikes\n ON (pm_dislikes.activity_id = pm_likes.activity_id AND pm_dislikes.meta_key = '" . LIKEBTN_META_KEY_DISLIKES . "')\n LEFT JOIN {$wpdb->prefix}bp_activity_meta pm_likes_minus_dislikes\n ON (pm_likes_minus_dislikes.activity_id = pm_likes.activity_id AND pm_likes_minus_dislikes.meta_key = '" . LIKEBTN_META_KEY_LIKES_MINUS_DISLIKES . "')\n WHERE\n pm_likes.meta_key = '" . LIKEBTN_META_KEY_LIKES . "' \n AND p.hide_sitewide = 0\n AND p.is_spam = 0 "; if (!empty($instance['time_range']) && $instance['time_range'] != 'all') { $query .= " AND p.user_registered >= '" . $this->timeRangeToDateTime($instance['time_range']) . "'"; } if ($author_in) { $query .= " AND p.user_id IN (" . $author_in . ") "; } $post_types_count++; } // bbPress Post if (_likebtn_is_bbp_active() && in_array(LIKEBTN_ENTITY_BBP_POST, $instance['entity_name'])) { if ($post_types_count > 0) { $query .= " UNION "; } $query .= "\n SELECT\n p.ID as 'post_id',\n IF (p.post_title != '', p.post_title, p.post_content) as post_title,\n p.post_date,\n CONVERT(pm_likes.meta_value, UNSIGNED INTEGER) as 'likes',\n CONVERT(pm_dislikes.meta_value, UNSIGNED INTEGER) as 'dislikes',\n CONVERT(pm_likes_minus_dislikes.meta_value, SIGNED INTEGER) as 'likes_minus_dislikes',\n p.post_type,\n p.post_mime_type,\n '' as url\n FROM {$wpdb->prefix}postmeta pm_likes\n LEFT JOIN {$wpdb->prefix}posts p\n ON (p.ID = pm_likes.post_id)\n LEFT JOIN {$wpdb->prefix}postmeta pm_dislikes\n ON (pm_dislikes.post_id = pm_likes.post_id AND pm_dislikes.meta_key = '" . LIKEBTN_META_KEY_DISLIKES . "')\n LEFT JOIN {$wpdb->prefix}postmeta pm_likes_minus_dislikes\n ON (pm_likes_minus_dislikes.post_id = pm_likes.post_id AND pm_likes_minus_dislikes.meta_key = '" . LIKEBTN_META_KEY_LIKES_MINUS_DISLIKES . "')\n WHERE\n pm_likes.meta_key = '" . LIKEBTN_META_KEY_LIKES . "'\n AND p.post_type in ('" . implode("', '", $likebtn_bbp_post_types) . "') \n AND p.post_status = 'publish' "; if (!empty($instance['time_range']) && $instance['time_range'] != 'all') { $query .= " AND post_date >= '" . $this->timeRangeToDateTime($instance['time_range']) . "'"; } if ($author_in) { $query .= " AND p.post_author IN (" . $author_in . ") "; } $post_types_count++; } // bbPress User if (_likebtn_is_bbp_active() && in_array(LIKEBTN_ENTITY_BBP_USER, $instance['entity_name'])) { if ($post_types_count > 0) { $query .= " UNION "; } $query .= "\n SELECT\n p.ID as 'post_id',\n p.display_name as post_title,\n p.user_registered as 'post_date',\n CONVERT(pm_likes.meta_value, UNSIGNED INTEGER) as 'likes',\n CONVERT(pm_dislikes.meta_value, UNSIGNED INTEGER) as 'dislikes',\n CONVERT(pm_likes_minus_dislikes.meta_value, SIGNED INTEGER) as 'likes_minus_dislikes',\n '" . LIKEBTN_ENTITY_BBP_USER . "' as post_type,\n '' as post_mime_type,\n '' as url\n FROM {$wpdb->prefix}usermeta pm_likes\n LEFT JOIN {$wpdb->prefix}users p\n ON (p.ID = pm_likes.user_id)\n LEFT JOIN {$wpdb->prefix}usermeta pm_dislikes\n ON (pm_dislikes.user_id = pm_likes.user_id AND pm_dislikes.meta_key = '" . LIKEBTN_META_KEY_DISLIKES . "')\n LEFT JOIN {$wpdb->prefix}usermeta pm_likes_minus_dislikes\n ON (pm_likes_minus_dislikes.user_id = pm_likes.user_id AND pm_likes_minus_dislikes.meta_key = '" . LIKEBTN_META_KEY_LIKES_MINUS_DISLIKES . "')\n WHERE\n pm_likes.meta_key = '" . LIKEBTN_META_KEY_LIKES . "' \n AND p.user_status = 0 "; if (!empty($instance['time_range']) && $instance['time_range'] != 'all') { $query .= " AND p.user_registered >= '" . $this->timeRangeToDateTime($instance['time_range']) . "'"; } $post_types_count++; } if ($post_types_count > 1) { $query = "SELECT * FROM (" . $query . ") main_query"; } $query .= "\n ORDER BY "; switch ($instance['order']) { default: case 'likes': $query .= "likes"; break; case 'dislikes': $query .= "dislikes"; break; case 'likes_minus_dislikes': $query .= "likes_minus_dislikes"; break; } $query .= " DESC"; $query .= " {$query_limit}"; // echo "<pre>"; // print_r($query); // exit(); $posts = $wpdb->get_results($query); $post_loop = array(); if (count($posts) > 0) { foreach ($posts as $i => $db_post) { $post = array('id' => $db_post->post_id, 'type' => $db_post->post_type, 'post_mime_type' => $db_post->post_mime_type, 'title' => '', 'link' => '', 'likes' => '', 'dislikes' => '', 'date' => '', 'excerpt' => '', 'author_id' => '', 'author_name' => ''); if (empty($instance['title_length'])) { $instance['title_length'] = LIKEBTN_WIDGET_TITLE_LENGTH; } // Title $post['title'] = _likebtn_prepare_title($db_post->post_type, $db_post->post_title, $instance['title_length']); // Link $post['link'] = _likebtn_get_entity_url($db_post->post_type, $db_post->post_id, $db_post->url); $post['likes'] = $db_post->likes; $post['dislikes'] = $db_post->dislikes; if ($show_date) { $post['date'] = strtotime($db_post->post_date); } if ($show_author) { $author_id = _likebtn_get_author_id($db_post->post_type, $db_post->post_id); if ($author_id) { $post['author_id'] = $author_id; $post['author_name'] = _likebtn_get_entity_title(LIKEBTN_ENTITY_USER, $author_id); } } if ($show_excerpt) { $post['excerpt'] = _likebtn_get_entity_excerpt($db_post->post_type, $db_post->post_id); } // For bbPress replies if (!$post['title']) { $post['title'] = _likebtn_shorten_title($post['excerpt'], $instance['title_length']); } $post_loop[$i] = $post; } } // Get and include the template we're going to use ob_start(); include $this->getTemplateHierarchy(self::TEMPLATE); $result = ob_get_contents(); ob_get_clean(); return $result; }
function _likebtn_bp_activity_add($entity_name, $entity_id, $voter_id, $vote_type, $hide_sitewide, $snippet, $snippet_html) { if (!$voter_id) { return false; } if ($vote_type == LIKEBTN_VOTE_LIKE) { $type_name = __('liked', LIKEBTN_I18N_DOMAIN); } else { $type_name = __('disliked', LIKEBTN_I18N_DOMAIN); } $primary_link = _likebtn_get_entity_url($entity_name, $entity_id); $pattern = __('<a href="%user_url%" title="%user_name%">%user_name%</a> %type_name% %entity_name%, <a href="%entity_url%">%entity_title%</a>', LIKEBTN_I18N_DOMAIN); $title = _likebtn_get_entity_title($entity_name, $entity_id); $action = strtr($pattern, array('%user_url%' => _likebtn_get_entity_url(LIKEBTN_ENTITY_BP_MEMBER, $voter_id), '%user_name%' => bp_core_get_user_displayname($voter_id), '%type_name%' => $type_name, '%entity_url%' => _likebtn_get_entity_url($entity_name, $entity_id), '%entity_name%' => mb_strtolower(_likebtn_get_entity_name_title($entity_name, true)), '%entity_title%' => $title)); // Add snippet $content = "<!--{$entity_name}_{$entity_id}-->"; if ($snippet == '1') { $image_thumbnail = _likebtn_get_entity_image($entity_name, $entity_id, 'thumbnail'); $excerpt = _likebtn_get_entity_excerpt($entity_name, $entity_id); if (!$snippet_html) { $snippet_html = LIKEBTN_BP_SNIPPET_TPL; } $snippet_html = strtr($snippet_html, array('%image_thumbnail%' => $image_thumbnail, '%title%' => $title, '%excerpt%' => $excerpt)); $content .= $snippet_html; // ob_start(); // include(_likebtn_get_template_path(LIKEBTN_TEMPLATE_ACTIVITY_SNIPPET)); // $content .= ob_get_contents(); // ob_get_clean(); } $component = LIKEBTN_BP_COMPONENT_NAME; $item_id = $entity_id; // Determine hide_sitewide $private_group_activity = false; $group_id = 0; // Set hide_sitewide to true: // - BuddyPress forum // - Activity update in private group if ($entity_name == LIKEBTN_ENTITY_BBP_POST) { $group_post_id = (int) get_post_meta($entity_id, '_bbp_forum_id', true); if ($group_post_id) { $group_id_array = get_post_meta($group_post_id, '_bbp_group_ids', true); if ($group_id_array && isset($group_id_array[0])) { $group_id = (int) $group_id_array[0]; //$group = groups_get_group( array( 'group_id' => $group_id ) ); //$group_permalink = trailingslash*t( bp_get_root_domain() . '/' . bp_get_groups_root_slug() . '/' . $group->slug . '/' ) ); $group_post = get_post($group_post_id); if ($group_post && !empty($group_post->post_status) && $group_post->post_status == 'private') { $private_group_activity = true; } } } } if (in_array($entity_name, array(LIKEBTN_ENTITY_BP_ACTIVITY_POST, LIKEBTN_ENTITY_BP_ACTIVITY_UPDATE, LIKEBTN_ENTITY_BP_ACTIVITY_COMMENT, LIKEBTN_ENTITY_BP_ACTIVITY_TOPIC))) { $get_activity = bp_activity_get_specific(array('activity_ids' => $entity_id)); if (!empty($get_activity['activities']) && !empty($get_activity['activities'][0])) { $activity = $get_activity['activities'][0]; if ($activity->component == 'groups' && isset($activity->item_id) && (int) $activity->hide_sitewide == 1) { $private_group_activity = true; $group_id = $activity->item_id; } } } if ($private_group_activity && $group_id) { $hide_sitewide = 1; $component = 'groups'; $item_id = $group_id; } bp_activity_add(array('user_id' => $voter_id, 'item_id' => $item_id, 'secondary_item_id' => $vote_type, 'primary_link' => $primary_link, 'action' => $action, 'content' => $content, 'component' => $component, 'type' => LIKEBTN_BP_ACTIVITY_TYPE, 'hide_sitewide' => (int) $hide_sitewide)); }
function _likebtn_like_box($identifier, $size = LIKEBTN_LIKE_BOX_SIZE, $text = '', $type = LIKEBTN_VOTE_LIKE) { global $wpdb; $html = ''; if (!$size) { $size = LIKEBTN_LIKE_BOX_SIZE; } // Type $type = (int) $type; $query_where = ''; if ($type == LIKEBTN_VOTE_LIKE || $type === '') { $query_where = ' AND type = ' . LIKEBTN_VOTE_LIKE; } elseif ($type == LIKEBTN_VOTE_DISLIKE) { $query_where = ' AND type = ' . $type; } elseif ($type == LIKEBTN_VOTE_BOTH) { $query_where = ''; } $query = "\n SELECT DISTINCT user_id\n FROM " . $wpdb->prefix . LIKEBTN_TABLE_VOTE . "\n WHERE identifier = %s\n AND user_id is not NULL\n AND user_id != ''\n {$query_where} \n ORDER BY created_at DESC\n LIMIT {$size}\n "; $query_prepared = $wpdb->prepare($query, $identifier); $vote_list = $wpdb->get_results($query_prepared); if (!count($vote_list)) { return ''; } $user_loop = array(); foreach ($vote_list as $vote) { $user_loop[] = array('user_id' => $vote->user_id, 'name' => _likebtn_get_entity_title(LIKEBTN_ENTITY_USER, $vote->user_id), 'avatar' => _likebtn_get_avatar_url($vote->user_id), 'url' => get_author_posts_url($vote->user_id)); } // Get and include the template we're going to use ob_start(); include _likebtn_get_template_path(LIKEBTN_TEMPLATE_LIKE_BOX); $html = ob_get_contents(); ob_get_clean(); return $html; }
function _likebtn_get_entities($no_list = false, $include_invisible = false) { /*global $likebtn_entities; if (count($likebtn_entities)) { return $likebtn_entities; }*/ $likebtn_entities = array(LIKEBTN_ENTITY_POST => _likebtn_get_entity_title(LIKEBTN_ENTITY_POST), LIKEBTN_ENTITY_POST_LIST => _likebtn_get_entity_title(LIKEBTN_ENTITY_POST_LIST), LIKEBTN_ENTITY_PAGE => _likebtn_get_entity_title(LIKEBTN_ENTITY_PAGE), LIKEBTN_ENTITY_PAGE_LIST => _likebtn_get_entity_title(LIKEBTN_ENTITY_PAGE_LIST)); $post_types = get_post_types(array('public' => true, '_builtin' => false)); if (!empty($post_types)) { foreach ($post_types as $post_type) { // If bbPress is active miss bbPress custom post types if (_likebtn_is_bbp_active() && in_array($post_type, array('forum', 'topic', 'reply'))) { continue; } $likebtn_entities[$post_type] = _likebtn_get_entity_title($post_type); $likebtn_entities[$post_type . LIKEBTN_LIST_FLAG] = _likebtn_get_entity_title($post_type . LIKEBTN_LIST_FLAG); } } // Append BuddyPress if (_likebtn_is_bp_active()) { $likebtn_entities[LIKEBTN_ENTITY_BP_ACTIVITY_POST] = _likebtn_get_entity_title(LIKEBTN_ENTITY_BP_ACTIVITY_POST); $likebtn_entities[LIKEBTN_ENTITY_BP_ACTIVITY_UPDATE] = _likebtn_get_entity_title(LIKEBTN_ENTITY_BP_ACTIVITY_UPDATE); $likebtn_entities[LIKEBTN_ENTITY_BP_ACTIVITY_COMMENT] = _likebtn_get_entity_title(LIKEBTN_ENTITY_BP_ACTIVITY_COMMENT); $likebtn_entities[LIKEBTN_ENTITY_BP_ACTIVITY_TOPIC] = _likebtn_get_entity_title(LIKEBTN_ENTITY_BP_ACTIVITY_TOPIC); $likebtn_entities[LIKEBTN_ENTITY_BP_MEMBER] = _likebtn_get_entity_title(LIKEBTN_ENTITY_BP_MEMBER); } // Append bbPress if (_likebtn_is_bbp_active()) { $likebtn_entities[LIKEBTN_ENTITY_BBP_POST] = _likebtn_get_entity_title(LIKEBTN_ENTITY_BBP_POST); $likebtn_entities[LIKEBTN_ENTITY_BBP_USER] = _likebtn_get_entity_title(LIKEBTN_ENTITY_BBP_USER); } // append Comments $likebtn_entities[LIKEBTN_ENTITY_COMMENT] = _likebtn_get_entity_title(LIKEBTN_ENTITY_COMMENT); // translate entity names // does not work here /* load_plugin_textdomain(LIKEBTN_I18N_DOMAIN, false, dirname(plugin_basename(__FILE__)) . '/languages'); foreach ($entities as $entity_name => $entity_title) { $entities[$entity_name] = __($entity_title, LIKEBTN_I18N_DOMAIN); } */ // Remove excerpt entities if ($no_list) { foreach ($likebtn_entities as $entity_name => $entity_title) { if (_likebtn_has_list_flag($entity_name)) { unset($likebtn_entities[$entity_name]); } } } // Add invisible if ($include_invisible) { $likebtn_entities = array_merge($likebtn_entities, array(LIKEBTN_ENTITY_USER => _likebtn_get_entity_title(LIKEBTN_ENTITY_USER))); } return $likebtn_entities; }