1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
|
<div id="contenue_page" align="center">
<?php
echo '<table border="0" cellpadding="3" cellspacing="0">
<tr>
<td align="center" colspan="2" class="no_connect"><strong>Nom</strong></td>
<td align="center" class="no_connect"><strong>Classe</strong></td>
<td align="center" class="no_connect"><strong>Base level </strong></td>
<td align="center" class="no_connect"><strong>Job level </strong></td>
<td align="center" class="no_connect"><strong>Guilde</strong></td>
<td align="center" class="no_connect"><strong>Dernière map </strong></td>
</tr>
';
$rq = mysql_query("SELECT c.name AS namep , c.online , c.base_level , c.job_level , g.guild_id AS guildid , c.last_map , c.class , g.name AS nameg FROM `char` AS c LEFT OUTER JOIN guild AS g ON g.guild_id = c.guild_id WHERE c.online='1' ORDER BY c.base_level DESC") or die (mysql_error());
if (mysql_num_rows($rq) == '0') { echo '<tr><td colspan="9" class="error_warning"> Personne n\'est connecté</td></tr>'; } else {
while ($re = mysql_fetch_assoc($rq)) {
echo '
<tr>
<td align="center" class="no_connect"> </td>
<td align="center" class="no_connect"><strong>'.$re['namep'].'</strong></td>
<td align="center"><font color="green">'.$class[$re['class']].'</font></td>
<td align="center"><i>'.$re['base_level'].'</i></td>
<td align="center"><i>'.$re['job_level'].'</i></td>
<td align="center"><img src="inser/emblem.php?guild='.$re['guildid'].'"><font color="gray">'.$re['nameg'].'</font></td>
<td align="center">'.$re['last_map'].'</td>
</tr>
</table>
';
}
}
?>
</div> |
Partager