Liste des joueurs en ligne
This script was created
from UmriWe for ChronosWoW
and released in AC-WEB!
from UmriWe for ChronosWoW
and released in AC-WEB!
La page où sera affiché la liste :
Code PHP :
<?php
include "config.php";
mysql_connect($host,$user,$pass);
mysql_select_db($characters) or die (mysql_error());
$sql = mysql_query("SELECT * FROM characters WHERE online='1' ORDER BY RAND() LIMIT 49") or die(mysql_error());
$numrows = mysql_num_rows($sql);
if($numrows > 0)
{
echo '<b>Seulement 49 joueurs aux maximum sont affichés.</b><br /><table border="1" width="100%" style="border: 1px solid #c0c0c0;border-collapse:collapse;" align="center">
<tr><td><b><center>Nom</cetner></b></td><td><b><center>Race</center></b></td><td><b><center>Classe</center></b></td><td><b><center>Niveau</center></b></td><td><b><center>Emplacement</center></b></td></tr>';
while($raw = mysql_fetch_array($sql)){
//Character Class
$cclass = $raw['class'];
if ($cclass == 1)
{
$class = "<img src='images/classes/warrior.png' width='18' height='18'/>";
}
elseif ($cclass == 2)
{
$class = "<img src='images/classes/paladin.png' width='18' height='18'/>";
}
elseif ($cclass == 3)
{
$class = "<img src='images/classes/hunter.png' width='18' height='18'/>";
}
elseif ($cclass == 4)
{
$class = "<img src='images/classes/rogue.png' width='18' height='18'/>";
}
elseif ($cclass == 5)
{
$class = "<img src='images/classes/priest.png' width='18' height='18'/>";
}
elseif ($cclass == 6)
{
$class = "<img src='images/classes/dk.png' width='18' height='18'/>";
}
elseif ($cclass == 7)
{
$class = "<img src='images/classes/shaman.png' width='18' height='18'/>";
}
elseif ($cclass == 8)
{
$class = "<img src='images/classes/mage.png' width='18' height='18'/>";
}
elseif ($cclass == 9)
{
$class = "<img src='images/classes/warlock.png' width='18' height='18'/>";
}
elseif ($cclass == 11)
{
$class = "<img src='images/classes/druid.png' width='18' height='18'/>";
}
//Character Race
$rrace = $raw['race'];
$gender = $raw['gender'];
if ($rrace == 1)
{
$race = "Human";
}
elseif ($rrace == 2)
{
$race = "Orc";
}
if ($rrace == 3)
{
$race = "Dwarf";
}
elseif ($rrace == 4)
{
$race = "Night Elf";
}
elseif ($rrace == 5)
{
$race = "Undead";
}
elseif ($rrace == 6)
{
$race = "Tauren";
}
elseif ($rrace == 7)
{
$race = "Gnome";
}
elseif ($rrace == 8)
{
$race = "Troll";
}
elseif ($rrace == 10)
{
$race = "Blood Elf";
}
elseif ($rrace == 11)
{
$race = "Draenei";
}
//Character Gender
$ggender = $raw['gender'];
if($ggender == 1)
{
$gender = "Female";
}
else
{
$gender = "Male";
}
//Location Map
$map = $raw['map'];
if($map == 0)
{
$location = "<b>Royaume de l'Est</b>";
}
elseif($map == 1)
{
$location = "<b>Kalimdor</b>";
}
elseif($map == 530)
{
$location = "<b>Outre-Terre</b>";
}
elseif($map == 571)
{
$location = "<b>Norfendre</b>";
}
// (Ally or Horde) Check
if($rrace == 2 || $rrace == 5 || $rrace == 6 || $rrace == 8 || $rrace == 10)
{
$bg = "#bd3d43";
}
elseif($rrace == 1 || $rrace == 3 || $rrace == 4 || $rrace == 7 || $rrace == 11)
{
$bg = "#1d80dc";
}
echo '
<tr>
<td style="background-color: '.$bg.';"><b><center>'.$raw['name'].'</center></b></td>
<td style="background-color: '.$bg.';"><center><img src="images/race/'.$raw[race].'-'.$raw[gender].'.gif" title="'.$race.' '.$gender.'"/></center></td>
<td style="background-color: '.$bg.';"><center>'.$class.'</center></td>
<td style="background-color: '.$bg.';"><center>'.$raw['level'].'</center></td>
<td style="background-color: '.$bg.';"><center>'.$location.'</center></td>
</tr>';
}
echo '</tr>';
echo"</table><br />";
}
else
{
echo "<b><FONT color=\"red\">Aucun joueur en ligne !</FONT></b>";
}
?>Le fichier de configuration config.php :
Code PHP :
<?php
$host = 'localhost'; //Adresse de connexion à la base de données
$user = 'root'; //Nom de l'utilisateur
$pass = '****'; //Mot de passe
$characters = 'characters'; //Nom de la base de données qui contient les informations des personnages
?>Les images :
.
Accueil