<?
include('includes/application_top.php');

if (!ISSET($_REQUEST['page_id']))
{
	$page_id = 1;
	$page = "index.html";
}
else
{
	$page_id = $_REQUEST['page_id'];
	$page = "index1.html";
}

// Navigation
$result = mysql_query("SELECT * FROM pages");
while ($array = mysql_fetch_array($result))
{
	$class = "";
	if ($array['page_id'] == $page_id)
	{
		$class = 'class="activeLink"';
	}
	$navi[] = array('ID' => $array['page_id'],
									'PAGE_NAME' => utf8_encode($array['page_name']),
									'LINK_CLASS' => $class);
}
$smarty->assign('NAVIGATION',$navi);

// Seiten-Inhalte
$query = "SELECT * FROM pages WHERE page_id='" . $page_id . "' LIMIT 1";
$result = mysql_query($query) or die($query);
$array = mysql_fetch_array($result);

// Bilder auslesen
$bild = explode(',',$array['page_image']);
for ($i = 0; $i < count($bild); $i++) {
	$bilder[] = array('BILD' => trim($bild[$i]));
}

// Mittagstisch
$mittag = mysql_query("SELECT * FROM mittag");
$gerichte = mysql_fetch_array($mittag);
if ($gerichte['gericht'] != "") {
	$smarty->assign('MITTAG', utf8_encode($gerichte['gericht']));
}

// Aktuelles
$result = mysql_query("SELECT * FROM aktuell ORDER BY date_added DESC");
while ($aktuell = mysql_fetch_array($result)) {
	$tmpAkt = new aktuell($aktuell['id']);
	$akt[] = array('HEAD' => $tmpAkt->head, 
								'BODY' => $tmpAkt->body);
}

// Termine
$result = mysql_query("SELECT * FROM termine WHERE valid_to >= '" . date('Y-m-d H:s:i') . "' ORDER BY valid_to ASC");
while ($termine = mysql_fetch_array($result)) {
	$tmpTermin = new termin($termine['id']);
	$termin[] = array('HEAD' => $tmpTermin->head,
										'BODY' => $tmpTermin->body);
}

if (ISSET($akt)) { $smarty->assign('AKTUELLES', $akt); }
if (ISSET($termin)) { $smarty->assign('TERMINE', $termin); }
$smarty->assign('PAGE_HEADLINE',utf8_encode($array['page_headline']));
$smarty->assign('PAGE_BODY',utf8_encode($array['page_text']));
$smarty->assign('PAGE_IMAGE',$bilder);
$smarty->display($page);
?>