I need some vote system for trinity 3.3.5 with point and reward or something like that.
The second question is what i do wrong with my online players script, because not work
PHP Code:
<?php
$user = 'root'; // mysql user
$pass = 'pass'; // mysql pass
$characters = 'characters'; // name of the characters db
$ip = '127.0.0.1'; // host adresse (ip)
echo "<table border=1><tr><th>Name</th><th>Class</th><th>Race</th><th>Level</th></tr>";
$connect = mysql_connect($ip, $user, $pass) or die ("Cant connect $ip");
mysql_select_db($characters, $connect) or die ("Cant connect $characters");
$sql = "SELECT `name`,`class`,`race`,CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 54), ' ', -1) AS UNSIGNED) AS `level` FROM `characters` WHERE `online` = 1 ORDER BY `level` DESC";
$result = mysql_query($sql, $connect);
while ($vystup = mysql_fetch_array($result))
{
echo "<tr><td align=\"center\">".$vystup["name"]."</td>";
echo "<td align=\"center\">";
switch ($vystup["class"]):
case 1:
print "<img src=\"img/1.gif\" alt=\"Warrior\">";
break;
case 2:
print "<img src=\"img/2.gif\" alt=\"Paladin\">";
break;
case 3:
print "<img src=\"img/3.gif\" alt=\"Hunter\">";
break;
case 4:
print "<img src=\"img/4.gif\" alt=\"Rogue\">";
break;
case 5:
print "<img src=\"img/5.gif\" alt=\"Priest\">";
break;
case 6:
print "<img src=\"img/6.gif\" alt=\"Death Knight\">";
break;
case 7:
print "<img src=\"img/7.gif\" alt=\"Shaman\">";
break;
case 8:
print "<img src=\"img/8.gif\" alt=\"Mage\">";
break;
case 9:
print "<img src=\"img/9.gif\" alt=\"Warlock\">";
break;
case 11:
print "<img src=\"img/11.gif\" alt=\"Druid\">";
break;
endswitch;
echo "</td><td align=\"center\">";
switch ($vystup["race"]):
case 1:
print "<img src=\"img/1-0.gif\" alt=\"Human\">";
break;
case 2:
print "<img src=\"img/2-0.gif\" alt=\"Oc\">";
break;
case 3:
print "<img src=\"img/3-0.gif\" alt=\"Dwarf\">";
break;
case 4:
print "<img src=\"img/4-0.gif\" alt=\"Night Elf\">";
break;
case 5:
print "<img src=\"img/5-0.gif\" alt=\"Undead\">";
break;
case 6:
print "<img src=\"img/6-0.gif\" alt=\"Tauren\">";
break;
case 7:
print "<img src=\"img/7-0.gif\" alt=\"Gnome\">";
break;
case 8:
print "<img src=\"img/8-0.gif\" alt=\"Troll\">";
break;
case 10:
print "<img src=\"img/10-0.gif\" alt=\"Blood Elf\">";
break;
case 11:
print "<img src=\"img/11-0.gif\" alt=\"Draenei\">";
break;
endswitch;
echo "</td>";
echo "<td>".$vystup["level"]."</td>";
echo "</tr>";
}
mysql_close();
echo "</table>";
?></div>