<?php	// *** Index
	// *** Copyright DesignConsult (www.designconsult.nl), all rights reserved

	// *** Offline halen voor een domein: if($_SERVER['SERVER_NAME'] == "www.foreverlamp.eu") die("Nog niet online, kom aub later terug!");
	session_start();
	
	include("./admin/databaseconnectie.php");

	function errorDie($message)
	{

		$errorHeader = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
 <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  <title>bizzerd | Persoon niet gevonden</title>
  <meta name="viewport" content="width=device-width, initial-scale=1.0"/>
  <style>
  .image img{
		width:60%
	}
  @media screen and (min-width: 640px) {
	.image img{
		width:40%
	}
  }
  </style>
   <link rel="shortcut icon" type="image/png" href="/favicon.png"/>
  <style type="text/css">@font-face{font-family: "Neo Tech Std Bold";src:url("https://easy.myfonts.net/v2/woff2?4iq1eMNtUGgJ6G40S8kp4TvvqB70kLeYZT5iQRiZuR&Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cCo6Ly8qL3YyL3dvZmYyPzRpcTFlTU50VUdnSjZHNDBTOGtwNFR2dnFCNzBrTGVZWlQ1aVFSaVp1UiIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTQ4MzgzMzYwMH19fV19&Signature=J4Q6qABQUJK-BjCfVA6flPsMgH2FHJjR7myZksDzzLwkQOmQ7Exgjjr-GFHrQJ3lwVQcUIaHiWcBqPFBebXED1bXxLUQuPC6xD4FkILNZWNMoHS1-YwmZB3w~r16wMqCM3oVGrns1k9kPnP6x~s~OMuP0sDsyZOwBx8uzQoX2L-fgLlKxUqESXIEKGr0LNux6EgCZSBNdOjK9jvTIHYShi66cKjb5X3KQ2NNf~f-28oOpmtgtbulbfg1KquIYGv4muU43hp5aBZB9w0Kx-eCIhLI8nVFd-Y~Zv-C1xfYItECwE0G9o-ewfveze~83PLaLFb~EKxlW2t1aU9c35nxhQ__&Key-Pair-Id=APKAJN6QFZEE4BZCL6XQ")format("woff2");}@font-face{font-family: "Neo Tech Std Light";src:url("https://easy.myfonts.net/v2/woff2?4iq1eMNtUGgJ6G40S8kp4iIkOUsj15ubjN5KIpK5jH&Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cCo6Ly8qL3YyL3dvZmYyPzRpcTFlTU50VUdnSjZHNDBTOGtwNGlJa09Vc2oxNXViak41S0lwSzVqSCIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTQ4NDA5MjgwMH19fV19&Signature=MBoDvBKme9nFNlXOVg6KL-vkHHRBzf9H5K9MuEOzs8ffh~~6dRAm1STC8LUkWYBRgLSoUTyETwimtKTZsWakGLGBpFmQU9gmwNvcuNMNlh3KFkrFyRLbt~z7I5cW4MI29IEOGgDLwpXygokt250yWelyQ4o~SiZK0AB8TIeiXSCfcQ~Vyc7JUuGC~u7goJxmiXXuhs8deX5YDBkBX8AG0vyGRKP6fH7tbujT-ux9ujQ6K8U7qsakoyFHSl4KKLP~-4eYC1tXWitIG5BxKXmwpVKrVs0g7DsW2ukoLRm6Ul5V-M30lXI0obAYpr~rtMAR8IIYH8fNWhCTHjY~t5O~rA__&Key-Pair-Id=APKAJN6QFZEE4BZCL6XQ")format("woff2");}@font-face{font-family: "Neo Tech Std Medium";src:url("https://easy.myfonts.net/v2/woff2?4iq1eMNtUGgJ6G40S8kp41KMnTRSKr8SFf6YfcZcKl&Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cCo6Ly8qL3YyL3dvZmYyPzRpcTFlTU50VUdnSjZHNDBTOGtwNDFLTW5UUlNLcjhTRmY2WWZjWmNLbCIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTQ4NDAwNjQwMH19fV19&Signature=VYSlw-TD3GFYAvkHBT9Naa03gPBNBUGKbi23EL-ECucJbaBY3e28aq2wlbLXrHQf0oGUjSzXiLP2eAGGDvaYWpYGgfYA8tJHMN8z8mVGPufXazdeL3jhfedCv5m7LuQ9Vh4154si2AIPN-RiJM4YhfpEMppUbSCQ0mi~E4cH9bmmsTOY0DsvqnOT9PNNoriLpEm7V4wEgiLPwqaW-a-bEbPlGD9NQ39iPP8bDVDpo5xuJ2VNhqpr0yDiADxhC8OU7FLPtnt2kqJ-bV5t6QIA6cW-23nl9mynsptsj6xgIELLHE1BiFAMb-9zNdnpFX9b8WtoNvZDwb1UwyUgL7EBOg__&Key-Pair-Id=APKAJN6QFZEE4BZCL6XQ")format("woff2");}@font-face{font-family: "Neo Tech Std Regular";src:url( https://easy.myfonts.net/v2/woff2?4iq1eMNtUGgJ6G40S8kp4FdBLnHEXbOVPZ6AY4B89b&Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cCo6Ly8qL3YyL3dvZmYyPzRpcTFlTU50VUdnSjZHNDBTOGtwNEZkQkxuSEVYYk9WUFo2QVk0Qjg5YiIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTQ4MzY2MDgwMH19fV19&Signature=tc5DHfWEIlZumaCVIqbHdIdTPnMpzJc4hADyEMzXVhysu1fdkQInQE~ItTmSuuxnXeoW33u1odSdNQCLwTdwzjdlF-664DOSMt4SsQRDyGzVKGxQ2fVRIfvLdR8-uTnrFCRqCfFEBvBgNZ9rFLFNWnIA38OpiqV6Qv3fZw4G9omsZUFCoSHYvMZgkShcXChpMDuLxcUqfkqnl9tQJi8JcKvBmSfvTLcnN2459aW6PkHeeM7701-swcX8bhBvpWCwnrvUqPqwXLwlaongslLMLixRKjg9fOb4McZuywiOC8UUSgU1NgSmjIZKtPBHlvMhqdUD3fzym~WTQ4p3uq-4Tw__&Key-Pair-Id=APKAJN6QFZEE4BZCL6XQ")format("woff2");}@font-face{font-family: "mfPreviewBar";src:url("https://easy.myfonts.net/v2/woff2?ASYurrIODteOEYjel2ThrlDmB2AFo09GqMj43FEeFrCCvPCAC4&Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cCo6Ly8qL3YyL3dvZmYyP0FTWXVycklPRHRlT0VZamVsMlRocmxEbUIyQUZvMDlHcU1qNDNGRWVGckNDdlBDQUM0IiwiQ29uZGl0aW9uIjp7IkRhdGVMZXNzVGhhbiI6eyJBV1M6RXBvY2hUaW1lIjoxNDg0MDkyODAwfX19XX0_&Signature=jBemL2ivUgMscBLfWma5hCu4Qzl4uUVje3BT5N9T3sbZgVu3PRRx9m~sMfq~dj~DLuwFcgF8R4C3Il56WP2cMC3g9uplRZ7XB6MG5deLCT8Z8o8deY5Z5kcDBU8vve53d68fJ4oKAfQhRgRto-2YfW9Lv29GvOmHrwxM1OU-p2dcwtLIE1YlHNQMnM6aG0464t12-Aeob45FdhvjRIZNBgdcujWiPf6bod7JoLWvsuMI8f2TPIvhJpQk6or1e9yqIvXmAtsxVxaKp6-95UbLhCHCV1R~J1Y6jBLpy75y4FFJnd78vD0c6f2-EUJwex-v~Dazdd3YVoPYsvg4daOb3w__&Key-Pair-Id=APKAJN6QFZEE4BZCL6XQ")format("woff2");}</style>
</head>
<body style="margin: 0; padding: 0; background-color:#f7a823">
<div class="image">
       <a href="https://www.bizzerd.com"><img style="padding-top:10%;height:75%; margin: 0 auto; display: block;"src="http://www.bizzerdcard.com/bizzerdwit.png"></a>
</div>
<div class="text" style="padding-left:10%; padding-right:10%">
	   ';
		$errorFooter = '
<p align="center" style="font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;"><a style="color:#fff; font-size:20px; text-decoration:none;" href="https://www.bizzerd.com">bizzerd.com</a></br></br>
       </p>  
</div>
</div>

</body>
</html>';
		die($errorHeader . $message . $errorFooter);
	}

	$iphone = checkIphone();
	
	// *** Template preview foefje
	//echo "<span style='color: #CCCCCC; font-size: 16px;'>c:" . $_GET["c"] . "</span><br>";
	
	if($_GET["c"] == "cards") 
	{
		$_GET["c"] = "template";
	}
	

	//echo "<span style='color: #CCCCCC; font-size: 16px;'>c:" . $_GET["c"] . "</span><br>";
	
	if(isset($_POST["customtemplate"]))
	{
		//die("HIER");
		$antiCacheDate = "?date=" . strtotime(date("Y-m-d H:i:s"));
		
		$_SESSION["customtemplate"] = $_POST["customtemplate"];
		$_SESSION["customperson"]   = $_POST["customperson"];
	}
	else
	{
		if($_GET["page"] == "")
		{
			//$_SESSION["customtemplate"] = "";
			//$_SESSION["customperson"]   = "";
		}
	}

	//echo "<span style='color: #CCCCCC; font-size: 16px;'>c:" . $_GET["c"] . "</span><br>";
	
	if($_SESSION["customtemplate"] != "")
	{
		//Dit is een custom template en dus niet in elkaar gezet met s.php
		$_GET["c"] = $_SESSION["customtemplate"];
		$_GET["p"] = $_SESSION["customperson"];
		//die("c:" . $_GET["c"]);
	}

	//echo "<span style='color: #CCCCCC; font-size: 16px;'>c:" . $_GET["c"] . "</span><hr>";
	
	// *** Company
	$company = trim(strtolower($_GET["c"]));
	
	//echo "<span style='color: #CCCCCC; font-size: 16px;'>company:" . $company . "</span><hr>";
	
	
	$errormsg = '<h2 align="center" style="font-family: Neo Tech Std Medium; font-size:25px; color:#FFF; font-weight:bold; line-height:50px;">We kunnen jouw bizzerd niet vinden.</h2><p align="center" style="font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">
 
	Misschien is de URL van jouw bizzerd verkeerd ingevuld. Of misschien is de URL veranderd..</br>
	 
	Kun je je bizzerd niet meer terugvinden, neem dan contact met ons op. </br></br></p>
	<div align="center"><a align="center" style="text-decoration:none; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px; padding-right:10px;" href="tel:0882272222"><i style="padding-right:10px;"  class="fa fa-phone" area-hidden="true"></i>(088) 227 22 22</a><p style="display:inline; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">|</p><a align="center" style="text-decoration:none; padding-left:10px; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;" href="mailto:contact@bizzerd.com"><i class="fa fa-envelope-o" style="padding-right:10px;" area-hidden="true"></i>contact@bizzerd.com</a></div></br>';

	//$query = mysql_query("SELECT * FROM mobilecard_companies WHERE naam = '" . $company . "'");
	//$row_c = mysql_fetch_array($query, MYSQL_ASSOC) or errorDie($errormsg);
	$row_c = sqlRow("SELECT * FROM mobilecard_companies WHERE naam = '" . $company . "'") or errorDie($errormsg);

	//$query = mysql_query("UPDATE mobilecard_companies SET teller = '" . ($row_c["teller"] + 1) . "' WHERE naam = '" . $company . "';") or die("Error while updating database.");
	sqlRow("UPDATE mobilecard_companies SET teller = '" . ($row_c["teller"] + 1) . "' WHERE naam = '" . $company . "';");
	
	// *** Get whitelabel info
	include("./includes/whitelabel.php");


	// *** Vertalingen
	if(trim(str_replace("~||~", "", $row_c["vertalingen"])) == "") $row_c["vertalingen"] = "1"; // *** Standaard vertalingen

	$temp = explode("~||~", $row_c["vertalingen"]);
	$vertalingen_count = 0;
	
	if($_POST["set_lan"] != "") $_SESSION["lan"] = $_POST["set_lan"];
	
	
	//echo "vertalingen (c:" . $company . ", ses: " . $_SESSION["lan"] . "): " . $row_c["vertalingen"] . "<hr>";
	
	$vertaling_id = $_SESSION["lan"];

	for($i = 0; $i < count($temp); $i++)
	{
		if($vertaling_id == "") $vertaling_id = $temp[$i];
		
		if($temp[$i] != "")
		{
			$notfound = 0;
			
			//$query_temp = mysql_query("SELECT afkorting FROM mobilecard_vertalingen WHERE id = '" . $temp[$i] . "'");
			//$row_temp = mysql_fetch_array($query_temp, MYSQL_ASSOC) or $notfound = 1;			
			$row_temp = sqlRow("SELECT afkorting FROM mobilecard_vertalingen WHERE id = '" . $temp[$i] . "'") or $notfound = 1;
			
			if($notfound != 1)
			{
				$vertalingen_count++;
				
				if($vertalingen_count != 1) $vertalingen_div .= "<span class='vertalingen_divider'>|</span>";
				
				if($temp[$i] == $vertaling_id) $selected = "_selected"; else $selected = "";
				
				$vertalingen_div .= "<a href='javascript: document.getElementById(\"set_lan\").value = " . $temp[$i] . "; document.getElementById(\"set_lan_form\").submit(); void(0);' class='vertalingen_a" . $selected . "' id='vertalingen_" . $temp[$i] . "'>" . $row_temp["afkorting"] . "</a>";
			}
		}
	}	
	
	if($vertalingen_count <= 1)
	{
		$vertalingen_div = "";
	}
	else
	{
		$vertalingen_div = "<div class='vertalingen'>
		
		<form id='set_lan_form' method='post' style='display: none;'><input type='hidden' name='set_lan' id='set_lan' value=''></form>
		
		" . $vertalingen_div . "
		
		</div>";
	}
	
	$_SESSION["lan"] = $vertaling_id;
	
	//echo "vertaling_id: " . $_SESSION["lan"] . "<hr>";

	$errormsg = '<h2 align="center" style="font-family: Neo Tech Std Medium; font-size:25px; color:#FFF; font-weight:bold; line-height:50px;">We kunnen jouw bizzerd niet vinden.
	   </h2><p align="center" style="font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">
 
Misschien is de URL van jouw bizzerd verkeerd ingevuld. Of misschien is de URL veranderd. </br>
 
Kun je je bizzerd niet meer terugvinden, neem dan contact met ons op. </br></br></p>
<div align="center"><a align="center" style="text-decoration:none; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px; padding-right:10px;" href="tel:0882272222"><i style="padding-right:10px;"  class="fa fa-phone" area-hidden="true"></i>(088) 227 22 22</a><p style="display:inline; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">|</p><a align="center" style="text-decoration:none; padding-left:10px; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;" href="mailto:contact@bizzerd.com"><i class="fa fa-envelope-o" style="padding-right:10px;" area-hidden="true"></i>contact@bizzerd.com</a></div></br>';
	
	//$query_vertaling = mysql_query("SELECT * FROM mobilecard_vertalingen WHERE id = '" . str_replace("'", "`", $vertaling_id) . "'");
	//$row_vertaling = mysql_fetch_array($query_vertaling, MYSQL_ASSOC) or errorDie($errormsg);
	$row_vertaling = sqlRow("SELECT * FROM mobilecard_vertalingen WHERE id = '" . str_replace("'", "`", $vertaling_id) . "'") or errorDie($errormsg);


	// *** Translation array
	/*
	$translationDefault = array();
	$translationDefault["z_bel_mij_titel"] 				= "Bel mij!";
	$translationDefault["z_bel_mij_beschrijving"] 			= "Vul uw gegevens hieronder in en ~volledige_naam~ belt u zo snel mogelijk terug.";
	$translationDefault["z_bel_mij_verzonden_titel"] 		= "Verzonden!";
	$translationDefault["z_bel_mij_verzonden_beschrijving"] 	= "Het formulier is verzonden! ~volledige_naam~ belt u zo snel mogelijk terug.";
	$translationDefault["z_bel_mij_verzonden_mail"] 		= "
										
	Geachte ~ontvanger~,
	
	<br><br>
	
	~verzender~ heeft het \"Bel mij\" formulier ingevuld op uw MobiCard en wenst teruggebeld te worden.
	
	<br><br>
	
	Telefoonnummer: ~telefoon~
	
	<br><br>
	
	~bericht~
	
	Met vriendelijke groet,<br>
	<i>MobiCard</i>
	
	";
	$translationDefault["z_bel_mij_mail_message_header"] 		= "~verzender~ heeft een bericht aan u geschreven:";

	$translationDefault["z_uw_naam"] 				= "Uw naam";
	$translationDefault["z_uw_telefoonnummer"] 			= "Uw telefoonnummer";
	$translationDefault["z_voeg_een_boodschap_toe"] 		= "Voeg een boodschap toe";
	$translationDefault["z_uw_boodschap"] 				= "Uw boodschap";
	$translationDefault["z_typ_de_3_cijfers_over_in_het_hokje"] 	= "Typ de 3 cijfers over in het hokje";
	$translationDefault["z_verzenden"] 				= "verzenden";
	$translationDefault["z_naar_voorpagina"] 			= "naar voorpagina";
	$translationDefault["z_whatsapp_titel"] 			= "WhatsApp";
	
	$translationDefault["z_whatsapp_beschrijving"] 			= "Om te kunnen WhatsAppen met ~volledige_naam~ dient u het telefoonnummer toe te voegen aan uw adressenlijst:
									<h1><a href='tel:~mobiel_formatted~' style='text-decoration: none;'>~mobiel~</a></h1>
									Nadat u het telefoonnummer heeft toegevoegd, verschijnt ~volledige_naam~ in de WhatsApp lijst en kunt u een gesprek starten.";	
									
	$translationDefault["z_skype_titel"] 				= "Skype";
	$translationDefault["z_skype_beschrijving"] 			= "De Skype gebruikersnaam van ~volledige_naam~ is:
									<h1>~skype~</h1>
									<a href='skype:~skype~?call&topic=Verzoek%20vanuit%20MobiCard'>Bel ~voornaam~</a> of <a href='skype:~skype~?chat'>stuur ~voornaam~ een Skype bericht</a>
									<br><br>
									Bovenstaande links proberen Skype voor u te starten. Mocht dit niet werken, kunt u ook de gebruikersnaam kopi&euml;ren en toevoegen in Skype.";

	$translationDefault["z_cv_titel"] 				= "Curriculum Vitae";
	$translationDefault["z_deel_titel"] 				= "Deel deze MobiCard";
	$translationDefault["z_deel_via_email"] 			= "Deel via e-mail";
	$translationDefault["z_naam_van_ontvanger"] 			= "Naam van ontvanger";
	$translationDefault["z_email_van_ontvanger"] 			= "E-mail van ontvanger";
	$translationDefault["z_email_deel_subject"] 			= "Bekijk de MobiCard van ~naam~";
	$translationDefault["z_email_deel_tekst"] 			= "Beste ~ontvanger~,
					
									~verzender~ wil graag dat u de MobiCard van ~naam~ bekijkt!
																		
									~bericht~
									
									Klik op deze link om de MobiCard te bekijken:
									~link~
														
									<i>Een MobiCard is een digitaal visitekaartje. U kunt hier de contactgegevens van ~naam~ inzien, de locatie bekijken op Google Maps, de contactgegevens opslaan in uw adresboek (vCard) en het profiel van ~naam~ bekijken op social media zoals LinkedIn, Facebook en Twitter.</i>
														
									Met vriendelijke groet,					
									~verzender~";
	$translationDefault["z_de_email_is_verzonden"] 			= "De e-mail is verzonden!";

	$translationDefault["z_deel_via_sms"] 				= "Deel via sms";
	$translationDefault["z_deel_via_whatsapp"] 			= "Deel via WhatsApp";
	//$translationDefault["z_sms_tekst"] 				= "Wordt de link naar het kaartje niet automatisch meegegeven in de sms, doe dan het volgende: Kopieer onderstaande link door er op te drukken en vast te houden. Plak de link vervolgens in de sms door 1 keer te klikken en de optie plakken (paste) te kiezen.";
	$translationDefault["z_sms_tekst"] 				= "Stuur de link naar deze MobiCard via sms:";
	$translationDefault["z_sms_deel_tekst"] 			= "Bekijk de MobiCard van ~naam~: ~link~";
	$translationDefault["z_stuur_een_sms"] 				= "stuur een sms";
	$translationDefault["z_deel_via_qr_code"] 			= "Deel via QR-code";
	$translationDefault["z_qr_code_tekst"] 				= "Door deze code met de smartphone te scannen, krijgt u de directe link naar deze MobiCard.";
	$translationDefault["z_vcard_titel"] 				= "Contact toevoegen (vCard)";
	$translationDefault["z_vcard_beschrijving"] 			= "Een contact wordt geopend in uw contactlijst. Hieronder kunt u eventueel een boodschap toevoegen aan deze contact (bijvoorbeeld als geheugensteuntje voor uzelf)";
	$translationDefault["z_vcard_standard_tekst"] 			= "";
	$translationDefault["z_contact_toevoegen"] 			= "contact toevoegen";
	
	$translationDefault["z_fout"] 					= "Fout!"; 
	$translationDefault["z_u_heeft_uw_naam_of_tel"] 		= "U heeft uw naam of telefoonnummer niet ingevuld."; 
	$translationDefault["z_u_heeft_niet_uw_naam_of"] 		= "U heeft niet uw naam of de naam van de ontvanger ingevuld, dan wel een ongeldig e-mail adres opgegeven!"; 
	$translationDefault["z_u_heeft_een_verkeerde_3_cijferige"] 	= "U heeft een verkeerde 3-cijferige code ingevuld. Probeer aub nogmaals!"; 
	$translationDefault["z_terug"] 					= "terug";
	$translationDefault["z_doorgaan"] 				= "doorgaan";
	*/
	
	$translation = array();
	
	//while (list ($key, $val) = each ($row_vertaling))
	foreach ($row_vertaling as $key => $val)
	{
		if($key != "id" && $key != "naam" && $key != "z1" && $key != "afkorting") $translation[$key] = $row_vertaling[$key];
		
		//if($translation[$key] == "") $translation[$key] = $translationDefault[$key];
		
		//echo $key . ": " . $translation[$key] . "<br>";
	} 
	unset($val);	
	
	
	
	// *** Is dit een template of een custom card?
	if($row_c["template"] == "1" || $_GET["c"] == "template") $template = 1; 
	
	//die("TEMPLATE:" . $row_c["template"]);
		
	// *** Template HTML inladen van company "template"
	$row_temp = $row_c;
	
	if($row_c["template"] == "1" && $_GET["c"] != "template")
	{
		$errormsg = '<h2 align="center" style="font-family: Neo Tech Std Medium; font-size:25px; color:#FFF; font-weight:bold; line-height:50px;">We kunnen jouw bizzerd niet vinden.
	   </h2><p align="center" style="font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">
 
Misschien is de URL van jouw bizzerd verkeerd ingevuld. Of misschien is de URL veranderd. </br>
 
Kun je je bizzerd niet meer terugvinden, neem dan contact met ons op. </br></br></p>
<div align="center"><a align="center" style="text-decoration:none; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px; padding-right:10px;" href="tel:0882272222"><i style="padding-right:10px;"  class="fa fa-phone" area-hidden="true"></i>(088) 227 22 22</a><p style="display:inline; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">|</p><a align="center" style="text-decoration:none; padding-left:10px; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;" href="mailto:contact@bizzerd.com"><i class="fa fa-envelope-o" style="padding-right:10px;" area-hidden="true"></i>contact@bizzerd.com</a></div></br>';
		
		//$query = mysql_query("SELECT * FROM mobilecard_companies WHERE naam = 'template'");
		//$row_temp = mysql_fetch_array($query, MYSQL_ASSOC) or errorDie($errormsg);
		$row_temp = sqlRow("SELECT * FROM mobilecard_companies WHERE naam = 'template'") or errorDie($errormsg);
	}

	$pages = array();
	$pages["global"] 	= $row_temp["html_global"];
	$pages[""] 		= $row_temp["html_home"];
	$pages["deel"] 		= $row_temp["html_deel"];
	$pages["deel2"] 	= $row_temp["html_deel2"];
	$pages["deel3"] 	= $row_temp["html_deel3"];
	$pages["standard"] 	= $row_temp["html_standard"];
	
	if($pages["standard"] == "")
	{
		// *** Get standard page from template
		
		//$query_temp = mysql_query("SELECT * FROM mobilecard_companies WHERE naam = 'template'");
		//$row_temp   = mysql_fetch_array($query_temp, MYSQL_ASSOC);
		$row_temp = sqlRow("SELECT * FROM mobilecard_companies WHERE naam = 'template'");
		
		$pages["standard"] = $row_temp["html_standard"];		
	
	}
	
	$pages["map"] 		= $row_temp["html_map"];
	$pages["qr"] 		= $row_temp["html_qr"];
	$pages["cv"] 		= $row_temp["html_cv"];
	$footer 		= $row_temp["html_footer"];


	// *** Person
	$errormsg = '<h2 align="center" style="font-family: Neo Tech Std Medium; font-size:25px; color:#FFF; font-weight:bold; line-height:50px;">We kunnen jouw bizzerd niet vinden.
	   </h2><p align="center" style="font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">
 
Misschien is de URL van jouw bizzerd verkeerd ingevuld. </br>
 
Kun je je bizzerd niet meer terugvinden, neem dan contact met ons op. </br></br>
</p>
<div align="center"><a align="center" style="text-decoration:none; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px; padding-right:10px;" href="tel:0882272222"><i style="padding-right:10px;"  class="fa fa-phone" area-hidden="true"></i>(088) 227 22 22</a><p style="display:inline; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">|</p><a align="center" style="text-decoration:none; padding-left:10px; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;" href="mailto:contact@bizzerd.com"><i class="fa fa-envelope-o" style="padding-right:10px;" area-hidden="true"></i>contact@bizzerd.com</a></div></br>';
	
	$person = str_replace(".", ".", str_replace(" ", ".", trim(strtolower($_GET["p"]))));
	
	//$query = mysql_query("SELECT * FROM mobilecard_persons WHERE company = '" . $row_c["id"] . "' AND naam = '" . $person . "'");
	//$row_p   = mysql_fetch_array($query, MYSQL_ASSOC) or errorDie($errormsg);
	$row_p = sqlRow("SELECT * FROM mobilecard_persons WHERE company = '" . $row_c["id"] . "' AND naam = '" . $person . "'") or errorDie($errormsg);
	
	
	$row_p["vimeo"] = "";
	
	//Check for GDPR accepting

	//$query = mysql_query("UPDATE mobilecard_persons SET teller = '" . ($row_p["teller"] + 1) . "' WHERE company = '" . $row_c["id"] . "' AND naam = '" . $person . "';") or die("Error while updating database.");
	sqlRow("UPDATE mobilecard_persons SET teller = '" . ($row_p["teller"] + 1) . "' WHERE company = '" . $row_c["id"] . "' AND naam = '" . $person . "';");
	
	//$query2 = mysql_query("SELECT * FROM mobilecard_GDPR_confirmation WHERE person_id=" . $row_p['id'] . ';');
	//$gdpr = mysql_fetch_array($query2, MYSQL_ASSOC);
	$gdpr = sqlRow("SELECT * FROM mobilecard_GDPR_confirmation WHERE person_id=" . $row_p['id'] . ';');
		
	if(!$gdpr['display_confirm'] && !$row_c['gdpr_accepted'] && $_POST['a'] != "preview"){
		errorDie('<h2 align="center" style="font-family: Neo Tech Std Medium; font-size:25px; color:#FFF; font-weight:bold; line-height:50px;">Je hebt geen akkoord gegeven op onze privacy voorwaarden en hierdoor mogen wij jouw kaartje niet meer weergeven.
	   </h2><p align="center" style="font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">
 
Log in op <a style="text-decoration:none; font-weight:bold; color:#fff" href="https://app.bizzerd.com/s_edit.php">app.bizzerd.com</a> om alsnog akkoord te geven of neem contact met ons op. </br></br>
</p>
<div align="center"><a align="center" style="text-decoration:none; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px; padding-right:10px;" href="tel:0882272222"><i style="padding-right:10px;"  class="fa fa-phone" area-hidden="true"></i>(088) 227 22 22</a><p style="display:inline; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">|</p><a align="center" style="text-decoration:none; padding-left:10px; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;" href="mailto:contact@bizzerd.com"><i class="fa fa-envelope-o" style="padding-right:10px;" area-hidden="true"></i>contact@bizzerd.com</a></div></br>');

	}	
	// *** Preview (als men in het stappenplan een card samenstelt)
	//echo "<span style='color: #CCCCCC; font-size: 16px;'>now_previewing:" . $_SESSION["now_previewing"] . "/" . $row_c["volledige_naam"] . "</span><br>";

	//if($_SESSION["now_previewing"] != "") $_POST["a"] = "preview";
	
	if($_POST["a"] == "preview")
	{
		//echo "<span style='color: #CCCCCC; font-size: 16px;'>preview</span><br>";
	
		//echo "SAVE PREVIEW. ";
		
		//$row_p = array();
		
		//$query = mysql_query("SELECT * FROM mobilecard_persons WHERE id = '87' ");
		//$row_p   = mysql_fetch_array($query, MYSQL_ASSOC) or die("Company or person not found");
		
		// *** Checkboxes moeten handmatig in array gezet worden omdat isset false is als niet gevinkt
		/*
		$row_p["belmij"] = $_POST["belmij"];
		$row_p["whatsapp"] = $_POST["whatsapp"];
		$row_p["website_icoon"] = $_POST["website_icoon"];
		$row_p["website_link"] = $_POST["website_link"];
		$row_p["qrcode"] = $_POST["qrcode"];
		$row_p["googlemaps"] = $_POST["googlemaps"];
		*/
		$row_p_temp = $row_p;
		// echo $row_p['adresveld'];
		// echo $row_p['adresveld'];
		// $_POST[$key] = $row_p['adresveld'];
		// $_POST["voornaam"] = $row_p['voornaam'];
		// $_SESSION["row_p_voornaam"] = $row_p['voornaam'];
		// $_SESSION["row_p_achternaam"] = $row_p['achternaam'];
		// print_r($_POST);

		//while (list ($key, $val) = each ($row_p_temp))
		foreach ($row_p_temp as $key => $val)
		{

			// if($key !== "adresveld" && $key !== "voornaam" && $key !== "achternaam")
			// {
				$row_p[$key] = $_POST[$key];
				$_SESSION["row_p_" . $key] = $_POST[$key];

			// }
		} 
		unset($val);
		
		// echo $_POST['adresveld'];
		// echo $row_p['adresveld'];
		// print_r($_SESSION);
		
		if(!isset($_POST["functie"]))
		{
			//die($_SESSION["lan"]);
			
			$_POST["functie"] = $_POST["functie_" . $_SESSION["lan"]];  
			$row_p["functie"] = $_POST["functie"];
			$_SESSION["row_p_functie"] = $_POST["functie"];				
			
			/*			
			$_POST_TEMP = $_POST;
	
			while (list ($key, $val) = each ($_POST_TEMP))
			{
				if(strstr($key, "functie_") && $row_p["functie"] == "")
				{
					echo $key . " = " . $val . "(" . $row_p["functie"] . ")<br>";
					
					$row_p["functie"] = $val;
					$_SESSION["row_p_functie"] = $val;				
				}
			}
			*/
			
			
		}
		
		//die("adresveld:" . $_POST["adresveld_" . $_SESSION["lan"]]);
		

		if(isset($_POST["adresveld_" . $_SESSION["lan"]]))
		{
			$_POST["adresveld"] = $_POST["adresveld_" . $_SESSION["lan"]]; 
			
			$row_p["adresveld"] = $_POST["adresveld"];
			$_SESSION["row_p_adresveld"] = $_POST["adresveld"];				
		}
		$_SESSION["row_p_adresveld"] = $row_p['adresveld'];
		
		$row_c_temp = $row_c;
		
		//while (list ($key, $val) = each ($row_c_temp))
		foreach ($row_c_temp as $key => $val)
		{
			//if(isset($_POST[$key]))
			//{
				$row_c[$key] = $_POST[$key];
				$_SESSION["row_c_" . $key] = $_POST[$key];
			//}
		} 
		unset($val);
					
		$row_c["volledige_naam"] = $_POST["c_volledige_naam"];
		$_SESSION["row_c_volledige_naam"] = $_POST["c_volledige_naam"];
		
		$_SESSION["now_previewing"] = $row_c["volledige_naam"];
		
		//echo "now_previewing" . $_SESSION["now_previewing"];
		
		//$row_p["adresveld"] = $_POST["adresveld"];
		//$row_p["template_logo"] = $_POST["template_logo"];
		//$row_p["template_artwork"] = $_POST["template_artwork"];
	}

	
	//if($company == "template")
	//$_SESSION["now_previewing"] = "";

	//echo "<span style='color: #CCCCCC; font-size: 16px;'>now_previewing:" . $_SESSION["now_previewing"] . "/" . $row_c["volledige_naam"] . "</span><br>";

	
	if($_SESSION["now_previewing"] != "" && $row_c["volledige_naam"] != "") // $_SESSION["now_previewing"] == $row_c["volledige_naam"]
	{
		//echo "GET PREVIEW. ";
	
		$row_p_temp = $row_p;
		
		//while (list ($key, $val) = each ($row_p_temp))
		foreach ($row_p_temp as $key => $val)
		{
			$row_p[$key] = $_SESSION["row_p_" . $key];
		}
		unset($val);
		
		$row_c_temp = $row_c;
		
		//while (list ($key, $val) = each ($row_c_temp))
		foreach ($row_c_temp as $key => $val)
		{
			$row_c[$key] = $_SESSION["row_c_" . $key];
		}
		unset($val);
		
		
	}
		
	//if($row_c["template"] != "")
	
	//die($_SESSION["now_previewing"] . "|" . $row_c["volledige_naam"]);

	// *** Zoom 50% in preview mode
	//echo "<span style='color: #CCCCCC; font-size: 16px;'>now_previewing:" . $_SESSION["now_previewing"] . "/" . $row_c["volledige_naam"] . "</span><br>";
	
	if($_SESSION["now_previewing"] == $row_c["volledige_naam"] && $row_c["volledige_naam"] != "")
	{
		$extraCSS .= "

		<style>
		
		html
		{
			
			-moz-transform: scale(0.5); /* Firefox */
			-moz-transform-origin: 0 0;
			-o-transform: scale(0.5); /* Opera */
			-o-transform-origin: 0 0;
			-webkit-transform: scale(0.5); /* Safari And Chrome */
			-webkit-transform-origin: 0 0;
			transform: scale(0.5); /* Standard Property */
			transform-origin: 0 0;  /* Standard Property */			
		}
		
		</style>
								
		";		
	}
		
function adjustBrightness($hex, $steps) {
    // Steps should be between -255 and 255. Negative = darker, positive = lighter
    $steps = max(-255, min(255, $steps));

    // Normalize into a six character long hex string
    $hex = str_replace('#', '', $hex);
    if (strlen($hex) == 3) {
        $hex = str_repeat(substr($hex,0,1), 2).str_repeat(substr($hex,1,1), 2).str_repeat(substr($hex,2,1), 2);
    }

    // Split into three parts: R, G and B
    $color_parts = str_split($hex, 2);
    $return = '#';

    foreach ($color_parts as $color) {
        $color   = hexdec($color); // Convert to decimal
        $color   = max(0,min(255,$color + $steps)); // Adjust color
        $return .= str_pad(dechex($color), 2, '0', STR_PAD_LEFT); // Make two char hex code
    }

    return $return;
}

	
	if($template != "")
	{
		//die("TEMPLATE: " . $row_c["template_achtergrond"] . "/" . $template);
		
		// *** Wordt toegevoegd aan images zodat nieuwe images niet uit de cache komen
		if($_POST["a"] == "preview") 
		{		
			$antiCacheDate = "?date=" . strtotime(date("Y-m-d H:i:s"));	
		}
		
		
		$voorgrond = $row_c["template_voorgrond"];
		
		$adjustedVoorgrond = adjustBrightness($voorgrond, -50);
		
		if("#" . $voorgrond == $adjustedVoorgrond) $adjustedVoorgrond = adjustBrightness($voorgrond, 50);
		
		
		$extraCSS .= "
		
		<style>
		
		" . $zoom . "
		
		body, html
		{
			background-color: #" . str_replace("#", "", $row_c["template_achtergrond"]) . ";
		}

		.canvas_bg, .page2, .cv_page, .cv_header, .canvas, .vertalingen
		{
			background-color: #" . str_replace("#", "", $row_c["template_voorgrond"]) . ";
		}


		.deel_list_selected, .deel_div_selected
		{
			background-color: " . $adjustedVoorgrond . ";
		}

		.input_submit, .input_submit:active, .input_submit:visited, .input_submit:hover
		{
			color: #" . str_replace("#", "", $row_c["template_voorgrond"]) . ";
		}
		
		.input_submit, .input_submit:active, .input_submit:visited, .input_submit:hover
		{
			background-color: #FFF/*" . str_replace("#", "", $row_c["template_titels"]) . "*/;
		}
		
		
		.header_text b, .info span, h1, .deel_list, .deel_list:visited, .deel_list:active, .deel_list:hover, .cv_header b, .cv_page h2
		{
			color: #" . str_replace("#", "", $row_c["template_titels"]) . ";
		}

		.page2 .input_submit, .page2 .input_submit:active, .page2 .input_submit:visited, .page2 .input_submit:hover{
			color: #000;	
		}
		.link_adres, .link_adres:visited, .link_adres:active, .header_text, .info, .cv_header, .page2, .cv_page, 
		.vertalingen_a_selected, .vertalingen_a_selected:visited, .vertalingen_a_selected:active, .vertalingen_a_selected:hover, .vertalingen_divider
		{
			color: #" . str_replace("#", "", $row_c["template_tekst"]) . ";
		}
				
		a, a:visited, a:active, a:hover, .link_website, .link_website:active, .link_website:visited, .cv_page h1
		{
			color: #" . str_replace("#", "", $row_c["template_links"]) . ";
		}		


		.arrow
		{
			background-image: url('/template/images/icons/cv_arrow.png');
		}

		hr
		{
			border: 0px;
			background-image: url('/template/images/icons/hr.png'); background-repeat: repeat-x; background-position: left middle;
			display: block;
			height: 4px;			
		}
		
		.cv_page h2
		{
			border-top: 0px;
			background-image: url('/template/images/icons/hr.png'); background-repeat: repeat-x; background-position: left top;
		}
		
		</style>
				
		";
		
	}


	
	$extraCSS .= "
	
	<style>
		
	 .scrollbuttons
	 {
	  	position: fixed; 
	 	z-index: 1000; 
	 	left: 92%;
	 	top: 815px;
	 }
	 
	</style>
		
	 ";
	 
 
	 $temp_voorvoegsel = substr($row_p["voorvoegsel"], strpos($row_p["voorvoegsel"], "~||~" . $vertaling_id . ":") + strlen("~||~" . $vertaling_id . ":"));

	 if(strstr($row_p["voorvoegsel"], "~||~"))
	 {		
		 if(strstr($temp_voorvoegsel, "~||~")) $temp_voorvoegsel = substr($temp_voorvoegsel, 0, strpos($temp_voorvoegsel, "~||~"));		
		 if(!strstr($row_p["voorvoegsel"], "~||~" . $vertaling_id . ":")) $temp_voorvoegsel = "";
 
		 if(strstr($temp_voorvoegsel, "~||~")) $temp_voorvoegsel = substr($temp_voorvoegsel, 0, strpos($temp_voorvoegsel, "~||~"));
						 
		 $row_p["voorvoegsel"] = $temp_voorvoegsel;
	 }		
	// *** Format data	

	$row_p["volledige_naam"] = $row_p["voorvoegsel"] . " " . $row_p["voornaam"] . " " . $row_p["tussenvoegsel"] . " " . $row_p["achternaam"];
	$row_p["volledige_naam"] = str_replace("  ", " ", $row_p["volledige_naam"]);
	$row_p["volledige_naam"] = str_replace("  ", " ", $row_p["volledige_naam"]);
	$row_p["volledige_naam"] = trim($row_p["volledige_naam"]);
	
	// *** Adres (let op: afzonderlijke adresvelden deprecated, gebruik adresveld (textarea))
	$row_p["adres"] = $row_p["straat"] . " " . $row_p["huisnummer"] . " " . $row_p["toevoeging"] . "\n";
	if($row_p["postbus"] != "")
	{
		if(!strrpos($row_p["postbus"], "postbus"))
		{
			$row_p["postbus"] = "Postbus " . $row_p["postbus"];
		}
		
		$row_p["adres"] .= $row_p["postbus"] . "\n"; 	
	}
	
	$row_p["adres"] .= $row_p["postcode"] . " " . $row_p["plaats"] . "\n" . $row_p["land"]; 
	
	if($row_p["adresveld"] != "") $row_p["adres"] = $row_p["adresveld"];
	
	if($vertalingen_count > 1)
	{
		if(strstr($row_p["adres"], "~||~")) $row_p["adres_formatted"] = substr($row_p["adres"], 0, strpos($row_p["adres"], "~||~")); else $row_p["adres_formatted"] = $row_p["adres"];


		$temp_adres = substr($row_p["adresveld"], strpos($row_p["adresveld"], "~||~" . $vertaling_id . ":") + strlen("~||~" . $vertaling_id . ":"));
		
		//echo $temp_adres . "|<br>";
		
		if(strstr($row_p["adres"], "~||~"))
		{		
			if(strstr($temp_adres, "~||~")) $temp_adres = substr($temp_adres, 0, strpos($temp_adres, "~||~"));		
			if(!strstr($row_p["adresveld"], "~||~" . $vertaling_id . ":")) $temp_adres = "";
	
			if(strstr($temp_adres, "~||~")) $temp_adres = substr($temp_adres, 0, strpos($temp_adres, "~||~"));
							
			$row_p["adres"] = $temp_adres;
		}		
		
		if(strstr($row_p["functie"], "~||~"))
		{
			$temp_functie = substr($row_p["functie"], strpos($row_p["functie"], "~||~" . $vertaling_id . ":") + strlen("~||~" . $vertaling_id . ":"));
			if(strstr($temp_functie, "~||~")) $temp_functie = substr($temp_functie, 0, strpos($temp_functie, "~||~"));		
			if(!strstr($row_p["functie"], "~||~" . $vertaling_id . ":")) $temp_functie = "";
	
			if(strstr($temp_functie, "~||~")) $temp_functie = substr($temp_functie, 0, strpos($temp_functie, "~||~"));
							
			$row_p["functie"] = $temp_functie;
		}

		if(strstr($row_p["website"], "~||~"))
		{
			$temp_website = substr($row_p["website"], strpos($row_p["website"], "~||~" . $vertaling_id . ":") + strlen("~||~" . $vertaling_id . ":"));
			if(strstr($temp_website, "~||~")) $temp_website = substr($temp_website, 0, strpos($temp_website, "~||~"));		
			if(!strstr($row_p["website"], "~||~" . $vertaling_id . ":")) $temp_website = "";
	
			if(strstr($temp_website, "~||~")) $temp_website = substr($temp_website, 0, strpos($temp_website, "~||~"));
							
			$row_p["website"] = $temp_website;
		}

		for($j=1; $j<=4;$j++){
			if(strstr($row_p["extralink" . $j . "_titel"], "~||~"))
			{
			
				$temp_extralink = substr($row_p["extralink" . $j . "_titel"], strpos($row_p["extralink" . $j . "_titel"], "~||~" . $vertaling_id . ":") + strlen("~||~" . $vertaling_id . ":"));
				if(strstr($temp_extralink, "~||~")) $temp_extralink = substr($temp_extralink, 0, strpos($temp_extralink, "~||~"));		
				if(!strstr($row_p["extralink" . $j . "_titel"], "~||~" . $vertaling_id . ":")) $temp_extralink = "";
	
				if(strstr($temp_extralink, "~||~")) $temp_extralink = substr($temp_extralink, 0, strpos($temp_extralink, "~||~"));
							
				$row_p["extralink" . $j . "_titel"] = $temp_extralink;
			}
		}	

		for($j=1; $j<=3;$j++){
			$temp_extratekst = substr($row_p["extratekst" . $j], strpos($row_p["extratekst" . $j], "~||~" . $vertaling_id . ":") + strlen("~||~" . $vertaling_id . ":"));

			if(strstr($row_p["extratekst" . $j], "~||~"))
			{		
				if(strstr($temp_extratekst, "~||~")) $temp_extratekst = substr($temp_extratekst, 0, strpos($temp_extratekst, "~||~"));		
				if(!strstr($row_p["extratekst" . $j], "~||~" . $vertaling_id . ":")) $temp_extratekst = "";
		
				if(strstr($temp_extratekst, "~||~")) $temp_extratekst = substr($temp_extratekst, 0, strpos($temp_extratekst, "~||~"));
								
				$row_p["extratekst" . $j] = $temp_extratekst;
			}	
		}
	}
	else
	{
		$row_p["adres_formatted"] = $row_p["adres"];
	}
	
	$row_p["adres_google"] = nl2br(trim($row_p["adres_formatted"]));
	
	if($row_p["adres_google"] != "") $row_p["adres_google"] = "<a href='~link~/map' class='link_adres'>" . $row_p["adres_google"] . "</a><div class='spacer'></div>";
	

	if(strstr($row_p["adres_formatted"], "[MAP]") && strstr($row_p["adres_formatted"], "[/MAP]"))
	{
		$row_p["adres_formatted"] = substr($row_p["adres_formatted"], 0, strpos($row_p["adres_formatted"], "[/MAP]"));
		$row_p["adres_formatted"] = substr($row_p["adres_formatted"], strpos($row_p["adres_formatted"], "[MAP]") + 5);
	}
		
	$row_p["adres"] = str_replace("[MAP]", "", $row_p["adres"]);
	$row_p["adres"] = str_replace("[/MAP]", "", $row_p["adres"]);	
	$row_p["adres"] = nl2br($row_p["adres"]);

	$row_p["adres_google"] = str_replace("[MAP]", "", $row_p["adres_google"]);
	$row_p["adres_google"] = str_replace("[/MAP]", "", $row_p["adres_google"]);

	
	//if($row_p["adresveld"] != "") $row_p["adres"] = nl2br($row_p["adresveld"]);
		
	$row_p["tel_formatted"] = $row_p["tel"];
	$row_p["mobiel_formatted"] = $row_p["mobiel"];
	$row_p["website_formatted"] = $row_p["website"];

	if(strstr(strtolower($row_p["youtube"]), "vimeo"))
	{
		$row_p["vimeo"] = $row_p["youtube"];
		$row_p["youtube"] = "";
	}

	

	
	$row_p["adres_formatted"] = str_replace("\n", " ", $row_p["adres_formatted"]);
	$row_p["adres_formatted"] = str_replace("\r", " ", $row_p["adres_formatted"]);
	$row_p["adres_formatted"] = str_replace("\t", " ", $row_p["adres_formatted"]);
	$row_p["adres_formatted"] = str_replace("  ", " ", $row_p["adres_formatted"]);
	$row_p["adres_formatted"] = str_replace("  ", " ", $row_p["adres_formatted"]);
	$row_p["adres_formatted"] = str_replace("  ", " ", $row_p["adres_formatted"]);
	$row_p["adres_formatted"] = str_replace("  ", " ", $row_p["adres_formatted"]);
	$row_p["adres_formatted"] = str_replace("P.O. Box", "", $row_p["adres_formatted"]);
	$row_p["adres_formatted"] = str_replace(" ", "+", $row_p["adres_formatted"]);
	

	$row_p["tel_formatted"] = str_replace(" ", "", $row_p["tel_formatted"]);
	$row_p["tel_formatted"] = str_replace("-", "", $row_p["tel_formatted"]);
	$row_p["tel_formatted"] = str_replace("(", "", $row_p["tel_formatted"]);
	$row_p["tel_formatted"] = str_replace(")", "", $row_p["tel_formatted"]);

	$row_p["mobiel_formatted"] = str_replace(" ", "", $row_p["mobiel_formatted"]);
	$row_p["mobiel_formatted"] = str_replace("-", "", $row_p["mobiel_formatted"]);
	$row_p["mobiel_formatted"] = str_replace("(", "", $row_p["mobiel_formatted"]);
	$row_p["mobiel_formatted"] = str_replace(")", "", $row_p["mobiel_formatted"]);

	$temp = parse_url($row_p["website_formatted"]);
	$row_p["website_formatted"] = $temp["host"];
	
	// *** Toepassen variatie op kaartje
	
	
	// *** Page
	$page = trim(strtolower($_GET["page"]));
	if(isset($_POST["page"])) $page = trim(strtolower($_POST["page"]));
	
	if($page == "deel_qr")
	{
		$page = "deel";
		$show_qr = 1;
	}
	
	
	$www = $whitelabel_www;
	if(strstr($whitelabel_server_name, "office.online4you.nl")) { $port = ":8380"; $www = $whitelabel_wwwdev; }
	$link = "https://" . $whitelabel_server_name . $port . "/" . $person;
	$link2 = "https://" . $whitelabel_server_name . $port;
	$link3 = str_replace("http://cards", "http://" . $www, "http://" . str_replace($row_c["naam"], $www, $whitelabel_server_name) . $port);
	$link4 = "https://www." . $whitelabel_domein;



	// *** Format CV
	
	$row_p["cv"] = formatSpecialMarkup($row_p["cv"]);
	
	function formatSpecialMarkup($markup)
	{
		if(strip_tags($markup) != $markup)
		{
			
		}
		else
		{
			$markup .= "\n";
		
			$temp = explode(">", $markup);
			
			for($i = 1; $i < count($temp); $i++)
			{
				$nl = strpos($temp[$i], "\n");
				//if(!strstr($nl, "\n")) $nl = strlen($temp[$i]);
				
				$temp[$i] = substr($temp[$i], 0, $nl) . "</div>"  . substr($temp[$i], $nl);
			
			}
			
			$markup = implode("<div class='arrow'>", $temp);
			
			$markup = str_replace("[", "<h2>", $markup);
			$markup = str_replace("]", "</h2>", $markup);
			$markup = str_replace("---", "<div class='cv_ruler'>&nbsp;</div>", $markup);
			
			$markup = trim($markup);
	
	
			$markup = nl2br($markup);
			$markup = str_replace("</div><br />", "</div>", $markup);
		}
					
		return($markup);
	}
		
	
	$cv = "
	
	<div class='cv_page'>

               " . $row_p["cv"] . "

	</div>
	
	";
	
	
	$captcha = (rand(100, 999) + 2) * 15;
	
	$captcha_html = "

	<table cellspacing='0' cellpadding='0' style='margin-bottom: 3px;'>
	<tr>
		<td style='padding-right: 6px; vertical-align: middle;'>" . $translation["z_typ_de_3_cijfers_over_in_het_hokje"] . ":</td>				
		<td style='padding-right: 6px; vertical-align: middle;'><img src='/includes/password_img.php?c=" . $captcha . "&color=000000&bgcolor=DDDDDD' alt='Typ deze code over!' width='50' height='27'></td>
		<td style='padding-right: 6px; vertical-align: middle;'>></td>
		<td style='padding-right: 6px; vertical-align: middle;'><input type='hidden' name='c' value='" . $captcha . "'><input type='number' name='userc' class='input_text' style='width: 64px;' maxlength='3' lang='verplicht[thousand]:typ aub de 3 cijfers over!'></td>
	</tr>
	</table>
	
	";
	

	
	
	
	// *** Page template
	if($pages[$page] == "")	$pages[$page] = $pages["standard"];
	$html = str_replace("~html~", $pages[$page], $pages["global"]);


	//die($pages["global"] . "--------------------" . $page . "---------------" . $company . "------------" . $html);


	// *** vCard
	if($page == "vcard")
	{
		$html = str_replace("~titel~", $translation["z_vcard_titel"], $html);
		
		$tekst = "
	
		" . $translation["z_vcard_beschrijving"] . ":
		
		<br><br>
	
		<form method='get' action='~link2~/vcard/index.php'>
		<input type='hidden' name='c' value='~company~'>
		<input type='hidden' name='p' value='~person~'>

		<div><input type='text' name='pm' value='" . $translation["z_vcard_standard_tekst"] . "' class='input_text'></div>

		<input type='submit' value='" . str_replace("'", "`", $translation["z_contact_toevoegen"]) . "' class='input_submit'>

		</form>

		<br>
		
		<hr>		
		
		";	
	
		$html = str_replace("~tekst~", $tekst, $html);

		//die("PAGE: " . $html);	
	
	}
	
	// *** WhatsApp
	if($page == "whatsapp")
	{
		$html = str_replace("~titel~", $translation["z_whatsapp_titel"], $html);
	
		$tekst = $translation["z_whatsapp_beschrijving"];
		
		$html = str_replace("~tekst~", $tekst, $html);
	}


	// *** Extra pagina's
	for($j == 1; $j <= 4; $j++)
	{
		if($page == "link" . $j)
		{
			//echo "link " . $j;
			
			$html = str_replace("~titel~", $row_p["extralink" . $j . "_titel"], $html);
			$html = str_replace("~tekst~", formatSpecialMarkup($row_p["extralink" . $j . "_html"]), $html);
		}
	}

	// *** Skype
	if($page == "skype")
	{
		$html = str_replace("~titel~", $translation["z_skype_titel"], $html);
	
		$tekst = $translation["z_skype_beschrijving"];
	
		$html = str_replace("~tekst~", $tekst, $html);
	}


	// *** Belmij
	if($page == "belmij")
	{
		
	
		if($_POST["a"] == "belmij_send")
		{
		
			if($_POST["naam"] == "" || $_POST["telefoon"] == "")
			{
				$html = str_replace("~titel~", "<span style='background-color: #FF0000; color: #FFFFFF;'><b>&nbsp;" . $translation["z_fout"] . "&nbsp;</b></span>", $html);
				$tekst = $translation["z_u_heeft_uw_naam_of_tel"] . "<br><br><a href='javascript: history.go(-1);' class='input_submit'>" . $translation["terug"] . "</a><br><br><hr>";
			}
			else
			{
				$captcha = ((intval($_POST["c"]) / 15) - 2);
				
				if($captcha != intval($_POST["userc"]))
				{
					$html = str_replace("~titel~", "<span style='background-color: #FF0000; color: #FFFFFF;'><b>&nbsp;" . $translation["z_fout"] . "&nbsp;</b></span>", $html);
					$tekst = $translation["z_u_heeft_een_verkeerde_3_cijferige"] . "<br><br><a href='javascript: history.go(-1);' class='input_submit'>" . $translation["terug"] . "</a><br><br><hr>";
				}	
				else
				{
					$headers = getEmailHeaders($whitelabel_array);
									
					$_POST["bericht"] = trim($_POST["bericht"]);
	
	
					$subject = "" . $_POST["naam"] . " wil gebeld worden!";
	
					if($_POST["bericht"] != "")
					{
						$bericht = "
						
						<b>" . $translation["z_bel_mij_mail_message_header"] . "</b><br>
						<i>" . $_POST["bericht"] . "</i>
						<br><br>
						
						";
					
					}
						
					$mailtext = $translation["z_bel_mij_verzonden_mail"];

					$mailtext = str_replace("~bericht~", $bericht, $mailtext);
										
					$mailtext = str_replace("~ontvanger~", $row_p["volledige_naam"], $mailtext);
					$mailtext = str_replace("~verzender~", $_POST["naam"], $mailtext);
					$mailtext = str_replace("~telefoon~", $_POST["telefoon"], $mailtext);
																
					$mailtext = "<div style='font-family: arial; font-size: 12px;'>" . $mailtext . "</div>";
										
					mail($row_p["email"], $subject, $mailtext, $headers, "-f info@" . $whitelabel_domein); 
									
					$html = str_replace("~titel~", $translation["z_bel_mij_verzonden_titel"], $html);
					
					//$tekst = "Het formulier is verzonden! " . $row_p["volledige_naam"] . " belt u zo spoedig mogelijk terug.";
					
					$tekst = $translation["z_bel_mij_verzonden_beschrijving"];
				}
				
			}
			
		}
		else
		{
			$html = str_replace("~titel~", $translation["z_bel_mij_titel"], $html);
			
			$tekst = "
		
			" . $translation["z_bel_mij_beschrijving"] . "
			
			<br><br>
		
			<form method='post'>
			<input type='hidden' name='a' value='belmij_send'>
			
			" . $translation["z_uw_naam"] . ":<br>
			<input type='text' name='naam' value='' class='input_text'>
	
			" . $translation["z_uw_telefoonnummer"] . ":<br>
			<input type='text' name='telefoon' value='' class='input_text'>
	
			<a href='javascript: showMe(\"persoonlijke_boodschap\"); hideMe(\"persoonlijke_boodschap_link\");' id='persoonlijke_boodschap_link' class='deel_link'>" . $translation["z_voeg_een_boodschap_toe"] . "</a>
	
			<div id='persoonlijke_boodschap' style='display: none;'>
			" . $translation["z_uw_boodschap"] . ":<br>
			<textarea name='bericht' class='input_textarea'></textarea>
			</div>
	
	                ~captcha~
	
			<input type='submit' value='" . str_replace("'", "`", $translation["z_verzenden"]) . "' class='input_submit'>
	
			</form>
	
			<br>
			
			<hr>		
			
			";
		}
		$html = str_replace("~tekst~", $tekst, $html);
	}

	if($page == "deel" && strstr($html, "~deel_content~") && !isset($_POST["naam"]))
	{
		
		$nfc_icon = "nfc";		
		$nfc_list = "~translation:z_deel_via_nfc~";
		$nfc_div = "~translation:z_deel_via_nfc_tekst~";

		if(checkIOS())
		{
			$nfc_icon = "airdrop";		
			$nfc_list = "~translation:z_deel_via_airdrop~";
			$nfc_div = "~translation:z_deel_via_airdrop_tekst~";
		}
		
		$deel_html = "
		<link rel='stylesheet' href='https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css'>
		<h1>~translation:z_deel_titel~:</h1>
		
		<a href='javascript: openShareDiv(1); void(0);' id='deel_link_1' class='deel_list'><!-- img src='/~company~/images/icons/email.png'--><i style='font-size:30px; width:30px; padding-right:5px;' class='fa fa-envelope-o'></i> ~translation:z_deel_via_email~</a>
		<div id='deel_div_1' class='deel_div'>
			
			<form method='post' id='deel_email_form'>
			
			~translation:z_uw_naam~:<br>
			<input type='text' name='uwnaam' value='' class='input_text'>
			
			~translation:z_naam_van_ontvanger~:<br>
			<input type='text' name='naam' value='' class='input_text'>
			
			~translation:z_email_van_ontvanger~:<br>
			<input type='email' name='email' value='' class='input_text'>
			
			<a href='javascript: showMe(\"persoonlijke_boodschap\"); hideMe(\"persoonlijke_boodschap_link\");' id='persoonlijke_boodschap_link' style='display: none;' class='deel_link'>~translation:z_voeg_een_boodschap_toe~</a>
			
			<div id='persoonlijke_boodschap' style='display: none;'>
			~translation:z_uw_boodschap~:<br>
			<textarea name='bericht' class='input_textarea'></textarea>
			</div>
			
			~captcha~
			
			<input type='submit' value='" . str_replace("'", "`", $translation["z_verzenden"]) . "' class='input_submit'>
			
			</form>
					
		</div>
		
		
		
		<a href='javascript: openShareDiv(2); void(0);' id='deel_link_2' class='deel_list'><!-- img src='/~company~/images/icons/sms.png'--><i style='font-size:30px; width:30px; padding-right:5px;' class='fa fa-commenting-o' aria-hidden='true'></i> ~translation:z_deel_via_sms~</a>
		<div id='deel_div_2' class='deel_div'>
			
			~deel_sms~
	
		</div>
		
		
		
		<a href='javascript: openShareDiv(3); void(0);' style='display:none;'  id='deel_link_3' class='deel_list'><!--img src='/~company~/images/icons/qrcode.png'--><i style='font-size:30px; width:30px; padding-right:5px;' class='fa fa-qrcode'></i> ~translation:z_deel_via_qr_code~</a>
		<div id='deel_div_3' class='deel_div'>
			
			~translation:z_qr_code_tekst~<br><br>
			<p>Het kan zijn dat deze QR code niet wordt weergegeven. We zijn druk bezig dit probleem op te lossen.<br><br>Excuses voor het ongemak.<br>Het bizzerd team</p><br><br>
			<div class='qcode-frame'>	
				<iframe style='border: 0px; width: 100%; height: 560px; background-color: #FFFFFF;' frameborder='0' src='/qr/index.php?showdata=~link~' scrolling='no'></iframe>
			</div>
		</div>
		
		
		
		<a href='~deel_whatsapp~' onclick='openShareDiv(4); void(0);' id='deel_link_4' class='deel_list'><!-- img src='/~company~/images/icons/whatsapp.png' --><i style='font-size:30px; padding-right:5px; width:30px;' class='fa fa-whatsapp'></i> ~translation:z_deel_via_whatsapp~</a>
		<div id='deel_div_4' class='deel_div'>

			~translation:z_deel_via_whatsapp_tekst~

		</div>
		
		
		
		<a href='javascript: openShareDiv(5); void(0);' id='deel_link_5' class='deel_list'><!-- img src='/~company~/images/icons/" . $nfc_icon . ".png'--> <i style='font-size:30px; width:30px; padding-right:5px;' class='fa fa-share' aria-hidden='true'></i> " . $nfc_list . "</a>
		<div id='deel_div_5' class='deel_div'>

			" . $nfc_div . "

		</div>
		
		
		
		<br>
		
		<a href='~link~' class='input_submit'>~translation:z_terug~</a>

		<br><br>
		<script>
		
		function openShareDiv(thisDiv)
		{
			if(thisDiv == shareDiv) shareDiv = 0; else shareDiv = thisDiv;
			
			for(i = 1; i <= 5; i++)
			{
				if(i == shareDiv)
				{
					showMe('deel_div_' + i);
					shareScrollDiv = i;
					
					setTimeout(function(){ 
					
						$('body,html').animate({'scrollTop': $('#deel_link_' + shareScrollDiv).offset().top - 10}, 350); 
						
						document.getElementById('deel_link_' + shareScrollDiv).className = 'deel_list deel_list_selected';
						document.getElementById('deel_div_' + shareScrollDiv).className = 'deel_div deel_div_selected';
						
					}, 350);
					
		
				}
				else
				{
				
					hideMe('deel_div_' + i);
					document.getElementById('deel_link_' + i).className = 'deel_list';
					document.getElementById('deel_div_' + i).className = 'deel_div';
					
				}		
			}
		}
		
		shareDiv = 0;
		shareScrollDiv = 0;
		
		</script>
		<script> 
		if(window.location.href.indexOf('deel_qr') > -1) {
       			openShareDiv(3);
       			void(0);
    		}
		</script>
		";
		
		$html = str_replace("~deel_content~", $deel_html, $html);
	}

	// *** Delen via e-mail
	if($page == "deel" && isset($_POST["naam"]) && isset($_POST["email"]) && isset($_POST["bericht"]))
	{
		if($_POST["uwnaam"] == "" || $_POST["naam"] == "" || !preg_match('/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/', strtolower($_POST["email"])))
		{
			$html = str_replace("~html~", $pages["deel3"], $pages["global"]);
			$html = str_replace("~error~", $translation["z_u_heeft_niet_uw_naam_of"], $html);
		
		}
		else
		{
			$captcha = ((intval($_POST["c"]) / 15) - 2);
			
			if($captcha != intval($_POST["userc"]))
			{
				$html = str_replace("~html~", $pages["deel3"], $pages["global"]);
				$html = str_replace("~error~", $translation["z_u_heeft_een_verkeerde_3_cijferige"], $html);
			}	
			else
			{
				
				$html = str_replace("~html~", $pages["deel2"], $pages["global"]);
				$table = array(
        			'Š'=>'S', 'š'=>'s', 'Đ'=>'Dj', 'đ'=>'dj', 'Ž'=>'Z', 'ž'=>'z', 'Č'=>'C', 'č'=>'c', 'Ć'=>'C', 'ć'=>'c',
			        'À'=>'A', 'Á'=>'A', 'Â'=>'A', 'Ã'=>'A', 'Ä'=>'A', 'Å'=>'A', 'Æ'=>'A', 'Ç'=>'C', 'È'=>'E', 'É'=>'E',
			        'Ê'=>'E', 'Ë'=>'E', 'Ì'=>'I', 'Í'=>'I', 'Î'=>'I', 'Ï'=>'I', 'Ñ'=>'N', 'Ò'=>'O', 'Ó'=>'O', 'Ô'=>'O',
			        'Õ'=>'O', 'Ö'=>'O', 'Ø'=>'O', 'Ù'=>'U', 'Ú'=>'U', 'Û'=>'U', 'Ü'=>'U', 'Ý'=>'Y', 'Þ'=>'B', 'ß'=>'Ss',
			        'à'=>'a', 'á'=>'a', 'â'=>'a', 'ã'=>'a', 'ä'=>'a', 'å'=>'a', 'æ'=>'a', 'ç'=>'c', 'è'=>'e', 'é'=>'e',
			        'ê'=>'e', 'ë'=>'e', 'ì'=>'i', 'í'=>'i', 'î'=>'i', 'ï'=>'i', 'ð'=>'o', 'ñ'=>'n', 'ò'=>'o', 'ó'=>'o',
			        'ô'=>'o', 'õ'=>'o', 'ö'=>'o', 'ø'=>'o', 'ù'=>'u', 'ú'=>'u', 'û'=>'u', 'ý'=>'y', 'ý'=>'y', 'þ'=>'b',
			        'ÿ'=>'y', 'Ŕ'=>'R', 'ŕ'=>'r',
    			);
				$headers  = "MIME-Version: 1.0\n";
				$headers .= "Content-type: text/html; charset=iso-8859-1\n";
				// $headers .= "Reply-To: " .strtr($row_p["uwnaam"], $table) . " <" . $row_p["email"] . ">\n";
				$headers .= "From: " . strtr($row_p["uwnaam"], $table) . " <noreply@" . $whitelabel_domein . ">\n"; // $_SERVER["SERVER_NAME"]
				//$headers .= "CC:" . $row_p["volledige_naam"] . " <" . $row_p["email"] . ">\n";	

				//if($_POST["bericht"] != "") $_POST["bericht"] .= "<br><br>";				
				$_POST["bericht"] = trim($_POST["bericht"]);

				if($row_p["text_deel_email_subject"] == "") $row_p["text_deel_email_subject"] = $translation["z_email_deel_subject"];

				$subject = $row_p["text_deel_email_subject"];
				$subject = str_replace("~ontvanger~", 	$_POST["naam"], $subject);
				$subject = str_replace("~verzender~", 	$_POST["uwnaam"], $subject);
				$subject = str_replace("~bericht~", 	$_POST["bericht"], $subject);
				$subject = str_replace("~link~", 	"<a href='" . $link . "'>" . $link . "</a>", $subject);

				


				$subject = str_replace("~naam~", strtr($row_p["volledige_naam"], $table), $subject);
				$subject = str_replace("MobiCard", 	$whitelabel_naam_card, $subject);
				
				
				if($row_p["text_deel_email"] == "")
				{
					$row_p["text_deel_email"] = $translation["z_email_deel_tekst"];
				}
				
				$mailtext = $row_p["text_deel_email"];
				if(!strstr($mailtext, "~link~")) $mailtext .= "\n\n~link~";
				$mailtext = str_replace("~ontvanger~", 	$_POST["naam"], $mailtext);
				$mailtext = str_replace("~verzender~", 	$_POST["uwnaam"], $mailtext);
				$mailtext = str_replace("~bericht~", 	$_POST["bericht"], $mailtext);
				$mailtext = str_replace("~link~", 	"<a href='" . $link . "'>" . $link . "</a>", $mailtext);
				$mailtext = str_replace("~naam~", 	$row_p["volledige_naam"], $mailtext);
				$mailtext = nl2br($mailtext);
				$mailtext = str_replace("MobiCard", $whitelabel_naam_card, $mailtext);
				
				$mailtext = "<div style='font-family: arial; font-size: 12px;'>" . $mailtext . "</div>";

				mail($_POST["email"], $subject, $mailtext, $headers, "-f noreply@" . $whitelabel_domein); 


				
				/*
				$mailtext = "
				
				<div style='font-family: arial; font-size: 12px;'>

				Beste " . $_POST["naam"] . ",
				
				<br><br>
				
				" . $_POST["uwnaam"] . " wil graag dat u de Mobi Card van " . $row_p["volledige_naam"] . " bekijkt!
				
				<br><br>
								
				" . $_POST["bericht"] . "
				
				Klik op deze link om de Mobi Card te bekijken:
				<a href='" . $link . "'>" . $link . "</a> 
				
				<br><br>
				
				<i>Een Mobi Card is een digitaal visitekaartje. U kunt hier de contactgegevens van " . $row_p["volledige_naam"] . " inzien, de locatie bekijken op Google Maps, de contactgegevens opslaan in uw adresboek (vCard) en het profiel van " . $row_p["volledige_naam"] . " bekijken op social media zoals LinkedIn, Facebook en Twitter.</i>
				
				<br><br>
				
				Met vriendelijke groet,
				
				<br>
				
				" . $_POST["uwnaam"] . "
														
				";
				*/
				
				
				/*				

				Beste " . $_POST["naam"] . ",<br><br>
				
				" . $row_p["volledige_naam"] . " wil graag dat u zijn Mobi Card bekijkt!
				
				<br><br>
				
				Klik op deze link om de Mobi Card te bekijken:<br>
				<a href='" . $link . "'>" . $link . "</a>		
				
				<br><br>
				
				<i>Een Mobi Card is een digitaal visitekaartje. U kunt hier de contactgegevens van " . $row_p["volledige_naam"] . " inzien, de locatie bekijken op Google Maps, de contactgegevens opslaan in uw adresboek (vCard) en het profiel van " . $row_p["volledige_naam"] . " bekijken op social media zoals LinkedIn, Facebook en Twitter.</i>
		
				<br><br>
				
				*/
				
								
				/*
				if($_POST["bericht"] != "")
				{
					$mailtext .= "<b>Persoonlijk bericht:</b><br>
					
					" . $_POST["bericht"] . "
					
					<br><br>
					
					";
				}
				*/
				
				/*
				$mailtext .= "
				
				<i>Met vriendelijke groet,</i><br>
				" . $row_p["volledige_naam"] . "
				
				";
				*/
				
			}
			
		}
	
	}
	

	$row_p["link_bewerken"] = "<a href='" . $link4 . "/cardoptions.php?a=edit&c=" . $company . "&p=" . $person . "'>Card bewerken</a>";
	if($row_p["superuser"] == "1") $row_p["link_nieuw"] = "<a href='" . $link4 . "/cardoptions.php?a=new&c=" . $company . "&p=" . $person . "'>Nieuwe Card</a>"; else $row_p["link_nieuw"] = "";

	$html = str_replace("~footer~", $footer, $html);
	
	
	// *** Schoonmaak van lege <!--key--> en <!--/key--> en alles daartussen
	
	
	/*
	echo "<textarea>" . $html . "</textarea><hr>";
	echo "<textarea>";
	echo print_r($row_p);
	echo "</textarea>";
	echo "<textarea>";
	echo print_r($row_c);
	echo "</textarea>";
	*/


	for($i = 1; $i <= 4; $i++)
	{	
		if($row_p["extralink" . $i . "_type"] == "")
		{
			//echo "extralink DEL: " . $row_p["extralink" . $i . "_type"] . "<br>";
			$row_p["extralink" . $i] = "";
			$row_p["extralink" . $i . "_titel"] = "";
			$row_p["extralink" . $i . "_html"] = "";
		}
		else
		{
			//echo "extralink NO DEL: " . $row_p["extralink" . $i . "_type"] . "<br>";
		}
		
	}	
	
	$row_p_temp = $row_p;
			
	//while (list ($key, $val) = each ($row_p_temp))
	foreach ($row_p_temp as $key => $val)
	{
		//echo $key . ": " . $row_p[$key] . "<br>";
		
		while(strstr($html, "<!--" . $key . "-->") && strstr($html, "<!--/" . $key . "-->") && ($row_p[$key] == "" || $row_p[$key] == "0"))
		{
			//echo "- DEL " . $key . "!<br>";
			$html = substr($html, 0, strpos($html, "<!--" . $key . "-->")) . substr($html, strpos($html, "<!--/" . $key . "-->") + strlen("<!--/" . $key . "-->"));
		}
	} 
	unset($val);
	
	$row_c_temp = $row_c;
			
	//while (list ($key, $val) = each ($row_c_temp))
	foreach ($row_c_temp as $key => $val)
	{
		while(strstr($html, "<!--" . $key . "-->") && strstr($html, "<!--/" . $key . "-->") && $row_c[$key] == "")
		{
			$html = substr($html, 0, strpos($html, "<!--" . $key . "-->")) . substr($html, strpos($html, "<!--/" . $key . "-->") + strlen("<!--/" . $key . "-->"));
		}
	} 
	unset($val);

			
	// *** Tilde notaties replacen	
	if(substr($row_p["pasfoto"], 0, 7) == "/upload") $row_p["pasfoto"] = "https://app.bizzerd.com" . $row_p["pasfoto"];
	if($row_p["pasfoto"] != "") $pasfoto = "<img src='" . trim($row_p["pasfoto"]) . $antiCacheDate . "'>";
	
	$html = str_replace("~pasfoto~", $pasfoto, $html);
	$html = str_replace("~cv~", $row_p["cv"], $html);
	$html = str_replace("~pasfoto_url~", $row_p["pasfoto"], $html);
	// *** vCard notificatie vooraf wijzigen (eerst comment kunnen invullen, dan vcard tonen)
	//$vCardLink = "javascript: var personalMessage = window.prompt(\"Een contact wordt geopend in uw contactlijst. Hieronder kunt u eventueel een boodschap toevoegen aan de contact (bijvoorbeeld als geheugensteuntje):\"); document.location = \"~link2~/vcard/index.php?c=~company~&p=~person~&pm=\" + personalMessage; void(0);";

	$vCardLink = "~link2~/" . $row_p["naam"] . "/vcard";
	

	if($_SESSION["now_previewing"] == $row_c["volledige_naam"] && $row_c["volledige_naam"] != "")
	{
		$html = str_replace("~link2~/vcard/index.php?c=~company~&p=~person~", "javascript: alert(\"Deze button leidt naar de download van een vCard welke opgeslagen kan worden in het adresboek\"); void(0);", $html);
		
	}
	else
	{
		// *** Onderstaande aanzetten zorgt voor een tussenpagina voordat vcard geopend wordt, waar men een persoonlijke melding kan invullen
		//$html = str_replace("~link2~/vcard/index.php?c=~company~&p=~person~", $vCardLink, $html);
	}
		
	
	$html = str_replace("~company~", $company, $html);
	$html = str_replace("~person~", $person, $html);
	
	$html = str_replace("~title~", $row_p["volledige_naam"] . " - ". $row_c["volledige_naam"], $html);
	$html = str_replace("~og:title~", $row_p["volledige_naam"] . " - ". $row_c["volledige_naam"], $html);
	$html = str_replace("~og:description~", "Bekijk de " . $whitelabel_naam_card . " van " . $row_p["volledige_naam"] . " (". $row_c["volledige_naam"] . ")", $html);
	$html = str_replace("~deel_sms_text~", $row_p['text_deel_sms'], $html);
	//if($company == "template")

	if($_SESSION["now_previewing"] == $row_c["volledige_naam"])
	{
		$html = str_replace("~og:image~", $link2 . "/" . $company . "/images/icon150.jpg", $html);
	}
	else
	{
		$html = str_replace("~og:image~", $link2 . "/" . $company . "/images/icons/facebook.jpg", $html);
	}
	
	
	$html = str_replace("~captcha~", $captcha_html, $html);

	$html = str_replace("~bedrijf~", $row_c["volledige_naam"], $html);
	
	$html = str_replace("~volledige_naam~", $row_p["volledige_naam"], $html);
	$html = str_replace("~voorvoegsel~", $row_p["voorvoegsel"], $html);
	$html = str_replace("~voornaam~", $row_p["voornaam"], $html);
	$html = str_replace("~tussenvoegsel~", $row_p["tussenvoegsel"], $html);
	$html = str_replace("~achternaam~", $row_p["achternaam"], $html);
	$html = str_replace("~naam~", $row_p["naam"], $html);

	$html = str_replace("~functie~", str_replace("//", "<br>", $row_p["functie"]), $html);
	$html = str_replace("~website_formatted~", $row_p["website_formatted"], $html);
	$html = str_replace("~website~", addHttp($row_p["website"]), $html);
	
	$html = str_replace("~linkedin~", addHttp($row_p["linkedin"]), $html);
	$html = str_replace("~facebook~", addHttp($row_p["facebook"]), $html);
	$html = str_replace("~twitter~", addHttp($row_p["twitter"]), $html);
	$html = str_replace("~pinterest~", addHttp($row_p["pinterest"]), $html);
	$html = str_replace("~instagram~", addHttp($row_p["instagram"]), $html);
	$html = str_replace("~youtube~", addHttp($row_p["youtube"]), $html);
	$html = str_replace("~vimeo~", addHttp($row_p["vimeo"]), $html);
	$html = str_replace("~googleplus~", addHttp($row_p["googleplus"]), $html);
	$html = str_replace("~blog~", addHttp($row_p["blog"]), $html);
	$html = str_replace("~skype~", $row_p["skype"], $html);
	
	$mobiel = $row_p["mobiel_formatted"];
	if(substr( $mobiel, 0, 1 ) === "0"){
		$mobiel = "31" . ltrim($mobiel, '0');
	}
	$html = str_replace("~link~/whatsapp", "https://wa.me/" . $mobiel, $html);

	$html = str_replace("https://www.mobicard.nl/images/mobicard_i.png", "https://app.bizzerd.com/images/mobicard_i.png", $html);
	
	$html = str_replace("~mobiel_formatted~", $row_p["mobiel_formatted"], $html);
	$html = str_replace("~mobiel~", $row_p["mobiel"], $html);

	$html = str_replace("~extratekst1~", nl2br($row_p["extratekst1"]), $html);
	$html = str_replace("~extratekst2~", nl2br($row_p["extratekst2"]), $html);
	$html = str_replace("~extratekst3~", nl2br($row_p["extratekst3"]), $html);

	
	$html = str_replace("~email~", $row_p["email"], $html);
	$html = str_replace("~emailstart~", explode("@", $row_p["email"])[0], $html); 
	
	$email_formatted = $row_p["email"];
	if(strlen($email_formatted) > 27) $email_formatted = substr($email_formatted, 0, 21) . "...";
	$html = str_replace("~email_formatted~", $email_formatted, $html);
	
	
	$html = str_replace("~tel_formatted~", $row_p["tel_formatted"], $html);
	$html = str_replace("~link~/belmij", "tel:".$row_p["tel_formatted"], $html);
	$html = str_replace("~tel~", $row_p["tel"], $html);
	$html = str_replace("~fax~", $row_p["fax"], $html);	
	$html = str_replace("~adres_formatted~", $row_p["adres_formatted"], $html);
	$html = str_replace("~adres_google~", $row_p["adres_google"], $html);
	
	//echo "adres_formatted:" . $row_p["adres_formatted"] . "<br>";
	
	$html = str_replace("~adres~", $row_p["adres"], $html);

	$html = str_replace("~link_bewerken~", $row_p["link_bewerken"], $html);
	$html = str_replace("~link_nieuw~", $row_p["link_nieuw"], $html);
	
	$html = str_replace("~link_deel_email~",    'javascript: showMe("deel_email"); hideMe("deel_sms"); hideMe("deel_qr"); hideMe("deel_whatsapp");', $html);
	$html = str_replace("~link_deel_sms~",      'javascript: hideMe("deel_email"); showMe("deel_sms"); hideMe("deel_qr"); hideMe("deel_whatsapp");', $html);	
	$html = str_replace("~link_deel_qr~",       'javascript: hideMe("deel_email"); hideMe("deel_sms"); showMe("deel_qr"); hideMe("deel_whatsapp");', $html);
	$html = str_replace("~link_deel_whatsapp~", 'javascript: hideMe("deel_email"); hideMe("deel_sms"); hideMe("deel_qr"); showMe("deel_whatsapp");', $html);


	$html = str_replace("~vertalingen~", $vertalingen_div, $html);
	$html = str_replace("~language~", $_SESSION["lan"], $html);
	$html = str_replace("~nfc_div~", $nfc_div, $html);
	$html = str_replace("~nfc_list~", $nfc_list, $html);

	if($row_p["variatie_id"] != NULL){
		
		$errormsg = '<h2 align="center" style="font-family: Neo Tech Std Medium; font-size:25px; color:#FFF; font-weight:bold; line-height:50px;">We kunnen jouw bizzerd niet vinden.
	   </h2><p align="center" style="font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">
 
Misschien is de URL van jouw bizzerd verkeerd ingevuld. Of misschien is de URL veranderd. </br>
 
Kun je je bizzerd niet meer terugvinden, neem dan contact met ons op. </br></br>
</p>
<div align="center"><a align="center" style="text-decoration:none; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px; padding-right:10px;" href="tel:0882272222"><i style="padding-right:10px;"  class="fa fa-phone" area-hidden="true"></i>(088) 227 22 22</a><p style="display:inline; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;">|</p><a align="center" style="text-decoration:none; padding-left:10px; font-family:Neo Tech Std Light; color:#FFF; font-size:20px; line-height:30px;" href="mailto:contact@bizzerd.com"><i class="fa fa-envelope-o" style="padding-right:10px;" area-hidden="true"></i>contact@bizzerd.com</a></div></br>';
		
		//$query = mysql_query("SELECT * FROM mobilecard_variaties WHERE variatie_id = '" . $row_p["variatie_id"] . "';");
		//$row_v   = mysql_fetch_array($query, MYSQL_ASSOC) or errorDie($errormsg);
		$row_v = sqlRow("SELECT * FROM mobilecard_variaties WHERE variatie_id = '" . $row_p["variatie_id"] . "';") or errorDie($errormsg);
		
		$html = str_replace("~variatie~", $row_v['variatievalue'], $html);
		$html = str_replace("~variatie_id~", $row_v['variatie_id'], $html);
		$html = str_replace("~variatie_naam~", $row_v['variatienaam'], $html);
		$html = str_replace("~variatie_type~", $row_v['variatietype'], $html);

	}

	$html = str_replace("~link~", $link, $html);
	$html = str_replace("~link2~", $link2, $html);

	if(!strstr($html, "~extracss~"))
	{
		$html = str_replace("</head>", "~extracss~</head>", $html);
	}

	$html = str_replace("~extracss~", $extraCSS, $html);
	
	
	// *** Template logo
	$template_logo = $row_c["template_logo"] . $antiCacheDate;

	$strip_temp = $row_c["template_logo"];
	$strip_temp = str_replace($link3, "", $strip_temp);
	$strip_temp = trim($strip_temp);

	if($strip_temp == "") $template_logo = "http://www.mobicard.nl/images/pixel.gif";
		
	$html = str_replace("~template_logo~", $template_logo, $html);


	// *** Template artwork
	$template_artwork = $row_c["template_artwork"] . $antiCacheDate;

	$strip_temp = $row_c["template_artwork"];
	$strip_temp = str_replace($link3, "", $strip_temp);
	$strip_temp = trim($strip_temp);

	if($strip_temp == "") $template_artwork = "http://www.mobicard.nl/images/pixel.gif";
		
	$html = str_replace("~template_artwork~", $template_artwork, $html);



	for($i = 2; $i <= 10; $i++)
	{
		$html = str_replace("~RANDOM:1-" . $i . "~", ceil(rand(1, $i)), $html);
	
	}
	
	$html = str_replace("~WEEKDAY~", date("N"), $html);
	
	// *** WEEK5
	$week = date("W");
	
	$week5 = 1;
	
	for($i = 0; $i < $week; $i++)	
	{
		$week5++;
		if($week5 > 5) $week5 = 1;
	}
	
	$html = str_replace("~WEEK5~", $week5, $html);
	
	
	if($_SESSION["now_previewing"] == $row_c["volledige_naam"] && $row_c["volledige_naam"] != "")
	{
		$html = str_replace("~preview~", 1, $html);
	}
	else
	{
		$html = str_replace("~preview~", 0, $html);
	}

	// *** Reclame
	if($page != "cv" && $template == 1 && ($row_c["pakket"] == "" || $row_c["pakket"] == "1"))
	{
		/*
		$adSense = "
		
		<script async src=\"//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js\"></script>
		<!-- Mobi Card Ads -->
		<ins class=\"adsbygoogle\"
		     style=\"display:block\"
		     data-ad-client=\"ca-pub-8519558442851207\"
		     data-ad-slot=\"5287040974\"
		     data-ad-format=\"auto\"></ins>
		<script>
		(adsbygoogle = window.adsbygoogle || []).push({});
		</script>		
		
		";
		*/
		
		$html = str_replace("~reclame~", "", $html);
		//$html = str_replace("~reclame~", $adSense, $html);
	}
	else
	{
		$html = str_replace("~reclame~", "", $html);
	}
	
	
	// *** Custom iconen correctie
	if($template == 1) $html = str_replace("/icons/", "/icons_" . $row_c["template_iconen"] . "/", $html);
	
	//die("template_iconen:" . $row_c["template_iconen"]);
	
	//if($row_c["template_iconen"] != "") $html = str_replace("/icons/", "/icons_" . $row_c["template_iconen"] . "/", $html);
	
	// *** Template correctie
	if($template == 1) $html = str_replace("/" . $company . "/", "/template/", $html);
	
	for($i = 1; $i <= 4; $i++)
	{
		//echo $row_p["extralink" . $i . ""] . "<br>";
		
		if($row_p["extralink" . $i . "_type"] != "")
		{
			if($row_p["extralink" . $i . "_type"] == "page")
			{
				$row_p["extralink" . $i] = $link . "/link" . $i;
			}
			else
			{
				$row_p["extralink" . $i] .= "' target='_blank";
			}
			
			$html = str_replace("~extralink" . $i . "~", addHttp($row_p["extralink" . $i]), $html);
			
			$html = str_replace("~extralink" . $i . "_titel~", str_replace("//", "<br>", $row_p["extralink" . $i . "_titel"]), $html);
		}
	
	}

	if(strpos($row_p["text_deel_sms"], '~link~') == false) $row_p["text_deel_sms"] = $translation["z_sms_deel_tekst"]; // "Bekijk de Mobi Card van ~naam~: ~link~";
	
	
	//if(checkIphone() == 1) $sms_string = "sms:"; else $sms_string = "sms:?body=" . $row_p["text_deel_sms"] . "";
	
	
	// *** SMS	
	if(checkIOS()) $sms_string = "sms:&body=" . rawurlencode($row_p["text_deel_sms"]) . ""; else $sms_string = "sms:?body=" . rawurlencode($row_p["text_deel_sms"]) . "";
	
	$deel_sms = "

	" . $translation["z_sms_tekst"] . "
	
	<!--<br><p>" . $row_p["text_deel_sms"] . "</p><br>-->

	<br><br>

	<a href='" . $sms_string . "' class='input_submit'>" . $translation["z_stuur_een_sms"] . "</a>

	";
	
	$deel_sms = str_replace("~naam~", $row_p["volledige_naam"], $deel_sms);
	$deel_sms = str_replace("~link~", $link, $deel_sms);
	
	$html = str_replace("~deel_sms~", $deel_sms, $html);
	
	
	// *** WhatsApp
	$whatsapp_string = "whatsapp://send?text=" . rawurlencode($row_p["text_deel_sms"]) . "";
	
	$whatsapp_string = str_replace("~naam~", $row_p["volledige_naam"], $whatsapp_string);
	$whatsapp_string = str_replace("~link~", $link, $whatsapp_string);

	$html = str_replace("~deel_whatsapp~", $whatsapp_string, $html);
	
	
	if($show_qr == 1)
	{
		$html = str_replace("id='deel_qr'", "id='deel_qr' style=''", $html);
	}

	//if($company == "template")
	
	if($_SESSION["now_previewing"] == $row_c["volledige_naam"])
	{
		$script = "
		
		<script type=\"text/javascript\">
	
		function scrollDown()
		{
			$('html, body').animate({scrollTop: $(document).height()-$(window).height()}, 800);
		}
		
		function scrollUp()
		{
			$('html, body').animate({scrollTop: 0}, 'slow');		
		}
		
		</script>
		
		<div class='scrollbuttons'><a href='javascript: scrollUp(); void(0);'><img src='/template/images/scrollup.png' width='42' height='42' style='margin-bottom: 4px;'></a><br><a href='javascript: scrollDown(); void(0);'><img src='/template/images/scrolldown.png' width='42' height='42'></a></div>
		
		";
		
		$html = str_replace("~scrollbuttons~", $script, $html);
	}	
	else $html = str_replace("~scrollbuttons~", "", $html);

	$html = str_replace("icons_/", "icons/", $html);
	
	// *** Cloak e-mail
	// if(strstr($row_p["email"], "@"))
	// {
	// 	$email = $row_p["email"];
		
	// 	$temp = explode("@", $email);
	// 	//$mailto = "javascript: document.location.href = \"mai\" + \"lto:" . $temp[0] . "\" + String.fromCharCode(64) + \"" . $temp[1] . "\"; void(0);";
	// 	$mailto = 
			
	// 	$html = str_replace("mailto:" . $email, $mailto, $html);
		
	// 	$mailtoScript = "<script language=\"JavaScript\">
	// 	<!--
	// 	document.write ('" . $temp[0] . "');
	// 	document.write ('@');
	// 	document.write ('" . $temp[1] . "');
	// 	// -->
	// 	</script>";
		
	// 	$html = str_replace($email, $mailtoScript, $html);
	// }		
	
	// *** Translations
	
	$tTemp = $translation;
		
	//while (list ($key, $val) = each ($tTemp))
	foreach ($tTemp as $key => $val)
	{
		$html = str_replace("~translation:" . $key . "~", $val, $html);
	} 
	unset($val);
	
	$html = str_replace("~whitelabel~", $whitelabel, $html);
	$html = str_replace("~whitelabel_domein~", $whitelabel_domein, $html);
	$html = str_replace("~whitelabel_infopage~", $whitelabel_infopage, $html);
	
	$html = str_replace("MobiCard", $whitelabel_naam_card, $html);
	$html = str_replace("Mobicard", $whitelabel_naam_card, $html);
	$html = str_replace("MOBICARD", $whitelabel_naam_card, $html);
			
	
	// *** Show us the magic!
	// $stats_query = mysql_query("SELECT * FROM mobilecard_companies WHERE naam = '" . $company . "'");
	$current_date = date("d/m/Y-H:i:s");
	$url = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";

	//$stats_query = "INSERT INTO statistieken(person, company,"."date".", url) VALUES ('".(int)$row_p['id']."', '".(int)$row_c['id']."', '".$current_date."','".$url."');";
	//$stats_result = mysql_query($stats_query);
	$stats_result = sqlRow("INSERT INTO statistieken(person, company,"."date".", url) VALUES ('".(int)$row_p['id']."', '".(int)$row_c['id']."', '".$current_date."','".$url."');");
	
	echo $html;
	// echo "The time is " . date("");

	// echo ;
	// echo $row_p['id'];
	// echo "<div style='position: absolute; top: 0px; left: 0px;'>" . $whitelabel_naam_card . "</div>";


	function addHttp($link)
	{
		if(!stristr($link, "http://") && !stristr($link, "https://")) $link = "http://" . $link;
	
		return($link);
	}

	function checkIphone()
	{	
		if(strstr($_SERVER['HTTP_USER_AGENT'],'iPhone') || strstr($_SERVER['HTTP_USER_AGENT'],'iPod'))
		{
			return(1);
		}
		else
		{
			return(0);
		}		
				 
	}
	
	function checkIOS()
	{	
		//Detect special conditions devices
		$ua = $_SERVER['HTTP_USER_AGENT'];
		if(strstr($ua, "like ")) $ua = substr($ua, 0, strpos($ua, "like "));
		
		$iPod    = stripos($ua,"iPod");
		$iPhone  = stripos($ua,"iPhone");
		$iPad    = stripos($ua,"iPad");
		$Android = stripos($ua,"Android");
		$webOS   = stripos($ua,"webOS");
		$Mac 	 = stripos($ua, "Mac");
		$ios = false;
		
		//echo "<div style='background-color: #FF0000'>" . $ua . "<hr>";
		
		//do something with this information
		if( $iPod || $iPhone ){
		   
		    $ios = true;
		    //echo "iPod or iPhone";
		    
		}else if($iPad){

		    $ios = true;
		    //echo "iPad";

		}else if($Android){

		    $ios = false;
			
		}else if($webOS || $Mac){

		    //echo "webOS";

		    $ios = true;
		}		
		//echo "</div>";
		
		return($ios);
	}
		
	function getEmailHeaders($whitelabel_array)
	{
		$headers  = "MIME-Version: 1.0\n";
		$headers .= "Content-type: text/html; charset=iso-8859-1\n";
		$headers .= "From: " . $whitelabel_array["naam"] . " <" . $whitelabel_array["email"] . ">\n";	
		$headers .= "Reply-To: " . $whitelabel_array["naam"] . " <" . $whitelabel_array["email"] . ">\n";	
		
		return($headers);
	}
			
	// *** Databaseconnectie afsluiten
	include("./admin/databasedeconnectie.php");

?>
