11-20-2011, 02:35 AM
Hey Guys i was create a Ranking Script !
User-Rank:
<?php
//currently an example, change to your desired infomation
$dbuser = "root";
$dbpass = "root";
$dbhost = "localhost";
$dbname = "newproject_db";
//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_job, a_nick, a_job2 FROM t_characters WHERE a_job2>0 AND a_level>30 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_job"] == 0 && $row["a_job2"] == 2 ) {$class = "<font color="#FF0000">Warmaster</font>";} <br><br> //knight<br> elseif ($row["a_job"] == 1 && $row["a_job2"] == 1 ) {$class = "<font color="#0000FF">Royal Knight</font>";} <br> elseif ($row["a_job"] == 1 && $row["a_job2"] == 2 ) {$class = "<font color="#0000FF">Templar Knight</font>";} <br><br> //Healer<br> elseif ($row["a_job"] == 2 && $row["a_job2"] == 1 ) {$class = "<font color="#008000">Archer</font>";} <br> elseif ($row["a_job"] == 2 && $row["a_job2"] == 2 ) {$class = "<font color="#008000">Cleric</font>";} <br><br> //Mage<br> elseif ($row["a_job"] == 3 && $row["a_job2"] == 1 ) {$class = "<font color="#800080">Wizard</font>";} <br> elseif ($row["a_job"] == 3 && $row["a_job2"] == 2 ) {$class = "<font color="#800080">Witch</font>";} <br><br> //Rogue<br> elseif ($row["a_job"] == 4 && $row["a_job2"] == 1 ) {$class = "<font color="#FFA500">Assassin</font>";} <br> elseif ($row["a_job"] == 4 && $row["a_job2"] == 2 ) {$class = "<font color="#FFA500">Ranger</font>";}<br><br> //Sorcerer<br> elseif ($row["a_job"] == 5 && $row["a_job2"] == 1 ) {$class = "<font color="#9B30FF">Elementalist</font>";} <br> elseif ($row["a_job"] == 5 && $row["a_job2"] == 2 ) {$class = "<font color="#9B30FF">Specialist</font>";} <br><br> //Nightshadow<br> elseif ($row["a_job"] == 6 && $row["a_job2"] == 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_nick"]."</font>";<br> echo "<font size="3">".$class."</font>";<br> }<br> echo "<br>";<br
Guild-Rank:
<?php
//currently an example, change to your desired infomation
$dbuser = "root";
$dbpass = "root";
$dbhost = "localhost";
$dbname = "newproject_db";
//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_name FROM t_guild WHERE a_level>0 AND a_level>4 ORDER BY a_level DESC");
echo "</pre>
<table width="400" border="0" cellpadding="2" cellspacing="2">LevelName".$row["a_level"]."".$row["a_name"]."</table>
<br>";<br
Banlist:
<?php
//currently an example, change to your desired infomation
$dbuser = "root";
$dbpass = "root";
$dbhost = "localhost";
$dbname = "newproject_db";
//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_idname, a_detail, a_modify_date FROM t_users_block");
echo "</pre>
<table width="450" border="0" cellpadding="2" cellspacing="2">AccountnameReasonBandate".$row["a_idname"]."".$row["a_detail"]."".$row["a_modify_date"]."</table>
<br>";<br
You only change the MySQL Connection Fields. Warning for Banlist: In your Database you must enter in "a_detail" your Reason and in "a_modify_date" the Bantime..
Only Works for EP1 Files !!
Howto:
You need a Webserver (eg. Xampp) on your PC, Root etc. Then you create a .php file (eg. ranking.php) . Open it and copy one of my Codes in it. Then edit the MySQL-Connection in the .php file. Then youre done!
(SORRY FOR BAD ENGLISH IM GERMAN)