From 468fde03b6b3ef3b8419bd976a8d1c746c402712 Mon Sep 17 00:00:00 2001 From: "Matteo Nastasi (mop)" Date: Fri, 11 Feb 2011 08:26:10 +0100 Subject: [PATCH] DISABLE status for user managed --- web/Obj/dbase_pgsql.phh | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/web/Obj/dbase_pgsql.phh b/web/Obj/dbase_pgsql.phh index 5da9207..fe5d681 100644 --- a/web/Obj/dbase_pgsql.phh +++ b/web/Obj/dbase_pgsql.phh @@ -86,7 +86,8 @@ class BriskDB /* check the existence of the nick in the BriskDB */ log_main("login_exists: ".$login); - $user_sql = sprintf("SELECT * FROM %susers WHERE login = lower('%s');", $G_dbpfx, escsql($login)); + $user_sql = sprintf("SELECT * FROM %susers WHERE login = lower('%s') AND (type & CAST (X'%08x' as integer)) = 0;", + $G_dbpfx, escsql($login), USER_FLAG_TY_DISABLE); if (($user_pg = pg_query($this->dbconn->db(), $user_sql)) != FALSE) if (pg_numrows($user_pg) == 1) return TRUE; @@ -97,7 +98,7 @@ class BriskDB function &getrecord_bylogin($login) { GLOBAL $G_false, $G_dbpfx; - $user_sql = sprintf("SELECT * FROM %susers WHERE login = lower('%s');", $G_dbpfx, escsql($login)); + $user_sql = sprintf("SELECT * FROM %susers WHERE login = lower('%s') AND (type & CAST (X'%08x' as integer)) = 0;", $G_dbpfx, escsql($login), USER_FLAG_TY_DISABLE); if (($user_pg = pg_query($this->dbconn->db(), $user_sql)) == FALSE) return $ret; -- 2.17.1