Map : trop de requetes

[sagaff]

Le code complet de la map est ici : http://sitedemickael.chez-alice.fr/map.txt

Sephi-Chan avec l'exemple que tu m'a donné, je suis incapable de faire la jointure.

Je peux au mieux mettre les véritables nom de table :

Code PHP :

<?php 

$mapquery = "SELECT cases.*,

    rpg_coffers.name AS rpg_coffers, 

    rpg_coffers.x AS coffre_x, 

    rpg_coffers.y AS rpg_coffers_y, 

    rpg_clans_elements.name AS rpg_clans_elements, 

    rpg_clans_elements.x AS clan_x, 

    rpg_clans_elements.y AS clan_y, 

    rpg_users.id AS personnage_id

    rpg_users.charname AS rpg_users

FROM cases

LEFT JOIN rpg_coffers

ON rpg_coffers.x = cases.x

AND rpg_coffers.y = cases.y

LEFT JOIN rpg_clans_elements

ON rpg_clans_elements.x = cases.x

AND rpg_clans_elements.y = cases.y



LEFT JOIN rpg_users

ON rpg_users.x = cases.x

AND rpg_users.y = cases.y

WHERE cases.x BETWEEN x_min AND x_max

AND cases.y BETWEEN y_min AND y_max";