Affilié à :
Affiliation(s) :
Error: Erreur sur la requete : SELECT gall_guild1_id, gall_guild2_id, g1.gld_name AS gall_guild1_name, g2.gld_name AS gall_guild2_name,
j1.id AS gall_guild1_game_id, j1.titre AS gall_guild1_game_name,
j2.id AS gall_guild2_game_id, j2.titre AS gall_guild2_game_name,
gall_terms
FROM alliance, guild g1, guild g2
LEFT JOIN mp_portail.mol_fiches_mmo AS j1 ON g1.gld_game_id = j1.id_fiche
LEFT JOIN mp_portail.mol_fiches_mmo AS j2 ON g2.gld_game_id = j2.id_fiche
WHERE gall_guild1_id = g1.gld_id
AND gall_guild2_id = g2.gld_id
AND (gall_guild1_id = '5540' OR gall_guild2_id = '5540')
AND gall_status = '1'
ORDER BY gall_guild1_game_name ASC, gall_guild2_game_name ASC -- (Champ 'j1.id' inconnu dans field list)
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
/usr/home/www/mpv3/guildes/class/Relation.php on line
144
Guilde(s) alliée(s) :
Error: Erreur sur la requete : SELECT gwar_guild1_id, gwar_guild2_id, g1.gld_name AS gwar_guild1_name, g2.gld_name AS gwar_guild2_name,
j1.id AS gwar_guild1_game_id, j1.titre AS gwar_guild1_game_name,
j2.id AS gwar_guild2_game_id, j2.titre AS gwar_guild2_game_name,
gwar_terms
FROM war, guild g1, guild g2
LEFT JOIN mp_portail.mol_fiches_mmo AS j1 ON g1.gld_game_id = j1.id_fiche
LEFT JOIN mp_portail.mol_fiches_mmo AS j2 ON g2.gld_game_id = j2.id_fiche
WHERE gwar_guild1_id = g1.gld_id
AND gwar_guild2_id = g2.gld_id
AND (gwar_guild1_id = '5540' OR gwar_guild2_id = '5540')
ORDER BY gwar_guild1_game_name ASC, gwar_guild2_game_name ASC -- (Champ 'j1.id' inconnu dans field list)
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
/usr/home/www/mpv3/guildes/class/Relation.php on line
98
Guilde(s) en guerre :
