<?php
if (empty($securite) or !isset($securite) or $securite != "ok") {
header("location: erreur.php?err=access_denied");
}
$royaume = royaume(Securite::get($_GET['royaume']));
include "kernel/id_tab.php";
echo "<p class=\"title\">{$titre_connecter}</p>";
mysql_connect($realmd['host'], $realmd['user'], $realmd['password']) or die(mysql_error());
mysql_select_db($realmd['db']) or die(mysql_error());
$reponse = mysql_query("SELECT * FROM `realmlist`") or die(mysql_error());
mysql_close();
while ($donnees = mysql_fetch_array($reponse, MYSQL_ASSOC)) {
mysql_connect($characters[$donnees['id']]['host'], $characters[$donnees['id']]['user'], $characters[$donnees['id']]['password']) or die(mysql_error());
mysql_select_db($characters[$donnees['id']]['db']) or die(mysql_error());
$reponse2 = mysql_query("SELECT COUNT(*) AS nombre FROM characters WHERE online= 1") or die(mysql_error());
$donnees2 = mysql_fetch_array($reponse2);
$online = $donnees2['nombre'];
mysql_close();
echo "<b><a href=\"index.php?module=connectes&royaume=" . $donnees['id'] . "\">Il y a {$online} joueurs connectés sur : " . $donnees['name'] . "</a></b><br>";
}
echo "<br />";
mysql_connect($characters[$royaume]['host'], $characters[$royaume]['user'], $characters[$royaume]['password']) or die(mysql_error());
mysql_select_db($characters[$royaume]['db']) or die(mysql_error());
if ($gm_visible_list == 1) {
$reponse2 = mysql_query("SELECT c.guid,c.name,c.race,c.class,c.zone,c.map,c.gender,c.level,r.gmlevel,\n\t\tCAST( SUBSTRING_INDEX(SUBSTRING_INDEX(c.data, ' ', " . (CHAR_DATA_OFFSET_ARENA_POINTS + 1) . "), ' ', -1) AS UNSIGNED) AS highest_rank,\n\t\tCAST( SUBSTRING_INDEX(SUBSTRING_INDEX(c.data, ' ', " . (CHAR_DATA_OFFSET_GUILD_ID + 1) . "), ' ', -1) AS UNSIGNED) as GNAME\n\t\tFROM " . $characters[$royaume]['db'] . ".characters c LEFT OUTER JOIN " . $realmd['db'] . ".account r ON r.id=c.account\n\t\tWHERE c.online = 1");
} else {
$reponse2 = mysql_query("SELECT c.guid,c.name,c.race,c.class,c.zone,c.map,c.gender,c.level,r.gmlevel,\n\t\tCAST( SUBSTRING_INDEX(SUBSTRING_INDEX(c.data, ' ', " . (CHAR_DATA_OFFSET_ARENA_POINTS + 1) . "), ' ', -1) AS UNSIGNED) AS highest_rank,\n\t\tCAST( SUBSTRING_INDEX(SUBSTRING_INDEX(c.data, ' ', " . (CHAR_DATA_OFFSET_GUILD_ID + 1) . "), ' ', -1) AS UNSIGNED) as GNAME\n\t\tFROM " . $characters[$royaume]['db'] . ".characters c LEFT OUTER JOIN " . $realmd['db'] . ".account r ON r.id=c.account\n\t\tWHERE c.online = 1 AND r.gmlevel = 0");
}
echo "\n\t<table class=\"lined\" style=\"border-collapse: collapse\"; width=\"99%\" border=\"1\" cellpadding=\"3\" cellspacing=\"0\" align=\"center\" class=\"sortable\">\n\t<tr>\n\t<th width=\"120\">" . $lang_player['name'] . "</th>\n\t<th width=\"30\">" . $lang_player['race'] . "</th>\n\t<th width=\"30\">" . $lang_player['class'] . "</th>\n\t<th width=\"30\">" . $lang_player['level'] . "</th>\n <th width=\"30\">" . $lang_player['rank'] . "</th>\n\t<th width=\"30\">" . $lang_player['faction'] . "</th>\n\t<th width=\"200\">" . $lang_player['guilde'] . "</th>\n\t<th width=\"80\">" . $lang_player['map'] . "</th>\n\t<th width=\"250\">" . $lang_player['zone'] . "</th>\n\t</tr>";
$reponse5 = mysql_query("SELECT COUNT(*) AS nombre FROM characters WHERE online= 1") or die(mysql_error());
echo "<p>Cette page n'existe pas !</p>";
echo "<a href=\"index.php?module=honneur\">Retour</a>";
}
} else {
echo "<p>Erreur d'accès code 1</p>";
echo "<a href=\"index.php?module=honneur&side=alliance&page=1\">Retour</a>";
}
break;
case "horde":
$page_get = Securite::get($_GET['page']);
if (!empty($page_get)) {
$adresse = "index.php?module=honneur&side=horde";
$ParPage = $Par_Page;
$retour_total = mysql_query('SELECT COUNT(*) AS total FROM characters WHERE race not in (1,3,4,7,11)');
$donnees_total = mysql_fetch_assoc($retour_total);
$total = Securite::get($donnees_total['total']);
$nombreDePages = ceil($total / $ParPage);
if (isset($page_get)) {
$pageActuelle = intval($page_get);
if ($pageActuelle > $nombreDePages) {
$pageActuelle = $nombreDePages;
}
} else {
$pageActuelle = 1;
}
$premiereEntree = ($pageActuelle - 1) * $ParPage;
if ($page_get <= $nombreDePages) {
$reponse = mysql_query("\n\t\t\t\t\tSELECT guid,name,race,class,totalHonorPoints,\n\t\t\t\t\tCAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', " . (CHAR_DATA_OFFSET_ARENA_POINTS + 1) . "), ' ', -1) AS UNSIGNED) AS honor,\n\t\t\t\t\tCAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', " . (CHAR_DATA_OFFSET_LEVEL + 1) . "), ' ', -1)AS UNSIGNED) AS level,\n\t\t\t\t\tCAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', " . (CHAR_DATA_OFFSET_GUILD_ID + 1) . "), ' ', -1) AS UNSIGNED) as GNAME,\n\t\t\t\t\tmid(lpad( hex( CAST(substring_index(substring_index(data,' '," . (CHAR_DATA_OFFSET_SEX + 1) . "),' ',-1) as unsigned) ),8,'0'),4,1) as gender\n\t\t\t\t\tFROM `characters`\n\t\t\t\t\twhere race not in (1,3,4,7,11)\n\t\t\t\t\torder by totalHonorPoints desc\n\t\t\t\t\tLIMIT {$premiereEntree}, {$ParPage}") or die(mysql_error());
?>
<p class="title"><?php
echo $titre_honor;
echo "<tr><td colspan=\"8\">Aucuns bugs signialés !!!</td></tr>";
} else {
while ($ligne = mysql_fetch_array($resultat)) {
extract($ligne);
$description_bug = substr($description_bug, 0, 30);
$date = date('d-m-Y H:i:s', $date_bug);
echo "<tr>\n\t\t\t\t\t\t<td class='milieu'>{$id_bug}</td>\n\t\t\t\t\t\t<td class='milieu'>{$type_bug}</td>\n\t\t\t\t\t\t<td class='milieu'>{$auteur_bug}</td>\n\t\t\t\t\t\t<td><a href=\"index.php?module=bugs&action=info_bug&id={$id_bug}\">{$description_bug} ...</a></td>\n\t\t\t\t\t\t<td>{$reponse_bug}</td>\n\t\t\t\t\t\t<td>{$statut_bug}</td>\n\t\t\t\t\t\t<td>{$mg_bug}</td>\n\t\t\t\t\t\t<td>{$date}</td></tr>";
}
}
echo "</table><br />";
echo "<a href=\"index.php?module=bugs&action=signaler\">Signaler un bug</a><br /><br />";
echo "<a href=\"javascript:history.go(-1)\">Retour</a>";
break;
case "compteur":
if ($_SESSION['auth'] == "yes") {
$id = Securite::get($_GET['id']);
if (!empty($id)) {
$membre_id = Securite::bdd($_SESSION['id']);
$retour = mysql_query("SELECT * FROM bug_signalant WHERE id_bug = '{$id}' AND membre_id = '{$membre_id}'") or die(mysql_error());
$donnees = mysql_fetch_array($retour);
if (mysql_num_rows($retour) == 0) {
generate_xsrf_token();
$token = Securite::bdd($_SESSION['token_xsrf']);
$sql = "SELECT *FROM bugreport WHERE id_bug={$id}";
$resultat = mysql_query($sql) or die(mysql_error());
$data = mysql_fetch_array($resultat);
echo "<p class=\"title\">Je confirme avec le même bug que selui decrit ci-dessous:</p>";
echo "<p>" . Securite::html($data['description_bug']) . "</p>";
echo "<form action=\"index.php?module=bugs&action=compteur_v\" method=\"POST\">\n\t\t\t\t\t<input type=\"hidden\" name=\"token_xsrf\" value=\"" . $token . "\" />\n\t\t\t\t\t<input type=\"hidden\" name=\"id\" value='{$id}'>\n\t\t\t\t\t<input type=\"hidden\" name=\"membre\" value='{$membre_id}'>\n\t\t\t\t\t<input type=\"submit\" value=\"Oui je confirme !\">";
} else {
echo "<p>Vous avez déjà signaler ce bug !</p>";
<?php
if (empty($securite) or !isset($securite) or $securite != "ok") {
header("location: erreur.php?err=access_denied");
}
if ($_SESSION['auth'] == "yes") {
switch ($_GET['action']) {
case "voir_equipe":
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());
$arenateam_id = Securite::get($_GET['id']);
function count_days($a, $b)
{
$gd_a = getdate($a);
$gd_b = getdate($b);
$a_new = mktime(12, 0, 0, $gd_a['mon'], $gd_a['mday'], $gd_a['year']);
$b_new = mktime(12, 0, 0, $gd_b['mon'], $gd_b['mday'], $gd_b['year']);
return round(abs($a_new - $b_new) / 86400);
}
$query = mysql_query("SELECT arenateamid, name FROM arena_team WHERE arenateamid = '{$arenateam_id}'");
if (mysql_num_rows($query) <= 0) {
echo "Cette équipe n'existe pas !";
} else {
$arenateam_data = mysql_fetch_row($query);
$query = mysql_query("SELECT arenateamid, rating, games, wins, played, wins2, rank FROM arena_team_stats WHERE arenateamid = '{$arenateam_id}'");
$arenateamstats_data = mysql_fetch_row($query);
$members = mysql_query("\n\t\t\t\tSELECT DISTINCT arena_team_member.guid,characters.name,\n\t\t\t\tcharacters.name, SUBSTRING_INDEX(SUBSTRING_INDEX(characters.data, ' ', " . (CHAR_DATA_OFFSET_LEVEL + 1) . "), ' ', -1) AS level,\n\t\t\t\tarena_team_member.played_week, arena_team_member.wons_week, arena_team_member.played_season, arena_team_member.wons_season\n\t\t\t\tFROM arena_team_member,characters\n\t\t\t\tLEFT JOIN arena_team_member k1 ON k1.guid = characters.guid\n\t\t\t\tWHERE arena_team_member.arenateamid = '{$arenateam_id}' AND arena_team_member.guid = characters.guid");
@($total_members = mysql_num_rows($members));
@($losses_week = $arenateamstats_data[4] - $arenateamstats_data[3]);
@($winperc_week = $arenateamstats_data[4] / $arenateamstats_data[3] * 100);
@($losses_season = $arenateamstats_data[6] - $arenateamstats_data[5]);
<?php
session_start();
#########################################################################################
# COPYRIGHT: Module original POMM Created by mirage666 (c) (mailto:mirage666@pisem.net icq# 152263154) adapter pour coolWoW par CiRvEnT #
#########################################################################################
if (empty($securite) or !isset($securite) or $securite != "ok") {
header("location: erreur.php?err=access_denied");
}
$royaume = (require_once "kernel/config.php");
require_once "kernel/map_fonc.php";
require_once "lang/french.php";
require_once "kernel/fonctions.php";
$_SESSION['royaume'] = royaume(Securite::get($_GET['royaume']));
?>
<SCRIPT LANGUAGE="javascript" TYPE="text/javascript">
var current_map = 0;
var time = <?php
echo $time;
?>
;
var show_time=<?php
echo $show_time;
?>
;
var show_status=<?php
echo $show_status;
?>
;
var maps_count = <?php
<?php
if (empty($securite) or !isset($securite) or $securite != "ok") {
header("location: erreur.php?err=access_denied");
}
$test_idr = Securite::get($_GET['id']);
if (!empty($test_idr)) {
$idr = $test_idr;
class SQL
{
var $link_id;
var $query_result;
var $num_queries = 0;
function connect($db_host, $db_username, $db_password, $db_name = '', $use_names = '', $pconnect = true, $newlink = false)
{
global $lang_global;
if ($pconnect) {
$this->link_id = @mysql_pconnect($db_host, $db_username, $db_password);
} else {
$this->link_id = @mysql_connect($db_host, $db_username, $db_password, $newlink);
}
if ($this->link_id) {
if ($db_name) {
if (@mysql_select_db($db_name, $this->link_id)) {
return $this->link_id;
} else {
die(error($lang_global['err_sql_open_db'] . " ('{$db_name}')"));
}
if (!empty($use_names)) {
$this->query("SET NAMES '{$use_names}'");
}
