[PHP] Dual-Class Rankings

[Sycohazza]

DEMO: 2

 

This is a rankings script to display the dual classes of players

 

class text color matches the color in game behind and weapon / armor icons

 

Must be above level 31 to be on rankings

 

 

 

 

[rankings.php]

 

<?php

//currently an example, change to your desired infomation
$dbuser = "user";
$dbpass = "pass";
$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_job>0 AND 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>//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>?><br><b

 

 

 

if you want a to limit the amount of people to display

 

$q = mysql_query("SELECT a_level, a_class, a_charname, a_job FROM t_characters WHERE a_job>0 AND a_level>31 ORDER BY a_level DESC LIMIT 50");

 

 

notice

 

DESC LIMIT 50

[Koko]

Great ! Thanks a lot

[Sycohazza]

anyone know why night shadow doesnt show? i have tried countless tries but i dont see why it wont work because its the exact same code as the other classes

[Sycohazza]

nevermind i fixed

[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

[pwner]

The Script does Not work theres only a headline with class name and lvl but there stand no players.

Can someone help me?

[loler]

i have the same problem

[ewsdfgasdf]

here is the ranking but there is stand no name

2

pls help