$stories = 0; $comments = 0; $linksf = 0; $days = Date('t', mktime(0, 0, 0, $month, 1, $year)); // special case for this month - don't show days in the future $today = getdate(); if ($today['year'] == $year and $today['mon'] == $month) { $days = min($days, $today['mday']); } $num_pages = ceil($days / $_GUS_days); if (!isset($_GET['page']) or empty($_GET['page'])) { $curpage = 1; } else { $curpage = (int) $_GET['page']; } $base_url = GUS_create_url('page'); $navlinks = COM_printPageNavigation($base_url, $curpage, $num_pages); $temp_table = GUS_create_temp_userstats_table($year, $month); for ($day = 1; $day <= $days; $day++) { if ($day > ($curpage - 1) * $_GUS_days and $day <= $curpage * $_GUS_days) { $day_of_week = date('l', mktime(0, 0, 0, $month, $day, $year)); $date_formatted = date('l d', mktime(0, 0, 0, $month, $day, $year)); $T->set_var('day_display', $date_formatted); $T->set_var(array('day' => $day, 'mon' => $month, 'year' => $year)); if ($day % 2) { $T->set_var('rowclass', 'row1'); } else { $T->set_var('rowclass', 'row2'); } $result = DB_query("SELECT COUNT( DISTINCT ip ) AS num_anon FROM {$temp_table['name']} WHERE uid = '1' AND DAYOFMONTH( date ) = {$day}"); $row = DB_fetchArray($result, FALSE);
// main SQL query $date_compare = GUS_get_date_comparison('date', $year, $month, $day); $date_format = $day == 0 ? 'CONCAT( DATE_FORMAT( date, \'%d %b - \' ), TIME_FORMAT( time, \'%H:%i\' ) )' : 'TIME_FORMAT( time, \'%H:%i\' )'; $order_by = GUS_get_order_by($sort); $sql = "SELECT page, uid, username, ip, host, referer, query_string, date, time, request,\n\t\t{$date_format} AS date_formatted \n\t\tFROM {$_TABLES['gus_userstats']} \n\t\tWHERE {$date_compare} AND ip='{$ip_addr}' {$order_by}"; // create navigation_URLs AND set urls $totalrec = DB_query($sql); $totalrows = DB_numRows($totalrec); $num_pages = ceil($totalrows / $_GUS_limit); if (!isset($_GET['page']) or empty($_GET['page'])) { $curpage = 1; } else { $curpage = (int) $_GET['page']; } $header_url = GUS_create_url('sort'); $base_url = GUS_create_url(''); $navigation_URLs = COM_printPageNavigation($base_url, $curpage, $num_pages); // limit to the sql $offset = ($curpage - 1) * $_GUS_limit; $sql .= " LIMIT " . $offset . ', ' . $_GUS_limit; $rec = DB_query($sql); $nrows = DB_numRows($rec); // set template $T = GUS_template_start(); $T->set_var('additional_nav', GUS_make_nav($day, $month, $year, "ip_addr={$ip_addr}")); //---------------------- // IP info block $block_title = "{$ip_addr} [" . $_GUS_Whois_URL_start . $ip_addr . $_GUS_Whois_URL_end . 'whois</a>]'; // Check to see if collect stats on this IP $result = DB_query("SELECT COUNT(*) AS ignored\n\t\t\t\t\t\tFROM {$_TABLES['gus_ignore_ip']}\n\t\t\t\t\t\tWHERE '{$ip_addr}' LIKE ip\n\t\t\t\t\t\tLIMIT 1", 1); $row = DB_fetchArray($result, FALSE);