[Daniel2]

sql = mysql_query("SELECT char_name, charId, classid, level, id, class_name, SUBSTRING_INDEX(class_name, '_', -1) AS class_name FROM characters, class_list, olympiad_nobles AS o WHERE charId = charId AND id = classid ORDER BY classid, olympiad_points DESC") or die(mysql_error());

mano coloca desse geito acima aii por favor

Spoiler

<?php
$castelo_id = $_GET['id'];

$dono = mysql_query ("SELECT * FROM clan_data WHERE hasCastle='$castelo_id'");
while($linha = mysql_fetch_array ($dono)){
$pega_clan = $linha ['clan_name'];
$pega_lider_id = $linha ['leader_id'];
$pega_clan = $linha ['clan_name'];
}

$lider_clan = mysql_query ("SELECT * FROM characters WHERE charID='$pega_lider_id'");
while($linha3 = mysql_fetch_array ($lider_clan)){
$lider_name = $linha3 ['char_name'];
}

$siege = mysql_query ("SELECT * FROM castle WHERE id='$castelo_id'");
while ($linha2 = mysql_fetch_array($siege)){
$pega_data = date('M d Y h:iA ',$castle['siegeDate']/1000);
}

switch($_GET['id']){

case "5":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="http://www.secretexperience.net/images/aden.jpg" width="149" height="99" /></div></td>
</tr>
<tr>
<td colspan="2"><div align="center">Aden</div></td>
</tr>
<tr>
<td width="119"><div align="right">Dono:</div></td>
<td width="166"><? echo $pega_clan ?></td>
</tr>
<tr>
<td><div align="right">L&iacute;der:</div></td>
<td><?php echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pr&oacute;xima Siege:</div></td>
<td><?php echo $pega_data ?></td>
</tr>
</table>

<?php
break;

case "1":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="http://www.secretexperience.net/images/gludio.jpg" width="149" height="99" /></div></td>
</tr>
<tr>
<td colspan="2"><div align="center">Gludio</div></td>
</tr>
<tr>
<td width="119"><div align="right">Dono:</div></td>
<td width="166"><? echo $pega_clan ?></td>
</tr>
<tr>
<td><div align="right">L&iacute;der:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pr&oacute;xima Siege:</div></td>
<td><? echo $pega_data ?></td>
</tr>
</table>

<?php
break;

case "2":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="http://www.secretexperience.net/images/dion.jpg" width="149" height="99" /></div></td>
</tr>
<tr>
<td colspan="2"><div align="center">Dion</div></td>
</tr>
<tr>
<td width="119"><div align="right">Dono:</div></td>
<td width="166"><? echo $pega_clan ?></td>
</tr>
<tr>
<td><div align="right">L&iacute;der:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pr&oacute;xima Siege:</div></td>
<td><? echo $pega_data ?></td>
</tr>
</table>

<?
break;

case "3":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="http://www.secretexperience.net/images/giran.jpg" width="149" height="99" /></div></td>
</tr>
<tr>
<td colspan="2"><div align="center">Giran</div></td>
</tr>
<tr>
<td width="119"><div align="right">Dono:</div></td>
<td width="166"><? echo $pega_clan ?></td>
</tr>
<tr>
<td><div align="right">L&iacute;der:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pr&oacute;xima Siege:</div></td>
<td><? echo $pega_data ?></td>
</tr>
</table>

<?
break;

case "4":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="http://www.secretexperience.net/images/oren.jpg" width="149" height="99" /></div></td>
</tr>
<tr>
<td colspan="2"><div align="center">Oren</div></td>
</tr>
<tr>
<td width="119"><div align="right">Dono:</div></td>
<td width="166"><? echo $pega_clan ?></td>
</tr>
<tr>
<td><div align="right">L&iacute;der:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pr&oacute;xima Siege:</div></td>
<td><? echo $pega_data ?></td>
</tr>
</table>

<?
break;

case "6":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="http://www.secretexperience.net/images/innadril.jpg" width="149" height="99" /></div></td>
</tr>
<tr>
<td colspan="2"><div align="center">Innadril</div></td>
</tr>
<tr>
<td width="119"><div align="right">Dono:</div></td>
<td width="166"><? echo $pega_clan ?></td>
</tr>
<tr>
<td><div align="right">L&iacute;der:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pr&oacute;xima Siege:</div></td>
<td><? echo $pega_data ?></td>
</tr>
</table>

<?
break;

case "7":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="http://www.secretexperience.net/images/goddard.jpg" width="149" height="99" /></div></td>
</tr>
<tr>
<td colspan="2"><div align="center">Goddard</div></td>
</tr>
<tr>
<td width="119"><div align="right">Dono:</div></td>
<td width="166"><? echo $pega_clan ?></td>
</tr>
<tr>
<td><div align="right">L&iacute;der:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pr&oacute;xima Siege:</div></td>
<td><? echo $pega_data ?></td>
</tr>
</table>

<?
break;

case "8":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="http://www.secretexperience.net/images/rune.jpg" width="149" height="99" /></div></td>
</tr>
<tr>
<td colspan="2"><div align="center">Rune</div></td>
</tr>
<tr>
<td width="119"><div align="right">Dono:</div></td>
<td width="166"><? echo $pega_clan ?></td>
</tr>
<tr>
<td><div align="right">L&iacute;der:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pr&oacute;xima Siege:</div></td>
<td><? echo $pega_data ?></td>
</tr>
</table>

<?
break;

case "9":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="http://www.secretexperience.net/images/schuttgart.jpg" width="149" height="99" /></div></td>
</tr>
<tr>
<td colspan="2"><div align="center">Schuttgart</div></td>
</tr>
<tr>
<td width="119"><div align="right">Dono:</div></td>
<td width="166"><? echo $pega_clan ?></td>
</tr>
<tr>
<td><div align="right">L&iacute;der:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pr&oacute;xima Siege:</div></td>
<td><? echo $pega_data ?></td>
</tr>
</table>

<?
break;
?>
<?
}
?>

ver se pode eu consertei quase tudo rsrsrsrs ushaushuahsuha


OBS: agora se o seu server for interlude nao é charId nao é Obj_Id