added pagination

1 files changed, 6 insertions, 5 deletions

diff --git a/cloud_comments.module b/cloud_comments.module
index 7bbbdad..467cd52 100755
--- a/cloud_comments.module
+++ b/cloud_comments.module
@@ -43,8 +43,9 @@ function cloud_comments_all() {
     );
 
     $page_content = "";
-    $query = "SELECT * FROM {scilab_cloud_comment}";
-    $query_result = db_query($query);
+    $query = "SELECT scc.*, tcc.number AS chapter_no, tce.number AS example_no FROM scilab_cloud_comment scc LEFT JOIN textbook_companion_chapter tcc ON tcc.id = scc.chapter LEFT JOIN textbook_companion_example tce ON tce.id = scc.example ORDER BY scc.date DESC";
+    $query_result = pager_query($query, 5, 0 );
+    //$query_result = db_query($query);
 
     while ($row = db_fetch_object($query_result)) {
 
@@ -65,7 +66,7 @@ function cloud_comments_all() {
         $qr = db_query($q, $row->chapter);
         $obj = db_fetch_object($qr);
         $chapter = $obj->name?$obj->name:"None";
-        $page_content .= t("<div class='type'> <b>Chapter: </b> ") . $chapter . t("</div>");
+        $page_content .= t("<div class='type'> <b>Chapter: </b> ") . $chapter . ($row->chapter_no?" (<b>{$row->chapter_no}</b>)":"") . t("</div>");
 
         $page_content .= t("<div class='type'> <b>Category: </b>") . $categories[$row->category] . t("</div>");
 
@@ -74,7 +75,7 @@ function cloud_comments_all() {
         $obj = db_fetch_object($qr);
         $example_link = $obj->caption?l($obj->caption,"http://cloud.scilab.in/index.php?eid=".$row->example):"None";
 
-        $page_content .= t("<div class='example'> <b>Example: </b>") . $example_link .t("</div>");
+        $page_content .= t("<div class='example'> <b>Example: </b>") . $example_link . ($row->example_no?" (<b>{$row->example_no}</b>)":"") . t("</div>");
 
         $page_content .= t("<div class='comment'> <br><b>Comment:</b><br>") . $row->comment . t("</div>");
 
@@ -92,7 +93,7 @@ function cloud_comments_all() {
         }
         $page_content .= t("</div>");
     } // while ends
-
+	$page_content .= theme('pager', NULL, 5, 0);
     return $page_content;
 } // function cloud_comments_all