Minahito
minah****@users*****
2007年 4月 18日 (水) 13:57:16 JST
Index: xoops2jp/html/kernel/block.php
diff -u xoops2jp/html/kernel/block.php:1.2.8.10.2.4.2.1 xoops2jp/html/kernel/block.php:1.2.8.10.2.4.2.2
--- xoops2jp/html/kernel/block.php:1.2.8.10.2.4.2.1 Tue Apr 17 18:06:09 2007
+++ xoops2jp/html/kernel/block.php Wed Apr 18 13:57:16 2007
@@ -1,5 +1,5 @@
<?php
-// $Id: block.php,v 1.2.8.10.2.4.2.1 2007/04/17 09:06:09 minahito Exp $
+// $Id: block.php,v 1.2.8.10.2.4.2.2 2007/04/18 04:57:16 minahito Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
@@ -790,7 +790,7 @@
$blockids[] = $myrow['gperm_itemid'];
}
if (!empty($blockids)) {
- $sql = 'SELECT b.* FROM '.$this->db->prefix('newblocks').' b, '.$this->db->prefix('block_module_link').' m, ' . $this->db->prefix('modules') . ' md WHERE m.block_id=b.bid';
+ $sql = 'SELECT b.* FROM '.$this->db->prefix('newblocks').' b, '.$this->db->prefix('block_module_link').' m WHERE m.block_id=b.bid';
$sql .= ' AND b.isactive=1 AND b.visible=1';
if ($mid !== false && $mid !== 0) {
$sql .= ' AND m.module_id IN (0,'.intval($mid).')';
@@ -798,8 +798,6 @@
$sql .= ' AND m.module_id=0';
}
- $sql .= ' AND b.mid = md.mid AND md.isactive=1';
-
//
// SIDE
//