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);
} |
Partager