header(); # script version $scriptVersion = 11; $scriptUpdate = 'H'; # 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 Project: Webdesign - Administration!

Ein Überblick über alle Inhalte

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 erlich noch mehr geplant :P

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