diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-09-30 18:13:25 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-09-30 18:13:25 +0000 |
| commit | f97999d1a49a6d5882003a91cce5cd04abbef021 (patch) | |
| tree | 44894e98e81f6373d5d6c7ac208a8522183cd3df /modules | |
| parent | 7752a593e58b98bc3b1f9ce52327fc792018e86f (diff) | |
| download | brdo-f97999d1a49a6d5882003a91cce5cd04abbef021.tar.gz brdo-f97999d1a49a6d5882003a91cce5cd04abbef021.tar.bz2 | |
- Patch #10920 by jhriggs: fixed bug with comment moderation.
Diffstat (limited to 'modules')
| -rw-r--r-- | modules/comment.module | 2 | ||||
| -rw-r--r-- | modules/comment/comment.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/comment.module b/modules/comment.module index d4329c956..38a71846a 100644 --- a/modules/comment.module +++ b/modules/comment.module @@ -1277,7 +1277,7 @@ function comment_moderate() { $moderation = $_POST['moderation']; if ($moderation) { - $result = db_query('SELECT mid, MAX(value) AS value FROM {moderation_roles} WHERE rid IN (%s) GROUP BY mid', implode(', ', array_keys($user->roles))); + $result = db_query('SELECT DISTINCT mid, value, ABS(value) FROM {moderation_roles} WHERE rid IN (%s) ORDER BY mid, ABS(value), value', implode(', ', array_keys($user->roles))); while ($mod = db_fetch_object($result)) { $votes[$mod->mid] = $mod->value; } diff --git a/modules/comment/comment.module b/modules/comment/comment.module index d4329c956..38a71846a 100644 --- a/modules/comment/comment.module +++ b/modules/comment/comment.module @@ -1277,7 +1277,7 @@ function comment_moderate() { $moderation = $_POST['moderation']; if ($moderation) { - $result = db_query('SELECT mid, MAX(value) AS value FROM {moderation_roles} WHERE rid IN (%s) GROUP BY mid', implode(', ', array_keys($user->roles))); + $result = db_query('SELECT DISTINCT mid, value, ABS(value) FROM {moderation_roles} WHERE rid IN (%s) ORDER BY mid, ABS(value), value', implode(', ', array_keys($user->roles))); while ($mod = db_fetch_object($result)) { $votes[$mod->mid] = $mod->value; } |