| 1 | 1358 | Luisehahne | <?php
 | 
      
        | 2 |  |  | /**
 | 
      
        | 3 |  |  |  *
 | 
      
        | 4 |  |  |  * @category        admin
 | 
      
        | 5 |  |  |  * @package         pages
 | 
      
        | 6 |  |  |  * @author          WebsiteBaker Project
 | 
      
        | 7 |  |  |  * @copyright       2004-2009, Ryan Djurovich
 | 
      
        | 8 | 1373 | Luisehahne |  * @copyright       2009-2011, Website Baker Org. e.V.
 | 
      
        | 9 | 1358 | Luisehahne |  * @link			http://www.websitebaker2.org/
 | 
      
        | 10 |  |  |  * @license         http://www.gnu.org/licenses/gpl.html
 | 
      
        | 11 |  |  |  * @platform        WebsiteBaker 2.8.x
 | 
      
        | 12 | 1373 | Luisehahne |  * @requirements    PHP 5.2.2 and higher
 | 
      
        | 13 | 1358 | Luisehahne |  * @version         $Id$
 | 
      
        | 14 |  |  |  * @filesource		$HeadURL$
 | 
      
        | 15 |  |  |  * @lastmodified    $Date$
 | 
      
        | 16 |  |  |  *
 | 
      
        | 17 |  |  |  */
 | 
      
        | 18 |  |  | 
 | 
      
        | 19 |  |  | // Include config file
 | 
      
        | 20 |  |  | require('../../config.php');
 | 
      
        | 21 |  |  | 
 | 
      
        | 22 |  |  | // Make sure people are allowed to access this page
 | 
      
        | 23 |  |  | if(MANAGE_SECTIONS != 'enabled')
 | 
      
        | 24 |  |  | {
 | 
      
        | 25 |  |  | 	header('Location: '.ADMIN_URL.'/pages/index.php');
 | 
      
        | 26 |  |  | 	exit(0);
 | 
      
        | 27 |  |  | }
 | 
      
        | 28 | 1402 | Luisehahne | /* */
 | 
      
        | 29 |  |  | $debug = false; // to show position and section_id
 | 
      
        | 30 |  |  | If(!defined('DEBUG')) { define('DEBUG',$debug);}
 | 
      
        | 31 | 1475 | Luisehahne | // Include the WB functions file
 | 
      
        | 32 |  |  | require_once(WB_PATH.'/framework/functions.php');
 | 
      
        | 33 | 1402 | Luisehahne | // Create new admin object
 | 
      
        | 34 |  |  | require_once(WB_PATH.'/framework/class.admin.php');
 | 
      
        | 35 | 1475 | Luisehahne | $admin = new admin('Pages', 'pages_modify', false);
 | 
      
        | 36 | 1358 | Luisehahne | 
 | 
      
        | 37 | 1475 | Luisehahne | $action = 'show';
 | 
      
        | 38 | 1358 | Luisehahne | // Get page id
 | 
      
        | 39 | 1475 | Luisehahne | $requestMethod = '_'.strtoupper($_SERVER['REQUEST_METHOD']);
 | 
      
        | 40 |  |  | $page_id = intval((isset(${$requestMethod}['page_id'])) ? ${$requestMethod}['page_id'] : 0);
 | 
      
        | 41 |  |  | $action = ($page_id ? 'show' : $action);
 | 
      
        | 42 |  |  | // Get section id if there is one
 | 
      
        | 43 |  |  | $requestMethod = '_'.strtoupper($_SERVER['REQUEST_METHOD']);
 | 
      
        | 44 |  |  | $section_id = ((isset(${$requestMethod}['section_id'])) ? ${$requestMethod}['section_id']  : 0);
 | 
      
        | 45 |  |  | $action = ($section_id ? 'delete' : $action);
 | 
      
        | 46 |  |  | // Get module if there is one
 | 
      
        | 47 |  |  | $requestMethod = '_'.strtoupper($_SERVER['REQUEST_METHOD']);
 | 
      
        | 48 |  |  | $module = ((isset(${$requestMethod}['module'])) ? ${$requestMethod}['module']  : 0);
 | 
      
        | 49 |  |  | $action = ($module != '' ? 'add' : $action);
 | 
      
        | 50 |  |  | $admin_header = true;
 | 
      
        | 51 |  |  | $backlink = ADMIN_URL.'/pages/sections.php?page_id='.(int)$page_id;
 | 
      
        | 52 | 1358 | Luisehahne | 
 | 
      
        | 53 | 1475 | Luisehahne | switch ($action):
 | 
      
        | 54 |  |  | 	case 'delete' :
 | 
      
        | 55 | 1358 | Luisehahne | 
 | 
      
        | 56 | 1475 | Luisehahne | 		if( ( !($section_id = intval($admin->checkIDKEY('section_id', 0, $_SERVER['REQUEST_METHOD'])) )) )
 | 
      
        | 57 |  |  | 		{
 | 
      
        | 58 |  |  | 			if($admin_header) { $admin->print_header(); }
 | 
      
        | 59 |  |  | 			$admin->print_error($MESSAGE['GENERIC_SECURITY_ACCESS'],$backlink);
 | 
      
        | 60 |  |  | 		}
 | 
      
        | 61 | 1358 | Luisehahne | 
 | 
      
        | 62 | 1475 | Luisehahne | 		$action = 'show';
 | 
      
        | 63 |  |  | 	    $sql  = 'SELECT `module` FROM `'.TABLE_PREFIX.'sections` ';
 | 
      
        | 64 |  |  | 	    $sql .= 'WHERE `section_id` ='.$section_id;
 | 
      
        | 65 |  |  |         if( ( ($modulname = $database->get_one($sql)) == $module) && ($section_id > 0 ) ) {
 | 
      
        | 66 |  |  | 			// Include the modules delete file if it exists
 | 
      
        | 67 |  |  | 			if(file_exists(WB_PATH.'/modules/'.$modulname.'/delete.php'))
 | 
      
        | 68 |  |  | 		    {
 | 
      
        | 69 |  |  | 				require(WB_PATH.'/modules/'.$modulname.'/delete.php');
 | 
      
        | 70 |  |  | 			}
 | 
      
        | 71 |  |  | 		    $sql  = 'DELETE FROM `'.TABLE_PREFIX.'sections` ';
 | 
      
        | 72 |  |  | 		    $sql .= 'WHERE `section_id` ='.(int)$section_id.' LIMIT 1';
 | 
      
        | 73 |  |  | 			if( !$database->query($sql) ) {
 | 
      
        | 74 |  |  | 				if($admin_header) { $admin->print_header(); }
 | 
      
        | 75 |  |  | 				$admin->print_error($database->get_error(),$backlink);
 | 
      
        | 76 |  |  | 			}  else {
 | 
      
        | 77 |  |  | 				require_once(WB_PATH.'/framework/class.order.php');
 | 
      
        | 78 |  |  | 				$order = new order(TABLE_PREFIX.'sections', 'position', 'section_id', 'page_id');
 | 
      
        | 79 |  |  | 				$order->clean($page_id);
 | 
      
        | 80 |  |  | 				$format = $TEXT['SECTION'].' %d  %s %s '.strtolower( $TEXT['DELETED']);
 | 
      
        | 81 |  |  | 				$message = sprintf ($format,$section_id,strtoupper($modulname),strtolower($TEXT['SUCCESS']));
 | 
      
        | 82 |  |  | 				if($admin_header) { $admin->print_header(); }
 | 
      
        | 83 |  |  | 				$admin_header = false;
 | 
      
        | 84 |  |  | 				unset($_POST);
 | 
      
        | 85 |  |  | 				$admin->print_success($message, $backlink );
 | 
      
        | 86 |  |  | 			}
 | 
      
        | 87 |  |  |         } else {
 | 
      
        | 88 |  |  | 			if($admin_header) { $admin->print_header(); }
 | 
      
        | 89 |  |  | 			$admin->print_error($module.' '.strtolower($TEXT['NOT_FOUND']),$backlink);
 | 
      
        | 90 |  |  |         }
 | 
      
        | 91 | 1358 | Luisehahne | 
 | 
      
        | 92 | 1475 | Luisehahne | 		break;
 | 
      
        | 93 |  |  | 	case 'add' :
 | 
      
        | 94 |  |  | 
 | 
      
        | 95 |  |  | 		if (!$admin->checkFTAN())
 | 
      
        | 96 |  |  | 		{
 | 
      
        | 97 |  |  | 			$admin->print_header();
 | 
      
        | 98 |  |  | 			$admin->print_error($MESSAGE['GENERIC_SECURITY_ACCESS'],$backlink);
 | 
      
        | 99 |  |  | 		}
 | 
      
        | 100 |  |  | 		$action = 'show';
 | 
      
        | 101 |  |  | 		$module = preg_replace('/\W/', '', $module );  // fix secunia 2010-91-4
 | 
      
        | 102 |  |  | 		require_once(WB_PATH.'/framework/class.order.php');
 | 
      
        | 103 |  |  | 		// Get new order
 | 
      
        | 104 | 1358 | Luisehahne | 		$order = new order(TABLE_PREFIX.'sections', 'position', 'section_id', 'page_id');
 | 
      
        | 105 | 1475 | Luisehahne | 		$position = $order->get_new($page_id);
 | 
      
        | 106 |  |  | 		// Insert module into DB
 | 
      
        | 107 |  |  | 	    $sql  = 'INSERT INTO `'.TABLE_PREFIX.'sections` SET ';
 | 
      
        | 108 |  |  | 	    $sql .= '`page_id` = '.(int)$page_id.', ';
 | 
      
        | 109 |  |  | 	    $sql .= '`module` = \''.$module.'\', ';
 | 
      
        | 110 |  |  | 	    $sql .= '`position` = '.(int)$position.', ';
 | 
      
        | 111 |  |  | 	    $sql .= '`block` = 1';
 | 
      
        | 112 |  |  |         if($database->query($sql)) {
 | 
      
        | 113 |  |  | 			// Get the section id
 | 
      
        | 114 |  |  | 			$section_id = $database->get_one("SELECT LAST_INSERT_ID()");
 | 
      
        | 115 |  |  | 			// Include the selected modules add file if it exists
 | 
      
        | 116 |  |  | 			if(file_exists(WB_PATH.'/modules/'.$module.'/add.php'))
 | 
      
        | 117 |  |  | 		    {
 | 
      
        | 118 |  |  | 				require(WB_PATH.'/modules/'.$module.'/add.php');
 | 
      
        | 119 |  |  | 			}
 | 
      
        | 120 |  |  |         } elseif ($database->is_error())  {
 | 
      
        | 121 |  |  | 			if($admin_header) { $admin->print_header(); }
 | 
      
        | 122 |  |  | 			$admin->print_error($database->get_error());
 | 
      
        | 123 |  |  | 		}
 | 
      
        | 124 |  |  | 		break;
 | 
      
        | 125 |  |  | 	default:
 | 
      
        | 126 |  |  | 		break;
 | 
      
        | 127 |  |  | endswitch;
 | 
      
        | 128 | 1358 | Luisehahne | 
 | 
      
        | 129 | 1475 | Luisehahne | switch ($action):
 | 
      
        | 130 |  |  | 	default:
 | 
      
        | 131 | 1358 | Luisehahne | 
 | 
      
        | 132 | 1475 | Luisehahne | 		if($admin_header) { $admin->print_header(); }
 | 
      
        | 133 |  |  | 		// Get perms
 | 
      
        | 134 |  |  | 		$sql  = 'SELECT `admin_groups`,`admin_users` FROM `'.TABLE_PREFIX.'pages` ';
 | 
      
        | 135 |  |  | 		$sql .= 'WHERE `page_id` = '.$page_id;
 | 
      
        | 136 |  |  | 		$results = $database->query($sql);
 | 
      
        | 137 | 1358 | Luisehahne | 
 | 
      
        | 138 | 1475 | Luisehahne | 		$results_array = $results->fetchRow();
 | 
      
        | 139 |  |  | 		$old_admin_groups = explode(',', $results_array['admin_groups']);
 | 
      
        | 140 |  |  | 		$old_admin_users = explode(',', $results_array['admin_users']);
 | 
      
        | 141 |  |  | 		$in_old_group = FALSE;
 | 
      
        | 142 |  |  | 		foreach($admin->get_groups_id() as $cur_gid)
 | 
      
        | 143 |  |  | 		{
 | 
      
        | 144 |  |  | 			if (in_array($cur_gid, $old_admin_groups))
 | 
      
        | 145 |  |  | 		    {
 | 
      
        | 146 |  |  | 				$in_old_group = TRUE;
 | 
      
        | 147 |  |  | 			}
 | 
      
        | 148 |  |  | 		}
 | 
      
        | 149 |  |  | 		if((!$in_old_group) && !is_numeric(array_search($admin->get_user_id(), $old_admin_users)))
 | 
      
        | 150 |  |  | 		{
 | 
      
        | 151 |  |  | 			$admin->print_header();
 | 
      
        | 152 |  |  | 			$admin->print_error($MESSAGE['PAGES']['INSUFFICIENT_PERMISSIONS']);
 | 
      
        | 153 |  |  | 		}
 | 
      
        | 154 | 1358 | Luisehahne | 
 | 
      
        | 155 | 1475 | Luisehahne | 		// Get page details
 | 
      
        | 156 |  |  | 		$sql  = 'SELECT * FROM `'.TABLE_PREFIX.'pages` ';
 | 
      
        | 157 |  |  | 		$sql .= 'WHERE `page_id` = '.$page_id;
 | 
      
        | 158 |  |  | 		$results = $database->query($sql);
 | 
      
        | 159 | 1358 | Luisehahne | 
 | 
      
        | 160 | 1475 | Luisehahne | 		if($database->is_error())
 | 
      
        | 161 |  |  | 		{
 | 
      
        | 162 |  |  | 			// $admin->print_header();
 | 
      
        | 163 |  |  | 			$admin->print_error($database->get_error());
 | 
      
        | 164 |  |  | 		}
 | 
      
        | 165 |  |  | 		if($results->numRows() == 0)
 | 
      
        | 166 |  |  | 		{
 | 
      
        | 167 |  |  | 			// $admin->print_header();
 | 
      
        | 168 |  |  | 			$admin->print_error($MESSAGE['PAGES']['NOT_FOUND']);
 | 
      
        | 169 |  |  | 		}
 | 
      
        | 170 |  |  | 		$results_array = $results->fetchRow();
 | 
      
        | 171 | 1358 | Luisehahne | 
 | 
      
        | 172 | 1475 | Luisehahne | 		// Set module permissions
 | 
      
        | 173 |  |  | 		$module_permissions = $_SESSION['MODULE_PERMISSIONS'];
 | 
      
        | 174 | 1358 | Luisehahne | 
 | 
      
        | 175 | 1475 | Luisehahne | 		// Unset block var
 | 
      
        | 176 |  |  | 		unset($block);
 | 
      
        | 177 |  |  | 		// Include template info file (if it exists)
 | 
      
        | 178 |  |  | 		if($results_array['template'] != '')
 | 
      
        | 179 |  |  | 		{
 | 
      
        | 180 |  |  | 			$template_location = WB_PATH.'/templates/'.$results_array['template'].'/info.php';
 | 
      
        | 181 |  |  | 		} else {
 | 
      
        | 182 |  |  | 			$template_location = WB_PATH.'/templates/'.DEFAULT_TEMPLATE.'/info.php';
 | 
      
        | 183 |  |  | 		}
 | 
      
        | 184 |  |  | 		if(file_exists($template_location))
 | 
      
        | 185 |  |  | 		{
 | 
      
        | 186 |  |  | 			require($template_location);
 | 
      
        | 187 |  |  | 		}
 | 
      
        | 188 |  |  | 		// Check if $menu is set
 | 
      
        | 189 |  |  | 		if(!isset($block[1]) || $block[1] == '')
 | 
      
        | 190 |  |  | 		{
 | 
      
        | 191 |  |  | 			// Make our own menu list
 | 
      
        | 192 |  |  | 			$block[1] = $TEXT['MAIN'];
 | 
      
        | 193 |  |  | 		}
 | 
      
        | 194 | 1358 | Luisehahne | 
 | 
      
        | 195 | 1475 | Luisehahne | 		/*-- load css files with jquery --*/
 | 
      
        | 196 |  |  | 		// include jscalendar-setup
 | 
      
        | 197 |  |  | 		$jscal_use_time = true; // whether to use a clock, too
 | 
      
        | 198 |  |  | 		require_once(WB_PATH."/include/jscalendar/wb-setup.php");
 | 
      
        | 199 | 1358 | Luisehahne | 
 | 
      
        | 200 | 1475 | Luisehahne | 		// Setup template object
 | 
      
        | 201 |  |  | 		$tpl = new Template(THEME_PATH.'/templates');
 | 
      
        | 202 |  |  | 		$tpl->set_file('page', 'pages_sections.htt');
 | 
      
        | 203 |  |  | 		$tpl->set_block('page', 'main_block', 'main');
 | 
      
        | 204 |  |  | 		$tpl->set_block('main_block', 'module_block', 'module_list');
 | 
      
        | 205 |  |  | 		$tpl->set_block('main_block', 'section_block', 'section_list');
 | 
      
        | 206 |  |  | 		$tpl->set_block('section_block', 'block_block', 'block_list');
 | 
      
        | 207 |  |  | 		$tpl->set_block('main_block', 'calendar_block', 'calendar_list');
 | 
      
        | 208 |  |  | 		$tpl->set_var('FTAN', $admin->getFTAN());
 | 
      
        | 209 | 1358 | Luisehahne | 
 | 
      
        | 210 | 1475 | Luisehahne | 		// set first defaults and messages
 | 
      
        | 211 |  |  | 		$tpl->set_var(array(
 | 
      
        | 212 |  |  | 						'PAGE_ID' => $results_array['page_id'],
 | 
      
        | 213 |  |  | 						// 'PAGE_IDKEY' => $admin->getIDKEY($results_array['page_id']),
 | 
      
        | 214 |  |  | 						'PAGE_IDKEY' => $results_array['page_id'],
 | 
      
        | 215 |  |  | 						'TEXT_PAGE' => $TEXT['PAGE'],
 | 
      
        | 216 |  |  | 						'PAGE_TITLE' => ($results_array['page_title']),
 | 
      
        | 217 |  |  | 						'MENU_TITLE' => ($results_array['menu_title']),
 | 
      
        | 218 |  |  | 						'TEXT_CURRENT_PAGE' => $TEXT['CURRENT_PAGE'],
 | 
      
        | 219 |  |  | 						'HEADING_MANAGE_SECTIONS' => $HEADING['MANAGE_SECTIONS'],
 | 
      
        | 220 |  |  | 						'HEADING_MODIFY_PAGE' => $HEADING['MODIFY_PAGE'],
 | 
      
        | 221 |  |  | 						'TEXT_CHANGE_SETTINGS' => $TEXT['CHANGE_SETTINGS'],
 | 
      
        | 222 |  |  | 						'TEXT_ADD_SECTION' => $TEXT['ADD_SECTION'],
 | 
      
        | 223 |  |  | 						'TEXT_ID' => 'ID',
 | 
      
        | 224 |  |  | 						'TEXT_TYPE' => $TEXT['TYPE'],
 | 
      
        | 225 |  |  | 						'TEXT_BLOCK' => $TEXT['BLOCK'],
 | 
      
        | 226 |  |  | 						'TEXT_PUBL_START_DATE' => $TEXT{'PUBL_START_DATE'},
 | 
      
        | 227 |  |  | 						'TEXT_PUBL_END_DATE' => $TEXT['PUBL_END_DATE'],
 | 
      
        | 228 |  |  | 						'TEXT_ACTIONS' => $TEXT['ACTIONS'],
 | 
      
        | 229 |  |  | 						'ADMIN_URL' => ADMIN_URL,
 | 
      
        | 230 |  |  | 						'WB_URL' => WB_URL,
 | 
      
        | 231 |  |  | 						'THEME_URL' => THEME_URL
 | 
      
        | 232 |  |  | 						)
 | 
      
        | 233 |  |  | 					);
 | 
      
        | 234 | 1358 | Luisehahne | 
 | 
      
        | 235 | 1475 | Luisehahne | 		// Insert variables
 | 
      
        | 236 |  |  | 		$tpl->set_var(array(
 | 
      
        | 237 |  |  | 						'PAGE_ID' => $results_array['page_id'],
 | 
      
        | 238 |  |  | 						// 'PAGE_IDKEY' => $admin->getIDKEY($results_array['page_id']),
 | 
      
        | 239 |  |  | 						'PAGE_IDKEY' => $results_array['page_id'],
 | 
      
        | 240 |  |  | 						'VAR_PAGE_TITLE' => $results_array['page_title'],
 | 
      
        | 241 |  |  | 						'SETTINGS_LINK' => ADMIN_URL.'/pages/settings.php?page_id='.$results_array['page_id'],
 | 
      
        | 242 |  |  | 						'MODIFY_LINK' => ADMIN_URL.'/pages/modify.php?page_id='.$results_array['page_id']
 | 
      
        | 243 |  |  | 						)
 | 
      
        | 244 |  |  | 					);
 | 
      
        | 245 | 1358 | Luisehahne | 
 | 
      
        | 246 | 1475 | Luisehahne | 		$sql  = 'SELECT `section_id`,`module`,`position`,`block`,`publ_start`,`publ_end` ';
 | 
      
        | 247 |  |  | 		$sql .= 'FROM `'.TABLE_PREFIX.'sections` ';
 | 
      
        | 248 |  |  | 		$sql .= 'WHERE `page_id` = '.$page_id.' ';
 | 
      
        | 249 |  |  | 		$sql .= 'ORDER BY `position` ASC';
 | 
      
        | 250 |  |  | 		$query_sections = $database->query($sql);
 | 
      
        | 251 |  |  | 
 | 
      
        | 252 |  |  | 		if($query_sections->numRows() > 0)
 | 
      
        | 253 |  |  | 		{
 | 
      
        | 254 |  |  | 			$num_sections = $query_sections->numRows();
 | 
      
        | 255 |  |  | 			while($section = $query_sections->fetchRow())
 | 
      
        | 256 |  |  | 		    {
 | 
      
        | 257 |  |  | 				if(!is_numeric(array_search($section['module'], $module_permissions)))
 | 
      
        | 258 |  |  | 		        {
 | 
      
        | 259 |  |  | 					// Get the modules real name
 | 
      
        | 260 |  |  | 		            $sql = 'SELECT `name` FROM `'.TABLE_PREFIX.'addons` ';
 | 
      
        | 261 |  |  | 		            $sql .= 'WHERE `directory` = "'.$section['module'].'"';
 | 
      
        | 262 |  |  | 		            if(!$database->get_one($sql) || !file_exists(WB_PATH.'/modules/'.$section['module']))
 | 
      
        | 263 | 1358 | Luisehahne | 					{
 | 
      
        | 264 | 1475 | Luisehahne | 						$edit_page = '<span class="module_disabled">'.$section['module'].'</span>';
 | 
      
        | 265 |  |  | 					}else
 | 
      
        | 266 |  |  | 					{
 | 
      
        | 267 |  |  | 						$edit_page = '';
 | 
      
        | 268 |  |  | 					}
 | 
      
        | 269 |  |  | 					$edit_page_0 = '<a id="sid'.$section['section_id'].'" href="'.ADMIN_URL.'/pages/modify.php?page_id='.$results_array['page_id'];
 | 
      
        | 270 |  |  | 					$edit_page_1 = $section['section_id'].'">'.$section['module'].'</a>';
 | 
      
        | 271 |  |  | 					if(SECTION_BLOCKS)
 | 
      
        | 272 |  |  | 		            {
 | 
      
        | 273 |  |  | 						if($edit_page == '')
 | 
      
        | 274 |  |  | 						{
 | 
      
        | 275 |  |  | 							if(defined('EDIT_ONE_SECTION') && EDIT_ONE_SECTION)
 | 
      
        | 276 |  |  | 							{
 | 
      
        | 277 |  |  | 								$edit_page = $edit_page_0.'&wysiwyg='.$edit_page_1;
 | 
      
        | 278 |  |  | 							} else {
 | 
      
        | 279 |  |  | 								$edit_page = $edit_page_0.'#wb_'.$edit_page_1;
 | 
      
        | 280 |  |  | 							}
 | 
      
        | 281 |  |  | 						}
 | 
      
        | 282 |  |  | 						$input_attribute = 'input_normal';
 | 
      
        | 283 |  |  | 						$tpl->set_var(array(
 | 
      
        | 284 |  |  | 								'STYLE_DISPLAY_SECTION_BLOCK' => ' style="visibility:visible;"',
 | 
      
        | 285 |  |  | 								'NAME_SIZE' => 300,
 | 
      
        | 286 |  |  | 								'INPUT_ATTRIBUTE' => $input_attribute,
 | 
      
        | 287 |  |  | 								'VAR_SECTION_ID' => $section['section_id'],
 | 
      
        | 288 |  |  | 								'VAR_SECTION_IDKEY' => $admin->getIDKEY($section['section_id']),
 | 
      
        | 289 |  |  | 								// 'VAR_SECTION_IDKEY' => $section['section_id'],
 | 
      
        | 290 |  |  | 								'VAR_POSITION' => $section['position'],
 | 
      
        | 291 |  |  | 								'LINK_MODIFY_URL_VAR_MODUL_NAME' => $edit_page,
 | 
      
        | 292 |  |  | 								'SELECT' => '',
 | 
      
        | 293 |  |  | 								'SET_NONE_DISPLAY_OPTION' => ''
 | 
      
        | 294 |  |  | 								)
 | 
      
        | 295 |  |  | 							);
 | 
      
        | 296 |  |  | 						// Add block options to the section_list
 | 
      
        | 297 |  |  | 						$tpl->clear_var('block_list');
 | 
      
        | 298 |  |  | 						foreach($block AS $number => $name)
 | 
      
        | 299 |  |  | 		                {
 | 
      
        | 300 |  |  | 							$tpl->set_var('NAME', htmlentities(strip_tags($name)));
 | 
      
        | 301 |  |  | 							$tpl->set_var('VALUE', $number);
 | 
      
        | 302 |  |  | 							$tpl->set_var('SIZE', 1);
 | 
      
        | 303 |  |  | 							if($section['block'] == $number)
 | 
      
        | 304 |  |  | 		                    {
 | 
      
        | 305 |  |  | 								$tpl->set_var('SELECTED', ' selected="selected"');
 | 
      
        | 306 |  |  | 							} else {
 | 
      
        | 307 |  |  | 								$tpl->set_var('SELECTED', '');
 | 
      
        | 308 |  |  | 							}
 | 
      
        | 309 |  |  | 							$tpl->parse('block_list', 'block_block', true);
 | 
      
        | 310 |  |  | 						}
 | 
      
        | 311 | 1358 | Luisehahne | 					} else {
 | 
      
        | 312 | 1475 | Luisehahne | 						if($edit_page == '')
 | 
      
        | 313 |  |  | 						{
 | 
      
        | 314 |  |  | 							$edit_page = $edit_page_0.'#wb_'.$edit_page_1;
 | 
      
        | 315 |  |  | 						}
 | 
      
        | 316 |  |  | 						$input_attribute = 'input_normal';
 | 
      
        | 317 |  |  | 						$tpl->set_var(array(
 | 
      
        | 318 |  |  | 								'STYLE_DISPLAY_SECTION_BLOCK' => ' style="visibility:hidden;"',
 | 
      
        | 319 |  |  | 								'NAME_SIZE' => 300,
 | 
      
        | 320 |  |  | 								'INPUT_ATTRIBUTE' => $input_attribute,
 | 
      
        | 321 |  |  | 								'VAR_SECTION_ID' => $section['section_id'],
 | 
      
        | 322 |  |  | 								'VAR_SECTION_IDKEY' => $admin->getIDKEY($section['section_id']),
 | 
      
        | 323 |  |  | 								// 'VAR_SECTION_IDKEY' => $section['section_id'],
 | 
      
        | 324 |  |  | 								'VAR_POSITION' => $section['position'],
 | 
      
        | 325 |  |  | 								'LINK_MODIFY_URL_VAR_MODUL_NAME' => $edit_page,
 | 
      
        | 326 |  |  | 								'NAME' => htmlentities(strip_tags($block[1])),
 | 
      
        | 327 |  |  | 								'VALUE' => 1,
 | 
      
        | 328 |  |  | 								'SET_NONE_DISPLAY_OPTION' => ''
 | 
      
        | 329 |  |  | 								)
 | 
      
        | 330 |  |  | 							);
 | 
      
        | 331 | 1358 | Luisehahne | 					}
 | 
      
        | 332 | 1475 | Luisehahne | 					// Insert icon and images
 | 
      
        | 333 |  |  | 					$tpl->set_var(array(
 | 
      
        | 334 |  |  | 								'CLOCK_16_PNG' => 'clock_16.png',
 | 
      
        | 335 |  |  | 								'CLOCK_DEL_16_PNG' => 'clock_del_16.png',
 | 
      
        | 336 |  |  | 								'DELETE_16_PNG' => 'delete_16.png'
 | 
      
        | 337 |  |  | 								)
 | 
      
        | 338 |  |  | 							);
 | 
      
        | 339 |  |  | 					// set calendar start values
 | 
      
        | 340 |  |  | 					if($section['publ_start']==0)
 | 
      
        | 341 |  |  | 		            {
 | 
      
        | 342 |  |  | 						$tpl->set_var('VALUE_PUBL_START', '');
 | 
      
        | 343 | 1358 | Luisehahne | 					} else {
 | 
      
        | 344 | 1475 | Luisehahne | 						$tpl->set_var('VALUE_PUBL_START', date($jscal_format, $section['publ_start']));
 | 
      
        | 345 | 1358 | Luisehahne | 					}
 | 
      
        | 346 | 1475 | Luisehahne | 					// set calendar start values
 | 
      
        | 347 |  |  | 					if($section['publ_end']==0)
 | 
      
        | 348 |  |  | 		            {
 | 
      
        | 349 |  |  | 						$tpl->set_var('VALUE_PUBL_END', '');
 | 
      
        | 350 |  |  | 					} else {
 | 
      
        | 351 |  |  | 						$tpl->set_var('VALUE_PUBL_END', date($jscal_format, $section['publ_end']));
 | 
      
        | 352 |  |  | 					}
 | 
      
        | 353 |  |  | 					// Insert icons up and down
 | 
      
        | 354 |  |  | 					if($section['position'] != 1 )
 | 
      
        | 355 |  |  | 		            {
 | 
      
        | 356 |  |  | 						$tpl->set_var(
 | 
      
        | 357 |  |  | 									'VAR_MOVE_UP_URL',
 | 
      
        | 358 |  |  | 									'<a href="'.ADMIN_URL.'/pages/move_up.php?page_id='.$page_id.'&section_id='.$section['section_id'].'">
 | 
      
        | 359 |  |  | 									<img src="'.THEME_URL.'/images/up_16.png" alt="{TEXT_MOVE_UP}" />
 | 
      
        | 360 |  |  | 									</a>' );
 | 
      
        | 361 |  |  | 					} else {
 | 
      
        | 362 |  |  | 						$tpl->set_var(array(
 | 
      
        | 363 |  |  | 									'VAR_MOVE_UP_URL' => ''
 | 
      
        | 364 |  |  | 									)
 | 
      
        | 365 |  |  | 								);
 | 
      
        | 366 |  |  | 					}
 | 
      
        | 367 |  |  | 					if($section['position'] != $num_sections ) {
 | 
      
        | 368 |  |  | 						$tpl->set_var(
 | 
      
        | 369 |  |  | 									'VAR_MOVE_DOWN_URL',
 | 
      
        | 370 |  |  | 									'<a href="'.ADMIN_URL.'/pages/move_down.php?page_id='.$page_id.'&section_id='.$section['section_id'].'">
 | 
      
        | 371 |  |  | 									<img src="'.THEME_URL.'/images/down_16.png" alt="{TEXT_MOVE_DOWN}" />
 | 
      
        | 372 |  |  | 									</a>' );
 | 
      
        | 373 |  |  | 					} else {
 | 
      
        | 374 |  |  | 						$tpl->set_var(array(
 | 
      
        | 375 |  |  | 									'VAR_MOVE_DOWN_URL' => ''
 | 
      
        | 376 |  |  | 									)
 | 
      
        | 377 |  |  | 								);
 | 
      
        | 378 |  |  | 					}
 | 
      
        | 379 |  |  | 				} else {
 | 
      
        | 380 |  |  | 				  continue;
 | 
      
        | 381 | 1358 | Luisehahne | 				}
 | 
      
        | 382 | 1475 | Luisehahne | 
 | 
      
        | 383 |  |  | 					$tpl->set_var(array(
 | 
      
        | 384 |  |  | 									'DISPLAY_DEBUG' => ' style="visibility="visible;"',
 | 
      
        | 385 |  |  | 									'TEXT_SID' => 'SID',
 | 
      
        | 386 |  |  | 									'DEBUG_COLSPAN_SIZE' => 9
 | 
      
        | 387 |  |  | 									)
 | 
      
        | 388 |  |  | 								);
 | 
      
        | 389 |  |  | 				if($debug)
 | 
      
        | 390 |  |  | 		        {
 | 
      
        | 391 |  |  | 					$tpl->set_var(array(
 | 
      
        | 392 |  |  | 									'DISPLAY_DEBUG' => ' style="visibility="visible;"',
 | 
      
        | 393 |  |  | 									'TEXT_PID' => 'PID',
 | 
      
        | 394 |  |  | 									'TEXT_SID' => 'SID',
 | 
      
        | 395 |  |  | 									'POSITION' => $section['position']
 | 
      
        | 396 |  |  | 									)
 | 
      
        | 397 |  |  | 								);
 | 
      
        | 398 |  |  | 				} else {
 | 
      
        | 399 |  |  | 					$tpl->set_var(array(
 | 
      
        | 400 |  |  | 									'DISPLAY_DEBUG' => ' style="display:none;"',
 | 
      
        | 401 |  |  | 									'TEXT_PID' => '',
 | 
      
        | 402 |  |  | 									'POSITION' => ''
 | 
      
        | 403 |  |  | 									)
 | 
      
        | 404 |  |  | 								);
 | 
      
        | 405 | 1358 | Luisehahne | 				}
 | 
      
        | 406 | 1475 | Luisehahne | 				$tpl->parse('section_list', 'section_block', true);
 | 
      
        | 407 | 1358 | Luisehahne | 			}
 | 
      
        | 408 |  |  | 		}
 | 
      
        | 409 |  |  | 
 | 
      
        | 410 | 1475 | Luisehahne | 		// now add the calendars -- remember to to set the range to [1970, 2037] if the date is used as timestamp!
 | 
      
        | 411 |  |  | 		// the loop is simply a copy from above.
 | 
      
        | 412 |  |  | 		$sql  = 'SELECT `section_id`,`module` FROM `'.TABLE_PREFIX.'sections` ';
 | 
      
        | 413 |  |  | 		$sql .= 'WHERE page_id = '.$page_id.' ';
 | 
      
        | 414 |  |  | 		$sql .= 'ORDER BY `position` ASC';
 | 
      
        | 415 |  |  | 		$query_sections = $database->query($sql);
 | 
      
        | 416 | 1358 | Luisehahne | 
 | 
      
        | 417 | 1475 | Luisehahne | 		if($query_sections->numRows() > 0)
 | 
      
        | 418 |  |  | 		{
 | 
      
        | 419 |  |  | 			$num_sections = $query_sections->numRows();
 | 
      
        | 420 |  |  | 			while($section = $query_sections->fetchRow())
 | 
      
        | 421 |  |  | 		    {
 | 
      
        | 422 |  |  | 				// Get the modules real name
 | 
      
        | 423 |  |  | 		        $sql  = 'SELECT `name` FROM `'.TABLE_PREFIX.'addons` ';
 | 
      
        | 424 |  |  | 		        $sql .= 'WHERE `directory` = "'.$section['module'].'"';
 | 
      
        | 425 |  |  | 		        $module_name = $database->get_one($sql);
 | 
      
        | 426 | 1358 | Luisehahne | 
 | 
      
        | 427 | 1475 | Luisehahne | 				if(!is_numeric(array_search($section['module'], $module_permissions)))
 | 
      
        | 428 |  |  | 		        {
 | 
      
        | 429 |  |  | 					$tpl->set_var(array(
 | 
      
        | 430 |  |  | 								'jscal_ifformat' => $jscal_ifformat,
 | 
      
        | 431 |  |  | 								'jscal_firstday' => $jscal_firstday,
 | 
      
        | 432 |  |  | 								'jscal_today' => $jscal_today,
 | 
      
        | 433 |  |  | 								'start_date' => 'start_date'.$section['section_id'],
 | 
      
        | 434 |  |  | 								'end_date' => 'end_date'.$section['section_id'],
 | 
      
        | 435 |  |  | 								'trigger_start' => 'trigger_start'.$section['section_id'],
 | 
      
        | 436 |  |  | 								'trigger_end' => 'trigger_stop'.$section['section_id']
 | 
      
        | 437 |  |  | 								)
 | 
      
        | 438 |  |  | 							);
 | 
      
        | 439 |  |  | 					if(isset($jscal_use_time) && $jscal_use_time==TRUE) {
 | 
      
        | 440 |  |  | 						$tpl->set_var(array(
 | 
      
        | 441 |  |  | 								'showsTime' => "true",
 | 
      
        | 442 |  |  | 								'timeFormat' => "24"
 | 
      
        | 443 |  |  | 								)
 | 
      
        | 444 |  |  | 							);
 | 
      
        | 445 |  |  | 					}  else {
 | 
      
        | 446 |  |  | 						$tpl->set_var(array(
 | 
      
        | 447 |  |  | 								'showsTime' => "false",
 | 
      
        | 448 |  |  | 								'timeFormat' => "24"
 | 
      
        | 449 |  |  | 								)
 | 
      
        | 450 |  |  | 							);
 | 
      
        | 451 |  |  | 					}
 | 
      
        | 452 |  |  | 				}
 | 
      
        | 453 |  |  | 				$tpl->parse('calendar_list', 'calendar_block', true);
 | 
      
        | 454 | 1358 | Luisehahne | 			}
 | 
      
        | 455 |  |  | 		}
 | 
      
        | 456 |  |  | 
 | 
      
        | 457 | 1475 | Luisehahne | 		// Work-out if we should show the "Add Section" form
 | 
      
        | 458 |  |  | 		$sql  = 'SELECT `section_id` FROM `'.TABLE_PREFIX.'sections` ';
 | 
      
        | 459 |  |  | 		$sql .= 'WHERE `page_id` = '.$page_id.' AND `module` = "menu_link"';
 | 
      
        | 460 |  |  | 		$query_sections = $database->query($sql);
 | 
      
        | 461 |  |  | 		if($query_sections->numRows() == 0)
 | 
      
        | 462 |  |  | 		{
 | 
      
        | 463 |  |  | 			// Modules list
 | 
      
        | 464 |  |  | 		    $sql  = 'SELECT `name`,`directory`,`type` FROM `'.TABLE_PREFIX.'addons` ';
 | 
      
        | 465 |  |  | 		    $sql .= 'WHERE `type` = "module" AND `function` = "page" AND `directory` != "menu_link" ';
 | 
      
        | 466 |  |  | 		    $sql .= 'ORDER BY `name`';
 | 
      
        | 467 |  |  | 		    $result = $database->query($sql);
 | 
      
        | 468 |  |  | 		// if(DEBUG && $database->is_error()) { $admin->print_error($database->get_error()); }
 | 
      
        | 469 | 1358 | Luisehahne | 
 | 
      
        | 470 | 1475 | Luisehahne | 			if($result->numRows() > 0)
 | 
      
        | 471 |  |  | 		    {
 | 
      
        | 472 |  |  | 				while ($module = $result->fetchRow())
 | 
      
        | 473 |  |  | 		        {
 | 
      
        | 474 |  |  | 					// Check if user is allowed to use this module   echo  $module['directory'],'<br />';
 | 
      
        | 475 |  |  | 					if(!is_numeric(array_search($module['directory'], $module_permissions)))
 | 
      
        | 476 |  |  | 		            {
 | 
      
        | 477 |  |  | 						$tpl->set_var('VALUE', $module['directory']);
 | 
      
        | 478 |  |  | 						$tpl->set_var('NAME', $module['name']);
 | 
      
        | 479 |  |  | 						if($module['directory'] == 'wysiwyg')
 | 
      
        | 480 |  |  | 		                {
 | 
      
        | 481 |  |  | 							$tpl->set_var('SELECTED', ' selected="selected"');
 | 
      
        | 482 |  |  | 						} else {
 | 
      
        | 483 |  |  | 							$tpl->set_var('SELECTED', '');
 | 
      
        | 484 |  |  | 						}
 | 
      
        | 485 |  |  | 						$tpl->parse('module_list', 'module_block', true);
 | 
      
        | 486 |  |  | 					} else {
 | 
      
        | 487 |  |  | 					  continue;
 | 
      
        | 488 |  |  | 					}
 | 
      
        | 489 | 1358 | Luisehahne | 				}
 | 
      
        | 490 |  |  | 			}
 | 
      
        | 491 |  |  | 		}
 | 
      
        | 492 | 1475 | Luisehahne | 		// Insert language text and messages
 | 
      
        | 493 |  |  | 		$tpl->set_var(array(
 | 
      
        | 494 |  |  | 							'TEXT_MANAGE_SECTIONS' => $HEADING['MANAGE_SECTIONS'],
 | 
      
        | 495 |  |  | 							'TEXT_ARE_YOU_SURE' => url_encode($TEXT['ARE_YOU_SURE']),
 | 
      
        | 496 |  |  | 							'TEXT_TYPE' => $TEXT['TYPE'],
 | 
      
        | 497 |  |  | 							'TEXT_ADD' => $TEXT['ADD'],
 | 
      
        | 498 |  |  | 							'TEXT_SAVE' =>  $TEXT['SAVE'],
 | 
      
        | 499 |  |  | 							'TEXTLINK_MODIFY_PAGE' => $HEADING['MODIFY_PAGE'],
 | 
      
        | 500 |  |  | 							'TEXT_CALENDAR' => $TEXT['CALENDAR'],
 | 
      
        | 501 |  |  | 							'TEXT_DELETE_DATE' => $TEXT['DELETE_DATE'],
 | 
      
        | 502 |  |  | 							'TEXT_ADD_SECTION' => $TEXT['ADD_SECTION'],
 | 
      
        | 503 |  |  | 							'TEXT_MOVE_UP' => $TEXT['MOVE_UP'],
 | 
      
        | 504 |  |  | 							'TEXT_MOVE_DOWN' => $TEXT['MOVE_DOWN']
 | 
      
        | 505 |  |  | 							)
 | 
      
        | 506 |  |  | 						);
 | 
      
        | 507 |  |  | 		$tpl->parse('main', 'main_block', false);
 | 
      
        | 508 |  |  | 		$tpl->pparse('output', 'page');
 | 
      
        | 509 |  |  | 		// include the required file for Javascript admin
 | 
      
        | 510 |  |  | 		if(file_exists(WB_PATH.'/modules/jsadmin/jsadmin_backend_include.php'))
 | 
      
        | 511 |  |  | 		{
 | 
      
        | 512 |  |  | 			include(WB_PATH.'/modules/jsadmin/jsadmin_backend_include.php');
 | 
      
        | 513 |  |  | 		}
 | 
      
        | 514 |  |  | 		break;
 | 
      
        | 515 |  |  | endswitch;
 | 
      
        | 516 | 1358 | Luisehahne | 
 | 
      
        | 517 |  |  | // Print admin footer
 | 
      
        | 518 |  |  | $admin->print_footer();
 |