Changeset 770 for temp/test-xoops.ec-cube.net/html/modules/xoopspoll/class/xoopspolllog.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/xoopspolllog.php (modified) (5 diffs)

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

@@ -45 +45 @@
         $this->initVar("user_id", XOBJ_DTYPE_INT, 0);
         $this->initVar("time", XOBJ_DTYPE_INT, null);
+        $this->initVar("rating_id", XOBJ_DTYPE_INT, null);
+        $this->initVar("comment", XOBJ_DTYPE_TXTAREA, null);
         if ( !empty($id) ) {
             if ( is_array($id) ) {
@@ -63 +65 @@
             $$k = $v;
         }
+
         $log_id = $this->db->genId($this->db->prefix("xoopspoll_log")."_log_id_seq");
-        $sql = "INSERT INTO ".$this->db->prefix("xoopspoll_log")." (log_id, poll_id, option_id, ip, user_id, time) VALUES ($log_id, $poll_id, $option_id, ".$this->db->quoteString($ip).", $user_id, ".time().")";
+        $sql = "INSERT INTO ".$this->db->prefix("xoopspoll_log")." (log_id, poll_id, option_id, ip, user_id, time, rating_id, comment) VALUES ($log_id, $poll_id, $option_id, ".$this->db->quoteString($ip).", $user_id, ".time().", $rating_id, ".$this->db->quoteString($comment).")";
         $result = $this->db->query($sql);
         if (!$result) {
@@ -148 +151 @@
     {
         $db =& Database::getInstance();
-        $sql = "SELECT DISTINCT user_id FROM ".$db->prefix("xoopspoll_log")." WHERE poll_id=".intval($poll_id)." AND user_id > 0";
+        $sql = "SELECT DISTINCT user_id FROM ".$db->prefix("xoopspoll_log")." WHERE poll_id=".intval($poll_id)." AND user_id > 0 AND rating_id = 1";
         $users = $db->getRowsNum($db->query($sql));
-        $sql = "SELECT DISTINCT ip FROM ".$db->prefix("xoopspoll_log")." WHERE poll_id=".intval($poll_id)." AND user_id=0";
+        $sql = "SELECT DISTINCT ip FROM ".$db->prefix("xoopspoll_log")." WHERE poll_id=".intval($poll_id)." AND user_id=0 AND rating_id = 1";
         $anons = $db->getRowsNum($db->query($sql));
         return $users+$anons;
@@ -159 +162 @@
     {
         $db =& Database::getInstance();
-        $sql = "SELECT COUNT(*) FROM ".$db->prefix("xoopspoll_log")." WHERE poll_id = ".intval($poll_id);
+        $sql = "SELECT COUNT(*) FROM ".$db->prefix("xoopspoll_log")." WHERE poll_id = ".intval($poll_id)." AND rating_id = 1";
         list($votes) = $db->fetchRow($db->query($sql));
         return $votes;
@@ -165 +168 @@
 
     // public static
-    function getTotalVotesByOptionId($option_id)
+    function getTotalVotesByOptionId($option_id, $rating_id)
     {
         $db =& Database::getInstance();
-        $sql = "SELECT COUNT(*) FROM ".$db->prefix("xoopspoll_log")." WHERE option_id = ".intval($option_id);
+        $sql = "SELECT COUNT(*) FROM ".$db->prefix("xoopspoll_log")." WHERE option_id = ".intval($option_id)." AND rating_id = $rating_id";
         list($votes) = $db->fetchRow($db->query($sql));
         return $votes;