<? 
 error_reporting(0);
/* 	--- [ shell check ]
	---------------------------------------------------------------------------------------------------------------- */	
	if(!isset($_SERVER['SHELL']) && !isset($_SESSION) ) { session_start(); }

/* 	--- [ timezone check ]
	---------------------------------------------------------------------------------------------------------------- */	
	if(function_exists("date_default_timezone_set") and function_exists("date_default_timezone_get")){ 
		@date_default_timezone_set(@date_default_timezone_get()); #date_default_timezone_set( 'Europe/Paris' );
	}

/*	--- [ constanten ]
	---------------------------------------------------------------------------------------------------------------- */	
	define("_DB_HOST" ,"localhost");
	define("_DB_DBASE" ,"eilandurk_1442026");
	#define("_DB_USER" ,"root");
	#define("_DB_PASS" ,"");
	define("_DB_USER" ,"eilandurk_1442026gb");
	define("_DB_PASS" ,"6gXmw6jFB4Z7psDAxryy");
	
	define("_AVG_DBC", true) ;	

	if(_DB_USER=="root"){
		define("_MAIL_AUTH" , false); 
		
	}else{
		define("_MAIL_HOST" , "smtp.rsh.nl"); 
		define("_MAIL_AUTH" , true); 
		define("_MAIL_PORT" , 25); 
		define("_MAIL_USER" , "webmind"); 
		define("_MAIL_PASS" , "Appelsapje20"); 
		
	}
	
/*	--- [ classes/class.root_path.php ]
	---------------------------------------------------------------------------------------------------------------- */	
	$RootVars 	= new root_path_class;
	# $RootVars->setUpload( "uploads/" ); 	// instellen als er een andere naam word gebruikt
	# $RootVars->setSubdir( "new/" ); 		// alleen gebruiken voor sub directory op een domein: http://www.webmind.nl/site/ 
	# $RootVars->setCMSdir( "onderhoud/" ); 		// alleen gebruiken als het anders dan cms is!
	# $RootVars->setPdwUpload( "media/" ); 	// instellen als er een andere naam word gebruikt
	$RootVars->init();						// haal gegevens op.
	$RootVars->setShowInfo(false);			// true geeft class info.


/*	--- [ variabelen ]
	---------------------------------------------------------------------------------------------------------------- */	
	$rootURL	= $RootVars->getRootURL();
	$rootDir	= $RootVars->getRootDIR();
	$uploadURL	= $RootVars->getUploadURL();
	$uploadDir	= $RootVars->getUploadDIR();
	$rootCMS	= $rootURL.$RootVars->getCMSdir();
	$rootDirCMS	= $rootDir.$RootVars->getCMSdir(); 
	$pdwPath	= $RootVars->getPdwUploadPath();
	$SubDir 	= $RootVars->getSubdir();
	$adminmail 	= "info@eilandurk.nl";
	$rightnow 	= time();

	if(_DB_USER=="root") touch(str_replace($SubDir,"",$rootDir), time());

	
/*	--- [ louis vuitton hack check ]
	---------------------------------------------------------------------------------------------------------------- */	
	if(strpos("_test".$_SERVER['REQUEST_URI'], "/index.php/"))
	{
		header( "HTTP/1.1 404 Not Found" ); 
		header("location: ".$rootURL."index.php?mode=error&type=404");
		exit;
	}
	
/*	--- [ session check ]
	---------------------------------------------------------------------------------------------------------------- */	
	if(isset($_SESSION)){
		if(!isset($_SESSION['taalid'])) $_SESSION['taalid'] = 1;
		$_SESSION['rootURL'] = $rootURL;
		$_SESSION['rootDir'] = $rootDir;
		$_SESSION['uploadURL'] = $uploadURL;
		$_SESSION['uploadDir'] = $uploadDir;
		$_SESSION['DirCMS'] = $RootVars->getCMSdir();
		$_SESSION['pdw_upload_path'] = $pdwPath; 
		$_SESSION['SubDir'] = $SubDir;
		$_SESSION['add_sub'] = '';
	}
	
	if($_SERVER['SERVER_PORT']!=80) $_SESSION['add_sub'] = $SubDir;
/*	--- [ menu parameters ]
	---------------------------------------------------------------------------------------------------------------- */	
	
	#$portfolio_init = '';
	if($_REQUEST['mode']=="portfolio" || $_REQUEST['mode']=="fotoalbum") 
	$portfolio_init = "$.HSCore.components.HSCubeportfolio.init('.cbp');";
	
	$menu_options = array(	'1' => 
						array(	'1' => 
							array(	'0' => 'light g-bg-white g-transition-0_3 g-py-10', 
									'1' => 'g-py-10', 
									'2' => 'u-shadow-v18 g-py-0', 
									'3' => '' ),
					'2' => array(	'0' => 'dark g-bg-black g-transition-0_3 g-py-10', 
									'1' => 'g-py-10', '2' => 'g-py-0',  '3' => '' ),
					'3' => array(	'0' => 'dark g-bg-primary g-transition-0_3 g-py-10', 
									'1' => 'g-py-10', '2' => 'g-py-0', '3' => '' ),
					'4' => array(	'0' => 'dark g-bg-primary-gradient-opacity-v1 g-transition-0_3 g-py-10', 
									'1' => 'g-py-10', '2' => 'g-py-0', '3' => '' ),
					'5' => array(	'0' => 'dark g-transition-0_3 g-py-10 g-py-10', 
									'1' => 'g-py-10', 
									'2' => 'g-bg-black-opacity-0_7 g-py-0', 
									'3' => 'style="background-color: transparent !important;"' ),
					'6' => array(	'0' => 'light g-bg-white-opacity-0_7 g-transition-0_3 g-py-10', 
									'1' => 'g-py-10', 
									'2' => 'u-shadow-v18 g-py-0', 
									'3' => '' ),
					'7' => array(	'0' => 'dark g-transition-0_3 g-bg-black-opacity-0_4 g-py-10', 
									'1' => 'g-bg-black-opacity-0_7 g-py-10', 
									'2' => 'g-bg-black-opacity-0_4 g-py-0', 
									'3' => '' ),
					'8' => array(	'0' => 'light g-brd-bottom g-brd-gray-dark-v5 g-transition-0_3 g-py-10', 
									'1' => 'u-header__section--light g-brd-bottom g-py-10', 
									'2' => 'u-header__section--dark g-bg-black-opacity-0_7 g-py-0', 
									'3' => '' ),
					'div-ul' => '<div class="collapse navbar-collapse align-items-center flex-sm-row g-pt-10 g-pt-5--lg" id="navBar">
      								<ul class="navbar-nav  text-uppercase g-font-weight-400 ml-auto">',
					'nav-header' => 'sticky-top u-header--toggle-section u-header--change-appearance',
					'nav-link' => 'g-py-7 g-px-0',
					'nav-item' => 'g-mx-10--lg g-mx-15--xl',
					'sub-menu' => 'g-brd-top g-brd-primary g-brd-top-2 g-min-width-220 g-mt-21 g-mt-11--lg--scrolling',
					'sub-nav-link' => 'nav-link',
					'css-add1' => '',
					'css-add2' => '',
					'css-add3' => '',
					'css-add4' => '',
					'css-add5' => '<link rel="stylesheet" href="'.$rootURL.'assets/vendor/fancybox/jquery.fancybox.min.css">'.chr(10),
					'css-add6' => '<link rel="stylesheet" href="'.$rootURL.'assets/vendor/slick-carousel/slick/slick.css">'.chr(10),
					'css-add7' => '<link rel="stylesheet" href="'.$rootURL.'assets/vendor/typedjs/typed.css">'.chr(10),
					'css-add8' => '<link rel="stylesheet" href="'.$rootURL.'assets/vendor/hs-megamenu/src/hs.megamenu.css">'.chr(10),
					'css-addx' => '',
					'js-add1' => '',
					'js-add2' => '',
					'js-add3' => '',
					'js-add4' => '',
					'js-add5' => '<script src="'.$rootURL.'assets/vendor/typedjs/typed.min.js"></script>'.chr(10),
					'js-add6' => '<script src="'.$rootURL.'assets/js/components/hs.tabs.js"></script>'.chr(10),
					'js-add7' => '<script src="'.$rootURL.'assets/js/components/text-animation/hs.text-slideshow.js"></script>'.chr(10),
					'js-add8' => '',
					'js-addx' => '',
					'menu' => '1',
					'script' => "<script>
								    $(document).on('ready', function () {
								      
								      // initialization of go to
								      $.HSCore.components.HSGoTo.init('.js-go-to');

								      // initialization of carousel
								      $.HSCore.components.HSCarousel.init('.js-carousel');
								      
								      $('#we-provide').slick('setOption', 'responsive', [{
								        breakpoint: 992,
								        settings: {
								          slidesToShow: 2
								        }
								      }, {
								        breakpoint: 576,
								        settings: {
								          slidesToShow: 1
								        }
								      }], true);

								      // initialization of HSDropdown component
									      $.HSCore.components.HSDropdown.init( $('[data-dropdown-target]'), {
									        afterOpen: function(){
									          $(this).find('input[type=\"search\"]').focus();
									        }
									      });
									  
								      // initialization of masonry
								      $('.masonry-grid').imagesLoaded().then(function () {
								        $('.masonry-grid').masonry({
								          columnWidth: '.masonry-grid-sizer',
								          itemSelector: '.masonry-grid-item',
								          percentPosition: true
								        });
								      });

								      
								      // initialization of popups with media
								      $.HSCore.components.HSPopup.init('.js-fancybox-media', {
								        helpers: {
								          media: {},
								          overlay: {
								            css: {
								              'background': 'rgba(255, 255, 255, .8)'
								            }
								          }
								        }
								      });
								      // initialization of cubeportfolio
                					  ".$portfolio_init."
								      
								      // initialization of counters
								      // var counters = $.HSCore.components.HSCounter.init('[class*=\"js-counter\"]');
    
								    });

								    $(window).on('load', function () {
								      // initialization of header
								      $.HSCore.components.HSHeader.init($('#js-header'));
								      $.HSCore.helpers.HSHamburgers.init('.hamburger');

								      // initialization of HSMegaMenu component
								      $('.js-mega-menu').HSMegaMenu({
								        event: 'hover',
								        pageContainer: $('.container'),
								        breakpoint: 991
								      });
								    });
								  </script>"
																				
					),
														
	
					'2' => 
						array(	'1' => 
							array(	'0' => 'light g-bg-white g-transition-0_3 g-py-10', 
									'1' => 'g-bg-white-opacity-0_7 u-shadow-v18 g-py-0', 
									'2' => 'g-bg-white g-py-10', 
									'3' => '' ),
					'2' => array(	'0' => 'light g-bg-white g-transition-0_3 g-py-10', 
									'1' => 'g-bg-white-opacity-0_7 u-shadow-v18 g-py-0', 
									'2' => 'g-bg-white g-py-10', 
									'3' => '' ),
					'3' => array(	'0' => 'light g-bg-white g-transition-0_3 g-py-10 g-py-0--lg', 
									'1' => 'u-shadow-v18', 
									'2' => '', 
									'3' => 'py-0' ),
					'4' => array(	'0' => 'light g-bg-white g-transition-0_3 g-py-10 g-py-0--lg', 
									'1' => 'g-bg-white-opacity-0_7 u-shadow-v18 g-py-0', 
									'2' => '', 
									'3' => 'py-0' ),
					'5' => array(	'0' => 'light g-bg-white g-transition-0_3 g-py-10', 
									'1' => 'g-bg-white-opacity-0_7 u-shadow-v18 g-py-0', 
									'2' => 'g-bg-white g-py-10', 
									'3' => '' ),
					'6' => array(	'0' => 'light g-bg-white g-transition-0_3 g-py-10 g-py-0--lg', 
									'1' => 'u-shadow-v18', 
									'2' => '', 
									'3' => 'py-0' ),
					'7' => array(	'0' => 'light g-bg-white g-transition-0_3 g-py-10', 
									'1' => 'g-bg-white-opacity-0_7 u-shadow-v18 g-py-0', 
									'2' => 'g-bg-white g-py-10', 
									'3' => '' ),
					'8' => array(	'0' => 'light g-bg-white g-transition-0_3 g-py-10', 
									'1' => 'g-bg-white-opacity-0_7 u-shadow-v18 g-py-0', 
									'2' => 'g-bg-white g-py-10', 
									'3' => ''), 
					
					'div-ul' => '<div class="collapse navbar-collapse align-items-center flex-sm-row g-pt-10 g-pt-5--lg" id="navBar">
	  								<ul class="navbar-nav ml-auto text-uppercase g-font-weight-600 u-main-nav-v1 u-sub-menu-v1">',
					'nav-header' => 'static--lg u-header--show-hide--lg u-header--change-appearance--lg',
					'nav-link' => 'g-mx-2--md g-mx-5--xl g-mb-5 g-mb-0--lg',
					'nav-item' => 'g-mx-2--md g-mx-5--xl g-mb-5 g-mb-0--lg',
					'sub-menu' => 'g-mt-17--lg g-mt-7--lg--scrolling',
					'sub-nav-link' => '',
					'css-add1' => '<link rel="stylesheet" href="'.$rootURL.'assets/vendor/bootstrap/offcanvas.css">'.chr(10),
					'css-add2' => '<link rel="stylesheet" href="'.$rootURL.'assets/vendor/hs-megamenu/src/hs.megamenu.css">'.chr(10),
					'css-add3' => '<link rel="stylesheet" href="'.$rootURL.'assets/vendor/slick-carousel/slick/slick.css">'.chr(10),
					'css-add4' => '<link rel="stylesheet" href="'.$rootURL.'assets/vendor/fancybox/jquery.fancybox.css">'.chr(10),
					'css-add5' => '',
					'css-add6' => '',
					'css-add7' => '',
					'css-add8' => '',
					'css-addx' => '',
					'js-add1' => '<script src="'.$rootURL.'assets/vendor/bootstrap/offcanvas.js"></script>'.chr(10),
					'js-add2' => '<script src="'.$rootURL.'assets/vendor/imagesloaded/imagesloaded.pkgd.min.js"></script>'.chr(10),
					'js-add3' => '',
					'js-add4' => '',
					'js-add5' => '',
					'js-add6' => '',
					'js-add7' => '',
					'js-add8' => '',
					'js-addx' => '',
					'menu' => '2',
					'script' => "<script>
									    $(document).on('ready', function () {
									      // initialization of go to
									      $.HSCore.components.HSGoTo.init('.js-go-to');

									      // initialization of carousel
									      $.HSCore.components.HSCarousel.init('.js-carousel');

									      $('#we-provide').slick('setOption', 'responsive', [{
									        breakpoint: 992,
									        settings: {
									          slidesToShow: 2
									        }
									      }, {
									        breakpoint: 576,
									        settings: {
									          slidesToShow: 1
									        }
									      }], true);
									      
									      // initialization of HSDropdown component
									      $.HSCore.components.HSDropdown.init( $('[data-dropdown-target]'), {
									        afterOpen: function(){
									          $(this).find('input[type=\"search\"]').focus();
									        }
									      });
										 
									      // initialization of masonry
									      $('.masonry-grid').imagesLoaded().then(function () {
									        $('.masonry-grid').masonry({
									          columnWidth: '.masonry-grid-sizer',
									          itemSelector: '.masonry-grid-item',
									          percentPosition: true
									        });
									      });

									      // initialization of popups with media
									      $.HSCore.components.HSPopup.init('.js-fancybox-media', {
									        helpers: {
									          media: {},
									          overlay: {
									            css: {
									              'background': 'rgba(255, 255, 255, .8)'
									            }
									          }
									        }
									      });
									    });

									    $(window).on('load', function () {
									      // initialization of header
									      $.HSCore.components.HSHeader.init($('#js-header'));
									      $.HSCore.helpers.HSHamburgers.init('.hamburger');

									      // initialization of HSMegaMenu component
									      $('.js-mega-menu').HSMegaMenu({
									        event: 'hover',
									        pageContainer: $('.container'),
									        breakpoint: 991
									      });
									    });
									  </script>"											
								)
								
							);
	
/* 	--- [ menu ] 
	---------------------------------------------------------------------------------------------------------------- */	
	/* Classic Header 	*/ 
	$menu 	= 1; 
	$option = 1; /* 1 = 'White BG', 2 = 'Dark BG', 3 = 'Primary BG', 4 = 'Gradient BG', 5 = 'Transparent BG', 
				  	6 = 'SemiTransparent white BG', 7 = 'SemiTransparent black BG',	8 = 'Bordered BG' */ 
	/* Nav Styles 		*/
	 # $menu	= 2; 
	 # $option = 2; /* Nav Styles '1 t/m 8' */
	

/*	--- [ cookie consent ]
	---------------------------------------------------------------------------------------------------------------- */	
	$cookieconsent = false;

/* 	--- [ shop ]
	---------------------------------------------------------------------------------------------------------------- */	
	
	$shop_actief = true; /* nog niet voor UNIFI geschikt */
	$max_depth = 3;
  $site_lang = 1;			// 1 = NL .............

/* 	--- [ diverse status ]
	---------------------------------------------------------------------------------------------------------------- */	
	$dagen 		= array('1' => 'Maandag', '2' => 'Dinsdag', '3' => 'Woensdag', '4' => 'Donderdag', '5' => 'Vrijdag', '6' => 'Zaterdag', '7' => 'Zondag' );
	$maanden 	= array('01' => 'Januari', '02' => 'Februari', '03' => 'Maart', '04' => 'April', '05' => 'Mei', '06' => 'Juni', '07' => 'Juli', '08' => 'Augustus', '09' => 'September', '10' => 'Oktober', '11' => 'November' , '12' => 'December' );
	$concert_status 	= array('0' => 'Toon concert',
														'3' => 'Toon Gratis concert',
														'4' => 'Verkoop aan de deur',
														'5' => 'Verkoop derden',
														'6' => 'Aankondiging',
														'2' => 'Gesloten',
														'1' => 'Archief' );
	$verzend_type 		= array('0' => "pakketpost (verzendkosten)", '1' => "postbus (briefkosten)" ); 

	$klant_status 		= array('1' => "aktief", '0' => "niet aktief"); 

	$betaal_status 		= array('0' => "Gratis kaarten",	
														'1' => "iDeal ING/ABNAMRO", '11' => "ideal success", '12' => "ideal cancel", '13' => "ideal error",'111' => "klaar voor verzenden", '112' => "onderweg", '113' => "ideal afgerond",	
														'2' => "Overmaken via de bank", '21' => "Ontvangen via de bank", '22' => "Overmaken via de bank cancel", '213' => "Overmaken via de bank afgerond",
														'3' => "Contant of per pin",  '32' => "Contant of pin cancel", '313' => "Contant of pin afgerond",
														'4' => "Paypal", '41' => "paypal success", '42' => "paypal cancel", '411' => "klaar voor verzenden", '412' => "onderweg", '413' => "paypal afgerond",
														'5' => "Eenmalige machtiging",  '52' => "Machtiging cancel", '513' => "Machtiging afgerond",
														'6' => "Mollie ideal", '61' => "mollie success", '62' => "mollie cancel", '63' => "mollie error", '69' => "mollie betaling in behandeling",'611' => "klaar voor verzenden", '612' => "onderweg", '613' => "mollie afgerond",
														'7' => "Op rekening", '71' => "Op rekening ontvangen",  '72' => "Op rekening cancel", '713' => "Op rekening afgerond",
														'9' => "Omni ideal", '91' => "omni success", '92' => "omni cancel", '93' => "omni error", '99' => "omni betaling in behandeling",'911' => "klaar voor verzenden", '912' => "onderweg", '913' => "omni afgerond"); 

	$betaal_check	 		= array('1' => "ideal_pay_with",	
														'4' => "paypal_pay_with",
														'6' => "mollie_pay_with",
														'9' => "omni_pay_with"); 
			
	
/* 	--- [ einde config ] 
	---------------------------------------------------------------------------------------------------------------- */	
?><?
function str_rot($s, $n = -1) {
	
	static $letters = 'AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz0123456789.,!$*+-?@#'; 
	
	$letterLen = round(strlen($letters)/2);
	if($n==-1) $n = (int)($letterLen/2); //Find the "halfway rotate point"
	$n = (int)$n % ($letterLen);
	if (!$n) return $s;
	if ($n < 0) $n += ($letterLen);
	//if ($n == 13) return str_rot13($s);
	$rep = substr($letters, $n * 2).substr($letters, 0, $n * 2);
	
	return strtr($s, $letters, $rep);

}
 
function decryptie($table, $field, $value) {
	global $rootDir; 	

 	if(	_AVG_DBC == true ){
		$fname = $rootDir.'include/db_class_config.php';
	 	if(file_exists($fname)){
	 		include($fname);		
			if($value) $value = str_rot($value);							 		
		}
	}
 	
	return $value;
}
	 
function makepass()
{
		$chars = "abcdefghijkmnopqrstuvwxyz023456789!@#$%^&*()-_=+<>,.?/:;[]{}";
	  srand((double)microtime()*1000000);
		$i = 0;
		$pass = '' ;
		while ($i <= 7)
		{
				$num = rand() % 33;
				$tmp = substr($chars, $num, 1);
				if(rand(0,1)==1) $tmp = strtoupper($tmp);
				$pass = $pass . $tmp;
				$i++;
		}
		return $pass;
}

function prep_header($sitename, $title, $description, $url, $fotos, $publisher_handle, $creator  )
{
		global $rootURL;
		
		$description = substr(strip_tags($description),0,195);
		if(strlen($description)==195) $description .= "...";
					
		
		$header = array('tw'=>'', 'og'=>'' );
		
		$header['tw'] =   chr(10).'<!-- Twitter Card data -->
										'.chr(10).'<meta name="twitter:card" content="summary" />
										'.chr(10).'<meta name="twitter:title" content="'.strip_tags($title).'" />
										'.chr(10).'<meta name="twitter:description" content="'.$description.'" />'; 

		if($publisher_handle) 
			$header['tw'] = chr(10).'<meta name="twitter:site" content="'.$publisher_handle.'" />';
		
		if($creator) 
			$header['tw'] = chr(10).'<meta name="twitter:creator" content="'.$creator.'" / >';
										 
		$header['og'] =  chr(10).'<!-- Open Graph data -->
										'.chr(10).'<meta property="og:url" content="'.$rootURL.$url.'" />
										'.chr(10).'<meta property="og:type" content="website" />
										'.chr(10).'<meta property="og:title" content="'.strip_tags($title).'" />
										'.chr(10).'<meta property="og:site_name" content="'.$sitename.'" />
										'.chr(10).'<meta property="og:description" content="'.$description.'" /> 
										';		

		$img =  chr(10).'<meta property="og:image:width" content="400" />
					'.chr(10).'<meta property="og:image:height" content="300" />';
		foreach($fotos AS $key => $val){
			if($val){
				$header['tw'] .= chr(10).'<meta name="twitter:image" content="'.$val.'" />'; 
				$header['og'] .= chr(10).'<meta property="og:image" content="'.$val.'" />'.$img;
				$img = '';
			}
			
		}
		
	
	return $header;	
}

function my_social_media_link($name, $opmaak)
{
	global $db, $rootURL;
	if($name=="googleplus")	$name = 'Google Plus';
	
	$query = $db->select("SELECT * FROM setup_sociale_media WHERE name LIKE '$name'");
	$row = $db->get_row($query, 'MYSQL_ASSOC');
	
	if($row['switch']=='on' && $row['link']){
		
		$link = str_replace( 'href=""', 'href="'.$row['link'].'"' ,$opmaak);
		$link = str_replace( 'title=""', 'title="'.$row['name'].'"' ,$link);

		return $link;
	}
	
}


function create_social_media_link($name, $url)
{
	
	$url = strtolower(urlencode($url));
	
	if($name=="facebook")
	{	
		$url = 'window.open(\'https://www.facebook.com/sharer/sharer.php?u='.$url.'&amp;src=sdkpreparse\',\''.$name.'\',\'width=560,height=660\')';
	}else{
		return "#";	
	}
	
	return $url;	
}

function share_social_media_link($name, $mode, $url, $opmaak, $photo = "")
{
	global $db;
	
	if($photo) $photo = '&media='.$photo;
	
	$title = urlencode(preg_replace('/&#?[a-z0-9]{2,8};/i', '', $mode));
	$url = strtolower(urlencode($url));
	
	if($name=="facebook")
	{	
		$url = 'https://www.facebook.com/sharer/sharer.php?u='.$url.'&amp;src=sdkpreparse';
	}
	elseif($name=="email")
	{	// rawurlencode ?
		$url = 'mailto:?body='.$title.'&url='.$url;
	}
	elseif($name=="twitter")
	{	
		$url = 'https://www.twitter.com/intent/tweet?text='.$title.'&url='.$url;
	}
	elseif($name=="whatsapp")
	{
		$url = 'whatsapp://send/?text='.$url;
	}
	elseif($name=="googleplus")
	{	
		$name = 'Google Plus';
		$url = 'https://plus.google.com/share?url='.$url;
	}
	elseif($name=="pinterest")
	{
		$url = 'https://pinterest.com/pin/create/button/?url='.$url.$photo.'&description='.$title.$url;;
	}
	elseif($name=="linkedin")
	{
		$url = 'https://www.linkedin.com/shareArticle?mini=true&url='.$url.'title='.$title;

	}else{
		return "";
	}	 
	
	
	$query = $db->select("SELECT * FROM setup_sociale_media WHERE name LIKE '$name'");
	$row = $db->get_row($query, 'MYSQL_ASSOC');
	
	if($row['page_to_media']=='on'){
		
		$link = str_replace( 'href=""', 'href="'.$url.'"' ,$opmaak);
		$link = str_replace( 'title=""', 'title="'.$row['name'].'"' ,$link);
		$link = str_replace( '</i>.</a>', '</i>'.$row['name'].'</a>' ,$link);

		return $link;
	}
	
}


function create_link($link, $url, $title = '', $photo = '')
{
	
	if($photo) $photo = '&media='.$photo;
	$title = urlencode(preg_replace('/&#?[a-z0-9]{2,8};/i', '', $title));
	$url = strtolower(urlencode($url));
	
	if($link=="facebook")
	{	
		return 'https://www.facebook.com/sharer/sharer.php?u='.$url;
	}
	elseif($link=="email")
	{	// rawurlencode ?
		return 'mailto:?body='.$title.'&url='.$url;
	}
	elseif($link=="twitter")
	{	
		return 'https://www.twitter.com/intent/tweet?text='.$title.'&url='.$url;
	}
	elseif($link=="whatsapp")
	{
		return 'whatsapp://send/?text='.$url;
	}
	elseif($link=="googleplus")
	{	
		return 'https://plus.google.com/share?url='.$url;
	}
	elseif($link=="pinterest")
	{
		return 'https://pinterest.com/pin/create/button/?url='.$url.$photo.'&description='.$title.$url;;
	}
	elseif($link=="linkedin")
	{
		return 'https://www.linkedin.com/shareArticle?mini=true&url='.$url.'title='.$title;

	}	 
	
	return '#';
}

function convert_utf8( $string ) { 
    if ( strlen(utf8_decode($string)) == strlen($string) ) {   
        // $string is not UTF-8
        return iconv("ISO-8859-1", "UTF-8", $string);
    } else {
        // already UTF-8
        return $string;
    }
}

function us_date($date)
{
	if($date=="0000-00-00" || $date=="00-00-0000") $date = "";
	
	$datum = explode("-",$date);
	if(trim($date) && strlen($datum[2])==4){
		$date = $datum[2]."-".$datum[1]."-".$datum[0];
		
	}
	
	return $date;
}

function nl_date($date)
{
	if($date=="0000-00-00" || $date=="00-00-0000") $date = "";
	
	$datum = explode("-",$date);
	if(trim($date) && strlen($datum[0])==4){
		$date = $datum[2]."-".$datum[1]."-".$datum[0];
		
	}
	return $date;
}


function dateDiff($time1, $time2, $precision = 6) {
	
	// Time format is UNIX timestamp or
	// PHP strtotime compatible strings
    // If not numeric then convert texts to unix timestamps
	if (!is_int($time1)) {
    	$time1 = strtotime($time1);
	}
    if (!is_int($time2)) {
    	$time2 = strtotime($time2);
    }
 
    // If time1 is bigger than time2
    // Then swap time1 and time2
    if ($time1 > $time2) {
      	$ttime = $time1;
      	$time1 = $time2;
      	$time2 = $ttime;
    }
 
    // Set up intervals and diffs arrays
    $intervals = array('minute'); // 'year','month','day','second','hour'
    $diffs = array();
 
    // Loop thru all intervals
    foreach ($intervals as $interval) {
      	// Create temp time from time1 and interval
      	$ttime = strtotime('+1 ' . $interval, $time1);
      	// Set initial values
      	$add = 1;
      	$looped = 0;
      	// Loop until temp time is smaller than time2
      while ($time2 >= $ttime) {
        	// Create new temp time from time1 and interval
			$add++;
			$ttime = strtotime("+" . $add . " " . $interval, $time1);
			$looped++;
      }
 
      $time1 = strtotime("+" . $looped . " " . $interval, $time1);
      $diffs[$interval] = $looped;
    }
	
	$count = 0;
    $times = array();
    // Loop thru all diffs
    foreach ($diffs as $interval => $value) {
    	// Break if we have needed precission
    	if ($count >= $precision) {
 			break;		
    	}
	    // Add value and interval 
	    // if value is bigger than 0
	    if ($value > 0) {
	 		// Add s if value is not 1
	 		if ($value != 1) {
	   			$interval .= "s";
	 		}
	 		// Add value and interval to times array
	 		$times[] = $value . " " . $interval;
	 		$count++;
	    }
    }
    
    $minuten = array();
    $temp = explode(" ",implode(", ", $times));
 	$minuten['minuten'] = $temp[0];
 	$minuten['uren'] = $minuten['minuten']/60;
    // Return string with times
    return $minuten;
    
    // use: print_r(dateDiff('2015-06-11 08:00:00', '2015-06-11 09:45:00',1 ));
}

function shop_menu_site_map($taalid, $categorie="0"){
	
	global $db, $rootURL;
	
	$query = $db->select("SELECT * FROM shop_categorien WHERE parent_id='$categorie' && taalid=$taalid ORDER BY positie ASC");
	if($db->get_rows($query, 'MYSQL_ASSOC')){
		
		while($row = $db->get_row($query, 'MYSQL_ASSOC')){
		
			#$htmllink = make_html_link( $row['titel'] ).".html" ;
			#echo $categorie."<br/>";
			#if($categorie=="0"){
			#	$menu[] = shop_menu_site_map( $taalid, $row['id']);		
			#}	
			#$menu[] = "shop/group/$row[id]/$htmllink";

			$queryI = $db->select("SELECT * FROM shop_producten WHERE taalid='$taalid' && categorie_id='$row[id]' && status='1' && actie_artikel!='code' ORDER BY locatie ASC");
			while($rowI = $db->get_row($queryI, 'MYSQL_ASSOC')){
				$htmllink = make_html_link( $rowI['titel'] ).".html" ;
				$menu[] = "shop/view/$rowI[id]/$htmllink";
				
			}
			
		}
	}
	
	
	return $menu;
}

function test_table($table_name)
{
	global $db;
	$query = $db->select("SELECT * FROM $table_name");
	if(!$query)	return false;	
	
	return true;
	
}
					
function request_session_4_sql_injection($to_page = ""){
	global $_REQUEST, $_SESSION, $rootURL;
	
	foreach($_REQUEST AS $key => $val){
	
		$options	= array('XP_ ', 'UPDATE ', 'INSERT ', 'ALTER ', 'CREATE ', 'RENAME ', 'DELETE ', 
							'REPLACE ', 'SELECT ', 'FROM ', 'WHERE ', 'DROP ', 'TABLE ', 'CONCAT ', 
							'CAST ', 'DATABASE ', ' OR ', ' AND ', 'BENCHMARK ', 'WAITFOR ', 'DELAY ' );
            
        $val = strtoupper(strval($val));		
        $val = str_replace("'", "''", $val); // Most important one! This line alone can prevent most injection attacks
        $val = str_replace("--", "", $val);
        $val = str_replace("[", "[[]", $val);
        $val = str_replace("%", "[%]", $val);
        
                            
        foreach($options AS $key2 => $val2){
            if(strstr("_debug_sql_injection:$val", $val2)){
                unset($_REQUEST[$key]);
                #unset($_SESSION);
                #unset($_COOKIE);
                #unset($_ENV);
                header("location: ".$rootURL.$to_page);
                exit;
            }
        }
    }
	
}

function urlsafe_b64encode($string) {

	$data = base64_encode(gzcompress(serialize($string),9));
    $data = str_replace(array('+','/','='),array('-','_',''),$data);
    return $data;

}

function urlsafe_b64decode($string) {

    $data = str_replace(array('-','_'),array('+','/'),$string);
    $mod4 = strlen($data) % 4;
    if ($mod4) {
        $data .= substr('====', $mod4);
    }

	return unserialize(gzuncompress(stripslashes(base64_decode($data))));
}

function menu($title){
		global $db, $rootURL;
		$Menu = "";
		$query = $db->select("select *, DATE_FORMAT(datum,'%d-%m-%Y') AS datum from portfolio_cat where taalid=".$_SESSION['taal']['id']." order by datum desc");
		
		if($db->get_rows($query, 'MYSQL_ASSOC')){
			while($r = $db->get_row($query, 'MYSQL_ASSOC')) {
				
				$htmllink = make_html_link( $r['titel'] ) ;
				$strURL = "href=\"".$rootURL."portfolio/".$htmllink.".html"."\"";
				$HighClassM = '';
				if(isset($title) && $title==$r['titel']) $HighClassM = 'class="MegaMenuSeccond"';
		
				$Menu .= "<li><a $strURL $HighClassM >".htmlentities(stripslashes(substr(ucfirst($r['titel']),0,1)), ENT_QUOTES, "UTF-8")."".htmlentities(stripslashes(substr($r['titel'],1)), ENT_QUOTES, "UTF-8")."</a></li>";
                
			}
		
		}
		
		return $Menu;
	}
function menu_case($array, $names, $id = "", $hmn = "" ){
	global $db, $rootURL, $menu_naam;
	$crumb = "";
#	if(isset($menu_naam[0])) $crumb = strtolower($menu_naam[0]);
#	if(isset($menu_naam[1])) $crumb .= strtolower($menu_naam[1]);
	$htmllink = make_html_link( $array[$names[0]] ) ;

	if($id){
		switch ($array[$names[1]])
		{
			case "geen":
				$strURL = "#";
				$strOnClick = "";
				break;
			case "portfolio":
				$query = $db->select("select titel from portfolio_cat where id=".$array[$names[5]]."");
				$row = $db->get_row($query, 'MYSQL_ASSOC');

				if(@$_SESSION['portfolio_x'][0]+@$_SESSION['portfolio_x'][1]+@$_SESSION['portfolio_x'][2]<>0)
				$_SESSION['portfolio_cat'][$array[$names[5]]] = "onclick=\"hs_id('".@$_SESSION['portfolio_x'][0]."','".@$_SESSION['portfolio_x'][1]."','".@$_SESSION['portfolio_x'][2]."','".$rootURL."include/menu_ajax.php"."')\"";

				$htmllink = make_html_link( $row['titel'] ) ;
				$strURL = $rootURL.$crumb."portfolio/0/".$htmllink.".html";
				break;
			case "fotoalbum":
				$query = $db->select("select header from album where id=".$array[$names[5]]."");
				$row = $db->get_row($query, 'MYSQL_ASSOC');
			
				$htmllink = make_html_link( $row['header'] ) ;
				$strURL = $rootURL.$crumb."fotoalbum/".$htmllink.".html";
				break;
			case "artikel":
				if(test_table("shop_producten")){
					
					$query = $db->select("select titel from shop_producten where id=".$array[$names[5]]."");
					$row = $db->get_row($query, 'MYSQL_ASSOC');
					$htmllink = make_html_link( $row['titel'] ) ;
					$strURL = $rootURL.$crumb."shop/view/".$array[$names[5]]."/".$htmllink.".html";
				}else{
					$strURL = "#";
				}
				
				break;
			case "url":
				if(substr($array[$names[3]],0,4)=="http"){
					$strURL = $array[$names[3]];
					$blank = 'target="_blank" ';
				}else{
					$strURL = $rootURL.$crumb.$array[$names[3]]; // deze voor hid & sid gebruiken en in .htaccess aanpassen
				}

				break;
			case "tekst":
				$query = $db->select("select url,hoofdmenu from hoofdmenus where id=".$_SESSION['hid']."");
				$row = $db->get_row($query, 'MYSQL_ASSOC');

				if($row['url']=='infoplus/') $tekstpath = $row['url']; else $tekstpath = str_replace('+','-', urlencode(strtolower($hmn))).'/'; // $row['hoofdmenu']
				
				if ($array[$names[4]] == "J"){
					$strURL = $rootURL;
				}else{ //".$array[$names[5]]."/
					$query = $db->select("select paginatitel from paginas where paginaid=".$array[$names[5]]."");
					$row = $db->get_row($query, 'MYSQL_ASSOC');

					$htmllink = make_html_link( $row['paginatitel'] ) ;
					$strURL = $rootURL.$crumb.$tekstpath.$htmllink.".html";
				}
				break;					
		}
	}else{
		switch ($array[$names[1]])
		{
			case "geen":
				$strURL = "href=\"#\"";
				$strOnClick = "";
				break;
			case "portfolio":
				$query = $db->select("select titel from portfolio_cat where id=".$array[$names[5]]."");
				$row = $db->get_row($query, 'MYSQL_ASSOC');

				if($_SESSION['portfolio_x'][0]+$_SESSION['portfolio_x'][1]+$_SESSION['portfolio_x'][2]<>0)
				$_SESSION['portfolio_cat'][$array[$names[5]]] = "onclick=\"hs_id('".@$_SESSION['portfolio_x'][0]."','".@$_SESSION['portfolio_x'][1]."','".@$_SESSION['portfolio_x'][2]."','".$rootURL."include/menu_ajax.php"."')\"";

				$htmllink = make_html_link( $row['titel'] ) ;
				$strURL = "href=\"".$rootURL.$crumb."portfolio/0/".$htmllink.".html"."\"";
				break;
			case "fotoalbum":
				$query = $db->select("select header from album where id=".$array[$names[5]]."");
				$row = $db->get_row($query, 'MYSQL_ASSOC');

				$htmllink = make_html_link( $row['header'] ) ;
				$strURL = "href=\"".$rootURL.$crumb."fotoalbum/".$htmllink.".html"."\"";
				break;
			case "artikel":
				if(test_table("shop_producten")){
				
					$query = $db->select("select titel from shop_producten where id=".$array[$names[5]]."");
					$row = $db->get_row($query, 'MYSQL_ASSOC');
					$htmllink = make_html_link( $row['titel'] ) ;
					$strURL = "href=\"".$rootURL.$crumb."shop/view/".$array[$names[5]]."/".$htmllink.".html"."\"";
				}else{
					$strURL = "href=\"#\"";
				}	
				break;
			case "url":
				if(substr($array[$names[2]],0,4)=="http"){
					$strURL = "href=\"".$array[$names[2]]."\"";
					$blank = 'target="_blank" ';
				}else{
					$strURL = "href=\"".$rootURL.$crumb.$array[$names[2]]."\"";
				}
			
				break;
			case "tekst":
				$query = $db->select("select url, hoofdmenu from hoofdmenus where id=".$array[$names[4]]."");
				$row = $db->get_row($query, 'MYSQL_ASSOC');

				
				if($row['url']=='infoplus/') $tekstpath = $row['url']; elseif($hmn!="") $tekstpath =  str_replace('+','-', urlencode(strtolower($hmn))).'/'; // $row['hoofdmenu']
				
				if ($array[$names[3]] == "J"){
					$strURL = "href=\"".$rootURL."\"";
				}else{ // ".$array[$names[5]]."/
					$query = $db->select("select paginatitel from paginas where paginaid=".$array[$names[5]]."");
					$row = $db->get_row($query, 'MYSQL_ASSOC');
					$htmllink = make_html_link( $row['paginatitel'] ) ;
				
					$strURL = "href=\"".$rootURL.$crumb.$tekstpath.$htmllink.".html"."\"";
				}
				break;					
		}
	}

	return $strURL;
}


function responsivemenu($taalid, $u_header__section, $option){
	
	global $db, $rootURL, $shop_actief;
	$params = $u_header__section[$option];
	$params['nav-link'] = $u_header__section['sub-nav-link'];
	
	if($u_header__section['menu']==2){
		 
		 $u_header__section['div-ul'] = str_replace('u-main-nav-v1','u-main-nav-v'.$option, $u_header__section['div-ul']) ;
		 
		 if($option==6){
		 	 $u_header__section['nav-link'] = str_replace('g-mx-2--md g-mx-5--xl g-mb-5 g-mb-0--lg','g-mb-5 g-mb-0--lg', $u_header__section['nav-link']) ;
		 	 $u_header__section['nav-item'] = str_replace('g-mx-2--md g-mx-5--xl g-mb-5 g-mb-0--lg','g-mb-5 g-mb-0--lg', $u_header__section['nav-item']) ;
		 	 $u_header__section['sub-menu'] = '' ;
		}	 
	}
	
	$aq = "";
    if($shop_actief!=true ) $aq = " && url!='shop/'";
    $query = $db->select("select id, hoofdmenu, soortlink as hsoortlink, url as hurl, paginaid as hpaginaid, homepage as hhomepage
			              from hoofdmenus where taalid=".$taalid." $aq order by volgnummer asc, hoofdmenu asc");
                          
    if($db->get_rows($query, 'MYSQL_ASSOC')){
		
		$menu_item = $u_header__section['div-ul'];
		
    	while ($row = $db->get_row($query, 'MYSQL_ASSOC')) 
    	{
    		
    		$strURL = menu_case($row, array( '0' => 'hoofdmenu', '1' => 'hsoortlink' ,'2' => 'hurl', '3' => 'hhomepage', '4' => 'id', '5' => 'hpaginaid' ));
    		
    		if(isset($_SESSION['hid']) && $_SESSION['hid']==$row['id']) $HighClassM = 'active'; else $HighClassM = '';
			
    		if(strtolower($row['hhomepage'])=='j'){
    			if(isset($_SESSION['hid']) && $_SESSION['hid']==0 ) $HighClassM = 'active';
    			$menu_item .= '	<li class="nav-item '.$HighClassM.' '.$u_header__section['nav-item'].'" data-animation-in="fadeIn" data-animation-out="fadeOut" data-max-width="60%" data-position="left">
    								<a id="mega-menu-home" class="nav-link '.$u_header__section['nav-link'].'" aria-haspopup="true" aria-expanded="false" href="'.$rootURL.'" onclick="hs_id(\'0\',\'0\',\'0\',\''.$rootURL.'include/menu_ajax.php\')" >Home</a>
								</li>';
			}else{
			
				$menu_item_new = responsiveSmenu($row['id'], $row['hoofdmenu'], $params );
	            
	            if($menu_item_new==""){
	            	$menu_item .= '	<li class="nav-item '.$HighClassM.' '.$u_header__section['nav-item'].'">
								  		<a '.$strURL.'  class="nav-link '.$u_header__section['nav-link'].'" onclick="hs_id(\''.$row['id'].'\',\'0\',\'0\',\''.$rootURL.'include/menu_ajax.php\')"  >'.htmlentities(stripslashes($row['hoofdmenu']), ENT_QUOTES, "UTF-8").'</a>
									</li>';
		            
				}else{
					
					
					$class_name= make_html_link( htmlentities(stripslashes($row['hoofdmenu']), ENT_QUOTES, "UTF-8"));
					
					$menu_item .= '<li class="nav-item '.$HighClassM.' hs-has-sub-menu '.$u_header__section['nav-item'].'" data-animation-in="fadeIn" data-animation-out="fadeOut">
									  <a id="nav-link--'.$class_name.'" class="nav-link '.$u_header__section['nav-link'].'" href="#" aria-haspopup="true" aria-expanded="false" aria-controls="nav-submenu--'.$class_name.'">'.htmlentities(stripslashes($row['hoofdmenu']), ENT_QUOTES, "UTF-8").'</a>
									  <ul class="hs-sub-menu list-unstyled '.$params[0].' '.$params[2].' '.$u_header__section['sub-menu'].'" id="nav-submenu--'.$class_name.'" aria-labelledby="nav-link--'.$class_name.'" '.$params[3].'>';
									 
					$menu_item .= $menu_item_new;
		            
		            $menu_item .= '		</ul>';
		            $menu_item .= '</li>';

		          	
				}
	            
				
			}
    	
        }
        $menu_item .= "		</ul>
        				</div>";
    }
            

    return $menu_item;	
	
}
function responsiveSmenu($hid, $hmn ="", $u_header__section){
    global $db, $rootURL, $shop_actief;
    
    $class_name= make_html_link( htmlentities(stripslashes($hmn), ENT_QUOTES, "UTF-8"));
    
    $menu_item = "";

	$aq = "";
    if($shop_actief!=true ) $aq = " && url!='shop/'";

	$query = $db->select("select ifnull(id, '0') as submenuid, submenu, soortlink as ssoortlink, url as surl, paginaid as spaginaid, homepage as shomepage 
				          from submenus where hoofdmenuid=".$hid." $aq order by volgnummer asc");

    if($db->get_rows($query, 'MYSQL_ASSOC')){
		
        while ($row = $db->get_row($query, 'MYSQL_ASSOC')) 
    	{
    		$_SESSION['portfolio_x'][1] = $row['submenuid'];
        	$strURL = menu_case($row, array( '0' => 'submenu', '1' => 'ssoortlink' ,'2' => 'submenuid', '3' => 'surl', '4' => 'shomepage', '5' => 'spaginaid' ), $hid, $hmn);
    
			if(isset($_SESSION['sid']) && $_SESSION['sid']==$row['submenuid']) $HighClassM = 'active'; else $HighClassM = '';
			$class_name2 =  make_html_link( htmlentities(stripslashes($row['submenu'])));
            
            $menu_item_new = responsiveXmenu($hid, $row['submenuid'], $hmn, $u_header__section);
            
            
            if($menu_item_new==""){
				
		        $menu_item .= '	<li class="dropdown-item '.$HighClassM.'">
									<a class="'.$u_header__section['nav-link'].'" onclick="hs_id(\''.$hid.'\',\''.$row['submenuid'].'\',\'0\',\''.$rootURL.'include/menu_ajax.php\')" href="'.$strURL.'">'.htmlentities(stripslashes($row['submenu'])).'</a>
								</li>';
                
			}else{
				
				$menu_item .='<li class="dropdown-item hs-has-sub-menu '.$HighClassM.'">
								  <a id="nav-link--'.$class_name.'--'.$class_name2.'" class="'.$u_header__section['nav-link'].'" href="#" aria-haspopup="true" aria-expanded="false" aria-controls="nav-submenu--'.$class_name.'--'.$class_name2.'">'.htmlentities(stripslashes($row['submenu'])).'</a>								  
								  <ul class="hs-sub-menu list-unstyled '.$u_header__section[0].' '.$u_header__section[2].' g-brd-top g-brd-primary g-brd-top-2 g-min-width-220 g-mt-minus-2" '.$u_header__section[3].' id="nav-submenu--'.$class_name.'--'.$class_name2.'" aria-labelledby="nav-link--'.$class_name.'--'.$class_name2.'" >
								  	'.$menu_item_new.'	
								  </ul>
								</li>';
				
			}
			
            
        }    
        
    }
    return $menu_item;    
}
	
function responsiveXmenu($hid, $sid, $hmn="", $u_header__section){
    global $db, $rootURL, $shop_actief;
    $menu_item = "";
	$aq = "";
    if($shop_actief!=true ) $aq = " && url!='shop/'";

    $query = $db->select("select ifnull(id, '0') as submenuid, submenu, soortlink as ssoortlink, url as surl, paginaid as spaginaid, homepage as shomepage 
			              from extramenus where hoofdmenuid=".$sid." $aq order by volgnummer asc");


	if($db->get_rows($query, 'MYSQL_ASSOC')){ 

    	while ($row = $db->get_row($query, 'MYSQL_ASSOC')) 
    	{
			$_SESSION['portfolio_x'][1] = $row['submenuid'];
			$strURL = menu_case($row, array( '0' => 'submenu', '1' => 'ssoortlink' ,'2' => 'submenuid', '3' => 'surl', '4' => 'shomepage', '5' => 'spaginaid' ), $row['submenuid'],$hmn);
		
			
			if(isset($_SESSION['xid']) && $_SESSION['xid']==$row['submenuid']) $HighClassM = 'active'; else $HighClassM = '';
			$menu_item .= '<li class="dropdown-item '.$HighClassM.'">
					           <a class="'.$u_header__section['nav-link'].'" onclick="hs_id(\''.$hid.'\',\''.$sid.'\',\''.$row['submenuid'].'\',\''.$rootURL.'include/menu_ajax.php\')" href="'.$strURL.'">'.htmlentities(stripslashes($row['submenu']), ENT_QUOTES, "UTF-8").'</a>
					        </li>';
			
		}

    }		

    
    return $menu_item;    
}

function hoofdmenu($taalid, $type = false, $param = true){
    global $db, $rootURL;
    $menu_item = "";

	$query = $db->select("select id, hoofdmenu, soortlink as hsoortlink, url as hurl, paginaid as hpaginaid, homepage as hhomepage
			              from hoofdmenus where taalid=".$taalid." order by volgnummer asc, hoofdmenu asc");
                          
    if($db->get_rows($query, 'MYSQL_ASSOC')){
#        $menu_item .= "<ul >";

    	while ($row = $db->get_row($query, 'MYSQL_ASSOC')) 
    	{
    	
    		$strURL = menu_case($row, array( '0' => 'hoofdmenu', '1' => 'hsoortlink' ,'2' => 'hurl', '3' => 'hhomepage', '4' => 'id', '5' => 'hpaginaid' ));
    		$HighClassM = '';
			if(isset($_SESSION['hid']) && $_SESSION['hid']==$row['id']) $HighClassM = 'class="MegaMenuFirst"';
		
            $menu_item .= "<li >";
            if($type == true && $param == true){
                $menu_item .= "    <a $strURL $HighClassM onclick=\"showHide('extended_menu".$row['id']."');hs_id('".$row['id']."','0','0','".$rootURL."include/menu_ajax.php"."')\">". htmlentities(stripslashes($row['hoofdmenu']), ENT_QUOTES, "UTF-8")."</a>";
            }else{
                $menu_item .= "    <a $strURL $HighClassM onclick=\"hs_id('".$row['id']."','0','0','".$rootURL."include/menu_ajax.php"."')\">". htmlentities(stripslashes($row['hoofdmenu']), ENT_QUOTES, "UTF-8")."</a>";
            }    
            if($param == true) $menu_item .= submenu($row['id'], $type, $param, $row['hoofdmenu'] );
                
            $menu_item .= "</li>";
    	
        }
#        $menu_item .= "</ul>";
    }
            

    return $menu_item;
}

function submenu($hid, $type = false, $param = true, $hmn =""){
    global $db, $rootURL;
    $menu_item = "";

	$query = $db->select("select ifnull(id, '0') as submenuid, submenu, soortlink as ssoortlink, url as surl, paginaid as spaginaid, homepage as shomepage 
				          from submenus where hoofdmenuid=".$hid." order by volgnummer asc");

    if($db->get_rows($query, 'MYSQL_ASSOC')){
    
        if($type == true && $param == true){ 
            $menu_item .= "<div id=\"extended_menu".$hid."\" class=\"hide\"><ul >";
        }elseif($param == true){
            $menu_item .= "<ul >";
        }
    	while ($row = $db->get_row($query, 'MYSQL_ASSOC')) 
    	{
    	
        	$strURL = menu_case($row, array( '0' => 'submenu', '1' => 'ssoortlink' ,'2' => 'submenuid', '3' => 'surl', '4' => 'shomepage', '5' => 'spaginaid' ), $hid, $hmn);
    
            $menu_item .= "<li >";
        
            $HighClassM = '';
			if(isset($_SESSION['sid']) && $_SESSION['sid']==$row['submenuid']) $HighClassM = 'class="MegaMenuSeccond"';
		
            $menu_item .= "<a $HighClassM href=\"$strURL\" onclick=\"hs_id('".$hid."','".$row['submenuid']."','0','".$rootURL."include/menu_ajax.php"."')\">".htmlentities(stripslashes(substr(ucfirst($row['submenu']),0,1)), ENT_QUOTES, "UTF-8")."".htmlentities(stripslashes(substr($row['submenu'],1)), ENT_QUOTES, "UTF-8")."</a>";
            
            $menu_item .= extramenu($hid, $row['submenuid'], $hmn);
                
            $menu_item .= "</li>";
        
        }    
        if($type == true && $param == true){ 
            $menu_item .= "</ul></div>";
        }elseif($param == true){
            $menu_item .= "</ul>";
        }    
    }
    return $menu_item;    
}

function extramenu($hid, $sid, $hmn=""){
    global $db, $rootURL;
    $menu_item = "";

    $query = $db->select("select ifnull(id, '0') as submenuid, submenu, soortlink as ssoortlink, url as surl, paginaid as spaginaid, homepage as shomepage 
			              from extramenus where hoofdmenuid=".$sid." order by volgnummer asc");


	if($db->get_rows($query, 'MYSQL_ASSOC')){ 

		$menu_item .= "<ul >"; 

    	while ($row = $db->get_row($query, 'MYSQL_ASSOC')) 
    	{

			$strURL = menu_case($row, array( '0' => 'submenu', '1' => 'ssoortlink' ,'2' => 'submenuid', '3' => 'surl', '4' => 'shomepage', '5' => 'spaginaid' ), $row['submenuid'],$hmn);
		
			$HighClassM = '';
			if(isset($_SESSION['xid']) && $_SESSION['xid']==$row['submenuid']) $HighClassM = 'class="MegaMenuThird"';
		
            $menu_item .= "<li ><a $HighClassM href=\"$strURL\" onclick=\"hs_id('".$hid."','".$sid."','".$row['submenuid']."','".$rootURL."include/menu_ajax.php"."')\">".htmlentities(stripslashes(substr(ucfirst($row['submenu']),0,1)), ENT_QUOTES, "UTF-8")."".htmlentities(stripslashes(substr($row['submenu'],1)), ENT_QUOTES, "UTF-8")."</a></li >";
            
		}
        $menu_item .= "</ul>";
    }		

    
    return $menu_item;    
}

function sitemap( $taalid = 1 ){
	global $rootURL, $hid, $sid, $menu_naam;
		$position = 1;
		$strSql = "select id, hoofdmenu, soortlink as hsoortlink, url as hurl, paginaid as hpaginaid, homepage as hhomepage
					from hoofdmenus where taalid=".$taalid." order by volgnummer asc, hoofdmenu asc";
	
		$query = mysql_query($strSql) or die(mysql_error());
		
		$retValue = "";
	
		while($r = mysql_fetch_assoc($query))
		{
			$hoofdmenu 	= stripslashes($r['hoofdmenu']);
			$htmllink	= make_html_link($r['hoofdmenu']);
			switch ($r['hsoortlink'])
			{
				case "geen":
					$strURL = "href=\"#\"";
					break;
				case "url":
					$strURL = "href=\"".$rootURL.$r['hurl']."\"";

					break;
				case "portfolio":
					$c_query = mysql_query("select titel from portfolio_cat where id=".$r['hpaginaid']."") or die(mysql_error());
					$c_row = mysql_fetch_assoc($c_query);
	
					$htmllink = make_html_link( $c_row['titel'] ) ;
				
					$strURL = "href=\"".$rootURL."portfolio/".$htmllink.".html"."\"";;
					break;
				case "tekst":
					if ($r['hhomepage'] == "J")
					{
						$strURL = "href=\"".$rootURL."\"";
					}else{
						$n_query = mysql_query("select paginatitel from paginas where paginaid='".$r['hpaginaid']."'" ) or die(mysql_error());
						$row = mysql_fetch_assoc($n_query);
						$htmllink = make_html_link( $row['paginatitel'] ) ;

						$strURL = "href=\"".$rootURL."informatie/".$r['hpaginaid']."/".$htmllink.".html"."\"";
					}
					break;					
			}

			$retValue .= "<li><a title='".$r['hoofdmenu']."' $strURL onclick=\"hs_id('".$r['id']."','0','0','".$rootURL."include/menu_ajax.php"."')\" >". htmlentities(stripslashes($r['hoofdmenu']), ENT_QUOTES)."</a>";

			$strSql2 = "select ifnull(id, '0') as submenuid, submenu, soortlink as ssoortlink, url as surl, paginaid as spaginaid, homepage as shomepage 
						from submenus
						where hoofdmenuid=".$r['id']." order by volgnummer asc";
		
			$query2 = mysql_query($strSql2) or die(mysql_error());

			if( mysql_num_rows($query2)!=0){ 
	
				$retValue .= "<ul >\n"; 
				while($r2 = mysql_fetch_assoc($query2))
				{
				
					$htmllink	= make_html_link($r2['submenu']);
					switch ($r2['ssoortlink'])
					{
						case "geen":
							$strURL = "#";
							break;
						case "url":
							$strURL = $rootURL.$r2['surl'];
							break;
						case "portfolio":

							$c_query = mysql_query("select titel from portfolio_cat where id=".$r2['spaginaid']."") or die(mysql_error());
							$c_row = mysql_fetch_assoc($c_query);
			
							$htmllink = make_html_link( $c_row['titel'] ) ;
						
							$strURL = $rootURL."portfolio/".$htmllink.".html";
							break;
						case "tekst":
							if ($r2['shomepage'] == "J")
							{
								$strURL = $rootURL;
							}
							else
							{
								$n_query = mysql_query("select paginatitel from paginas where paginaid='".$r2['spaginaid']."'" ) or die(mysql_error());
								$row = mysql_fetch_assoc($n_query);
								$htmllink = make_html_link( $row['paginatitel'] ) ;								
								$strURL = $rootURL."informatie/".$htmllink.".html";
							}
							break;					
					}
					
			
					$strSql3 = "select ifnull(id, '0') as submenuid, submenu, soortlink as ssoortlink, url as surl, paginaid as spaginaid, homepage as shomepage 
								from extramenus
								where hoofdmenuid=".$r2['submenuid']." order by volgnummer asc";

					$query3 = mysql_query($strSql3) or die(mysql_error());

					if(mysql_num_rows($query3)!=0){ 
	
						$retValue .= "<li><a title='".$r2['submenu']."' href=\"$strURL\" onclick=\"hs_id('".$r['id']."','".$r2['submenuid']."','0','".$rootURL."include/menu_ajax.php"."')\" >".htmlentities(stripslashes($r2['submenu']), ENT_QUOTES)."</a>";
						$retValue .= "<ul >"; 

						while($r3 = mysql_fetch_assoc($query3))
						{
								$htmllink	= make_html_link($r3['submenu']);
						
								switch ($r3['ssoortlink'])
								{
									case "geen":
										$strURL = "#";
										break;
									case "url":
										$strURL = $rootURL.$r3['surl'];
										break;
									case "portfolio":
										$c_query = mysql_query("select titel from portfolio_cat where id=".$r3['spaginaid']."") or die(mysql_error());
										$c_row = mysql_fetch_assoc($c_query);
						
										$htmllink = make_html_link( $c_row['titel'] ) ;
									
										$strURL = $rootURL."portfolio/".$htmllink.".html";;
										break;
									case "tekst":
										if ($r2['shomepage'] == "J")
										{
											$strURL = $rootURL;
										}
										else
										{
											$n_query = mysql_query("select paginatitel from paginas where paginaid='".$r3['spaginaid']."'" ) or die(mysql_error());
											$row = mysql_fetch_assoc($n_query);
											$htmllink = make_html_link( $row['paginatitel'] ) ;
											$strURL = $rootURL."informatie/".$htmllink.".html";
										}
										break;					
								}
								
								$retValue .= "<li><a title='".$r3['submenu']."' href=\"$strURL\" onclick=\"hs_id('".$r['id']."','".$r2['submenuid']."','". $r3['submenuid']."','".$rootURL."include/menu_ajax.php"."')\" >".htmlentities(stripslashes($r3['submenu']), ENT_QUOTES)."</a>";
						}
						
						$retValue .= "</ul></li>"; 
	
	
					}else{
						$retValue .= "<li><a title='".$r2['submenu']."' href=\"$strURL\" onclick=\"hs_id('".$r['id']."','".$r2['submenuid']."','0','".$rootURL."include/menu_ajax.php"."')\">".htmlentities(stripslashes($r2['submenu']), ENT_QUOTES)."</a>";
					
						$retValue .= "</li>"; 
					}
				
				
				}

				$retValue .= "</ul></li>"; 

			}else{

				$retValue .= "</li>"; 

			}

			$position++;
		}
		
	return $retValue;
}

function get_crumbs($menu, $submenu ){
	global $rootURL;
	$strSql = "select id, hoofdmenu, soortlink as hsoortlink, url as hurl, paginaid as hpaginaid, homepage as hhomepage	from hoofdmenus where id=".$menu;
	$query = mysql_query($strSql) or die(mysql_error());

	$r = mysql_fetch_assoc($query);

	$strURL = menu_case($r, array( '0' => 'hoofdmenu', '1' => 'hsoortlink' ,'2' => 'hurl', '3' => 'hhomepage', '4' => 'id', '5' => 'hpaginaid' ));

	$retValue = "&nbsp;&raquo; <a style=\"text-decoration:none;color:#000000\" $strURL >".htmlentities(stripslashes($r[hoofdmenu]), ENT_QUOTES, "UTF-8")."</a>";

	$strSql2 = "select ifnull(id, '0') as submenuid, submenu, soortlink as ssoortlink, url as surl, paginaid as spaginaid, homepage as shomepage 
				from submenus
				where paginaid=".$submenu;
	$query2 = mysql_query($strSql2) or die(mysql_error());
	if(mysql_num_rows($query2)){
		$r2 = mysql_fetch_assoc($query2);

		$strURL = menu_case($r2, array( '0' => 'submenu', '1' => 'ssoortlink' ,'2' => 'submenuid', '3' => 'surl', '4' => 'shomepage', '5' => 'spaginaid' ), $menu);
		$retValue .= "&nbsp;&raquo; <a style=\"text-decoration:none;color:#000000\" href=\"$strURL\" >".htmlentities(stripslashes($r2[submenu]), ENT_QUOTES, "UTF-8")."</a>";

	}
	return $retValue;
}			

function makethumb($foto, $resize=80)
{
	global $uploadDir;
	
	$src = "$uploadDir/$foto";
	$des = "$uploadDir/thumbs/$foto";
	
	$cp = copy($src, $des);
	if ($cp)
	{
		exec("mogrify -resize $resize $des");
	}
	else
	{
		echo "fout"; exit;
	}
}

function make_html_link( $titel, $makelowercase = true )
{

	$html_link=preg_replace("/[^A-Z0-9_\.]+/i", "-", $titel);
	$html_link=preg_replace("/_{2,}/", "-", $html_link);

	if($makelowercase==true) $html_link = strtolower( $html_link );

	return $html_link;
}
 
function mailFriend($no, $eo, $url)
{
	global $rootURL, $adminmail;
	
	$root = substr($rootURL, 0, (strlen($rootURL)-1));

	if ($no and $eo and $url)
	{
		$ev = $admin;
		$nv = getTekst("strTxtSitenaam");
		
		$mailBody = file_get_contents("../templates/mail_friend_".$_SESSION['taal']['code'].".html", False);
		$mailBody = str_replace("[title]", getTekst("strTxtSitenaam"), $mailBody);
		$mailBody = str_replace("[sitenaam]", getTekst("strTxtSitenaam"), $mailBody);
		$mailBody = str_replace("[rootPath]", $root, $mailBody);
		$mailBody = str_replace("[url]", $url, $mailBody);
		$mailBody = str_replace("[naam_ontvanger]", $no, $mailBody);
		$mailBody = str_replace("[email_ontvanger]", $eo, $mailBody);
		$text = strip_tags($mailBody);
		
		include_once($rootDir."classes/PHPMailer/PHPMailerAutoload.php");
			
		$mail = new phpmailer();
		
		if(_MAIL_AUTH==true){
		
			$mail->isSMTP();
			
			$mail->Host     	= _MAIL_HOST;
			$mail->Port       	= _MAIL_PORT;     // set the SMTP port for the MAIL server
			$mail->SMTPAuth   	= _MAIL_AUTH;     // enable SMTP authentication
			$mail->Username   	= _MAIL_USER;	  // SMTP account username
			$mail->Password   	= _MAIL_PASS;     // SMTP account password
		
		}
				
		$mail->From     = $ev;
		$mail->FromName = $nv;
		$mail->Subject  = 'Interessante pagina voor u op '.getTekst("strTxtSitenaam");
		
		$mail->Body    = $mailBody;
		$mail->AltBody = $text;
		
		$mail->AddAddress($eo, $no);
	
		$retValue = $mail->Send();
		
		if(!$retValue)
		{
			echo "Er is een fout opgetreden bij het versturen van de het bericht.<br>";	
		}
	
		$mail->ClearAddresses();
		$mail->ClearAttachments();
	
		return $retValue;
	}
	else
	{
		return false;
	}
}

# Controleerd of een waarde leeg is en vervangt deze dan met de opgegeven waarde
function nvl($value, $repValue)
{
	if ($value == "")
	{
		$retValue = $repValue;
	}
	else
	{
		$retValue = $value;
	}
	
	return $retValue;
}

function getTekst($tekstcode)
{
	$tekstcodeL = strtolower($tekstcode);

	if (isset($_SESSION["taal"][$tekstcodeL]) && $_SESSION["taal"][$tekstcodeL])
	{
		return convert_utf8( $_SESSION['taal'][$tekstcodeL] );
	}
	else
	{
		return "$tekstcode";
	}
}

function showTekst($tekstcode)
{
	$tekstcode = strtolower($tekstcode);
	
	echo $_SESSION['taal'][$tekstcode];
}

function selectTalen($taalid)
{
	?>
	<select name="taalid" size="1" onchange="submit()">
	
	<?
	$query = mysql_query("select t.id, t.taal
						from talen t 
						order by taal asc") or die(mysql_error());
	while ($r = mysql_fetch_array($query))
	{
		if ($r[id] == $taalid)
		{
			$temp = " selected";
		}
		else
		{
			$temp = "";
		}
		?>
		<option value="