Changeset 722

Timestamp:

01/22/09 17:55:17 (14 years ago)

Author:

Tomtom33

Message:

Take care about enable plugin or not. That's running good now!

File:

• plugins/multiBlogSearch/inc/class.multi.blog.search.php (modified) (3 diffs)

plugins/multiBlogSearch/inc/class.multi.blog.search.php

@@ -22 +22 @@
      public function getPosts($params = array(),$count_only = false)
      {
+          $rs = $this->core->con->select('SELECT * FROM '.$this->core->prefix.'blog WHERE blog_status = "1"');
+          $sb = array();
+          while ($rs->fetch()) {
+               $s = new dcSettings($this->core,$rs->blog_id);
+               if ($s->multiblogsearch_enabled) {
+                    $sb[] = "P.blog_id = '".$rs->blog_id."'";
+               }
+               unset($s);
+          }
+          $where = ' ('.implode(' OR ',$sb).') ';
+          
           if ($count_only)
           {
@@ -55 +66 @@
           'FROM '.$this->core->prefix.'post P '.
           'INNER JOIN '.$this->core->prefix.'user U ON U.user_id = P.user_id '.
-          'NATURAL JOIN '.$this->core->prefix.'blog B '.
+          'LEFT OUTER JOIN '.$this->core->prefix.'blog B ON B.blog_id = P.blog_id '.
           'LEFT OUTER JOIN '.$this->core->prefix.'category C ON P.cat_id = C.cat_id ';
 
@@ -62 +73 @@
           }
 
-          $strReq .=
-          "WHERE P.blog_id != '' AND B.blog_id = P.blog_id ";
+          $strReq .= "WHERE ".$where;
+          //"WHERE P.blog_id != '' ";
 
           if (!$this->core->auth->check('contentadmin',$this->core->blog->id)) {