コード例 #1
0
ファイル: daily.php プロジェクト: hostellerie/gus
 $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);
コード例 #2
0
ファイル: ip.php プロジェクト: hostellerie/gus
// 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);