Menu
▾
▴
[xoops-svn] SF.net SVN: xoops-svn:[11680] XoopsCore/branches/2.5.x
|
From: <txm...@us...> - 2013-06-15 12:02:28
|
Revision: 11680
http://sourceforge.net/p/xoops/svn/11680
Author: txmodxoops
Date: 2013-06-15 12:02:25 +0000 (Sat, 15 Jun 2013)
Log Message:
-----------
Added footer blocks
Added Paths:
-----------
XoopsCore/branches/2.5.x/2.5.6_timgno/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/class/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/class/xoopsblock.php
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/include/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/include/defines.php
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/admin/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/admin/system_blocks.html
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/class/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/class/block.php
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/themes/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/themes/default/
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/themes/default/centerFooter.html
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/themes/default/leftFooter.html
XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/themes/default/rightFooter.html
Added: XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/class/xoopsblock.php
===================================================================
--- XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/class/xoopsblock.php (rev 0)
+++ XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/class/xoopsblock.php 2013-06-15 12:02:25 UTC (rev 11680)
@@ -0,0 +1,619 @@
+<?php
+/**
+ * XOOPS Block management
+ *
+ * You may not change or alter any portion of this comment or credits
+ * of supporting developers from this source code or any supporting source code
+ * which is considered copyrighted (c) material of the original comment or credit authors.
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
+ *
+ * @copyright The XOOPS Project http://sourceforge.net/projects/xoops/
+ * @license GNU GPL 2 (http://www.gnu.org/licenses/old-licenses/gpl-2.0.html)
+ * @package kernel
+ * @since 2.0.0
+ * @author Kazumi Ono (AKA onokazu) http://www.myweb.ne.jp/, http://www.xoops.org/, http://jp.xoops.org/
+ * @author Skalpa Keo <sk...@xo...>
+ * @author Taiwen Jiang <ph...@us...>
+ * @version $Id: xoopsblock.php 8066 2011-11-06 05:09:33Z beckmi $
+ */
+
+defined('XOOPS_ROOT_PATH') or die('Restricted access');
+
+include_once $GLOBALS['xoops']->path( 'kernel/object.php' );
+
+class XoopsBlock extends XoopsObject
+{
+ var $db;
+
+ function XoopsBlock($id = null)
+ {
+ $this->db =& XoopsDatabaseFactory::getDatabaseConnection();
+ $this->initVar('bid', XOBJ_DTYPE_INT, null, false);
+ $this->initVar('mid', XOBJ_DTYPE_INT, 0, false);
+ $this->initVar('func_num', XOBJ_DTYPE_INT, 0, false);
+ $this->initVar('options', XOBJ_DTYPE_TXTBOX, null, false, 255);
+ $this->initVar('name', XOBJ_DTYPE_TXTBOX, null, true, 150);
+ //$this->initVar('position', XOBJ_DTYPE_INT, 0, false);
+ $this->initVar('title', XOBJ_DTYPE_TXTBOX, null, false, 150);
+ $this->initVar('content', XOBJ_DTYPE_TXTAREA, null, false);
+ $this->initVar('side', XOBJ_DTYPE_INT, 0, false);
+ $this->initVar('weight', XOBJ_DTYPE_INT, 0, false);
+ $this->initVar('visible', XOBJ_DTYPE_INT, 0, false);
+ // The block_type is in a mess, let's say:
+ // S - generated by system module
+ // M - generated by a non-system module
+ // C - Custom block
+ // D - cloned system/module block
+ // E - cloned custom block, DON'T use it
+ $this->initVar('block_type', XOBJ_DTYPE_OTHER, null, false);
+ $this->initVar('c_type', XOBJ_DTYPE_OTHER, null, false);
+ $this->initVar('isactive', XOBJ_DTYPE_INT, null, false);
+
+ $this->initVar('dirname', XOBJ_DTYPE_TXTBOX, null, false, 50);
+ $this->initVar('func_file', XOBJ_DTYPE_TXTBOX, null, false, 50);
+ $this->initVar('show_func', XOBJ_DTYPE_TXTBOX, null, false, 50);
+ $this->initVar('edit_func', XOBJ_DTYPE_TXTBOX, null, false, 50);
+
+ $this->initVar('template', XOBJ_DTYPE_OTHER, null, false);
+ $this->initVar('bcachetime', XOBJ_DTYPE_INT, 0, false);
+ $this->initVar('last_modified', XOBJ_DTYPE_INT, 0, false);
+
+ if (!empty($id)) {
+ if (is_array($id)) {
+ $this->assignVars($id);
+ } else {
+ $this->load(intval($id));
+ }
+ }
+ }
+
+ /**
+ * Load $id
+ *
+ * @param int $id
+ */
+ function load($id)
+ {
+ $id = intval($id);
+ $sql = 'SELECT * FROM ' . $this->db->prefix('newblocks') . ' WHERE bid = ' . $id;
+ $arr = $this->db->fetchArray($this->db->query($sql));
+ $this->assignVars($arr);
+ }
+
+ /**
+ * Store Block Data to Database
+ *
+ * @return int $id
+ */
+ function store()
+ {
+ if (!$this->cleanVars()) {
+ return false;
+ }
+ foreach ($this->cleanVars as $k => $v) {
+ ${$k} = $v;
+ }
+ if (empty($bid)) {
+ $bid = $this->db->genId($this->db->prefix("newblocks") . "_bid_seq");
+ $sql = sprintf("INSERT INTO %s (bid, mid, func_num, options, name, title, content, side, weight, visible, block_type, c_type, isactive, dirname, func_file, show_func, edit_func, template, bcachetime, last_modified) VALUES (%u, %u, %u, %s, %s, %s, %s, %u, %u, %u, %s, %s, %u, %s, %s, %s, %s, %s, %u, %u)", $this->db->prefix('newblocks'), $bid, $mid, $func_num, $this->db->quoteString($options), $this->db->quoteString($name), $this->db->quoteString($title), $this->db->quoteString($content), $side, $weight, $visible, $this->db->quoteString($block_type), $this->db->quoteString($c_type), 1, $this->db->quoteString($dirname), $this->db->quoteString($func_file), $this->db->quoteString($show_func), $this->db->quoteString($edit_func), $this->db->quoteString($template), $bcachetime, time());
+ } else {
+ $sql = "UPDATE " . $this->db->prefix("newblocks") . " SET options=" . $this->db->quoteString($options);
+ // a custom block needs its own name
+ if ($this->isCustom() /* in_array( $block_type , array( 'C' , 'E' ) ) */) {
+ $sql .= ", name=" . $this->db->quoteString($name);
+ }
+ $sql .= ", isactive=" . $isactive . ", title=" . $this->db->quoteString($title) . ", content=" . $this->db->quoteString($content) . ", side=" . $side . ", weight=" . $weight . ", visible=" . $visible . ", c_type=" . $this->db->quoteString($c_type) . ", template=" . $this->db->quoteString($template) . ", bcachetime=" . $bcachetime . ", last_modified=" . time() . " WHERE bid=" . $bid;
+ }
+ if (!$this->db->query($sql)) {
+ $this->setErrors("Could not save block data into database");
+ return false;
+ }
+ if (empty($bid)) {
+ $bid = $this->db->getInsertId();
+ }
+ return $bid;
+ }
+
+ /**
+ * Delete a ID from the database
+ *
+ * @return bool
+ */
+ function delete()
+ {
+ $sql = sprintf("DELETE FROM %s WHERE bid = %u", $this->db->prefix('newblocks'), $this->getVar('bid'));
+ if (! $this->db->query($sql)) {
+ return false;
+ }
+ $sql = sprintf("DELETE FROM %s WHERE gperm_name = 'block_read' AND gperm_itemid = %u AND gperm_modid = 1", $this->db->prefix('group_permission'), $this->getVar('bid'));
+ $this->db->query($sql);
+ $sql = sprintf("DELETE FROM %s WHERE block_id = %u", $this->db->prefix('block_module_link'), $this->getVar('bid'));
+ $this->db->query($sql);
+ return true;
+ }
+
+ /**
+ * do stripslashes/htmlspecialchars according to the needed output
+ *
+ * @param $format output use: S for Show and E for Edit
+ * @param $c_type type of block content
+ * @returns string
+ */
+ function getContent($format = 's', $c_type = 't')
+ {
+ switch ($format) {
+ case 's':
+ // check the type of content
+ // H : custom HTML block
+ // P : custom PHP block
+ // S : use text sanitizater (smilies enabled)
+ // T : use text sanitizater (smilies disabled)
+ if ($c_type == 'H') {
+ return str_replace('{X_SITEURL}', XOOPS_URL . '/', $this->getVar('content', 'n'));
+ } else if ($c_type == 'P') {
+ ob_start();
+ echo eval($this->getVar('content', 'n'));
+ $content = ob_get_contents();
+ ob_end_clean();
+ return str_replace('{X_SITEURL}', XOOPS_URL . '/', $content);
+ } else if ($c_type == 'S') {
+ $myts =& MyTextSanitizer::getInstance();
+ $content = str_replace('{X_SITEURL}', XOOPS_URL . '/', $this->getVar('content', 'n'));
+ return $myts->displayTarea($content, 1, 1);
+ } else {
+ $myts =& MyTextSanitizer::getInstance();
+ $content = str_replace('{X_SITEURL}', XOOPS_URL . '/', $this->getVar('content', 'n'));
+ return $myts->displayTarea($content, 1, 0);
+ }
+ break;
+ case 'e':
+ return $this->getVar('content', 'e');
+ break;
+ default:
+ return $this->getVar('content', 'n');
+ break;
+ }
+ }
+
+ /**
+ * Build Block
+ *
+ * @return unknown
+ */
+ function buildBlock()
+ {
+ global $xoopsConfig, $xoopsOption, $xoTheme;
+ $block = array();
+ if (!$this->isCustom()) {
+ // get block display function
+ $show_func = $this->getVar('show_func');
+ if (!$show_func) {
+ return false;
+ }
+ if (!file_exists($func_file = $GLOBALS['xoops']->path('modules/' . $this->getVar('dirname') . '/blocks/' . $this->getVar('func_file')))) {
+ return false;
+ }
+ // must get lang files b4 including the file
+ // some modules require it for code that is outside the function
+ xoops_loadLanguage('blocks', $this->getVar('dirname'));
+ include_once $func_file;
+
+ if (function_exists($show_func)) {
+ // execute the function
+ $options = explode('|', $this->getVar('options'));
+ $block = $show_func($options);
+ if (!$block) {
+ return false;
+ }
+ } else {
+ return false;
+ }
+ } else {
+ // it is a custom block, so just return the contents
+ $block['content'] = $this->getContent('s', $this->getVar('c_type'));
+ if (empty($block['content'])) {
+ return false;
+ }
+ }
+ return $block;
+ }
+
+ /*
+ * Aligns the content of a block
+ * If position is 0, content in DB is positioned
+ * before the original content
+ * If position is 1, content in DB is positioned
+ * after the original content
+ */
+ function buildContent($position, $content = "", $contentdb = "")
+ {
+ if ($position == 0) {
+ $ret = $contentdb . $content;
+ } else if ($position == 1) {
+ $ret = $content . $contentdb;
+ }
+ return $ret;
+ }
+
+ /**
+ * Enter description here...
+ *
+ * @param string $originaltitle
+ * @param string $newtitle
+ * @return string title
+ */
+ function buildTitle($originaltitle, $newtitle = '')
+ {
+ if ($newtitle != '') {
+ $ret = $newtitle;
+ } else {
+ $ret = $originaltitle;
+ }
+ return $ret;
+ }
+
+ /**
+ * XoopsBlock::isCustom()
+ *
+ * @return
+ */
+ function isCustom()
+ {
+ return in_array($this->getVar('block_type'), array(
+ 'C' ,
+ 'E'));
+ }
+
+ /**
+ * XoopsBlock::getOptions()
+ *
+ * @return
+ */
+ function getOptions()
+ {
+ global $xoopsConfig;
+ if (!$this->isCustom()) {
+ $edit_func = $this->getVar('edit_func');
+ if (!$edit_func) {
+ return false;
+ }
+ if (file_exists($GLOBALS['xoops']->path('modules/' . $this->getVar('dirname') . '/blocks/' . $this->getVar('func_file')))) {
+ if (file_exists($file = $GLOBALS['xoops']->path('modules/' . $this->getVar('dirname') . '/language/' . $xoopsConfig['language'] . '/blocks.php'))) {
+ include_once $file;
+ } elseif (file_exists($file = $GLOBALS['xoops']->path('modules/' . $this->getVar('dirname') . '/language/english/blocks.php'))) {
+ include_once $file;
+ }
+ include_once $GLOBALS['xoops']->path('modules/' . $this->getVar('dirname') . '/blocks/' . $this->getVar('func_file'));
+ $options = explode("|", $this->getVar("options"));
+ $edit_form = $edit_func($options);
+ if (!$edit_form) {
+ return false;
+ }
+ return $edit_form;
+ } else {
+ return false;
+ }
+ } else {
+ return false;
+ }
+ }
+
+ /**
+ * get all the blocks that match the supplied parameters
+ * @param $side 0: sideblock - left
+ * 1: sideblock - right
+ * 2: sideblock - left and right
+ * 3: centerblock - left
+ * 4: centerblock - right
+ * 5: centerblock - center
+ * 6: centerblock - left, right, center
+ * @param $groupid groupid (can be an array)
+ * @param $visible 0: not visible 1: visible
+ * @param $orderby order of the blocks
+ * @returns array of block objects
+ */
+ function getAllBlocksByGroup($groupid, $asobject = true, $side = null, $visible = null, $orderby = "b.weight,b.bid", $isactive = 1)
+ {
+ $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 )";
+ } elseif ($side == XOOPS_FOOTERBLOCK_ALL) {
+ $side = "(b.side=10 OR b.side=11 OR b.side=12 )";
+ } else {
+ $side = "b.side=" . $side;
+ }
+ $sql .= " AND " . $side;
+ }
+ if (isset($visible)) {
+ $sql .= " AND b.visible=$visible";
+ }
+ $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)
+ {
+ $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)";
+ } elseif ($side == 10) {
+ $side = "(side=11 OR side=12 OR side=13)";
+ } else {
+ $side = "side=" . $side;
+ }
+ $where_query .= " AND " . $side;
+ }
+ if (isset($visible)) {
+ $where_query .= " AND visible=.". $visible;
+ }
+ $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)
+ {
+ $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;
+ }
+ $result = $db->query($sql);
+ $ret = array();
+ while ($myrow = $db->fetchArray($result)) {
+ if ($asobject) {
+ $ret[] = new XoopsBlock($myrow);
+ } else {
+ $ret[] = $myrow['bid'];
+ }
+ }
+ return $ret;
+ }
+
+ /**
+ * XoopsBlock::getAllByGroupModule()
+ *
+ * @param mixed $groupid
+ * @param integer $module_id
+ * @param mixed $toponlyblock
+ * @param mixed $visible
+ * @param string $orderby
+ * @param integer $isactive
+ * @return
+ */
+ function getAllByGroupModule($groupid, $module_id = 0, $toponlyblock = false, $visible = null, $orderby = 'b.weight, m.block_id', $isactive = 1)
+ {
+ $isactive = intval($isactive);
+ $db =& XoopsDatabaseFactory::getDatabaseConnection();
+ $ret = array();
+ if (isset($groupid)) {
+ $sql = "SELECT DISTINCT gperm_itemid FROM " . $db->prefix('group_permission') . " WHERE gperm_name = 'block_read' AND gperm_modid = 1";
+ if (is_array($groupid)) {
+ $sql .= ' AND gperm_groupid IN (' . implode(',', $groupid) . ')';
+ } else {
+ if (intval($groupid) > 0) {
+ $sql .= ' AND gperm_groupid=' . intval($groupid);
+ }
+ }
+ $result = $db->query($sql);
+ $blockids = array();
+ while ($myrow = $db->fetchArray($result)) {
+ $blockids[] = $myrow['gperm_itemid'];
+ }
+ if (empty($blockids)) {
+ return $blockids;
+ }
+ }
+ $sql = 'SELECT b.* FROM ' . $db->prefix('newblocks') . ' b, ' . $db->prefix('block_module_link') . ' m WHERE m.block_id=b.bid';
+ $sql .= ' AND b.isactive=' . $isactive;
+ if (isset($visible)) {
+ $sql .= ' AND b.visible=' . intval($visible);
+ }
+ if (!isset($module_id)) {
+ } else if (!empty($module_id)) {
+ $sql .= ' AND m.module_id IN (0,' . intval($module_id);
+ if ($toponlyblock) {
+ $sql .= ',-1';
+ }
+ $sql .= ')';
+ } else {
+ if ($toponlyblock) {
+ $sql .= ' AND m.module_id IN (0,-1)';
+ } else {
+ $sql .= ' AND m.module_id=0';
+ }
+ }
+ if (!empty($blockids)) {
+ $sql .= ' AND b.bid IN (' . implode(',', $blockids) . ')';
+ }
+ $sql .= ' ORDER BY ' . $orderby;
+ $result = $db->query($sql);
+ while ($myrow = $db->fetchArray($result)) {
+ $block = new XoopsBlock($myrow);
+ $ret[$myrow['bid']] = & $block;
+ unset($block);
+ }
+ return $ret;
+ }
+
+ /**
+ * XoopsBlock::getNonGroupedBlocks()
+ *
+ * @param integer $module_id
+ * @param mixed $toponlyblock
+ * @param mixed $visible
+ * @param string $orderby
+ * @param integer $isactive
+ * @return
+ */
+ function getNonGroupedBlocks($module_id = 0, $toponlyblock = false, $visible = null, $orderby = 'b.weight, m.block_id', $isactive = 1)
+ {
+ $db =& XoopsDatabaseFactory::getDatabaseConnection();
+ $ret = array();
+ $bids = array();
+ $sql = "SELECT DISTINCT(bid) from " . $db->prefix('newblocks');
+ if ($result = $db->query($sql)) {
+ while ($myrow = $db->fetchArray($result)) {
+ $bids[] = $myrow['bid'];
+ }
+ }
+ $sql = "SELECT DISTINCT(p.gperm_itemid) from " . $db->prefix('group_permission') . " p, " . $db->prefix('groups') . " g WHERE g.groupid=p.gperm_groupid AND p.gperm_name='block_read'";
+ $grouped = array();
+ if ($result = $db->query($sql)) {
+ while ($myrow = $db->fetchArray($result)) {
+ $grouped[] = $myrow['gperm_itemid'];
+ }
+ }
+ $non_grouped = array_diff($bids, $grouped);
+ if (!empty($non_grouped)) {
+ $sql = 'SELECT b.* FROM ' . $db->prefix('newblocks') . ' b, ' . $db->prefix('block_module_link') . ' m WHERE m.block_id=b.bid';
+ $sql .= ' AND b.isactive=' . intval($isactive);
+ if (isset($visible)) {
+ $sql .= ' AND b.visible=' . intval($visible);
+ }
+ if (!isset($module_id)) {
+ } else if (!empty($module_id)) {
+ $sql .= ' AND m.module_id IN (0,' . intval($module_id);
+ if ($toponlyblock) {
+ $sql .= ',-1';
+ }
+ $sql .= ')';
+ } else {
+ if ($toponlyblock) {
+ $sql .= ' AND m.module_id IN (0,-1)';
+ } else {
+ $sql .= ' AND m.module_id=0';
+ }
+ }
+ $sql .= ' AND b.bid IN (' . implode(',', $non_grouped) . ')';
+ $sql .= ' ORDER BY ' . $orderby;
+ $result = $db->query($sql);
+ while ($myrow = $db->fetchArray($result)) {
+ $block = new XoopsBlock($myrow);
+ $ret[$myrow['bid']] =& $block;
+ unset($block);
+ }
+ }
+ return $ret;
+ }
+
+ /**
+ * XoopsBlock::countSimilarBlocks()
+ *
+ * @param mixed $moduleId
+ * @param mixed $funcNum
+ * @param mixed $showFunc
+ * @return
+ */
+ function countSimilarBlocks($moduleId, $funcNum, $showFunc = null)
+ {
+ $funcNum = intval($funcNum);
+ $moduleId = intval($moduleId);
+ if ($funcNum < 1 || $moduleId < 1) {
+ // invalid query
+ return 0;
+ }
+ $db =& XoopsDatabaseFactory::getDatabaseConnection();
+ if (isset($showFunc)) {
+ // showFunc is set for more strict comparison
+ $sql = sprintf("SELECT COUNT(*) FROM %s WHERE mid = %d AND func_num = %d AND show_func = %s", $db->prefix('newblocks'), $moduleId, $funcNum, $db->quoteString(trim($showFunc)));
+ } else {
+ $sql = sprintf("SELECT COUNT(*) FROM %s WHERE mid = %d AND func_num = %d", $db->prefix('newblocks'), $moduleId, $funcNum);
+ }
+ if (!$result = $db->query($sql)) {
+ return 0;
+ }
+ list ($count) = $db->fetchRow($result);
+ return $count;
+ }
+}
+?>
\ No newline at end of file
Added: XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/include/defines.php
===================================================================
--- XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/include/defines.php (rev 0)
+++ XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/include/defines.php 2013-06-15 12:02:25 UTC (rev 11680)
@@ -0,0 +1,123 @@
+<?php
+/**
+ * XOOPS constansts
+ *
+ * You may not change or alter any portion of this comment or credits
+ * of supporting developers from this source code or any supporting source code
+ * which is considered copyrighted (c) material of the original comment or credit authors.
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
+ *
+ * @copyright The XOOPS Project http://sourceforge.net/projects/xoops/
+ * @license GNU GPL 2 (http://www.gnu.org/licenses/old-licenses/gpl-2.0.html)
+ * @package kernel
+ * @since 2.0.0
+ * @version $Id: defines.php 10054 2012-08-11 10:06:44Z beckmi $
+ */
+
+defined('XOOPS_ROOT_PATH') or die('Restricted access');
+
+/**
+ * Define required Defines (I guess lol )
+ */
+define('XOOPS_SIDEBLOCK_LEFT', 0);
+define('XOOPS_SIDEBLOCK_RIGHT', 1);
+define('XOOPS_SIDEBLOCK_BOTH', 2);
+define('XOOPS_CENTERBLOCK_LEFT', 3);
+define('XOOPS_CENTERBLOCK_RIGHT', 4);
+define('XOOPS_CENTERBLOCK_CENTER', 5);
+define('XOOPS_CENTERBLOCK_ALL', 6);
+define('XOOPS_CENTERBLOCK_BOTTOMLEFT', 7);
+define('XOOPS_CENTERBLOCK_BOTTOMRIGHT', 8);
+define('XOOPS_CENTERBLOCK_BOTTOM', 9);
+define('XOOPS_FOOTERBLOCK_ALL', 10);
+define('XOOPS_FOOTERBLOCK_LEFT', 11);
+define('XOOPS_FOOTERBLOCK_RIGHT', 12);
+define('XOOPS_FOOTERBLOCK_CENTER', 13);
+define('XOOPS_BLOCK_INVISIBLE', 0);
+define('XOOPS_BLOCK_VISIBLE', 1);
+define('XOOPS_MATCH_START', 0);
+define('XOOPS_MATCH_END', 1);
+define('XOOPS_MATCH_EQUAL', 2);
+define('XOOPS_MATCH_CONTAIN', 3);
+// YOU SHOULD AVOID USING THE FOLLOWING CONSTANTS, THEY WILL BE REMOVED
+define('XOOPS_THEME_PATH', XOOPS_ROOT_PATH . '/themes');
+define('XOOPS_ADMINTHEME_PATH', XOOPS_ROOT_PATH . '/modules/system/themes');
+define('XOOPS_UPLOAD_PATH', XOOPS_ROOT_PATH . '/uploads');
+define('XOOPS_LIBRARY_PATH', XOOPS_ROOT_PATH . '/libraries');
+define('XOOPS_THEME_URL', XOOPS_URL . '/themes');
+define('XOOPS_ADMINTHEME_URL', XOOPS_URL . '/modules/system/themes');
+define('XOOPS_UPLOAD_URL', XOOPS_URL . '/uploads');
+define('XOOPS_LIBRARY_URL', XOOPS_URL . '/libraries');
+
+// ----- BEGIN: Deprecated, move to template class -----
+// define('SMARTY_DIR', XOOPS_ROOT_PATH . '/class/smarty/');
+define('XOOPS_COMPILE_PATH', XOOPS_VAR_PATH . '/caches/smarty_compile');
+define('XOOPS_CACHE_PATH', XOOPS_VAR_PATH . '/caches/xoops_cache');
+// ----- END: Deprecated, move to template class -----
+
+if (!defined('XOOPS_XMLRPC')) {
+ define('XOOPS_DB_CHKREF', 1);
+} else {
+ define('XOOPS_DB_CHKREF', 0);
+}
+
+/**
+ * User Mulitbytes
+ */
+// if ( !defined( 'XOOPS_USE_MULTIBYTES' ) ) {
+// define('XOOPS_USE_MULTIBYTES', 0 );
+// }
+
+// IT IS A WRONG PLACE FOR THE FOLLOWING CONSTANTS
+/*
+ * Some language definitions that cannot be translated
+ */
+define('_XOOPS_FATAL_MESSAGE', "<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Strict//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd'>
+<html xmlns='http://www.w3.org/1999/xhtml'>
+<head>
+<meta http-equiv='Content-Type' content='text/html; charset=utf-8;charset=utf-8' />
+<title>Internal server error</title>
+<style type='text/css'>
+* { margin: 0; padding: 0; font-family: Arial, Helvetica, sans-serif;}
+body {font-size: 12px; background-color: #f0f0f0; text-align: center;}
+#xo-siteblocked {
+ border: 1px solid #c0c4c0;
+ width: 375px;
+ height: 318px;
+ margin: 150px auto;
+ text-align: center;
+ background-color: #fff;
+ background-image: url(images/img_errors.png);
+ background-repeat: no-repeat;
+ background-position: 30px 50px;
+ padding-left: 300px;
+ padding-right: 30px;
+ border-radius: 15px;
+ -moz-border-radius: 15px;
+ -webkit-border-radius: 15px;
+}
+ #xo-siteblocked h1 {font-size: 1.7em; margin: 45px 0 30px 0;}
+ #xo-siteblocked h2 {font-size: 1.5em; margin: 0 0 30px 0;}
+ #xo-siteblocked h1, h2 {font-weight: normal; text-shadow: 1px 1px 2px #ccc;}
+ #xo-siteblocked a, #xo-siteblocked a:visited {color: #2cb0ff; text-decoration: none;}
+ #xo-siteblocked p { font-size: 1.3em; margin-top: 12px; line-height: 2em;}
+ #xo-siteblocked p.xo-siteblocked-message { height: 70px;}
+ #xo-siteblocked p.xo-siteblocked-desc { font-size: .9em; font-style: italic; margin-top: 25px;}
+</style>
+</head>
+<body>
+ <div id='xo-siteblocked'>
+ <h1>A problem has occurred on our server!</h1>
+ <h2>Page is currently unavailable</h2>
+ <p class='xo-siteblocked-message'>We are working on a fix<br /><a href='/'>Please come back soon ...</a></p>
+ <p class='xo-siteblocked-desc'>Error : %s</p>
+ </div>
+</body>
+</html>"
+);
+
+define('_XOOPS_FATAL_BACKTRACE', "Backtrace");
+
+?>
\ No newline at end of file
Added: XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/admin/system_blocks.html
===================================================================
--- XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/admin/system_blocks.html (rev 0)
+++ XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/admin/system_blocks.html 2013-06-15 12:02:25 UTC (rev 11680)
@@ -0,0 +1,107 @@
+<!-- Breadcrumb Header -->
+<{includeq file="db:system_header.html"}>
+<script type="text/javascript">
+ IMG_ON = '<{xoAdminIcons success.png}>';
+ IMG_OFF = '<{xoAdminIcons cancel.png}>';
+</script>
+<{if $filterform}>
+<div class="floatright">
+ <div class="xo-buttons">
+ <button id="xo-add-btn" class="ui-corner-all" onclick="self.location.href='admin.php?fct=blocksadmin&op=add';">
+ <img src="<{xoAdminIcons add.png}>" alt="<{$smarty.const._AM_SYSTEM_BLOCKS_ADD}>" />
+ <{$smarty.const._AM_SYSTEM_BLOCKS_ADD}>
+ </button>
+ </div>
+</div>
+<div class="clear"></div>
+<div id="xo-block-dragndrop">
+ <table class="outer">
+ <tr>
+ <th>
+ <form name="<{$filterform.name}>" id="<{$filterform.name}>" action="<{$filterform.action}>" method="<{$filterform.method}>" <{$filterform.extra}> >
+ <div class="xo-blocksfilter">
+ <{foreach item=element from=$filterform.elements}>
+ <{if $element.hidden != true}>
+
+ <div class="xo-caption"><{$element.caption}></div>
+ <div class="xo-element"><{$element.body}></div>
+ <{else}>
+ <{$element.body}>
+ <{/if}>
+ <{/foreach}>
+ </div>
+ </form>
+ </th>
+ </tr>
+ <tr>
+ <td>
+ <table id="xo-block-managment">
+ <tr>
+ <td side="0" class="xo-blocksection" rowspan="3" id="xo-leftcolumn">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDELEFT}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=0}>
+ </td>
+ <td side="3" class="xo-blocksection">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDETOPLEFT}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=3}>
+ </td>
+ <td side="5" class="xo-blocksection">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDETOPCENTER}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=5}>
+ </td>
+ <td side="4" class="xo-blocksection">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDETOPRIGHT}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=4}>
+ </td>
+ <td side="1" class="xo-blocksection" rowspan="3" id="xo-rightcolumn">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDERIGHT}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=1}>
+ </td>
+ </tr>
+ <tr style="height:30px;">
+ <td colspan="3" class="xo-blockContent width5"> </td>
+ </tr>
+ <tr>
+ <td side="7" class="xo-blocksection">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEBOTTOMLEFT}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=7}>
+ </td>
+ <td side="9" class="xo-blocksection">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEBOTTOMCENTER}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=9}>
+ </td>
+ <td side="8" class="xo-blocksection">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEBOTTOMRIGHT}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=8}>
+ </td>
+ </tr>
+ <tr>
+ <table id="xo-block-footer">
+ <tr>
+ <td side="11" class="xo-blocksection">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEFOOTERLEFT}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=11}>
+ </td>
+ <td side="13" class="xo-blocksection">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEFOOTERCENTER}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=13}>
+ </td>
+ <td side="12" class="xo-blocksection">
+ <div class="xo-title"><{$smarty.const._AM_SYSTEM_BLOCKS_SIDEFOOTERRIGHT}></div>
+ <{includeq file="db:system_blocks_item.html" blocks=$blocks side=12}>
+ </td>
+ </tr>
+ </table>
+ </tr>
+ </table>
+ </td>
+ </tr>
+ </table>
+</div>
+<{/if}>
+<div id="xo-block-add" <{if $filterform}>class="hide"<{/if}>>
+ <{if !$filterform}><br /><{/if}>
+ <{$blockform}>
+</div>
+<!-- Preview block -->
+<div id="xo-preview-block" class="hide"></div>
Added: XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/class/block.php
===================================================================
--- XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/class/block.php (rev 0)
+++ XoopsCore/branches/2.5.x/2.5.6_timgno/htdocs/modules/system/templates/class/block.php 2013-06-15 12:02:25 UTC (rev 11680)
@@ -0,0 +1,564 @@
+<?php
+/**
+ * Block Class Manager
+*
+ * You may not change or alter any portion of this comment or credits
+ * of supporting developers from this source code or any supporting source code
+ * which is considered copyrighted (c) material of the original comment or credit authors.
+ * This program is distributed in the hope that it will be useful,
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
+ *
+ * @copyright The XOOPS Project http://sourceforge.net/projects/xoops/
+ * @license GNU GPL 2 (http://www.gnu.org/licenses/old-licenses/gpl-2.0.html)
+ * @package system
+ * @version $Id: block.php 8066 2011-11-06 05:09:33Z beckmi $
+ */
+defined('XOOPS_ROOT_PATH') or die('Restricted access');
+
+require_once XOOPS_ROOT_PATH . '/kernel/block.php';
+
+/**
+ * System Block
+ *
+ * @copyright copyright (c) 2000 XOOPS.org
+ * @package system
+ */
+class SystemBlock extends XoopsBlock
+{
+ function __construct()
+ {
+ parent::__construct();
+ }
+
+ function getForm($mode='edit')
+ {
+ if ($this->isNew()) {
+ $title = _AM_SYSTEM_BLOCKS_ADDBLOCK;
+ $modules = array(-1);
+ $groups = array( XOOPS_GROUP_USERS, XOOPS_GROUP_ANONYMOUS, XOOPS_GROUP_ADMIN );
+ $this->setVar('block_type', 'C');
+ $this->setVar('visible',1);
+ $op = 'save';
+ } else {
+ // Search modules
+ $blocklinkmodule_handler =& xoops_getmodulehandler('blocklinkmodule');
+ $criteria = new CriteriaCompo(new Criteria('block_id', $this->getVar('bid') ));
+ $blocklinkmodule = $blocklinkmodule_handler->getObjects($criteria);
+ foreach ($blocklinkmodule as $link) {
+ $modules[] = $link->getVar('module_id');
+ }
+ // Saerch perms
+ $groupperm_handler =& xoops_gethandler('groupperm');
+ $groups =& $groupperm_handler->getGroupIds('block_read', $this->getVar('bid'));
+ switch ($mode) {
+ case 'edit':
+ $title = _AM_SYSTEM_BLOCKS_EDITBLOCK;
+ break;
+ case 'clone':
+ $title = _AM_SYSTEM_BLOCKS_CLONEBLOCK;
+ $this->setVar('bid', 0);
+ if ( $this->isCustom() ) {
+ $this->setVar('block_type', 'C');
+ } else {
+ $this->setVar('block_type', 'D');
+ }
+ break;
+ }
+ $op = 'save';
+ }
+ $form = new XoopsThemeForm($title, 'blockform', 'admin.php', 'post', true);
+ if (!$this->isNew()) {
+ $form->addElement(new XoopsFormLabel(_AM_SYSTEM_BLOCKS_NAME, $this->getVar('name')));
+ }
+ // Side position
+ $side_select = new XoopsFormSelect(_AM_SYSTEM_BLOCKS_TYPE, 'side', $this->getVar('side'));
+ $side_select->addOptionArray(array(
+ 0 => _AM_SYSTEM_BLOCKS_SBLEFT,
+ 1 => _AM_SYSTEM_BLOCKS_SBRIGHT,
+ 3 => _AM_SYSTEM_BLOCKS_CBLEFT,
+ 4 => _AM_SYSTEM_BLOCKS_CBRIGHT,
+ 5 => _AM_SYSTEM_BLOCKS_CBCENTER,
+ 7 => _AM_SYSTEM_BLOCKS_CBBOTTOMLEFT,
+ 8 => _AM_SYSTEM_BLOCKS_CBBOTTOMRIGHT,
+ 9 => _AM_SYSTEM_BLOCKS_CBBOTTOM,
+ 11 => _AM_SYSTEM_BLOCKS_CBFOOTERLEFT,
+ 12 => _AM_SYSTEM_BLOCKS_CBFOOTERRIGHT,
+ 13 => _AM_SYSTEM_BLOCKS_CBFOOTERCENTER));
+ $form->addElement($side_select);
+ // Order
+ $form->addElement(new XoopsFormText(_AM_SYSTEM_BLOCKS_WEIGHT, 'weight', 2, 5, $this->getVar('weight')));
+ // Display
+ $form->addElement(new XoopsFormRadioYN(_AM_SYSTEM_BLOCKS_VISIBLE, 'visible', $this->getVar('visible')));
+ // Visible In
+ $mod_select = new XoopsFormSelect(_AM_SYSTEM_BLOCKS_VISIBLEIN, 'modules', $modules, 5, true);
+ $module_handler =& xoops_gethandler('module');
+ $criteria = new CriteriaCompo(new Criteria('hasmain', 1));
+ $criteria->add(new Criteria('isactive', 1));
+ $module_list = $module_handler->getList($criteria);
+ $module_list[-1] = _AM_SYSTEM_BLOCKS_TOPPAGE;
+ $module_list[0] = _AM_SYSTEM_BLOCKS_ALLPAGES;
+ ksort($module_list);
+ $mod_select->addOptionArray($module_list);
+ $form->addElement($mod_select);
+ // Title
+ $form->addElement(new XoopsFormText(_AM_SYSTEM_BLOCKS_TITLE, 'title', 50, 255, $this->getVar('title')), false );
+ if ($this->isNew() || $this->isCustom()) {
+ $editor_configs=array();
+ $editor_configs["name"] ="content_block";
+ $editor_configs["value"] = $this->getVar('content', 'e');
+ $editor_configs["rows"] = 20;
+ $editor_configs["cols"] = 100;
+ $editor_configs["width"] = "100%";
+ $editor_configs["height"] = "400px";
+ $editor_configs["editor"] = xoops_getModuleOption('blocks_editor', 'system');
+ $form->addElement(new XoopsFormEditor(_AM_SYSTEM_BLOCKS_CONTENT, "content_block", $editor_configs), true);
+ if ( in_array( $editor_configs["editor"], array('dhtmltextarea','textarea' ) ) ) {
+ $ctype_select = new XoopsFormSelect(_AM_SYSTEM_BLOCKS_CTYPE, 'c_type', $this->getVar('c_type'));
+ $ctype_select->addOptionArray(array(
+ 'H' => _AM_SYSTEM_BLOCKS_HTML,
+ 'P' => _AM_SYSTEM_BLOCKS_PHP,
+ 'S' => _AM_SYSTEM_BLOCKS_AFWSMILE,
+ 'T' => _AM_SYSTEM_BLOCKS_AFNOSMILE));
+ $form->addElement($ctype_select);
+ } else {
+ $form->addElement(new XoopsFormHidden('c_type', 'H'));
+ }
+ } else {
+ if ($this->getVar('template') != '') {
+ $tplfile_handler =& xoops_gethandler('tplfile');
+ $btemplate = $tplfile_handler->find($GLOBALS['xoopsConfig']['template_set'], 'block', $this->getVar('bid') );
+ if (count($btemplate) > 0) {
+ $form->addElement(new XoopsFormLabel(_AM_SYSTEM_BLOCKS_CONTENT, '<a href="' . XOOPS_URL . '/modules/system/admin.php?fct=tplsets&op=edittpl&id=' . $btemplate[0]->getVar('tpl_id') . '">' . _AM_SYSTEM_BLOCKS_EDITTPL . '</a>'));
+ } else {
+ $btemplate2 = $tplfile_handler->find('default', 'block', $this->getVar('bid'));
+ if (count($btemplate2) > 0) {
+ $form->addElement(new XoopsFormLabel(_AM_SYSTEM_BLOCKS_CONTENT, '<a href="' . XOOPS_URL . '/modules/system/admin.php?fct=tplsets&op=edittpl&id=' . $btemplate2[0]->getVar('tpl_id') . '" rel="external">' . _AM_SYSTEM_BLOCKS_EDITTPL . '</a>'));
+ }
+ }
+ }
+ if ( $this->getOptions() != false ) {
+ $form->addElement(new XoopsFormLabel(_AM_SYSTEM_BLOCKS_OPTIONS, $this->getOptions()));
+ } else {
+ $form->addElement(new XoopsFormHidden('options', $this->getVar('options')));
+ }
+ $form->addElement(new XoopsFormHidden('c_type', 'H'));
+ }
+ $cache_select = new XoopsFormSelect(_AM_SYSTEM_BLOCKS_BCACHETIME, 'bcachetime', $this->getVar('bcachetime'));
+ $cache_select->addOptionArray(array(
+ '0' => _NOCACHE,
+ '30' => sprintf(_SECONDS, 30),
+ '60' => _MINUTE,
+ '300' => sprintf(_MINUTES, 5),
+ '1800' => sprintf(_MINUTES, 30),
+ '3600' => _HOUR,
+ '18000' => sprintf(_HOURS, 5),
+ '86400' => _DAY,
+ '259200' => sprintf(_DAYS, 3),
+ '604800' => _WEEK,
+ '2592000' => _MONTH));
+ $form->addElement($cache_select);
+ // Groups
+ $form->addElement(new XoopsFormSelectGroup( _AM_SYSTEM_BLOCKS_GROUP, 'groups', true, $groups, 5, true) );
+
+ $form->addElement(new XoopsFormHidden('block_type', $this->getVar('block_type')));
+ $form->addElement(new XoopsFormHidden('mid', $this->getVar('mid')));
+ $form->addElement(new XoopsFormHidden('func_num', $this->getVar('func_num')));
+ $form->addElement(new XoopsFormHidden('func_file', $this->getVar('func_file')));
+ $form->addElement(new XoopsFormHidden('show_func', $this->getVar('show_func')));
+ $form->addElement(new XoopsFormHidden('edit_func', $this->getVar('edit_func')));
+ $form->addElement(new XoopsFormHidden('template', $this->getVar('template')));
+ $form->addElement(new XoopsFormHidden('dirname', $this->getVar('dirname')));
+ $form->addElement(new XoopsFormHidden('name', $this->getVar('name')));
+ $form->addElement(new XoopsFormHidden('bid', $this->getVar('bid')));
+ $form->addElement(new XoopsFormHidden('op', $op ));
+ $form->addElement(new XoopsFormHidden('fct', 'blocksadmin'));
+ $button_tray = new XoopsFormElementTray('', ' ');
+ if ($this->isNew() || $this->isCustom()) {
+ $preview = new XoopsFormButton('', 'previewblock', _PREVIEW, 'preview');
+ $preview->setExtra("onclick=\"blocks_preview();\"");
+ $button_tray->addElement( $preview );
+ }
+ $button_tray->addElement(new XoopsFormButton('', 'submitblock', _SUBMIT, 'submit'));
+ $form->addElement($button_tray);
+
+ return $form;
+ }
+
+ /**
+ * XoopsBlock::getOptions()
+ *
+ * @return
+ */
+ function getOptions()
+ {
+ global $xoopsConfig;
+ if (!$this->isCustom()) {
+ $edit_func = $this->getVar('edit_func');
+ if (!$edit_func) {
+ return false;
+ }
+ if (file_exists($GLOBALS['xoops']->path('modules/' . $this->getVar('dirname') . '/blocks/' . $this->getVar('func_file')))) {
+ if (file_exists($file = $GLOBALS['xoops']->path('modules/' . $this->getVar('dirname') . '/language/' . $xoopsConfig['language'] . '/blocks.php'))) {
+ include_once $file;
+ } elseif (file_exists($file = $GLOBALS['xoops']->path('modules/' . $this->getVar('dirname') . '/language/english/blocks.php'))) {
+ include_once $file;
+ }
+ include_once $GLOBALS['xoops']->path('modules/' . $this->getVar('dirname') . '/blocks/' . $this->getVar('func_file'));
+ $options = explode("|", $this->getVar("options"));
+ $edit_form = $edit_func($options);
+ if (!$edit_form) {
+ return false;
+ }
+ return $edit_form;
+ } else {
+ return false;
+ }
+ } else {
+ return false;
+ }
+ }
+
+ function isCustom()
+ {
+ if ($this->getVar('block_type') == 'C') return true;
+ return false;
+ }
+
+ /**
+ * do stripslashes/htmlspecialchars according to the needed output
+ *
+ * @param $format output use: S for Show and E for Edit
+ * @param $c_type type of block content
+ * @returns string
+ */
+ function getContent($format = 's', $c_type = 'T')
+ {
+ $format = strtolower($format);
+ $c_type = strtoupper($c_type);
+ switch ($format) {
+ case 's':
+ // check the type of content
+ // H : custom HTML block
+ // P : custom PHP block
+ // S : use text sanitizater (smilies enabled)
+ // T : use text sanitizater (smilies disabled)
+ if ($c_type == 'H') {
+ return str_replace('{X_SITEURL}', XOOPS_URL . '/', $this->getVar('content', 'n'));
+ } else if ($c_type == 'P') {
+ ob_start();
+ echo eval($this->getVar('content', 'n'));
+ $content = ob_get_contents();
+ ob_end_clean();
+ return str_replace('{X_SITEURL}', XOOPS_URL . '/', $content);
+ } else if ($c_type == 'S') {
+ $myts =& MyTextSanitizer::getInstance();
+ $content = str_replace('{X_SITEURL}', XOOPS_URL . '/', $this->getVar('content', 'n'));
+ return $myts->displayTarea($content, 1, 1);
+ } else {
+ $myts =& MyTextSanitizer::getInstance();
+ $content = str_replace('{X_SITEURL}', XOOPS_URL . '/', $this->getVar('content', 'n'));
+ return $myts->displayTarea($content, 1, 0);
+ }
+ break;
+ case 'e':
+ return $this->getVar('content', 'e');
+ break;
+ default:
+ return $this->getVar('content', 'n');
+ break;
+ }
+ }
+}
+
+/**
+ * System block handler class. (Singelton)
+ *
+ * This class is responsible for providing data access mechanisms to the data source
+ * of XOOPS block class objects.
+ *
+ * @copyright copyright (c) 2000 XOOPS.org
+ * @package system
+ * @subpackage avatar
+ */
+class SystemBlockHandler extends XoopsPersistableObjectHandler
+{
+ function __construct($db)
+ {
+ parent::__construct($db, 'newblocks', 'SystemBlock', 'bid', 'title');
+ }
+
+ function insert($obj)
+ {
+ $obj->setVar('last_modified', time());
+ return parent::insert($obj);
+ }
+
+ /**
+ * retrieve array of {@link XoopsBlock}s meeting certain conditions
+ *
+ * @param object $criteria {@link CriteriaElement} with conditions for the blocks
+ * @param bool $id_as_key should the blocks' bid be the key for the returned array?
+ * @return array {@link XoopsBlock}s matching the conditions
+ **/
+ function getObjects($criteria = null, $id_as_key = false)
+ {
+ $ret = array();
+ $limit = $start = 0;
+ $sql = 'SELECT DISTINCT(b.bid), b.* FROM ' . $this->db->prefix('newblocks') . ' b LEFT JOIN ' . $this->db->prefix('block_module_link') . ' l ON b.bid=l.block_id';
+ if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
+ $sql .= ' ' . $criteria->renderWhere();
+ $limit = $criteria->getLimit();
+ $start = $criteria->getStart();
+ }
+ $result = $this->db->query($sql, $limit, $start);
+ if (!$result) {
+ return $ret;
+ }
+
+ while ($myrow = $this->db->fetchArray($result)) {
+ $block = new SystemBlock();
+ $block->assignVars($myrow);
+ if (!$id_as_key) {
+ $ret[] =& $block;
+ } else {
+ $ret[$myrow['bid']] = & $block;
+ }
+ unset($block);
+ }
+ return $ret;
+ }
+
+ /**
+ * get all the blocks that match the supplied parameters
+ *
+ * @param $side
+ * 0: sideblock - left
+ * 1: sideblock - right
+ * 2: sideblock - left and right
+ * 3: centerblock - left
+ * 4: centerblock - right
+ * 5: centerblock - center
+ * 6: centerblock - left, right, center
+ * @param $groupid groupid (can be an array)
+ * @param $visible 0: not visible 1: visible
+ * @param $orderby order of the blocks
+ * @returns array of block objects
+ */
+ function getAllBlocksByGroup($groupid, $asobject = true, $side = null, $visible = null, $orderby = "b.weight,b.bid", $isactive = 1)
+ {
+ $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 )";
+ } elseif ($side == XOOPS_FOOTERBLOCK_ALL) {
+ $side = "(b.side=11 OR b.side=12 OR b.side=13 )";
+ } else {
+ $side = "b.side=" . $side;
+ }
+ $sql .= " AND " . $side;
+ }
+ if (isset($visible)) {
+ $sql .= " AND b.visible=$visible";
+ }
+ $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;
+ }
+
+ function getBlockByPerm( $groupid )
+ {
+ $ret = array();
+ if (isset($groupid)) {
+ $sql = "SELECT DISTINCT gperm_itemid FROM " . $this->db->prefix('group_permission') . " WHERE gperm_name = 'block_read' AND gperm_modid = 1";
+ if ( is_array($groupid) ) {
+ $sql .= ' AND gperm_groupid IN (' . implode(',', $groupid) . ')';
+ } else {
+ if (intval($groupid) > 0) {
+ $sql .= ' AND gperm_groupid=' . intval($groupid);
+ }
+ }
+ $result = $this->db->query($sql);
+ $blockids = array();
+ while ( $myrow = $this->db->fetchArray( $result ) ) {
+ $blockids[] = $myrow['gperm_itemid'];
+ }
+ if (empty($blockids)) {
+ return $blockids;
+ }
+ return $blockids;
+ }
+ }
+
+ function getAllByGroupModule($groupid, $module_id = 0, $toponlyblock = false, $visible = null, $orderby = 'b.weight, m.block_id', $isactive = 1)
+ {
+ $isactive = intval($isactive);
+ $db = $GLOBALS['xoopsDB'];
+ $ret = array();
+ if (isset($groupid)) {
+ $sql = "SELECT DISTINCT gperm_itemid FROM ".$db->prefix('group_permission')." WHERE gperm_name = 'block_read' AND gperm_modid = 1";
+ if ( is_array($groupid) ) {
+ $sql .= ' AND gperm_groupid IN ('.implode(',', $groupid).')';
+ } else {
+ if (intval($groupid) > 0) {
+ $sql .= ' AND gperm_groupid='.intval($groupid);
+ }
+ }
+ $result = $db->query($sql);
+ $blockids = array();
+ while ( $myrow = $db->fetchArray($result) ) {
+ $blockids[] = $myrow['gperm_itemid'];
+ }
+ if (empty($blockids)) {
+ return $blockids;
+ }
+ }
+ $sql = 'SELECT b.* FROM '.$db->prefix('newblocks').' b, '.$db->prefix('block_module_link').' m WHERE m.block_id=b.bid';
+ $sql .= ' AND b.isactive='.$isactive;
+ if (isset($visible)) {
+ $sql .= ' AND b.visible='.intval($visible);
+ }
+ if (!isset($module_id)) {
+ } elseif (!empty($module_id)) {
+ $sql .= ' AND m.module_id IN (0,'. intval($module_id);
+ if ($toponlyblock) {
+ $sql .= ',-1';
+ }
+ $sql .= ')';
+ } else {
+ if ($toponlyblock) {
+ $sql .= ' AND m.module_id IN (0,-1)';
+ } else {
+ $sql .= ' AND m.module_id=0';
+ }
+ }
+ if (!empty($blockids)) {
+ $sql .= ' AND b.bid IN ('.implode(',', $blockids).')';
+ }
+ $sql .= ' ORDER BY '.$orderby;
+ $result = $db->query($sql);
+ while ( $myrow = $db->fetchArray($result) ) {
+ $block = new XoopsBlock($myrow);
+ $ret[$myrow['bid']] =& $block;
+ unset($block);
+ }
+ return $ret;
+ }
+
+ function getNonGroupedBlocks($module_id = 0, $toponlyblock = false, $visible = null, $orderby = 'b.weight, m.block_id', $isactive = 1)
+ {
+ $db = $GLOBALS['xoopsDB'];
+ $ret = array();
+ $bids = array();
+ $sql = "SELECT DISTINCT(bid) from ".$db->prefix('newblocks');
+ if ($result = $db->query($sql)) {
+ while ( $myrow = $db->fetchArray($result) ) {
+ $bids[] = $myrow['bid'];
+ }
+ }
+ $sql = "SELECT DISTINCT(p.gperm_itemid) from ".$db->prefix('group_permission')." p, ".$db->prefix('groups')." g WHERE g.groupid=p.gperm_groupid AND p.gperm_name='block_read'";
+ $grouped = array();
+ if ($result = $db->query($sql)) {
+ while ( $myrow = $db->fetchArray($result) ) {
+ $grouped[] = $myrow['gperm_itemid'];
+ }
+ }
+ $non_grouped = array_diff($bids, $grouped);
+ if (!empty($non_grouped)) {
+ $sql = 'SELECT b.* FROM '.$db->prefix('newblocks').' b, '.$db->prefix('block_module_link').' m WHERE m.block_id=b.bid';
+ $sql .= ' AND b.isactive='.intval($isactive);
+ if (isset($visible)) {
+ $sql .= ' AND b.visible='.intval($visible);
+ }
+ if (!isset($module_id)) {
+ } elseif (!empty($module_id)) {
+ $sql .= ' AND m.module_id IN (0,'. intval($module_id);
+ if ($toponlyblock) {
+ $sql .= ',-1';
+ }
+ $sql .= ')';
+ } else {
+ if ($toponlyblock) {
+ $sql .= ' AND m.module_id IN (0,-1)';
+ } else {
+ $sql .= ' AND m.module_id=0';
+ }
+ }
+ $sql .= ' AND b.bid IN ('....
[truncated message content] |
