diff options
| author | nikrou <nikrou@piwigo.org> | 2010-06-23 18:17:36 +0000 |
|---|---|---|
| committer | nikrou <nikrou@piwigo.org> | 2010-06-23 18:17:36 +0000 |
| commit | d28c348908e281f4bb7ed61dd0854e9bced5d4d7 (patch) | |
| tree | b60a7b0a1ceaca769c4be1b7584e30323df13f77 | |
| parent | b3ad6951e825fe54f2f6d81ea8625bd0e5e7ba1f (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
| -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.' ;'; |