function auth_cookie() { $ss = explode("_", $_COOKIE['id']); $req = "SELECT user,pass FROM user WHERE user=\"" . $ss[0] . "\""; $row1 = db_req($req); if ($ss[0] == $row1[0]['user'] && $ss[1] == $row1[0]['pass'] && $row1[0]['user'] !== null && $row1[0]['pass'] !== null && $row1[0]['user'] !== '' && $row1[0]['pass'] !== '') { $req = "UPDATE user SET date_last_login=null WHERE user='******'"; db_req_without_resp($req); return $row1[0][user]; } else { return false; } }
<?php ////////////////////////////////////////// ///проверяет логин введенный через POST/// ////////////////////////////////////////// if ($_POST[user] == null) { echo "not"; return; } require_once __DIR__ . "/../function/db.php"; $req = "SELECT user,pass FROM user WHERE user=\"" . $_POST[user] . "\""; $row1 = db_req($req); if ($_POST[pass] == $row1[0][pass]) { echo "ok"; setcookie("id", $_POST[user] . "_" . $_POST[pass], time() + 60 * 60 * 24 * 365, "/"); } else { echo "not"; } return;
<?php require_once __DIR__ . "/../function/db.php"; $req = "SELECT * FROM status;"; $ss = db_req($req); //print_r($ss); $call_sost = $ss['call']; echo $call_sost;
db_req_without_resp($req); include "/var/www/indriver/modules/stop.php"; echo "1"; } if ($_POST[work] == '1') { $req = "UPDATE `status` SET `work`='1' WHERE `status_id`='0';"; include "/var/www/indriver/modules/stop.php"; db_req_without_resp($req); echo "1"; } if ($_POST[work] == '0') { $req = "UPDATE `status` SET `work`='0' WHERE `status_id`='0';"; db_req_without_resp($req); echo "1"; } if ($_POST[ask_work] == '1') { $req = "SELECT * FROM status;"; $ret = db_req($req); echo $ret['work']; } if ($_POST[ask_start] == '1') { $req = "SELECT * FROM status;"; $ret = db_req($req); echo $ret['init']; } if ($_POST[disconnect] == '1') { $req = "UPDATE `status` SET `disk`='1' WHERE `status_id`='0';"; db_req_without_resp($req); include "/var/www/indriver/modules/disconnect.php"; echo "1"; }
/////инициализировать курл $ch = curl_init(); while (1) { ////найти 5 последних idriver_id показанных этому таксисту заказов..... $sql = "SELECT `id_tax` FROM `current_taxa_android` WHERE taxist_id='" . $ss1 . "' ORDER BY `id_taxa` DESC LIMIT 5"; $id_tax = db_reqs($sql); ///// взять два айди от 0,1 идекса массива данных, из псоледней итерации. $sql = "SELECT `last1`,`last2` FROM `last_indriver_id` WHERE taxist_id='" . $ss1 . "' AND `date` >= (now() - interval 5 minute);"; $last = db_req($sql); $last1 = $last['last1']; $last2 = $last['last2']; //////////////////////// ///GET GEO taxist /// //////////////////////// $sql = "SELECT `long`,`lat` FROM geoloc WHERE `taxist_id`='" . $ss1 . "' order by `time` DESC limit 1"; $ret = db_req($sql); $lat1 = $ret['lat']; $long1 = $ret['long']; //////////// ////curl//// //////////// curl_setopt_array($ch, array(CURLOPT_NOBODY => 0, CURLOPT_RETURNTRANSFER => 1, CURLOPT_URL => "http://178.248.236.45/api/getlastorders", CURLOPT_POST => 1, CURLOPT_POSTFIELDS => $postdata, CURLOPT_CONNECTTIMEOUT => 5, CURLOPT_TIMEOUT => 5, CURLOPT_HEADER => 0)); $out = curl_exec($ch); $idd = json_decode($out); print_r($idd); //$start = microtime(true); $x = 0; foreach ($idd->response->items as $s => $ss) { ///ПРОВЕРКА. если индексы из массива данных 0 и 1. от последней итерации совападут в той же последовательности ///в которой они были в последней итерации то завершить итерацию и запросить данные по новой... ///ЗАЧЕМ КАЛЬКУЛИРОВАТЬ за ново ТО ЧТО КАЛЬКУЛИРОВАЛОСЬ РАНЬШЕ.... незачем!
$ret = db_req($req); echo json_encode($ret); } //////////////////////////////////// //////////антииндрайвер ищет клиента //////////////////////////////////// if ($input['id'] == "client") { $sql = "SELECT * FROM `taxist` WHERE username='******'user'] . "'"; $ret1 = db_req($sql); if ($ret1['work'] != 0) { $sql = "SELECT * FROM current_taxa_android WHERE taxist_id=(SELECT `taxist_id` FROM `taxist` WHERE username='******'user'] . "') order by `id_taxa` Desc limit 1"; $ret = db_req($sql); //if($ret['new']==1) //{ $sql = "UPDATE `current_taxa_android` SET `new`='0' WHERE `id_taxa`='" . $ret['id_taxa'] . "'"; db_req($sql); $ret[] = $ret1['work']; $ret[] = $ret1['dial_status']; $ret[] = $ret1['connected']; echo json_encode($ret); // } // else // { // // $ret4[] = $ret1['work']; // $ret4[] = $ret1['dial_status']; // $ret4[] = $ret1['connected']; // $ret4['ans'] = "empty"; // echo json_encode($ret4); // } } else {
<?php require_once __DIR__ . "/../function/db.php"; $req = "SELECT * FROM filtres;"; $ret = db_req($req); if ($s == 1) { echo $ret['price']; } if ($s == 0) { echo $ret['dist']; } if (!is_null($_POST[price])) { $req = "UPDATE filtres SET `price`='{$_POST['price']}' WHERE `filtres_id`='1';"; echo $req; db_req($req); header("Location: " . $_SERVER['HTTP_REFERER']); }
<?php require_once __DIR__ . "/../function/db.php"; $location = db_req("SELECT * FROM current_taxa;"); print_r($location);