diff options
| author | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-08-19 11:35:09 +0000 |
|---|---|---|
| committer | artem <artem@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2008-08-19 11:35:09 +0000 |
| commit | 84a4272b58e6bcc5be3366adc5771851c522eae3 (patch) | |
| tree | e088fd336667817dda9b8b89ddb3ea0ee6a327b8 /frontends/php/include/perm.inc.php | |
| parent | c18881cf3bf1288bff75ecb10df386ec25a0cab9 (diff) | |
- [DEV-137] improvements in sqls (Artem)
git-svn-id: svn://svn.zabbix.com/trunk@5926 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'frontends/php/include/perm.inc.php')
| -rw-r--r-- | frontends/php/include/perm.inc.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/frontends/php/include/perm.inc.php b/frontends/php/include/perm.inc.php index 3e830fe9..9c3ee565 100644 --- a/frontends/php/include/perm.inc.php +++ b/frontends/php/include/perm.inc.php @@ -66,7 +66,7 @@ function check_authorisation(){ bold(date('d.m.Y H:i',$login['attempt_clock'])), '.'))); - DBexecute('UPDATE users SET attempt_failed=0 WHERE userid='.zbx_dbstr($login['userid'])); + DBexecute('UPDATE users SET attempt_failed=0 WHERE userid='.$login['userid']); } } @@ -169,7 +169,7 @@ return $result; function check_perm2system($userid){ $sql = 'SELECT COUNT(g.usrgrpid) as grp_count '. ' FROM usrgrp g, users_groups ug '. - ' WHERE ug.userid = '.zbx_dbstr($userid). + ' WHERE ug.userid = '.$userid. ' AND g.usrgrpid = ug.usrgrpid '. ' AND g.users_status = '.GROUP_STATUS_DISABLED; $res = DBfetch(DBSelect($sql)); @@ -209,7 +209,7 @@ function get_user_auth($userid){ $sql = 'SELECT MAX(g.gui_access) as gui_access '. ' FROM usrgrp g, users_groups ug '. - ' WHERE ug.userid='.zbx_dbstr($userid). + ' WHERE ug.userid='.$userid. ' AND g.usrgrpid=ug.usrgrpid '; $acc = DBfetch(DBselect($sql)); |