From 5b8b0757f4f938f86bed86ae56fa3511704e006f Mon Sep 17 00:00:00 2001
From: Loui Chang <louipc.ist@gmail.com>
Date: Thu, 15 Apr 2010 16:52:55 -0400
Subject: pkg_comments: Only display 10 comments by default.

Add a mechanism to view all comments.

Signed-off-by: Loui Chang <louipc.ist@gmail.com>
---
 web/lib/pkgfuncs.inc | 29 +++++++++++++++++++++++++----
 1 file changed, 25 insertions(+), 4 deletions(-)

(limited to 'web/lib')

diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 0b65170a..49bedc36 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -194,9 +194,25 @@ function create_dummy($pname="", $sid="") {
 
 }
 
-# grab package comments
-#
-function package_comments($pkgid=0) {
+# Return the number of comments for a specified package
+function package_comments_count($pkgid = 0) {
+	if ($pkgid) {
+		$dbh = db_connect();
+		$q = "SELECT COUNT(*) FROM PackageComments ";
+		$q.= "WHERE PackageID = " . mysql_real_escape_string($pkgid);
+		$q.= " AND DelUsersID = 0";
+	}
+	$result = db_query($q, $dbh);
+
+	if (!$result) {
+		return;
+	}
+
+	return mysql_result($result, 0);
+}
+
+# Return an array of package comments
+function package_comments($pkgid = 0) {
 	$comments = array();
 	if ($pkgid) {
 		$dbh = db_connect();
@@ -206,6 +222,11 @@ function package_comments($pkgid=0) {
 		$q.= " AND PackageID = ".mysql_real_escape_string($pkgid);
 		$q.= " AND DelUsersID = 0"; # only display non-deleted comments
 		$q.= " ORDER BY CommentTS DESC";
+
+		if (!isset($_GET['comments'])) {
+			$q.= " LIMIT 10";
+		}
+
 		$result = db_query($q, $dbh);
 
 		if (!$result) {
@@ -328,7 +349,7 @@ function package_details($id=0, $SID="") {
 				include('actions_form.php');
 				include('pkg_comment_form.php');
 			}
-			
+
 			# Print Comments
 			$comments = package_comments($id);
 			if (!empty($comments)) {
-- 
cgit v1.2.3-24-g4f1b