+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Emulation Guides (https://lckb.dev/forum/forumdisplay.php?fid=188)
+----- Thread: [PHP] Dual-Class Rankings (/showthread.php?tid=39)
- Sycohazza - 07-09-2011
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 - 07-10-2011
Great ! Thanks a lot
- Sycohazza - 07-10-2011
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 - 07-11-2011
nevermind i fixed
- LikeToMove - 08-20-2011
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 - 09-01-2011
The Script does Not work theres only a headline with class name and lvl but there stand no players.
Can someone help me?
- loler - 09-03-2011
i have the same problem
- ewsdfgasdf - 09-03-2011
here is the ranking but there is stand no name
2
pls help