From 4fad80e53822ca8d9a62098cfc7f23db1c4ea3e0 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Mon, 10 May 2004 21:30:31 +0000
Subject: - Patch #7638 by nereocystis: fixed PostgreSQL (ANSI SQL)
 compatibility bug in the comment module.

---
 modules/comment/comment.module | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'modules/comment/comment.module')

diff --git a/modules/comment/comment.module b/modules/comment/comment.module
index 841197d3f..6e490ee16 100644
--- a/modules/comment/comment.module
+++ b/modules/comment/comment.module
@@ -986,10 +986,10 @@ function comment_mod_matrix($edit) {
     db_query("DELETE FROM {moderation_roles} ");
     foreach ($edit as $role_id => $votes) {
       foreach ($votes as $mid => $value) {
-        $sql[] = "('$mid', '$role_id', '". ($value ? $value : 0) ."')";
+        $sql = "('$mid', '$role_id', '". ($value ? $value : 0) ."')";
+   db_query("INSERT INTO {moderation_roles} (mid, rid, value) VALUES ". $sql);
       }
     }
-    db_query("INSERT INTO {moderation_roles} (mid, rid, value) VALUES ". implode(", ", $sql));
     drupal_set_message(t("the vote values have been saved."));
   }
 
-- 
cgit v1.2.3