ilch.de :: Forum :: Ilch Clan 1.1 :: Fehlersuche und Probleme

admin
1	`<?php # Copyright by: Manuel# Support: www.ilch.dedefined ('main')` `or` `die` `(` `'no direct access'` `);defined ('admin')` `or` `die` `(` `'only admin access'` `);$design` `=` `new` `design (` `'Admins Area',` `'Admins Area', 2 );$design->header();# script version$scriptVersion` `= 11;$scriptUpdate` `=` `'O';# 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` `: { ?><table width="100%"` `border="0"` `cellspacing="0"` `cellpadding="5"` `class="rand"> <tr` `class="Chead"> <td><b>Willkommen bei ilchClan - Administration!</b></td> </tr> <tr> <td` `class="Cnorm"> <table width="100%"><tr><td valign="top"` `width="100%"> <!-- Hallo, hier können Sie alle möglichen Einstellungen vornehmen. <br /><br /> Wenn Sie Probleme haben sollten, oder irgendwie nicht weiter wissen, bitte kommen Sie uns doch auf <a href="http://www.ilch.de"` `target="_blank">www.ilch.de</a> besuchen, damit wir Ihnen helfen können. <br /><br /> Auch wenn Sie Verbesserungswünsche oder eine geniale Idee haben, freuen wir uns über jeden Vorschlag. <br /><br /> und jetzt <b>viel Spass mit dem Script!</b> --> <!-- </td><td valign="top"` `width="60%"> --> <br /> <h3 style="display:inline;">Ein Überblick über alle Inhalte</h3> <script type="text/javascript">` `function` `toggle_mimg() { class_name = document.getElementById('cpm').className;` `if(class_name ==` `"admix") { class_name =` `"admix_n"; link_text =` `"Symbol-Ansicht"; }` `else` `{ class_name =` `"admix"; link_text =` `"Listen-Ansicht"; } document.getElementById('cpm').className = class_name; document.getElementById('list_toggle').innerHTML = link_text; } </script> <ul id="cpm"` `class="admix"> <li` `class="admix_box">Admin<br /> <ul> <li><a href="admin.php?allg"><img src="include/images/icons/admin/konfiguration.png"` `alt="">Konfiguration</a></li> <?php` `if` `($allgAr['mail_smtp']) { ?> <li><a href="admin.php?smtpconf"><img src="include/images/icons/admin/smtpconf.png"` `alt="">SMTP konfigurieren</a></li> <?php } ?> <li><a href="admin.php?menu"><img src="include/images/icons/admin/navigation.png"` `alt="">Navigation</a></li> <li><a href="admin.php?backup"><img src="include/images/icons/admin/backup.png"` `alt="">Backup</a></li> <li><a href="admin.php?range"><img src="include/images/icons/admin/ranks.png"` `alt="">Ranks</a></li> <li><a href="admin.php?smilies"><img src="include/images/icons/admin/smilies.png"` `alt="">Smiles</a></li> <li><a href="admin.php?newsletter"><img src="include/images/icons/admin/newsletter.png"` `alt="">Newsletter</a></li> <li><a href="admin.php?admin-versionsKontrolle"><img src="include/images/icons/admin/version_check.png"` `alt="">Versions Kontrolle</a></li> <li><a href="admin.php?checkconf"><img src="include/images/icons/admin/version_check.png"` `alt="">Server Konfiguration</a></li> <br` `class="admix_last"/> </ul> </li> <li` `class="admix_box">Statistik<br /> <ul> <li><a href="admin.php?admin-besucherStatistik"><img src="include/images/icons/admin/stats_visitor.png"` `alt="">Besucher</a></li> <li><a href="admin.php?admin-siteStatistik"><img src="include/images/icons/admin/stats_site.png"` `alt="">Seite</a></li> <li><a href="admin.php?admin-userOnline"><img src="include/images/icons/admin/stats_online.png"` `alt="">Online</a></li> <br` `class="admix_last"/> </ul> </li> <li` `class="admix_box">Clanbox<br /> <ul> <li><a href="admin.php?wars-last"><img src="include/images/icons/admin/wars_last.png"` `alt=""` `/>Lastwars</a></li> <li><a href="admin.php?wars-next"><img src="include/images/icons/admin/wars_next.png"` `alt=""` `/>Nextwars</a></li> <li><a href="admin.php?awards"><img src="include/images/icons/admin/awards.png"` `alt=""` `/>Awards</a></li> <li><a href="admin.php?kasse"><img src="include/images/icons/admin/kasse.png"` `alt=""` `/>Kasse</a></li> <li><a href="admin.php?rules"><img src="include/images/icons/admin/rules.png"` `alt=""` `/>Rules</a></li> <li><a href="admin.php?history"><img src="include/images/icons/admin/history.png"` `alt=""` `/>History</a></li> <li><a href="admin.php?groups"><img src="include/images/icons/admin/teams.png"` `alt=""` `/>Teams</a></li> <li><a href="admin.php?trains"><img src="include/images/icons/admin/training_times.png"` `alt=""` `/>Trainzeiten</a></li> <br` `class="admix_last"/> </ul> </li> <li` `class="admix_box">User<br /> <ul> <li><a href="admin.php?user"><img src="include/images/icons/admin/user.png"` `alt="">Verwalten</a></li> <li><a href="admin.php?grundrechte"><img src="include/images/icons/admin/user_rights.png"` `alt="">Grundrechte</a></li> <li><a href="admin.php?profilefields"><img src="include/images/icons/admin/user_profile_fields.png"` `alt="">Profilefelder</a></li> <li><a href="javascript: createNewUser();"><img src="include/images/icons/admin/user_add.png"` `alt="">neuen User</a></li> <br` `class="admix_last"/> </ul> </li> <li` `class="admix_box">Content<br /> <ul> <li><a href="admin.php?news"><img src="include/images/icons/admin/news.png"` `alt="">News</a></li> <li><a href="admin.php?forum"><img src="include/images/icons/admin/forum.png"` `alt="">Forum</a></li> <li><a href="admin.php?archiv-downloads"><img src="include/images/icons/admin/downloads.png"` `alt="">Downloads</a></li> <li><a href="admin.php?archiv-links"><img src="include/images/icons/admin/links.png"` `alt="">Links</a></li> <li><a href="admin.php?gallery"><img src="include/images/icons/admin/gallery.png"` `alt="">Gallery</a></li> <li><a href="admin.php?vote"><img src="include/images/icons/admin/vote.png"` `alt="">Umfrage</a></li> <li><a href="admin.php?kalender"><img src="include/images/icons/admin/calendar.png"` `alt="">Kalender</a></li> <li><a href="admin.php?contact"><img src="include/images/icons/admin/contact.png"` `alt="">Kontakt</a></li> <li><a href="admin.php?impressum"><img src="include/images/icons/admin/imprint.png"` `alt="">Impressum</a></li> <li><a href="admin.php?selfbp"><img src="include/images/icons/admin/self_page_box.png"` `alt="">Eigene Box/Page</a></li> <li><a href="admin.php?gbook"><img src="include/images/icons/admin/guestbook.png"` `alt="">Gästebuch</a></li> <br` `class="admix_last"/> </ul> </li> <li` `class="admix_box">Boxen<br /> <ul> <li><a href="admin.php?picofx"><img src="include/images/icons/admin/picofx.png"` `alt="">PicOfX</a></li> <li><a href="admin.php?archiv-partners"><img src="include/images/icons/admin/partners.png"` `alt="">Partner</a></li> <br` `class="admix_last"/> </ul> </li> <li` `class="admix_box">Module <?php` `$modabf` `= db_query(`"SELECT * FROM `prefix_modules` WHERE ashow = 1"`);` `if` `(db_num_rows($modabf) > 0) {` `echo` `'<br /><ul>';` `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` `'<li><a href="admin.php?'.$modrow->url.'"><img src="'.$bild.'" alt="">'.$modrow->name.'</a></li>'."\n"; }` `echo` `'<br class="admix_last"/></ul>'; } ?> </li> </ul> </td></td></table> </td> </tr></table> <?php` `break; }` `case` `'versionsKontrolle'` `: { // ICON Anzeige...` `echo` `'<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/version_check.png" /></td><td width="30"></td><td valign="bottom"><h1>Versionskontrolle</h1></td></tr></table>';` `echo` `'Scripte Version: '.$scriptVersion.'<br />Update Version: '.$scriptUpdate.'<br /><br />';` `echo` `'<script language="JavaScript" type="text/javascript" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></script>'; #echo` `'<iframe width="100%" height="60" src="http://www.ilch.de/down/ilchClan/update.php?version='.$scriptVersion.'&update='.$scriptUpdate.'"></iframe>';` `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` `'<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>'; } } // ICON Anzeige...` `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; }` `case` `'userOnline'` `: { ?> <table cellpadding="0"` `cellspacing="0"` `border="0"><tr><td><img src="include/images/icons/admin/stats_online.png"` `/></td><td width="30"></td><td valign="bottom"><h1>Online Statistik</h1></td></tr></table> <table border="0"` `cellpadding="2"` `cellspacing="1"` `class="border"> <tr` `class="Chead"> <th>Username</th> <th>Letzte aktivitaet</th> <th>IP-Adresse</th> <th>Anbieter</th> </tr> <?php` `echo` `user_admin_online_liste(); ?> </table> <?php` `break; }` `case` `'besucherUebersicht'` `: {` `function` `get_max_from_x ($q) {` `$q` `= db_query($q);` `$m` `= 0;` `while($r` `= db_fetch_row($q)) {` `if` `($r[0] >` `$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).'<b>...</b>'; }` `echo` `'<tr class="norm"><td width="150" title="'.$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>'; } // ICON Anzeige...` `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>';` `echo` `'<br /><br /><table cellpadding="0" border="0" cellspacing="0" width="100%">';` `echo` `'<tr><td valign="top" width="33%"><b>Nach Tagen (letzten 5 Monate):</b><br />';` `echo` `'<table cellpadding="0" border="0" cellspacing="0" width="90%">';` `$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` `'</table>';` `echo` `'</td><td valign="top" width="33%"><b>Nach Monaten:</b><br />';` `echo` `'<table cellpadding="0" border="0" cellspacing="0" width="90%">';` `$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` `'</table>';` `echo` `'</td><td valign="top" width="33%"><b>Nach Jahren:</b><br />';` `echo` `'<table cellpadding="0" border="0" cellspacing="0" width="90%">';` `$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` `'</table>';` `echo` `'</td></tr></table>';` `break; }` `case` `'siteStatistik'` `: {##########################################function` `forum_statistic_show ($sql,$ges) {` `$erg` `= db_query($sql);` `echo` `'<table border="0" cellpadding="0" cellspacing="0">';` `while` `($r` `= db_fetch_row($erg)) {#` `str_repeat('\|',abs($row['regs'] / 2))` `echo` `'<tr><td>'.$r[1].'</td><td>'.str_repeat('\|',$r[0]).' '.$r[0].'</td></tr>'; }` `echo` `'</table>';}// ICON Anzeige...echo` `'<table cellpadding="0" cellspacing="0" border="0"><tr><td><img src="include/images/icons/admin/stats_site.png" /></td><td width="30"></td><td valign="bottom"><h1>Seiten Statistik</h1></td></tr></table>';echo` `'<table><tr><td valign="top">';$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.'<br /><hr>';# 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` `'<b>Aktivsten User heute</b><br />';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` `'<hr><b>Aktivsten Themen heute</b><br />';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` `'<hr><b>Aktivsten Foren heute</b><br />';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` `'<hr><b>Neue User heute</b><br />';forum_statistic_show($sql,$gsh);echo` `'</td><td valign="top">';$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.'<br /><hr>';# 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` `'<b>Aktivsten User gestern</b><br />';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` `'<hr><b>Aktivsten Themen gestern</b><br />';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` `'<hr><b>Aktivsten Foren gestern</b><br />';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` `'<hr><b>Neue User gestern</b><br />';forum_statistic_show($sql,$gsh);echo` `'</td></tr></table>';echo` `'<h1>Es ist ganz ehrlich noch mehr geplant :P</h1>';##########################################` `break; } }$design->footer();?>`

Sry besser gehts net bin mit handy gerade :-)

Zuletzt modifiziert von josefcool am 03.04.2013 - 08:00:00

Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Fehlersuche und Probleme » Admin bereich oeffnet sich nicht