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
| $frag = mysql_query("SELECT char.char_id, char.name, char.guild_id, global_reg_value.value AS tues, char.class, login.sex
FROM `char` INNER JOIN global_reg_value ON char.char_id=global_reg_value.char_id INNER JOIN login ON login.account_id=char.account_id
WHERE global_reg_value.str='PVPKill' AND char.guild_id<>176;") or die(mysql_error());
//Requète PVPDeath
$death= mysql_query("SELECT char.name, char.char_id, char.guild_id, char.class, login.sex, global_reg_value.value AS mort
FROM `char` INNER JOIN `login` ON char.account_id=login.account_id INNER JOIN global_reg_value ON char.char_id=global_reg_value.char_id
WHERE global_reg_value.str='PVPDeath' AND char.guild_id<>176;") or die(mysql_error());
//Boucle remplissage avec infos + PVPKill
while ($pvpkill = mysql_fetch_array($frag)) {
$pvpstats[$pvpkill['char_id']]['nom'] = $pvpkill['name'];
$pvpstats[$pvpkill['char_id']]['guild_id'] = $pvpkill['guild_id'];
$pvpstats[$pvpkill['char_id']]['sex'] = $pvpkill['sex'];
$pvpstats[$pvpkill['char_id']]['class'] = $pvpkill['class'];
$pvpstats[$pvpkill['char_id']]['tues'] = $pvpkill['tues'];
}
//Boucle rajoutant PVPDeath à chaque ligne ayant des kills
while ($pvpdeath = mysql_fetch_array($death)) {
$pvpstats[$pvpdeath['char_id']]['nom'] = $pvpdeath['name'];
$pvpstats[$pvpdeath['char_id']]['guild_id'] = $pvpdeath['guild_id'];
$pvpstats[$pvpdeath['char_id']]['sex'] = $pvpdeath['sex'];
$pvpstats[$pvpdeath['char_id']]['class'] = $pvpdeath['class'];
$pvpstats[$pvpdeath['char_id']]['mort'] = $pvpdeath['mort'];
} |
Partager