De deux choses l'une... une seule fois !

[Pyl]

Du code concernant le premier sujet ?

Code PHP :

<?

include("bdd.php");

@session_start();

$id=$_SESSION['id'];

$perso=$_SESSION['perso'];

$req=mysql_query("SELECT arme,vision,attaque FROM membres WHERE id='$id'");

$perso=mysql_fetch_array($req);

$id_arme=$perso['arme'];

$vision=$perso['vision'];

$attaque=$perso['attaque'];

$req=mysql_query("SELECT distance FROM armes WHERE id='$id_arme'");

$armes =mysql_fetch_array($req);

$distance=$armes['distance'];

if($vision<$distance) $distance=$vision;

$sql="SELECT * FROM map WHERE perso='$id'";

$req = mysql_query($sql) or die(mysql_error());

$coord = mysql_fetch_array($req);

$X = $coord['X'];

$Y = $coord['Y'];

$Xmin = $X - $distance;

$Xmax = $X + $distance;

$Ymin = $Y - $distance;

$Ymax = $Y + $distance;

$sql1 = "SELECT * FROM  map WHERE (Y BETWEEN '$Ymin' AND '$Ymax') && (X BETWEEN '$Xmin' AND '$Xmax') && ((bat!='0' AND idbat!='0')||(perso!='0' AND perso!='$id'))";

$req1 = mysql_query($sql1) or die(mysql_error());    

$nbcible =mysql_fetch_row($sql1);

$retour = mysql_query("SELECT COUNT(*) AS nbre_entrees FROM  map WHERE (Y BETWEEN '$Ymin' AND '$Ymax') && (X BETWEEN '$Xmin' AND '$Xmax') && ((bat!='0' AND idbat!='0')||(perso!='0' AND perso!='$id'))");

$donnees = mysql_fetch_array($retour);

if($attaque!='0')

    {

    if($donnees['nbre_entrees']!='0')

        {

        $cible='';

        $cible.='<form action="attaquer.php" method="post">';

        //selection de la cible

        $cible.='<select name="cible">';

        $cible.='<option value="nocible"></option>';

        //echo'<option value=""></option>';

        while($data = mysql_fetch_array($req1))

            {

            $X=$data['X'];

            $Y=$data['Y'];    

            $idbat=$data['idbat'];

            $id_cible=$data['perso'];

            switch ($idbat) 

                {

                case '0':        

                // cible est un perso

                if($id_cible!='0') 

                    {

                    $req2=mysql_query("SELECT joueur_pseudo  FROM membres WHERE id='$id_cible'");

                    $req3=mysql_query("SELECT camp  FROM membres WHERE id='$id_cible'");

                    $perso_cible =mysql_fetch_array($req2);

                    $camp_cible =mysql_fetch_array($req3);

                    $nom_cible=$perso_cible['joueur_pseudo'];

                    $camp=$camp_cible['camp'];

                    $cible.='<option value="perso@@@'.$id_cible.'">'.$nom_cible.' ( '.$camp.' )</option>';

                    }

                break;

                }    

            }

        $cible.='</select><br><br><input type="submit" value="attaquer">';

        $cible.='</form>';

        echo '<center>'.$cible.'</center>';

        }

    else

        {

        echo'<center><br><font color=white></i>Il n\'y a personne  &agrave;  attaquer.</font></i></center>';    

        }

    }

else

    {

    echo'<center><font color=white><br>Vous n\'avez plus d\'attaque.</font></center>';

    }    

?>