diff options
| author | Steven Wittens <steven@10.no-reply.drupal.org> | 2004-12-20 02:05:00 +0000 |
|---|---|---|
| committer | Steven Wittens <steven@10.no-reply.drupal.org> | 2004-12-20 02:05:00 +0000 |
| commit | e7b0b227b9993767c355e19c748ddfb9a4260239 (patch) | |
| tree | 12ffde8cfbfe5a7128cdc5b367a865e7c8ab70aa /modules/comment.module | |
| parent | 78c24e67c0e1ed001889b435c4e8dd1be36d8d28 (diff) | |
| download | brdo-e7b0b227b9993767c355e19c748ddfb9a4260239.tar.gz brdo-e7b0b227b9993767c355e19c748ddfb9a4260239.tar.bz2 | |
Making comment moderation query PGSQL/ANSI compatible.
Diffstat (limited to 'modules/comment.module')
| -rw-r--r-- | modules/comment.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/comment.module b/modules/comment.module index 67197bbdb..a6f848f74 100644 --- a/modules/comment.module +++ b/modules/comment.module @@ -1503,7 +1503,7 @@ function theme_comment_moderation_form($comment) { // comment hasn't been moderated yet: if (!isset($votes) && $user->roles) { - $result = db_query('SELECT v.mid, v.vote, MAX(r.value) AS value FROM {moderation_votes} v INNER JOIN {moderation_roles} r ON r.mid = v.mid WHERE r.rid IN (%s) GROUP BY v.mid, v.vote ORDER BY weight', implode(', ', array_keys($user->roles))); + $result = db_query('SELECT v.mid, v.vote, MAX(v.weight) AS weight, MAX(r.value) AS value FROM {moderation_votes} v INNER JOIN {moderation_roles} r ON r.mid = v.mid WHERE r.rid IN (%s) GROUP BY v.mid, v.vote ORDER BY weight', implode(', ', array_keys($user->roles))); $votes = array(); while ($vote = db_fetch_object($result)) { if ($vote->value != 0) { |