';
// top pages today
echo '
';
echo '
Most popular pages
';
$sql = "SELECT page, COUNT(*) as cnt
FROM ".$this->getConf('db_prefix')."access as A
WHERE ".$this->tlimit."
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'));
echo '';
// top referer today
echo '
';
echo '
Top incoming links
';
$sql = "SELECT ref as url, COUNT(*) as cnt
FROM ".$this->getConf('db_prefix')."access as A
WHERE ".$this->tlimit."
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'));
echo '';
// top countries today
echo '
';
echo '
Visitor\'s top countries
';
$sql = "SELECT B.country, COUNT(*) as cnt
FROM ".$this->getConf('db_prefix')."access as A,
".$this->getConf('db_prefix')."iplocation as B
WHERE ".$this->tlimit."
AND A.ip = B.ip
GROUP BY B.country
ORDER BY cnt DESC, B.country
LIMIT 20";
$result = $this->runSQL($sql);
$this->html_resulttable($result,array('Countries','Count'));
echo '';
echo '