$id = mysql_real_escape_string(htmlspecialchars($_GET['id'], ENT_QUOTES));
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());
$result = mysql_query("SELECT account FROM `characters` WHERE guid = {$id} LIMIT 1");
if (mysql_num_rows($result)) {
$result = mysql_query("SELECT ci.bag,ci.slot,ci.item,ci.item_template, SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 15), ' ', -1) as stack_count FROM character_inventory ci INNER JOIN item_instance ii on ii.guid = ci.item WHERE ci.guid = {$id} AND ci.item_template IN(20558,20559,20560,29024,29434,40752,40753,42425,43228,43589,45624) ORDER BY ci.bag,ci.slot");
echo "<p class=\"title\">les Marque d'honneurs</p>";
if (mysql_num_rows($result) <= 0) {
echo "<p>Ce rang n'existe pas !</p>";
echo "<a href='javascript:history.go(-1)'>Retour</a>";
} else {
echo "<table class=\"lined\" width=\"99%\" style='border-collapse: collapse'; width='90%' border='1' cellspacing='1' cellpadding='1'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<th width=\"30\">Objet</th>\n\t\t\t\t\t\t\t\t<th width=\"30\">Quantité</th>\n\t\t\t\t\t\t\t</tr>";
while ($donnees = mysql_fetch_assoc($result)) {
$id_item = $donnees['item_template'];
echo "<tr><td align=\"center\">";
echo "<a href=\"http://fr.wowhead.com/?item=" . $id_item . "\"><img src=\"" . get_icon2($id_item) . "\" /></a>";
echo "</td><td align=\"center\">";
echo $donnees['stack_count'];
echo "</td>";
echo "</tr>";
}
echo "</table><br />";
}
} else {
echo "erreur";
}
break;
case "supprimer":
generate_xsrf_token();
$token = Securite::bdd($_SESSION['token_xsrf']);
$id = mysql_real_escape_string(htmlspecialchars($_GET['id'], ENT_QUOTES));
echo "<h1 class='title'>Une erreur de lien est survenue !</h1>";
echo "<p><a href=\"index.php?module=logs\">Retour</a></p>";
} else {
if ($type == "achat") {
require_once "../kernel/fonctions_armurerie.php";
echo "<p class=\"title\">Logs des achats</p><br />";
$reponse = mysql_query('SELECT r.username as account, id_achat, id_perso, id_item, date_achat, id_boutique, c.name as perso
FROM log_achat l
INNER JOIN ' . $realmd['db'] . '.account r ON r.id = l.id_membre
INNER JOIN ' . $characters[1]['db'] . '.characters c ON c.guid = l.id_perso');
echo "<table class=\"lined\" width=\"99%\" style='border-collapse: collapse'; align='center' width='90%' border='1' cellspacing='1' cellpadding='1'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<th>ID</th>\n\t\t\t\t\t\t\t\t<th>Compte</th>\n\t\t\t\t\t\t\t\t<th>Personnage</th>\n\t\t\t\t\t\t\t\t<th>Objet</th>\n\t\t\t\t\t\t\t\t<th>date d'achat</th>\n\t\t\t\t\t\t\t\t<th>article</th>\n\t\t\t\t\t\t\t</tr>";
if (mysql_num_rows($reponse) <= 0) {
echo "<tr><td colspan=\"8\"><center><b>Aucuns logs !!!</b></center></td></tr>";
} else {
while ($donnees = mysql_fetch_assoc($reponse)) {
echo "<tr>\n\t\t\t\t\t\t\t\t\t<td align=\"center\">" . $donnees['id_achat'] . "</td>\n\t\t\t\t\t\t\t\t\t<td align=\"center\">" . $donnees['account'] . "</td>\n\t\t\t\t\t\t\t\t\t<td align=\"center\">" . $donnees['perso'] . "</td>\n\t\t\t\t\t\t\t\t\t<td align=\"center\"><a href=\"http://fr.wowhead.com/?item=" . $donnees['id_item'] . "\"><img src=\"" . get_icon2($donnees['id_item']) . "\" /></a>\n\t\t\t\t\t\t\t\t\t</td>\n\t\t\t\t\t\t\t\t\t<td align=\"center\">" . $donnees['date_achat'] . "</td>\n\t\t\t\t\t\t\t\t\t<td align=\"center\">" . $donnees['id_boutique'] . "</td>\n\t\t\t\t\t\t\t\t</tr>";
}
}
echo "</table><br />\n\t\t\t\t\t\t<a href=\"index.php?module=logs\">Retour</a>";
} elseif ($type == "co_site") {
echo "<p class=\"title\">Logs des connexions au site</p><br />";
$reponse = mysql_query('SELECT r.username as account ,id_conn, date, ip
FROM log_login l
INNER JOIN ' . $realmd['db'] . '.account r ON r.id = l.id_account
WHERE l.type_conn = "site"');
echo "<table class=\"lined\" width=\"99%\" style='border-collapse: collapse'; align='center' width='90%' border='1' cellspacing='1' cellpadding='1'>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<th>ID</th>\n\t\t\t\t\t\t\t\t<th>Date de la connexion</th>\n\t\t\t\t\t\t\t\t<th>Compte</th>\n\t\t\t\t\t\t\t\t<th>Adresse IP</th>\n\t\t\t\t\t\t\t</tr>";
if (mysql_num_rows($reponse) <= 0) {
echo "<tr><td colspan=\"8\"><center><b>Aucuns logs !!!</b></center></td></tr>";
} else {
while ($donnees = mysql_fetch_assoc($reponse)) {
echo "<tr>\n\t\t\t\t\t\t\t\t\t<td align=\"center\">" . $donnees['id_conn'] . "</td>\n\t\t\t\t\t\t\t\t\t<td align=\"center\">" . $donnees['date'] . "</td>\n\t\t\t\t\t\t\t\t\t<td align=\"center\">" . $donnees['account'] . "</td>\n\t\t\t\t\t\t\t\t\t<td align=\"center\">" . $donnees['ip'] . "</td>\n\t\t\t\t\t\t\t\t</tr>";
