diff options
| author | nikrou <nikrou@piwigo.org> | 2010-06-23 18:11:00 +0000 |
|---|---|---|
| committer | nikrou <nikrou@piwigo.org> | 2010-06-23 18:11:00 +0000 |
| commit | 186e9df5af48f258a3b0f87a112c73cf2731cafd (patch) | |
| tree | b6b38d70cd55e37df361ded7b929d87d8c226704 /include | |
| parent | 1015546138629dd974afe4e9a1b2a605d1a8eb11 (diff) | |
Fix bug 1733 : queries must use single quotes
git-svn-id: http://piwigo.org/svn/trunk@6589 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'include')
| -rw-r--r-- | include/functions_comment.inc.php | 8 |
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.' ;'; |