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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
//////////////////////////
/* RECUPERATION VARIABLE */ {
$Id = 0;
$Name= "";
$Email = "";
$Password = "";
$Active = "";
$Mac = make_safe($_GET['mac']);
$Hwid = make_safe($_GET['hwid']);
$Banned = "";
$Ip = make_safe($_GET['ip']);
$Code = "";
}
//////////////////////////
/* REQUETE */ {
$RequestMac = "SELECT id,name,email,password,active,macAdresses,hwid,banned,ip,code FROM users WHERE macAddresses= ? and ip= ? and hwid= ? ";
}
//////////////////////////
/* CONNECTION */ {
$connexion = ($GLOBALS["___mysqli_ston"] = mysqli_connect($db_host, $db_user, $db_password)) or die(((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));
$select = ((bool)mysqli_query($GLOBALS["___mysqli_ston"], "USE " . $db_name)) or die(((is_object($GLOBALS["___mysqli_ston"])) ? mysqli_error($GLOBALS["___mysqli_ston"]) : (($___mysqli_res = mysqli_connect_error()) ? $___mysqli_res : false)));
mysqli_query($GLOBALS["___mysqli_ston"], "set character_set_server='utf8'");
mysqli_query($GLOBALS["___mysqli_ston"], "set names 'utf8'");
}
if(mysqli_stmt_prepare($initMac, $RequestMac))
{
echo "rentre";
mysqli_stmt_bind_param($initMac,'s',$Mac);
mysqli_stmt_execute($initMac);
mysqli_stmt_bind_result($initMac, $Id,$Name,$Email,$Password,$Active,$Mac,$Hwid,$Banned,$Ip,$Code);
$smtp = mysqli_stmt_store_result($initMac);
if($smtprow = mysqli_num_rows($smtp) >0)
{
if(mysqli_fetch_array($smtpRow))
{
if($Banned == 0)
{
echo "non banni";
}
else
{
echo "banni";
}
}
}
else
{
echo "existe pas";
}
mysqli_stmt_close($initMac);
} |
