aboutsummaryrefslogtreecommitdiffstats
path: root/include
diff options
context:
space:
mode:
authornikrou <nikrou@piwigo.org>2010-06-23 18:17:36 +0000
committernikrou <nikrou@piwigo.org>2010-06-23 18:17:36 +0000
commitd28c348908e281f4bb7ed61dd0854e9bced5d4d7 (patch)
treeb60a7b0a1ceaca769c4be1b7584e30323df13f77 /include
parentb3ad6951e825fe54f2f6d81ea8625bd0e5e7ba1f (diff)
Bug 1733 fixed : merge from trunk.
Queries must use single quotes. git-svn-id: http://piwigo.org/svn/branches/2.1@6590 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'include')
-rw-r--r--include/functions_comment.inc.php8
1 files changed, 4 insertions, 4 deletions
diff --git a/include/functions_comment.inc.php b/include/functions_comment.inc.php
index 9b7736219..5468f511d 100644
--- a/include/functions_comment.inc.php
+++ b/include/functions_comment.inc.php
@@ -156,11 +156,11 @@ SELECT id FROM '.COMMENTS_TABLE.'
INSERT INTO '.COMMENTS_TABLE.'
(author, author_id, content, date, validated, validation_date, image_id)
VALUES (
- "'.$comm['author'].'",
+ \''.$comm['author'].'\',
'.$comm['author_id'].',
- "'.$comm['content'].'",
+ \''.$comm['content'].'\',
NOW(),
- "'.($comment_action=='validate' ? 'true':'false').'",
+ \''.($comment_action=='validate' ? 'true':'false').'\',
'.($comment_action=='validate' ? 'NOW()':'NULL').',
'.$comm['image_id'].'
)
@@ -352,7 +352,7 @@ function validate_user_comment($comment_id)
{
$query = '
UPDATE '.COMMENTS_TABLE.'
- SET validated = "true"
+ SET validated = \'true\'
, validation_date = NOW()
WHERE id = '.$comment_id.'
;';