Changeset 4183 for branches/2.0/comments.php

Timestamp:

Nov 4, 2009, 9:51:56 PM (14 years ago)

Author:

nikrou

Message:

bug 1220 : merge from trunk
fix regression when search by author or keyword contains quote

File:

• branches/2.0/comments.php (modified) (2 diffs)

branches/2.0/comments.php

@@ -188 +188 @@
   array(
     'F_ACTION'=>PHPWG_ROOT_PATH.'comments.php',
-    'F_KEYWORD'=> @htmlspecialchars($_GET['keyword'], ENT_QUOTES, 'utf-8'),
-    'F_AUTHOR'=> @htmlspecialchars($_GET['author'], ENT_QUOTES, 'utf-8'),
+    'F_KEYWORD'=> @htmlspecialchars(stripslashes($_GET['keyword'], ENT_QUOTES, 'utf-8')),
+    'F_AUTHOR'=> @htmlspecialchars(stripslashes($_GET['author'], ENT_QUOTES, 'utf-8')),
     )
   );
@@ -258 +258 @@
 
 $query = '
-SELECT COUNT(DISTINCT(id))
+SELECT COUNT(DISTINCT(com.id))
   FROM '.IMAGE_CATEGORY_TABLE.' AS ic
     INNER JOIN '.COMMENTS_TABLE.' AS com