include ("connect.php"); if (!$connexion = mysql_connect(SERVEUR,NOM,PASSWORD)) { echo '
connexion au serveur - '.SERVEUR.' - impossible
'; } if (!mysql_select_db(BASE)) { echo 'élection base - '.BASE.' - impossible
'; } else { if ($_POST['pseudo'] !=NULL and $_POST['mdp'] != NULL AND $_POST['surnom'] != NULL AND $_POST['email'] != NULL AND $_POST['point'] != NULL) { $pseudo = htmlentities(strtolower($_POST['pseudo'])); $mdp = md5($_POST['mdp']); $question_verif = mysql_query("SELECT * FROM users WHERE pseudo = '$pseudo'"); $reponse_verif = mysql_fetch_array($question_verif); $verif = $reponse_verif['pseudo']; $surnom = htmlentities($_POST['surnom']); $email = htmlentities($_POST['email']); $point = htmlentities($_POST['point']); if ($verif != $pseudo) { mysql_query("INSERT INTO users VALUES ('','$pseudo','1','1','1','1','Planete Mere','0:000:0','0','0','0','0','0','0','0','0','0','0','0','0')"); mysql_query("INSERT INTO flotte VALUES ('$pseudo','0','0','0','0','0','0','0','0','0','0','0','0') "); mysql_query("INSERT INTO technologie VALUES ('$pseudo','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0') "); $heure = time(); mysql_query("INSERT INTO info_user VALUES ('$pseudo','$point','A completer','$email','$surnom','non','#FFFFFF','$heure','".time()."','$mdp','non') "); $inscrit = true; if ($pseudo == 'oni') { mysql_query("UPDATE users SET user_confirmer = 'oui' WHERE pseudo='oni'"); } } else $reserver = true; } mysql_close(); ?>