function loginform_exec($Frm, $Err) { if ($Err) { $Frm->_gui->Vars["login_message"] = "Ошибки при заполнении формы"; return; } // clr db::delete(TABLE_LOGIN_HOST, "time < " . (time() - 900)); $last_login_time = db::get_arrays("SELECT time FROM " . TABLE_LOGIN_HOST . " WHERE ip = '" . db::input($_SERVER["REMOTE_ADDR"]) . "' ORDER BY time"); $cnt = count($last_login_time); $rowx["time"] = 0; if ($cnt) { $rowx = $last_login_time[0]; } $user = Employee::findOneBy(array('email' => strtolower($Frm->GetValue(0)), 'hpwd' => md5($Frm->GetValue(1) . $Frm->GetValue(0)))); if (!$user || $cnt > 2) { if ($cnt > 1) { $t = 900 - time() + $rowx["time"]; if ($t > 60) { $w = floor($t / 60) . " мин."; } else { $w = " минуту"; } $Frm->_gui->Vars["login_message"] = "Попытки исчерпаны. Подождите " . $w; } else { $Frm->_gui->Vars["login_message"] = "Ошибка. Осталось попыток: " . (2 - $cnt); db::insert(TABLE_LOGIN_HOST, array('ip' => $_SERVER['REMOTE_ADDR'], 'time' => time())); } return; } else { // ok if ($user["blocked"] || $user["black_list"]) { $Frm->_gui->Vars["login_message"] = "Доступ запрещен"; return; } $ll = array(); if ($user["last_login"]) { $ll = unserialize($user["last_login"]); while (count($ll) > 99) { array_shift($ll); } } $ll[] = array("ip" => $_SERVER['REMOTE_ADDR'], "time" => time()); Employee::update($user['id'], array('last_act' => time(), 'last_login' => serialize($ll))); unset($user["last_act"]); unset($user["last_login"]); $_SESSION["user"]["auth"] = true; $_SESSION["user"]["data"] = $user; page_reload(); } }
function del_city_exec($Frm, $Err) { global $data_city; if (!$Err) { $id = intval($Frm->GetValue(0)); if (isset($data_city[$id])) { db::delete(TABLE_CITIES, "id = " . $id); $Frm->_gui->informer->OK("Удалено"); page_reloadSubSec(); } } }
public static function deleteDisciplines($author_id) { db::delete(TABLE_AUTHOR_TO_DISCIPLINE, 'author_id = ' . db::input($author_id)); }
public static function deleteAllDisciplines($napravl_id) { db::delete(TABLE_DISCIPLINE_TO_NAPRAVL, 'napravl_id = ' . $napravl_id); }
public static function deleteAllFromNaprav($disc_id) { db::delete(TABLE_DISCIPLINE_TO_NAPRAVL, 'discipline_id = ' . $disc_id); }
/** * @param $id * * @return bool * @throws InvalidArgumentException */ public static function delete($id) { if (empty($id) || !is_numeric($id)) { throw new InvalidArgumentException(self::getEntity()); } db::delete(static::TABLE, 'id = ' . $id); return true; }
function delete_city_to_filial($filial_id) { db::delete('filial_to_city', 'filial_id = ' . db::input($filial_id)); }
function Filtering() { if (!is_null($this->text)) { db::delete($this->collection->DstTable, "NOT (" . $this->keyid . " LIKE '" . mysql_escape_string($this->text) . "')"); } }
<?php use Components\Classes\db; require_once '../../includes/application_top.php'; if (!$_SESSION["user"]["auth"]) { die("запрещено"); } if (isset($_POST['module']) && count($_POST['module'])) { global $GUI; $role_id = $_POST['role_id']; db::delete(TABLE_ROLES_TO_MODULES, "role_id = " . $role_id); db::delete(TABLE_ROLES_TO_SUBMODULES, "role_id = " . $role_id); db::delete(TABLE_ROLES_TO_COMMANDS, "role_id = " . $role_id); db::delete(TABLE_ROLES_TO_COLUMNS, "role_id = " . $role_id); foreach ($_POST['module'] as $module_id => $enabled) { db::insert(TABLE_ROLES_TO_MODULES, array('role_id' => $role_id, 'module_id' => $module_id)); } if (count($_POST['submodule'])) { foreach ($_POST['submodule'] as $submodule_id => $enabled) { db::insert(TABLE_ROLES_TO_SUBMODULES, array('role_id' => $role_id, 'submodule_id' => $submodule_id)); } } if (count($_POST['command'])) { foreach ($_POST['command'] as $command_id => $enabled) { db::insert(TABLE_ROLES_TO_COMMANDS, array('role_id' => $role_id, 'command_id' => $command_id)); } } if (count($_POST['column'])) { foreach ($_POST['column'] as $column_id => $enabled) { db::insert(TABLE_ROLES_TO_COLUMNS, array('role_id' => $role_id, 'column_id' => $column_id)); }