<?
{
include ("config.php");
$query="SELECT * FROM tblGameID1 ORDER BY Lvl*2+STotalBonus DESC";
$result = mssql_query($query,$conn);
if (mssql_num_rows($result) < 1) {
echo "<b>No data in table.</b>";
**
else {
$range = mssql_num_rows($result);
if ($range > 999) { $range = 999; **
echo "<body bgcolor=\"c02022\">";
echo "<table border=\"2\" frame=\"hisides\" rules=\"groups\" bgcolor=\"d03045\">";
echo "<caption><b>Player Ranks</b></caption>";
echo "<colgroup align=\"center\">";
echo "<colgroup align=\"center\">";
echo "<colgroup align=\"center\">";
echo "<colgroup align=\"center\">";
echo "<colgroup align=\"center\">";
echo "<colgroup align=\"center\">";
echo "<colgroup align=\"center\">";
echo "<colgroup align=\"center\">";
echo "<colgroup align=\"center\">";
echo "<colgroup align=\"center\">";
echo "<thead valign=\"top\">";
echo "<tr>";
echo "<th>Rank";
echo "<th>Game ID";
echo "<th>Character Type";
echo "<th>Level";
echo "<th>Strength";
echo "<th>Spirit";
echo "<th>Dexterity";
echo "<th>Power";
echo "<th>Honor";
echo "<th>PK Count";
for ($i=0;$i<$range;$i++) {
$rank = $i + 1;
$f = mssql_fetch_array($result);
if ($f['Face'] == 0)
$char='Philar';
else if ($f['Face'] == 1)
$char='Azlar';
else if ($f['Face'] == 2)
$char='Sadad';
else if ($f['Face'] == 3)
$char='Destino';
else if ($f['Face'] == 4)
$char='Jarexx';
else if ($f['Face'] == 5)
$char='Canon';
else if ($f['Face'] == 6)
$char='Kitara';
else if ($f['Face'] == 7)
$char='Lunarena';
else if ($f['Face'] == 8)
$char='Lavita';
else if ($f['Face'] > 8)
$char='?';
else if ($f['Face'] < 0)
$char='?';
echo "<tr><td>".$rank."<td>".$f['GameID']."<td>".$char."<td>".$f['Lvl']."<td>".$f['Strength']."<td>".$f['Spirit']."<td>".$f['Dexterity']."<td>".$f['Power']."<td>".$f['Fame']."<td>".$f['PKPenaltyCount'];
**
echo "</tr>";
echo "</table>";
**
**
?>
This is my new Rank.php it makes it so you can see the char type too!
You must be registered to see links