in date base dont have npc.sql..
<?php
error_reporting(0);
$servidor = 'localhost'; // MySQL HOST
$usuario = 'root'; // MySQL Login
$senha = ''; // MySQL Senha
$db = 'acis'; // L2JDB
$ip = '127.0.0.1'; // MySQL IP
$con = mysql_connect($servidor, $usuario, $senha) or die(mysql_error());
mysql_select_db($db, $con) or die(mysql_error());
include ("../configs/anti-inject-base64.php");
include ("../configs/anti_inject.php");
?>
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Grand Boss</title>
<link rel="shortcut icon" href="../imagens/favicon2.ico" type="image/x-icon" />
<style type="text/css" media="screen">
body {
background:#000 url(../imagens/page_bg.jpg) left top repeat-x;
color:#fff;
font-family:Arial, Helvetica, sans-serif
}
a:link, a:visited, a:hover {
color:#f2f2f2;
text-decoration:none;
}
a:active {
color:#fff;
text-decoration:underline;
}
.style1 { background-color:#252525 }
.style2 {
color:#900;
font-weight:bold;
}
.style3 { background-color:#353535; }
.style10 { font-size:12px; }
.vivo { color:#0c0; }
.morto { color:#f00; }
.spawn { color:#09f }
.respawntime { color:#f90 }
#table_boss {
border:none;
color:#fff;
width:100%;
}
#table_boss caption { padding:5px 0 }
#table_boss tr td {
text-align:center;
border:1px solid #444;
}
#table_boss tr.t_corpo:hover td {
background-color:#444;
color:#ff0;
font-weight:bold;
}
#table_boss tr.topo {
color:#fff;
font-weight:bold;
font-size:16px;
}
#table_boss tr.topo td {
background-color:#252525;
background:#191919 url(../imagens/menu_hover.png) left bottom repeat-x;
}
#table_boss tr.topo td.t1 { width:40% }
#table_boss tr.topo td.t2 { width:1% }
</style>
</head>
<body>
<a href="bosses.php" title="RaidBoss">Raid Boss</a>
<?php
$raidspawn = mysql_query("SELECT boss_id,respawn_time FROM grandboss_data ORDER BY respawn_time DESC");
$total = mysql_num_rows($raidspawn);
$max_pag = 80;
$paginas = (($total % $max_pag) > 0) ? (int)($total / $max_pag) + 1 : ($total / $max_pag);
if (isset($_GET['pagina'])){
$pagina = (int)$_GET['pagina'];
}else{
$pagina = 1;
}
$pagina = max(min($paginas, $pagina), 1);
$inicio = ($pagina - 1) * $max_pag;
$sql = "SELECT boss_id,respawn_time FROM `grandboss_data` ORDER BY `respawn_time` DESC LIMIT ".$inicio.", ".$max_pag;
$query = mysql_query($sql);
echo '<table id="table_boss" cellpadding="1" cellspacing="0">';
echo '<tr class="topo">
<td class="t1"><span class="respawntime">Raid Boss</span></td>
<td class="t2">Status</td>
</tr>';
while(list($boss_id,$respawn_time) = mysql_fetch_row($query)){
$raidnames = mysql_query("SELECT name,level FROM npc WHERE id = $boss_id");
$text = '<span class="vivo">Alive</span>';
$respawn = '<span class="spawn">Spawn</span>';
if($respawn_time > 0){
$respawntime = date('d/m/Y \\s H:i:s',($respawn_time / 1000));
$text = '<span class="morto">Not Alive</span>';
}
while(list($raidname,$levelup) = mysql_fetch_row($raidnames)){
echo '<tr class="style10 t_corpo">
<td class="style1">'.$raidname.'</td>
<td class="style3">'.$text.'</td>
</tr>';
}
}
?>
</div>
</body>
</html>