Sélection monstre/joueur

[phenix]

J'ai pas tout comprit, alors j'ai tenté sa:

Code :

SELECT
                    monstre.id AS id_monstre,
                    monstre.id_type,
                    listemonstre.nom AS nom_monstre,
                    listemonstre.niveau AS niveau_monstre,
                    monstre.lieu AS lieu_monstre,
                    monstre.quartier AS quartier_monstre,
                    listemonstre.forceu AS for_monstre,
                    listemonstre.dexterite AS dex_monstre,
                    listemonstre.endurance AS end_monstre,
                    listemonstre.pouvoir AS pouv_monstre,
                    monstre.PV AS PV_monstre,
                    monstre.PA AS PA_monstre,
                    monstre.PM AS PM_monstre,
                    monstre.time_PA,
                    monstre.time_PM,
                    monstre.save_PA,
                    monstre.save_PM,
                    listemonstre.armure AS armure_monstre,
                    listemonstre.degat_min AS degat_min_monstre,
                    listemonstre.degat_max AS degat_max_monstre,
                    monstre.position AS position_monstre,
                    
                    users.id AS id_users,
                    users.pseudo AS pseudo_users,
                    users.lieu AS lieu_users,
                    users.quartier AS quartier_users,
                    users.pseudo AS pseudo_users,
                    users.niv AS niveau_users,
                    users.exp AS exp_users,
                    users.forceu AS for_users,
                    users.dexterite AS dex_users,
                    users.endurance AS end_users,
                    users.pouvoir AS pouv_users,
                    users.PV AS PV_users,
                    users.PO AS PO_users,
                    users.arme AS arme_users,
                    users.armure AS armure_users,
                    users.tete AS tete_users,
                    users.jambe AS jambe_users,
                    users.bouclier AS bouclier_users,
                    users.gant AS gant_users,
                    users.orientation AS orientation_users,
                    users.position AS position_users


                    
FROM monstre

                    INNER JOIN users ON monstre.lieu = users.lieu AND monstre.quartier = users.quartier                     INNER JOIN listemonstre ON monstre.id_type = listemonstre.id                    

                    WHERE users.statut = 1 AND users.position = MIN(
(monstre.position%24)-(users.position%24)*(monstre.position%24)-(users.position%24)+(monstre.position/24)-(users.position/24)*(monstre.position/24)-(users.position/24)

)

Bien sur sa marche pas. J'ai tenter d'autre bidouille sans plus de succès.

Merci pour votre aide (joli le tableau avec les opérateurs je vais le garder sous la main (h) ),

phenix