Raid Boss Status/live Map Script

<?php
# SETTINGS
# ----------------------------------------------------------------
# MySql database information.
   $db_host = "127.0.0.1";
   $db_user = "root";  ## username for mysql database
   $db_pass = "********";   ## password for mysql database
   $db_name = "l2jdb";
    
$mysqlport = '3306';

$db = mysql_connect ( $db_host, $db_user, $db_pass ) or die ("Coudn't connect to [$db_host]");
mysql_select_db ( $db_name );  
# -----------------------------------------------------------------
?>
<HTML>
<HEAD>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="description" content="A private server for L2" />
<meta name="keywords" content="L2, Lineage 2 server, Lineage 2, private L2" />
<meta name="author" content="spider661" />
<TITLE>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="10: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+" minutes "+cursec+" seconds to automatic refresh!"
else
curtime=cursec+" seconds to automatic refresh!"
window.status=curtime
setTimeout("beginrefresh()",1000)
}
}

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

<script type="text/javascript" src="tjpzoom.js"></script>  
<script type="text/javascript" src="tjpzoom_config_relative.js"></script>
</HEAD>
<body bgcolor="#ffffff">
<table width="100%" bordercolor="#888888">
<tr>
   <td>
<?php
$current = time()*1000;
$query_boss=mysql_query("SELECT boss_id,loc_x,loc_y,loc_z,respawn_time FROM raidboss_spawnlist");

echo "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>";
echo "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>";
echo "<br><br><br><br><br><br><br><br><br><br><br>";
echo "<div style=position:absolute;top:10px;left:50px>Attention: The dots reveal boss locations throughout the map.<br> Zoom mode only aids in viewing names and towns not zooming the boss.<br>
To view the names run the cursor over the dot's location.<br> Red = dead     Green = alive. <br></div>";
echo "<div style=position:absolute;top:100px;left:40px><img src=interlude.jpg width='724' height='1048' onmouseover=\"TJPzoom(this);\"></div>";
while ($res=mysql_fetch_array($query_boss))
    {
   $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 );
    
   $x=116*0.4+40 +($valx+107823)/200*0.4;
   $y=2580*0.4+100 +($valy-255420)/200*0.4;
if($respawn == "0")
   echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=3.png title=\"$name[0] x:$valx y:$valy z:$valz\"></div><center>";
else if($current >= $respawn)  
   echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=3.png title=\"$name[0] (DEAD!!!) x:$valx y:$valy z:$valz\"></div><center>";  
else if($current < $respawn)  
   echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=0.png title=\"$name[0] (DEAD!!!) x:$valx y:$valy z:$valz\"></div><center>";
   }  
?>
   </td>
</tr>
</table>
</center>
</BODY>
</HTML>

<html>
<head>
<body bgcolor="#000000" text="lime" link="#009933" vlink="#009933" padding="0" leftmargin="0">
<font size="2">  
<TITLE>Live Raid Boss Map - L2 Minonn</TITLE>

<script>
<!--
//enter refresh time in "minutes:seconds" Minutes should range from 0 to inifinity. Seconds should range from 0 to 59
var limit="5: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+" minutes "+cursec+" seconds to automatic refresh!"
else
curtime=cursec+" seconds to automatic refresh!"
window.status=curtime
setTimeout("beginrefresh()",1000)
}
}

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

</head>
<?php
include"connection.php";
?>
<?php
$query_raidbosses=mysql_query("SELECT boss_id,loc_x,loc_y,loc_z,respawn_time FROM raidboss_spawnlist");
$query_grandboss=mysql_query("SELECT boss_id,loc_x,loc_y,loc_z,respawn_time FROM grandboss_spawnlist");
$online= mysql_num_rows($query_raidbosses);
$online2= mysql_num_rows($query_grandboss);
echo "<div style=position:absolute;top:0px;left:0px><img src=map.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] is ALIVE!\"></div><center>";
else    
   echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=0.png title=\"Level $level[0] $name[0] is DEAD!\"></div><center>";
   }
while ($res=mysql_fetch_array($query_grandboss))
    {
   $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] esta VIVO!\"></div><center>";
else    
   echo "<div style=\"position:absolute;top:".$y."px;left:".$x."px\"><img src=0.png title=\"Level $level[0] $name[0] esta MORTO!\"></div><center>";
   }  
mysql_close();
?>

<?php

//Do not remove this header
//This script package is distributed by Enforcer [email protected], this file comes from kadar`s scripts
//You are free to distribute this package as long as the headers stay intact.

//This file must stay in the parent directory of the script folder and must be filled out correctly for the scripts to work.

$db_user = "root"; //your sql username goes here
$db_pass = "root"; //your sql password goes here
$db_name = "l2jdb";    //your database name goes here
$db_serv = "localhost"; //the address of the database goes here

$db = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]");
mysql_select_db ( $db_name );

?>