<? //function list
	

	// string afkorten naar gewenst aantal tekens en afronden met ...
	function trimSentence($str, $num, $nohtml=true) {
	    if ($nohtml) {
	        $length=strlen(strip_tags($str));
	    } else {
	        $length=strlen($str);
	    }
	
	    $newstr = ($length > $num)?substr($str,0,$num-3)."...":$str;
		return $newstr;
	}

	// afbeelding bewerken en opslaan
    // - 19/12/2007 (chmod 777 na aanmaken afbeelding)
    // - 17/01/2008 (er kan nu met $_POST['update'] = id van de afbeelding, worden aangegeven of het een update moet zijn)
    // - ToDo: BMP toevoegen
    function invoegenafbeelding($pad, $pad_t, $max_w, $max_wt, $max_h, $max_ht, $tabel, $fixed, $id, $sQuery = ''){
        
        $kwaliteit  = "100";                                      // kwaliteit waarmee de JPG bewaard wordt 
        $maxsize    = (1900*1024);                                // 1024(1 kb) * 1900 = 1900 kb 

    
        if($_SERVER['REQUEST_METHOD']=='POST'){ 
            if (isset($_FILES["afbeelding"]["name"]) && ($_FILES["afbeelding"]["name"]) !== " "){ 
                  $file  = $_FILES["afbeelding"]["name"];       // filename 
                  $image = $_FILES["afbeelding"]["tmp_name"];   // tmp name 
                   $type  = $_FILES["afbeelding"]["type"];       // .ext 
                   $size  = $_FILES["afbeelding"]["size"];       //bestands grootte in bytes 
                   //$name  = "$id"."_"."$tabel"."_";
                   
                $split = explode('.',$file);
                $file = $split[0];
                $name  = $file."_";
                
                   if($size < $maxsize){ 
                     
                       //afmetingen 
                       $imageXY  = getimagesize($image); 
                       $img_w  = $imageXY[0]; //width 
                       $img_h  = $imageXY[1]; //height                        
                       
                     if($fixed == 1){
                         
                         $newimg_w = $max_w;
                         $newimg_h = $max_h;
                         
                         $newimg_wt = $max_wt;
                         $newimg_ht = $max_ht;
                         
                     } else {

                           if($img_w > $img_h){
             
                               if($img_w > $max_w){ 
                                  $factor   = ($img_w / $max_w); 
                                   $newimg_w = $max_w;     
                                   $newimg_h = ($img_h / $factor); 
                               } 
                       
                               if($img_w > $max_wt){ 
                                   $factor    = ($img_w / $max_wt); 
                                   $newimg_wt = $max_wt;     
                                   $newimg_ht = ($img_h / $factor); 
                              }
                              
                           } else {
                               
                               if($img_h > $max_h){ 
                                  $factor   = ($img_h / $max_h); 
                                   $newimg_h = $max_h;     
                                   $newimg_w = ($img_w / $factor); 
                               } 
                       
                               if($img_h > $max_ht){ 
                                   $factor    = ($img_h / $max_ht); 
                                   $newimg_ht = $max_ht;     
                                   $newimg_wt = ($img_w / $factor); 
                              }                   
                               
                           }    
                         
                     } 
                       
                      $newImg_w  = (isset($newimg_w))  ? $newimg_w  : $img_w; 
                       $newImg_h  = (isset($newimg_h))  ? $newimg_h  : $img_h; 
                       $newImg_wt = (isset($newimg_wt)) ? $newimg_wt : $img_w; 
                       $newImg_ht = (isset($newimg_ht)) ? $newimg_ht : $img_h; 
                    
                       if($newImg_w > $max_w){ 
                          $factor   = ($newImg_w / $max_w); 
                           $newImg_w = $max_w;     
                           $newImg_h = ($newImg_h / $factor); 
                       }
                       
                       if($newImg_h > $max_h){ 
                          $factor   = ($newImg_h / $max_h); 
                           $newImg_h = $max_h;     
                           $newImg_w = ($newImg_w / $factor); 
                       }                       
                       
                       if($imageXY[2]==1 || $imageXY[2]==2 || $imageXY[2]==3 || $imageXY[2]==6){ 
                          //switch bestandstype 
                           $newImg   = imagecreatetruecolor($newImg_w, $newImg_h); 
                           $newThumb = imagecreatetruecolor($newImg_wt, $newImg_ht); 
                           switch($imageXY[2]){  //bestandstype 
                            case 1: //GIF
                                $imgSrc   = ImageCreateFromGIF($image);  
                                   $imgSrcXY = getimagesize($image); 
                                   $imgSrc_w = $imgSrcXY[0]; 
                                   $imgSrc_h = $imgSrcXY[1]; 
                                   
                                   //filename ophogen 
                                   $i = 0; 
                                   while (file_exists($pad.$name.$i.".gif")) { 
                                    $i = $i + 1; 
                                   } 
                                   $name = $name.$i.".gif";     
                               
                                   //copy + verwijder tmp img 
                                   imagecopyresampled($newImg, $imgSrc, 0, 0, 0, 0, $newImg_w, $newImg_h, $imgSrc_w, $imgSrc_h); 
                                   imagecopyresampled($newThumb, $imgSrc, 0, 0, 0, 0, $newImg_wt, $newImg_ht, $imgSrc_w, $imgSrc_h); 
                                   imagegif($newImg, $pad.$name, $kwaliteit); 
                                   imagegif($newThumb, $pad_t.$name, $kwaliteit); 
                                   $bestandBig     = $pad.$name;
                                   $bestandSmall     = $pad_t.$name;
                                   chmod($bestandBig, 0777); 
                                   chmod($bestandSmall, 0777);
                                   imagedestroy($newImg);     
                                   imagedestroy($newThumb);     
                                   break; 
                                
                               case 2: //jpg               
                                   $imgSrc   = ImageCreateFromJPEG($image);  
                                   $imgSrcXY = getimagesize($image); 
                                   $imgSrc_w = $imgSrcXY[0]; 
                                   $imgSrc_h = $imgSrcXY[1]; 
                                   
                                   //filename ophogen 
                                   $i = 0; 
                                   while (file_exists($pad.$name.$i.".jpg")) { 
                                    $i = $i + 1; 
                                   } 
                                   $name = $name.$i.".jpg";     
                               
                                   //copy + verwijder tmp img 
                                   imagecopyresampled($newImg, $imgSrc, 0, 0, 0, 0, $newImg_w, $newImg_h, $imgSrc_w, $imgSrc_h); 
                                   imagecopyresampled($newThumb, $imgSrc, 0, 0, 0, 0, $newImg_wt, $newImg_ht, $imgSrc_w, $imgSrc_h); 
                                   imagejpeg($newImg, $pad.$name, $kwaliteit); 
                                   imagejpeg($newThumb, $pad_t.$name, $kwaliteit); 
                                   $bestandBig     = $pad.$name;
                                   $bestandSmall     = $pad_t.$name;
                                   chmod($bestandBig, 0777); 
                                   chmod($bestandSmall, 0777);
                                   imagedestroy($newImg);     
                                   imagedestroy($newThumb);     
                                   break; 
                                
                            case 3: //png
                                $imgSrc   = ImageCreateFromPNG($image);  
                                   $imgSrcXY = getimagesize($image); 
                                   $imgSrc_w = $imgSrcXY[0]; 
                                   $imgSrc_h = $imgSrcXY[1]; 

                                   //filename ophogen 
                                   $i = 0; 
                                   while (file_exists($pad.$name.$i.".png")) { 
                                    $i = $i + 1; 
                                   } 
                                   $name = $name.$i.".png";     
                                
                                   //copy + verwijder tmp img 
                                   imagecopyresampled($newImg, $imgSrc, 0, 0, 0, 0, $newImg_w, $newImg_h, $imgSrc_w, $imgSrc_h); 
                                   imagecopyresampled($newThumb, $imgSrc, 0, 0, 0, 0, $newImg_wt, $newImg_ht, $imgSrc_w, $imgSrc_h); 
                                   imagepng($newImg, $pad.$name); 
                                   imagepng($newThumb, $pad_t.$name); 
                                   $bestandBig     = $pad.$name;
                                   $bestandSmall     = $pad_t.$name;
                                   chmod($bestandBig, 0777); 
                                   chmod($bestandSmall, 0777);
                                   imagedestroy($newImg);     
                                   imagedestroy($newThumb);     
                                   break; 
                         }//switch 
                           
                         if(isset($_POST['update']) && !empty($_POST['update'])){
                             $pica_id = $_POST['update'];
                             deletePic($tabel, $_POST['update'], $pad);
                         } else {
                             $pica_id = "";
                         }
                         
                         if(file_exists($pad.$name)){ 
                               $msg = "imageinsert";
                            //mysql_query(" INSERT INTO $tabel (id, naam, onderdeelid) VALUES ('$pica_id', '$name', '$id') ") or die ("insert image: ".mysql_error());  
                            mysql_query(" INSERT INTO $tabel SET id = '$pica_id', naam = '$name', onderdeelid = '$id' $sQuery ") or die ("insert image: ".mysql_error());  
                           } 
                    } else {
                       print_r($imageXY);
                       $msg = "errortype"; 
                    }  
                } else {     
                 $msg = "errorsize";     
                } 
            } 
        }  
        return $msg;
    }

	// verwijderd verboden tekens uit een string
	function stripStr($str) {
		$newstr ="";
		$chr = array(" ", "!", "@", "#", "\$", "%", "^", "&", "*", "(", ")", "+", "=", "[", "{", "}", "]", ":", ";", "\"", "'", "<", ",", ">", ".", "?", "/");
		for($i=0; $i<strlen($str) ;$i++) {
			if(!in_array($str[$i],$chr)) $newstr = $newstr.$str[$i];
		}
	
		return $newstr;
	}
	
	// verwijderd verboden tekens uit een string
	function stripMail($str) {
		$newstr ="";
		$chr = array(" ", "!", "#", "\$", "%", "^", "&", "*", "(", ")", "+", "=", "[", "{", "}", "]", ":", ";", "\"", "'", "<", ",", ">", "?", "/");
		for($i=0; $i<strlen($str) ;$i++) {
			if(!in_array($str[$i],$chr)) $newstr = $newstr.$str[$i];
		}
	
		return $newstr;
	}	

	// mild
	function stripStrmild($str) {
		$newstr ="";
		$chr = array("\"", "'");
		for($i=0; $i<strlen($str) ;$i++) {
			if(!in_array($str[$i],$chr)) $newstr = $newstr.$str[$i];
		}
	
		return $newstr;
	}	
	
	// zet een timestamp om naar een leesbare datum
	// zet een timestamp om naar een leesbare datum
	function dutchtime($timestamp, $iSubstr = 0){
		if($timestamp > 0){
			$datum		= stripStr($timestamp);
			$jaar 		= substr("$datum",0,4);
			$maand 		= substr("$datum",4,2);
			$dag 		= substr("$datum",6,2);
			$uur 		= substr("$datum",8,2);
			$min 		= substr("$datum",10,2);
			$newstr		= "$dag/$maand/$jaar $uur:$min";
		} else {
			$newstr = "";
		}
		
		if($iSubstr > 0){
			$newstr = substr($newstr,0,$iSubstr);
		}
		
		return $newstr;			
	}
    
    // zet een leesbare datum om naar een timestamp
    function computertime($sDatetime){
        $aSearch = array('-',' ','/',':');
        $aRepleace = array('','','','');
        $sDatetime = str_replace($aSearch, $aRepleace, $sDatetime)."00000000000000";
        if($sDatetime > 0){
            $datum        = stripStr($sDatetime);
            $jaar         = substr("$datum",4,4);
            $maand         = substr("$datum",2,2);
            $dag         = substr("$datum",0,2);
            $uur         = substr("$datum",8,2);
            $min         = substr("$datum",10,2);
            $sec        = substr("$datum",12,2);
            $newstr        = $jaar.$maand.$dag.$uur.$min.$sec;
        } else {
            $newstr = 0;
        }
        return $newstr;            
    }

	// vervangt special tekens naar ISO codes
	function replaceSpecialchars($str){
		$str = str_replace("'","&#39;", $str);
		$str = str_replace("é","&#233;", $str);
		$str = str_replace("ë","&#235;", $str);
		$str = str_replace("è","&#232;", $str);
		$str = str_replace("ö","&#246;", $str);
		$str = str_replace("ä","&#228;", $str);
		$str = str_replace("ä","&#228;", $str);
		$str = str_replace("ä","&#228;", $str);

		return $str;
	}	
	
	// vervangt iso tekens naar gewone leestekens
	function replaceIsocode($str){
		$str = str_replace("&#39;","'", $str);
		//$str = str_replace("&#34;","\"", $str);
		$str = str_replace("&#233;","é", $str);
		$str = str_replace("&#235;","ë", $str);
		$str = str_replace("&#232;","è", $str);
		$str = str_replace("&#246;","ö", $str);
		$str = str_replace("&#228;","ä", $str);
		$str = str_replace("&#228;","ä", $str);
		$str = str_replace("ä","&#228;", $str);
		$str = str_replace("&#37;","%", $str);
		$str = str_replace("&#36;","$", $str);

		return $str;
	}

	// vlug een waarde uit de database trekken
	function getSingleValue($table, $kolom, $id, $kolomId = ''){
		if($kolomId == ''){ $sKolomId = 'id'; } else { $sKolomId = addslashes($kolomId); }
		$getValue = mysql_query(" SELECT $kolom FROM $table WHERE $sKolomId = '$id' LIMIT 1 ") or die ($msg = mysql_error());
		if(isset($msg)){
			return $msg;
		} else {
			$value = mysql_fetch_array($getValue);
			return $value[$kolom];
		}
	}
	
	//BANNERS MODULE: banners ophalen en parsen
	function showBanners ($pageid, $pos){
		$now 				= date("YmdHis");	// huidige datum:tijd
		$positie_layout 	= $pos; 				// onder
		$bannerblock		= "";				// container voor de banners
		$getAandacht 		= mysql_query(" SELECT b.* FROM banners b, banners_menu m WHERE m.menu = '$pageid' AND m.banner = b.id AND (b.datum_vanaf = '0' OR b.datum_vanaf < '$now') AND (b.datum_tot = '0' OR b.datum_tot > '$now') AND (b.views_max = 0 OR b.views_max > b.views) AND b.positie_layout = '$positie_layout' AND b.status = '1' ORDER BY b.positie ASC ") or die ("get banners ".mysql_error());
		while($aandacht 	= mysql_fetch_array($getAandacht)){
			
			// view met 1 verhogen
			mysql_query("UPDATE banners SET views = views+1 WHERE id =  $aandacht[id] LIMIT 1 ") or die ("hit aandacht ".mysql_error());
			
			if(!empty($aandacht['code'])){
				$bannerblock .= "$aandacht[code]";
			} else {
				switch($aandacht['type']){
					
					case "1":	// JPG	
						$content	= "";
						$img		= "<img src=\"upload/banners/$aandacht[bestandsnaam]\" alt=\"$aandacht[omschrijving]\" width=\"$aandacht[afmeting_breed]\" height=\"$aandacht[afmeting_hoog]\" border=\"0\">";
						if(!empty($aandacht['link'])){
							if(!empty($aandacht['target'])){ $target = "target=\"$aandacht[target]\""; } else {$target = "";}
							$startlink = "<a href=\"$aandacht[link]\" $target>";
							$endlink = "</a>";
							$content = "$startlink"."$img"."$endlink";
						} else { 
							$content = $img;
						}
						$bannerblock .= "<div style=\"width:$aandacht[afmeting_breed]px; height:$aandacht[afmeting_hoog]px; float:left; margin-top:$aandacht[marge_boven]px; margin-right:$aandacht[marge_rechts]px; margin-bottom:$aandacht[marge_onder]px; margin-left:$aandacht[marge_links]px;\">$content</div>";
						
					break;
					
					case "2":	// GIF	
						$content	= "";
						$img		= "<img src=\"upload/banners/$aandacht[bestandsnaam]\" alt=\"$aandacht[omschrijving]\" width=\"$aandacht[afmeting_breed]\" height=\"$aandacht[afmeting_hoog]\" border=\"0\">";
						if(!empty($aandacht['link'])){
							if(!empty($aandacht['target'])){ $target = "target=\"$aandacht[target]\""; } else {$target = "";}
							$startlink = "<a href=\"$aandacht[link]\" $target>";
							$endlink = "</a>";
							$content = $startlink.$img.$endlink;
						} else { 
							$content = $img;
						}
						$bannerblock .= "<div style=\"width:$aandacht[afmeting_breed]px; height:$aandacht[afmeting_hoog]px; float:left; margin-top:$aandacht[marge_boven]px; margin-right:$aandacht[marge_rechts]px; margin-bottom:$aandacht[marge_onder]px; margin-left:$aandacht[marge_links]px;\">$content</div>";		
					break;
		
					case "3":	// PNG
						$content	= "";
						$img		= "<img src=\"upload/banners/$aandacht[bestandsnaam]\" alt=\"$aandacht[omschrijving]\" width=\"$aandacht[afmeting_breed]\" height=\"$aandacht[afmeting_hoog]\" border=\"0\">";
						if(!empty($aandacht['link'])){
							if(!empty($aandacht['target'])){ $target = "target=\"$aandacht[target]\""; } else {$target = "";}
							$startlink = "<a href=\"$aandacht[link]\" $target>";
							$endlink = "</a>";
							$content = $startlink.$img.$endlink;
						} else { 
							$content = $img;
						}
						$bannerblock .= "<div style=\"width:$aandacht[afmeting_breed]px; height:$aandacht[afmeting_hoog]px; float:left; margin-top:$aandacht[marge_boven]px; margin-right:$aandacht[marge_rechts]px; margin-bottom:$aandacht[marge_onder]px; margin-left:$aandacht[marge_links]px;\">$content</div>";		
					break;
					
					case "4":	// FLASH	
						$content	= "";
						$swf		= "$aandacht[code_swf]";
						if(!empty($aandacht['link'])){
							if(!empty($aandacht['target'])){ $target = "target=\"$aandacht[target]\""; } else {$target = "";}
							$startlink = "<a href=\"$aandacht[link]\" $target >";
							$endlink = "</a>";
							$content = $startlink.$swf.$endlink;
						} else { 
							$content = $swf;
						}
						$bannerblock .= "<div style=\"width:$aandacht[afmeting_breed]px; height:$aandacht[afmeting_hoog]px; float:left; margin-top:$aandacht[marge_boven]px; margin-right:$aandacht[marge_rechts]px; margin-bottom:$aandacht[marge_onder]px; margin-left:$aandacht[marge_links]px;\">$content</div>";		
		
					break;							
				}
			}	
		}
		
		return $bannerblock;		
	}
	
	function afronden($str){
		$newstr = number_format("$str", 2, ',','.');
		return $newstr;
	}

	// check of een tabel bestaat
	function tableExists ($table, $db = '') {
		if($db == ''){ $db = $dbname; }
		$sSqlTables = "SHOW TABLES FROM ". $db; 
		$oSqlTables = mysql_query($sSqlTables) or die ($sSqlTables.'<hr />'.mysql_error());
		//$tables = mysql_list_tables ($db); deprecated 04/01/2010 JD
		while (list ($temp) = mysql_fetch_array($oSqlTables)) {
			if ($temp == $table) {
				return TRUE;
			}
		}
		return FALSE;
	}

	// print_r maar dan netjes op het scherm..
	function printr($aInput = array())
	{
		echo '<div style="background-color:#FFFFFF; padding:25px;"><pre>';
		print_r($aInput);
		echo '</pre></div>';
	}
	
	// check email
	function isEmail($mailadres)
	{
		$regxMail = '^[a-zA-Z0-9._-]+@[a-zA-Z0-9-]+\.[a-zA-Z.]{2,5}$^';
		if(preg_match($regxMail, $mailadres))
		{
			return true;
		}
		else 
		{
			return false;
		}
	}
	
	// als er een foutmelding is.. in een sessie zetten..
	function setmsg($sMsg = '')
	{
		if ($sMsg != '')
		{
			$_SESSION['msg'][] = $sMsg;
		}
	}
	
	// als er een melding in de sessie staat, tonen en legen
	function showMsg($bReturn = false)
	{
		if(isset($_SESSION['msg'])) {
			$msg = '<div id="msg"><h2>Feedback</h2><br /><ul>';
			foreach($_SESSION['msg'] AS $error){ $msg .="<li>".$error."</li>"; }
			$msg .= "</lu></div>";
			
			unset($_SESSION['msg']);
			if($bReturn){
				return $msg; 
			} else {
				echo $msg;
			}
		}
	}

	// controleren of een module is geinstaleerd
	function checkModuleInstalled($module = ''){
		if($module != '')
		{	
			$getModule = mysql_query(" SELECT id FROM configuratie_modules_beschikbaar WHERE modules = '$module' AND status = '1' LIMIT 1 ") or die ($msg = mysql_error());
			if(mysql_num_rows($getModule) > 0)
			{
				return  true;
			}
			else 
			{
				return false;
			}
		}
		else 
		{
			return false;
		}
	}

	// chache wegschrijven
	function writeCache($sUrl, $sContent, $iCacheLimit)
	{
		$iDatum_nu = mktime();
		$iDatum_chache = mktime(date('H'),date('i')-$iCacheLimit,date('s'),date('m'),date('d'),date('Y'));
		
		// alles wat ouder is dan opgegeven chachetijd verwijderen
		mysql_query(" DELETE FROM menu_cache WHERE datum < '$iDatum_chache' ") or die ("oudere cache legen ".mysql_error());
		
		// inhoud naar cache wegschrijven
		mysql_query("  INSERT INTO menu_cache(
		id,url,datum,html
		) VALUES (
		'','$sUrl','$iDatum_nu','$sContent'
		) ") or die ("insert into menu_cache".mysql_error());		
	}
	
	function isCached($sUrl, $iCacheLimit)
	{
		$iDatum_chache = mktime(date('H'),date('i')-$iCacheLimit,date('s'),date('m'),date('d'),date('Y'));
		$oGetCache = mysql_query(" SELECT id FROM menu_cache WHERE url = '$sUrl' AND datum > '$iDatum_chache' ") or die ("get chache ".mysl_error());
		if(mysql_num_rows($oGetCache) > 0)
		{
			return true;
		} 
		else 
		{
			return false;
		}
	}
	
	function getCached($sUrl, $iCacheLimit)
	{
		$iDatum_chache = mktime(date('H'),date('i')-$iCacheLimit,date('s'),date('m'),date('d'),date('Y'));
		$oGetCache = mysql_query(" SELECT html FROM menu_cache WHERE url = '$sUrl' AND datum > '$iDatum_chache' ") or die ("get chache ".mysl_error());
		if(mysql_num_rows($oGetCache) > 0)
		{
			$aCache = mysql_fetch_assoc($oGetCache);
			$sHtml = $aCache['html'];
			return $sHtml;
		} 
		else 
		{
			return 'empty cache';
		}
	}

	// inhoud van een include in een var terug geven.
	function get_include_contents($filename){
	    if (is_file($filename)) {
	        ob_start();
	        include $filename;
	        $contents = ob_get_contents();
	        ob_end_clean();
	        return $contents;
	    }
	    return false;
	}	
	
	// tellen of een menuitem subitems heeft
	function countChildren($iParent, $aParents = array()){
			
		if(sizeOf($aParents) > 0)
		{
			$sSqlCount 		= " SELECT COUNT(*) AS kinderen FROM menu WHERE isSubVan = '". $iParent ."' AND id IN (". implode(', ',$aParents) .")";
		} else {
			$sSqlCount 		= " SELECT COUNT(*) AS kinderen FROM menu WHERE isSubVan = '". $iParent ."'";
		}	
		$oSqlCount 		= mysql_query($sSqlCount) or die ("$sSqlCount<hr />".mysql_error());
		$aSqlCount 		= mysql_fetch_assoc($oSqlCount);
		$iAantal		= intval($aSqlCount['kinderen']);
		return $iAantal;
	}

	// aantal submenu van een opgegeven menuitem opvragen
	function urlFriendly($sStr)
	{
		$sNewstr = strtolower(stripStr(str_replace(" ","-",$sStr)));
		return $sNewstr;
	}
	
	// aantal kinderen van een opgegeven tabel opvragen
	function countKids($iParent, $sTable, $sKolom = 'parent_id')
	{
		$sSqlCount 		= " SELECT COUNT(*) AS kids FROM ". $sTable ." WHERE ". $sKolom ." = '". $iParent ."' ";
		$oSqlCount 		= mysql_query($sSqlCount) or die ("$sSqlCount<hr />".mysql_error());
		$aSqlCount 		= mysql_fetch_assoc($oSqlCount);
		$iAantal		= intval($aSqlCount['kids']);
		
		return $iAantal;
	}		
	
	function getSubs($sUrl, $iParent = 0, $aActiveIds = array(), $iLevel = 0, $iTeller = 0, $iComplete = 0, $iTaal = 1 , $iInt = 0, $sPrefix = ''){
		$iTeller++;
		$iCounter = 0;
		$sStr = '';
		$sSqlNodes = " SELECT * FROM menu WHERE isSubVan = '".$iParent."' AND actief = '1' AND ((datum_start = 0 OR datum_start < '".date("YmdHis")."') AND (datum_eind = 0 OR datum_eind > '".date("YmdHis")."')) AND taal = '".$iTaal."' ORDER BY positie ASC  ";
		$oSqlNodes = mysql_query($sSqlNodes) or die ($sSqlNodes."<hr />".mysql_error());
		$iCountNodes 	= mysql_num_rows($oSqlNodes);
		$class = '';
		
		$sStr .= '<ul>'."\n";
		$classTeller = 1;
			
		$sTarget = '';
	
		while($aNodes = mysql_fetch_assoc($oSqlNodes)){
			$iCounter++;

			$sTarget = '';

			// de base url voor de producten opstellen, die wordt per sub immers langer ;-)
			if(!empty($aNodes['url'])) {
		
				if(strpos($aNodes['url'],'|') > 0) {
					$aUrlTarget = explode('|',$aNodes['url']);
					$sNewUrl 	= $aUrlTarget[0];
					$sTarget 	= ' target="_'.end($aUrlTarget).'"';
				} else {
					$sNewUrl 	= $aNodes['url'];
					$sTarget 	= '';
				}

			} elseif($aNodes['link_to_first_child'] == 1) {
				$sSqlFirstChild = " SELECT naam_paginaurl FROM menu WHERE isSubVan = '".$aNodes['id']."' AND actief = '1' ORDER BY positie ASC LIMIT 1 ";
				$sGetFirstChild = mysql_query($sSqlFirstChild) or die ($sSqlFirstChild."<hr />".mysql_error());
				if(mysql_num_rows($sGetFirstChild) > 0){
					$aFirstChild = mysql_fetch_assoc($sGetFirstChild);
					$sNewUrl = $sUrl.$aNodes['naam_paginaurl'].'/'.$aFirstChild['naam_paginaurl'].'/';
				} else {
					$sNewUrl = $sUrl.$aNodes['naam_paginaurl'].'/';
				}
			} else {	
				//$sNewUrl = $sUrl.$aNodes['naam_paginaurl'].'/';
				if($iParent == 0 && $iCounter == 1){
					$sNewUrl = $sUrl;
				} else {
					$sNewUrl = $sUrl.$aNodes['naam_paginaurl'].'/';
				}
			}
				
				
			// actieve items van een class voorzien
			if($iParent == 0 && $iCounter == 1 && sizeOf($GLOBALS['sUrl']) == 0) {
				$sClass = ' class="current"';
			} elseif(in_array($aNodes['id'], $aActiveIds) && $iInt != 0) {
				$sClass = ' class="current"';
			} else {
				$sClass = '';
			}

			// relattribuut vaststellen
			if(!empty($aNodes['rel'])){
				$sRel = ' rel="'.$aNodes['rel'].'"';
			} else {
				$sRel = '';
			}

			$sStr .= '<li '.$class.'><a href="'.$sNewUrl.'"'.$sClass.' '.$sRel.' '.$sTarget.'>'.$sPrefix.$aNodes['naam_menu'].'</a>';
			
			// even terug zetten voor de subitems, anders taat de subcat er twee keer in
			$sNewUrl = $sUrl.$aNodes['naam_paginaurl'].'/';
			// als er kinderen zijn de 
			if(($iLevel > 1 || $iLevel == 0) && ($iTeller < $iLevel || $iLevel == 0) && ($iComplete == 1 || in_array($aNodes['id'], $aActiveIds))) {
				if(countKids($aNodes['id'], 'menu', 'isSubVan') > 0 && ($iComplete == 1 || in_array($aNodes['id'], $aActiveIds))){
						$iInt++;
						$sStr .= getSubs($sNewUrl, $aNodes['id'], $aActiveIds, $iLevel , $iTeller, $iComplete, $iTaal,  $iInt);
						$iInt--;
				}
			}
			
			$sStr .= '</li>'."\n\t";
			$classTeller++;
		}
		$sStr .= '</ul>'."\n";

		return $sStr;		
	}
	
	function newsletterView($iLetter, $sUserCode){

		$id 			= '';
		$nieuwsbrief_id = intval($iLetter);
		$user_code		= mysql_real_escape_string($sUserCode);
		$user_id 		= getSingleValue('nieuwsbrief_leden','id',$user_code,'code');
		$ip 			= mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
		$datum 			= date('YmdHis');

		
		$sSql = " SELECT * FROM nieuwsbrief_stats_views WHERE nieuwsbrief_id = '".$nieuwsbrief_id."' AND user_id = '". $user_id ."' LIMIT 1 "; 
		$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error()); 
		if(mysql_num_rows($oSql) < 1){		
		
			$sSql = " INSERT INTO nieuwsbrief_stats_views (id,nieuwsbrief_id,user_id,user_code,ip,datum,hits,datum_laatstehit,dag,tijd) VALUES ('". $id ."','". $nieuwsbrief_id ."','". $user_id ."','". $user_code ."','". $ip ."','". $datum ."','1','". $datum ."','". date('d') ."','". date('Hi')."') "; 
			$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error());	

			$sSql = " UPDATE nieuwsbrief_stats_samenvatting SET aantal_geopend = aantal_geopend+1, aantal_bekeken = aantal_bekeken+1 WHERE nieuwsbrief_id = '".$nieuwsbrief_id."' LIMIT 1 "; 
			$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error()); 
		} else {
			$aClickstat = mysql_fetch_assoc($oSql);
			$sSql = " UPDATE nieuwsbrief_stats_views SET ip = '".$ip."', hits = hits+1, datum_laatstehit = '".$datum."' WHERE id = '". $aClickstat['id'] ."' LIMIT 1 "; 
			$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error());
			
			$sSql = " UPDATE nieuwsbrief_stats_samenvatting SET aantal_bekeken = aantal_bekeken+1 WHERE nieuwsbrief_id = '".$nieuwsbrief_id."' LIMIT 1 "; 
			$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error()); 			
		}	 
				
	}
	
	function newsletterClick($iLetter, $sUserCode, $sRequest_href){
		
		$id 			= '';
		$nieuwsbrief_id = intval($iLetter);
		$user_code		= mysql_real_escape_string($sUserCode);
		$user_id 		= getSingleValue('nieuwsbrief_leden','id',$user_code,'code');
		$ip 			= mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
		$datum 			= date('YmdHis');
		$stripFromUrl	= '&track=newsletter&letter='.$nieuwsbrief_id.'&user='.$user_code;
		$url 			= mysql_real_escape_string(str_replace($stripFromUrl,'',$sRequest_href));
		
		
		// ClickTracks
		$sSql = " SELECT id FROM nieuwsbrief_stats_clicks WHERE nieuwsbrief_id = '".$nieuwsbrief_id."' AND url = '".$url."' AND user_id = '".$user_id."' LIMIT 1 "; 
		$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error());
		if(mysql_num_rows($oSql) < 1){		
		
			// add
			$sSql = " INSERT INTO nieuwsbrief_stats_clicks (id,nieuwsbrief_id,user_id,user_code,ip,clicks,datum,datum_laatstehit,url) VALUES ('". $id ."','". $nieuwsbrief_id ."','". $user_id ."','". $user_code ."','". $ip ."','1','". $datum ."','". $datum ."','". $url."') "; 
			$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error());
			
			$sSql = " UPDATE nieuwsbrief_stats_samenvatting SET aantal_clicks = aantal_clicks+1, aantal_clicks_uniek = aantal_clicks_uniek+1 WHERE nieuwsbrief_id = '".$nieuwsbrief_id."' LIMIT 1 "; 
			$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error()); 			
			
		} else {
			
			// update
			$aNewsletter = mysql_fetch_assoc($oSql);
			$sSql = " UPDATE nieuwsbrief_stats_clicks SET clicks = clicks+1, datum_laatstehit = '".$datum."' WHERE id = '". $aNewsletter['id'] ."' LIMIT 1 "; 
			$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error()); 	
			
			$sSql = " UPDATE nieuwsbrief_stats_samenvatting SET aantal_clicks = aantal_clicks+1 WHERE nieuwsbrief_id = '".$nieuwsbrief_id."' LIMIT 1 "; 
			$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error()); 				
		}
		
		// ClickStats
		$sSql = " SELECT id FROM nieuwsbrief_stats_links WHERE url = '".$url."' LIMIT 1 "; 
		$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error());
		if(mysql_num_rows($oSql) < 1){
			
			$sSql = " INSERT INTO nieuwsbrief_stats_links (id,nieuwsbrief_id,url,aantal_clicks) VALUES ('". $id ."','". $nieuwsbrief_id ."','". $url ."','1') "; 
			$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error());
			
		} else {

			$sSql = " UPDATE nieuwsbrief_stats_links SET aantal_clicks = aantal_clicks+1 WHERE url = '". $url ."' LIMIT 1 "; 
			$oSql = mysql_query($sSql) or die ($sSql."<hr />".mysql_error()); 			
		}
		
	}

	 function crawlUp($iId = 0, $sTabel = '', $sParentKolom = 'parent_id', $sGetKolom = 'id', $sStr = '', $iInt = 0){
 
	  $sSqlRecord = " SELECT * FROM ". $sTabel ." WHERE id = '". $iId ."' LIMIT 1 ";
	  $SGetRecord = mysql_query($sSqlRecord) or die ($sSqlRecord.'<hr />'.mysql_error());
	  $aRecord = mysql_fetch_assoc($SGetRecord);
	  
	  $sStr = $aRecord[$sGetKolom].'/'.$sStr;

	  if($aRecord[$sParentKolom] > 0){
	   $iInt ++;
	   $sStr = crawlUp($aRecord[$sParentKolom], $sTabel, $sParentKolom, $sGetKolom, '', $iInt).$sStr;
	   $iInt --;
	  }
	  return $sStr;
	 }
	 
	 // je gegevens direct in een array terug krijgen
	function getArray($sSql = '') {
		$aReturn = array();
		if(!empty($sSql)) {
			$ExcuteQuery = mysql_query($sSql) or die ($aReturn['feedback'] = mysql_error());
			$i = 0;
			$iCount = mysql_num_rows($ExcuteQuery);
			if($iCount > 0) {
				$aReturn['count'] = $iCount;
				while($aRecord = mysql_fetch_assoc($ExcuteQuery)) {
					$i++;
					$aReturn['data'][$aRecord['id']] = $aRecord;
					if($i == 1){
						$aReturn['first'] = $aRecord;
					}
				}
			} else {
				$aReturn['count'] = 0;
				$aReturn['feedback'] = 'Er zijn geen resultaten.';
			}
		} else {
			$aReturn['count'] = 0;
			$aReturn['feedback'] = 'De query string is leeg.';
		}
		
		return $aReturn;
	}
    
    //Email veilig maken tegen bots
    function hide_email($email) { 
        $character_set = '+-.0123456789@ABCDEFGHIJKLMNOPQRSTUVWXYZ_abcdefghijklmnopqrstuvwxyz'; 
        $key = str_shuffle($character_set); 
        $cipher_text = ''; 
        $id = 'e'.rand(1,999999999); for ($i=0;$i<strlen($email);$i+=1) 
        $cipher_text.= $key[strpos($character_set,$email[$i])]; 
        $script = 'var a="'.$key.'";var b=a.split("").sort().join("");var c="'.$cipher_text.'";var d="";'; 
        $script.= 'for(var e=0;e<c.length;e++)d+=b.charAt(a.indexOf(c.charAt(e)));'; 
        $script.= 'document.getElementById("'.$id.'").innerHTML="<a href=\\"mailto:"+d+"\\">"+d+"</a>"'; 
        $script = "eval(\"".str_replace(array("\\",'"'),array("\\\\",'\"'), $script)."\")"; 
        $script = '<script type="text/javascript">/*<![CDATA[*/'.$script.'/*]]>*/</script>'; 
        return '<span id="'.$id.'">[javascript protected email address]</span>'.$script; 
    }
	
	// alle postvars gescaped en geencode weergeven.
	function catchPost($aArray = array(), $bHtml = false, $bDebug = false){
	
		$sHtml = '';
		foreach($aArray as $sKey => $mixedValue){
			if(is_array($mixedValue)){
				if($bDebug){ $sHtml .= 'array > '; }
				$sHtml .= '$'.$sKey."\t".' = $_POST[\''.$sKey.'\'];'."\n";
			} elseif(is_numeric($mixedValue)){
				if($bDebug){ $sHtml .= 'interger > '; }
				$sHtml .= '$'.$sKey."\t".' = utf8_encode(intval($_POST[\''.$sKey.'\']));'."\n";		
			} else {
				if($bDebug){ $sHtml .= 'string > '; }
				$sHtml .= '$'.$sKey."\t".' = utf8_encode(mysql_real_escape_string($_POST[\''.$sKey.'\']));'."\n";
			}
		}

		if($bHtml){ 
			$sHtml = nl2br($sHtml); 
		} else {  
			$sHtml = '<pre>'.$sHtml.'</pre>';
		}
		return $sHtml;
	}
	
	function giveVarList($aArray = array(), $iOption = 0){
	
		$sReturn = '<pre>';
		switch($iOption){
			case 0:
				foreach($aArray as $key => $value){
					$sReturn .= '$'.$key.' = \'\';'."\n";
				}
			break;			
			case 1:
				foreach($aArray as $key => $value){
					$sReturn .= '$'.$key.' = $_SESSION[\'cart\'][\'koper\'][\''.$key.'\'];'."\n";
				}
			break;
		
		}
		$sReturn .= '</pre>';
		
		return $sReturn;
	
	}	
?><?

	/* -- SET BASE-HREF ----------------------------------------------------------------------------------------------------------------------------- */
	$sBase_href 		= "http://". $_SERVER['HTTP_HOST'] . (dirname($_SERVER['PHP_SELF']) != "/" ? dirname($_SERVER['PHP_SELF']) . "/" : "/");
	$sRequest_href		= "http://". $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'];
	$sRequests_href		= "/".str_replace("$sBase_href","",$sRequest_href);
	

	/* -- SET MODREWRITE VARS  ---------------------------------------------------------------------------------------------------------------------- */		
	$sUrl 				= explode("/",$sRequests_href);
	array_pop($sUrl);
	array_shift($sUrl);
	$GLOBALS['sUrl'] 	= $sUrl;

	// request url without unfriendly vars
	$sThisUrl 			= $sBase_href.implode('/',$sUrl)."/";
	
	/* -- GET MENU CONFIG  --------------------------------------------------------------------------------------------------------- session -------- */
	if(!isset($_SESSION['config']['menu']) || $_SESSION['config']['menu']['tijd'] < date("U")-900){
	 	$sSqlmenu 	 = "SELECT * FROM menu_config ORDER BY id DESC LIMIT 1 ";
	 	$oSqlmenu 	 = mysql_query($sSqlmenu) or die ("<hr>$sSqlmenu<hr>".mysql_error());
	 	$aConfigMenu = mysql_fetch_assoc($oSqlmenu);
	 	$_SESSION['config']['menu'] = $aConfigMenu;
	 	$_SESSION['config']['menu']['tijd'] = date('U');
	} 
	
	/* -- GET BASIC CONFIG  -------------------------------------------------------------------------------------------------------- session -------- */
	if(!isset($_SESSION['config']['basic']) || $_SESSION['config']['basic']['tijd'] < date("U")-900){
	 	$sSqlBasicinfo 	 = "SELECT naam FROM configuratie_cms_algemeen ORDER BY id DESC LIMIT 1 ";
	 	$oSqlBasicinfo	 = mysql_query($sSqlBasicinfo) or die ("<hr>$sSqlBasicinfo<hr>".mysql_error());
	 	$aBasicInfo = mysql_fetch_assoc($oSqlBasicinfo);
	 	$_SESSION['config']['basic'] = $aBasicInfo;
	 	$_SESSION['config']['basic']['tijd'] = date('U');
	}	


	/* -- UNIQUE USERID HASH  ------------------------------------------------------------------------------------------------------ session -------- */
	if(!isset($_SESSION['user']['currentid'])){
		$_SESSION['user']['currentid'] = md5(date('U').$_SERVER['REMOTE_ADDR']);
	}
	
	if(!isset($_SESSION['user']['orderid'])) {
		// create a string based on ip and a container
		$string = $_SERVER['REMOTE_ADDR'];
		$ip = '';
		
		// match any character that is not a number between 0 and 9
		preg_match_all("/[0-9]/", $string, $matches);

		// loop through the matches with foreach
		foreach($matches[0] as $value) {
			$ip .= $value;
		}			
	
		$sOrderId = date("U").$ip;
		$_SESSION['user']['orderid'] = substr($sOrderId,0,12);	
	} else {
		// unset($_SESSION['user']['orderid']);
	}	
	
	
	/* -- GET AVAILABLE LANGUAGES  ------------------------------------------------------------------------------------------------- session -------- */
	if(!isset($_SESSION['config']['talen'])){
		$aTalen 	 = array();
	 	$sSqlTalen 	 = "SELECT * FROM menu_talen WHERE status = 1 ORDER BY id ASC ";
	 	$oSqlTalen 	 = mysql_query($sSqlTalen) or die ("<hr>$sSqlTalen<hr>".mysql_error());
	 	while($aTaal = mysql_fetch_assoc($oSqlTalen))
	 	{
	 		$aTalen[$aTaal['id']] = $aTaal;
	 	}
	 	
	 	$_SESSION['config']['talen'] = $aTalen;
	}
 	
	if(!isset($_SESSION['lang']))
	{
		$_SESSION['lang'] = 1;
	}
	
	if(isset($_GET['lang']))
	{
		if(intval($_GET['lang']) == 0){ $iLang = 1; } else { $iLang = intval($_GET['lang']);  }
		$_SESSION['lang'] = $iLang;
	} 

	
	/* -- ANALYTICS ---------------------------------------------------------------------------------------------------------------- session -------- */
	if(!isset($_SESSION['analytics'])){
		$sSqlGetAnalytics = "SELECT code FROM configuratie_analytics ORDER BY id DESC LIMIT 1 ";
		$oSqlGetAnalytics = mysql_query($sSqlGetAnalytics) or die ($sSqlGetAnalytics."<hr>".mysql_error());
		$iCountCode = mysql_num_rows($oSqlGetAnalytics);
		if($iCountCode > 0){
			$aAnalytics = mysql_fetch_assoc($oSqlGetAnalytics);
			$sCode = $aAnalytics['code'];
	
			// inhoud van de include ophalen en items vervangen
			$sAnalyticsJavascript = get_include_contents('includes/misc/googletrackcode.php');
			$sAnalyticsJavascript = str_replace('[ANALYTICSCODE]',$sCode,$sAnalyticsJavascript);
			$_SESSION['analytics'] = $sAnalyticsJavascript;		
		} else {
			$_SESSION['analytics'] = '';
		}
	}	

	
	/* -- MENU OPHALEN  --------------------------------------------------------------------------------------------------------------- live -------- */
	// WHERE condities voor het ophalen van het menu
	$ingelogd = 0;
	if($ingelogd == 0){
		$loggedin 	= " AND publiek = '1'";
	} elseif($ingelogd == 1) {	
		$loggedin 	= "";
	}
	
	$sEmbargoTijd 	= " AND ((datum_start = '0' OR datum_start < '". date("YmdHis") ."') AND (datum_eind = '0' OR  datum_eind > '". date("YmdHis") ."' )) ";
	$sWhereTaal		= " AND taal = '". $_SESSION['lang'] ."' ";

	

	// pagina en menustructuur opzetten
	if(sizeof($sUrl) < 1) {
		
		$getFirstMenu 		= mysql_query(" SELECT * FROM menu WHERE actief > '0' AND publiek = '1' $sEmbargoTijd $sWhereTaal AND isSubVan = '0' ORDER BY positie ASC LIMIT 1 ") or die (" get menu ".mysql_error());
		$firstMenu 			= mysql_fetch_assoc($getFirstMenu);
		$aMenuStructure[$firstMenu['id']] = $firstMenu;

		function getSubStructure($sParentId, $aMenuStructure, $sEmbargoTijd, $sWhereTaal)
		{
			$sSqlCurrentLevel 		= " SELECT * FROM menu WHERE isSubVan = '". $sParentId  ."' AND actief > '0' AND publiek = '1' $sEmbargoTijd $sWhereTaal ORDER BY positie ASC LIMIT 1 ";
			$oSqlCurrentLevel 		= mysql_query($sSqlCurrentLevel) or die ("$sSqlCurrentLevel<hr/>".mysql_erro());
			$iCountCurrentLevel 	= mysql_num_rows($oSqlCurrentLevel);
			if($iCountCurrentLevel > 0)
			{
				$aMenuDetails = mysql_fetch_assoc($oSqlCurrentLevel);
				$aMenuStructure[$aMenuDetails['id']] = $aMenuDetails;
				getSubStructure($aMenuDetails['id'], $aMenuStructure, $sEmbargoTijd, $sWhereTaal);
			}
			
			return $aMenuStructure;
		}

		$aMenuStructure = getSubStructure($firstMenu['id'], $aMenuStructure, $sEmbargoTijd, $sWhereTaal);
		$aMenuStructureFirst = reset($aMenuStructure);
		unset($aMenuStructure); 
		$aMenuStructure[] = $aMenuStructureFirst;		
		
	// acties uitvoeren	
	} elseif(sizeof($GLOBALS['sUrl']) > 0){
		if(isset($GLOBALS['sUrl'][0]) && !is_numeric($GLOBALS['sUrl'][0]) && $GLOBALS['sUrl'][0] == 'action' && isset($GLOBALS['sUrl'][1]) ){

			switch($GLOBALS['sUrl'][1])
			{
				case "newsaddmember":  		$action = "action_newsAddMember.php"; 			break;
				case "activatenews":  		$action = "action_newsActivatie.php"; 			break;
				case "deactivatenews":  	$action = "action_newsDescript.php"; 			break;
				case "sendmail":  			$action = "action_mailSend.php"; 				break;
				case "guestbookadd":  		$action = "action_gastenboekAdd.php"; 			break;
				case "download":			$action = "action_downloadregister.php";		break;
				default: 					$action = "";
			}
			
			if(!empty($action)){
				include("includes/actions/". $action ."");
				exit;
			} else {
				echo "404";
				exit;
			}
			
		} else {
			$aMenuStructure = array();
			$aDiscard = array();
			
			foreach($sUrl as $sMenuitem)
			{	
				if(!in_array($sMenuitem, $aDiscard)) {
				
					if(sizeOf($aMenuStructure) < 1){
						$iLastNavId = 0;
						$aLastNavId['parent_id'] = 0;
					} else {
						$aLastNavId = end($aMenuStructure);
						$iLastNavId = $aLastNavId['id'];
					}
					
					$sSqlNavigatieItem = " SELECT * FROM menu WHERE isSubVan = '".$iLastNavId."' AND naam_paginaurl = '".$sMenuitem."' LIMIT 1 ";
					$sGetNavigatieItem = mysql_query($sSqlNavigatieItem) or die ($sSqlNavigatieItem."<hr />".mysql_error());
					$aNavigatieItem = mysql_fetch_assoc($sGetNavigatieItem);

					if(isset($aNavigatieItem['id']) && $aNavigatieItem['id'] > 0){
						$aMenuStructure['lastparent'] = $aNavigatieItem['id'];
					}
					
					if(!empty($aNavigatieItem['id'])){
						$aMenuStructure[$aNavigatieItem['id']] = $aNavigatieItem;  
					}
				}	
			}
		}
	}
		
	$aCurrentPage 	= end($aMenuStructure);
	$iCurrentPage 	= $aCurrentPage['id'];
	$aMenuKeys 		= array_keys($aMenuStructure);	


	/* -- JAVASCRIPTS ----------------------------------------------------------------------------------------------------------------- live -------- */
	$jsArray 	= array();
	//$sInJs 		= implode(", ",array_keys($aMenuStructure));
	if(strlen($iCurrentPage) > 0) {
		$sWhereJs 	= "menu_id IN (0, ". $iCurrentPage .") ";
	} else {
		$sWhereJs 	= 'menu_id IN (0)';
	}
	$sSqlGetJs 	= " SELECT * FROM menu_javascript WHERE ".$sWhereJs;
	$getJs			= mysql_query($sSqlGetJs) or die ("$sSqlGetJs<hr /> ".mysql_error());
	while($dataJs = mysql_fetch_assoc($getJs)){
		$key = $dataJs['positie'];
		$jsArray[$key] = $dataJs['bestand'];
	}	
	
	array_unique($jsArray);
	ksort($jsArray);
	
	$sJavascripts = "";
	foreach($jsArray as $jsinclude){
		if($jsinclude == "js/extra/excanvas.js")
		{
			$sJavascripts .= " <!--[if IE]><script language=\"javascript\" type=\"text/javascript\" src=\"$jsinclude\"></script><![endif]--> \n\t\t ";
		} 
		else 
		{
			$sJavascripts .= "<script type=\"text/javascript\" src=\"$jsinclude\"></script> \n\t\t";
		}
	}
	
	
	/* -- CLICKTRACKER ---------------------------------------------------------------------------------------------------------------- live -------- */
	if(isset($_GET['track'])){
		$sTrack = addslashes($_GET['track']);
		
		switch($sTrack){
			case "newsletter":

				$iLetter 			= intval($_GET['letter']);
				$sUserCode			= mysql_real_escape_string($_GET['user']);
				newsletterClick($iLetter, $sUserCode, $sRequest_href);				

			break;	 
		}

	}

?>