07-09-2011, 12:18 AM
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