Всемя осад.

function _castle()
{

open_table();
echo "<br><center><h3>Статистика по Замкам</h3></center><br>";
close_table();
open_table();
require ("config.php");

// Print top of page

/******** GIRAN *************/
$giranOwner = "Нет хозяина";
$giranSiegeDate = " ... ";
$giranTax ="";
/********* OREN **************/
$orenOwner = "Нет хозяина";
$orenSiegeDate = " ... ";
$orenTax ="";
/********** ADEN **************/
$adenOwner = "Нет хозяина";
$adenSiegeDate = " ... ";
$adenTax ="";
/******** Gludio **************/
$gludioOwner = "Нет хозяина";
$gludioSiegeDate = "...";
$gludioTax ="";

/********** DION ***************/
$dionOwner = "Нет хозяина";
$dionSiegeDate = " ... ";
$dionTax ="";
/******** INNADRIL *************/
$innadrilOwner = "Нет хозяина";
$innadrilSiegeDate = " ... ";
$innadrilTax ="";
/******** GODDARD *************/
$goddardOwner = "Нет хозяина";
$goddardSiegeDate = " ... ";
$goddardTax ="";
/*********************************/
/******** RUNE *************/
$runeOwner = "Нет хозяина";
$runeSiegeDate = " ... ";
$runeTax ="";
/*********************************/
/******** SCHUTTGART *************/
$schuttgartOwner = "Нет хозяина";
$schuttgartSiegeDate = " ... ";
$schuttgartTax ="";
/*********************************/
$result = mysql_query("SELECT castle.name, clan_data.clan_name FROM castle,clan_data WHERE clan_data.hasCastle=castle.id");
while($row= mysql_fetch_array($result,MYSQL_ASSOC)){
switch($row['name']){
case 'Giran':$giranOwner=$row['clan_name'];break;
case 'Oren':$orenOwner=$row['clan_name'];break;
case 'Aden':$adenOwner=$row['clan_name'];break;
case 'Gludio':$gludioOwner=$row['clan_name'];break;
case 'Dion':$dionOwner=$row['clan_name'];break;
case 'Innadril':$innadrilOwner=$row['clan_name'];break;
case 'Goddard':$goddardOwner=$row['clan_name'];break;
case 'Rune':$runeOwner=$row['clan_name'];break;
case 'Schuttgart':$schuttgartOwner=$row['clan_name'];break;
}
}
$result = mysql_query("SELECT name,taxPercent,siegeDate FROM castle");
while($row=mysql_fetch_array($result,MYSQL_ASSOC)){
switch($row['name']){
case 'Giran':$giranTax=$row['taxPercent'].'%';
$giranSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
case 'Oren':$orenTax=$row['taxPercent'].'%';
$orenSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
case 'Aden':$adenTax=$row['taxPercent'].'%';
$adenSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
case 'Gludio':$gludioTax=$row['taxPercent'].'%';
$gludioSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
case 'Dion':$dionTax=$row['taxPercent'].'%';
$dionSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
case 'Innadril':$innadrilTax=$row['taxPercent'].'%';
$innadrilSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
case 'Goddard':$goddardTax=$row['taxPercent'].'%';
$goddardSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
case 'Rune':$runeTax=$row['taxPercent'].'%';
$runeSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
case 'Schuttgart':$SchuttgartTax=$row['taxPercent'].'%';
$SchuttgartSiegeDate=date('D\, j M Y H\:i',$row['siegeDate']/1000);break;
}
}
?>
<table cellpadding=0 cellspacing=0 width="100%" align=center>
<?php /******************************* Aden ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="100%" align=center>
<Tr align=center><td colspan=2><h3>Aden Castle</h3><br><br>
<tr valign=top><td width=200><img src="modules/l2/images/aden.jpg"><td>
<table cellpadding=0 cellspacing=7 width=90% border=0 align=center>
<tr ><td>Дата осады<td>Хозяин замка<td>Налог
<tr><td><?php print $adenSiegeDate;?><td><?php print$adenOwner;?><td><?php print$adenTax;?>
<tr><td colspan=2><br>
<tr ><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='5' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");

while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='5' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/
?>
<?php /******************************* Dion ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="100%" align=center>
<Tr align=center><td colspan=2><h3>Dion Castle</h3><br><br>
<tr valign=top><td width=200><img src="modules/l2/images/dion.jpg"><td>
<table cellpadding=0 cellspacing=7 width=90% border=0 align=center>
<tr ><td>Дата осады<td>Хозяин замка<td>Налог
<tr><td><?php print $dionSiegeDate;?><td><?php print$dionOwner;?><td><?php print$dionTax;?>
<tr><td colspan=2><br>
<tr ><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='2' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");

while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='2' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></tr>';
/********************************************************************************
*/
?>
<?php /******************************* Giran ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="100%" align=center>
<Tr align=center><td colspan=2><h3>Giran Castle</h3><br><br>
<tr valign=top><td width=200><img src="modules/l2/images/giran.jpg"><td>
<table cellpadding=0 cellspacing=7 width=90% border=0 align=center>
<tr ><td>Дата осады<td>Хозяин замка<td>Налог
<tr><td><?php print $giranSiegeDate;?><td><?php print$giranOwner;?><td><?php print$giranTax;?>
<tr><td colspan=2><br>
<tr ><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='3' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");

while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='3' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/
?>
<?php /******************************* Gludio ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="100%" align=center>
<Tr align=center><td colspan=2><h3>Gludio Castle</h3><br><br>
<tr valign=top><td width=200><img src="modules/l2/images/gludio.jpg"><td>
<table cellpadding=0 cellspacing=7 width=90% border=0 align=center>
<tr ><td>Дата осады<td>Хозяин замка<td>Налог
<tr><td><?php print $gludioSiegeDate;?><td><?php print$gludioOwner;?><td><?php print$gludioTax;?>
<tr><td colspan=2><br>
<tr ><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='1' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");

while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='1' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';


/********************************************************************************
*/?>

<?php /******************************* Goddard ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="100%" align=center>
<Tr align=center><td colspan=2><h3>Goddard Castle</h3><br><br>
<tr valign=top><td width=200><img src="modules/l2/images/goddard.jpg"><td>
<table cellpadding=0 cellspacing=7 width=90% border=0 align=center>
<tr ><td>Дата осады<td>Хозяин замка<td>Налог
<tr><td><?php print $goddardSiegeDate;?><td><?php print$goddardOwner;?><td><?php print$goddardTax;?>
<tr><td colspan=2><br>
<tr ><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='7' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");

while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='7' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/?>

<?php /******************************* Innadril ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="100%" align=center>
<Tr align=center><td colspan=2><h3>Innadril Castle</h3><br><br>
<tr valign=top><td width=200><img src="modules/l2/images/innadril.jpg"><td>
<table cellpadding=0 cellspacing=7 width=90% border=0 align=center>
<tr ><td>Дата осады<td>Хозяин замка<td>Налог
<tr><td><?php print $innadrilSiegeDate;?><td><?php print$innadrilOwner;?><td><?php print$innadrilTax;?>
<tr><td colspan=2><br>
<tr ><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='6' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");

while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='6' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/?>

<?php /******************************* Oren ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="100%" align=center>
<Tr align=center><td colspan=2><h3>Oren Castle</h3><br><br>
<tr valign=top><td width=200><img src="modules/l2/images/oren.jpg"><td>
<table cellpadding=0 cellspacing=7 width=90% border=0 align=center>
<tr ><td>Дата осады<td>Хозяин замка<td>Налог
<tr><td><?php print $orenSiegeDate;?><td><?php print$orenOwner;?><td><?php print$orenTax;?>
<tr><td colspan=2><br>
<tr ><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='4' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");

while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='4' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/
?>

<?php /******************************* Rune ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="100%" align=center>
<Tr align=center><td colspan=2><h3>Rune Castle</h3><br><br>
<tr valign=top><td width=200><img src="modules/l2/images/rune.jpg"><td>
<table cellpadding=0 cellspacing=7 width=90% border=0 align=center>
<tr ><td>Дата осады<td>Хозяин замка<td>Налог
<tr><td><?php print $runeSiegeDate;?><td><?php print$runeOwner;?><td><?php print$runeTax;?>
<tr><td colspan=2><br>
<tr ><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='8' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");

while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='8' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table><br><br><br></td></tr>';
/********************************************************************************
*/
?>
<?php /******************************* Schuttgart ***********************************/?>
<tr><td><table cellpadding=0 cellspacing=0 width="100%" align=center>
<Tr align=center><td colspan=2><h3>Schuttgart Castle</h3><br><br>
<tr valign=top><td width=200><img src="modules/l2/images/schuttgart.jpg"><td>
<table cellpadding=0 cellspacing=7 width=90% border=0 align=center>
<tr ><td>Дата осады<td>Хозяин замка<td>Налог
<tr><td><?php print $SchuttgartSiegeDate;?><td><?php print$schuttgartOwner;?><td><?php print$SchuttgartTax;?>
<tr><td colspan=2><br>
<tr ><td colspan=2>Атакующие<td colspan=2>Защищающие
<tr><td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='9' AND type='1'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");

while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
}}?>
<td colspan=2>
<?php
$result = mysql_query("SELECT clan_id FROM siege_clans WHERE castle_id='9' AND type='0'");
while($row=mysql_fetch_array($result))
{
$result2 = mysql_query("SELECT clan_name FROM clan_data WHERE clan_id='$row[0]'");
while($row2=mysql_fetch_array($result2))
{
print $row2[0];print'<br>';
if($row2[0]!="")
{$s11="1";break;}
}
}
if($s11=="1"){print '';}
else
print 'НПС</table></table></td></tr>';
/********************************************************************************
*/