public function setGroups($driver_id, $groupList) { DBHelper::run("DELETE FROM `drivers_groups` WHERE `driver_id` = " . $driver_id); foreach ($groupList as $group_id) { DBHelper::run("INSERT INTO `drivers_groups` SET `group_id` = " . $group_id . ", `driver_id` = " . $driver_id); } }
public function signIn($login, $hash) { $hash256 = hash('sha256', $hash . $login); $result = DBHelper::getFirst("SELECT * FROM `users` WHERE `login` = '" . $login . "' AND `password` = '" . $hash256 . "'"); if ($result != NULL) { if (session_id() == "") { session_start(); } $_SESSION['login'] = $login; DBHelper::run("UPDATE `users` WHERE `login` = '" . $login . "' SET `last_activity` = " . time()); return "SUCCESS"; } return "FAILURE"; }
public function setLocation($id, $lat, $lng, $busy, $accuracy) { return DBHelper::run("UPDATE `drivers` SET\n `lat` = '" . $lat . "',\n `lng` = '" . $lng . "',\n `busy` = '" . $busy . "',\n `accuracy` = '" . $accuracy . "',\n `last_activity` = '" . time() . "'\n WHERE `driver_id` = " . $id); }
public function deleteDriver($id) { return DBHelper::run("DELETE FROM `users` WHERE `user_id` = " . $id); }