diff options
| author | Dries Buytaert <dries@buytaert.net> | 2006-09-06 12:27:50 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2006-09-06 12:27:50 +0000 |
| commit | fd210c342cbf6d6ceca034a08f3b39d2991e8d7c (patch) | |
| tree | 71a5a1f08a4936b82b286f5a45891514cf1447f5 | |
| parent | 40fba3d73b79b58b2130338da1f40befec7c4283 (diff) | |
| download | brdo-fd210c342cbf6d6ceca034a08f3b39d2991e8d7c.tar.gz brdo-fd210c342cbf6d6ceca034a08f3b39d2991e8d7c.tar.bz2 | |
- Patch #81777 by havran: make access checking work on PostgreSQL. (ANSI SQL 92)
| -rw-r--r-- | includes/bootstrap.inc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/includes/bootstrap.inc b/includes/bootstrap.inc index dc0d78a91..41dca93ce 100644 --- a/includes/bootstrap.inc +++ b/includes/bootstrap.inc @@ -631,7 +631,7 @@ function drupal_is_denied($type, $mask) { // (allowed). // The use of ORDER BY / LIMIT is more efficient than "MAX(status) = 0" // in PostgreSQL <= 8.0. - return (bool) db_result(db_query_range("SELECT (status = 0) FROM {access} WHERE type = '%s' AND LOWER('%s') LIKE LOWER(mask) ORDER BY status DESC", $type, $mask, 0, 1)); + return (bool) db_result(db_query_range("SELECT CASE WHEN status=1 THEN 0 ELSE 1 END FROM {access} WHERE type = '%s' AND LOWER('%s') LIKE LOWER(mask) ORDER BY status DESC", $type, $mask, 0, 1)); } /** |