get_results("SELECT FORMAT(SUM(hit_count), 0) AS hit_count, hit_date FROM $this->hits_table WHERE hit_date < CURDATE() GROUP BY hit_date ORDER BY hit_date DESC LIMIT $best_num"); ?> get_results("SELECT FORMAT(SUM(hit_count), 0) AS hit_count, SUM(hit_count) AS sort_order, hit_date FROM $this->hits_table WHERE hit_date < CURDATE() GROUP BY hit_date ORDER BY sort_order DESC LIMIT $best_num"); ?>

Today's Page Loads

    get_var("SELECT FORMAT(SUM(hit_count), 0) FROM $this->hits_table WHERE hit_date = CURDATE()"); ?>

Total Page Loads

    get_var("SELECT FORMAT(SUM(hit_count), 0) FROM $this->hits_table"); ?>

Avg Daily Loads

    get_var("SELECT FORMAT((SUM(hit_count)/ ((TO_DAYS(CURDATE()) - TO_DAYS(MIN(hit_date))) + 1)), 0) FROM $this->hits_table WHERE hit_date > '$date'"); ?>

Today's Prediction

    get_var("SELECT FORMAT(SUM(hit_count) * (86400/TIME_TO_SEC(TIME(NOW()))), 0) FROM $this->hits_table WHERE hit_date = CURDATE()"); ?>
     

Previous Days

    '. $row->hit_count .' ('. $row->hit_date .')'; } ?>
     

Best Days

    '. $row->hit_count .' ('. $row->hit_date .')'; } ?>
Complied: | System Load Average: get_loadavg(); ?>

get_results("SELECT post_id, AVG(hit_count) AS hit_avg FROM $this->hits_table WHERE hit_date >= DATE_SUB(CURDATE(),INTERVAL 30 DAY) AND post_id <> 0 GROUP BY post_id ORDER BY post_id ASC", ARRAY_A); $avg = array(); foreach($posts as $post) $avg[$post['post_id']] = $post['hit_avg']; $posts = $wpdb->get_results("SELECT post_id, hit_count * (86400/TIME_TO_SEC(TIME(NOW()))) AS hit_now FROM $this->hits_table WHERE hit_date = CURDATE() AND post_id <> 0 ORDER BY post_ID ASC;", ARRAY_A); $now = array(); foreach($posts as $post) $now[$post['post_id']] = $post['hit_now']; $diff = array(); foreach($posts as $post) $diff[$post['post_id']] = intval(($now[$post['post_id']] - $avg[$post['post_id']]) * 1000 ); $win = count(array_filter($diff, create_function('$a', 'if($a > 0) return(TRUE);'))); $lose = count($diff) - $win; $sort = array_flip($diff); ksort($sort); ?>

Most Reads

    hits_table WHERE 1=1 AND post_id <> 0 GROUP BY post_id ORDER BY sort_order DESC LIMIT $detail_lines"; $result = $wpdb->get_results($request, ARRAY_A); if(!empty($result)){ foreach($result as $post){ echo '
  1. '. get_the_title($post['post_id']) .'
    Tot: '. $post['hit_count'] .' Avg: '. $post['hit_avg'] .' Max: '. $post['hit_max'] ."
    2. \n"; } }else{ echo '
  2. No Data Yet.
    3. '; } ?>

Top Climbers

    '. get_the_title($post_id) .'
    Up: '. number_format($diff[$post_id] / 1000, 0) .' Avg: '. number_format($avg[$post_id], 0) .' Today: '. number_format($now[$post_id], 0) ."\n"; } }else{ echo '
  1. No Data Yet.
    2. '; } ?>

Biggest Losers

    '. get_the_title($post_id) .'
    Down: '. number_format($diff[$post_id] / 1000, 0) .' Avg: '. number_format($avg[$post_id], 0) .' Today: '. number_format($now[$post_id], 0) ."\n"; } }else{ echo '
  1. No Data Yet.
    2. '; } ?>

Note on climbers and losers: values for "today" are predicted totals for the day based on current data. They should not be mistaken to represent the actual number of page loads in a day, as they will fluctuate throughout the day.

Referrers from Google Blog Search

    '; $rss = @fetch_rss( $rss_feed ); if ( isset($rss->items) && 1 < count($rss->items) ) { $rss->items = array_slice($rss->items, 0, $detail_lines); foreach ($rss->items as $item ) { ?>
    2. No Data Yet.'; } ?>

Referrers from Technorati

    '; $rss = @fetch_rss( $rss_feed ); if ( isset($rss->items) && 1 < count($rss->items) ) { $rss->items = array_slice($rss->items, 0, $detail_lines); foreach ($rss->items as $item ) { ?>
    2. No Data Yet.'; } ?>

Incoming Search Terms

    pop_refs("limit=$detail_lines&days=$bstat_period"); if(!empty($refs)) echo $refs; else echo '
  1. No Data Yet.
    2. '; ?>