Halli Hallo,
ich poste mal ein Bild und vielleicht kann mir jemand sagen, was das für ein Fehler ist und wie ich den vielleicht beheben kann.
Danke schon mal
Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
Geschlossen |
<?php # Copyright by Manuel # Support www.ilch.de defined ('main') or die ( 'no direct access' ); $count_query_xyzXYZ = 0; function db_connect () { if (defined('CONN')) { return; } define ( 'CONN', @mysql_pconnect(DBHOST, DBUSER, DBPASS)); $db = @mysql_select_db(DBDATE, CONN); if (!CONN) { die('Verbindung nicht möglich, bitte prüfen Sie ihre mySQL Daten wie Passwort, Username und Host<br />'); } if ( !$db ) { die ('Kann Datenbank "'.DBDATE.'" nicht benutzen : ' . mysql_error(CONN)); } } function db_close () { mysql_close ( CONN ); } function db_check_error (&$r, $q) { if (!$r AND mysql_errno(CONN) <> 0 AND function_exists('is_coadmin') AND is_coadmin()) { // var_export (debug_backtrace(), true) echo('<font color="#FF0000">MySQL Error:</font><br>'.mysql_errno(CONN).' : '.mysql_error(CONN).'<br>in Query:<br>'.$q.'<pre>'.debug_bt().'</pre>'); } return ($r); } function db_query ($q) { global $count_query_xyzXYZ; $count_query_xyzXYZ++; if (preg_match ("/^UPDATE `?prefix_\S+`?\s+SET/is", $q)) { $q = preg_replace("/^UPDATE `?prefix_(\S+?)`?([\s\.,]|$)/i","UPDATE `".DBPREF."\\1`\\2", $q); } elseif (preg_match ("/^INSERT INTO `?prefix_\S+`?\s+[a-z0-9\s,\)\(]*?VALUES/is", $q)) { $q = preg_replace("/^INSERT INTO `?prefix_(\S+?)`?([\s\.,]|$)/i", "INSERT INTO `".DBPREF."\\1`\\2", $q); } else { $q = preg_replace("/prefix_(\S+?)([\s\.,]|$)/", DBPREF."\\1\\2", $q); } return (db_check_error(@mysql_query($q, CONN), $q)); } function db_result ($erg, $zeile=0, $spalte=0) { return (mysql_result ($erg,$zeile,$spalte)); } function db_fetch_assoc ($erg) { return (mysql_fetch_assoc($erg)); } function db_fetch_row ($erg) { return (mysql_fetch_row($erg)); } function db_fetch_object ($erg) { return (mysql_fetch_object($erg)); } function db_num_rows ($erg) { return (mysql_num_rows ($erg)); } function db_last_id () { return ( mysql_insert_id (CONN)); } function db_count_query ( $query ) { return (db_result(db_query($query),0)); } function db_list_tables ( $db ) { return (mysql_list_tables ($db, CONN)); } function db_tablename ($db, $i) { return (mysql_tablename ($db, $i)); } function db_check_erg ($erg) { if ($erg == false OR @db_num_rows($erg) == 0) { exit ('Es ist ein Fehler aufgetreten'); } } function db_make_sites ($page ,$where ,$limit ,$link ,$table, $anzahl = NULL) { $hvmax = 4; // hinten und vorne links nach page $maxpage = ''; if ( empty ($MPL) ) { $MPL = ''; } if ( is_null ( $anzahl ) ) { $resultID = db_query ( "SELECT COUNT(*) FROM prefix_".$table." ".$where ); $total = db_result($resultID,0); } else { $total = $anzahl; } if ($limit < $total) { $maxpage = $total / $limit; if (is_double($maxpage)) { $maxpage = ceil($maxpage); } $ibegin = $page - $hvmax; $iende = $page + $hvmax ; $vgl1 = $iende + $ibegin; $vgl2 = ($hvmax * 2) + 1; if ( $vgl1 <= $vgl2 ) { $iende = $vgl2; } $vgl3 = $maxpage - ($vgl2 -1); if ($vgl3 < $ibegin ) { $ibegin = $vgl3; } if ($ibegin < 1) { $ibegin = 1; } if ($iende > $maxpage) { $iende = $maxpage; } $vMPL = ''; if ($ibegin > 1) { $vMPL = '<a href="'.$link.'-p1">«</a> '; } $MPL = $vMPL.'[ '; for($i=$ibegin; $i <= $iende; $i++) { if($i == $page) { $MPL .= $i; } else { $MPL .= '<a href="'.$link.'-p'.$i.'">'.$i.'</a>'; } if ($i != $iende) { $MPL .= ' | '; } } $MPL .= ' ]'; if ($iende < $maxpage) { $MPL .= ' <a href="'.$link.'-p'.$maxpage.'">»</a>'; } } return $MPL; } ?>
<?php defined ('main') or die ( 'no direct access' ); $title = $allgAr['title'].' :: Raidstatistik'; $hmenu = 'Raidstatistik'; $design = new design ( $title , $hmenu ); $design->header(); require_once("include/includes/func/b3k_func.php"); echo '<script src="include/includes/js/b3k.js" language="JavaScript" type="text/javascript"></script>'; button("Start", "index.php?raidstatistik", 0); button("Bosskills", "index.php?raidstatistik-bosskills", 0); button("Instanzen", "index.php?raidstatistik-inztanzen", 0); echo "<br>"; switch($menu->get(1)){ case "bosskills": $tpl = new tpl ('raid/STATISTIK_BOSSE.htm'); $SQL = "SELECT a.bosse, a.img, COUNT(b.id) as kills, MIN(b.time) as firstkill, MAX(b.time) as lastkill, c.name as inzen FROM prefix_raid_bosse AS a, prefix_raid_bosscounter AS b, prefix_raid_inzen AS c WHERE a.id=b.bid AND a.inzen=c.id GROUP BY a.bosse ORDER BY kills DESC"; $res = db_query( $SQL ); $all = db_result(db_query("SELECT COUNT(id) FROM prefix_raid_bosscounter"),0); $kill = db_query("SELECT id FROM prefix_raid_bosse"); $killed = 0; while( $k = db_fetch_assoc( $kill )){ $isKilled = db_result(db_query("SELECT COUNT(id) FROM prefix_raid_bosscounter WHERE id=".$k['id']),0); if( $isKilled > 0 ){ $killed++; } } $r['kills'] = $killed; $r['alle'] = db_result(db_query("SELECT COUNT(id) FROM prefix_raid_bosse"),0); $r['pz'] = pzVortschritsAnzeige( $r['kills'], $r['alle'] ); $tpl->set_ar_out($r,0); #Tab Header $i=0; while( $row = db_fetch_assoc( $res )){ $i++; $tpl->set_out("nr", $i, 1); $row['gruppen1'] = db_result(db_query("SELECT b.gruppen FROM prefix_raid_bosscounter AS a, prefix_raid_gruppen AS b WHERE a.time=".$row['firstkill']." AND a.grpid=b.id"),0); $row['gruppen2'] = db_result(db_query("SELECT b.gruppen FROM prefix_raid_bosscounter AS a, prefix_raid_gruppen AS b WHERE a.time=".$row['lastkill']." AND a.grpid=b.id"),0); $row['firstkill'] = DateFormat("D d.m.Y", $row['firstkill']); $row['lastkill'] = DateFormat("D d.m.Y", $row['lastkill']); $row['CLASS'] = cssClass($row['CLASS']); $row['img'] = ( file_exists("include/images/bosse/".$row["img"]) ? "<img height = 50 src='".$allgAr['domain']."/include/images/bosse/".$row["img"]."'>" : "" ); $row['pz'] = pzVortschritsAnzeige( $row['kills'], $all ); $tpl->set_ar_out( $row, 2); } $tpl->out(3); #Tab footer break; case "inztanzen": $tpl = new tpl('raid/STATISTIK_INIS.htm'); $sql = "SELECT a.id, a.name as inzen, a.img, a.maxbosse, c.info, b.grpsize, d.level, (SELECT COUNT(aa.id) FROM prefix_raid_bosscounter AS aa WHERE aa.iid=a.id) AS cAllKilledBosse, (SELECT COUNT(bb.id) FROM prefix_raid_raid AS bb WHERE bb.inzen=a.id) AS allRaids, ((SELECT COUNT(bb.id) FROM prefix_raid_raid AS bb WHERE bb.inzen=a.id) * a.maxbosse) AS cAllCanKilledBosse, ((SELECT COUNT(dd.id) FROM prefix_raid_bosscounter AS dd WHERE dd.iid=a.id) / a.maxbosse ) AS clear FROM prefix_raid_inzen AS a LEFT JOIN prefix_raid_grpsize AS b ON a.grpsize=b.id LEFT JOIN prefix_raid_info AS c ON a.info=c.id LEFT JOIN prefix_raid_level AS d ON a.level=d.id ORDER BY clear DESC"; $t['pz'] = ""; $tpl->set_ar_out($t,0); #Tab Header $res = db_query( $sql ); $i = 0; while( $row = db_fetch_object($res) ){ if( $row->clear != "0.00" ){ ### Rang $i++; $tpl->set_out("nr", $i, 1); ### Ausgabe $pfad = "include/images/inzen/"; $row->CLASS = cssClass($row->CLASS); $row->img = ( file_exists( $pfad . $img ) ? "<img width='75' src='".$pfad.$row->img."'>" : "n/a" ); $tpl->set_ar_out($row, 2); } } $tpl->out(3); break; default: $db_table_breite = 50; echo "<br>"; db_table( "SELECT a.klassen as Alle_Klassen, COUNT(b.klassen) as anzahl, a.id as del FROM prefix_raid_klassen AS a, prefix_raid_chars AS b WHERE a.id=b.klassen GROUP BY a.klassen ORDER BY anzahl DESC", 0 ); echo "<br>"; db_table( "SELECT a.klassen as Alle_Main_Klassen, COUNT(b.klassen) as anzahl FROM prefix_raid_klassen AS a, prefix_raid_chars AS b WHERE a.id=b.klassen AND b.rang>=4 GROUP BY a.klassen ORDER BY anzahl DESC", 0 ); echo "<br>"; db_table( "SELECT a.rassen, COUNT(b.rassen) as anzahl FROM prefix_raid_rassen AS a, prefix_raid_chars AS b WHERE a.id=b.rassen GROUP BY a.rassen ORDER BY anzahl DESC", 0 ); echo "<br>"; db_table( "SELECT a.berufe as Main_Berufe, COUNT(b.mberuf) as anzahl FROM prefix_raid_berufe AS a, prefix_raid_chars AS b WHERE a.id=b.mberuf GROUP BY a.berufe ORDER BY anzahl DESC", 0 ); echo "<br>"; db_table( "SELECT a.berufe as Second_Berufe, COUNT(b.sberuf) as anzahl FROM prefix_raid_berufe AS a, prefix_raid_chars AS b WHERE a.id=b.sberuf GROUP BY a.berufe ORDER BY anzahl DESC", 0 ); echo "<br>"; db_table( "SELECT a.rang as Ränge, COUNT(b.rang) as anzahl FROM prefix_raid_rang AS a, prefix_raid_chars AS b WHERE a.id=b.rang GROUP BY a.rang ORDER BY a.id DESC", 0 ); break; } copyright(); $design->footer(); ?>
<?php defined ('main') or die ( 'no direct access' ); $title = $allgAr['title'].' :: Raidstatistik'; $hmenu = 'Raidstatistik'; $design = new design ( $title , $hmenu ); $design->header(); require_once("include/includes/func/b3k_func.php"); echo '<script src="include/includes/js/b3k.js" language="JavaScript" type="text/javascript"></script>'; button("Start", "index.php?raidstatistik", 0); button("Bosskills", "index.php?raidstatistik-bosskills", 0); button("Instanzen", "index.php?raidstatistik-inztanzen", 0); echo "<br>"; switch($menu->get(1)){ case "bosskills": $tpl = new tpl ('raid/STATISTIK_BOSSE.htm'); $SQL = "SELECT a.bosse, a.img, COUNT(b.id) as kills, MIN(b.time) as firstkill, MAX(b.time) as lastkill, c.name as inzen FROM prefix_raid_bosse AS a, prefix_raid_bosscounter AS b, prefix_raid_inzen AS c WHERE a.id=b.bid AND a.inzen=c.id GROUP BY a.bosse ORDER BY kills DESC"; $res = db_query( $SQL ); $all = db_result(db_query("SELECT COUNT(id) FROM prefix_raid_bosscounter"),0); $kill = db_query("SELECT id FROM prefix_raid_bosse"); $killed = 0; while( $k = db_fetch_assoc( $kill )){ $ikq = db_query("SELECT COUNT(id) FROM prefix_raid_bosscounter WHERE id=".$k['id']); if (db_num_rows($ikq)) { $isKilled = db_result($ikq); if( $isKilled > 0 ){ $killed++; } } } $r['kills'] = $killed; $r['alle'] = db_result(db_query("SELECT COUNT(id) FROM prefix_raid_bosse"),0); $r['pz'] = pzVortschritsAnzeige( $r['kills'], $r['alle'] ); $tpl->set_ar_out($r,0); #Tab Header $i=0; while( $row = db_fetch_assoc( $res )){ $i++; $tpl->set_out("nr", $i, 1); $qry = db_query("SELECT b.gruppen FROM prefix_raid_bosscounter AS a, prefix_raid_gruppen AS b WHERE a.time=".$row['firstkill']." AND a.grpid=b.id"); $row['gruppen1'] = db_num_rows($qry) ? db_result($qry ,0) : ''; $qry = db_query("SELECT b.gruppen FROM prefix_raid_bosscounter AS a, prefix_raid_gruppen AS b WHERE a.time=".$row['lastkill']." AND a.grpid=b.id"); $row['gruppen2'] = db_num_rows($qry) ? db_result($qry ,0) : ''; $row['firstkill'] = DateFormat("D d.m.Y", $row['firstkill']); $row['lastkill'] = DateFormat("D d.m.Y", $row['lastkill']); $row['CLASS'] = cssClass($row['CLASS']); $row['img'] = ( file_exists("include/images/bosse/".$row["img"]) ? "<img height = 50 src='".$allgAr['domain']."/include/images/bosse/".$row["img"]."'>" : "" ); $row['pz'] = pzVortschritsAnzeige( $row['kills'], $all ); $tpl->set_ar_out( $row, 2); } $tpl->out(3); #Tab footer break; case "inztanzen": $tpl = new tpl('raid/STATISTIK_INIS.htm'); $sql = "SELECT a.id, a.name as inzen, a.img, a.maxbosse, c.info, b.grpsize, d.level, (SELECT COUNT(aa.id) FROM prefix_raid_bosscounter AS aa WHERE aa.iid=a.id) AS cAllKilledBosse, (SELECT COUNT(bb.id) FROM prefix_raid_raid AS bb WHERE bb.inzen=a.id) AS allRaids, ((SELECT COUNT(bb.id) FROM prefix_raid_raid AS bb WHERE bb.inzen=a.id) * a.maxbosse) AS cAllCanKilledBosse, ((SELECT COUNT(dd.id) FROM prefix_raid_bosscounter AS dd WHERE dd.iid=a.id) / a.maxbosse ) AS clear FROM prefix_raid_inzen AS a LEFT JOIN prefix_raid_grpsize AS b ON a.grpsize=b.id LEFT JOIN prefix_raid_info AS c ON a.info=c.id LEFT JOIN prefix_raid_level AS d ON a.level=d.id ORDER BY clear DESC"; $t['pz'] = ""; $tpl->set_ar_out($t,0); #Tab Header $res = db_query( $sql ); $i = 0; while( $row = db_fetch_object($res) ){ if( $row->clear != "0.00" ){ ### Rang $i++; $tpl->set_out("nr", $i, 1); ### Ausgabe $pfad = "include/images/inzen/"; $row->CLASS = cssClass($row->CLASS); $row->img = ( file_exists( $pfad . $img ) ? "<img width='75' src='".$pfad.$row->img."'>" : "n/a" ); $tpl->set_ar_out($row, 2); } } $tpl->out(3); break; default: $db_table_breite = 50; echo "<br>"; db_table( "SELECT a.klassen as Alle_Klassen, COUNT(b.klassen) as anzahl, a.id as del FROM prefix_raid_klassen AS a, prefix_raid_chars AS b WHERE a.id=b.klassen GROUP BY a.klassen ORDER BY anzahl DESC", 0 ); echo "<br>"; db_table( "SELECT a.klassen as Alle_Main_Klassen, COUNT(b.klassen) as anzahl FROM prefix_raid_klassen AS a, prefix_raid_chars AS b WHERE a.id=b.klassen AND b.rang>=4 GROUP BY a.klassen ORDER BY anzahl DESC", 0 ); echo "<br>"; db_table( "SELECT a.rassen, COUNT(b.rassen) as anzahl FROM prefix_raid_rassen AS a, prefix_raid_chars AS b WHERE a.id=b.rassen GROUP BY a.rassen ORDER BY anzahl DESC", 0 ); echo "<br>"; db_table( "SELECT a.berufe as Main_Berufe, COUNT(b.mberuf) as anzahl FROM prefix_raid_berufe AS a, prefix_raid_chars AS b WHERE a.id=b.mberuf GROUP BY a.berufe ORDER BY anzahl DESC", 0 ); echo "<br>"; db_table( "SELECT a.berufe as Second_Berufe, COUNT(b.sberuf) as anzahl FROM prefix_raid_berufe AS a, prefix_raid_chars AS b WHERE a.id=b.sberuf GROUP BY a.berufe ORDER BY anzahl DESC", 0 ); echo "<br>"; db_table( "SELECT a.rang as Ränge, COUNT(b.rang) as anzahl FROM prefix_raid_rang AS a, prefix_raid_chars AS b WHERE a.id=b.rang GROUP BY a.rang ORDER BY a.id DESC", 0 ); break; } copyright(); $design->footer(); ?>
Geschlossen | ||
Zurück zu Fehlersuche und Probleme |