habe pimpmyilchadmin installiert, was auch ohne Probleme funktionierte, allerdings bekomme ich folgende Fehlermeldung wenn ich im Adminbereich bin :
Soweit ich das erkennen kann, ist eine Funktion nicht definiert, aber habe keine Ahnung wo ich diese finden kann. Hoffe ihr könnt mir helfen.
Hier noch meine admin.php :
<?php # Copyright by: Manuel Staechele # Support: www.ilch.de defined ('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 = 'M'; # 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 class="border" cellspacing="1" cellpadding="0" width="100%" border="0"> <tr> <td class="Chead" height="20"> Info</td> </tr> <td> <table cellspacing="0" cellpadding="0" width="100%" border="0"> <tr> <td class="Cnorm" align="center" width="20%"> <?php echo getCalendar($mon, $jahr, $url, $urlod, $data, $cellpadding=2);?> </td> <td class="Cnorm" align="center" valign="top" width="60%">Nächsten Geburtstage<hr style="height: 0px; border: dotted #444444 0px; border-top-width: 1px; " /><br> <? include ('include/boxes/geburtstag.php');?> </td> <td class="Cnorm" align="center" width="20%"> <embed src="http://www.clocklink.com/clocks/0008-Orange.swf?TimeZone=WET" width="150" height="150" wmode="transparent" type="application/x-shockwave-flash"> </td> </tr> </table> </td> </tr> </table> <br> <table class="border" cellspacing="1" cellpadding="4" width="100%" border="0"> <tr> <td class="Chead" colspan="4">Statistik</td> </tr> <tr> <td class="Cnorm" width="25%"><font class="smalfont">Design</font></td> <td class="Cnorm" width="25%" nowrap><font class="smalfont"> <? echo $allgAr['gfx']; ?> </font></td> <td class="Cnorm" width="25%"><font class="smalfont">Installierte Version</font></td> <td class="Cnorm" width="25%"><font class="smalfont"> <?php echo ''.$scriptVersion.' Update: '.$scriptUpdate.''; ?> </font></td> </tr> <tr> <td class="Cnorm"><font class="smalfont">Datenbankgröße</font></td> <td class="Cnorm"><font class="smalfont"> <?php // gibt die groesse der Datenbank aus $result = db_query("SHOW TABLE STATUS"); $dbsize = 0; while($row = mysql_fetch_assoc($result)) { $dbsize += $row['Data_length']; }echo nicebytes($dbsize); ?> </font></td> <td class="Cnorm"><font class="smalfont">Downloads</font></td> <td class="Cnorm"><font class="smalfont"> <?php echo nicebytes(dirsize('include/downs/')); ?> </font></td> </tr> <tr> <td class="Cnorm"><font class="smalfont">Benutzer & Gäste online</font></td> <td class="Cnorm"><font class="smalfont"> <?php echo '<b>'.ges_online().'</b> Benutzer und <b>'.ges_gast_online().'</b> Gäste';?> <a class="smalfont" href="admin.php?admin-userOnline">» anzeigen</a></font></td> <td class="Cnorm" nowrap><font class="smalfont">Web Status</font></td> <td class="Cnorm"><font class="smalfont"> <? if ($allgAr['wartung'] == 0){ echo 'Seite Öffentlich'; }else echo '<b>Wartungs Modus</b> <img src="include/images/icons/wartung.png">'; ?> </a></font></td> </tr> <tr> <td class="Cnorm"><font class="smalfont">nicht aktivierte Accounts</font></td> <td class="Cnorm"><font class="smalfont"> <? $gesuser = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 1"),0); echo '<b>'.$gesuser.'</b>'; ?> <a class="smalfont" href="admin.php?puser">» anzeigen</a> </font></td> <td class="Cnorm"nowrap><font class="smalfont">nicht aktivierte Join Us</font></td> <td class="Cnorm"><font class="smalfont"> <? $joinus = @db_result(db_query("SELECT count(name) FROM prefix_usercheck WHERE ak = 4"),0); echo '<b>'.$joinus.'</b>'; ?> <a class="smalfont" href="admin.php?groups-joinus">» anzeigen</a> </font></td> </tr> </table> <br> <table class="border" cellspacing="1" cellpadding="4" width="100%" border="0"> <tr> <td class="Chead" colspan="2">Die neusten Mitglieder</td> <td class="Chead" colspan="2">Die letzten Artikel, News ...</td> </tr> <tr> <td class="Cnorm" colspan="2" valign="top"> <table border="0" cellspacing="0" cellpadding="2" width="100%"> <? $abf = 'SELECT * FROM prefix_user ORDER BY regist DESC LIMIT 5'; $erg = db_query($abf); while ($row = db_fetch_object($erg)) { $regsek = mktime ( 0,0,0, date('m'), date('d'), date('Y') ) - $row->regist; $regday = round($regsek / 86400); $user = $row->name; echo'<tr class="Cnorm"><td><a href="?user-1-'.$row->id.'"><b>'.$user.'</b></a></td><td> Registriert am "'.date('d.m.Y',$row->regist).'"</td></tr>';} ?> </table> </td> <td class="Cnorm" colspan="2" valign="top"> <table border="0" cellspacing="0" cellpadding="2" width="100%"> <? $abf = 'SELECT news_id,news_title FROM `prefix_news` ORDER BY news_time DESC LIMIT 5'; $erg = db_query($abf); while ($row = db_fetch_object($erg) ) { echo'<tr class="Cnorm"><td><a href="?news-edit-'.$row->news_id.'">'.$row->news_title.'</a></td></tr>';} ?> </table> </td> </tr> <tr> <td class="Chead" colspan="4" align="right"><a class="Chead" href="admin.php?about">Systeminformationen</a></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> <br> <table cellpadding="0" cellspacing="0" border="0"><tr><td></td><td width="30"></td><td valign="bottom"><h2>Online</h2></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> <br><br> <table cellpadding="0" cellspacing="0" border="0"><tr><td widht="48"></td><td width="30"></td><td valign="bottom"><h2>Last log Member List</h2></td></tr></table> <table border="0" cellpadding="2" cellspacing="1" class="border"> <tr class="Chead"> <th>Letzte aktivitaet</th> <th>Username</th> </tr> <?php $abf = 'SELECT * FROM prefix_user where recht <= -3 ORDER BY llogin DESC'; $erg = db_query($abf); while ($row = db_fetch_object($erg)) { $datum = date('d.m.y-H:m:s',$row->llogin); $user = $row->name; echo'<tr class="Chead"><td>'.$datum.'</td><td> <a href="?user-1-'.$row->id.'">'.$user.'</a></td></tr>';} ?> </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 erlich noch mehr geplant :P</h1>'; ########################################## break; } } $design->footer(); ?>
verwendete ilchClan Version: 1.1
betroffene Homepage: thft-clan.de