$nbr = mysql_query("SELECT count(*) AS totalr FROM `characters` WHERE account = {$post}") or die(mysql_error());
$nbtotr = mysql_fetch_array($nbr, MYSQL_ASSOC);
echo "<tr>\n\t\t\t\t\t\t\t\t\t<td align=\"left\">Nombre total de personnages:</td>\n\t\t\t\t\t\t\t\t\t<td align=\"left\">{$nbtot['total']}</td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td align=\"left\">Personnages dans ce royaume:</td>\n\t\t\t\t\t\t\t\t\t<td align=\"left\">{$nbtotr['totalr']}</td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t\t<p>Liste des personnages :<br />";
mysql_connect($characters[1]['host'], $characters[1]['user'], $characters[1]['password']) or die(mysql_error());
mysql_select_db($characters[1]['db']) or die(mysql_error());
$test = mysql_query("SELECT * FROM characters WHERE account={$post} ORDER BY name ") or die(mysql_error());
while ($donnees = mysql_fetch_array($test, MYSQL_ASSOC)) {
$perso = $donnees['name'];
$level = explode(' ', $donnees['data']);
$niveau = $level[53];
$race = $donnees['race'];
$class = $donnees['class'];
echo "<a href=\"../armurerie-select.php?perso={$perso}\">{$perso} - ";
nomrace($race);
echo " ";
nomclass($class);
echo " | lvl {$niveau}</a><br />";
}
echo "</p><br /><table>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td align=\"left\"><a href='javascript:history.go(-1)'>Retour</a> <input type=\"submit\" value=\"Modifier\"></td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</form>\n\t\t\t\t\t</p>";
break;
case "modi":
verify_xsrf_token();
$id = mysql_real_escape_string($_POST['id']);
$username = trim(htmlspecialchars($_POST['username']));
$password = mysql_real_escape_string($_POST['new_pass']);
$mail = mysql_real_escape_string($_POST['mail']);
$banned = mysql_real_escape_string($_POST['banned']);
$gmlevel = mysql_real_escape_string($_POST['gmlevel']);
$failedlog = mysql_real_escape_string($_POST['failedlog']);
$locked = mysql_real_escape_string($_POST['locked']);
$expansion = mysql_real_escape_string($_POST['expansion']);
echo nomside(Securite::bdd($donnees['race']));
echo "\" valign=\"top\" width=\"50%\">";
echo "<table class=\"profile-header-nametext-table\">\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<td class=\"profile-header-portrait\">\n\t\t\t\t\t\t\t\t\t\t<img width=\"72\" height=\"72\" src=\"images/portraits/";
echo portraitcaractere($donnees['level']);
echo "/" . Securite::html($donnees['gender']) . "-" . Securite::html($donnees['race']) . "-" . Securite::html($donnees['class']) . ".gif\" class=\"profile-header-portrait-img-";
echo nomside(Securite::html($donnees['race']));
echo "\" onmouseover=\"ddrivetip('<span class=\\'tooltip-whitetext\\'>race - classe</span>')\" onmouseout=\"hideddrivetip()\">\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t\t<td class=\"profile-header-title\" valign=\"top\">\n\t\t\t\t\t\t\t\t\t\t<span class=\"profile-header-title-name\">" . Securite::html($donnees['name']) . "</span><br>\n\t\t\t\t\t\t\t\t\t\t<span class=\"profile-header-title-guild\"><a href=\"index.php?module=guildes&action=membres&id=" . Securite::html($donnees['GNAME']) . "\">" . Securite::bdd($guild_name[0]) . "</a></span><br>";
?>
<span class="profile-header-title-info">Level <?php
echo $donnees['level'];
?>
<?php
nomrace(Securite::html($donnees['race']));
?>
<?php
nomclass(Securite::html($donnees['class']));
?>
</span><br>
<?php
echo "</td>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</table>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td class=\"profile-header-";
echo nomside(Securite::html($donnees['race']));
echo "-right\" width=\"50%\" valign=\"top\">\n\t\t\t\t\t\t\t<span onmouseover=\"ddrivetip('<span class=\\'profile-tooltip-header\\'>Guild - name\\</span><br><span class=\\'profile-tooltip-description\\'>Guild Rank: membre<br>Members: 100</span>')\" onmouseout=\"hideddrivetip()\">Guild: " . Securite::html($guild_name[0]) . "</span><br><br>Realm: Royaume<br>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t\t<br />\n\t\t\t\t<center>";
?>
<br /><br />
<table cellpadding="0" cellspacing="0" class="lined" style="width: 560px;">
<tr>
<td width="6%">
<?php
if (!empty($equiped_items[1][1])) {
echo maketooltip("<img src=\"{$equiped_items[1][1]}\" class=\"{$equiped_items[1][2]}\" alt=\"\" />", "{$item_datasite}{$EQU_HEAD}", $equiped_items[1][0], "item_tooltip", "target=\"_blank\"");
} else {