[Web Site] Lineage site by GoBack - Nightvision

[KetChup]

Spoiler

<?
$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('D\, j M Y H\:i',$linha2['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="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><? 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 "1":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="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>

<?
break;

case "2":
?>
<table width="306" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td colspan="2"><div align="center"><img src="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="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="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="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="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="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="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;
?>
<?
}
?>

aonde fica a tal linha 18 ?

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

olha la o trem que aparece como que remove os erros ? pq se eu meche aqui numa coisa ai da erro e acaba complicando tudo

[Dandilo]

Pra saber onde fica cada linha abra no bloco de notas e de "ctrl+g"

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

Mude diacordo com os nomes de suas tabelas

Poder ser que sua tabela esteja assim por EX:
c.charId = char_id = c.char_id

Espero ter ajudado!