<?php
class Core {
	
	public static $dbCon;
	
	
	// Maak een verbinding met de database
	public static function makeCon(){
		//Core::makeConRemote();/*
		if ( $_SERVER['HTTP_HOST'] == "mavisys" ){
			Core::makeConLocal();
		}else{
			Core::makeConRemote();
		}
			
	}
	
	public static function parseBoolean($number){
		if ( $number == 0 ){
			return false;
		}else{
			return true;
		}
	}
	
	public static function toBoolean($number){
		if ( $number == 0 ){
			return false;
		}else{
			return true;
		}
	}
	
	public static function getDomain() {
		
		$arr = $urlParts = explode('.', $_SERVER['HTTP_HOST']);
		return $arr[0];
	}
	private static function makeConLocal(){
		
		// declaratie van de namen
		/*
		$dbUser="necrom9608";    // verander door jouw gebruikersnaam
		$dbPass="Pizz@isgood9608";  // verander door jouw paswoord
		$dbHost="localhost"; // naam van de host
		$database="mav"; // naam van de database
		*/
		
		$dbUser="necrom9608";    // verander door jouw gebruikersnaam
		$dbPass="??9MuaBxFQ@73uB568*p&b8Q=n8e?-Zu";  // verander door jouw paswoord
		$dbHost="83.96.242.46"; // naam van de host
		$database="mav"; // naam van de database
		
		// verbinding maken met de mySQL server
		$mysql_id= mysql_connect("$dbHost","$dbUser","$dbPass");
		Core::$dbCon = $mysql_id;
					
		// selcteer de database
		@mysql_select_db($database) or die( "Unable to select database");
	}
	
	private static function makeConRemote(){
		
		$dbUser="limburg";    // verander door jouw gebruikersnaam

		$dbPass="??9MuaBxFQ@73uB568*p&b8Q=n8e?-Zu";  // verander door jouw paswoord
		$dbHost="83.96.242.46"; // naam van de host
		//$database="mav"; // naam van de database
		/*
		// declaratie van de namen
		$dbUser="root";    // verander door jouw gebruikersnaam
		$dbPass="";  // verander door jouw paswoord
		$dbHost="localhost"; // naam van de host
		*/
		$database="mav." . Core::getDomain();    // naam van de database
			
			
		// verbinding maken met de mySQL server
		$mysql_id= mysql_connect("$dbHost","$dbUser","$dbPass");
		Core::$dbCon = $mysql_id;
					
		// selcteer de database
		@mysql_select_db($database) or die( "Unable to select database");
	}
	
	public static function getMaxID($tabel){
		$sqlMaxID = sprintf("SELECT MAX(ID) as maxID
							 FROM %s",$tabel);
		$queryMaxID = mysql_query($sqlMaxID);
		
		
		$maxID = -1;
		
		while ($row = mysql_fetch_object($queryMaxID)) {
			$maxID = $row->maxID;
		}
		
		return $maxID;
	}
	
	public static function getToday(){
		return date("Y-m-d H:i:s");	
	}
	
	public static function makeFilteredQueryString($input, $sql, $operator = "AND"){
		for ($i = 0 ; $i < count($input) ; $i++ ){
			if (is_string($input[$i]['value'])){
				$sql .= $input[$i]['name'] . " " . $input[$i]['operator'] . " '" . Core::quote_smart($input[$i]['value']) ."'";
			}else{
				$sql .= $input[$i]['name'] . " " . $input[$i]['operator'] . " " . $input[$i]['value'];
			}
		    
		     if ( $i != count($input)-1 ){
		     	$sql.= " $operator ";
		     }
		}
		return $sql;
	}
	
	public static function quote_smart($value) {
		return $value;
		/*
		if(version_compare(phpversion(),"4.3.0") == "-1") {
			return $value;
			return mysql_escape_string($value);
		} else {
			return mysql_real_escape_string($value);
		}
		*/
		
	}
	
	public static function encrypt($input){
		$salt1 = "SOME RANDAM SHIZZLE ME DIZZLE";
		$r = $salt1 . Core::quote_smart($input) . $salt1;
		$r = $salt1 . $input . $salt1;
		return md5($r);
		
	}
	
	public static function saveSQL($input){
		mysql_select_db("taxinet");
		
		$sql = sprintf("INSERT INTO sqlTest ( sqlString ) values ( '%s' )", Core::quote_smart($input) );
		
		$query = Core::executeQuery($sql);
		
		$database="mav." . Core::getDomain();
		
		mysql_select_db($database);
	}
}
?>