Apparition du perso sur la map[Résolu]

Code PHP :

<?

session_start();

include('zone-page/haut.php');

include('zone-page/menu-gauche.php');

include('zone-page/droit.php');

include('bdd.php');

include('reglage.php');

include('function.php');



$req = $db->query("SELECT * FROM map WHERE perso='0' AND bat='0' ANd idbat='0'");

                    $nb_result = $db->affected_rows();

                    $nb = mt_rand(1,$nb_result);

                    for($i=0;$nb>=$i;$i++) $res = $db->fetch_array($req22);

                    $newX=$res22['X'];

                    $newY=$res22['Y'];

                $sql = "UPDATE map SET perso='$id' WHERE X='$newX' AND Y='$newY'";

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

                echo'<center><br>Vous venez de retourner sur le champ de bataille.';

                echo'<br><a href="jouer.php">Rejoindre le front</a></center>';





include('zone-page/droit2.php');

?>

Code PHP :

<?php 

$query = mysql_query("SELECT * FROM pc WHERE pc_camps='".$camps."'");

$i = 1;

while ( $pc = mysql_fetch_assoc($query) )  {

        

        $tab[$i] = $pc['idpc'];

        $i++;

        }



$nbr_pc = $i-1; // Afin de ne pas avoir le dernier $i vide etant donné qu'on incrémente

$pc_choisi = mt_rand(1,$nbr_pc); // random du Pc



$idpc = $tab[$pc_choisi]; // Collecte les informations

Code PHP :

<?php 

// Requiert id et matricule du joueur a rez ==> $idjoueur et $camps



$query = mysql_query("SELECT * FROM pc WHERE pc_camps='".$camps."'");

$i = 1;

while ( $pc = mysql_fetch_assoc($query) )  {

        

        $tab[$i] = $pc['idpc'];

        $i++;

        }



$nbr_pc = $i-1;

$pc_choisi = mt_rand(1,$nbr_pc);



$idpc = $tab[$pc_choisi];



$query = mysql_query("SELECT x,y FROM carte LEFT JOIN pc ON carte.idpc=pc.idpc WHERE pc.idpc='".$idpc."'") or die(mysql_error()); 



// Recherche des bords de la zone de rez ( 3 ici )

$pc = mysql_fetch_assoc($query);

$zone_x_min = $pc['x']-3;

    if ( $zone_x_min < 1 ) $zone_x_min == 1 ;

$zone_x_max = $pc['x']+3;

$zone_y_min = $pc['y']-3;

    if ( $zone_y_min < 1 ) $zone_y_min == 1 ;

$zone_y_max = $pc['y']+3;



// Requete bord de la zone

$query2 = mysql_query("SELECT * FROM carte LEFT JOIN terrain ON carte.idterrain=terrain.idterrain WHERE x BETWEEN '$zone_x_min' AND '$zone_x_max' AND y BETWEEN '$zone_y_min' AND '$zone_y_max'");



// Boucle de vérification case non occupée

    while ( $zone = mysql_fetch_assoc($query2) )  {

        $zone_x = $zone['x'];

        $zone_y = $zone['y'];

        $query3 = mysql_query("SELECT x,y FROM perso WHERE x='$zone_x' AND y='$zone_y'");

        $query4 = mysql_query("SELECT x,y FROM carte WHERE x='$zone_x' AND y='$zone_y' AND idpc!='1'");

        $case_joueur = mysql_num_rows($query3);            

        $case_pc = mysql_num_rows($query4);    

            

// Case vide ( pas de joueur, ni de batiment ), on insère dans la bdd

if ( $case_joueur == 0  && $case_pc == 0 )) {

            mysql_query("UPDATE perso SET x='".$zone_x."', y='".$zone_y."' WHERE idperso='".$idjoueur."'");

             echo '<SCRIPT LANGUAGE="JavaScript">document.location.href="index.php?page=jouer&rez"></SCRIPT>';

            }    

    } // Fin du while

Code PHP :

<?

session_start();

include('zone-page/haut.php');

include('zone-page/menu-gauche.php');

include('zone-page/droit.php');

include('bdd.php');

include('reglage.php');

include('function.php');



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

$camp = $sql['camp'];

if($camp=='Triple Entente')

    {

    $req = $db->query("SELECT * FROM map WHERE perso='0' AND bat='1' ANd idbat='0'");

                    /////A partir de la je coince ^^/////

                    $nb_result = $db->affected_rows();

                    $nb = mt_rand(1,$nb_result);

                    for($i=0;$nb>=$i;$i++) $res = $db->fetch_array($req22);

                    $newX=$res22['X'];

                    $newY=$res22['Y'];

                $sql = "UPDATE map SET perso='$id' WHERE X='$newX' AND Y='$newY'";

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

                echo'<center><br>Vous venez de retourner sur le champ de bataille.';

                echo'<br><a href="jouer.php">Rejoindre le front</a></center>';





include('zone-page/droit2.php');

?>