1. IMPORTANT : Nouvelles mesures de sécurité - 2. Règles pour obtenir de l'aide dans les forums de support - 3. Restrictions des droits pour le groupe "Support suspendu"

Il est obligatoire de respecter les Règles de MyBB.fr : Version abrégée ou Version complète pour obtenir du support sur nos forums.

Les membres ayant un site/forum contrevenant aux règles de MyBB.support seront placés dans le groupe "Support suspendu" et ne bénéficieront plus du support du staff. Nous recommandons aux autres membres d'agir de même. Il ne s'agit pas d'un bannissement, le membre retrouvera son statut "normal" dès que sa situation sera conforme aux règles.

Nouveau : un Wiki en français : plus de détails.
Avant de soumettre votre problème, consultez-le, ainsi que la FAQ, sans oublier le moteur de recherche interne.


Note de ce sujet :
  • Moyenne : 0 (0 vote(s))
  • 1
  • 2
  • 3
  • 4
  • 5
[Réglé] [AIDE] Forum + PLugins
Mots-clés » forum, plugins
10-02-2012, 9:03,
#4
RE: [AIDE] Forum + PLugins
Merci spyto, par contre j'ai quelque erreurs :
http://hightseries.verygames.net/forum/misc.php?page=test

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /data/filer-6/web/web814/htdocs/forum/inc/plugins/pagemanager.php(794) : eval()'d code on line 61

Voici mon joblist :

Code :
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Liste des métiers</title>
</head>
<?php
function GetFriendID($pszAuthID) {

        $iServer = "0";
        $iAuthID = "0";
        $szAuthID = $pszAuthID;
        $szTmp = strtok($szAuthID, ":");
        while(($szTmp = strtok(":")) !== false) {
                $szTmp2 = strtok(":");
                if($szTmp2 !== false) {
                        $iServer = $szTmp;
                        $iAuthID = $szTmp2;
                }
        }
        if($iAuthID == "0")
                return "0";

        $i64friendID = bcmul($iAuthID, "2", 0);
        $i64friendID = bcadd($i64friendID, bcadd("76561197960265728", $iServer, 0), 0);

        return $i64friendID;
}
function connexionBD()
{
    $db_login = 'roleplay';
    $db_password = 'rppassword';
    $db = 'mysql:host=94.23.55.57;dbname=Roleplay'; // Ici, l'hôte et le nom de la BDD
    try
    {
        $connexion = new PDO($db, $db_login, $db_password, array(PDO::ATTR_PERSISTENT=>true));
        return $connexion;
    }
    catch (PDOException $ex)
    {
        die("Erreur de connexion a la base de données: " . $ex->getMessage());
        return false;
    }
}
$connexion = connexionBD();
mysql_connect("94.23.55.57", "roleplay", "rppassword");
mysql_select_db("Roleplay");
?>
<center>
<!-- Métiers Etat -->
<h1>Métiers D'Etat</h1>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '1' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital1 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Gouvernement</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '1' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "1" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">     
        </td>
        <td style="text-align:left; width:200px;">
            Chef d'Etat
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '1' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "1" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Agent C.I.A
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '1' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "1" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Agent du F.B.I
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '1' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "1" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Agent de police
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '1' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "1" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Gardien
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
/* Fin Gouvernement */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '2' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital2 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Hopital</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital2; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '2' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "2" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">     
        </td>
        <td style="text-align:left; width:200px;">
            Directeur de l'Hopital
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '2' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "2" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Urgentiste
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '2' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "2" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Médecin
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '2' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "2" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Infirmier
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '2' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "2" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Aide-Soignant
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
/* Fin Hopital */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '15' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital15 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Detectives</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital15; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '15' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "15" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Chef Détectives
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '15' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "15" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Enquêteur
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '15' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "15" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Apprenti Enquêteur
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '15' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "15" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Détective Privé
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '15' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "15" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Détective
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
/* Fin Detective */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '12' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital12 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Banque</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital12; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '12' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "12" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Patron de la Banque
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '12' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "12" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Prêteur sur Gage
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '12' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "12" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Banquier
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '12' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "12" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti banquier
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '12' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "12" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Conseiller financier
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin Banque */
?>
</table>
</center>
<hr />
<hr />
<center>
<!-- Métiers Commerciaux -->
<h1>Métiers Commerciaux</h1>

<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '6' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital6 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Ammu-Nation</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital6; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '6' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "6" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Directeur de l'Ammu-Nation
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '6' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "6" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Armurier
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '6' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "6" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Apprenti Armurier
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '6' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "6" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Vendeur de Grenades
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '6' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "6" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Vendeur de Grenades
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin Armurerie */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '10' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital10 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Coachs</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital10; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '10' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "10" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Patron des Coachs
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '10' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "10" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Coach de Défense
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '10' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "10" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Coach Sportif
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '10' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "10" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Entraineur
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '10' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "10" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Entraineur
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin Coachs */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '14' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital14 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>BulletClub</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital14; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '14' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "14" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Patron BulletClub
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '14' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "14" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Moniteur de Tir
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '14' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "14" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Apprenti Moniteur de Tir
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '14' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "14" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Vendeur de Permis d'armes
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '14' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "14" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Vendeur de Permis d'armes
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin Moniteurs */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '16' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital16 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Epicerie</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital16; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '16' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "16" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Patron de l'épicerie
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '16' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "16" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Epicier
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '16' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "16" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Apprenti Epicier
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '16' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "16" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Vendeur de Glaces
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '16' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "16" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Vendeur de Glaces
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin Epicier */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '11' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital11 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Loto</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital11; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '11' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "11" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Patron du Loto
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '11' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "11" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Huissier du Loto
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '11' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "11" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Vendeur de Ticket
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '11' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "11" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Vendeur de ticket
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '11' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "11" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Buraliste
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin Loto */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '9' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital9 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>AirControl</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital9; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '9' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "9" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Patron AirControl
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '9' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "9" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Ingénieur AirControl
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '9' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "9" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Vendeur AirControl
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '9' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "9" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Vendeur AirControl
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '9' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "9" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Vendeur de recharge AirControl
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin AC */
?>
</table>
</center>
<hr />
<hr />
<center>
<!-- Métiers Zone noire -->
<h1>Métiers Zone noire</h1>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '5' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital5 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Tueurs</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '5' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "5" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Patron des tueurs
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '5' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "5" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Tueur d'Élite
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '5' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "5" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Tueur Experimenté
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '5' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "5" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Tueur Débutant
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '5' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "5" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Tueur
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin Tueurs */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '8' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital8 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Dealers</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital8; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '8' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "8" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Chef des Dealers
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '8' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "8" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Passeur de Drogue
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '8' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "8" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Dealer
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '8' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "8" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Dealer
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '8' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "8" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Revendeur de drogue
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin Dealer */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '7' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital7 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Mafia</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital7; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '7' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "7" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Parrain
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '7' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "7" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Consigliere
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '7' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "7" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Caporegime
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '7' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "7" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Mafieux
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '7' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "7" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Mafieux
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin Mafia */
?>
</table>
<hr />
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '13' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$capital13 = $donnees['CAPITAL'];
?>
<table>
    <tr>
        <td style="text-align:left; width:200px;">     
            <h3>Triades</h3>
        </td>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        Capital :
        <td style="text-align:left; width:50px;">
            <?php echo $capital13; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '13' AND RANKID = '1'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money1 = $donnees['SALARY'];

$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "13" AND RANKID = "1"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">    
        </td>
        <td style="text-align:left; width:200px;">
            Chef de la Triade
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money1; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '13' AND RANKID = '3'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money3 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "13" AND RANKID = "3"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Bras droit Triade
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money3; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '13' AND RANKID = '4'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money4 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "13" AND RANKID = "4"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
               Pirate Informatique
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money4; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '13' AND RANKID = '5'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money5 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "13" AND RANKID = "5"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Gangsters
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
            <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money5; ?>$
        </td>
        <td>
        </td>
  </tr>
<?php
}
?>
<?php
$requete = "SELECT * FROM RP_Jobs WHERE JOBID = '13' AND RANKID = '2'";
$result = $connexion->query($requete);
$donnees = $result->fetch();
$money2 = $donnees['SALARY'];
$retour = mysql_query('SELECT * FROM RP_Players WHERE JOBID = "13" AND RANKID = "2"');
while ($donnees = mysql_fetch_array($retour))
{
    ?>
    <tr>
        <td style="text-align:left; width:200px;">
        </td>
        <td style="text-align:left; width:200px;">
            Apprenti Gangsters
        </td>
        <td style="text-align:left; width:250px; overflow:hidden;">
        <?php $profil = GetFriendID($donnees['STEAMID']); ?>
            <a href="http://steamcommunity.com/profiles/<?php echo $profil; ?>/">
            <?php echo $donnees['PSEUDO']; ?></a>
        <td style="text-align:left; width:50px;">
            <?php echo $money2; ?>$
        </td>
        <td>

        </td>
  </tr>
<?php
}
/* Fin Mafia */
?>
</table>
</center>


N'hésite pas à demander de l'aide, sur le forum !
Toute l'équipe de modération est là pour toi !
Répondre


Messages dans ce sujet
[AIDE] Forum + PLugins - Azik - 05-02-2012, 12:25
RE: [AIDE] Forum + PLugins - Azik - 09-02-2012, 23:51
RE: [AIDE] Forum + PLugins - spyto - 10-02-2012, 0:07
RE: [AIDE] Forum + PLugins - Azik - 10-02-2012, 9:03
RE: [AIDE] Forum + PLugins - Saphir - 10-02-2012, 14:54
RE: [AIDE] Forum + PLugins - Azik - 10-02-2012, 21:34



Utilisateur(s) parcourant ce sujet : 1 visiteur(s)

Contact | MyBB.support | Retourner en haut | Retourner au contenu | Version bas-débit (Archivé) | Syndication RSS
 Utilitaire de traduction fourni par Regentronique