- md5
- febc5f73c27c9462cecedfb3de5dbc06
- sha1
- b5f45bae16ce919555dcab84a73d2c168ba3f9c4
- sha256
- 041768a5e654c3886f4752f98fd6ce00c0145cccf7b131a21967639a390d2500
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205
<?php
/**
* @version $Id: admin.statistics.php 120 2005-09-16 20:09:14Z stingrey $
* @package Joomla
* @subpackage Statistics
* @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* Joomla! is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*/
// no direct access
defined( '_VALID_MOS' ) or die( 'Restricted access' );
require_once( $mainframe->getPath( 'admin_html' ) );
switch ($task) {
case 'searches':
showSearches( $option, $task );
break;
case 'pageimp':
showPageImpressions( $option, $task );
break;
default:
showSummary( $option, $task );
break;
}
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", "agent" );
$sorts['b_hits'] = mosHTML::sortIcon( "$sort_base&tab=tab1", "hits", $order );
$sorts['o_agent'] = mosHTML::sortIcon( "$sort_base&tab=tab2", "agent" );
$sorts['o_hits'] = mosHTML::sortIcon( "$sort_base&tab=tab2", "hits", $order );
$sorts['d_agent'] = mosHTML::sortIcon( "$sort_base&tab=tab3", "agent" );
$sorts['d_hits'] = mosHTML::sortIcon( "$sort_base&tab=tab3", "hits", $order );
break;
case 'agent':
default:
$order_by = "agent $order";
$sorts['b_agent'] = mosHTML::sortIcon( "$sort_base&tab=tab1", "agent", $order );
$sorts['b_hits'] = mosHTML::sortIcon( "$sort_base&tab=tab1", "hits" );
$sorts['o_agent'] = mosHTML::sortIcon( "$sort_base&tab=tab2", "agent", $order );
$sorts['o_hits'] = mosHTML::sortIcon( "$sort_base&tab=tab2", "hits" );
$sorts['d_agent'] = mosHTML::sortIcon( "$sort_base&tab=tab3", "agent", $order );
$sorts['d_hits'] = mosHTML::sortIcon( "$sort_base&tab=tab3", "hits" );
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 );
}
function showPageImpressions( $option, $task ) {
global $database, $mainframe, $mosConfig_list_limit;
$query = "SELECT COUNT( id )"
. "\n FROM #__content"
;
$database->setQuery($query);
$total = $database->loadResult();
$limit = $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', $mosConfig_list_limit );
$limitstart = $mainframe->getUserStateFromRequest( "view{$option}{$task}limitstart", 'limitstart', 0 );
require_once( $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php' );
$pageNav = new mosPageNav( $total, $limitstart, $limit );
$query = "SELECT id, title, created, hits"
. "\n FROM #__content"
. "\n ORDER BY hits DESC"
. "\n LIMIT $pageNav->limitstart, $pageNav->limit"
;
$database->setQuery($query);
$rows = $database->loadObjectList();
HTML_statistics::pageImpressions( $rows, $pageNav, $option, $task );
}
function showSearches( $option, $task ) {
global $database, $mainframe, $mosConfig_list_limit;
global $_MAMBOTS;
$limit = $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', $mosConfig_list_limit );
$limitstart = $mainframe->getUserStateFromRequest( "view{$option}{$task}limitstart", 'limitstart', 0 );
// get the total number of records
$query = "SELECT COUNT(*)"
. "\n FROM #__core_log_searches"
;
$database->setQuery( $query );
$total = $database->loadResult();
require_once( $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php' );
$pageNav = new mosPageNav( $total, $limitstart, $limit );
$query = "SELECT *"
. "\n FROM #__core_log_searches"
. "\n ORDER BY hits DESC"
. "\n LIMIT $pageNav->limitstart, $pageNav->limit"
;
$database->setQuery( $query );
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
$_MAMBOTS->loadBotGroup( 'search' );
for ($i=0, $n = count($rows); $i < $n; $i++) {
$results = $_MAMBOTS->trigger( 'onSearch', array( $rows[$i]->search_term ) );
$count = 0;
for ($j = 0, $n2 = count( $results ); $j < $n2; $j++) {
$count += count( $results[$j] );
}
$rows[$i]->returns = $count;
}
HTML_statistics::showSearches( $rows, $pageNav, $option, $task );
}
?>
The same content is in 4 releases, Joomla 1.0.3 to 1.0.8. See them all, or every version of this file.