From e1ecc62b8388a6739acc37077d503e7e570cdbbb Mon Sep 17 00:00:00 2001 From: nikrou Date: Thu, 24 Jun 2010 18:36:24 +0000 Subject: Bug 1735 fixed : Comment page is not PostgreSQL compatible Fixed by adding all fields except category_id in group by clause category_id is retrieved later in an another query. Fixed also problem of FROM_UNIXTIME function not POstgreSQL compatible. git-svn-id: http://piwigo.org/svn/trunk@6596 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/functions_comment.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'include/functions_comment.inc.php') diff --git a/include/functions_comment.inc.php b/include/functions_comment.inc.php index 5468f511d..67fc40716 100644 --- a/include/functions_comment.inc.php +++ b/include/functions_comment.inc.php @@ -133,10 +133,10 @@ SELECT COUNT(*) AS user_exists if ($comment_action!='reject' and $conf['anti-flood_time']>0 ) { // anti-flood system - $reference_date = time() - $conf['anti-flood_time']; + $reference_date = date('c', time() - $conf['anti-flood_time']); $query = ' SELECT id FROM '.COMMENTS_TABLE.' - WHERE date > FROM_UNIXTIME('.$reference_date.') + WHERE date > \''.$reference_date.'\' AND author_id = '.$comm['author_id']; if ( pwg_db_num_rows( pwg_query( $query ) ) > 0 ) { -- cgit v1.2.3