<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_t77_connect = "";
$database_t77_connect = "";
$username_t77_connect = "";
$password_t77_connect = "";

$security = 'yes'; //set to yes if you want to enable the login screen

$omis_hostname = "http://yourhost/omis/";

//the full path to your omis installation 
//on Unix/Linux use "/path/to/your/omis/dir/"
//on Windows use "c:/path/to/your/omis/dir/"
$omis_path = "/path/to/your/omis/dir/"; 

//////////////////////////////////////////////////////////////////////////////////////////
/// no editing needed beyond this point //////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////

$t77_connect = @mysql_pconnect($hostname_t77_connect, $username_t77_connect, $password_t77_connect) or die("<span style=\"font-family:Arial, Helvetica, sans-serif; font-size:12px; font-weight:bold; color:#CC0000\" >Cannot connect to host...</span>");


if($security == 'yes' && $loginfile != 1) {
	
	session_start();
	$MM_authorizedUsers = "";
	$MM_donotCheckaccess = "true";
	
	// *** 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 log in. 
		// 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 == "") && true) { 
		  $isValid = true; 
		} 
	  } 
	  return $isValid; 
	}
	
	$MM_restrictGoTo = "fail.php";
	if (!((isset($HTTP_SESSION_VARS['MM_Username'])) && (isAuthorized("",$MM_authorizedUsers, $HTTP_SESSION_VARS['MM_Username'], $HTTP_SESSION_VARS['MM_UserGroup'])))) {   
	  $MM_qsChar = "?";
	  $MM_referrer = $HTTP_SERVER_VARS['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;
	}
}

function DateAndTime($timestamp)
{
       list($year,$month,$day,$hour,$minute,$second) =
             sscanf($timestamp,"%4s%2s%2s%2s%2s%2s");

       setlocale(LC_TIME,"nl_NL.ISO8859-hide@address.com");

       return strftime("%d-%m-%Y",
             mktime($hour,$minute,$second,
             $month,$day,$year));
}
?>