{/literal}
{php}
function get_race($num){
$race2 = "None";
switch ($num){
case 1:
$race2 = "Undead Scourge";
break;
case 2:
$race2 = "Human Alliance";
break;
case 3:
$race2 = "Orcish Horde";
break;
case 4:
$race2 = "Night Elves of Kalimdor";
break;
case 5:
$race2 = "Blood Mage";
break;
case 6:
$race2 = "Shadow Hunter";
break;
case 7:
$race2 = "Warden";
break;
case 8:
$race2 = "Crypt Lord";
break;
}
return $race2;
}
function returnnum($race){
$returnnum = -1;
switch ($race){
case "All":
$returnnum = 0;
break;
case "Undead Scourge":
$returnnum = 1;
break;
case "Human Alliance":
$returnnum = 2;
break;
case "Orcish Horde":
$returnnum = 3;
break;
case "Night Elf":
$returnnum = 4;
break;
case "Blood Mage":
$returnnum = 5;
break;
case "Shadow Hunter":
$returnnum = 6;
break;
case "Warden":
$returnnum = 7;
break;
case "Crypt Lord":
$returnnum = 8;
break;
}
return $returnnum;
}
$racenum = returnnum($race);
If ($racenum == 0)
$racenum = "";
$LocalConn = mysql_connect($host,$username,$pass) or die("Could not connect : " . mysql_error());
mysql_select_db($dbname) or die("Could not select " . $dbname . " database");
if ($number != "" AND $racenum != "")
$query = "SELECT * FROM `" . $tbname . "` WHERE race = " . $racenum . " ORDER BY xp DESC LIMIT 0, " . $number;
Else if ($number != "")
$query = "SELECT * FROM `" . $tbname . "` ORDER BY xp DESC LIMIT 0, " . $number;
Else if ($racenum != "") {
$query = "SELECT * FROM `" . $tbname . "` WHERE race = " . $racenum . " ORDER BY xp DESC LIMIT 0, 50";
$number = 50;
}
else{
$query = "SELECT * FROM `" . $tbname . "` ORDER BY xp DESC LIMIT 0, 50";
$number = 50;
}
$result = mysql_query($query) or die("Query failed : " . mysql_error());
$recordcount = mysql_num_rows($result);
if($recordcount<1){
$found = 0;
echo "
No record found";
}
else{
$found = 1;
}
echo "Rank | Player Name | XP | Race | " . Chr(10);
echo " | ";
$i = 0;
while($my_row = mysql_fetch_row($result)){
$i = $i + 1;
$my_row[1] = str_replace("<","<",$my_row[1]);
$my_row[1] = str_replace(">",">",$my_row[1]);
$my_row[1] = str_replace("'","'",$my_row[1]);
if (($i % 2) == 0) {
echo "" . $i . " | " . $my_row[1] . " | " . $my_row[2] . " | " . get_race($my_row[3]) . " | " . Chr(10);
}
else{
echo "" . $i . " | " . $my_row[1] . " | " . $my_row[2] . " | " . get_race($my_row[3]) . " | " . Chr(10);
}
}
{/php}
{literal}
|
|
|
|
|