*/
// must be run within Dokuwiki
if(!defined('DOKU_INC')) die();
if(!defined('DOKU_PLUGIN')) define('DOKU_PLUGIN',DOKU_INC.'lib/plugins/');
require_once(DOKU_PLUGIN.'admin.php');
/**
* All DokuWiki plugins to extend the admin function
* need to inherit from this class
*/
class admin_plugin_statistics extends DokuWiki_Admin_Plugin {
var $dblink = null;
/**
* return some info
*/
function getInfo(){
return confToHash(dirname(__FILE__).'/info.txt');
}
/**
* Access for managers allowed
*/
function forAdminOnly(){
return false;
}
/**
* return sort order for position in admin menu
*/
function getMenuSort() {
return 150;
}
/**
* handle user request
*/
function handle() {
}
/**
* fixme build statistics here
*/
function html() {
// fixme build a navigation menu in a TOC here
switch($_REQUEST['opt']){
default:
echo $this->locale_xhtml('intro');
echo $this->html_dashboard();
}
}
function html_timeselect(){
echo '';
}
function html_dashboard(){
// top pages today
$sql = "SELECT page, COUNT(*) as cnt
FROM ".$this->getConf('db_prefix')."access
WHERE DATE(dt) = CURDATE()
AND ua_type = 'browser'
GROUP BY page
ORDER BY cnt DESC, page
LIMIT 20";
$result = $this->runSQL($sql);
$this->html_resulttable($result,array('Pages','Count'));
// top referer today
$sql = "SELECT ref as url, COUNT(*) as cnt
FROM ".$this->getConf('db_prefix')."access
WHERE DATE(dt) = CURDATE()
AND ua_type = 'browser'
AND ref_type = 'external'
GROUP BY ref_md5
ORDER BY cnt DESC, url
LIMIT 20";
$result = $this->runSQL($sql);
$this->html_resulttable($result,array('Incoming Links','Count'));
}
/**
* Display a result in a HTML table
*/
function html_resulttable($result,$header){
echo '