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 +++++++++++++++++++++++++----
 web/template/pkg_comments.php | 12 +++++++++++-
 2 files changed, 36 insertions(+), 5 deletions(-)

(limited to 'web')

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)) {
diff --git a/web/template/pkg_comments.php b/web/template/pkg_comments.php
index 7c42ac16..02171a03 100644
--- a/web/template/pkg_comments.php
+++ b/web/template/pkg_comments.php
@@ -24,5 +24,15 @@ while (list($indx, $carr) = each($comments)) { ?>
 	</div>
 	</blockquote>
 <?php
-} ?>
+}
+?>
 </div>
+
+<?php
+$count = package_comments_count($_GET['ID']);
+if ($count > 10 && !isset($_GET['comments'])) {
+	echo '<div class="pgbox">';
+	echo '<a href="'. $_SERVER['PHP_SELF'] . '?ID=' . $_REQUEST['ID'] . '&comments=all">'. __('Show all %s comments', $count) . '</a>';
+	echo '</div>';
+}
+?>
-- 
cgit v1.2.3-24-g4f1b