hola, a tod@s veran estoy tratando de reparar una web y justamente en esta web me da este error
(http://imagizer.imageshack.us/v2/xq90/35/t1as.png) (https://imageshack.com/i/0zt1asp)
este es el codigo una ayuda pls
<div id="content"> <div class="postui2 text-title">
<h2>
Ranking
</h2>
</div>
<div class="postui2 text-con">
<div class="con-wrap">
<center>
<?PHP
$CPSeite = 50;
$markierteZeile=0;
if(isset($_GET['p'])) {
if(!checkInt($_GET['p']) || !($_GET['p']>0)) $aSeite = 1;
else $aSeite = $_GET['p'];
}
else { $aSeite = 1; }
if(isset($_POST['suche']) && $_POST['suche']=='suchen') {
if(!empty($_POST['charakter'])) {
$sqlCmd="SELECT id, name, level, exp, empire, guild_name, rang
FROM (
SELECT id, name, level, exp, empire, guild_name, @num := @num +1 AS rang
FROM (
SELECT player.id, player.name, player.level, player.exp, player_index.empire, guild.name AS guild_name, @num :=0
FROM player.player
LEFT JOIN player.player_index ON player_index.id = player.account_id
LEFT JOIN player.guild_member ON guild_member.pid = player.id
LEFT JOIN player.guild ON guild.id = guild_member.guild_id
INNER JOIN account.account ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND
account.status!='BLOCK'
ORDER BY player.level DESC , player.exp DESC
) AS t1
) AS t2
WHERE name LIKE '".mysql_real_escape_string($_POST['charakter'])."' LIMIT 1";
$sqlQry=mysql_query($sqlCmd,$sqlServ);
if(mysql_num_rows($sqlQry)>0) {
$getRang = mysql_fetch_object($sqlQry);
$aSeite = ceil($getRang->rang/$CPSeite);
$markierteZeile = $getRang->rang;
}
}
}
$sqlCmd = "SELECT COUNT(*) AS summeChars
FROM player.player
LEFT JOIN player.player_index
ON player_index.id=player.account_id
LEFT JOIN player.guild_member
ON guild_member.pid=player.id
LEFT JOIN player.guild
ON guild.id=guild_member.guild_id
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC, player.exp DESC";
$sqlQry = mysql_query($sqlCmd, $sqlServ);
$getSum = mysql_fetch_object($sqlQry);
$cSeite = calcPages($getSum->summeChars,$aSeite,$CPSeite);
?>
<form action="index.php?git=rankings" method="POST">
<table>
<tr>
<th class="topLine">Charaktersuche:</th>
<td class="thell" style="text-align:center;"><input type="text" name="charakter" maxlength="20" size="20"/></td>
<td class="tdunkel" style="text-align:center;"><input type="submit" name="suche" value="suchen" maxlength="20" size="20"/></td>
</tr>
</table>
</form>
<?PHP
$maxRange = 5;
$maxStep = 15;
if(($aSeite-$maxRange)>0) $sStart = $aSeite-$maxRange;
else $sStart = 1;
if(($aSeite+$maxRange)<=$cSeite[0]) $sEnde = $aSeite+$maxRange;
else $sEnde = $cSeite[0];
echo '<table>
<tr>
<td class="tdunkel">';
if(($aSeite-$maxStep)>0) echo '<a href="index.php?git=rankings&p='.($aSeite-$maxStep).'">'.($aSeite-$maxStep).'</a> «';
else echo '<a href="index.php?git=rankings&p=1">1</a> «';
echo'</td>';
for($i=$sStart;$i<=$sEnde;$i++) {
$sKlasse = ($i==$aSeite) ? "topLine" : "thell";
echo'<td class="'.$sKlasse.'" style="text-align:center;">';
echo'<a href="index.php?git=rankings&p='.$i.'">'.$i.'</a>';
echo'</td>';
}
echo'<td class="tdunkel" style="text-align:right;">';
if(($aSeite+$maxStep)<=$cSeite[0]) echo '» <a href="index.php?git=rankings&p='.($aSeite+$maxStep).'">'.($aSeite+$maxStep).'</a>';
else echo '» <a href="index.php?git=rankings&p='.$cSeite[0].'">'.$cSeite[0].'</a>';
echo'</td>';
echo'</table>';
?>
<table width="408">
<tr>
<th class="topLine">Platz</th>
<th class="topLine">Charakter</th>
<th class="topLine">Level</th>
<th class="topLine">EXP</th>
<th class="topLine">Gilde</th>
<th class="topLine">Reich</th>
</tr>
<?PHP
$sqlCmd = "SELECT player.id,player.name,player.level,player.exp,player_index.empire,guild.name AS guild_name
FROM player.player
LEFT JOIN player.player_index
ON player_index.id=player.account_id
LEFT JOIN player.guild_member
ON guild_member.pid=player.id
LEFT JOIN player.guild
ON guild.id=guild_member.guild_id
INNER JOIN account.account
ON account.id=player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status!='BLOCK'
ORDER BY player.level DESC, player.exp DESC
LIMIT ".$cSeite[1].",".$CPSeite;
//echo $sqlCmd;
$sqlQry = mysql_query($sqlCmd,$sqlServ);
$x=$cSeite[1]+1;
while($getPlayers = mysql_fetch_object($sqlQry)) {
$zF = ($x%2==0) ? "thell" : "tdunkel";
if(checkInt($markierteZeile) && $markierteZeile==$x) { $zF = "tmarkiert"; }
echo "<tr>";
echo "<td class=\"$zF\">".$x."</td>";
echo "<td class=\"$zF\">".$getPlayers->name."</td>";
echo "<td class=\"$zF\">".$getPlayers->level."</td>";
echo "<td class=\"$zF\">".$getPlayers->exp."</td>";
echo "<td class=\"$zF\">".$getPlayers->guild_name."</td>";
echo "<td class=\"$zF\">";
if(!empty($getPlayers->empire)) {
echo '<img src="img/reiche/'.$getPlayers->empire.'_kl.jpg" title="Reich" alt="Reich"/>';
}
echo "</td>";
echo "</tr>";
$x++;
}
?>
</table></center>
</div>
</div>
<div class="postui2 text-end">
</div></div>
MOD: UTILIZAR ETIQUETA GESHI PARA CÓDIGOS ([code][/code]) LEER REGLAS -> Normas de subforo de Desarrollo Web (http://foro.elhacker.net/desarrollo_web/normas_del_subforo_de_desarrollo_web-t407889.0.html) & Normas del subforo de PHP (https://foro.elhacker.net/php/normas_del_subforo_de_php-t148495.0.html)!
tienes 3 errores... no me fio del todo en el numero de linea porque no copiaste completo...
tienes un error en el identificador de conexion
tienes un error posiblemente consecuencia (no controlaste los errores) de un fetch, es decir, no puede sacar resultados, porque no tiene
tienes una llamada a una funcion que no conoce... tal vez la borraste o escribiste mal...
aprende a leer los errores para resolver esos casos