<?
/********************************************************************************
* Erweiterte Status Navbox von KC-Cracky - edited by Proggi *
* Version 1.1 *
* Datiert: 10.02.2009 *
* Website http://www.kit-coding.de *
* Hergestellt für PHPKIT Version 1.6.03 und 1.6.1 *
* Weiterverbreitung durch Fremde (auch in modifizierter Form) ist nicht erlaubt *
* Entfernen oder unsichbar machen des Copyrights, wenn vorhanden *
* ist nicht erlaubt *
* Support erhalten Sie ausschliesslich unter folgenden Adressen: *
* http://www.kit-coding.de - http://www.kit-spiele.de *
*********************************************************************************/


#Config ANFANG
// Breite der Navigationsbox - Pixel oder Prozentwerte
$width = '100%';

// Sollen Downloadinfos angezeigt werden? 1 = Ja | 0 = Nein
$showdltable = "0";

// Sollen Artikelinfos angezeigt werden? 1 = Ja | 0 = Nein
$showarttable = "0";

// Sollen Linkinfos angezeigt werden? 1 = Ja | 0 = Nein
$showlnktable = "0";

// Sollen Newsinfos angezeigt werden? 1 = Ja | 0 = Nein
$shownstable = "0";

// Sollen Foreninformationen angezeigt werden? 1 = Ja | 0 = Nein
$showforumstable = "0";

// Soll die Anzahl der GB-Eintraege angezeigt werden? 1 = Ja | 0 = Nein
$showgbstable = "0";

// Soll der Neueste User angezeigt werden? 1 = Ja | 0 = Nein
$shownewuser = "1";

// Soll das Neueste Mitglied angezeigt werden? 1 = Ja | 0 = Nein
$shownewmember = "0";

// Highlightcolor als 6-stelliger HEX-Code
$highlightcolor = "FF0000";

// Wie lange darf ein Username hoechstens sein - Anzahl in Zeichen
$userNameCut = 15;

// Sollen die Seitenzugriffe angezeigt werden? 1 = Ja | 0 = Nein
$showPageImpressions = "1";

// Ende Konfiguration

## Ab hier bitte nichts mehr aendern ##

$phpkit_status = phpkitstatus();

if (is_array($phpkit_status['online_user'])) {
unset($online_list);
$k=1;
foreach($phpkit_status['online_user'] as $userinfo) {
if ($config['user_ghost']!=1 || ($config['user_ghost']==1 && $userinfo['user_ghost']!=1)) {
if ($k>1) $online_list.=', ';
$k++;
}
}
if (isset($online_list)) $online_list.=" ".$lang['and']." ";
}


// Robots-Anzeige von Dooki auf KNW
//---> Gäste by Dooki inkl. Robots
/*
unset($online_robots);
if ($phpkit_status['online_guests']>0) {
if ($phpkit_status['online_guests']==1) {
$online_list.=$phpkit_status['online_guests']." ".$lang['guest'].".";
}else{
$online_list.=$phpkit_status['online_guests']." ".$lang['guests'].".";
}

$online_robots = function_robots_anzeigen($phpkit_status['guests_hash']);
if($online_robots != "") $online_robots = '<b>Aktive Robots:</b><br>'.$online_robots;
}else{
$online_list.=$lang['no']." ".$lang['guests'].".";
}
*/


//---> Gäste by Dooki inkl. Robots


#Newest USER
if (intval($shownewuser) === 1) {
$userinfo = $DB->fetch_array(
$DB->query("SELECT
user_id,
user_nick,
logtime
FROM
".$sqlprefix."_user
ORDER by
user_id DESC
LIMIT
1
"));
$user_name = cutstring(htmlentities($userinfo['user_nick']), $userNameCut);

// Der User ist zwar registriert, aber noch nicht aktiviert
if($userinfo['logtime'] == 0)
$user_name='<span style="color:#cc0000;">'.$user_name.'</span>';

eval ("\$listnewuser= \"".templateinclude("navigation/extnbst/newest_user")."\";");
}
#Begrüßung
if(intval($USER['id']) > 0) {
$since = number_format(((time()-$USER['logtime'])/60),0,",",".");
$time = formattime($USER['logtime'],'','time');
$usernick = htmlentities(cutstring($USER['nick'], 15));
eval ("\$gruss= \"".templateinclude("navigation/extnbst/gruss")."\";");
}else{
$gruss = '';
}

#Zugriffe
if(intval($showPageImpressions) === 1) {
$piCountToday = $DB->fetch_assoc(
$DB->query("SELECT
calender_id,
calender_date,
calender_picount
FROM
".$sqlprefix."_calender
WHERE
calender_id != 1
ORDER BY
calender_id DESC
LIMIT
1
"));
$piCountToday = number_format($piCountToday['calender_picount'],0,",",".");
//$yesterdayID = $DB->num_rows($DB->query("SELECT calender_id FROM ".$sqlprefix."_calender"));
//$yesterdayID = $yesterdayID-1;

$counter_t = $DB->fetch_assoc(
$DB->query("SELECT
calender_counter,
calender_id,
calender_picount
FROM
".$sqlprefix."_calender
WHERE
calender_id!='1'
ORDER by
calender_id DESC
LIMIT
1
"));
$counter_y = $DB->fetch_assoc(
$DB->query("SELECT
calender_id,
calender_counter,
calender_picount
FROM
".$sqlprefix."_calender
WHERE
calender_id<'$counter_t[calender_id]'
and
calender_id!='1'
ORDER by
calender_id DESC
LIMIT
1
"));

$piCountYesterday = $DB->fetch_assoc(
$DB->query("SELECT
calender_id,
calender_counter,
calender_picount
FROM
".$sqlprefix."_calender
WHERE
calender_id = '".$counter_y['calender_id']."'
LIMIT
1
"));
$piCountYesterday = number_format($piCountYesterday['calender_picount'],0,",",".");
$allcounter = $DB->fetch_array(
$DB->query("SELECT
SUM(calender_picount)
FROM
".$sqlprefix."_calender
"));
$allcounter = number_format($allcounter[0],0,",",".");
$rekord = $DB->fetch_array(
$DB->query("SELECT
MAcalender_counter)
FROM
".$sqlprefix."_calender
WHERE
calender_id != '1'
ORDER by
calender_id DESC
"));

}
// Ende Pageimpressions

#Pfeilgrafik UP & DOWN im Vergleich gestern zu heute
if ($phpkit_status['counter_today'] > $phpkit_status['counter_yesterday'])
$difftoyes='<img src="images/extnbst/arrow_up.gif" width="16" height="16" align="left" title="Besucherz&auml;hler steigend zum Vortag" alt="Besucherz&auml;hler steigend zum Vortag" /><span class="small"><b>'.number_format($phpkit_status['counter_today'],0,",",".").'</b></span>';
else
$difftoyes='<img src="images/extnbst/arrow_down.gif" width="16" height="16" align="left" title="Besucherz&auml;hler fallend zum Vortag" alt="Besucherz&auml;hler fallend zum Vortag" /><span class="small"><b>'.number_format($phpkit_status['counter_today'],0,",",".").'</b></span>';

$phpkit_status['counter_yesterday'] = number_format($phpkit_status['counter_yesterday'],0,",",".");
$phpkit_status['counter_total'] = number_format($phpkit_status['counter_total'],0,",",".");
$phpkit_status['user_counter'] = number_format($phpkit_status['user_counter'],0,",",".");

# Liste alle Seiteninfos auf
eval ("\$boxlinks[1]= \"".getTemplate("navigation/extnbst/sitemaininfos")."\";");


$getuserinfo = $DB->query("SELECT
user_nick,
user_id,
user_icqid,
logtime,
user_status
FROM
".$db_tab['user']."
WHERE
user_activate=1
ORDER by
logtime DESC
LIMIT
5
");

while ($userinfo = $DB->fetch_array($getuserinfo)) {
if (isonline($userinfo['user_id'])) $onlinestatus = '<img src="images/extnbst/bullet_green.png" width="12" height="12" alt="Online" title="Online" border="0" />';
else $onlinestatus = '<img src="images/extnbst/bullet_red.png" width="12" height="12" alt="'.htmlentities($userinfo['user_nick']).' ist offline" title="'.htmlentities($userinfo['user_nick']).' ist offline" border="0" />';

$usernick=cutstring(htmlentities($userinfo['user_nick']), $userNameCut);
$userlogtime = date("H:i", $userinfo['logtime']);

if($userinfo['user_status'] == 'admin') {
$fontStyle = 'color:#cc0000;';


}elseif($userinfo['user_status'] == 'vip') {
$fontStyle = 'color:#cc00cc;';
}else{
$fontStyle = '';
}
eval ("\$zonline_row.= \"".templateinclude("navigation/extnbst/zonline_row")."\";");
}
eval ("\$zonline= \"".templateinclude("navigation/extnbst/zonline")."\";");

if (is_array($phpkit_status['online_user'])) {
unset($online_user);
$online_usercount=count($phpkit_status['online_user']);
foreach($phpkit_status['online_user'] as $userinfo) {
if ($online_user) $online_user.=', ';

if ($userinfo['user_status'] == 'admin' && $userinfo['user_id'] == 1) {
$mainadmin.='<a href="http://wwp.icq.com/scripts/search.dll?to=$userinfo[user_icqid]"><img border=0 alt="$userinfo[user_nick] zu deiner ICQ-Contact-list hinzufügen" src="http://web.icq.com/whitepages/online?icq=$userinfo[user_icqid]&img=5" width="18" height="18"></a>&nbsp;<a class="small" href="include.php?path=login/userinfo.php&amp;id='.$userinfo['user_id'].'"> '.$userinfo['user_nick'].'</a>';
}elseif ($userinfo['user_status']=='admin' && $userinfo['user_id']!=1) {
$admin.='<a href="include.php?path=login/imcenter.php&amp;userid='.$userinfo['user_id'].'"><img src="images/sendim.gif" width="16" height="11" title="IM Message an '.$userinfo['user_nick'].' versenden" alt="IM Message an '.$userinfo['user_nick'].' versenden" border="0" align="absmiddle" /></a>&nbsp;<a class="small" href="include.php?path=login/userinfo.php&amp;id='.$userinfo['user_id'].'"> '.$userinfo['user_nick'].'</a><br />';



}
//VIP Status erweiterung muss installiert sein, sonst nicht aktivieren! ANFANG
#elseif ($userinfo['user_status']=='vip'){
# $VIP.='<a href="include.php?path=login/imcenter.php&amp;userid='.$userinfo['user_id'].'"><img src="images/sendim.gif" width="16" height="11" title="IM Message an '.$userinfo['user_nick'].' versenden" alt="IM Message an '.$userinfo['user_nick'].' versenden" border="0" align="absmiddle" /></a>&nbsp;<a class="small" href="include.php?path=login/userinfo.php&amp;id='.$userinfo['user_id'].'"> '.$userinfo['user_nick'].'</a><br />';
#}
//VIP Status erweiterung muss installiert sein, sonst nicht aktivieren! ENDE
else{
$user.='<a href="http://wwp.icq.com/scripts/search.dll?to=$userinfo[user_icqid]"><img border=0 alt="$userinfo[user_nick] zu deiner ICQ-Contact-list hinzufügen" src="http://web.icq.com/whitepages/online?icq=$userinfo[user_icqid]&img=5" width="18" height="18"></a><a href="include.php?path=login/imcenter.php&amp;userid='.$userinfo['user_id'].'"><img src="images/sendim.gif" width="16" height="11" title="IM Message an '.$userinfo['user_nick'].' versenden" alt="IM Message an '.$userinfo['user_nick'].' versenden" border="0" align="absmiddle" /></a>&nbsp;<a class="small" href="include.php?path=login/userinfo.php&amp;id='.$userinfo['user_id'].'"> '.$userinfo['user_nick'].'</a><br />';
}

}
}
if($phpkit_status['online_guests'] == 0) {
$guestsOnline = 'Keine';
}elseif($phpkit_status['online_guests'] == 1) {
$guestsOnline = 'Einer';
}else{
$guestsOnline = $phpkit_status['online_guests'];
}
eval ("\$boxlinks[2]= \"".getTemplate("navigation/extnbst/online_row")."\";");

#Forum anzeige
if ($config['forum_eod'] == 1 && $showforumstable == "1") {
$counter_post = $DB->fetch_row(
$DB->query("SELECT
COUNT(*)
FROM
".$sqlprefix."_forumpost
"));
$counter_post[0] = number_format($counter_post[0],0,",",".");
$counter_themen = $DB->fetch_row(
$DB->query("SELECT
COUNT(*)
FROM
".$sqlprefix."_forumthread
"));
$counter_themen[0] = number_format($counter_themen[0],0,",",".");

$counter_views_complete = $DB->fetch_assoc(
$DB->query("SELECT
SUM(forumthread_viewcount) as forumthread_viewcount
FROM
".$sqlprefix."_forumthread
"));
$counter_views_complete['forumthread_viewcount'] = number_format($counter_views_complete['forumthread_viewcount'],0,",",".");

eval ("\$listforum= \"".templateinclude("navigation/extnbst/listforum")."\";");
}

#Artikel anzeige
if ($showarttable=="1"){
$art_count = $DB->fetch_row(
$DB->query("SELECT
COUNT(*)
FROM
".$sqlprefix."_content
WHERE
content_option = '1'
AND
content_status = '1'
AND
(content_expire > ".time()." || content_expire = '0')
"));
$art_count[0] = number_format($art_count[0],0,",",".");
$art_klicks = $DB->fetch_row(
$DB->query("SELECT
SUM(content_views)
FROM
".$sqlprefix."_content
WHERE
content_option = '1'
AND
content_status = '1'
AND
(content_expire > ".time()." || content_expire = '0')
"));
$art_klicks[0] = number_format($art_klicks[0],0,",",".");
eval ("\$listart= \"".templateinclude("navigation/extnbst/listartikel")."\";");

}

#News anzeigen
if ($shownstable=="1"){
$news_count = $DB->fetch_row(
$DB->query("SELECT
COUNT(*)
FROM
".$sqlprefix."_content
WHERE
content_option = '2'
AND
content_status = '1'
AND
(content_expire > ".time()." || content_expire = '0')
"));
$news_count[0] = number_format($news_count[0],0,",",".");
$news_klicks = $DB->fetch_row(
$DB->query("SELECT
SUM(content_views)
FROM
".$sqlprefix."_content
WHERE
content_option = '2'
AND
content_status = '1'
AND
(content_expire > ".time()." || content_expire = '0')
"));
$news_klicks[0] = number_format($news_klicks[0],0,",",".");
eval ("\$listns= \"".templateinclude("navigation/extnbst/listnews")."\";");
}

#Links anzeigen
if ($showlnktable=="1"){
$link_count = $DB->fetch_row(
$DB->query("SELECT
COUNT(*)
FROM
".$sqlprefix."_content
WHERE
content_option = '3'
AND
content_status = '1'
AND
(content_expire > ".time()." || content_expire = '0')
"));
$link_count[0] = number_format($link_count[0],0,",",".");
$link_klicks = $DB->fetch_row(
$DB->query("SELECT
SUM(content_views)
FROM
".$sqlprefix."_content
WHERE
content_option = '3'
AND
content_status = '1'
AND
(content_expire > ".time()." || content_expire = '0')
"));
$link_klicks[0] = number_format($link_klicks[0],0,",",".");
eval ("\$listlnk= \"".templateinclude("navigation/extnbst/listlinks")."\";");
}

#Downloads anzeigen
if ($showdltable=="1"){
$down_count = $DB->fetch_row(
$DB->query("SELECT
COUNT(*)
FROM
".$sqlprefix."_content
WHERE
content_option = '4'
AND
content_status = '1'
AND
(content_expire > ".time()." || content_expire = '0')
"));
$down_count[0] = number_format($down_count[0],0,",",".");
$down_klicks = $DB->fetch_row(
$DB->query("SELECT
SUM(content_views)
FROM
".$sqlprefix."_content
WHERE
content_option = '4'
AND
content_status = '1'
AND
(content_expire > ".time()." || content_expire = '0')
"));
$down_klicks[0] = number_format($down_klicks[0],0,",",".");
eval ("\$listdl= \"".templateinclude("navigation/extnbst/listdownloads")."\";");
}

#Gästebuch anzeigen
if ($config['gbook_eod']==1 && $showgbstable=="1") {
$counter_3 = $DB->fetch_row(
$DB->query("SELECT
COUNT(*)
FROM
".$sqlprefix."_gbook
"));
$counter_3[0] = number_format($counter_3[0],0,",",".");
eval ("\$listgb= \"".templateinclude("navigation/extnbst/listgbook")."\";");
}

if($online_robots != "") {
eval ("\$listbots= \"".templateinclude("navigation/extnbst/listrobots")."\";");
}

eval ("\$boxlinks[3]= \"".getTemplate("navigation/extnbst/contentstats")."\";");

return $boxlinks;
?>

<?

$phpkit_status=phpkitstatus();
if (is_array($phpkit_status['online_user'])) {
unset($online_list);
$k=1;
foreach($phpkit_status['online_user'] as $userinfo) {
if ($config['user_ghost']!=1 || ($config['user_ghost']==1 && $userinfo['user_ghost']!=1)) {
if ($k>1) $online_list.=', ';

$k++;
}
}
if (isset($online_list)) $online_list.=" ".$lang['and']." ";
}
if ($phpkit_status['online_guests']>0) {if ($phpkit_status[online_guests]==1) {$online_list.="1 ".$lang['guest'];} else {$online_list.=$phpkit_status[online_guests]." ".$lang['guests'];}}
else {$online_list.=$lang['no']." ".$lang['guests'];}

//Besucher
$boxlinks[1]='<table width="100%" border="0" cellpadding="0" cellspacing="1">
<tr>
<td colspan="2" class="standard" align="center"><b>Besucher</b></td>
</tr>
<tr>
<td width="70%"><font class="small">heute:</font></td>

<td width="30%" align="right"><font class="small">'.$phpkit_status[counter_today].'</font></td>
</tr>
<tr>
<td><font class="small">gestern:</font></td>

<td align="right"><font class="small">'.$phpkit_status[counter_yesterday].'</font></td>
</tr>
<tr>
<td><font class="small">gesamt:</font></td>

<td align="right"><font class="small">'.$phpkit_status[counter_total].'</font></td>
</tr>
<tr>
<td><font class="small">Registrierte User:</font></td>

<td align="right"><font class="small">'.$phpkit_status[user_counter].'</font></td>
</tr>

</table>';

if ($config['user_ghost']==1) $sqlcommand.=' AND user_ghost<>1';
else $sqlcommand='';
$getuserinfo=$DB->query("SELECT user_nick, user_id, user_icqid, logtime FROM ".$db_tab['user']." WHERE user_activate=1 ".$sqlcommand." ORDER by logtime DESC ");
while ($userinfo=$DB->fetch_array($getuserinfo)) {
if (isonline($userinfo['user_id'])) $onlinestatus='online';
else $onlinestatus='offline';
$usernick=htmlentities($userinfo['user_nick']);
$userlogtime = strftime("%H:%i", $userinfo['logtime']);
}
if (is_array($phpkit_status['online_user'])) {
unset($online_user);
$online_usercount=count($phpkit_status['online_user']);
foreach($phpkit_status['online_user'] as $userinfo) {
if ($online_user) $online_user.=', ';

if ($userinfo['user_status']=='admin') {$admin.='<tr><td class="navbgright"><a class="small" href="include.php?path=login/imcenter.php&userid='.$userinfo[user_id].'"> <img src="images/sendim.gif" titel="IM Message an '.$sendeaus_dj.' versenden" alt="IM Message an '.$userinfo[user_nick].' versenden" border="0"></a><a href="http://wwp.icq.com/scripts/search.dll?to=$userinfo[user_icqid]"><img border=0 alt="$userinfo[user_nick] zu deiner ICQ-Contact-list hinzufügen" src="http://status.icq.com/online.gif?web=612220129&img=5" width="15" height="15"></a>&nbsp;<a class="small" style="color : #FFFF00" href="include.php?path=login/userinfo.php&id='.$userinfo[user_id].'"><b><em>'.$userinfo[user_nick].'</em></b></a>&nbsp; </td></tr>'; }



elseif ($userinfo['user_status']=='user') {$gast.='<tr><td class="navbgright"><a class="small" href="include.php?path=login/imcenter.php&userid='.$userinfo[user_id].'"> <img src="images/sendim.gif" titel="IM Message an '.$sendeaus_dj.' versenden" alt="IM Message an '.$userinfo[user_nick].' versenden" border="0"><a href="http://wwp.icq.com/scripts/search.dll?to=$userinfo[user_icqid]"><img border=0 alt="$userinfo[user_nick] zu deiner ICQ-Contact-list hinzufügen" src="http://status.icq.com/online.gif?web=$userinfo[user_id] " width="15" height="15"></a>&nbsp;<a class="small" style="color : #FF0000" href="include.php?path=login/userinfo.php&id='.$userinfo[user_id].'">'.$userinfo[user_nick].'</a>&nbsp; </td></tr>';}


//Ligaleiter
$boxlinks[2]='<table border="0" cellspacing="0" cellpadding="0" width="100%"><tr><td class="standard" align="center"><b>Ligaleiter Online</b><br></td></tr>'.$admin.'</table> ';

//Trainer
$boxlinks[5]='<table border="0" cellspacing="0" cellpadding="0" width="100%"><tr><td class="standard" align="center"><b>Trainer Online</b><br>'.$gast.'</table> ';
}
}
if (intval($USER['id'])>0) {
$online_since=number_format(((time()-$USER['logtime'])/60),0,",",".");
$online_time=formattime($USER['logtime'],'','time');
if (intval($imstatus_info=imstatus())>0) eval ("\$status_newim.= \"".getTemplate("navigation/status_newim")."\";");
// Mein Status
$boxlinks[6]='
<table border="0" cellspacing="0" cellpadding="0" width="100%">
<tr>
<td colspan="2" class="standard" align="center"><font class="small"><b>Meine Online Zeit</b></font></td>
</tr>
<tr>
<td width="50%"><font class="small" nowrap>'.$online_time.' h</font></td>
<td width="50%"><font class="small" nowrap>'.$online_since.' min.</font></td>
</tr>
'.$status_newim.'
</table>';



}

?>