Ahojte mám menší problémik s mojím statusom hráčov neukazuje mi levely asi to je preto lebo je to robené na TBC nie WOTLK... skript je takýto
<?php
$server = "";
$db_user = "";
$db_pass = "";
$database = "";
$conn = mysql_connect($server, $db_user, $db_pass) or die('Connection failed: ' . mysql_error());
//pick a database
mysql_select_db($database, $conn) or die('Select DB failed: ' . mysql_error());
//grab the results
$sql = "SELECT * FROM `characters` WHERE `online` = 1 ORDER BY `name`";
$result = mysql_query($sql, $conn) or die('Query failed: ' . mysql_error());
//since we're grabbing all data, and not count, we'll keep our own count
$count = 0;
//need to loop the results, to get data from all characters
echo "<HTML><HEAD><TITLE>Hraci Online</TITLE></HEAD><BODY>";
echo "<TABLE BORDER=1>";
echo "<TR><TH>Meno</TH><TH>Level</TH><TH>Povolanie</TH><TH>Rasa</TH><TH>Pohlavie</TH></TR>";
while ($character = mysql_fetch_array($result)) {
echo "<TR>";
$char_data = explode(' ',$character['data']);
$char_gender = dechex($char_data[36]);
$char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);
$level = $char_data[34];
$gender = $char_gender{3};
$race=$character['race'];
$class=$character['class'];
echo "<TD>";
if ($race==2 || $race==5 || $race==6 || $race==8) echo "<FONT COLOR=\"#FF0000\">";
if ($race==1 || $race==3 || $race==4 || $race==7) echo "<FONT COLOR=\"#0000FF\">";
echo $character['name'];
echo "</FONT>";
echo "</TD>";
echo "<TD>";
echo $level;
echo "</TD>";
echo "<TD>";
if ($class == 1) echo "Warrior";
if ($class == 2) echo "Paladin";
if ($class == 3) echo "Hunter";
if ($class == 4) echo "Rogue";
if ($class == 5) echo "Priest";
if ($class == 7) echo "Shaman";
if ($class == 8) echo "Mage";
if ($class == 9) echo "Warlock";
if ($class == 11) echo "Druid";
echo "</TD>";
echo "<TD>";
if ($race == 1) echo "Clovek";
if ($race == 2) echo "Orc";
if ($race == 3) echo "Dwarf";
if ($race == 4) echo "NightElf";
if ($race == 5) echo "Undead";
if ($race == 6) echo "Tauren";
if ($race == 7) echo "Gnome";
if ($race == 8) echo "Troll";
echo "</TD>";
echo "<TD>";
if ($gender == 0) echo "Muz";
if ($gender == 1) echo "Zena";
echo "</TD>";
echo "</TR>";
$count++;
}
echo "</TABLE>";
echo $count . " hrac(-ov) online.";
echo "</BODY></HTML>";
?>
Ako by sa to dalo opraviť? diks