Chat

header(); # script version $scriptVersion = 11; $scriptUpdate = 'L'; # statistik wird bereinigt. $mon = date('n'); $lastmon = $mon - 1; $jahr = date('Y'); $lastjahr = $jahr; if ( $lastmon <= 0 ) { $lastmon = 12; $lastjahr = $jahr - 1; } db_query("DELETE FROM prefix_stats WHERE NOT ((mon = $mon OR mon = $lastmon) AND (yar = $jahr OR yar = $lastjahr))"); db_query("OPTIMIZE TABLE prefix_stats"); $um = $menu->get(1); switch($um) { default : { ?>

Willkommen bei ilchClan - Administration!

Ein Überblick über alle Inhalte Admin Konfiguration Navigation Backup Ranks Smiles Newsletter Versions Kontrolle Server Konfiguration Statistik Besucher Seite Online Clanbox Lastwars Nextwars Awards Kasse Rules History Teams Trainzeiten User Verwalten Grundrechte Profilefelder neuen User Content News Forum Downloads Links Gallery Umfrage Kalender Kontakt Impressum Eigene Box/Page Gästebuch Boxen PicOfX Partner Module 0) { echo ' '; while ($modrow = db_fetch_object($modabf)) { if (file_exists('include/images/icons/admin/'.$modrow->url.'.png')) { $bild = 'include/images/icons/admin/'.$modrow->url.'.png'; } else { $bild = 'include/images/icons/admin/na.png'; } echo ' '.$modrow->name.' '."n"; } echo ' '; } ?>

Versionskontrolle

'; echo 'Scripte Version: '.$scriptVersion.'
Update Version: '.$scriptUpdate.'

'; echo ''; #echo ''; break; } ##################################### 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 ''.$title.''; 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).'...'; } echo ''.$name.''; echo '

---

'; echo ''.$prozent.'%'; echo ''.$wert.''; } } // ICON Anzeige... echo '

Besucher Statistik

'; echo 'Übersicht | letzter Monat | dieser Monat'; $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 '

Gesamt diesen Monat: '.$ges.''; echo ' '; 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 ' '; break; } case 'userOnline' : { ?>

Online Statistik

Username	Letzte aktivitaet	IP-Adresse	Anbieter

$m) { $m = $r[0]; } } return ($m); } function echo_admin_site_uebersicht ($schl, $wert, $max, $ges) { $wert = ( empty($wert) ? 1 : $wert ); $weite = ($wert / $max ) * 100; $prozent = ($wert * 100) / $ges; $prozent = number_format(round($prozent,2), 2, ',', ''); $name = $schl; if ( strlen ( $name ) >= 50 ) { $name = substr($name,0,50).'...'; } echo ''.$name.''; echo '

---

'; echo ''.$prozent.'%'; echo ''.$wert.''; } // ICON Anzeige... echo '

Besucher Statistik

'; echo 'Übersicht | letzter Monat | dieser Monat'; echo '

'; echo '

Nach Tagen (letzten 5 Monate): '; echo ' '; $max = db_result(db_query("SELECT MAX(`count`) FROM prefix_counter"),0); $ges = db_result(db_query("SELECT SUM(`count`) FROM prefix_counter"),0); $erg = db_query("SELECT `count` as sum, DATE_FORMAT(`date`, '%d.%m.%Y') as datum FROM prefix_counter ORDER BY `date` DESC"); while ($r = db_fetch_assoc($erg)) { echo_admin_site_uebersicht ($r['datum'], $r['sum'], $max, $ges); } echo ' '; echo '

Nach Monaten: '; echo ' '; $max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY MONTH(`date`), YEAR(`date`)"); $erg = db_query("SELECT SUM(`count`) as sum, MONTH(`date`) as monat, YEAR(`date`) as jahr FROM prefix_counter GROUP BY monat, jahr ORDER BY jahr DESC, monat DESC"); while ($r = db_fetch_assoc($erg)) { echo_admin_site_uebersicht ((strlen($r['monat'])==1?'0':'').$r['monat'].'.'.$r['jahr'], $r['sum'], $max, $ges); } echo ' '; echo '

Nach Jahren: '; echo ' '; $max = get_max_from_x("SELECT SUM(`count`) FROM prefix_counter GROUP BY YEAR(`date`)"); $erg = db_query("SELECT SUM(`count`) as sum, YEAR(`date`) as jahr FROM prefix_counter GROUP BY jahr ORDER BY jahr DESC"); while ($r = db_fetch_assoc($erg)) { echo_admin_site_uebersicht ($r['jahr'], $r['sum'], $max, $ges); } echo ' '; echo '

'; break; } case 'siteStatistik' : { ########################################## function forum_statistic_show ($sql,$ges) { $erg = db_query($sql); echo ' '; while ($r = db_fetch_row($erg)) { # str_repeat('|',abs($row['regs'] / 2)) echo ' '; } echo '

'.$r[1].'

'.str_repeat('|',$r[0]).' '.$r[0].'

'; } // ICON Anzeige... echo '

Seiten Statistik

'; echo '

'; $heute = mktime(0,0,0,date('m'),date('d'),date('Y')); $anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute),0,0); echo 'Gesamt Posts heute: '.$anzheute.' '; # aktivsten user $sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10"; echo 'Aktivsten User heute '; forum_statistic_show($sql,$anzheute); # aktivsten themen $sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10"; echo ' Aktivsten Themen heute '; forum_statistic_show($sql,$anzheute); # aktivsten foren $sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10"; echo ' Aktivsten Foren heute '; forum_statistic_show($sql,$anzheute); # neue user heute $gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute),0,0); $sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10"; echo ' Neue User heute '; forum_statistic_show($sql,$gsh); echo '

'; $heute1 = mktime(0,0,0,date('m'),date('d')-1,date('Y')); $anzheute = db_result(db_query("SELECT COUNT(*) FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute),0,0); echo 'Gesamt Posts gestern: '.$anzheute.' '; # aktivsten user $sql = "SELECT COUNT(*) as kk , erst as vv FROM prefix_posts WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10"; echo 'Aktivsten User gestern '; forum_statistic_show($sql,$anzheute); # aktivsten themen $sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_topics LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10"; echo ' Aktivsten Themen gestern '; forum_statistic_show($sql,$anzheute); # aktivsten foren $sql = "SELECT COUNT(*) as kk , prefix_forums.name as vv FROM prefix_topics LEFT JOIN prefix_forums ON prefix_forums.id = prefix_topics.fid LEFT JOIN prefix_posts ON prefix_posts.tid = prefix_topics.id WHERE time >= ".$heute1." AND time <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10"; echo ' Aktivsten Foren gestern '; forum_statistic_show($sql,$anzheute); # neue user heute $gsh = db_result(db_query("SELECT COUNT(*) FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute),0,0); $sql = "SELECT COUNT(*) as kk , name as vv FROM prefix_user WHERE regist >= ".$heute1." AND regist <= ".$heute." GROUP BY vv ORDER BY kk DESC LIMIT 10"; echo ' Neue User gestern '; forum_statistic_show($sql,$gsh); echo '

'; echo '

Es ist ganz ehrlich noch mehr geplant

'; ########################################## break; } } $design->footer(); ?>

JugendVerein