<?php
/**
 *
 * @category        admin
 * @package         pages
 * @author          WebsiteBaker Project
 * @copyright       2004-2009, Ryan Djurovich
 * @copyright       2009-2010, Website Baker Org. e.V.
 * @link			http://www.websitebaker2.org/
 * @license         http://www.gnu.org/licenses/gpl.html
 * @platform        WebsiteBaker 2.8.x
 * @requirements    PHP 4.3.4 and higher
 * @version         $Id: settings.php 1289 2010-02-10 15:13:21Z kweitzel $
 * @filesource		$HeadURL: svn://isteam.dynxs.de/wb-archiv/trunk/wb/admin/pages/settings.php $
 * @lastmodified    $Date: 2010-02-10 16:13:21 +0100 (Wed, 10 Feb 2010) $
 *
 */

// Get page id
if(!isset($_GET['page_id']) OR !is_numeric($_GET['page_id']))
{
	header("Location: index.php");
	exit(0);
} else {
	$page_id = $_GET['page_id'];
}

// Create new admin object
require('../../config.php');
require_once(WB_PATH.'/framework/class.admin.php');
$admin = new admin('Pages', 'pages_settings');

// Include the WB functions file
require_once(WB_PATH.'/framework/functions-utf8.php');

// Get perms
/*$database = new database(); */

$sql = 'SELECT * FROM `'.TABLE_PREFIX.'pages` WHERE `page_id` = '.$page_id;
$results = $database->query($sql);
$results_array = $results->fetchRow();

$old_admin_groups = explode(',', $results_array['admin_groups']);
$old_admin_users = explode(',', $results_array['admin_users']);

// Work-out if we should check for existing page_code
$sql = 'DESCRIBE `'.TABLE_PREFIX.'pages` `page_code`';
$field_sql = $database->query($sql);
$field_set = $field_sql->numRows();

$in_old_group = FALSE;
foreach($admin->get_groups_id() as $cur_gid)
{
	if (in_array($cur_gid, $old_admin_groups))
    {
		$in_old_group = TRUE;
	}
}
if((!$in_old_group) AND !is_numeric(array_search($admin->get_user_id(), $old_admin_users)))
{
	$admin->print_error($MESSAGE['PAGES']['INSUFFICIENT_PERMISSIONS']);
}

// Get page details
/* $database = new database();  */
$sql = 'SELECT * FROM `'.TABLE_PREFIX.'pages` WHERE `page_id`='.$page_id;
$results = $database->query($sql);
if($database->is_error()) {
	$admin->print_header();
	$admin->print_error($database->get_error());
}
if($results->numRows() == 0) {
	$admin->print_header();
	$admin->print_error($MESSAGE['PAGES']['NOT_FOUND']);
}
$results_array = $results->fetchRow();

// Get display name of person who last modified the page
$user=$admin->get_user_details($results_array['modified_by']);

// Convert the unix ts for modified_when to human a readable form
if($results_array['modified_when'] != 0)
{
	$modified_ts = gmdate(TIME_FORMAT.', '.DATE_FORMAT, $results_array['modified_when']+TIMEZONE);
} else {
	$modified_ts = 'Unknown';
}

// Setup template object, parse vars to it, then parse it
$template = new Template(THEME_PATH.'/templates');
$template->set_file('page', 'pages_settings.htt');
$template->set_block('page', 'main_block', 'main');

$template->set_var(array(
				'PAGE_ID' => $results_array['page_id'],
				'PAGE_TITLE' => ($results_array['page_title']),
				'MENU_TITLE' => ($results_array['menu_title']),
				'DESCRIPTION' => ($results_array['description']),
				'KEYWORDS' => ($results_array['keywords']),
				'MODIFIED_BY' => $user['display_name'],
				'MODIFIED_BY_USERNAME' => $user['username'],
				'MODIFIED_WHEN' => $modified_ts,
				'ADMIN_URL' => ADMIN_URL,
				'WB_URL' => WB_URL,
				'WB_PATH' => WB_PATH,
				'THEME_URL' => THEME_URL
				)
		);

// Work-out if we should show the "manage sections" link
$sql = 'SELECT `section_id` FROM `'.TABLE_PREFIX.'sections` WHERE `page_id`='.$page_id.' AND `module`="menu_link"';
$query_sections = $database->query($sql);
if($query_sections->numRows() > 0)
{
    $template->set_var('DISPLAY_MANAGE_SECTIONS', 'display:none;');
} elseif(MANAGE_SECTIONS == 'enabled')
{
	$template->set_var('TEXT_MANAGE_SECTIONS', $HEADING['MANAGE_SECTIONS']);
} else {
	$template->set_var('DISPLAY_MANAGE_SECTIONS', 'display:none;');
}

// Visibility
if($results_array['visibility'] == 'public') {
	$template->set_var('PUBLIC_SELECTED', ' selected="selected"');
} elseif($results_array['visibility'] == 'private') {
	$template->set_var('PRIVATE_SELECTED', ' selected="selected"');
} elseif($results_array['visibility'] == 'registered') {
	$template->set_var('REGISTERED_SELECTED', ' selected="selected"');
} elseif($results_array['visibility'] == 'hidden') {
	$template->set_var('HIDDEN_SELECTED', ' selected="selected"');
} elseif($results_array['visibility'] == 'display:none;') {
	$template->set_var('NO_VIS_SELECTED', ' selected="selected"');
}
// Group list 1 (admin_groups)
	$admin_groups = explode(',', str_replace('_', '', $results_array['admin_groups']));

	$sql = 'SELECT * FROM `'.TABLE_PREFIX.'groups`';
    $get_groups = $database->query($sql);

	$template->set_block('main_block', 'group_list_block', 'group_list');
	// Insert admin group and current group first
	$admin_group_name = $get_groups->fetchRow();
	$template->set_var(array(
									'ID' => 1,
									'TOGGLE' => '',
									'DISABLED' => ' disabled="disabled"',
									'LINK_COLOR' => '000000',
									'CURSOR' => 'default',
									'NAME' => $admin_group_name['name'],
									'CHECKED' => ' checked="checked"'
									)
							);
	$template->parse('group_list', 'group_list_block', true);
	while($group = $get_groups->fetchRow()) {
		// check if the user is a member of this group
		$flag_disabled = '';
		$flag_checked =  '';
		$flag_cursor =   'pointer';
		$flag_color =    '';
		if (in_array($group["group_id"], $admin->get_groups_id())) {
			$flag_disabled = ''; //' disabled';
			$flag_checked =  ''; //' checked';
			$flag_cursor =   'default';
			$flag_color =    '000000';
		}

		// Check if the group is allowed to edit pages
		$system_permissions = explode(',', $group['system_permissions']);
		if(is_numeric(array_search('pages_modify', $system_permissions))) {
			$template->set_var(array(
											'ID' => $group['group_id'],
											'TOGGLE' => $group['group_id'],
											'DISABLED' => $flag_disabled,
											'LINK_COLOR' => $flag_color,
											'CURSOR' => $flag_cursor,
											'NAME' => $group['name'],
											'CHECKED' => $flag_checked
											)
									);
			if(is_numeric(array_search($group['group_id'], $admin_groups))) {
				$template->set_var('CHECKED', ' checked="checked"');
			} else {
				if (!$flag_checked) $template->set_var('CHECKED', '');
			}
			$template->parse('group_list', 'group_list_block', true);
		}
	}
// Group list 2 (viewing_groups)
	$viewing_groups = explode(',', str_replace('_', '', $results_array['viewing_groups']));

    $sql = 'SELECT * FROM `'.TABLE_PREFIX.'groups`';
    $get_groups = $database->query($sql);

	$template->set_block('main_block', 'group_list_block2', 'group_list2');
	// Insert admin group and current group first
	$admin_group_name = $get_groups->fetchRow();
	$template->set_var(array(
									'ID' => 1,
									'TOGGLE' => '',
									'DISABLED' => ' disabled="disabled"',
									'LINK_COLOR' => '000000',
									'CURSOR' => 'default',
									'NAME' => $admin_group_name['name'],
									'CHECKED' => ' checked="checked"'
									)
							);
	$template->parse('group_list2', 'group_list_block2', true);

	while($group = $get_groups->fetchRow())
    {
		// check if the user is a member of this group
		$flag_disabled = '';
		$flag_checked =  '';
		$flag_cursor =   'pointer';
		$flag_color =    '';
		if (in_array($group["group_id"], $admin->get_groups_id()))
        {
			$flag_disabled = ''; //' disabled';
			$flag_checked =  ''; //' checked';
			$flag_cursor =   'default';
			$flag_color =    '000000';
		}

		$template->set_var(array(
										'ID' => $group['group_id'],
										'TOGGLE' => $group['group_id'],
										'DISABLED' => $flag_disabled,
										'LINK_COLOR' => $flag_color,
										'CURSOR' => $flag_cursor,
										'NAME' => $group['name'],
										'CHECKED' => $flag_checked
										)
								);
		if(is_numeric(array_search($group['group_id'], $viewing_groups)))
        {
			$template->set_var('CHECKED', 'checked="checked"');
		} else {
			if (!$flag_checked) {$template->set_var('CHECKED', '');}
		}

		$template->parse('group_list2', 'group_list_block2', true);

	}

// Show private viewers
if($results_array['visibility'] == 'private' OR $results_array['visibility'] == 'registered')
{
	$template->set_var('DISPLAY_VIEWERS', '');
} else {
	$template->set_var('DISPLAY_VIEWERS', 'display:none;');
}

//-- insert page_code 20090904-->
$template->set_var('DISPLAY_CODE_PAGE_LIST', ' id="multi_lingual" style="display:none;"');

// Work-out if page languages feature is enabled
if((defined('PAGE_LANGUAGES') && PAGE_LANGUAGES) && $field_set && file_exists(WB_PATH.'/modules/mod_multilingual/update_keys.php') )
{
    // workout field is set but module missing
    $TEXT['PAGE_CODE'] = empty($TEXT['PAGE_CODE']) ? 'Pagecode' : $TEXT['PAGE_CODE'];
	$template->set_var( array(
            'DISPLAY_CODE_PAGE_LIST' => ' id="multi_lingual"',
            'TEXT_PAGE_CODE' => '<a href="'.WB_URL.'/modules/mod_multilingual/update_keys.php?page_id='.$page_id.'">'.$TEXT['PAGE_CODE'].'</a>'
        )
    );

	// Page_code list
   /* 	$database = new database();  */
	function page_code_list($parent)
    {
		global $admin, $database, $template, $results_array, $pageCode;
		$default_language = DEFAULT_LANGUAGE;

        $sql = 'SELECT * FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$parent.' AND `language` = "'.$default_language.'" ORDER BY `position` ASC';
        $get_pages = $database->query($sql);

		while($page = $get_pages->fetchRow())
        {
			if($admin->page_is_visible($page)==false)
				continue;
			$template->set_var('FLAG_CODE_ICON',' none ');
			if( $page['parent'] == 0 )
            {
				$template->set_var('FLAG_CODE_ICON','url('.THEME_URL.'/images/flags/'.strtolower($page['language']).'.png)');
			}
			// If the current page cannot be parent, then its children neither
			$list_next_level = true;
			// Stop users from adding pages with a level of more than the set page level limit
			if($page['level']+1 < PAGE_LEVEL_LIMIT)
            {
				// Get user perms
				$admin_groups = explode(',', str_replace('_', '', $page['admin_groups']));
				$admin_users = explode(',', str_replace('_', '', $page['admin_users']));

				$in_group = FALSE;
				foreach($admin->get_groups_id() as $cur_gid)
                {
					if (in_array($cur_gid, $admin_groups))
					{
						$in_group = TRUE;
					}
				}

				if(($in_group) OR is_numeric(array_search($admin->get_user_id(), $admin_users)))
                {
					$can_modify = true;
				} else {
					$can_modify = false;
				}

				$title_prefix = '';
				for($i = 1; $i <= $page['level']; $i++) { $title_prefix .= ' - - &nbsp;'; }
                // $space = str_repeat('&nbsp;', 3);  $space.'&lt;'..'&gt;'
				$template->set_var(array(
										'VALUE' => $page['page_code'],
                                        'PAGE_VALUE' => $title_prefix.$page['page_code'],
										'PAGE_CODE' => $title_prefix.$page['menu_title']
										)
								);
				if($results_array['page_code'] == $page['page_code']) {
					$template->set_var('SELECTED', ' selected="selected"');
				} elseif($results_array['page_code'] == $page['page_code']) {
					$template->set_var('SELECTED', ' disabled="disabled" class="disabled"');
					$list_next_level=false;
				} elseif($can_modify != true) {
					$template->set_var('SELECTED', ' disabled="disabled" class="disabled"');
				} else {
					$template->set_var('SELECTED', '');
				}
				$template->parse('page_code_list', 'page_code_list_block', true);
			}
			if ($list_next_level)
				page_code_list($page['page_id']);
		}
	}

	// Insert code_page values from page to modify
	$template->set_block('main_block', 'page_code_list_block', 'page_code_list');
	if($admin->get_permission('pages_add_l0') == true OR $results_array['level'] == 0) {
		if($results_array['parent'] == 0) { $selected = ' selected'; } else { $selected = ''; }
		$template->set_var(array(
									'VALUE' => '',
									'PAGE_CODE' => $TEXT['NONE'],
                                    'PAGE_VALUE' => '',
									'SELECTED' => $selected
								)
							);
		$template->parse('page_code_list', 'page_code_list_block', true);
	}
	// get pagecode form this page_id
   	page_code_list(0);
}
//-- page code -->

// Parent page list
/* $database = new database();  */
function parent_list($parent)
{
	global $admin, $database, $template, $results_array,$field_set;

    $sql = 'SELECT * FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$parent.' ORDER BY `position` ASC';
    $get_pages = $database->query($sql);

	while($page = $get_pages->fetchRow())
    {
		if($admin->page_is_visible($page)==false)
        {
          continue;
        }

		// if parent = 0 set flag_icon
		$template->set_var('FLAG_ROOT_ICON',' none ');
		if( $page['parent'] == 0  && $field_set)
        {
			$template->set_var('FLAG_ROOT_ICON','url('.THEME_URL.'/images/flags/'.strtolower($page['language']).'.png)');
		}
		// If the current page cannot be parent, then its children neither
		$list_next_level = true;
		// Stop users from adding pages with a level of more than the set page level limit
		if($page['level']+1 < PAGE_LEVEL_LIMIT)
        {
			// Get user perms
			$admin_groups = explode(',', str_replace('_', '', $page['admin_groups']));
			$admin_users = explode(',', str_replace('_', '', $page['admin_users']));
			$in_group = FALSE;
			foreach($admin->get_groups_id() as $cur_gid)
            {
				if (in_array($cur_gid, $admin_groups))
                {
					$in_group = TRUE;
				}
			}
			if(($in_group) OR is_numeric(array_search($admin->get_user_id(), $admin_users)))
            {
				$can_modify = true;
			} else {
				$can_modify = false;
			}
			// Title -'s prefix
			$title_prefix = '';
			for($i = 1; $i <= $page['level']; $i++) { $title_prefix .= ' - '; }
			$template->set_var(array(
											'ID' => $page['page_id'],
											'TITLE' => ($title_prefix.$page['menu_title']),
											'MENU-TITLE' => ($title_prefix.$page['menu_title']),
											'PAGE-TITLE' => ($title_prefix.$page['page_title']),
											'FLAG_ICON' => ' none ',
											));

			if($results_array['parent'] == $page['page_id'])
            {
				$template->set_var('SELECTED', ' selected="selected"');
			} elseif($results_array['page_id'] == $page['page_id'])
            {
				$template->set_var('SELECTED', ' disabled="disabled" class="disabled"');
				$list_next_level=false;
			} elseif($can_modify != true)
            {
				$template->set_var('SELECTED', ' disabled="disabled" class="disabled"');
			} else {
				$template->set_var('SELECTED', '');
			}
			$template->parse('page_list2', 'page_list_block2', true);
		}
		if ($list_next_level)
        {
          parent_list($page['page_id']);
        }

	}
}

$template->set_block('main_block', 'page_list_block2', 'page_list2');
if($admin->get_permission('pages_add_l0') == true OR $results_array['level'] == 0) {
	if($results_array['parent'] == 0)
    {
		$selected = ' selected="selected"';
	} else { 
		$selected = '';
	}
	$template->set_var(array(
									'ID' => '0',
									'TITLE' => $TEXT['NONE'],
									'SELECTED' => $selected
									)
							);
	$template->parse('page_list2', 'page_list_block2', true);
}
parent_list(0);

if($modified_ts == 'Unknown')
{
	$template->set_var('DISPLAY_MODIFIED', 'hide');
} else {
	$template->set_var('DISPLAY_MODIFIED', '');
}

// Templates list
$template->set_block('main_block', 'template_list_block', 'template_list');

$sql = 'SELECT * FROM `'.TABLE_PREFIX.'addons` WHERE `type` = "template" AND `function` = "template" order by `name`';
$result = $database->query($sql);

if($result->numRows() > 0)
{
	while($addon = $result->fetchRow())
    {
		// Check if the user has perms to use this template
		if($addon['directory'] == $results_array['template'] OR $admin->get_permission($addon['directory'], 'template') == true)
        {
			$template->set_var('VALUE', $addon['directory']);
			$template->set_var('NAME', $addon['name']);
			if($addon['directory'] == $results_array['template'])
            {
				$template->set_var('SELECTED', ' selected="selected"');
			} else {
				$template->set_var('SELECTED', '');
			}
			$template->parse('template_list', 'template_list_block', true);
		}
	}
}

// Menu list
if(MULTIPLE_MENUS == false)
{
	$template->set_var('DISPLAY_MENU_LIST', 'display:none;');
}
// Include template info file (if it exists)
if($results_array['template'] != '')
{
	$template_location = WB_PATH.'/templates/'.$results_array['template'].'/info.php';
} else {
	$template_location = WB_PATH.'/templates/'.DEFAULT_TEMPLATE.'/info.php';
}
if(file_exists($template_location))
{
	require($template_location);
}
// Check if $menu is set
if(!isset($menu[1]) OR $menu[1] == '')
{
	// Make our own menu list
	$menu[1] = $TEXT['MAIN'];
}
// Add menu options to the list
$template->set_block('main_block', 'menu_list_block', 'menu_list');
foreach($menu AS $number => $name)
{
	$template->set_var('NAME', $name);
	$template->set_var('VALUE', $number);
	if($results_array['menu'] == $number)
    {
		$template->set_var('SELECTED', ' selected="selected"');
	} else {
		$template->set_var('SELECTED', '');
	}
	$template->parse('menu_list', 'menu_list_block', true);
}

// Insert language values
$template->set_block('main_block', 'language_list_block', 'language_list');

$sql = 'SELECT * FROM `'.TABLE_PREFIX.'addons` WHERE `type` = "language" ORDER BY `name`';
$result = $database->query($sql);

if($result->numRows() > 0)
{
	while($addon = $result->fetchRow())
    {
		$l_codes[$addon['name']] = $addon['directory'];
		$l_names[$addon['name']] = entities_to_7bit($addon['name']); // sorting-problem workaround
	}
	asort($l_names);
	foreach($l_names as $l_name=>$v)
    {
		// Insert code and name
		$template->set_var(array(
								'VALUE' => $l_codes[$l_name],
								'NAME' => $l_name,
								'FLAG_LANG_ICONS' => 'url('.THEME_URL.'/images/flags/'.strtolower($l_codes[$l_name]).'.png)',
								));
		// Check if it is selected
		if($results_array['language'] == $l_codes[$l_name])
        {
			$template->set_var('SELECTED', ' selected="selected"');
		} else {
			$template->set_var('SELECTED', '');
		}
		$template->parse('language_list', 'language_list_block', true);
	}
}

// Select disabled if searching is disabled
if($results_array['searching'] == 0)
{
	$template->set_var('SEARCHING_DISABLED', ' selected="selected"');
}
// Select what the page target is
switch ($results_array['target'])
{
	case '_top':
		$template->set_var('TOP_SELECTED', ' selected="selected"');
		break;
	case '_self':
		$template->set_var('SELF_SELECTED', ' selected="selected"');
		break;
	case '_blank':
		$template->set_var('BLANK_SELECTED', ' selected="selected"');
		break;
}

// Insert language text
$template->set_var(array(
				'HEADING_MODIFY_PAGE_SETTINGS' => $HEADING['MODIFY_PAGE_SETTINGS'],
				'TEXT_CURRENT_PAGE' => $TEXT['CURRENT_PAGE'],
				'TEXT_MODIFY' => $TEXT['MODIFY'],
				'TEXT_MODIFY_PAGE' => $HEADING['MODIFY_PAGE'],
				'LAST_MODIFIED' => $MESSAGE['PAGES']['LAST_MODIFIED'],
				'TEXT_PAGE_TITLE' => $TEXT['PAGE_TITLE'],
				'TEXT_MENU_TITLE' => $TEXT['MENU_TITLE'],
				'TEXT_TYPE' => $TEXT['TYPE'],
				'TEXT_MENU' => $TEXT['MENU'],
				'TEXT_PARENT' => $TEXT['PARENT'],
				'TEXT_VISIBILITY' => $TEXT['VISIBILITY'],
				'TEXT_PUBLIC' => $TEXT['PUBLIC'],
				'TEXT_PRIVATE' => $TEXT['PRIVATE'],
				'TEXT_REGISTERED' => $TEXT['REGISTERED'],
				'TEXT_NONE' => $TEXT['NONE'],
				'TEXT_HIDDEN' => $TEXT['HIDDEN'],
				'TEXT_TEMPLATE' => $TEXT['TEMPLATE'],
				'TEXT_TARGET' => $TEXT['TARGET'],
				'TEXT_SYSTEM_DEFAULT' => $TEXT['SYSTEM_DEFAULT'],
				'TEXT_PLEASE_SELECT' => $TEXT['PLEASE_SELECT'],
				'TEXT_NEW_WINDOW' => $TEXT['NEW_WINDOW'],
				'TEXT_SAME_WINDOW' => $TEXT['SAME_WINDOW'],
				'TEXT_TOP_FRAME' => $TEXT['TOP_FRAME'],
				'TEXT_ADMINISTRATORS' => $TEXT['ADMINISTRATORS'],
				'TEXT_ALLOWED_VIEWERS' => $TEXT['ALLOWED_VIEWERS'],
				'TEXT_DESCRIPTION' => $TEXT['DESCRIPTION'],
				'TEXT_KEYWORDS' => $TEXT['KEYWORDS'],
				'TEXT_SEARCHING' => $TEXT['SEARCHING'],
				'TEXT_LANGUAGE' => $TEXT['LANGUAGE'],
				'TEXT_ENABLED' => $TEXT['ENABLED'],
				'TEXT_DISABLED' => $TEXT['DISABLED'],
				'TEXT_SAVE' => $TEXT['SAVE'],
				'TEXT_RESET' => $TEXT['RESET'],
				'LAST_MODIFIED' => $MESSAGE['PAGES']['LAST_MODIFIED'],
				'HEADING_MODIFY_PAGE' => $HEADING['MODIFY_PAGE']
			) );

$template->parse('main', 'main_block', false);
$template->pparse('output', 'page');

// Print admin footer
$admin->print_footer();

?>