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