diff options
| author | nikrou <nikrou@piwigo.org> | 2010-06-24 18:36:24 +0000 |
|---|---|---|
| committer | nikrou <nikrou@piwigo.org> | 2010-06-24 18:36:24 +0000 |
| commit | e1ecc62b8388a6739acc37077d503e7e570cdbbb (patch) | |
| tree | 5896e67a20ca7549afe98055135e41eb77f9c13a /include | |
| parent | ad07b1c50b56a6b8ff52fb79cdfc741dfe086fb7 (diff) | |
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
Diffstat (limited to 'include')
| -rw-r--r-- | include/functions_comment.inc.php | 4 |
1 files changed, 2 insertions, 2 deletions
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 ) { |