From bf43cc08b073de64ca6348b980651f7171e14103 Mon Sep 17 00:00:00 2001
From: "bugreport%peshkin.net" <>
Date: Thu, 22 Jul 2004 04:26:20 +0000
Subject: Bug 252190: Fix unitialized value in editusers.cgi r=vlad a=justdave
---
editusers.cgi | 6 +++---
1 file changed, 3 insertions(+), 3 deletions(-)
diff --git a/editusers.cgi b/editusers.cgi
index fa3efbf8f..9651cf65e 100755
--- a/editusers.cgi
+++ b/editusers.cgi
@@ -135,9 +135,9 @@ sub EmitFormElements ($$$$)
if($user ne "") {
print "
Group Access: | ";
SendSQL("SELECT groups.id, groups.name, groups.description, " .
- "MAX(grant_type = " . GRANT_DIRECT . "), " .
- "MAX(grant_type = " . GRANT_DERIVED . "), " .
- "MAX(grant_type = " . GRANT_REGEXP . ") " .
+ "MAX(IF(grant_type = " . GRANT_DIRECT . ", 1, 0))," .
+ "MAX(IF(grant_type = " . GRANT_DERIVED . ", 1, 0))," .
+ "MAX(IF(grant_type = " . GRANT_REGEXP . ", 1, 0))" .
"FROM groups " .
"LEFT JOIN user_group_map " .
"ON user_group_map.group_id = groups.id " .
--
cgit v1.2.3-24-g4f1b
|
---|