Exemple #1
0
function get_totalviews_term($term_id = 1, $display = true, $with_bot = true, $type = '')
{
    global $wpdb;
    $where = '';
    $inner_join = '';
    if ($term_id != 0) {
        if (is_array($term_id)) {
            $term_id = array_map('intval', $term_id);
            $where = 'tt.term_id IN (' . implode(',', $term_id) . ') AND ';
        } else {
            $where = 'tt.term_id=' . intval($term_id) . ' AND ';
        }
        $inner_join = 'INNER JOIN ' . $wpdb->term_relationships . ' AS tr ON pm.post_id = tr.object_id' . ' INNER JOIN ' . $wpdb->term_taxonomy . ' AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = "' . $type . '"';
    }
    $add_word = get_totalviews_stats_word($term_id, $with_bot, $type);
    if ($with_bot) {
        $total_views = $wpdb->get_var('SELECT SUM(IFNULL(CAST(pm.meta_value AS UNSIGNED), 0)) FROM ' . $wpdb->postmeta . ' AS pm ' . $inner_join . ' WHERE ' . $where . ' (pm.meta_key = "' . WP_PVP::$post_meta_views . '" OR pm.meta_key = "' . WP_PVP::$post_meta_botviews . '")');
        $template = str_replace('%VIEW_COUNT%', '<span id="wppvp_gt_' . $add_word . '">%VIEW_COUNT%</span>', WP_PVP::$options['template']);
    } else {
        $total_views = $wpdb->get_var('SELECT SUM(IFNULL(CAST(pm.meta_value AS UNSIGNED), 0)) FROM ' . $wpdb->postmeta . ' AS pm ' . $inner_join . ' WHERE ' . $where . ' pm.meta_key = "' . WP_PVP::$post_meta_views . '"');
        $template = str_replace('%VIEW_COUNT%', '<span id="wppvp_gt_' . $add_word . '">%VIEW_COUNT%</span>', WP_PVP::$options['user_template']);
    }
    $total_views = intval($total_views);
    if ($display) {
        if (defined('WP_CACHE') && WP_CACHE) {
            WP_PVP::add_cache_stats('gt', $term_id, $with_bot, $type);
            $template = str_replace('%VIEW_COUNT%', '', $template);
        } else {
            $template = str_replace('%VIEW_COUNT%', number_format_i18n($total_views), $template);
        }
        echo $template;
    } else {
        return $total_views;
    }
}
Exemple #2
0
 public static function add_cache_stats($addin, $id, $with_bot = true, $type = '')
 {
     global $wpdb;
     static $first_run = true;
     $count_id = md5($_SERVER['REQUEST_URI']);
     if ($first_run) {
         $wpdb->query('DELETE FROM ' . $wpdb->postviews_plus . ' WHERE count_id = "' . $count_id . '"');
         $wpdb->query('DELETE FROM ' . $wpdb->postviews_plus . ' WHERE add_time < ' . (time() - 86400 * 7));
         $first_run = false;
     }
     $data = $wpdb->get_row('SELECT * FROM ' . $wpdb->postviews_plus . ' WHERE count_id = "' . $count_id . '"');
     if ($data) {
         switch ($addin) {
             case 'tv':
                 if ($data->tv == '') {
                     $update = array('tv' => $id);
                 } else {
                     if (!in_array($id, explode(',', $data->tv))) {
                         $update = array('tv' => $data->tv . ',' . $id);
                     }
                 }
                 if (isset($update)) {
                     $wpdb->update($wpdb->postviews_plus, $update, array('count_id' => $count_id));
                 }
                 break;
             case 'gt':
                 $add_word = get_totalviews_stats_word($id, $with_bot, $type);
                 if ($data->gt == '') {
                     $update = array('gt' => $add_word);
                 } else {
                     if (!in_array($add_word, explode(',', $data->gt))) {
                         $update = array('gt' => $data->gt . ',' . $add_word);
                     }
                 }
                 if (isset($update)) {
                     $wpdb->update($wpdb->postviews_plus, $update, array('count_id' => $count_id));
                 }
                 break;
         }
     } else {
         switch ($addin) {
             case 'tv':
                 $wpdb->insert($wpdb->postviews_plus, array('tv' => $id, 'count_id' => $count_id, 'add_time' => time()));
                 break;
             case 'gt':
                 $add_word = get_totalviews_stats_word($id, $with_bot, $type);
                 $wpdb->insert($wpdb->postviews_plus, array('gt' => $add_word, 'count_id' => $count_id, 'add_time' => time()));
                 break;
         }
     }
 }