<?php #####################################
case
'besucherStatistik'
:
{
function
echo_admin_site_statistik (
$title
,
$col
,
$smon
,
$ges
,
$orderQuery
) {
$sql
= db_query(
"SELECT COUNT(*) AS wert, $col as schl FROM `prefix_stats` WHERE mon = "
.
$smon
.
" GROUP BY schl ORDER BY "
.
$orderQuery
);
$max
= @db_result(db_query(
"SELECT COUNT(*) as wert, $col as schl FROM prefix_stats WHERE mon = "
.
$smon
.
" GROUP BY schl ORDER BY wert DESC LIMIT 1"
),0,0);
if
(
empty
(
$max
) ) {
$max
= 1; }
if
(
empty
(
$ges
) ) {
$ges
= 1; }
echo
'<tr><th align="left" colspan="4">'
.
$title
.
'</th></tr>'
;
while
(
$r
= db_fetch_assoc(
$sql
) ) {
$wert
= (
empty
(
$r
[
'wert'
]) ? 1 :
$r
[
'wert'
] );
$weite
= (
$wert
/
$max
) * 200;
$prozent
= (
$wert
* 100) /
$ges
;
$prozent
= number_format(
round
(
$prozent
,2), 2,
','
,
''
);
$name
=
$r
[
'schl'
];
if
(
strlen
(
$name
) >= 50 ) {
$name
=
substr
(
$name
,0,50).
'<b>...</b>'
;
}
echo
'<tr class="norm"><td width="150" title="'
.
$r
[
'schl'
].
'">'
.
$name
.
'</td><td width="250">'
;
echo
'<hr width="'
.
$weite
.
'" align="left" /></td>'
;
echo
'<td width="50" align="right">'
.
$prozent
.
'%</td>'
;
echo
'<td width="50" align="right">'
.
$wert
.
'</td></tr>'
;
}
}
echo
'<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_visitor.png" /></td><td width="30"></td><td valign="bottom"><h1>Besucher Statistik</h1></td></tr></table>'
;
echo
'<a href="admin.php?admin-besucherUebersicht">Übersicht</a> <b>|</b> <a href="?admin-besucherStatistik-'
.
$lastmon
.
'" title="'
.
$lastmon
.
'. '
.
$lastjahr
.
'">letzter Monat</a> <b>|</b> <a href="?admin-besucherStatistik-'
.
$mon
.
'" title="'
.
$mon
.
'. '
.
$jahr
.
'">dieser Monat</a>'
;
$smon
=
$menu
->get(2);
if
(
empty
(
$smon
) ) {
$smon
=
$mon
; }
$ges
= db_result(db_query(
"SELECT COUNT(*) FROM prefix_stats WHERE mon = "
.
$smon
),0,0);
echo
'<br /><br /><b>Gesamt diesen Monat: '
.
$ges
.
'</b>'
;
echo
'<table cellpadding="2" border="0" cellspacing="0">'
;
echo_admin_site_statistik (
'Besucher nach Tagen'
,
'day'
,
$smon
,
$ges
,
"schl DESC LIMIT 50"
);
echo_admin_site_statistik (
'Besucher nach Wochentagen'
,
'DAYNAME(FROM_UNIXTIME((wtag+3)*86400))'
,
$smon
,
$ges
,
"wtag DESC LIMIT 50"
);
echo_admin_site_statistik (
'Besucher nach Uhrzeit'
,
'stunde'
,
$smon
,
$ges
,
"schl ASC LIMIT 50"
);
echo_admin_site_statistik (
'Besucher nach Browsern'
,
'browser'
,
$smon
,
$ges
,
"schl DESC LIMIT 50"
);
echo_admin_site_statistik (
'Besucher nach Betriebssytemen'
,
'os'
,
$smon
,
$ges
,
"schl DESC LIMIT 50"
);
echo_admin_site_statistik (
'Besucher nach Herkunft'
,
'ref'
,
$smon
,
$ges
,
"wert DESC LIMIT 50"
);
echo
'</table>'
;
break
;
}
?>