/** * Конструктор класса * устанавливает массив с id устройств * задает токен для доступа к аккуанту * устанавливает устройства по умолчанию */ function __construct() { $this->devices = array(); $query = "SELECT device FROM devices WHERE is_active='1'"; $db = new data_base(); $devices = $db->super_query($query)->get_res(); foreach ($devices as $device) { $this->devices[] = $device[device]; } $query = "SELECT device FROM devices WHERE is_default='1'"; $default = $db->super_query($query, false)->get_res(); $this->set_token()->default_dev = $default[device]; }
echo $this->result; } else { if (is_int($this->result)) { echo $this->result; } else { echo $otvet; } } } } } include "mysql.php"; include "sms.php"; $db = new data_base(); $query = "SELECT token, devices FROM admin"; $result = $db->super_query($query)->get_res(); foreach ($result as $device) { $devices[] = explode(",", $device['devices']); } if (!isset($_COOKIE['PHPSESSID'])) { foreach ($result as $token) { $sms = new sms($devices, $token['token']); $in = $sms->get_in_sms(); if ($in['code'] == 0) { foreach ($in['data'] as $value) { $phone = str_replace("+7", "8", $value['phone']); $date_time = explode(" ", $value['date']); $query = "UPDATE `users` SET phone_ver='1', date_ver='" . $date_time[0] . "' WHERE phone='{$phone}' AND phone_ver='0'"; $db->query($query); } }
function get($id) { $query = "SELECT sended_sms.delivered, sended_sms.is_error, sended_sms.msg, sended_sms.id_rassilki, sended_sms.msg, sended_sms.id, sended_sms.phone as phone1,\n users.name, users.otch, users.phone, users.id, users.fam,\n sended_mass.tema\n FROM sended_sms\n Left Join users ON users.phone = sended_sms.phone\n LEFT JOIN sended_mass ON sended_mass.id = sended_sms.id_rassilki\n WHERE sended_sms.id_rassilki = {$id}"; $db = new data_base(); return $db->super_query($query)->get_res(); }