<?PHP

// error_reporting(E_ALL);

// setcookie('test', 'test');

// PHP include path wg. PEAR
	if ($_SERVER['HTTP_HOST'] == '127.0.0.1' OR $_SERVER['HTTP_HOST'] == 'localhost')
	{
	
		ini_set('include_path', './;./PEAR/');
	
	} else {
	
		$std_path=ini_get('include_path');
		
		$pear_path = str_replace('index.php', '', $_SERVER['PATH_TRANSLATED']) . "PEAR";
		
		// $pear_path = "/home/www/PEAR";
		//$pear_path = "../PEAR/";
		
		$new_path = "$std_path:$pear_path";
		// $new_path = "/kunden/homepages/10/d37978595/htdocs/kcms/PEAR";
		ini_set('include_path', $new_path);
	
	}




include_once('./modules/timer_start.inc.php');


// This is the controller Page. Here all decissions are made as to which module is being called etc.
// All requests must be called through index.php


	

// get global settings
require_once('./global_settings.php');



// secure all GET, POST, Request Variables
include_once('./modules/input_security.inc.php');

$timer->setMarker('security_cleaned');




// Start session
require_once('HTTP/Session.php');
HTTP_Session::start();


// Set Session Expire
HTTP_Session::setExpire(date('U')+60*60*24);
	
// Set Session Idle
HTTP_Session::setIdle(date('U')+60*60*8);



// get default values if necessary
if (HTTP_Session::isNew() === true or !isset($_SESSION['rechte']))
	{
	require_once("./modules/default_values.inc.php");
	}


/*
if ($_SERVER['HTTP_HOST'] == '127.0.0.1' OR $_SERVER['HTTP_HOST'] == 'localhost')
	{
		$_SESSION['theme'] = 'theme2';
	}
*/
if (isset($_REQUEST['theme']))
	{
		$_SESSION['theme'] = $_REQUEST['theme'];
	}



// SITE SWITCH
if(!isset($_SESSION['site']))
	{
	
	$_SESSION['site'] = $available_sites['default'];
	
	}


if (isset($_REQUEST['switch_site']))
	{
	
	$_SESSION['site'] = $available_sites[$_REQUEST['switch_site']];
	
	}



if (isset($_REQUEST['sub_template']))
	{
	$_REQUEST['sub_template'] .= ".tpl";
	}





// Instantiate sql()
require_once("./modules/sql.inc.php");



if ($_SESSION['rechte'] >= 95)
	{
	// print_r($_SESSION);
	// print_r($_REQUEST);
	// print_r($_COOKIE);
	// print_r($_POST);
	// print_r($_ENV);
	// die;
	}
	
	
	
// Constant is defined for security purposes. To make sure that modules are not called directly
// check if constant is set
define ('CONTROL', 'control');











	



// include smarty
include_once('./classes/MySmarty.class.php');

// create Smarty object
$smarty = new MySmarty;



$timer->setMarker('Smarty init');






// set locale
if (!setlocale(LC_ALL, $_SESSION['locale']))
	{
	
	// Fix Locale setting if Windows Server
	include("./modules/win_locale.inc.php");
	setlocale(LC_ALL, win_locale($_SESSION['locale']));
	
	}






// Special Mains requested?
if (isset($_REQUEST['special_mains']))
	{
	
	switch ($_REQUEST['special_mains'])
		{
		
		case 'email_form':
		include ('./mains/special_mains/email_form.php');		
		break;
		
		case 'password':
		include ('./mains/special_mains/password.php');	
		break;
		
		
		
		
		}
	
	
	}




// make available sites avalable in smarty
if (count($available_sites) > 1)
	{
	$smarty->assign('available_sites', $available_sites);	
	}





// assign pic path
$smarty->assign('pic_path', "./themes/" . $_SESSION['theme'] . "/pics");	


// assign tpl include_path
$smarty->assign('tpl_path', "./" . $_SESSION['theme']);	





// Get all special contents
$sql = "select * from special_content";
$result = sql($sql);

// print_r($result);
foreach ($result['result_set'] as $key => $value)
	{
	
	$special_content[$value['special_content_id']]['content'] = stripslashes($value['content']);
	
	}

$smarty->assign('special_content', $special_content);	



// Get News if set to true
if (SHOW_NEWS == true)
	{
	
	
		$sql = "select news_id, headline, teaser, date_format(datum, '%d') as tag, date_format(datum, '%b') as monat from news 
				   where 
						(
						UNIX_TIMESTAMP(display_from) <= UNIX_TIMESTAMP(NOW()) 
						OR display_from is null
						)
				   and 
						(
						UNIX_TIMESTAMP(display_to) >= UNIX_TIMESTAMP(NOW())
						OR display_to is null
						)
				   and is_visible = 'yes'
				   and site = '" . $_SESSION['site']['dbvalue'] . "'
				   order by datum DESC"; 
		
		
		$news = sql($sql);
		// print_r($news);
	
		if (isset($news['result_set'][0]))
			{
			$smarty->assign('news', $news['result_set']);	
			}
		
		
		
		if (isset($_REQUEST['news_id']))
			{
			$sql = "select * from news 
					   where 
							(
							UNIX_TIMESTAMP(display_from) <= UNIX_TIMESTAMP(NOW()) 
							OR display_from is null
							)
					   and 
							(
							UNIX_TIMESTAMP(display_to) >= UNIX_TIMESTAMP(NOW())
							OR display_to is null
							)
					   and is_visible = 'yes'
					   and news_id = '" . $_REQUEST['news_id'] . "'"; 	
			
			
			
			$news_detail = sql($sql);
			// print_r($news);
		
			if (isset($news_detail['result_set'][0]))
				{
				$smarty->assign('news_detail', $news_detail['result_set']);	
				}
	
			
			}	   
	
		  
			   

	
	
	}

// Check HTTP_Session PEAR Paket
// require_once("./modules/session_handler.inc.php");


// Get SLIDER

if (SLIDER === true)
	{
	
	if (!isset($_SESSION['admin_slider_see_all_slides']))
		{
		$_SESSION['admin_slider_see_all_slides'] = 'no';	
		}

	if ($_SESSION['admin_slider_see_all_slides'] == 'yes')
		{
		$slider_active_sql = "";	
		} else {
		$slider_active_sql = "and active='yes'";	
		}

	$sql = "select * from slider 
			where 1=1
			$slider_active_sql
			order by slider_name, position";
			
	$slider = sql($sql);
	 
	// print_r($slider);


	if (isset($slider['result_set'][0]))
		{
		
		foreach ($slider['result_set'] as $key => $value)
			{
				
			$slider_by_name[$value['slider_name']][] = $value;
			
			}
		
		
		
		$smarty->assign('slider', $slider_by_name);	
		// print_r($slider_by_name);
		
		}



	}








// get CMS navi
include_once('./modules/cms_navi.inc.php');


if (isset($_REQUEST['navi']))
	{
	$navi = $_REQUEST['navi'];
	} else {
	$navi = false;
	}



$navi_structure = cms_navi($navi);



// Get main navi count => find out navi width if variable

$count_mains = count($navi_structure['main_navis']);

if ($count_mains == 1)
	{
	$navi_width = 0;
	} else {
	$navi_width = floor((900-148)/ ($count_mains-1));
	}
	
$smarty->assign('navi_width', $navi_width);	



// print_r($navi_structure);


if ($navi_structure == false)
	{
	die("Under contruction--");	
	}

$smarty->assign('navi_structure', $navi_structure);	

$timer->setMarker('got navi');



// Get HP specific stuff
if ($navi_structure['selected_navi']['is_homepage'] <> 'xyes')
	{
		
	// 5 Events for Sideboard
	$sql = "select 
			  e.event_id,
			  e.`event_name`,
			  e.event_teaser,
			  e.event_soldout,
			  DATE_FORMAT(MIN(ed.`ed_start`), '%d.%m.%Y') AS 'first_event',
			  UNIX_TIMESTAMP(MIN(ed.`ed_start`)) AS 'first_event_ts',
			  UNIX_TIMESTAMP(MAX(ed.`ed_end`)) AS 'last_event_ts'
			 
			FROM
			  event_core e 
			  LEFT JOIN event_dates ed 
				ON e.`event_id` = ed.`event_id` 
			
			WHERE
			
			e.event_visible = 'yes'
			
			GROUP BY e.`event_id` 	
			
			HAVING last_event_ts >= UNIX_TIMESTAMP(NOW()) 
			
			 
			
			ORDER BY first_event DESC 
			LIMIT 5 ";
	
	$sideboard_events = sql($sql);
	
	$smarty->assign('sideboard_events', $sideboard_events['result_set']);	
		
		
	// print_r($sideboard_events);	
	
	
	// Get one random review
	$sql = "select 
				  * 
				FROM
				  review 
				ORDER BY RAND()
				LIMIT 1";	
		
	$review_otm = sql($sql);
	
	$smarty->assign('review_otm', $review_otm['result_set'][0]);	
		
	}






// TEAM
if ($navi_structure['selected_navi']['sub_template'] == 'team.tpl')
	{
	
	
	if (isset($_REQUEST['ap_id']))
		{
		$ap_limit = "where ap_id = " . $_REQUEST['ap_id'];
		} else {
		$ap_limit = "";	
		}
	
	$sql = "select 
				  * 
				FROM
				  ap
				 $ap_limit  
				ORDER BY ap_name";	
		
	$ap = sql($sql);
	
	$smarty->assign('ap', $ap['result_set']);
	
		
	}





// Event
if ($navi_structure['selected_navi']['sub_template'] == 'event.tpl')
	{
	
	
	if (isset($_REQUEST['event_id']))
		{
		$event_limit = "and e.event_id = " . $_REQUEST['event_id'];
		} else {
		$event_limit = "";	
		}
	
	$sql = "select 
			  *,
			  DATE_FORMAT(MIN(ed.`ed_start`), '%d.%m.%Y') AS 'first_event',
			  UNIX_TIMESTAMP(MIN(ed.`ed_start`)) AS 'first_event_ts',
			  
			  DATE_FORMAT(MAX(ed.`ed_end`), '%d.%m.%Y') AS 'last_event',
			  UNIX_TIMESTAMP(MAX(ed.`ed_end`)) AS 'last_event_ts' 
			FROM
			  event_core e 
			  LEFT JOIN event_dates ed 
				ON e.`event_id` = ed.`event_id` 
			
			   LEFT JOIN event_series es
				ON es.`event_series_id` = e.`event_series_id`
			
			where
			e.event_visible = 'yes'
			
			GROUP BY e.`event_id` 	
			
			HAVING last_event_ts >= UNIX_TIMESTAMP(NOW()) 
			
			$event_limit
			
			ORDER BY e.`event_series_id`, first_event_ts
			
			
			
			
			";	
		
	$event = sql($sql);
	// print_r($event);
	
	$smarty->assign('event', $event['result_set']);
	
	
	
	// Get Dates
	if (isset($_REQUEST['event_id']))
		{
		$sql = "select 
				  *,
				  DATE_FORMAT(ed_start, '%d.%m.%Y') AS formated_start_date,
				  DATE_FORMAT(ed_end, '%d.%m.%Y') AS formated_end_date,
				  DATE_FORMAT(ed_start, '%H:%i') AS formated_start_time,
				  DATE_FORMAT(ed_end, '%H:%i') AS formated_end_time
				FROM
				  event_dates 
				WHERE event_id = $_REQUEST[event_id]
				order by ed_start";
		
		$event_dates = sql($sql);
		
		$smarty->assign('event_dates', $event_dates['result_set']);
		
		}
	
	
	// Get Team Memebers
	if (isset($_REQUEST['event_id']))
		{
		$sql = "select * 
				 from event_ap, ap
				  
				 where event_id = $_REQUEST[event_id]
				 and event_ap.ap_id = ap.ap_id
				 order by ap_name";
		
		$event_team = sql($sql);
		
		$smarty->assign('event_team', $event_team['result_set']);
		
		}
	
		
	}






// alle Gruppen
$sql = "select event_name from event_core where event_visible = 'yes'";
$gruppen = sql($sql);

$gruppen2['--'] = "--";
foreach ($gruppen['result_set'] as $key => $value)
	{
	
	
	$gruppen2[$value['event_name']] = $value['event_name'];
	
	}
		
$smarty->assign('gruppen', $gruppen2);
// print_r($gruppen);



// switch special module
if ($navi_structure['selected_navi']['special_mains'] !== "")
	{
	$cms = "./mains/" . $navi_structure['selected_navi']['special_mains'] . ".php";
	} else {
	$cms = "./mains/cms_home.php";
	}



// forward to module
if (@!include($cms))
		{		
		include("mains/cms_home.php");
		}




// Timer Footer
if ($_SESSION['rechte'] >= 95)
	{
	// include_once('./modules/timer_end.inc.php');
	}
?>