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 _likebtn_get_entity_image($entity_name, $entity_id, $size = 'large') { $image = ''; switch ($entity_name) { case LIKEBTN_ENTITY_BP_MEMBER: case LIKEBTN_ENTITY_BBP_USER: case LIKEBTN_ENTITY_USER: $image = _likebtn_get_avatar_url($entity_id); break; case LIKEBTN_ENTITY_ATTACHMENT: $image_url = wp_get_attachment_image_src($entity_id, $size); if (!empty($image_url[0])) { $image = $image_url[0]; } break; default: $image_url = wp_get_attachment_image_src(get_post_thumbnail_id($entity_id), $size); if (!empty($image_url[0])) { $image = $image_url[0]; } break; } return $image; }