[PHP] Dual-Class Rankings

[LikeToMove]

I share the same script with NS fix.

Added the option "Not Chosen" if a player reached lvl 31 without a job.

 

<?php

//currently an example, change to your desired infomation
$dbuser = "lmao";
$dbpass = "lmfao";
$dbhost = "127.0.0.1";
$dbname = "lcep2";

//connect to database
$msconn = mysql_connect($dbhost, $dbuser, $dbpass);
$db = mysql_select_db($dbname, $msconn);
mysql_query("set names UTF8");

$q = mysql_query("SELECT a_level, a_class, a_charname, a_job FROM t_characters WHERE a_level>31 ORDER BY a_level DESC");
echo "</pre>
<table width="400" border="0" cellpadding="2" cellspacing="2">LevelNameClass</table>
<font color="#FF0000">Highlander</font>";} <br> elseif ($row["a_class"] == 0 && $row["a_job"] == 2 ) {$class = "<font color="#FF0000">Warmaster</font>";} <br><br> //knight<br> elseif ($row["a_class"] == 1 && $row["a_job"] == 1 ) {$class = "<font color="#0000FF">Royal Knight</font>";} <br> elseif ($row["a_class"] == 1 && $row["a_job"] == 2 ) {$class = "<font color="#0000FF">Templar Knight</font>";} <br><br> //Healer<br> elseif ($row["a_class"] == 2 && $row["a_job"] == 1 ) {$class = "<font color="#008000">Archer</font>";} <br> elseif ($row["a_class"] == 2 && $row["a_job"] == 2 ) {$class = "<font color="#008000">Cleric</font>";} <br><br> //Mage<br> elseif ($row["a_class"] == 3 && $row["a_job"] == 1 ) {$class = "<font color="#800080">Wizard</font>";} <br> elseif ($row["a_class"] == 3 && $row["a_job"] == 2 ) {$class = "<font color="#800080">Witch</font>";} <br><br> //Rogue<br> elseif ($row["a_class"] == 4 && $row["a_job"] == 1 ) {$class = "<font color="#FFA500">Assassin</font>";} <br> elseif ($row["a_class"] == 4 && $row["a_job"] == 2 ) {$class = "<font color="#FFA500">Ranger</font>";}<br><br> //Sorcerer<br> elseif ($row["a_class"] == 5 && $row["a_job"] == 1 ) {$class = "<font color="#9B30FF">Elementalist</font>";} <br> elseif ($row["a_class"] == 5 && $row["a_job"] == 2 ) {$class = "<font color="#9B30FF">Specialist</font>";} <br><br>//Dummy<br>elseif ($row["a_class"] == 0 && $row["a_job"] == 0 ) {$class = "<font color="#9B30FF">Not Chosen</font>";}<br>elseif ($row["a_class"] == 1 && $row["a_job"] == 0 ) {$class = "<font color="#9B30FF">Not Chosen</font>";}<br>elseif ($row["a_class"] == 2 && $row["a_job"] == 0 ) {$class = "<font color="#9B30FF">Not Chosen</font>";}<br>elseif ($row["a_class"] == 3 && $row["a_job"] == 0 ) {$class = "<font color="#9B30FF">Not Chosen</font>";}<br>elseif ($row["a_class"] == 4 && $row["a_job"] == 0 ) {$class = "<font color="#9B30FF">Not Chosen</font>";}<br>elseif ($row["a_class"] == 5 && $row["a_job"] == 0 ) {$class = "<font color="#9B30FF">Not Chosen</font>";}<br><br> //Nightshadow<br> elseif ($row["a_class"] == 6 && $row["a_job"] == 0 ) {$class = "NightShadow";}<br><br><br><br><br> echo "";<br> echo "<font size="3">".$row["a_level"]."</font>";<br> echo "<font size="3">".$row["a_charname"]."</font>";<br> echo "<font size="3">".$class."</font>";<br> }<br> echo "<br>";<br