29
There is a hack involved in the blocks..
You need to do the following.. in /class/xoopsblocks.php
This is an example from the 2.3.4 build of Multisite for XOOPS Lite edition.
le="color: #000000"><?php function getAllBlocksByGroup($groupid, $asobject = true, $side = null, $visible = null, $orderby = "b.weight,b.bid", $isactive = 1) { global $multisite_module; $db = &XoopsDatabaseFactory::getDatabaseConnection(); $ret = array(); if (! $asobject) { $sql = 'SELECT b.bid '; } else { $sql = 'SELECT b.* '; } $sql .= "FROM " . $db->prefix("newblocks") . " b LEFT JOIN " . $db->prefix("group_permission") . " l ON l.gperm_itemid=b.bid WHERE gperm_name = 'block_read' AND gperm_modid = 1"; if (is_array($groupid)) { $sql .= " AND (l.gperm_groupid=" . $groupid[0] . ""; $size = count($groupid); if ($size > 1) { for($i = 1; $i < $size; $i ++) { $sql .= " OR l.gperm_groupid=" . $groupid[$i] . ""; } } $sql .= ")"; } else { $sql .= " AND l.gperm_groupid=" . $groupid . ""; } $sql .= " AND b.isactive=" . $isactive; if (isset($side)) { // get both sides in sidebox? (some themes need this) if ($side == XOOPS_SIDEBLOCK_BOTH) { $side = "(b.side=0 OR b.side=1)"; } elseif ($side == XOOPS_CENTERBLOCK_ALL) { $side = "(b.side=3 OR b.side=4 OR b.side=5 OR b.side=7 OR b.side=8 OR b.side=9 )"; } else { $side = "b.side=" . $side; } $sql .= " AND " . $side; } if (isset($visible)) { $sql .= " AND b.visible=$visible"; } if ($multisite_module->isActive()) $sql .= " AND (b.domains like '|all%' or b.domains like '%|".str_replace('www.','',strtolower($_SERVER['HTTP_HOST']))."%')"; $sql .= " ORDER BY $orderby"; $result = $db->query($sql); $added = array(); while ($myrow = $db->fetchArray($result)) { if (! in_array($myrow['bid'], $added)) { if (! $asobject) { $ret[] = $myrow['bid']; } else { $ret[] = new XoopsBlock($myrow); } array_push($added, $myrow['bid']); } } return $ret; } /** * XoopsBlock::getAllBlocks() * * @param string $rettype * @param mixed $side * @param mixed $visible * @param string $orderby * @param integer $isactive * @return */ function getAllBlocks($rettype = "object", $side = null, $visible = null, $orderby = "side,weight,bid", $isactive = 1) { global $multisite_module; $db = &XoopsDatabaseFactory::getDatabaseConnection(); $ret = array(); $where_query = " WHERE isactive=" . $isactive; if (isset($side)) { // get both sides in sidebox? (some themes need this) if ($side == 2) { $side = "(side=0 OR side=1)"; } elseif ($side == 6) { $side = "(side=3 OR side=4 OR side=5 OR side=7 OR side=8 OR side=9)"; } else { $side = "side=" . $side; } $where_query .= " AND " . $side; } if (isset($visible)) { $where_query .= " AND visible=.". $visible; } if ($multisite_module->isActive()) $sql .= " AND (domains like '|all%' or domains like '%|".str_replace('www.','',strtolower($_SERVER['HTTP_HOST']))."%')"; $where_query .= " ORDER BY ".$orderby; switch ($rettype) { case "object": $sql = "SELECT * FROM " . $db->prefix("newblocks") . "" . $where_query; $result = $db->query($sql); while ($myrow = $db->fetchArray($result)) { $ret[] = new XoopsBlock($myrow); } break; case "list": $sql = "SELECT * FROM " . $db->prefix("newblocks") . "" . $where_query; $result = $db->query($sql); while ($myrow = $db->fetchArray($result)) { $block = new XoopsBlock($myrow); $title = $block->getVar("title"); $title = empty($title) ? $block->getVar("name") : $title; $ret[$block->getVar("bid")] = $title; } break; case "id": $sql = "SELECT bid FROM " . $db->prefix("newblocks") . "" . $where_query; $result = $db->query($sql); while ($myrow = $db->fetchArray($result)) { $ret[] = $myrow['bid']; } break; } //echo $sql; return $ret; } /** * XoopsBlock::getByModule() * * @param mixed $moduleid * @param mixed $asobject * @return */ function getByModule($moduleid, $asobject = true) { global $multisite_module; $moduleid = intval($moduleid); $db = &XoopsDatabaseFactory::getDatabaseConnection(); if ($asobject == true) { $sql = $sql = "SELECT * FROM " . $db->prefix("newblocks") . " WHERE mid=" . $moduleid; } else { $sql = "SELECT bid FROM " . $db->prefix("newblocks") . " WHERE mid=" . $moduleid; } if ($multisite_module->isActive()) $sql .= " AND (domains like '|all%' or domains like '%|".str_replace('www.','',strtolower($_SERVER['HTTP_HOST']))."%')"; $result = $db->query($sql); $ret = array(); while ($myrow = $db->fetchArray($result)) { if ($asobject) { $ret[] = new XoopsBlock($myrow); } else { $ret[] = $myrow['bid']; } } return $ret; }
the part that needs to be added is:
le="color: #000000"><?php $sql .= " AND (b.domains like '|all%' or b.domains like '%|".str_replace('www.','',strtolower($_SERVER['HTTP_HOST']))."
You will see where this is added (If you are doing a production machine the all you have to do is add this line where you see in the first code example.
