<?
error_reporting(0);
ini_set('display_errors', 0);
// initialiseren
require("include/init.inc.php");
$db = makeConnection();

// custom HTMLDocument voor Opera initialiseren
$page = new HTMLDocumentOpera();

// variabelen ophalen & destilleren
$type = strtolower(toStrDef($_REQUEST['type'], "home"));
$rewrite = strtolower(toStr($_REQUEST['rewrite']));
$id = 0;
switch ($type) {
	case 'home':
	case 'about':
	case 'cases':
	case 'clients':
	case 'contact':
		$rewrite = str_replace(array("/", ".html"), '', rewriteTitle($rewrite));

		$sqlContent = "SELECT contentID FROM " . ___tablePrefix . "content WHERE (contentHidden = '0')";
		if (getRecordSet($sqlContent, $rsContent, $db)) {
		   if (numRows($rsContent) > 0) {
		      for ($tmpContent=0; $tmpContent<numRows($rsContent); $tmpContent++) {
			      $intContentID = toInt(getResult($rsContent, $tmpContent, "contentID"));
			      $strContentMetaTitle = toStr(getData($intContentID, "contentMetaTitle"));
			      $strContentMenuTitel = toStr(getData($intContentID, "contentMenuTitel"));
			      $strContentTitel = rewriteTitle(toStrDef($strContentMetaTitle, $strContentMenuTitel));

			      // de herschreven URL analyseren en matchen met content
			      if ($rewrite == $strContentTitel) {
			      	$id = $intContentID;
			      }
			   }
		   }
		}

		$id = ($id == 0) ? toIntDef(getValue("SELECT contentID FROM " . ___tablePrefix . "content WHERE (contentInternNaam = '" . $type . "')", $db), 1) : $id;
		$n = array(0,0,0);
		$intContentNiveau = getValue("SELECT contentNiveau FROM " . ___tablePrefix . "content WHERE (contentID = '" . $id . "')", $db);
		for ($i=$intContentNiveau; $i>0; $i--) {
			if ($i == $intContentNiveau) {
				$n[$i] = $id;
				$intContentID = $id;
			} else {
				$n[$i] = getValue("SELECT contentParentID FROM " . ___tablePrefix . "content WHERE (contentID = '" . $intContentID . "')", $db);
				$intContentID = $n[$i];
			}
		}

		$meta = getMetaTags("content", $id, $db);
	break;
	case 'news':
		$rewrite = str_replace(array("/", ".html"), '', rewriteTitle($rewrite));
		$id = 3;
		$n = array(0,3,0);
		$meta = getMetaTags("nieuws", $id, $db);

		// bepaal de te tonen periode en evt. volgnummer van pagina
		$period = '';
		if (!empty($rewrite)) {
			$year = toInt(findFirstChars($rewrite, 4));
			$month = toInt(substr($rewrite, 4, 2));
			$n_page = toIntDef(substr($rewrite, 6), 1);
			if (!empty($year) && !empty($month)) {
				if (getValue("SELECT COUNT(*) FROM " . ___tablePrefix . "nieuws WHERE (nieuwsDatumVanaf LIKE '" . $year . "-" . sprintf("%02d", $month) . "%' AND nieuwsHidden = '0')", $db) > 0) {
					$period = $year . '-' . sprintf("%02d", $month);
				}
			}
		}
	break;
	case 'work':
		$rewrite = str_replace(".html", "", findAfter($rewrite, "/"));
		$id = 4;
		$n = array(0,4,0);
		$meta = getMetaTags("content", $id, $db);

		if (empty($rewrite)) {
			// work overzicht
			$w = array(0,0,0);
		} else {
			// fix voor een einde op / eindigt
			if (substr($rewrite, -1) == "/") {
				$rewrite = substr($rewrite, 0, (strlen($rewrite)-1));
			}

			// sla alle items uit de assortimentsmodule op, zodat je met rewriteTitle kunt matchen
			$arrAssortiment = array();
			$sqlAssortiment1 = "SELECT assID, assTitel FROM " . ___tablePrefix . "assortiment WHERE (assHidden = '0' AND assNiveau = '1' AND assType = '0') ORDER BY assID ASC";
			if (getRecordSet($sqlAssortiment1, $rsAssortiment1, $db)) {
				if (numRows($rsAssortiment1) > 0 ) {
					for ($tmpAssortiment1=0; $tmpAssortiment1<numRows($rsAssortiment1); $tmpAssortiment1++) {
						$intAssID1 = toInt(getResult($rsAssortiment1, $tmpAssortiment1, "assID"));
						$strAssTitel1 = toStr(getResult($rsAssortiment1, $tmpAssortiment1, "assTitel"));

						$arrAssortiment[$intAssID1 . '-0-0'] = rewriteTitle($strAssTitel1);

						$sqlAssortiment2 = "SELECT assID, assTitel FROM " . ___tablePrefix . "assortiment WHERE (assHidden = '0' AND assNiveau = '2' AND assPID = '" . $intAssID1 . "' AND assType = '0') ORDER BY assID ASC";
						if (getRecordSet($sqlAssortiment2, $rsAssortiment2, $db)) {
							if (numRows($rsAssortiment2) > 0 ) {
								for ($tmpAssortiment2=0; $tmpAssortiment2<numRows($rsAssortiment2); $tmpAssortiment2++) {
									$intAssID2 = toInt(getResult($rsAssortiment2, $tmpAssortiment2, "assID"));
									$strAssTitel2 = toStr(getResult($rsAssortiment2, $tmpAssortiment2, "assTitel"));

									$arrAssortiment[$intAssID1 . '-' . $intAssID2 . '-0'] = rewriteTitle($strAssTitel1) . '/' . rewriteTitle($strAssTitel2);

									$sqlAssortiment3 = "SELECT assID, assTitel FROM " . ___tablePrefix . "assortiment WHERE (assHidden = '0' AND assNiveau = '3' AND assPID = '" . $intAssID2 . "' AND assType = '1') ORDER BY assID ASC";
									if (getRecordSet($sqlAssortiment3, $rsAssortiment3, $db)) {
										if (numRows($rsAssortiment3) > 0 ) {
											for ($tmpAssortiment3=0; $tmpAssortiment3<numRows($rsAssortiment3); $tmpAssortiment3++) {
												$intAssID3 = toInt(getResult($rsAssortiment3, $tmpAssortiment3, "assID"));
												$strAssTitel3 = toStr(getResult($rsAssortiment3, $tmpAssortiment3, "assTitel"));

												$arrAssortiment[$intAssID1 . '-' . $intAssID2 . '-' . $intAssID3] = rewriteTitle($strAssTitel1) . '/' . rewriteTitle($strAssTitel2) . '/' . rewriteTitle($strAssTitel3);
											}
										}
									}
								}
							}
						}
					}
				}
			}

			$w = explode("-", toStr(array_search($rewrite, $arrAssortiment)));
		}
	break;
}

// custom HTMLDocument verder voor Opera initialiseren
$page->SetMeta("title", $meta['title']);
$page->SetMeta("description", $meta['description']);
$page->SetMeta("keywords", $meta['keywords']);
$page->SetMeta("author", $meta['author']);
$page->SetDocType("html-strict");
$page->IncludeCSS("include/styles.css");
$page->IncludeCSS("custom/" . $type . ".css");
$page->IncludeCSS("custom/custom.css");
$page->IncludePlugin("mybic");
//$page->IncludePlugin("sifr");
$page->IncludePlugin('cufon');
echo $page->Header(false);
?>
<!--[if lte IE 6]>
	<link rel="stylesheet" type="text/css" href="include/ie6_fixes.css">
<![endif]-->
<!--[if IE]>
	<link rel="stylesheet" type="text/css" href="include/ie_fixes.css">
<![endif]-->
<?
echo '</head>' . "\n";
echo '<body>' . "\n";
	echo '<div id="lijntje"><!----></div>' . "\n";
	echo '<div id="container">' . "\n";
		echo '<div id="main">';
			echo '<div id="logo"><a href="' . ___HTTP_PATH . '"><img src="images/opera_logo.gif" width="120" height="48" alt=""></a></div>' . "\n";
			echo '<ul id="nav">' . "\n";
				// menuitems worden in omgekeerde volgorde opgehaald omdat de LI's float="right" zijn
				$sqlContent1 = "SELECT contentID FROM " . ___tablePrefix . "content WHERE (contentNiveau = '1' AND contentHidden = '0') ORDER BY contentOrder DESC";
				if (getRecordSet($sqlContent1, $rsContent1, $db)) {
				   if (numRows($rsContent1) > 0) {
				      for ($tmpContent1=0; $tmpContent1<numRows($rsContent1); $tmpContent1++) {
					      $intContentID = toInt(getResult($rsContent1, $tmpContent1, "contentID"));
					      $strContentMenuTitel = strtoupper(toStr(getData($intContentID, "contentMenuTitel")));

							$li_style = ($n[1] == $intContentID) ? ' style="background-image: url(images/nav_arrow.gif);"' : '';
							$li_hover = ($n[1] != $intContentID) ? ' onmouseover="doNavOver(\'' . strtolower($strContentMenuTitel) . '\');" onmouseout="doNavOut(\'' . strtolower($strContentMenuTitel) . '\');"' : '';
							$img_style = ($n[1] == $intContentID) ? '_active' : '';

					      echo '<li' . $li_style . $li_hover . '><a href="' . rewriteURL('index.php?type=content&id=' . $intContentID, $db) . '"><img id="' . strtolower($strContentMenuTitel) . '" src="images/menu_' . strtolower($strContentMenuTitel) . $img_style . '.gif"></a></li>' . "\n";
					   }
				   }
				}
			echo '</ul>' . "\n";
			echo '<div class="free"><!----></div>' . "\n";
			echo '<div id="canvas">' . "\n";
				$canvas = file_get_contents("custom/" . $type . ".html");
				echo replaceTags($canvas);
				echo '<div class="free"><!----></div>' . "\n";
			echo '</div>' . "\n";
		echo '</div>';
	echo '</div>' . "\n";
	echo '<div id="copyright"><p>&copy; ' . date("Y") . ' OPERA Graphic Design | All rights reserved</p></div>' . "\n";

?>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-4787656-14");
pageTracker._trackPageview();
} catch(err) {}</script>
<?
echo $page->Footer();
closeConnection($db);
?>