<?
function modules_top_onlinelist_main()
{
include_once('funcs/DataBase.php');
$hts = new DataBase('l2jdb','<login>>', '<passwd>');
$list = $hts->get_array("SELECT * FROM `characters` WHERE `online` > ".(time()-1000)." ORDER BY `level` DESC, `char_name`;");
echo "<table cellSpacing=\"0\" class=\"btab\">\n";
echo "<tr><th>№</th><th>Имя пользователя</th><th>Уровень</th><th>Пол</th><th>Класс</th></tr>\n";
$n = 1;
foreach($list as $i)
{
$cs = $hts->get("SELECT * FROM `class_list` WHERE `id` = ".$i['classid']);
echo "<tr>";
echo "<td>$n</td>";
echo "<td><b>{$i['char_name']}</b></td>";
echo "<td>{$i['level']}</td>";
$sex = array(0=>'М', 1=>'Ж');
echo "<td>{$sex[$i['sex']]}</td>";
list($r, $class) = split("_", $cs['class_name']);
$race = array('H'=>'Human', 'E'=>'Elven', 'DE'=>'Dark Elven', 'O'=>'Orc', 'D'=>'Dwarven');
echo "<td>{$race[$r]} $class</td>";
echo "</tr>\n";
$n++;
}
echo "<tr><th colSpan=\"5\">Всего онлайн: ".sizeof($list)."</th></tr>\n";
echo "</table>\n";
}
modules_top_onlinelist_main();
?>