MyBB.support, le portail francophone de MyBB
[Réglé] [AIDE] Forum + PLugins - Version imprimable

+- MyBB.support, le portail francophone de MyBB (http://mybb.fr)
+-- Forum : Plug-ins et modules pour MyBB (http://mybb.fr/forum-32.html)
+--- Forum : Support (http://mybb.fr/forum-15.html)
+--- Sujet : [Réglé] [AIDE] Forum + PLugins (/thread-5252.html)



[AIDE] Forum + PLugins - Azik - 05-02-2012

Bonjour à vous,

Tous d'abord je suis fière d'utilisez MyBB.

J'aimerais savoir, si il y a un plugins pour créer des pages mybb qui prend en compte le php, pour que j'intègre ma page (http://hightseries.fr/joblist.php)


Cordialement,


RE: [AIDE] Forum + PLugins - Azik - 09-02-2012

UP SVP.


RE: [AIDE] Forum + PLugins - spyto - 10-02-2012

Page manager :
http://mods.mybb.com/view/page-manager

Pour la doc ;
http://community.mybb.com/thread-63082.html
19 pages à lire, avec des fichiers xml exemple...


RE: [AIDE] Forum + PLugins - Azik - 10-02-2012

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>




RE: [AIDE] Forum + PLugins - Saphir - 10-02-2012

As-tu bien désactivé l'affichage de l'header et du footer MyBB sur la page, si ce n'est pas le cas, tu ne peux pas utiliser de PHP dans ta page !


RE: [AIDE] Forum + PLugins - Azik - 10-02-2012

Ah non, merci.

Résolue les friends Big Grin


 Utilitaire de traduction fourni par Regentronique