diff options
author | bugreport%peshkin.net <> | 2004-07-22 06:26:20 +0200 |
---|---|---|
committer | bugreport%peshkin.net <> | 2004-07-22 06:26:20 +0200 |
commit | bf43cc08b073de64ca6348b980651f7171e14103 (patch) | |
tree | 480f4bfd81d56f1140ba2d6b3f0d12f52a26631d | |
parent | 5013f383c9a81fae0371e95f634cb1d4b85ba660 (diff) | |
download | bugzilla-bf43cc08b073de64ca6348b980651f7171e14103.tar.gz bugzilla-bf43cc08b073de64ca6348b980651f7171e14103.tar.xz |
Bug 252190: Fix unitialized value in editusers.cgi
r=vlad
a=justdave
-rwxr-xr-x | editusers.cgi | 6 |
1 files 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 "</TR><TR><TH VALIGN=TOP ALIGN=RIGHT>Group Access:</TH><TD><TABLE><TR>"; 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 " . |