$result = DB_query("SELECT COUNT(*) AS num_pages FROM {$temp_table['name']} WHERE DAYOFMONTH( date ) = {$day}"); $row = DB_fetchArray($result, FALSE); $pages += $row['num_pages']; $T->set_var('pages', $row['num_pages']); $date_compare = GUS_get_date_comparison('date', $year, $month, $day); $result = DB_query("SELECT COUNT(*) AS num_stories FROM {$_TABLES['stories']} WHERE {$date_compare}"); $row = DB_fetchArray($result, FALSE); $stories += $row['num_stories']; $T->set_var('stories', $row['num_stories']); $result = DB_query("SELECT COUNT(*) AS num_comments FROM {$_TABLES['comments']} WHERE {$date_compare}"); $row = DB_fetchArray($result, FALSE); $comments += $row['num_comments']; $T->set_var('comments', $row['num_comments']); $result = DB_query("SELECT COUNT(*) AS num_links FROM {$temp_table['name']}\n\t\t\t\t\t\t\t\tWHERE page LIKE '%portal.php' AND query_string <> '' AND DAYOFMONTH( date ) = {$day}"); $row = DB_fetchArray($result, FALSE); $linksf += $row['num_links']; $T->set_var('linksf', $row['num_links']); $T->Parse('ABlock', 'ROW', TRUE); } } $T->set_var(array('period' => $LANG_GUS00['total'], 'anon' => $anon, 'reg' => $reg, 'pages' => $pages, 'stories' => $stories, 'comments' => $comments, 'linksf' => $linksf, 'google_paging' => $navlinks)); $title = date('F Y - ', mktime(0, 0, 0, $month, 1, $year)) . $LANG_GUS00['daily_title']; $display = GUS_template_finish($T, $title); if ($_GUS_cache and date('Yn') !== $year . $month) { GUS_writecache($display); } GUS_remove_temp_table($temp_table); } echo COM_siteHeader($_GUS_CONF['show_left_blocks']); echo $display; echo COM_siteFooter($_GUS_CONF['show_right_blocks']);
} else { $result = DB_query("SELECT COUNT(*) AS num_links FROM {$temp_table['name']} WHERE page='phplinks/out_frame.php'"); $row = DB_fetchArray($result, FALSE); $linksf += $row['num_links']; } } else { $result = DB_query("SELECT COUNT(*) AS num_links FROM {$temp_table['name']}\n\t\t\t\t\t\t\t\tWHERE page LIKE '%portal.php' AND query_string <> ''"); $row = DB_fetchArray($result, FALSE); $linksf += $row['num_links']; } $T->set_var(array('linksf' => $row['num_links'], 'byhour' => 'X')); $result = DB_query("SELECT COUNT(*) AS num_referrers FROM {$temp_table['name']}\n\t\t\t\t\t\t\tWHERE referer <> ''"); $row = DB_fetchArray($result, FALSE); $referers += $row['num_referrers']; $T->set_var('referer', $row['num_referrers']); $rec1 = DB_query("SELECT RIGHT( host, INSTR( REVERSE( host ), '.' ) - 1 ) AS country\n\t\t\t\tFROM {$temp_table['name']} WHERE host <> 'localhost' AND ASCII( REVERSE( host ) ) > 64 GROUP BY country"); $num_rows = DB_numRows($rec1); $countries += $num_rows; $T->set_var(array('country' => $num_rows, 'browser' => 'X', 'platform' => 'X')); $T->parse('ABlock', 'MONTH', TRUE); GUS_remove_temp_table($temp_table); } $T->set_var(array('display_month' => $LANG_GUS00['total'], 'anon' => $anon, 'reg' => $reg, 'pages' => $pages, 'stories' => $stories, 'comments' => $comments, 'linksf' => $linksf, 'byhour' => 'NA', 'referer' => $referers, 'country' => $countries, 'browser' => 'NA', 'platform' => 'NA', 'google_paging' => $navlinks)); $display = GUS_template_finish($T, $LANG_GUS00['monthly_title']); if ($_GUS_cache and $curpage != $num_pages) { GUS_writecache($display); } } echo COM_siteHeader($_GUS_CONF['show_left_blocks']); echo $display; echo COM_siteFooter($_GUS_CONF['show_right_blocks']);