Untitled

<?php
$host="hector.unixmail.org"; // Host name
$username="kinger_wow"; // Mysql username
$password="wowaa1234"; // Mysql password
$db_name="world"; // Database name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$archavonID = 1024039;
$emalonID = 1032246;
$koralonID = 977437;
$toravonID = 1033705;

define("ALIVE", 0);
define("IN_PROGRESS", 1);
define("DEAD", 2);

$sql = "SELECT * FROM inprogress WHERE guid = '{$archavonID}'";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
if($row['inprogress'] == 0)
    $archavonALIVE = ALIVE;
elseif($row['inprogress'] == 1)
    $archavonALIVE = IN_PROGRESS;
elseif($row['inprogress'] == 2)
    $archavonALIVE = DEAD;

$sql = "SELECT * FROM inprogress WHERE guid = '{$emalonID}'";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
if($row['inprogress'] == 0)
    $emalonALIVE = ALIVE;
elseif($row['inprogress'] == 1)
    $emalonALIVE = IN_PROGRESS;
elseif($row['inprogress'] == 2)
    $emalonALIVE = DEAD;

$sql = "SELECT * FROM inprogress WHERE guid = '{$koralonID}'";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
if($row['inprogress'] == 0)
    $koralonALIVE = ALIVE;
elseif($row['inprogress'] == 1)
    $koralonALIVE = IN_PROGRESS;
elseif($row['inprogress'] == 2)
    $koralonALIVE = DEAD;

$sql = "SELECT * FROM inprogress WHERE guid = '{$toravonID}'";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
if($row['inprogress'] == 0)
    $toravonALIVE = ALIVE;
elseif($row['inprogress'] == 1)
    $toravonALIVE = IN_PROGRESS;
elseif($row['inprogress'] == 2)
    $toravonALIVE = DEAD;

$status = array('<font color="green"><b>Alive</b></font>',
                '<font color="orange"><b>In Progress</b>',
                '<font color="red"><b>Dead</b></font>');
?>

<body bgcolor="#2c2c2c">
<font face="Helvetica, Arial, Bitstream Vera Sans, Verdana, sans-serif">
<center>
<font color="white">World Boss Status:</font>
<br />
<font color="white">Archavon - </font><?php echo $status[$archavonALIVE]; ?><font color="white"> |</font>
<font color="white">Emalon - </font><?php echo $status[$emalonALIVE]; ?><font color="white"> |</font>
<font color="white">Koralon - </font><?php echo $status[$koralonALIVE]; ?><font color="white"> |</font>
<font color="white">Toravon - </font><?php echo $status[$toravonALIVE]; ?>
</center>
</font>
</body>