Помогите Пожалуйста С Замками Статусами

<?
$castle_name = array("Gludio Castle",
                     "Dion Castle",
                     "Giran Castle",
                     "Oren Castle",
                     "Aden Castle",
                     "Innadril Castle",
                     "Goddard Castle");

$castle_id = array("1",
                     "2",
                     "3",
                     "4",
                     "5",
                     "6",
                     "7");

$castle_av = array("0",
                     "30",
                     "120",
                     "60",
                     "150",
                     "180",
                     "90");

$result=mssql_query("SELECT *
                     FROM castle as C
                     LEFT OUTER JOIN pledge as P ON (C.pledge_id=P.pledge_id)
                     LEFT OUTER JOIN user_data as U ON (P.ruler_id=U.char_id)
                     ORDER BY id;");

$castles = array();
for ($x=0; $castles[$x]=mssql_fetch_assoc($result); $x++)
{
  if ($castles[$x]["name"]!="")
   $castles[$x]["owner"] = "<a href=?act=clan_info&id=".$castles[$x]["pledge_id"].">".$castles[$x]["name"]."</a>";
  else
   $castles[$x]["owner"] = "NPC";

  if ($castles[$x]["char_name"]=="")
   $castles[$x]["char_name"] = " ";

  if ($castles[$x]["next_war_time"]!=0)
   $castles[$x]["nwt"] = date("d/m/y, H:i", $castles[$x]["next_war_time"]).' ('.date("H:i",$castles[$x]["next_war_time"]-7200).' MSK)';
  else
   $castles[$x]["nwt"] = "Не определена";

}
unset($castles[count($castles)-1]);

for ($x=0; $x<count($castles); $x++)
{
?>

<?
  $result = mssql_query("SELECT *
                         FROM castle_war as C
                         LEFT OUTER JOIN pledge as P ON (C.pledge_id=P.pledge_id)
                         WHERE C.castle_id=".($x+1)." AND type=1 AND P.castle_id=0
                         ORDER BY name");

  $attackers_list = array();
  for ($i=0; $attackers_list[$i]=mssql_fetch_assoc($result); $i++)
   {
    if ($attackers_list[$i]["name"]!="")
     {
      $attackers_list[$i]["clan_n"] .= "<a".$attackers_list[$i]["pledge_id"].">".$attackers_list[$i]["name"]."</a>";
      $attackers_list[$i]["clan_d"] .= date("d/m/y, H:i", $attackers_list[$i]["propose_time"]);
     }
    else
     {
      $attackers_list[$i]["clan_n"] = " ";
      $attackers_list[$i]["clan_d"] = " ";
     }
   }
  unset($attackers_list[count($attackers_list)-1]);

  $result = mssql_query("SELECT *
                         FROM castle_war as C
                         LEFT OUTER JOIN pledge as P ON (C.pledge_id=P.pledge_id)
                         WHERE C.castle_id=".($x+1)." AND type=2 AND P.castle_id=0
                         ORDER BY name");

  $defenders_list = array();
  for ($i=0; $defenders_list[$i]=mssql_fetch_assoc($result); $i++)
   {
    if ($defenders_list[$i]["name"]!="")
     {
      $defenders_list[$i]["clan_n"] .= "<a".$defenders_list[$i]["pledge_id"].">".$defenders_list[$i]["name"]."</a>";
      $defenders_list[$i]["clan_d"] .= date("d/m/y, H:i", $defenders_list[$i]["propose_time"]);
     }
    else
     {
      $defenders_list[$i]["clan_n"] = " ";
      $defenders_list[$i]["clan_d"] = " ";
     }
   }
  unset($defenders_list[count($defenders_list)-1]);

  if (count($attackers_list)>count($defenders_list))
   $z = count($attackers_list);
  else
   $z = count($defenders_list);

  for ($i=0; $i<$z; $i++)
   {
?>