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=">>>" 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'
|