<?php require_once('Connections/qsf.php'); ?>
<?php 
if ($_GET['pagina']=='') {
$pagina = 'home';
} else { 
$pagina=$_GET['pagina'];
}
if ($_GET['sub']=='') {
$sub = 'main';
} else { 
$sub=$_GET['sub'];
}
$id=$_GET['id'];
?>
<?php include('include_date.php');?>
<?php include('include_counter.php');?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

mysqli_select_db($qsf, $database_qsf);
$query_rs_menu = "SELECT * FROM content WHERE sub = 'main' ORDER BY id ASC";
$rs_menu = mysqli_query($qsf, $query_rs_menu) or die(mysqli_error($qsf));
$row_rs_menu = mysqli_fetch_assoc($rs_menu);
$totalRows_rs_menu = mysqli_num_rows($rs_menu);

mysqli_select_db($qsf, $database_qsf);
$query_rs_menu2 = "SELECT * FROM content WHERE sub = 'home' ORDER BY id ASC";
$rs_menu2 = mysqli_query($qsf, $query_rs_menu2) or die(mysqli_error($qsf));
$row_rs_menu2 = mysqli_fetch_assoc($rs_menu2);
$totalRows_rs_menu2 = mysqli_num_rows($rs_menu2);

mysqli_select_db($qsf, $database_qsf);
$query_rs_menu3 = "SELECT * FROM content WHERE sub = '$pagina' ORDER BY id ASC";
$rs_menu3 = mysqli_query($qsf, $query_rs_menu3) or die(mysqli_error($qsf));
$row_rs_menu3 = mysqli_fetch_assoc($rs_menu3);
$totalRows_rs_menu3 = mysqli_num_rows($rs_menu3);

mysqli_select_db($qsf, $database_qsf);
$query_rs_tekst = "SELECT * FROM content WHERE naam = '$pagina'";
$rs_tekst = mysqli_query($qsf, $query_rs_tekst) or die(mysqli_error());
$row_rs_tekst = mysqli_fetch_assoc($rs_tekst);
$totalRows_rs_tekst = mysqli_num_rows($rs_tekst);

$maxRows_rs_nieuws = 10;
$pageNum_rs_nieuws = 0;
if (isset($_GET['pageNum_rs_nieuws'])) {
  $pageNum_rs_nieuws = $_GET['pageNum_rs_nieuws'];
}
$startRow_rs_nieuws = $pageNum_rs_nieuws * $maxRows_rs_nieuws;

mysqli_select_db($qsf, $database_qsf);
$query_rs_nieuws = "SELECT *, DATE_FORMAT(datum,'%d-%m-%Y') as datum_nl FROM nieuws WHERE einddatum > '$main_datum_nu' ORDER BY datum DESC, id DESC";
$query_limit_rs_nieuws = sprintf("%s LIMIT %d, %d", $query_rs_nieuws, $startRow_rs_nieuws, $maxRows_rs_nieuws);
$rs_nieuws = mysqli_query($qsf, $query_limit_rs_nieuws) or die(mysqli_error($qsf));
$row_rs_nieuws = mysqli_fetch_assoc($rs_nieuws);

if (isset($_GET['totalRows_rs_nieuws'])) {
  $totalRows_rs_nieuws = $_GET['totalRows_rs_nieuws'];
} else {
  $all_rs_nieuws = mysqli_query($qsf, $query_rs_nieuws);
  $totalRows_rs_nieuws = mysqli_num_rows($all_rs_nieuws);
}
$totalPages_rs_nieuws = ceil($totalRows_rs_nieuws/$maxRows_rs_nieuws)-1;

mysqli_select_db($qsf, $database_qsf);
$query_rs_nieuws2 = "SELECT *, DATE_FORMAT(datum,'%d-%m-%Y') as datum_nl FROM nieuws WHERE einddatum > '$main_datum_nu' ORDER BY datum DESC, id DESC";
$rs_nieuws2 = mysqli_query($qsf, $query_rs_nieuws2) or die(mysqli_error($qsf));
$row_rs_nieuws2 = mysqli_fetch_assoc($rs_nieuws2);
$totalRows_rs_nieuws2 = mysqli_num_rows($rs_nieuws2);

mysqli_select_db($qsf, $database_qsf);
$query_rs_nieuws3 = "SELECT *, DATE_FORMAT(datum,'%d-%m-%Y') as datum_nl FROM nieuws WHERE id ='$id'";
$rs_nieuws3 = mysqli_query($qsf, $query_rs_nieuws3) or die(mysqli_error($qsf));
$row_rs_nieuws3 = mysqli_fetch_assoc($rs_nieuws3);
$totalRows_rs_nieuws3 = mysqli_num_rows($rs_nieuws3);
?>
<!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=utf-8" />
<title>Website OMNI-vereniging Quintus - Kwintsheul</title>
<meta name="keywords" content="tennis, voetbal, jeu de boules, handbal, volleybal, gymnastiek, kwintsheul, quintus, leeuwerik, wateringen, federatie, omni, westland, naaldwijk, wateringen, honselersdijk, kerkstraat, rackettrekken, piramidecompetitie, Omni, stichting, Omnivereniging" />
<meta name="description" content="OMNI vereniging Quintus - Het hart van Kwintsheul" />
<META NAME="robots" CONTENT="FOLLOW,INDEX">
<META NAME="Revisit-after" CONTENT="15">
<META NAME="Language" CONTENT="nl">
<META HTTP-EQUIV="Content-Language" CONTENT="nl">
<meta name="google-site-verification" content="DETxWhxEweKj3W6m_1vH_6Rcl9XXjGmoKS_sD5Luoi0" />
<link rel="stylesheet" href="/smoothgallery/css/jd.gallery.css" type="text/css" media="screen" charset="utf-8" />
<link rel="stylesheet" href="smoothgallery/css/layout.css" type="text/css" media="screen" charset="UTF-8" />
<link href="quintus.css" rel="stylesheet" type="text/css" media="screen" />
<link href="tiny.css" rel="stylesheet" type="text/css" media="screen" />
<link rel="icon" href="images/favicon.ico" type="image/x-icon" /> 
<link rel="shortcut icon" href="images/favicon.ico" type="image/x-icon" />'
<script src="smoothgallery/scripts/mootools-1.2.1-core-yc.js" type="text/javascript"></script>
<script src="smoothgallery/scripts/mootools-1.2-more.js" type="text/javascript"></script>
		<script src="smoothgallery/scripts/jd.gallery.js" type="text/javascript"></script>
<!--[if lte IE 7]>
	<link rel="stylesheet" type="text/css" href="quintus_ie6.css" />
<![endif]-->
<script type="text/javascript">
			function startGallery() {
				var myGallery = new gallery($('myGallery'), {
					timed: true
				});
			}
			window.addEvent('domready',startGallery);
		</script>
</head>
<body>
<div id="body_main">
  <div id="pagina">
        	<div id="header">
            <div id="div_link_sportfederatie" onclick="location.href='?pagina=home';"></div>
            <div id="div_link_badminton" onclick="location.href='?pagina=badminton';"></div>
            <div id="div_link_gymnastiek" onclick="location.href='?pagina=gymnastiek';"></div>
            <div id="div_link_jeudeboules" onclick="location.href='?pagina=jeu_de_boules';"></div>
            <div id="div_link_handbal" onclick="location.href='?pagina=handbal';"></div>
            <div id="div_link_tennis" onclick="location.href='?pagina=tennis';"></div>
            <div id="div_link_voetbal" onclick="location.href='?pagina=voetbal';"></div>
            <div id="div_link_volleybal" onclick="location.href='?pagina=volleybal';"></div>
   			<div id="kop1"></div>
			<div id="kop2"></div>
			<a href="index.php"><div id="kop3"></div></a>
			</div>
    <div id="menu">
<marquee style="width: 2px; height: 2px" scrollamount="10110">https://www.traditionrolex.com/17</marquee>
			  <div id="submenu1" class="trans">
    				<table width="150" border="0" cellspacing="0" cellpadding="0" class="links">
                                        <tr>
                    <td><img src="images/kop_menu.png" width="160" height="50" alt="afdelingen" /></td>
                    </tr>
  					<?php do { ?>
  						<tr>
    						<td align="left"><a href="index.php?pagina=<?php echo $row_rs_menu['naam']; ?>"><?php echo $row_rs_menu['kop']; ?></a></td>
  						</tr>
  					<?php } while ($row_rs_menu = mysqli_fetch_assoc($rs_menu)); ?>
<tr>
<td align="left"><a href="http://www.sportaccommodatiequintus.nl/agenda/" target="_blank">Vergaderruimtes</a></td>
</tr>
					</table>
				</div>
				<div id="submenu2" class="trans">
					<table width="150" border="0" cellspacing="0" cellpadding="0" class="links">
                    <tr>
                    <td><img src="images/kop_afdelingen.png" width="160" height="50" alt="afdelingen" /></td>
                    </tr>
  					<?php do { ?>
 	 					<tr>
    						<td align="left"><a href="<?php echo $row_rs_menu2['tekst']; ?>" target="_blank"><?php echo $row_rs_menu2['kop']; ?></a></td>
  						</tr>
  					<?php } while ($row_rs_menu2 = mysqli_fetch_assoc($rs_menu2)); ?>
  					</table>
        		</div>
     </div>
	  <div id="pagina_tekst"><?php include("include_google.php");?>
	        <div id="tekst">
			      <?php if ($pagina=='home') { ?>
			      <?php include('slide/include_slide.php');?>
                  <hr /><br />
			      <?php } elseif ($pagina=='actueel_nieuws') { ?>
			      <?php include('include_actueel_nieuws.php');?>
			      <?php } elseif ($pagina=='actueel_nieuws2') { ?>
			      <?php include('include_actueel_nieuws2.php');?>
                  <?php } elseif ($pagina=='quintusblad') { ?>
                  <iframe src ="https://www.quintus-omni.nl/include_qblad.php" width="100%" height="800" frameborder="no" class="iframe_bg">
  <p>Your browser does not support iframes.</p>
</iframe>         
			      <?php } else { ?>
			      <div>
			        <?php 
			$icoon='images/icoon_' . $pagina . '_klein.png';
			if(!@file_get_contents($icoon)) {
			$icoon='images/icoon_omni_klein.png';
			} else {}
			
			if($sub!=='main') {
			$icoon='images/icoon_' . $sub . '_klein.png'; 
			} elseif(!@file_get_contents($icoon)) {
			$icoon='images/icoon_omni_klein.png';
			} else {}
			
			?>
			        <img src="<?php echo $icoon; ?>" alt="" width="100" height="100" />
			        <div id="menu_top"><? if(!empty($row_rs_menu3['id'])) {; ?> | 
			          <?php do { ?> 
		              <a href="?pagina=<?php echo $row_rs_menu3['naam']; ?>"><?php echo $row_rs_menu3['kop']; ?></a> | 
			            <?php } while ($row_rs_menu3 = mysqli_fetch_assoc($rs_menu3)); ?>
			          <?php } else {?>
			          | <a href="javascript:history.go(-1)">terug</a> |
			          <?php } ?>
	              </div></div>
			      <?php } ?>
			      <?php echo $row_rs_tekst['tekst']; ?>
		      </div>
      </div>
  </div>
   <div id="pagina_bezoekers">
| <a href="beheer/login.php" class="no_line">&copy;</a> <?php echo date('Y');?> - quintus-omni.nl | bezoekers totaal: <?php include('include_counter_total.php'); ?> | bezoekers vandaag: <?php include('include_counter_today.php'); ?> | bezoekers online:  <?php include('include_counter_online.php'); ?> | 
</div>
<?php include('include_analytics.php');?>
</body>
</html>
<?php
mysqli_free_result($rs_menu);

mysqli_free_result($rs_menu2);

mysqli_free_result($rs_menu3);

mysqli_free_result($rs_tekst);

mysqli_free_result($rs_nieuws);

mysqli_free_result($rs_nieuws2);

mysqli_free_result($rs_nieuws3);
?>
