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