<?php
	require_once 'DB.php';

	//
	// Settings class
	// defines parameters for connecting to the Database
	// and defualt application settings
	//
	class Settings {
		var $defaultPath;
		var $defaultTemplate;
	
		var $phptype;
		var $username;
		var $password;
		var $hostspec;
		var $database;
	
		function setDefaultPath($value) {
			$this->defaultPath = $value;
		}
	
		function getDefaultPath() {
			return $this->defaultPath;
		}	
	
		function setDefaultTemplate($value) {
			$this->defaultTemplate = $value;
		}
	
		function getDefaultTemplate() {
			return $this->defaultTemplate;
		}	
	
		function setPhptype($value) {
			$this->phptype = $value;
		}
	
		function getPhptype() {
			return $this->phptype;
		}	
		
		function setUsername($value) {
			$this->username = $value;
		}
	
		function getUsername() {
			return $this->username;
		}	
	
		function setPassword($value) {
			$this->password = $value;
		}
	
		function getPassword() {
			return $this->password;
		}		
	
		function setHostspec($value) {
			$this->hostspec = $value;
		}
	
		function getHostspec() {
			return $this->hostspec;
		}	
	
		function setDatabase($value) {
			$this->database = $value;
		}
	
		function getDatabase() {
			return $this->database;
		}							
	}	
	
	//
	// gets information from file for settings
	//
	function getDBInfo() {

		$filename = dirname(dirname(__FILE__)) . '/php_classes/settings.ini';
		
		$fileInfo = file_get_contents($filename);

		$iniArray = explode("\n", $fileInfo);
		
		$settings = new Settings();

		$valueArray = explode("=", $iniArray[0]);
		$settings->setDefaultPath(trim($valueArray[1]));
		
		$valueArray = explode("=", $iniArray[1]);
		$settings->setDefaultTemplate(trim($valueArray[1]));
		
		$valueArray = explode("=", $iniArray[2]);		
		$settings->setPhptype(trim($valueArray[1]));
		
		$valueArray = explode("=", $iniArray[3]);		
		$settings->setUsername(trim($valueArray[1]));
		
		$valueArray = explode("=", $iniArray[4]);		
		$settings->setPassword(trim($valueArray[1]));
		
		$valueArray = explode("=", $iniArray[5]);		
		$settings->setHostspec(trim($valueArray[1]));
		
		$valueArray = explode("=", $iniArray[6]);		
		$settings->setDatabase(trim($valueArray[1]));		
		
		return $settings;
	}
	
	//
	// saves information froom file for settings
	//
	function setDBInfo($settings) {
	
		$filename = dirname(dirname(__FILE__)) . '/php_classes/settings.ini';
		
		if (!is_writable ('../php_classes')) {
			echo dirname(dirname(__FILE__)) . "/php_classes is not writable<br>";		
		}

		$fp = fopen($filename, "w");

		$settingsStr .=  "DefaultPath=" . $settings->getDefaultPath() . "\n";
		$settingsStr .= "DefaultTemplate=" . $settings->getDefaultTemplate() . "\n";
		$settingsStr .= "Phptype=" . $settings->getPhptype() . "\n";
		$settingsStr .= "Username=" . $settings->getUsername() . "\n";
		$settingsStr .= "Password=" . $settings->getPassword() . "\n";
		$settingsStr .= "Hostspec=" . $settings->getHostspec() . "\n";
		$settingsStr .= "Database=" . $settings->getDatabase() . "\n";
		
		$bytes = fwrite($fp, $settingsStr);		
																
		fclose($fp);
		
	}	
	
	//
	// get connection to database
	//
	function getConnection() {

		$dsn = getDSN();

		$options = array(
	    	'debug'       => 2
		);

	
		$db = DB::connect($dsn, $options);

		if (DB::isError($db)) {
	    		echo $db->getDebugInfo() . "<br>";
	    		die ($db->getMessage());
		}

		return $db;
	}
	
	//
	// Sets up information for connecting to the database
	//
	function getDSN() {

		$settings = getDBInfo();

		$dsn = array(
	    		'phptype'  => $settings->getPhptype(),
	    		'username' => $settings->getUsername(),
   			'password' => $settings->getPassword(),
		        'hostspec' => $settings->getHostspec(),
	   		'database' => $settings->getDatabase()
		);

		return $dsn;
	}

    function executeSql($sql) {

		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}

		$db->query($sql);


		// Always check that $result is not an error
		if (DB::isError($result)) {
	    		die ($result->getMessage());
		}

		$db->disconnect();
		
    }
?>