/*Fix by Delta Zakelijk:*/
include_once ("mysql2i.class.php");
include ("cms/config/app_properties.php");
$connect_main = mysql_connect($client_DBHOST, $client_DBUSER, $client_DBPASS);
$db_select = mysql_select_db($client_DBNAME, $connect_main) or die(mysql_error());
if (!$_REQUEST['page'] || $_REQUEST['page']=="") $page = "a";
else $page = $_REQUEST['page'];
if (!$_REQUEST['lang'] || $_REQUEST['lang']=="") {
$lang="nl";
$GetRubriekNaam = "rubriek_naam_nl";
$GetSubRubriekNaam = "subrubriek_naam_nl";
$GetContent = "content_nl";
}
else {
$lang = $_REQUEST['lang'];
$GetRubriekNaam = "rubriek_naam_".$lang;
$GetSubRubriekNaam = "subrubriek_naam_".$lang;
$GetContent = "content_".$lang;
}
$rubArray = array();
$subRubArray = array();
$explodePage = explode(".", $page);
$rubriekid = $explodePage[0];
// ---- Rubrieken ophalen ---
$get_nav_data = mysql_query("SELECT $GetRubriekNaam, rubriek_id FROM $client_rubriek ORDER BY rubriek_volgorde");
while($data = mysql_fetch_assoc($get_nav_data)) {
$rubArray[] = array('id' => $data['rubriek_id'], 'naam' => stripslashes($data[$GetRubriekNaam]));
if ($data['rubriek_id'] == $rubriekid) {
$PaginaTitel = stripslashes($data[$GetRubriekNaam]);
}
}
// ---- Subrubrieken ophalen ---
$subrub_qry = "SELECT $GetSubRubriekNaam, subrubriek_id FROM $client_subrubriek ORDER BY subrubriek_volgorde";
$get_pagina_data = mysql_query($subrub_qry);
while($data = mysql_fetch_array($get_pagina_data)) {
$subRubArray[] = array('id' => $data['subrubriek_id'], 'naam' => stripslashes($data[$GetSubRubriekNaam]));
if ($data['subrubriek_id'] == $page) {
$SubPaginaTitel = stripslashes($data[$GetSubRubriekNaam]);
}
}
$get_content_data = mysql_query("SELECT $GetContent FROM $client_content WHERE content_id='$page' ");
if (in_array($page, $ExtraModules) && key_exists($lang, $LanguageArray)) { //CustomModules krijgen een custom naam, zie app_properties
$PaginaTitel = $ExtraModulesNames[$lang][$page];
}
else {
$PaginaContent_array = mysql_fetch_array($get_content_data);
$PaginaContent = stripslashes($PaginaContent_array[0]);
// plaatjes in originele formaat in 'n popup
// Fix by delta zakelijk
$PaginaContent = preg_replace("src=\"", "class=\"img_content\" onclick=\"javascript: PopupPic(this.src)\" src=\"", $PaginaContent);
}
?>
print $client_naam;?>
while(list($nr,$data) = each($rubArray)) {
print "\n";
if ($data['id'] == substr($page,0,1) && !in_array($page, $ExtraModules)) {
reset($subRubArray);
while(list($nr, $data2) = each($subRubArray)) {
$subrub_id_array = explode('.', $data2['id']);
if ($subrub_id_array[0] == $data['id']) {
print "\n";
}
}
}
}
//speciale opties. bijvoorbeeld een formulier of gastenboek.
while (list(,$ModuleId) = each($ExtraModules)) {
$ModuleNaam = $ExtraModulesNames[$lang][$ModuleId];
print "\n";
}
?>
//titel
if (strlen($page) <= 1 || in_array($page, $ExtraModules)) {
print "$PaginaTitel";
}
else {
print "$PaginaTitel
$SubPaginaTitel";
}
?>
//content
if (in_array($page, $ExtraModules) && key_exists($lang, $LanguageArray)) {
include ($_REQUEST['page'].".php");
}
else {
print $PaginaContent;
}
?>
|