[pLog-svn] r3205 - plugins/trunk/hostblock/class/dao

[oscar at devel.lifetype.net]

Author: oscar
Date: 2006-04-07 19:57:20 +0000 (Fri, 07 Apr 2006)
New Revision: 3205

Modified:
   plugins/trunk/hostblock/class/dao/blockedhosts.class.php
Log:
with this query is now easier for mysql which index to use, as long as we have the right index in place...


Modified: plugins/trunk/hostblock/class/dao/blockedhosts.class.php
===================================================================
--- plugins/trunk/hostblock/class/dao/blockedhosts.class.php	2006-04-07 19:36:53 UTC (rev 3204)
+++ plugins/trunk/hostblock/class/dao/blockedhosts.class.php	2006-04-07 19:57:20 UTC (rev 3205)
@@ -46,10 +46,13 @@
          */
         function getBlogBlacklist( $blogId, $blockType = BLOCK_COMMENT_POSTING, $includeGlobal = false )
         {
-        	$query = "SELECT * FROM ".$this->getPrefix()."host_blocking_rules ".
-                     "WHERE blog_id = $blogId";
+        	$query = "SELECT * FROM ".$this->getPrefix()."host_blocking_rules WHERE";
+        	
             if( $includeGlobal )
-            	$query .=" OR blog_id = ".GLOBALLY_BLOCKED_HOST;
+            	$query .=" blog_id IN ('".Db::qstr( $blogId )."', '".GLOBALLY_BLOCKED_HOST."') ";
+            else
+                $query .= " blog_id = '".Db::qstr( $blogId )."'";
+                
             $query .= " AND block_type = $blockType";
 
             $result = $this->Execute( $query );
@@ -129,4 +132,4 @@
             return $blockedHost;
         }
     }
-?>
+?>
\ No newline at end of file