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

Timestamp:

2006/12/12 23:43:18 (20 years ago)

Author:

uehara

Message:

 

File:

• temp/test-xoops.ec-cube.net/html/modules/xoopspoll/class/xoopspolloption.php (modified) (2 diffs)

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

@@ -98 +98 @@
 
     // public
-    function updateCount()
+    function updateCount($rating_id)
     {
-        $votes = XoopsPollLog::getTotalVotesByOptionId($this->getVar("option_id"));
-        $sql ="UPDATE ".$this->db->prefix("xoopspoll_option")." SET option_count=$votes WHERE option_id=".$this->getVar("option_id")."";
+        if($rating_id == 1) {
+            $colum = "option_count";
+        } else {
+            $colum = "minus_count";
+        }
+        $votes = XoopsPollLog::getTotalVotesByOptionId($this->getVar("option_id"), $rating_id);
+        $sql ="UPDATE ".$this->db->prefix("xoopspoll_option")." SET $colum=$votes WHERE option_id=".$this->getVar("option_id")."";
+
         $this->db->query($sql);
     }
@@ -124 +130 @@
         $db =& Database::getInstance();
         $ret = array();
-        $sql = "SELECT u.uid, u.uname, l.rating_id, l.comment FROM ".$db->prefix("xoopspoll_log")." l, ". $db->prefix("users") ." u WHERE l.user_id = u.uid AND 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";
         $result = $db->query($sql);
         while ( $myrow = $db->fetchArray($result) ) {