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> |
