Вот собственно код :
PHP код:
<?
error_reporting(E_ERROR);
//Config
$mssql_host = "";
$mssql_login = "";
$mssql_pass = "";
$mssql_db = "";
$rbdisplay = "BOSS"; //ALL - show all raid bosses; BOSS - show only "epic" bosses
//Config
$dbconnect=mssql_connect($mssql_host, $mssql_login, $mssql_pass);
if(!$dbconnect) { echo "Не могу установить соединение с базой. Попробуйте позже."; $dberror=1; }
if($dberror!=1) {
mssql_select_db($mssql_db);
if($rbdisplay=="BOSS"){
$rbselect = mssql_query("SELECT * FROM npc_boss WHERE
npc_db_name='orfen' or
npc_db_name='core' or
npc_db_name='baium' or
npc_db_name='antaras' or
npc_db_name='zaken' or
npc_db_name='valakas' or
npc_db_name='blinding_fire_barakiel' or
npc_db_name='queen_ant'
");
} else {
$rbselect = mssql_query("SELECT * FROM npc_boss");
}
echo "<table width=100% border=1>
<tr><td width=25%>RaidBoss</td><td width=25%>Статус</td><td width=50%>Время последнего фарма</td></tr>";
while ($navrb = mssql_fetch_array($rbselect))
{
echo "<tr><td width=25% align=center>$navrb[npc_db_name]</td><td width=25% align=center>";
if($navrb[alive]==1){ echo "<span style='color:green'>Alive</span>"; } else { echo "<span style='color:red'>Dead</span>"; }
echo "</td><td width=50% align=center>";
if($navrb[time_low]>0){ echo date("j M Y H:i",$navrb[time_low]); } else { echo"--:--"; }
echo "</td></tr>";
}
echo "</table>";
mssql_close();
}
?>