[Release]Flyff Ranking Script mit 3 Job.

<h3> Ranking</h3>

<!-- start content -->
<div id="content">
<div class="post">

<div class="entry">
<p><?php
function quetrabajo($job){
if ($job == '0'){
echo "Vagrant";
}
if ($job == '1'){
echo "Mercenary";
}
if ($job == '2'){
echo "Acrobat";
}
if ($job == '3'){
echo "Assist";
}
if ($job == '4'){
echo "Magician";
}
if ($job == '5'){
echo "Puppeter";
}
if ($job == '6'){
echo "Knight";
}
if ($job == '7'){
echo "Blade";
}
if ($job == '8'){
echo "Jester";
}
if ($job == '9'){
echo "Ranger";
}
if ($job == '10'){
echo "Ringmaster";
}
if ($job == '11'){
echo "Billposter";
}
if ($job == '12'){
echo "Psykeeper";
}
if ($job == '13'){
echo "Elementor";
}
if ($job == '14'){
echo "Gatekeeper";
}
if ($job == '15'){
echo "Doppler";
}
if ($job == '16'){
echo "M-Knight";
}
if ($job == '17'){
echo "M-Blade";
}
if ($job == '18'){
echo "M-Jester";
}
if ($job == '19'){
echo "M-Ranger";
}
if ($job == '20'){
echo "M-Ringmaster";
}
if ($job == '21'){
echo "M-Billposter";
}
if ($job == '22'){
echo "M-Psykeeper";
}
if ($job == '23'){
echo "M-Elementor";
}
if ($job == '24'){
echo "H-Knight";
}
if ($job == '25'){
echo "H-Blade";
}
if ($job == '26'){
echo "H-Jester";
}
if ($job == '27'){
echo "H-Ranger";
}
if ($job == '28'){
echo "H-Ringmaster";
}
if ($job == '29'){
echo "H-Billposter";
}
if ($job == '30'){
echo "H-Psykeeper";
}
if ($job == '31'){
echo "H-Elementor";
}
if ($job == '32'){
echo "Templar";
}
if ($job == '33'){
echo "Slayer";
}
if ($job == '34'){
echo "Harlequin";
}
if ($job == '35'){
echo "Crackshooter";
}
if ($job == '36'){
echo "Seraph";
}
if ($job == '37'){
echo "Force Master";
}
if ($job == '38'){
echo "Mentalist";
}
if ($job == '39'){
echo "Arcanist";
}
}

$contadorn=1;
$contadorm=1;
$contadorh=1;
$normal = array();
$master = array();
$hero = array();
require('./configs/rank_conf.php');
if(!$link){
echo 'configuracion incorrecta';
}else{
if(!db){
echo ' la base de datos no existe';
}else{
$sql = "SELECT * FROM CHARACTER_TBL ORDER BY m_nLevel DESC";
$result = mssql_query($sql);
while($consulta = mssql_fetch_array($result)) {
if($consulta['m_nJob']<=15){
$normal[$contadorn]=$consulta['m_szName'];
$normal[$contadorn+1]=$consulta['m_nLevel'];
$normal[$contadorn+2]=$consulta['m_nJob'];
$contadorn= $contadorn+3;
}else{
if($consulta['m_nJob']<=15){
$master[$contadorm]=$consulta['m_szName'];
$master[$contadorm+1]= $consulta['m_nLevel'];
$master[$contadorm+2]=$consulta['m_nJob'];
$contadorm= $contadorm+3;
}else{
$hero[$contadorh]=$consulta['m_szName'];
$hero[$contadorh+1]=$consulta['m_nLevel'];
$hero[$contadorh+2]=$consulta['m_nJob'];
$contadorh= $contadorh+3;
}
}
}

//empezamos a contar los Masters
echo '<div align="center"><table width="100%" border="0" cellspacing="0" cellpadding="0";"><tr>';
echo '<td width="37%" style="padding-left:12px;"><b><u>Username</td>';
echo '<td width="16%" style="padding-left:12px;"><b><u>Level</td>';
echo '<td width="47%" style="padding-left:12px;"><b><u>Job</u></b></td>';
echo'</tr>';
echo'<tr>';
for($i=1;$i<$contadorm;$i=$i+1){
echo '<td style="padding-left:12px;">';
if($i>1 and $i%3==0){
quetrabajo($master[$i]);
echo "</td></tr><tr>";
}else{
echo $master[$i]."</td>";
}

}
//acabamos

//empezamos a contar los heroes
for($i=1;$i<$contadorh;$i=$i+1){
echo '<td style="padding-left:12px;">';
if($i>1 and $i%3==0){
quetrabajo($hero[$i]);
echo "</td></tr><tr>";
}else{
echo $hero[$i]."</td>";
}

}
//acabamos

//empezamos a contar los Masters
for($i=1;$i<$contadorn;$i=$i+1){
echo '<td style="padding-left:12px;">';
if($i>1 and $i%3==0){
quetrabajo($normal[$i]);
echo "</td></tr><tr>";
}else{
echo $normal[$i]."</td>";
}

}
echo '</tr>';
//acabamos
}
}
mssql_close();

?>
<tr><td></td><td><br><br><div align="center" style="font-size:12;font-color:#666;"></div></td></tr></table></div></p>

</div>
</div>

</div>
<!-- end content -->

<?php
$link = @mssql_connect("Name-PC\SQLEXPRESS", "SA", "euer PW") ;
$db = @mssql_select_db("CHARACTER_01_DBF");
?>