<?php require_once('../Connections/Recipes.php'); ?>
<?php
//initialize the session
session_start();

// ** Logout the current user. **
$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";
if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){
  $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){
  //to fully log out a visitor we need to clear the session varialbles
  session_unregister('MM_Username');
  session_unregister('MM_UserGroup');
	
  $logoutGoTo = "../technical_library.php";
  if ($logoutGoTo) {
    header("Location: $logoutGoTo");
    exit;
  }
}
?>
<?php
session_start();
$MM_authorizedUsers = "1,2,3,4";
$MM_donotCheckaccess = "false";

// *** Restrict Access To Page: Grant or deny access to this page
function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { 
  // For security, start by assuming the visitor is NOT authorized. 
  $isValid = False; 

  // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. 
  // Therefore, we know that a user is NOT logged in if that Session variable is blank. 
  if (!empty($UserName)) { 
    // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. 
    // Parse the strings into arrays. 
    $arrUsers = Explode(",", $strUsers); 
    $arrGroups = Explode(",", $strGroups); 
    if (in_array($UserName, $arrUsers)) { 
      $isValid = true; 
    } 
    // Or, you may restrict access to only certain users based on their username. 
    if (in_array($UserGroup, $arrGroups)) { 
      $isValid = true; 
    } 
    if (($strUsers == "") && false) { 
      $isValid = true; 
    } 
  } 
  return $isValid; 
}

$MM_restrictGoTo = "../technical_library.php";
if (!((isset($_SESSION['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) {   
  $MM_qsChar = "?";
  $MM_referrer = $_SERVER['PHP_SELF'];
  if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = "&";
  if (isset($QUERY_STRING) && strlen($QUERY_STRING) > 0) 
  $MM_referrer .= "?" . $QUERY_STRING;
  $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer);
  header("Location: ". $MM_restrictGoTo); 
  exit;
}
?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "EditProfile")) {
  $updateSQL = sprintf("UPDATE tech_users SET UserFirstName=%s, UserLastName=%s, UserName=%s, UserPassword=%s, UserEmail=%s WHERE UserID=%s",
                       GetSQLValueString($_POST['FirstName'], "text"),
                       GetSQLValueString($_POST['LastName'], "text"),
                       GetSQLValueString($_POST['UserName'], "text"),
                       GetSQLValueString($_POST['Password'], "text"),
                       GetSQLValueString($_POST['EmailAddress'], "text"),
                       GetSQLValueString($_POST['UserID'], "int"));

  mysql_select_db($database_Recipes, $Recipes);
  $Result1 = mysql_query($updateSQL, $Recipes) or die(mysql_error());

  $updateGoTo = "index.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

$colname_LoggedIn = "1";
if (isset($_SESSION['MM_UserID'])) {
  $colname_LoggedIn = (get_magic_quotes_gpc()) ? $_SESSION['MM_UserID'] : addslashes($_SESSION['MM_UserID']);
}
mysql_select_db($database_Recipes, $Recipes);
$query_LoggedIn = sprintf("SELECT UserID, UserName, UserEmail FROM tech_users WHERE UserID = %s", $colname_LoggedIn);
$LoggedIn = mysql_query($query_LoggedIn, $Recipes) or die(mysql_error());
$row_LoggedIn = mysql_fetch_assoc($LoggedIn);
$totalRows_LoggedIn = mysql_num_rows($LoggedIn);

$colname_Users = "1";
if (isset($_SESSION['MM_UserID'])) {
  $colname_Users = (get_magic_quotes_gpc()) ? $_SESSION['MM_UserID'] : addslashes($_SESSION['MM_UserID']);
}
mysql_select_db($database_Recipes, $Recipes);
$query_Users = sprintf("SELECT * FROM tech_users WHERE UserID = %s", $colname_Users);
$Users = mysql_query($query_Users, $Recipes) or die(mysql_error());
$row_Users = mysql_fetch_assoc($Users);
$totalRows_Users = mysql_num_rows($Users);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Welcome to Barenbrug UK</title>
<link href="../styles/barenbrug.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style23 {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-weight: bold;
	font-size: 12px;
	color: #F7E700;
}
.style25 {font-family: "Wingdings 3"}
.style27 {
	font-family: Wingdings;
	font-size: 14px;
}
.style28 {
	font-weight: bold;
	font-size: 12px;
	font-family: Verdana, Arial, Helvetica, sans-serif;
	color: #FFFFFF;
}
.style36 {font-weight: bold; font-size: 12px; font-family: Verdana, Arial, Helvetica, sans-serif; color: #0000CC; }
.style38 {font-family: Wingdings; font-size: 14px; color: #F7E700; }
.style39 {
	font-size: 16px;
	font-weight: bold;
}
.style46 {font-size: 10px}
.style47 {font-weight: bold}
-->
</style>
</head>

<body>
<div align="center">  <table width="800"  border="0" cellspacing="0" cellpadding="0">
    <tr bgcolor="#F7E700">
      <td height="2" colspan="7" valign="top" bgcolor="#F7E700"><img src="../images/spacer.gif" alt="*" width="100%" height="4"></td>
    </tr>
    <tr bgcolor="#F7E700">
      <td width="4" rowspan="10" valign="top" bgcolor="#F7E700"><img src="../images/spacer.gif" alt="*" width="4" height="1"></td>
      <td colspan="5" valign="top" bgcolor="#F7E700"><div align="left"><img src="../images/spacer.gif" alt="*" width="1" height="20"></div></td>
      <td width="4" rowspan="10" valign="top" bgcolor="#F7E700"><img src="../images/spacer.gif" alt="*" width="4" height="4"></td>
    </tr>
	<tr bgcolor="#F7E700">
      <td height="40" rowspan="2" valign="top" bgcolor="#F7E700">&nbsp;</td>
      <td width="472" height="20" valign="middle" bgcolor="#F7E700" class="normal">&nbsp;</td>
      <td width="6" rowspan="2" valign="top" bgcolor="#F7E700">&nbsp;</td>
      <td width="256" rowspan="2" valign="top" bgcolor="#F7E700"><div align="right"><img src="../images/barenbrug_logo_250.jpg" alt="Barenbrug UK logo" width="250" height="40"></div></td>
      <td rowspan="2" valign="top" bgcolor="#F7E700">&nbsp;</td>
    </tr>
    <tr bgcolor="#F7E700">
      <td height="20" valign="middle" bgcolor="#F7E700" class="normal">&nbsp;</td>
    </tr>
    <tr bgcolor="#F7E700">
      <td valign="top" bgcolor="#F7E700"><div align="left"><img src="../images/spacer.gif" alt="*" width="1" height="6"><br>
          </div></td>
      <td valign="top" bgcolor="#F7E700" class="style10">&nbsp;</td>
      <td valign="top" bgcolor="#F7E700">&nbsp;</td>
      <td valign="top" bgcolor="#F7E700">&nbsp;</td>
      <td valign="top" bgcolor="#F7E700">&nbsp;</td>
    </tr>
    <tr bgcolor="#F7E700">
      <td width="22" height="36" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
      <td colspan="3" valign="baseline" bgcolor="#FFFFFF"><span class="normal"><img src="../images/spacer.gif" alt="*" width="1" height="10"><br>
          <span class="style39">Amenity - Mixture Selection Guide</span><br>
</span>        <hr></td>
      <td valign="baseline" bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
    <tr bgcolor="#F7E700">
      <td valign="top" bgcolor="#FFFFFF">&nbsp;</td>
      <td valign="top" bordercolor="#000000" bgcolor="#FFFFFF" class="breadcrum"><a href="../home.php">Home</a> &gt; <a href="index.php">Technical library</a> &gt; Mixture Selection Guide</td>
      <td valign="top" bgcolor="#FFFFFF" class="normal style46">&nbsp;</td>
      <td valign="top" bgcolor="#FFFFFF" class="normal style46">&nbsp;</td>
      <td valign="top" bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
    <tr bgcolor="#F7E700">
      <td width="22" valign="top" bgcolor="#FFFFFF"><div align="center"></div></td>
      <td height="313" colspan="3" valign="top" bgcolor="#FFFFFF" class="header"><table width="100%" >
        <tr>
          <td width="54%" class="header">PDF CHART OF MIXTURE SELECTION GUIDE</td>
          <td width="12%" class="normal"><div align="right" class="style11"><strong><a href="<?php echo $logoutAction ?>">Logout</a></strong></div></td>
        </tr>
      </table>
        <p class="normal style47"> Mixture Selection Guide - <a href="pdfs/Mixture%20Selection%20Guide.pdf">Download Chart in PDF Format</a> </p>
        <p class="normal"><a href="pdfs/Mixture%20Selection%20Guide.pdf"><img src="images/mixture_selection_guide.jpg" alt="Chart" width="174" height="225" border="1"></a><br>
        </p>
      </td>
      <td width="36" valign="top" bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
    <tr bgcolor="#F7E700">
      <td valign="top" bgcolor="#FFFFFF">&nbsp;</td>
      <td colspan="3" valign="top" bgcolor="#FFFFFF"><hr></td>
      <td valign="top" bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
    <tr bgcolor="#F7E700">
      <td valign="top" bgcolor="#FFFFFF">&nbsp;</td>
      <td colspan="3" valign="top" bgcolor="#FFFFFF"><div align="center"><img src="../images/nav.gif" alt="Menu" width="700" height="20" border="1" usemap="#Map">
          <map name="Map">
            <area shape="rect" coords="636,0,701,20" href="../sitemap.php" alt="Barenbrug UK Sitemap">
            <area shape="rect" coords="563,0,630,19" href="../contact.php" alt="Contact Us">
            <area shape="rect" coords="486,0,560,19" href="../links.php" alt="Useful Links">
            <area shape="rect" coords="406,0,482,20" href="../user_groups.php" alt="User Groups">
            <area shape="rect" coords="323,0,400,19" href="../press_releases.php" alt="Press Releases">
            <area shape="rect" coords="220,0,319,19" href="../technical_library.php">
            <area shape="rect" coords="158,0,213,19" href="../products.php" alt="Barenbrug UK Products">
            <area shape="rect" coords="96,0,151,19" href="../about_us.php" alt="About Barenbrug UK">
            <area shape="rect" coords="50,1,90,20" href="../home.php" alt="Homepage">
            <area shape="rect" coords="1,1,46,20" href="../menu.php" alt="Main Menu">
          </map>
      </div></td>
      <td valign="top" bgcolor="#FFFFFF">&nbsp;</td>
    </tr>
    <tr bgcolor="#F7E700">
      <td colspan="5" valign="top" bgcolor="#FFFFFF"><img src="../images/spacer.gif" alt="*" width="1" height="7"></td>
    </tr>
    <tr bgcolor="#F7E700">
      <td height="2" colspan="7" valign="top" bgcolor="#F7E700"><img src="../images/spacer.gif" alt="*" width="100%" height="4"></td>
    </tr>
    <tr bgcolor="#CCCCCC">
      <td height="19" colspan="4" valign="middle" bgcolor="#999999"><span class="style23"><span class="style25"><img src="../images/spacer.gif" alt="*" width="5" height="1">q</span> <a href="../new.php" class="yellow">NEW FROM BARENBRUG</a> <span class="style36"><span class="style38">y</span> <span class="style47"><a href="../terms.php" class="yellow">BARENBRUG UK TERMS OF BUSINESS</a> </span></span></span></td>
      <td colspan="2" valign="middle" bgcolor="#999999"><div align="right"><span class="style28"><span class="style27">o</span> <a href="../home.php" class="white">HOME</a> l <a href="../sitemap.php" class="white">SITEMAP</a> <span class="style27">m<span class="style23"><span class="style25"><img src="../images/spacer.gif" alt="*" width="5" height="1"></span></span><span class="normal">&nbsp;</span></span></span></div></td>
      <td valign="top" bgcolor="#999999">&nbsp;</td>
    </tr>
  </table>
</div>
</body>
</html>
<?php
mysql_free_result($LoggedIn);

mysql_free_result($Users);
?>