[Share] Ranking Script

[Scratch]

dont work for me TT.TT

[creed0116]

Hey as i found it a bit of a mess i rewrote it for you guys

<?php
$FlyFF_Settings['db_host'] = "localhost";
$FlyFF_Settings['db_user'] = "root";
$FlyFF_Settings['db_pass'] = "";
$FlyFF_Settings['db_dbname'] = "flyff";

@mysql_connect($FlyFF_Settings['db_host'], $FlyFF_Settings['db_user'], $FlyFF_Settings['db_pass']) or die("Couldn't establish connection to MySQL: " . mysql_error());
@mysql_select_db($FlyFF_Settings['db_dbname']) or die("Couldn't select MySQL database: " . mysql_error());

$job_array("Vagrant","Mercenary","Acrobat","Assist","Magician",
"Puppeteer","Knight","Blade","Jester","Ranger",
"Ringmaster","Billposter","Psykeeper","Elementor","GateKeeper",
"Doppler","Knight","Blade","Jester","Ranger",
"Ringmaster","Billposter","Psykeeper","Elementor","Knight",
"Blade","Jester","Ranger","Ringmaster","Billposter",
"Psykeeper","Elementor");
$gender_array("M","F");
?>
<table width="34%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#666666">
  <tr align="center"> 
    <td colspan="5"><b><font size="4">Character Ranking</font></b></td>
  </tr>
  <tr>
    <td>Rank</td>
    <td>Name</td>
    <td>Level</td>
    <td>Class</td>
    <td>Gender</td>
  </tr>
<?
	$rank_query = mysql_query("SELECT `charname`,`level`,`sex`,`accountname`,`exp`,`class` FROM characters WHERE `level` > 0 ORDER BY level DESC LIMIT 11");
	while($rank_result = mysql_fetch_assoc($rank_query)) {
	$i++;
?>
    <tr>
    <td><?=$i;?></td>
    <td><?=$rank_result['charname'];?></td>
    <td><?=$rank_result['level'];?></td>
    <td><?=$job_array($rank_result['class']);?></td>
    <td><?=$gender_array($rank_result['sex']);?></td>
  </tr>
< } ?>
</table>

Just so you guys know i simply wrote it havent tested it or anything so if your planning on using it tell me what the problem is if any ;).

I got this error
Parse error: parse error in C:\xampp\htdocs\rank.php on line 43

[ThuGie]

Yeah find
< } ?>
And change it to
<? } ?>

Seems i also made a small mistake with arrays what i now fixt.

I updated my post to fix this for those that cant find it.

[creed0116]

<?php
$FlyFF_Settings['db_host'] = "localhost";
$FlyFF_Settings['db_user'] = "root";
$FlyFF_Settings['db_pass'] = "";
$FlyFF_Settings['db_dbname'] = "flyff";

@mysql_connect($FlyFF_Settings['db_host'], $FlyFF_Settings['db_user'], $FlyFF_Settings['db_pass']) or die("Couldn't establish connection to MySQL: " . mysql_error());
@mysql_select_db($FlyFF_Settings['db_dbname']) or die("Couldn't select MySQL database: " . mysql_error());

$job_array = array("Vagrant","Mercenary","Acrobat","Assist","Magician",
"Puppeteer","Knight","Blade","Jester","Ranger",
"Ringmaster","Billposter","Psykeeper","Elementor","GateKeeper",
"Doppler","Knight","Blade","Jester","Ranger",
"Ringmaster","Billposter","Psykeeper","Elementor","Knight",
"Blade","Jester","Ranger","Ringmaster","Billposter",
"Psykeeper","Elementor");
$gender_array = array("M","F");
?>
<table width="34%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#666666">
  <tr align="center"> 
    <td colspan="5"><b><font size="4">Character Ranking</font></b></td>
  </tr>
  <tr>
    <td>Rank</td>
    <td>Name</td>
    <td>Level</td>
    <td>Class</td>
    <td>Gender</td>
  </tr>
<?
	$rank_query = mysql_query("SELECT `charname`,`level`,`sex`,`accountname`,`exp`,`class` FROM characters WHERE `level` > 0 ORDER BY level DESC LIMIT 11");
	while($rank_result = mysql_fetch_assoc($rank_query)) {
	$i++;
?>
    <tr>
    <td><?=$i;?></td>
    <td><?=$rank_result['charname'];?></td>
    <td><?=$rank_result['level'];?></td>
    <td><?=$job_array = ($rank_result['class']);?></td>
    <td><?=$gender_array = ($rank_result['sex']);?></td>
  </tr>
<? } ?>
</table>

credits to sir ThuGie for helping me..

[Scratch]

thyx for the script

[creed0116]

[QUOTE=iPwn

[beebee]

it doesnt filter my admin characters. can anyone please post the [GM] filter.. for instance if char name starts with [GM] it wont show here.

[cybrax]

thank you for the share!!!