[php-blog-cvs] serendipity serendipity_admin_comments.inc.php,1.16,1.17 NEWS,1.213,1.214

[Garvin H. <gar...@us...>]

Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv21748

Modified Files:
	serendipity_admin_comments.inc.php NEWS 
Log Message:
fix comment moderation panel for postgresql


Index: NEWS
===================================================================
RCS file: /cvsroot/php-blog/serendipity/NEWS,v
retrieving revision 1.213
retrieving revision 1.214
diff -u -d -r1.213 -r1.214
--- NEWS	9 Sep 2004 10:52:03 -0000	1.213
+++ NEWS	9 Sep 2004 11:17:27 -0000	1.214
@@ -3,6 +3,9 @@
 Version 0.7 ()
 ------------------------------------------------------------------------
 
+    * Fixed postgresql bug for viewing comment moderation panel
+      (garvinhicking)
+
     * Fixed postgresql bug for fetching the last entry id. Will fix bug
       with comment counter always reporting zero and trouble with
       assigning multiple categories. (garvinhicking)

Index: serendipity_admin_comments.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/serendipity_admin_comments.inc.php,v
retrieving revision 1.16
retrieving revision 1.17
diff -u -d -r1.16 -r1.17
--- serendipity_admin_comments.inc.php	31 Aug 2004 10:58:20 -0000	1.16
+++ serendipity_admin_comments.inc.php	9 Sep 2004 11:17:27 -0000	1.17
@@ -136,7 +136,7 @@
     $linkNext = '<input type="button" name="serendipity[nextpage]" value="&gt;&gt;&gt;" disabled="disabled" />';
 }
 
-$limit=serendipity_db_limit_sql(($page-1)*$commentsPerPage .",". $commentsPerPage);
+$limit = serendipity_db_limit_sql(serendipity_db_limit(($page-1)*$commentsPerPage, $commentsPerPage));
 $sql = serendipity_db_query("SELECT c.*, e.title FROM {$serendipity['dbPrefix']}comments c
                                 LEFT JOIN {$serendipity['dbPrefix']}entries e ON (e.id = c.entry_id)
                                 WHERE type = 'NORMAL'