[FRAGE] php Syntax

[Schnuffel16]

Hi,
könnte mir bitte jemand hier weiterhelfen .Möchte eine Rankingtabelle machen in der die Teammitglieder nicht angezeigt werden so nach der Art :

<?

require('./configs/reg_conf.php');
mssql_select_db("ACCOUNT_DBF");
if ('m_chLoginAuthority' == F) {
  echo "wird in Tabelle angezeigt";}
else [
  echo "";}
?>

Vielen Dank
Schnuffel 16

[©ross]

PHP Code:

<?php
function klasse($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";
}
}

    $contadorn=1;
    $contadorm=1;
    $contadorh=1;
    $normal = array();
    $master = array();
    $hero = array();
    require('config/rank_conf.php');
    if(!$link){
        echo 'Konfiguration ist falsch.';
    }else{
        if(!db){
            echo ' datenbank fehlt :0';
        }else{
            $sql = "SELECT * FROM CHARACTER_TBL WHERE m_chAuthority = 'F' ORDER BY m_nLevel DESC"; //Hier wird gefiltert F = Player | P = GM
            $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;
                    }
                }                    
            }
            
            //Master abschnitt
            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){
                                 klasse($master[$i]);
                                 echo "</td></tr><tr>";
                            }else{
                                echo $master[$i]."</td>";
                            }
                
                }

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

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

?>    
<p>
</center>

dazugehörige rank_conf.php

PHP Code:

 <?php
$link = @mssql_connect("PCName\SQLEXPRESS", "sa", "Passwort") ;
$db = @mssql_select_db("CHARACTER_01_DBF");
?>

Ist hier aus dem Sticky, mit geändeter Query.

mfg