1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
| <?php
$team = $_POST['team'];
$password = $_POST['pass'];
$id = $_SESSION['id'];
//Connexion
include ($_SERVER["DOCUMENT_ROOT"]."/php/sql_connection.php");
//Requete, bordel.
echo 'avant requete<br>';
$req = "SELECT * FROM team WHERE NAME='".$team."' AND PASSWORD ='".$password."'";
echo 'requete:'.$req.'<br>';
$res = $mysqli->query($req) or die(mysql_error());
$data = mysqli_fetch_assoc($res);
$num = mysqli_num_rows($res);
if ($num == 1) {
if (isset($data['PLAYER_2'])) {
if (isset($data['PLAYER_3'])) {
if (isset($data['PLAYER_4'])) {
if (isset($data['PLAYER_5'])) {
$request = "UPDATE team SET PLAYER_6 ='".$id."'";
}
else {
$request = "UPDATE team SET PLAYER_5 ='".$id."'";
}
}
else {
$request = "UPDATE team SET PLAYER_4 ='".$id."'";
}
}
else {
$request = "UPDATE team SET PLAYER_3 ='".$id."'";
}
}
else {
$request = "UPDATE team SET PLAYER_2 = '".$id."'";
}
$request = $request." WHERE NAME ='".$team."'";
echo $request;
$result = mysqli->query($request) or die(mysqli_error());
//$change = "UPDATE users SET TEAM ='".$team."' WHERE ID_STEAM ='".$id."'";
//$final = mysqli->query($change) or die(mysqli_error());
}
else {
echo 'erreur/mauvais pass';
}
?> |
Partager