<?php
	include_once("classes.inc");
	include_once("DBUtils.inc");	

	//
	// get website to be managed
	//
	///////////////////////////////////////////////////////////////////////////////////////////////////
	function getWebsiteByName($Website) {

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

		$sql = "SELECT `WebsiteKey`, `Website`, `UserName`, `Password` ";
		$sql .= "FROM `Websites` ";
		$sql .= "WHERE `Website` = '$Website' ";

		$result = $db->query($sql);

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


		$website = new Website();

		if ($row = $result->fetchRow()) {

			$website->setWebsiteKey($row[0]); 
			$website->setWebsite($row[1]); 
			$website->setUserName($row[2]);
			$website->setPassword($row[3]);
		
		}
		
		$result->free();
		
		$db->disconnect();

		return $website;			
	}
	
	//
	// get website to be managed
	//
	///////////////////////////////////////////////////////////////////////////////////////////////////
	function getWebsite($WebsiteKey) {

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

		$sql = "SELECT `WebsiteKey`, `Website`, `UserName`, `Password` ";
		$sql .= "FROM `Websites` ";
		$sql .= "WHERE `WebsiteKey` = $WebsiteKey ";

		$result = $db->query($sql);

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


		$website = new Website();

		if ($row = $result->fetchRow()) {

			$website->setWebsiteKey($row[0]);
			$website->setWebsite($row[1]);
			$website->setUserName($row[2]);
			$website->setPassword($row[3]);

		}

		$result->free();

		$db->disconnect();

		return $website;
	}


	function getWebsites() {

		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "SELECT `WebsiteKey`, `Website`, `UserName`, `Password` ";
		$sql .= "FROM `Websites` ";
		$sql .= "ORDER BY `Website`";		
			
		$result = $db->query($sql);

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

		$WebsiteArray = array();
		while ($row = $result->fetchRow()) {

			$website = new Website();
			
			$website->setWebsiteKey($row[0]); 
			$website->setWebsite($row[1]); 
			$website->setUserName($row[2]);
			$website->setPassword($row[3]);
			
			$WebsiteArray[] = $website;
			
		}		
		
		$db->disconnect();
		
		return $WebsiteArray;			
	}

	
	//
	// creates a website
	//
	function createWebsite($Website, $UserName, $Password) {
	
		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "INSERT INTO `Websites` (`Website`, `UserName`, `Password`) ";
		$sql .= "Values('$Website', '$UserName', '$Password')";
	
		$result = $db->query($sql);

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

		$db->disconnect();
		
	}	

	//
	// updates a website
	//
	function updateWebsite($WebsiteKey, $Website, $UserName, $Password) {

		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "UPDATE `Websites` SET " .
			"`Website` = '$Website', " .
			"`UserName` = '$UserName', " .
			"`Password` = '$Password' " .
			"WHERE `WebsiteKey` = $WebsiteKey ";

		$result = $db->query($sql);


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

		$db->disconnect();
				
	}	

	//
	// deletes a website
	//
	function deleteWebsite($WebsiteKey) {
	
		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "DELETE FROM `Websites` WHERE `WebsiteKey` = '$WebsiteKey'";
	
		$result = $db->query($sql);

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

		$db->disconnect();		
	}			
	

?>