{php} // Configuration options for MySQL are defined in config.php // Developed by 4HM | Pimp Daddy for the Warcraft 3 Frozen Throne MOD // Will also work with WAR3 MOD 4 Race // Visit http://4honor.net/forum/viewforum.php?f=28 for updates $race = "All"; $number = 50; if(!empty($_POST)){ $race = $_POST['Race']; $number = $_POST['Number']; } require('./war3ftstats_config.php'); {/php} {include file="war3ftstats_header.html"} {literal}

Results:
{/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 "
" . 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 "" . Chr(10); } else{ echo "" . Chr(10); } } {/php} {literal}
RankPlayer NameXPRace
" . $i . "" . $my_row[1] . "" . $my_row[2] . "" . get_race($my_row[3]) . "
" . $i . "" . $my_row[1] . "" . $my_row[2] . "" . get_race($my_row[3]) . "
{/literal}