summaryrefslogtreecommitdiffstats
path: root/web/lib
diff options
context:
space:
mode:
authorLoui Chang <louipc.ist@gmail.com>2010-04-15 16:52:55 -0400
committerLoui Chang <louipc.ist@gmail.com>2010-04-15 16:52:55 -0400
commit5b8b0757f4f938f86bed86ae56fa3511704e006f (patch)
tree5e9576e04a93309c1e931afc7836d844af26cd89 /web/lib
parent94da2bf1dceeff037933755912dd333302ca5ec9 (diff)
downloadaurweb-5b8b0757f4f938f86bed86ae56fa3511704e006f.tar.xz
pkg_comments: Only display 10 comments by default.
Add a mechanism to view all comments. Signed-off-by: Loui Chang <louipc.ist@gmail.com>
Diffstat (limited to 'web/lib')
-rw-r--r--web/lib/pkgfuncs.inc29
1 files changed, 25 insertions, 4 deletions
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 0b65170..49bedc3 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)) {