<?php
include("module/stat-menu.php");
mysql_connect($L2JBS_config["mysql_host"],$L2JBS_config["mysql_login"],$L2JBS_config["mysql_password"]) or die('Error MySQL.');
mysql_select_db($L2JBS_config["mysql_db"]) or dir('Error DB.');
//Получàем дàнные èз бàзы
$result = mysql_query("SELECT * FROM `cursed_weapons`") or die(mysql_error());
$row = mysql_num_rows($result);
if($row <= '0') {
echo "No Player with Cursed Weapon.<br>";
}
else {
$result1 = mysql_query("SELECT `ItemId`,`playerId`,`nbkills`,`endTime` FROM `cursed_weapons` ORDER by `nbkills`") or die(mysql_error());
echo "<table border='1'><tr>";
echo "<th class='Stil5'><center>Pos.</center></th>";
echo "<th class='Stil5'><center>Weapon</center></th>";
echo "<th class='Stil5'><center>Character Name</center></th>";
echo "<th class='Stil5'><center>Level</center></th>";
echo "<th class='Stil5'><center>Kills</center></th>";
echo "<th class='Stil5'><center>End Time</center></th>";
echo "</tr>";
$i=1;
while ($row1 = mysql_fetch_row($result1))
{
$result2 = mysql_query("SELECT `char_name`,`level`,`clanid` FROM `characters` WHERE `obj_Id` = '$row1[1]'") or die(mysql_error());
$row2 = mysql_fetch_row($result2);
if($row2[2] >= '1') {
$result3 = mysql_query("SELECT `clan_name` FROM `clan_data` WHERE `clan_id` = '$row1[3]'") or die(mysql_error());
$row3 = mysql_fetch_row($result3);
$clan_name = "<a href='clan_info.php?id=$row2[2]' target='_self'>$row3[0]</a>";
} else {
$clan_name = 'No Clan';
}
$result4 = mysql_query("SELECT `name` FROM `weapon` WHERE `item_id` = '$row1[0]'") or die(mysql_error());
$row4 = mysql_fetch_row($result4);
$timer=$row1[3]/1000;
$datetime=gmstrftime("%H:%M:%S", $timer);
echo "<tr>";
echo "<td class='Stil5'><center>$i</center></td>";
echo "<td class='Stil5'><center>$row4[0]</center></td>";
echo "<td class='Stil5'><center>$row2[0]</center></td>";
echo "<td class='Stil5'><center>$row2[1]</center></td>";
echo "<td class='Stil5'><center>$row1[2]</center></td>";
echo "<td class='Stil5'><center>$datetime</center></td>";
echo "</tr>";
$i++;
}
echo "</table>";
mysql_close();
}
?>
|
