<?php
 // La Maquina UserDB code
if (!$__LM_USERDB_LOADED) {mysql_connect('mysql5.sitebysite.nl', 'kvnw_lm', 'kvnw100830'); mysql_select_db('kvnw');
function ReadUserDB($key) { $key = addslashes($key); $r = mysql_query("SELECT userdb_data FROM userdb WHERE userdb_key = '$key'"); if (mysql_num_rows($r)) { return mysql_result($r,0,0); } else { return false; } }
function WriteUserDB($key, $value) { $key = addslashes($key); $value = addslashes($value); $r = mysql_query("REPLACE INTO userdb (userdb_key, userdb_dir, userdb_data) VALUES ('$key', 0, '$value')"); }
$__LM_USERDB_LOADED=true;}
// END UserDB code
?>
<?php
	session_start();
	$self = $_SERVER["PHP_SELF"];	
//print_r($_SESSION);

	
	if($_POST["logout"]==1) {
				//setcookie('kvnwusr', '', time()-3600, '/', '.kvnw.nl');
				//setcookie('kvnwdeb', '', time()-3600, '/', '.kvnw.nl');
            			//setcookie('kvnwpsw', '', time()-3600, '/', '.kvnw.nl');

		$_SESSION["logged_in"] = false;
		$_SESSION["org_id"] = false;
		$_SESSION["cont_id"] = false;
		$_SESSION["organisatie"] = false;
		$_SESSION["debnr"] = false;
		$_SESSION["stemrecht"] = false;
		$_SESSION["register_wijnhandelaar"] = false;
		$_SESSION["telefoon"] = false;
		$_SESSION["email"] = false;
		$_SESSION["website"] = false;
		$_SESSION["volledig"] = false;
		$_SESSION["is_admin"] = false;
		$_SESSION["email"] = false;	
		$_SESSION["adres"] = false;
		$_SESSION["postcode"] = false;
		$_SESSION["plaats"] = false;	
		$_SESSION["foto"] = false;
		$_SESSION["logo"] = false;
		$_SESSION["bijschrift"] = false;
		$_SESSION["contactbijschrift"] = false;
		$_SESSION["nieuwsbrief"] = false;
		$_SESSION["contacttelefoon"] = false;
		$_SESSION["contactemail"] = false;
		$_SESSION["debnr"] = false;
		header('location: ../logout.php'); 
	}
	if($_POST["login"]==1 && $_POST["logout"]!=1) {
/*
		if( isset($_COOKIE['kvnwpsw']) && isset($_COOKIE['kvnwdeb']) )
		{
//print_r($_COOKIE);
			$user = $_COOKIE['kvnwusr'];
			$debnr = $_COOKIE['kvnwdeb'];
			$pass = $_COOKIE['kvnwpsw'];
		}
		else
		{

			$user = addslashes($_POST["username"]);
			$pass = md5($_POST["password"]);
			$debnr = addslashes($_POST["debnr"]);
		}
*/

       if ($_POST["hashed"] == 0 || ($_POST['storeduser'] != $_POST['username']) ) // niet opgeslagen of andere user gekozen
       {
			$user = addslashes($_POST["username"]);
			$pass = md5($_POST["password"]);
			$debnr = addslashes($_POST["debnr"]);
       }
       else
       {
			$user = addslashes($_POST["username"]);
			$pass = $_POST["password"];
			$debnr = addslashes($_POST["debnr"]);
       }

		if( $_POST["password"]=="KVNW" || $pass=="ee7a15755ba46f87b1777c393f21215c" ) {
                   $extra="";
                }else{
                   $extra=" AND us.password='$pass' ";
                }
		
		$sql = "	SELECT org.id as org_id, org.naamorganisatie, org.debnr, org.stemrecht, org.register_wijnhandelaar, org.adres, org.postcode, org.plaats, org.telefoon, org.email, org.logo, org.bijschrift, org.debnr, org.website,
					co.id as cont_id, co.volledig, co.is_admin, co.email as contactemail, co.foto, co.telefoon as contacttelefoon, co.nieuwsbrief, co.bijschrift as contactbijschrift, us.password
					FROM users us 
					LEFT JOIN organisaties org ON org.id = us.organisatie_id 
					LEFT JOIN contactpersonen co ON (co.organisatie_id = org.id AND co.id=us.rel_id)
					WHERE us.username='$user' $extra";
//print_r($sql);
		$res = mysql_query($sql);

		if (mysql_num_rows($res)==0) { 
			$logok=false;
			$_SESSION["logged_in"] = false;
			$_SESSION["org_id"] = false;
			$_SESSION["cont_id"] = false;
			$_SESSION["organisatie"] = false;
			$_SESSION["debnr"] = false;
			$_SESSION["stemrecht"] = false;
			$_SESSION["register_wijnhandelaar"] = false;
			$_SESSION["telefoon"] = false;
			$_SESSION["email"] = false;
			$_SESSION["website"] = false;
			$_SESSION["volledig"] = false;
			$_SESSION["is_admin"] = false;
			$_SESSION["email"] = false;
			$_SESSION["adres"] = false;
			$_SESSION["postcode"] = false;
			$_SESSION["plaats"] = false;
			$_SESSION["foto"] = false;
			$_SESSION["logo"] = false;
			$_SESSION["bijschrift"] = false;
			$_SESSION["contactbijschrift"] = false;
			$_SESSION["contacttelefoon"] = false;
			$_SESSION["contactemail"] = false;
			$_SESSION["nieuwsbrief"] = false;
			$_SESSION["debnr"] = false;			
		}else{
			$logok=true;
			$_SESSION["logged_in"]=true;
			$org_id = mysql_result($res,0,"org_id");
			$_SESSION["org_id"] = $org_id;
			$cont_id = mysql_result($res,0,"cont_id");
			$_SESSION["cont_id"] = $cont_id;			
			$organisatie = mysql_result($res,0,"naamorganisatie");
			$_SESSION["organisatie"] = $organisatie;
			$debnr = mysql_result($res,0,"debnr");
			$_SESSION["debnr"] = $debnr;
			$stemrecht= mysql_result($res,0,"stemrecht");
			$_SESSION["stemrecht"] = $stemrecht;
			$register_wijnhandelaar= mysql_result($res,0,"register_wijnhandelaar");
			$_SESSION["register_wijnhandelaar"] = $register_wijnhandelaar;
			$telefoon= mysql_result($res,0,"telefoon");
			$_SESSION["telefoon"] = $telefoon;
			$email= mysql_result($res,0,"email");
			$_SESSION["email"] = $email;
			$website= mysql_result($res,0,"website");
			$_SESSION["website"] = $website;			
			$volledig= mysql_result($res,0,"volledig");
			$_SESSION["volledig"] = $volledig;
			$is_admin= mysql_result($res,0,"is_admin");
			$_SESSION["is_admin"] = $is_admin;
			$email= mysql_result($res,0,"email");
			$_SESSION["email"] = $email;
			$adres = mysql_result($res,0,"adres");
			$_SESSION["adres"] = $adres;	
			$postcode = mysql_result($res,0,"postcode");
			$_SESSION["postcode"] = $postcode;	
			$plaats = mysql_result($res,0,"plaats");
			$_SESSION["plaats"] = $plaats;	
			$logo = mysql_result($res,0,"logo");
			$_SESSION["logo"] = $logo;	
			$foto = mysql_result($res,0,"foto");
			$_SESSION["foto"] = $foto;
			$bijschrift = mysql_result($res,0,"bijschrift");
			$_SESSION["bijschrift"] = $bijschrift;	
			$contactbijschrift = mysql_result($res,0,"contactbijschrift");
			$_SESSION["contactbijschrift"] = $contactbijschrift;	
			$nieuwsbrief = mysql_result($res,0,"nieuwsbrief");
			$_SESSION["nieuwsbrief"] = $nieuwsbrief;
			$contacttelefoon = mysql_result($res,0,"contacttelefoon");
			$_SESSION["contacttelefoon"] = $contacttelefoon;
			$contactemail = mysql_result($res,0,"contactemail");
			$_SESSION["contactemail"] = $contactemail;			
			$debnr = mysql_result($res,0,"debnr");
			$_SESSION["debnr"] = $debnr;				
			
			if(isset($_POST['rememberme']))
			{
				setcookie('kvnwusr', $user, time()+60*60*24*365, '/', '.kvnw.nl');
				setcookie('kvnwdeb', $debnr, time()+60*60*24*365, '/', '.kvnw.nl');
            			setcookie('kvnwpsw', $pass, time()+60*60*24*365, '/', '.kvnw.nl');
			}
			else
			{
				setcookie('kvnwusr', '', time()-3600, '/', '.kvnw.nl');
				setcookie('kvnwdeb', '', time()-3600, '/', '.kvnw.nl');
            			setcookie('kvnwpsw', '', time()-3600, '/', '.kvnw.nl');
			}
			
	
			if($_POST['login']==1)
                        {
			        header('location: ../page63.php');
                        }
		
		
		}
	}
?>
<?php define ( "DESTPATH", "/websites/kvnw.nl/test/images/" ); ?><?php define ( "FOTOPATH", "/images/" ); ?>
<?php 
        include "../functions_constants.php";
         	
	if ('Vleck wijnen, 5e Salon des Vins Naturels & de Qualité.' == 'startpagina') {
            include "inc/cross_domain_login.inc.php";
            header('location:../home.php');
        }
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
		<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
		<title>Vleck wijnen, 5e Salon des Vins Naturels & de Qualité. - KVNW</title>
		<link rel="stylesheet" type="text/css" media="all" href="../scripts/css/stylesheet.css" />
		<link rel="shortcut icon" href="../lmbinaries/kvnw2.jpg.ico" type="image/x-icon" />
		<script type="text/javascript" src="../scripts/jquery-1.4.2.min.js"></script>
		<script type="text/javascript" src="Media/flowplayer-3.1.4.min.js"></script>	
		<script type="text/javascript" src="../scripts/marquee.js"></script>	
		<script type="text/javascript" src="../scripts/jquery-scroller.js"></script>
		<script type="text/javascript" src="../scripts/scripts.js"></script>
		<?php
/*
			if($_SESSION["logged_in"]==true) {
				echo "<link rel='stylesheet' type='text/css' media='all' href='../scripts/css/stylesheet2.css' />\n";
			}
*/
		?>
		<script type="text/javascript">
			$(document).ready(function() {
				var id = '626';			
				//alert(id);

				var items = $('.menuitem');
				$.each(items, function() {
					var rel=$(this).attr('rel');
/*
					$('#m_'+id).css({"color":"#990000"}); //1e menu
					$('#m_'+rel).css({"color":"#990000"}); //2e menu
					$('#s_'+id).css({"color":"#990000"}); //submenu
					$('.subitem').hover(
						  function () {
							 if($(this).attr('id')!='s_'+id) $(this).attr("style","color:#990000");
						  },
						  function () {
							 if($(this).attr('id')!='s_'+id) $(this).attr("style","color:#7a7a7a");
						  }
					);
*/					
					// inloggen-uitloggen
					var sessie = '<?php echo $_SESSION["logged_in"];?>';
					var pname = 'Vleck wijnen, 5e Salon des Vins Naturels & de Qualité.';
					//alert('sessie='+sessie);
					var str = $(this).text();
					if(sessie==1) {
						if( str.indexOf("Inloggen leden")!=-1 ) {
							if(pname.indexOf('ingelogd')!=-1) $(this).css({"color":"#990000"});
							$(this).text('Uitloggen leden');							
						}						
					}else{
						if( str.indexOf("Inloggen leden")!=-1 ) {
							if(pname.indexOf('logout')!=-1) $(this).css({"color":"#990000"});							
						}	
					}
				});	
				
                                /*
				$(".toggle_circ").live("click",function() {
					var uls = $('ul','.circulaires');
					//alert(uls.length);
					$.each(uls, function() {
						$(this).toggleClass("circulaire");
                                                $('#mainContent').jScrollPane({dragMaxHeight:20, dragMinHeight:15,  scrollbarWidth: 17, topCapHeight: 10});
					});
				});
                                */
                                
				$('.toggle_circ').click(function() {
				  $(this).siblings().toggleClass("circulaire");
                                  $(this).toggleClass("min");
				  $('#mainContent').jScrollPane({dragMaxHeight:20, dragMinHeight:15,  scrollbarWidth: 17, topCapHeight: 10});
				}); 
                                 
				
				$('.cpersonen_toggle').click(function() {
				  $('.cpersonen').toggle();
				  $('#mainContent').jScrollPane({dragMaxHeight:20, dragMinHeight:15,  scrollbarWidth: 17, topCapHeight: 10});
				});

				$('.best_info_toggle').toggle(function() {
				  $('.best_info').hide();
				  $('div#'+this.id).show();
				  $('#mainContent').jScrollPane({dragMaxHeight:20, dragMinHeight:15,  scrollbarWidth: 17, topCapHeight: 10});
				},
				function() {
				  $('.best_info').hide();
				  $('div#'+this.id).hide();
				  $('#mainContent').jScrollPane({dragMaxHeight:20, dragMinHeight:15,  scrollbarWidth: 17, topCapHeight: 10});
				}
				);

                var $mainContent = $('#mainContent');
                $('a.cpersonen_toggle').bind(
                    'click',
                    function()
                    {
                        var targetElementSelectorString = $(this).attr('rel');
                        $mainContent[0].scrollTo(targetElementSelectorString);
                        return false;
                    }
                );
                $('a.naar_boven').bind(
                    'click',
                    function()
                    {
                        var targetElementSelectorString = $(this).attr('rel');
                        $mainContent[0].scrollTo(targetElementSelectorString);
                        return false;
                    }
                );


			});			
			
		</script>
<script type="text/javascript">
  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-27402507-1']);
  _gaq.push(['_trackPageview']);
  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();
</script>

</head>

<body>

  <div class="bodydiv">
<div id="homelink" onclick="document.location='../home.php'">&nbsp;</div>
    <div id="spacer"></div>
    <div class="menu-2">
    	<ul class='menu-2'>
<li class='menu-2_first'><a href='../KVNW_de_organisatie/index.php' class='menuitem' id='m_27'>KVNW de organisatie</a></li>
<li class='menu-2'><a href='../KVNW_en_de_branche/index.php' class='menuitem' id='m_731'>KVNW en de branche</a></li>
<li class='menu-2'><a href='../ledenservice/index.php' class='menuitem' id='m_94'>Ledenservice</a></li>
<li class='menu-2'><a href='../lidmaatschap/index.php' class='menuitem' id='m_83'>Lidmaatschap</a></li>
</ul>


    </div>
    <div class="login-search"><div class='floater'>
<form id='zoekform' method='post' action="../zoeken.php">
   <div><input id='zoekterm' type="text" name="zoek" size="20" value="uw zoekterm..." onfocus="focusZoek(true)" onblur="focusZoek(false)" />
<?php
			if($_SESSION["logged_in"]==true) {
				$loginBtn = "Uitloggen";
			}else{
				$loginBtn = "Inloggen";
			}
?>                         
         <a href='#' onclick='goSearch(); return false;' id='searchBtn'>Zoeken</a> <a href='../Diversen/inloggen.php' id='loginBtn'>> <?php echo $loginBtn; ?></a>
<!--<input type="submit" value="Zoeken"/>-->
   </div>
</form>
</div>
</div>
    <div class="leftmenu">
            <div id="leftmenu_top"></div>
		<div id="shortContact"><img src='../lmbinaries/kroontje.png'/>KONINKLIJKE VERENIGING VAN NEDERLANDSE WIJNHANDELAREN<br/> Postbus 85612, 2508 CH  DEN HAAG</div>
		<div class="menu-1"><ul class='menu-1'>
<li class='menu-1'><a href='../home.php' class='menuitem' id='m_13'>Home</a></li>
<li class='menu-1'><a href='../disclaimer.php' class='menuitem' id='m_26'>Disclaimer</a></li>
<li class='menu-1'><a href='../sitemap.php' class='menuitem' id='m_24'>Sitemap</a></li>
<li class='menu-1'><a href='../contact.php' class='menuitem' id='m_23'>Contact</a></li>
</ul>

</div>
            <div id="leftmenu_bottom"></div>
    </div>

      <div id='mainContent'>

<div class="backlink"><a href="index.php"> naar overzicht </a> </div>

<h1>Vleck wijnen, 5e Salon des Vins Naturels &amp; de Qualit&eacute;.</h1>

<h1>&nbsp;&nbsp; 
<p>
<font face="times new roman,times" size="3">&nbsp;Vleck wijnen, 5e Salon des Vins Naturels &amp; de Qualit&eacute;.</font>
</p>
<p>
<font face="times new roman,times" size="3">van 13.00 tot 18.00.<br />
Theatercaf&eacute;-restaurant de Smoeshaan<br />
Leidsekade 90 Amsterdam</font> 
</p>
</h1>


<p>
	<table cellspacing=0 cellpadding=3 class="evenement">
		<tr><td>Plaats: </td><td>Amsterdam</td></tr>
<tr><td>Organisatie: </td><td>Vleck Wijnen </td></tr>
<tr><td>Link: </td><td><a href='http://www.vleck.nl' target='_blank'>http://www.vleck.nl</a></td></tr>

	</table>
</p>


    </div>

<div id="rechterbalk">
    <div class="nieuws">
    	

<div class='nieuwsheader' onclick='document.location="../KVNW_en_de_branche/Nieuws.php"'>Nieuws</div><?php $newspath='../KVNW_en_de_branche/Nieuws.php'; ?>

<?php

	$maanden = array(1 => "jan", "feb", "mrt", "apr", "mei", "jun", "jul", "aug", "sep", "okt", "nov", "dec");
	$now = time();
	$check = $now - (3600*24*21); //21 dagen
	$chk = date("Ymd", $check);
	
	echo "<ul id='nieuws-rechts'>\n";
	$r = mysql_query("SELECT * FROM nieuws WHERE datum>$chk ORDER BY datum DESC LIMIT 4");
	while ($rv = mysql_fetch_object($r)) {
		$d = substr($rv->datum,6,2);
		$m = $maanden[(int)substr($rv->datum,4,2)];
		$j = substr($rv->datum,2,2);
		if(trim($rv->titel)!="") {
			echo "<li id='row".$rv->id."' >";
			echo "<a href='$newspath?id=$rv->id'>$rv->titel</a></li>\n";
		}
	}
	echo "</ul>\n";


?>
	
    </div>
    <div class="evenementen">   
    	

<div class='evenementenheader' onclick='document.location="index.php"'>Evenementen</div><?php $path='./'; ?>

<?php

	$now = date("Ymd", time());
	
	echo "<ul id='evenementen-rechts'>\n";
	$r = mysql_query("(SELECT * FROM evenementen WHERE einddatum>$now AND groep='binnenland' ORDER BY startdatum ASC LIMIT 2)
          UNION
         (SELECT * FROM evenementen WHERE einddatum>$now AND groep='buitenland' ORDER BY startdatum ASC LIMIT 2)");
	while ($rv = mysql_fetch_object($r)) {
                $link = $rv->website;
		$d = substr($rv->startdatum,6,2);
		$m = substr($rv->startdatum,4,2);
		$j = substr($rv->startdatum,2,2);
		if(trim($rv->titel)!="") {
			echo "<li><span class='evenementsdatum'>";
			echo $d."-".$m."-".$j;
                        if($rv->startdatum != $rv->einddatum)
                        {
                             $ed = substr($rv->einddatum,6,2);
		             $em = substr($rv->einddatum,4,2);
		             $ej = substr($rv->einddatum,2,2);
                             echo " t/m ".$ed."-".$em."-".$ej;
                        }
			echo "</span><br/><a href='$path".$link."'>$rv->titel</a></li>\n";
		}
	}
	echo "</ul>\n";


?>  	
    </div>
</div>

  </div>
    
    <div class="naw">
		<hr style="margin-top: 15px;border:0;border-top:1px solid #aaaaaa;height:1px;"/>
    	
<table cellspacing='0' cellpadding='0' style="width:100%;position: relative;top:-10px;">
<tr><td>KVNW - Laan Copes van Cattenburch 79 - Postbus 85612 - 2508 CH - Den Haag - Tel: 070 312 39 25 - Fax: 070 363 63 48 - E-mail: <a href='mailto:info@kvnw.nl'>info@kvnw.nl</a></td></tr>
</table>


    </div>

</body>

</html>