Changeset 826 for temp

Timestamp:

2006/12/13 10:33:19 (19 years ago)

Author:

uehara

Message:

 

Location:

temp/test-xoops.ec-cube.net/html/modules/xoopspoll/class

Files:

• xoopspolloption.php (modified) (1 diff)
• xoopspollrenderer.php (modified) (1 diff)

temp/test-xoops.ec-cube.net/html/modules/xoopspoll/class/xoopspolloption.php

@@ -126 +126 @@
 
     // public static
-    function &getAllCommentByOptionId($option_id)
+    function &getAllCommentByOptionId($option_id, $limit_start, $limit_end)
     {
         $db =& Database::getInstance();
         $ret = array();
-        $sql = "SELECT u.uid, u.uname, l.rating_id, l.comment FROM ".$db->prefix("xoopspoll_log")." l LEFT JOIN ". $db->prefix("users") ." u  ON l.user_id = u.uid WHERE l.option_id=".intval($option_id)." ORDER BY time DESC";
+        $sql = "SELECT u.uid, u.uname, l.rating_id, l.comment FROM ".$db->prefix("xoopspoll_log")." l LEFT JOIN ". $db->prefix("users") ." u  ON l.user_id = u.uid WHERE l.option_id=".intval($option_id)." ORDER BY time DESC  LIMIT $limit_start, $limit_end";
         $result = $db->query($sql);
         while ( $myrow = $db->fetchArray($result) ) {

temp/test-xoops.ec-cube.net/html/modules/xoopspoll/class/xoopspollrenderer.php

@@ -173 +173 @@
     }
 
-    function assignComment(&$tpl, $option_id)
+    function assignComment(&$tpl, $option_id, $limit_start, $limit_end)
     {
-        $arrComment =& XoopsPollOption::getAllCommentByOptionId($option_id);
+        $arrComment =& XoopsPollOption::getAllCommentByOptionId($option_id, $limit_start, $limit_end);
+        $count = $arrComment['count'];
+        array_pop($arrComment);
         $tpl->assign('arrComment', $arrComment);
+        
+        return $count;
     }