Changeset 812 for temp/test-xoops.ec-cube.net

Timestamp:

2006/12/13 10:01:48 (19 years ago)

Author:

uehara

Message:

 

Location:

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

Files:

• class/xoopspolloption.php (modified) (1 diff)
• class/xoopspollrenderer.php (modified) (1 diff)
• pollresults.php (modified) (2 diffs)

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

@@ -155 +155 @@
         
     // public static
-    function &getAllOption()
+    function &getAllOption($limit_start, $limit_end)
     {
         $db =& Database::getInstance();
         $ret = array();
-        $sql = "SELECT * FROM ".$db->prefix("xoopspoll_option") . " ORDER BY update_date DESC";
+        $sql = "SELECT * FROM ".$db->prefix("xoopspoll_option") . " ORDER BY update_date DESC LIMIT $limit_start, $limit_end";
         $result = $db->query($sql);
         while ( $myrow = $db->fetchArray($result) ) {
             $ret[] = $myrow;
         }
+        $sql = "SELECT count(*) as count FROM ".$db->prefix("xoopspoll_option") . " ORDER BY update_date DESC";
+        $result = $db->query($sql);
+        $myrow = $db->fetchArray($result);
+        
+        $ret['count'] = $myrow['count'];
         //echo $sql;
         return $ret;

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

@@ -151 +151 @@
     }
     
-    function assignOptions(&$tpl)
+    function assignOptions(&$tpl, $limit_start, $limit_end)
     {
-        $arrOption =& XoopsPollOption::getAllOption();
+        $arrOption =& XoopsPollOption::getAllOption($limit_start, $limit_end);
         $tpl->assign('arrOption', $arrOption);
         
-        return $arrOption;
+        return $arrOption['count'];
     }
 

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

@@ -49 +49 @@
 $renderer = new XoopsPollRenderer($poll);
 $renderer->assignResults($xoopsTpl);
-$arrOption = $renderer->assignOptions($xoopsTpl);
+$count = $renderer->assignOptions($xoopsTpl, $start, POLL_OPTION_VIEW);
 
 $xoopsTpl->assign('arrStatus', $arrStatus);
@@ -55 +55 @@
 $xoopsTpl->assign('poll_id', $poll_id);
 
-$nav = new XoopsPageNav(count($arrOption), POLL_OPTION_VIEW, $start, "start", 'poll_id='.$poll_id);
+$nav = new XoopsPageNav($count, POLL_OPTION_VIEW, $start, "start", 'poll_id='.$poll_id);
 $xoopsTpl->assign('forum_pagenav', $nav->renderNav(4));