Exemplo n.º 1
0
         $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/>";
     }