$charName = char::charnameByCharID($row['CharID']);
echo "<td align='center'>{$n}</td><td align='center'><a href='?pg=rank&type=char&name={$charName}'>{$charName}</a></td><td align='center'>{$jobType}</td><td align='center'>{$row['Exp']}</td><td align='center'>{$row['Contribution']}</td><tr />";
$n++;
}
echo "</table>";
break;
//Job Ranking - Trader Only
//Job Ranking - Trader Only
case 'jobtrader':
core::$sql->changeDB("shard");
$hQuery = core::$sql->exec("select top 50 * from _CharTrijob where JobType = 1 order by Contribution desc, Exp desc, Level desc");
echo "\r\n\t\t<table id='table-3' border='0'>\r\n\t\t<tr>\r\n\t\t<td align='center'><a href='?pg=rank&type=jobtrader'><img src='img/trader-icon.png' alt='Trader'/> Trader</a></td>\r\n\t\t<td align='center'><a href='?pg=rank&type=jobthief'><img src='img/thief-icon.png' alt='Thief'/> Thief</a></td>\r\n\t\t<td align='center'><a href='?pg=rank&type=jobhunter'><img src='img/hunter-icon.png' alt='Hunter'/> Hunter</a></td>\r\n\t\t<td align='center'><a href='?pg=rank&type=job'><img src='img/trader-icon.png' alt='Trader'/><img src='img/hunter-icon.png' alt='Hunter'/><img src='img/thief-icon.png' alt='Thief'/> All</a></td>\r\n\t\t</tr>\r\n\t\t</table>\r\n\r\n\t\t<table id='table-3' border='0' cellpadding='0' cellspacing='0'>\r\n\t\t\t\t<td align='center'>Rank</td><td align='center'>Char name</td><td align='center'>Job type</td><td align='center'>Exp</td><td align='center'>Contribution</td><tr />";
$n = 1;
while ($row = mssql_fetch_array($hQuery)) {
$jobType = char::jobTypeByID($row['JobType']);
$charName = char::charnameByCharID($row['CharID']);
echo "<td align='center'>{$n}</td><td align='center'><a href='?pg=rank&type=char&name={$charName}'>{$charName}</a></td><td align='center'>{$jobType}</td><td align='center'>{$row['Exp']}</td><td align='center'>{$row['Contribution']}</td><tr />";
$n++;
}
echo "</table>";
break;
//Honor Ranking
//Honor Ranking
case 'honor':
core::$sql->changeDB("shard");
$hHonorRank = core::$sql->exec("select * from _TrainingCampHonorRank where CampID IS NOT NULL order by Ranking ASC");
echo "<table id='table-3' border='0' cellpadding='0' cellspacing='0'>\r\n\t\t\t\t<td align='center'>Rank</td><td align='center'>Owner</td><td align='center'>Graduates</td><tr/>\r\n\t\t\t";
while ($row = mssql_fetch_array($hHonorRank)) {
$data = misc::getCampDataByID($row['CampID']);
echo "<td align='center'>{$row['Ranking']}</td><td align='center'><a href='?pg=rank&type=char&name={$data['OwnerName']}'>{$data['OwnerName']}</a></td><td align='center'>{$data['GraduateCount']}</td><tr/>";
}