<?
$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íder:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pró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íder:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pró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íder:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pró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íder:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pró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íder:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pró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íder:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pró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íder:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pró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íder:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Pró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íder:</div></td>
<td><? echo $lider_name ?></td>
</tr>
<tr>
<td><div align="right">Próxima Siege:</div></td>
<td><? echo $pega_data ?></td>
</tr>
</table>
<?
break;
?>
<?
}
?>