Esempio n. 1
0
 function get_pageviews_data($_where_clause, $_filters = array())
 {
     $config =& SlimStatConfig::get_instance();
     $query = "SELECT COUNT(`id`) AS `hits` FROM `" . SlimStat::my_esc($config->database) . "`.`" . SlimStat::my_esc($config->stats) . "` WHERE ";
     if ($_where_clause != "") {
         $query .= $_where_clause . " AND ";
     }
     $query .= SlimStat::get_filter_clause($_filters) . " GROUP BY `visit`";
     $raw_data = SlimStat::_get_data($query);
     $data = array();
     foreach ($raw_data as $datum) {
         if (array_key_exists($datum["hits"], $data)) {
             $data[$datum["hits"]]++;
         } else {
             $data[$datum["hits"]] = 1;
         }
     }
     ksort($data);
     return $data;
 }