<?php
# Copyright by Manuel
# Support www.ilch.de
defined (
'main'
)
or
die
(
'no direct access'
);
if
(
empty
(
$_GET
[
'sum'
])) {
$heute
=
date
(
'Y-m-d'
);
$dif
=
date
(
'Y-m-d H:i:s'
, time() - 60);
$abf
=
"SELECT uid FROM `prefix_online` WHERE uptime > '"
.
$dif
.
"'"
;
$resultID
= db_query(
$abf
);
$guests
= 0;
$guestn
=
$lang
[
'guests'
];
$row
= db_fetch_object(
$resultID
);
$posts
= @db_result(db_query(
"SELECT count(ID) FROM prefix_posts"
),0);
$topic
= @db_result(db_query(
"SELECT count(ID) FROM prefix_topics"
),0);
$gesuser
= @db_result(db_query(
"SELECT count(ID) FROM prefix_user"
),0);
$forums
= @db_result(db_query(
"SELECT count(ID) FROM prefix_forums"
),0);
if
(
$row
->uid == 0) {
$guests
++; }
if
(
$guests
== 1) {
$guestn
=
$lang
[
'guest'
]; }
if
(
$guests
== 0) {
$gaeste
=
'0 '
.
$lang
[
'guests'
]; }
else
{
$gaeste
=
$guests
.
' '
.
$guestn
; }
echo
'Members: <font color="#FF0000">'
.
$gesuser
.
'</font><br />'
;
echo
'Online: <font color="#009900">'
.ges_online().
'</font><br />'
;
echo
'Gäste: <font color="#009900">'
.
$gaeste
.
'</font><br /><hr>'
;
echo
'<strong> '
.
$topic
.
'</strong> Beiträge mit<br />'
;
echo
'<strong> '
.
$posts
.
'</strong> Antworten in<br />'
;
echo
'<strong> '
.
$forums
.
'</strong> Foren<br /><br />'
;
echo
'<a class="box" href="index.php?statistik"><b>... '
.
$lang
[
'more'
].
'</b></a>'
;
}
else
{
$title
=
$allgAr
[
'title'
].
' :: Statistik'
;
$hmenu
=
'Statistik'
;
$design
=
new
design (
$title
,
$hmenu
, 0 );
$design
->header();
$anzahlShownTage
= 7;
echo
'<br /><table width=90%" align="center" class="border" cellpadding="0" cellspacing="1" border="0"><tr><td>'
;
echo
'<table width="100%" border="0" cellpadding="5" cellspacing="0">'
;
echo
'<tr class="Chead"><td colspan="3" align="center"><b>Site Statistik</b></td></tr>'
;
$max_in
= 0;
$ges
= 0;
$dat
=
array
();
$max_width
= 200;
$maxErg
= db_query(
'SELECT MAX(count) FROM `prefix_counter`'
);
$max_in
= db_result(
$maxErg
,0);
$erg
= db_query (
"SELECT count, DATE_FORMAT(date,'%a der %d. %b') as datum FROM `prefix_counter` ORDER BY date DESC LIMIT "
.
$anzahlShownTage
);
while
(
$row
= db_fetch_row(
$erg
) ) {
$value
=
$row
[0];
if
(
empty
(
$value
) ) {
$bwidth
= 0;
}
else
{
$bwidth
=
$value
/
$max_in
*
$max_width
;
$bwidth
=
round
(
$bwidth
,0);
}
echo
'<tr class="Cnorm">'
;
echo
'<td>'
.
$row
[1].
'</td>'
;
echo
'<td><table width="'
.
$bwidth
.
'" border="0" cellpadding="0" cellspacing="0">'
;
echo
'<tr><td height="2" class="border"></td></tr></table>'
;
echo
'</td><td align="right">'
.
$value
.
'</td></tr>'
;
$ges
+=
$value
;
}
$gesBesucher
= db_query(
'SELECT SUM(count) FROM prefix_counter'
);
$gesBesucher
= @db_result(
$gesBesucher
,0);
echo
'<tr class="Cmite"><td colspan="3"><div align="right">'
;
echo
'Wochen Summe: '
.
$ges
.
'</div>'
;
echo
'Besucher Gesamt '
.
$gesBesucher
.
' Maximal '
.
$max_in
.
'<br /><br />'
;
echo
'</td></tr><tr class="Cdark">'
;
echo
'<td colspan="3" align="center">[ <a href="javascript:window.close()">Fenster Schliesen</a> ]</td>'
;
echo
'</tr></table></td></tr></table><br />'
;
$design
->footer();
}
?>