$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']);
function GUS_get_ua_counts()
{
global $_TABLES, $_GUS_UA_IGNORE, $_GUS_table_prefix;
if (count($_GUS_UA_IGNORE) === 0) {
return array('list' => array(), 'list_len' => 0, 'entry_count' => 0);
}
$tmp_name = $_GUS_table_prefix . 'temp_ua_table';
$temp_table = GUS_create_temp_table($tmp_name, "SELECT DISTINCT ua_id, user_agent\n\t\t\t\tFROM {$_TABLES['gus_user_agents']} ua, {$_TABLES['gus_ignore_ua']} iua \n\t\t\t\tWHERE ua.user_agent LIKE iua.ua");
$result = DB_query("SELECT DISTINCT( user_agent ), COUNT( * ) AS entries\n\t\t\t\t\t\tFROM {$_TABLES['gus_userstats']} ua JOIN {$temp_table['name']} tmp ON ua.ua_id = tmp.ua_id\n\t\t\t\t\t\tGROUP BY user_agent");
$id_list = GUS_create_item_list_for_count($result, 'user_agent');
GUS_remove_temp_table($temp_table);
return $id_list;
}