Changeset 2146 for plugins/pollsFactory/inc/class.pollsfactory.php

Timestamp:

03/30/10 02:37:23 (13 years ago)

Author:

JcDenis

Message:

pollsFactory 1.1:

• Fixed order of queries and selections
• Fixed admin posts list actions
• Fixed adding polls from new post
• Fixed pgSQL bugs

File:

• plugins/pollsFactory/inc/class.pollsfactory.php (modified) (3 diffs)

plugins/pollsFactory/inc/class.pollsfactory.php

@@ -47 +47 @@
           if($ident > 0)
           {
-               $params['option_type'] = 'pollsresponse';
-               $params['post_id'] = $poll_id;
-               $params['option_title'] = $this->con->escape(http::realIP());
-
-               $rs = $this->getOptions($params);
+               $rs = $this->con->select(
+                    'SELECT option_id '.
+                    'FROM '.$this->table.' '.
+                    'WHERE post_id = '.$poll_id.' '.
+                    "AND option_title = '".$this->con->escape(http::realIP())."' ".
+                    "AND option_type = 'pollsresponse' ".
+                    $this->con->limit(1)
+               );
 
                if (!$rs->isEmpty()) $chk = true;
@@ -76 +79 @@
                "AND option_type = 'pollsresponse' ".
                'GROUP BY option_title, post_id '.
-               'ORDER BY option_upddt DESC '.
+               'ORDER BY option_title DESC '.
                $q
           );
@@ -84 +87 @@
      public function countVotes($poll_id)
      {
-          $params['option_type'] = 'pollsresponse';
-          $params['post_id'] = (integer) $poll_id;
-          $params['group'] = 'option_title';
+          $poll_id = (integer) $poll_id;
 
-          $rs = $this->getOptions($params);
-          
-          return $rs->count();
+          return $this->con->select(
+               'SELECT option_title '.
+               'FROM '.$this->table.' '.
+               'WHERE post_id = '.$poll_id.' '.
+               "AND option_type = 'pollsresponse' ".
+               'GROUP BY option_title '
+          )->count();
      }