diff options
| author | Loui Chang <louipc.ist@gmail.com> | 2010-04-15 16:52:55 -0400 |
|---|---|---|
| committer | Loui Chang <louipc.ist@gmail.com> | 2010-04-15 16:52:55 -0400 |
| commit | 5b8b0757f4f938f86bed86ae56fa3511704e006f (patch) | |
| tree | 5e9576e04a93309c1e931afc7836d844af26cd89 /web/lib | |
| parent | 94da2bf1dceeff037933755912dd333302ca5ec9 (diff) | |
| download | aurweb-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.inc | 29 |
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)) { |