Обновление статуса рб

<html>
<head>
<body bgcolor="#000000" text="lime" link="#009933" vlink="#009933" padding="0" leftmargin="0">
<font size="2">
<TITLE>Статус Raid Boss Map</TITLE>

<script>
<!--
//enter refresh time in "minutes:seconds" Minutes should range from 0 to inifinity. Seconds should range from 0 to 59
var limit="3:00"

if (document.images){
var parselimit=limit.split(":")
parselimit=parselimit[0]*60+parselimit[1]*1
}
function beginrefresh(){
if (!document.images)
return
if (parselimit==1)
window.location.reload()
else{
parselimit-=1
curmin=Math.floor(parselimit/60)
cursec=parselimit%60
if (curmin!=0)
curtime=curmin+" минуты "+cursec+" секунд до автоматического обновления!"
else
curtime=cursec+" секунд до автоматического обновления!"
window.status=curtime
setTimeout("beginrefresh()",1000)
}
}

window.onload=beginrefresh
//-->
</script>

</head>
<?php
include"connection.php";
?>
<?php
$query_grandbosses=mysql_query("SELECT boss_id,loc_x,loc_y,loc_z,respawn_time FROM grandboss_data");
$online= mysql_num_rows($query_grandbosses);    
$query_raidbosses=mysql_query("SELECT boss_id,loc_x,loc_y,loc_z,respawn_time FROM raidboss_spawnlist");
$online= mysql_num_rows($query_raidbosses);
echo "<div style=position:absolute;top:0px;left:0px><img src=interlude.jpg></div>";
while ($res=mysql_fetch_array($query_raidbosses))
  {
    $id=$res['boss_id'];
    $valx=$res['loc_x'];
    $valy=$res['loc_y'];
    $valz=$res['loc_z'];
    $respawn=$res['respawn_time'];
    $boss_name=mysql_query("SELECT name FROM npc WHERE id='$id'");
    $name = mysql_fetch_row( $boss_name );
    $boss_level=mysql_query("SELECT level FROM npc WHERE id='$id'");
    $level = mysql_fetch_row( $boss_level );
    
  $x=116+($valx+107823)/200;
  $y=2580+($valy-255420 )/200;
  
if($respawn == "0")
    echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=3.png title=\"Level $level[0] $name[0] Жив!\"></div><center>";
else         
    echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=0.png title=\"Level $level[0] $name[0] Убит!\"></div><center>";
    }    
    while ($res=mysql_fetch_array($query_grandbosses))
  {
    $id=$res['boss_id'];
    $valx=$res['loc_x'];
    $valy=$res['loc_y'];
    $valz=$res['loc_z'];
    $respawn=$res['respawn_time'];
    $boss_name=mysql_query("SELECT name FROM npc WHERE id='$id'");
    $name = mysql_fetch_row( $boss_name );
    $boss_level=mysql_query("SELECT level FROM npc WHERE id='$id'");
    $level = mysql_fetch_row( $boss_level );
    
  $x=116+($valx+107823)/200;
  $y=2580+($valy-255420 )/200;
  
if($respawn == "0")
    echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=3.png title=\"Level $level[0] $name[0] Жив!\"></div><center>";
else         
    echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=0.png title=\"Level $level[0] $name[0] Убит!\"></div><center>";
    }    
mysql_close();
?>

<?php
$configdb = array(
"host" => "localhost",
"user" => "root",
"pass" => "root",
"base" => "l2jdb",
);

$link = mysql_connect($configdb["host"],$configdb["user"],$configdb["pass"]) or die("MySQL error");
mysql_select_db($configdb["base"],$link);

echo "
<table width=100% border=0>
<tr>
<td width=50% align=center><b>Рейдбосс(Епик)</td>
<td width=25% align=center><b>Статус</td>
</tr>
";

$query = mysql_query("SELECT raid.boss_id, raid.respawn_time, npc.name, npc.level, npc.hp FROM grandboss_data AS raid INNER JOIN npc ON npc.id = raid.boss_id");

while ($raidData = mysql_fetch_array($query)) {
echo "<tr><td width=25% align=center>".$raidData["name"]."</td>";
echo "<td width=25% align=center><span style='color:green'>".($raidData["respawn_time"]=="0"?"Жив":"Мёртв")."</span></td>";

}

echo "</table>";

mysql_close($link);
?>