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';
}
?> |
