<?
/********************************HIER VARIABELEN INVULLEN*********************************/
session_start();

#Aantal items in een keer op scherm in het content frame
$limit  = 10;

function SetPathImgs($file_name,$sort)
{
	    if($sort == 0){$path  = "data/thumbs1db/".$file_name;}#Thumbnail
	elseif($sort == 1){$path  = "data/thumbs2db/".$file_name;}#Thumbnail
	elseif($sort == 2){$path  = "data/imagesdb/".$file_name;}#Image fullsize
	elseif($sort == 3){$path  = "data/documents/".$file_name;}#Image fullsize
	return $path;
}

#array met fieldnames, die hun schermwaarde vanuit andere tabel moeten halen
#fk_fieldname = array(tablename(andere),schermveld(andere),key)
//$arrFKS['fk_groepid'] = array('status','status','id');
$arrFKS['fk_groepid'] = array('groepen','groepnaam','id');
#bijbehorende functie
function FK2K($fk)
{
	global $arrFKS;
	if(strpos($fk,",") > 0)
	{
		$arrfk = explode(",",$fk);
		$sqlFK  = "SELECT ".$arrFKS['Fk_Model'][1]." FROM ".$arrFKS['Fk_Model'][0]." WHERE ";
		$num0R = 1;
		foreach($arrfk as $fk)
		{
			$sqlFK .= $arrFKS['Fk_Model'][2]." = '".$fk."' ".($num0R<count($arrfk)?"OR ":"");
			$num0R++;
		}
	}
	else
	{
		$sqlFK  = "SELECT ".$arrFKS['fk_groepid'][1]." FROM ".$arrFKS['fk_groepid'][0]." WHERE ".$arrFKS['fk_groepid'][2]." = '".$fk."'";		
	}
	$arrRet = array();
	$resFK = mysql_query($sqlFK) or die(mysql_error());
	while($rowFK = mysql_fetch_row($resFK))
	{
		$arrRet[] = $rowFK[0];		
	}
	return implode(",",$arrRet);
}
/*
#Vul arrays tbv eventuele selectboxes
$counter = 1;#detecteert de eerste selectbox, tbv onChangeEvent
$sqlGr = "SELECT id,groep FROM groepen ORDER BY groep";
$resGr = mysql_query($sqlGr) or die(mysql_error());
$r = 0;
while($rowGr = mysql_fetch_object($resGr))
{
	$arr_opt_val['fk_groep'][$r] = $rowGr -> id;
	$arr_opt_txt['fk_groep'][$r] = ucfirst($rowGr -> groep);
	$r++;
}

$sqlSG = "SELECT sg.id AS id, sg.fk_groep, g.groep AS groepnaam, sg.subgroep FROM subgroepen sg, groepen g WHERE g.id = sg.fk_groep ORDER BY groepnaam";
//$sqlSG = "SELECT id,subgroep FROM subgroepen ORDER BY subgroep";
$resSG = mysql_query($sqlSG) or die(mysql_error());
$r = 0;
while($rowSG = mysql_fetch_object($resSG))
{
	$arr_opt_val['fk_subgroep'][$r] = $rowSG -> id;
	$arr_opt_txt['fk_subgroep'][$r] = $rowSG -> subgroep;
	$r++;
}
*/
/*
$sqlStat = "SELECT id,groepnaam FROM groepen ORDER BY id";
$resStat = mysql_query($sqlStat) or die(mysql_error());
$r = 0;
#voeg hem toe aan een array om de waarde weer door te kunnen posten
$arrAdd2Post[] = "fk_groepid";
while($rowStat = mysql_fetch_object($resStat))
{
	$arr_opt_val['fk_groepid'][$r] = $rowStat -> id;
	$arr_opt_txt['fk_groepid'][$r] = $rowStat -> groepnaam;
	$r++;
}
*/

#Sizes opslag verschillende thumbs en images
function SetImgSizes($tablename)
{
	$arr_sizes[0]= 120;#Maximale breedte thumb1
	$arr_sizes[1]=  90;#Maximale hoogte  thumb1
	$arr_sizes[2]= 180;#Maximale breedte thumb2
	$arr_sizes[3]= 135;#Maximale hoogte  thumb2
	$arr_sizes[4]= 640;#Maximale breedte image
	$arr_sizes[5]= 480;#Maximale hoogte  image
	
	return($arr_sizes);
}

function LABEL($name)
{
	global $db_name;
	$arrNames[$db_name] 		 = "Tuintechniekeefde";
	$arrNames['username']        = "Gebruikersnaam";
	$arrNames['password']        = "Wachtwoord";
	$arrNames['rights']          = "Rechten";
	$arrNames['id']              = "Id";
	$arrNames['periode_id']      = "Periode als nummer";
	$arrNames['periode_txt']     = "Periode als tekst";
	$arrNames['menutitel']       = "Titel tbv uitklapmenu(max 20 tekens)";
	$arrNames['fk_groepid']      = "Groepsnaam";
	$arrNames['url']             = "Website";
	$arrNames['text']            = "Tekstblok";
	$arrNames['txtzomer']        = "Tekstblok zomer";
	$arrNames['txtwinter']       = "Tekstblok winter";
	$arrNames['txtcursief']      = "Tekstblok schuin";
	$arrNames['images']          = "Afbeeldingen";
	$arrNames['date']            = "Datum";
	$arrNames['header']          = "Koptekst";
	$arrNames['pre_text']        = "Voortekst";
	$arrNames['main_text']       = "Hoofdtekst";
	$arrNames['image']           = "Afbeelding";
	$arrNames['date']            = "Datum";
	$arrNames['status']          = "Op website";
	
	return isset($arrNames[$name]) ? $arrNames[$name] : ucfirst($name);
}	
/********************************EINDE VARIABELEN INVULLEN**********************************/
?><style>
#screen
{
	display:none;
	position:absolute; 
	left:0px; 
	top:0px; 
	width:0px;
	height:0px;
	z-index:123456;
	/*filter:alpha(opacity=0);
	opacity: 0;
	-moz-opacity:0;*/	
	text-align:center;
	vertical-align:middle;
	background-color:#000000;
	
}
#subscreen
{
	display:none;
	position:absolute; 
	z-index:234578;
	border:solid 10px #ffffff;
	background-color:#ffffff;
	/*filter:alpha(opacity=0);
	opacity: 0;
	-moz-opacity:0;*/
}

#subtxt
{
	display:none;
	position:relative;
	float:left;
	font-weight:bold;
	color:#555555;	
	margin-top:13px;
	background-color:#ffffff;
}
</style>
<script>
var browser = navigator.appName=='Netscape'?'FF':'IE';

var Interval = 0;
var opacIE = 1; 
var opacFF = 0.1; 

function ShowImg()
{	
	opacIE = parseInt(Interval/imgH*100); 
	opacFF = Interval/imgH; 
	
	document.getElementById('subscreen').style.display = "block";	
	document.getElementById('subscreen').style.filter  = 'alpha(opacity='+opacIE+')';
	document.getElementById('subscreen').style.opacity = opacFF;	
	
	/*Van middelpunt inzoomen*/
	//document.getElementById('subscreen').style.top     = (screen.height/2) - (Interval/2) - 135;
	//document.getElementById('subscreen').style.height  = Interval + 'px';
	//document.getElementById('imgsub').style.height     = Interval + 'px';	
	
	//document.getElementById('subscreen').style.left    = (screen.width/2) - (Interval/2*imgW/imgH);	
	//document.getElementById('subscreen').style.width   = Interval*imgW/imgH;
	//document.getElementById('imgsub').style.width      = Interval*imgW/imgH;
	
	/*Alleen van vaag naar helder*/
	document.getElementById('subscreen').style.top       = (screen.height/2) - 135 - imgH/2;
	document.getElementById('subscreen').style.height    = imgH;
	document.getElementById('subscreen').style.left      = (screen.width/2) - imgW/2;	
		
	if(Interval >= imgH)
	{
		clearInterval(makesteps);
		
		document.getElementById('imgsub').style.filter  = 'alpha(opacity=100)';
		document.getElementById('imgsub').style.opacity = 1;		
		document.getElementById('imgsub').style.width   = imgW;
		document.getElementById('imgsub').style.height  = imgH;
		
		document.getElementById('subscreen').style.filter  = 'alpha(opacity=100)';
		document.getElementById('subscreen').style.opacity = '1';		
		document.getElementById('subscreen').style.height  = imgH + 35;
		document.getElementById('subscreen').style.cursor  = 'pointer';	
		document.getElementById('subscreen').onclick = function(){document.getElementById('subscreen').style.display='none';document.getElementById('screen').style.display='none';}	
				
		document.getElementById('subtxt').style.display = "block";
		document.getElementById('subtxt').style.backgroundColor = "#ffffff";
		
		document.onkeydown = KeyHandler;
						
		Interval = 0;
	}
	Interval = Interval + (browser=='IE' ? 15 : 5);
}

function KeyHandler(e)
{	
	if(!e){var e = window.event;}
	if(e.keyCode){code = e.keyCode;}
	else if (e.which){code = e.which;}
	if(code == 27){document.getElementById('subscreen').onclick();}
}

function BigPic(obj)
{	
	img_tmp = new Image();
	img_tmp.src = obj.src.replace("thumbs2db","imagesdb");
	<?$arr_sizes = SetImgSizes($tablename);?>
	img_tmp.width  ? imgW = img_tmp.width  : imgW = <br />
<b>Warning</b>:  Undefined variable $arr_sizes in <b>/home/tuintechn/domains/tuintechniekeefde.nl/public_html/files/bigpic.php</b> on line <b>110</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on null in <b>/home/tuintechn/domains/tuintechniekeefde.nl/public_html/files/bigpic.php</b> on line <b>110</b><br />
;//tbv FF
	img_tmp.height ? imgH = img_tmp.height : imgH = <br />
<b>Warning</b>:  Undefined variable $arr_sizes in <b>/home/tuintechn/domains/tuintechniekeefde.nl/public_html/files/bigpic.php</b> on line <b>111</b><br />
<br />
<b>Warning</b>:  Trying to access array offset on null in <b>/home/tuintechn/domains/tuintechniekeefde.nl/public_html/files/bigpic.php</b> on line <b>111</b><br />
;//tbv FF	
	
	if(obj.getAttribute('setdia'))
	{
		var subscript = obj.getAttribute('setdia').replace("dia[","");
		    subscript = subscript.replace("]","");
	}
	else{var subscript = "&nbsp;";}	
		
	document.getElementById('screen').style.width    = screen.width;
	document.getElementById('screen').style.height   = screen.height;
	document.getElementById('screen').style.filter   = 'alpha(opacity=90)';
	document.getElementById('screen').style.opacity  = 0.9;
	document.getElementById('screen').style.display  = "block";
	
	document.getElementById('subscreen').style.cursor = 'arrow';	
	document.getElementById('subscreen').onclick     = function(){}	
	document.getElementById('subscreen').innerHTML   = "<img id=imgsub src=\""+img_tmp.src+"\">";
	document.getElementById('subscreen').innerHTML  += "<br>";
	document.getElementById('subscreen').innerHTML  += "<div id=\"subtxt\">"+subscript+"</div>";
	
	makesteps = setInterval("ShowImg()",(browser=='IE' ? 5 : 5));	
}

var anchor;

function TwnIni()
{
	var anchors = document.getElementsByTagName('img');	
		
	for (var i=0; i<anchors.length; i++)
	{
		anchor = anchors[i];
		var relAttribute = String(anchor.getAttribute('setdia'));
				
		if (anchor.getAttribute('setdia') && (relAttribute.toLowerCase().match('dia')))
		{
			anchor.onclick = function(){BigPic(this); return false;}										
		}
	}
}

setTimeout("window.onLoad = TwnIni()",100);
</script>
<div id="screen"></div>
<div id="subscreen"></div>

<html>
<head>
<title>Tuintechniekeefde</title>
<link rel="stylesheet" href="files/layout.css" type="text/css">
<script language="javascript" SRC="files/buttons.js"></script>
<meta http-equiv="keywords" content="">
</head>
<body style="overflow:hidden;" bgcolor="#82ba3f" onLoad="Change_Fotos();">
<div id="main">
	<div id="menu">
		<script language="javascript">
var diashow = new Array();
<?
$sql = "SELECT * FROM diashow WHERE id = 1";
$res = $conn->query($sql);
$row = $res->fetch_assoc();
$images = $row['images'];
$arrImages = explode(",",$images);
$counter = 0;
foreach($arrImages as $image)
{
	echo("diashow[".$counter."]  = '<a href=\"beheer/data/imagesdb/".$image."\" rel=lightbox[diashow] title=\"Diashow: dia ".$counter."\"><img style=\"border:solid 2px #82BA3F;\" src=\"beheer/data/thumbs1db/".$image."\" border=\"0\"></a>';\n");
	$counter++;
}
?>
var I = 0;

function Change_Fotos()
{ 
	document.getElementById('diashow').innerHTML = diashow[I];
	timerID=setTimeout('Change_Fotos()', 2000);
	I++;	
	if(I == <br />
<b>Warning</b>:  Undefined variable $arrImages in <b>/home/tuintechn/domains/tuintechniekeefde.nl/public_html/files/menu.php</b> on line <b>23</b><br />
<br />
<b>Fatal error</b>:  Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null given in /home/tuintechn/domains/tuintechniekeefde.nl/public_html/files/menu.php:23
Stack trace:
#0 /home/tuintechn/domains/tuintechniekeefde.nl/public_html/header.php(21): include()
#1 /home/tuintechn/domains/tuintechniekeefde.nl/public_html/home.php(3): include('/home/tuintechn...')
#2 {main}
  thrown in <b>/home/tuintechn/domains/tuintechniekeefde.nl/public_html/files/menu.php</b> on line <b>23</b><br />