<?php

session_start();

$sql_serveur = "localhost";

$sql_base = "divinite";

$sql_login = "root";

$sql_password = "";

$conn = mysql_connect($sql_serveur,$sql_login,$sql_password);

$conn2 = mysql_select_db($sql_base);

if($_SESSION['pseudo'] != '')

{



$compte = mysql_query("SELECT * FROM joueurs_membres WHERE membre_pseudo='".$_SESSION['pseudo']."'");

while($affich_compte = mysql_fetch_array($compte))

{

$membre_partie=$affich_compte['membre_partie'];

$membre_id=$affich_compte['membre_id'];

}



$ressource = mysql_query("SELECT * FROM jeu_planete WHERE id_joueurs='".$membre_id."'");

while($affich_ressource = mysql_fetch_array($ressource))

{

$nom_planete = $affich_ressource['nom_planete'];

$bois = $affich_ressource['ressources_bois'];

$energie = $affich_ressource['ressources_energie'];

$or = $affich_ressource['ressources_or'];

$robots = $affich_ressource['ressources_robots'];

$uranium = $affich_ressource['ressources_uranium'];

$argent = $affich_ressource['ressources_argent'];

$metal = $affich_ressource['ressources_metal'];

}

$construction = mysql_query("SELECT * FROM jeu_construction WHERE id_joueurs='".$membre_id."'");

while($affich_construction = mysql_fetch_array($construction))

{

$lvl_mine_or=$_affich_construction['ressource_mine_or'];

$lvl_mine_argent=$_affich_construction['ressource_mine_argent'];

$lvl_menuiserie=$_affich_construction['ressource_menuiserie'];

$lvl_uranium=$_affich_construction['ressource_uranium'];

$lvl_depot_or=$_affich_construction['depot_mine_or'];

$lvl_depot_argent=$_affich_construction['depot_mine_argent'];

$lvl_depot_menuiserie=$_affich_construction['depot_menuiserie'];

$lvl_depot_uranium=$_affich_construction['depot_uranium'];

$lvl_centre_commandement=$_affich_construction['batiments_centre_commandement'];

$lvl_centre_energetique=$_affich_construction['batiments_centre_energetique'];

$lvl_centre_devellopement=$_affich_construction['batiments_centre_devellopement'];

$lvl_centre_robotique=$_affich_construction['batiments_centre_robotique'];

$lvl_centre_missile=$_affich_construction['batiments_centre_missile'];

$lvl_centre_infanterie=$_affich_construction['batiments_centre_infanterie'];

$lvl_centre_spacial=$_affich_construction['batiments_centre_spacial'];

$lvl_centre_artilleur=$_affich_construction['batiments_centre_artilleur'];

$lvl_centre_breche=$_affich_construction['batiments_centre_breche'];

//ici mes recherches $lvl_teleportation=$_affich_construction['recherche_teleportation'];

}

}

?>

<?php 

$construction = mysql_query("SELECT * FROM jeu_construction WHERE id_joueurs='".$membre_id."'");

while($affich_construction = mysql_fetch_array($construction))

{

$lvl_mine_or=$_affich_construction['ressource_mine_or'];

$lvl_mine_argent=$_affich_construction['ressource_mine_argent'];

$lvl_menuiserie=$_affich_construction['ressource_menuiserie'];

$lvl_uranium=$_affich_construction['ressource_uranium'];

$lvl_depot_or=$_affich_construction['depot_mine_or'];

$lvl_depot_argent=$_affich_construction['depot_mine_argent'];

$lvl_depot_menuiserie=$_affich_construction['depot_menuiserie'];

$lvl_depot_uranium=$_affich_construction['depot_uranium'];

$lvl_centre_commandement=$_affich_construction['batiments_centre_commandement'];

$lvl_centre_energetique=$_affich_construction['batiments_centre_energetique'];

$lvl_centre_devellopement=$_affich_construction['batiments_centre_devellopement'];

$lvl_centre_robotique=$_affich_construction['batiments_centre_robotique'];

$lvl_centre_missile=$_affich_construction['batiments_centre_missile'];

$lvl_centre_infanterie=$_affich_construction['batiments_centre_infanterie'];

$lvl_centre_spacial=$_affich_construction['batiments_centre_spacial'];

$lvl_centre_artilleur=$_affich_construction['batiments_centre_artilleur'];

$lvl_centre_breche=$_affich_construction['batiments_centre_breche'];

//ici mes recherches $lvl_teleportation=$_affich_construction['recherche_teleportation'];

}