function showSummary($option, $task) { global $database, $mainframe; // get sort field and check against allowable field names $field = strtolower(mosGetParam($_REQUEST, 'field', '')); if (!in_array($field, array('agent', 'hits'))) { $field = ''; } // get field ordering or set the default field to order $order = strtolower(mosGetParam($_REQUEST, 'order', 'asc')); if ($order != 'asc' && $order != 'desc' && $order != 'none') { $order = 'asc'; } else { if ($order == 'none') { $field = 'agent'; $order = 'asc'; } } // browser stats $order_by = ''; $sorts = array(); $tab = mosGetParam($_REQUEST, 'tab', 'tab1'); $sort_base = "index2.php?option={$option}&task={$task}"; switch ($field) { case 'hits': $order_by = "hits {$order}"; $sorts['b_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab1", "agente"); $sorts['b_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab1", "acessos", $order); $sorts['o_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab2", "agente"); $sorts['o_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab2", "acessos", $order); $sorts['d_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab3", "agente"); $sorts['d_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab3", "acessos", $order); break; case 'agent': default: $order_by = "agent {$order}"; $sorts['b_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab1", "agente", $order); $sorts['b_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab1", "acessos"); $sorts['o_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab2", "agente", $order); $sorts['o_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab2", "acessos"); $sorts['d_agent'] = mosHTML::sortIcon("{$sort_base}&tab=tab3", "agente", $order); $sorts['d_hits'] = mosHTML::sortIcon("{$sort_base}&tab=tab3", "acessos"); break; } $query = "SELECT *" . "\n FROM #__stats_agents" . "\n WHERE type = 0" . "\n ORDER BY {$order_by}"; $database->setQuery($query); $browsers = $database->loadObjectList(); $query = "SELECT SUM( hits ) AS totalhits, MAX( hits ) AS maxhits" . "\n FROM #__stats_agents" . "\n WHERE type = 0"; $database->setQuery($query); $bstats = null; $database->loadObject($bstats); // platform statistics $query = "SELECT *" . "\n FROM #__stats_agents" . "\n WHERE type = 1" . "\n ORDER BY hits DESC"; $database->setQuery($query); $platforms = $database->loadObjectList(); $query = "SELECT SUM( hits ) AS totalhits, MAX( hits ) AS maxhits" . "\n FROM #__stats_agents" . "\n WHERE type = 1"; $database->setQuery($query); $pstats = null; $database->loadObject($pstats); // domain statistics $query = "SELECT *" . "\n FROM #__stats_agents" . "\n WHERE type = 2" . "\n ORDER BY hits DESC"; $database->setQuery($query); $tldomains = $database->loadObjectList(); $query = "SELECT SUM( hits ) AS totalhits, MAX( hits ) AS maxhits" . "\n FROM #__stats_agents" . "\n WHERE type = 2"; $database->setQuery($query); $dstats = null; $database->loadObject($dstats); HTML_statistics::show($browsers, $platforms, $tldomains, $bstats, $pstats, $dstats, $sorts, $option); }