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

	//
	// gets link information
	//
	function getWebsiteLink($Link, $WebsiteKey) {

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

		$sql = "SELECT `LinkKey`, `Link`, `LinkText`, `WebsiteKey`";
		$sql .= "FROM `Links` ";
		$sql .= "WHERE `WebsiteKey` = $WebsiteKey AND `Link` = '$Link'";

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

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

		$link = new Link();

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

			$link->setLinkKey($row[0]); 
			$link->setLink($row[1]); 
			$link->setLinkText($row[2]); 
			$link->setWebsiteKey($row[3]); 
		
		}
		
		$result->free();
		
		$db->disconnect();

		return $link;			
	}
	
	//
	// gets link information
	//
	function getLink($LinkKey) {

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

		$sql = "SELECT `LinkKey`, `Link`, `LinkText`, `WebsiteKey`";
		$sql .= "FROM `Links` ";
		$sql .= "WHERE `LinkKey` = '$LinkKey'";
		$sql .= "ORDER BY `Link`";

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

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

		$link = new Link();

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

			$link->setLinkKey($row[0]);
			$link->setLink($row[1]);
			$link->setLinkText($row[2]);
			$link->setWebsiteKey($row[3]);

		}

		$result->free();

		$db->disconnect();

		return $link;
	}

	//
	// gets all links
	//
	function getLinks($WebsiteKey) {

		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "SELECT `LinkKey`, `Link`, `LinkText`, `WebsiteKey` ";
		$sql .= "FROM `Links` ";
		$sql .= "WHERE `WebsiteKey` = $WebsiteKey ";
		$sql .= "ORDER BY `Link` ";

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

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

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

			$link = new Link();
			
			$link->setLinkKey($row[0]); 
			$link->setLink($row[1]); 
			$link->setLinkText($row[2]); 
			$link->setWebsiteKey($row[3]); 
			
			$linkArray[] = $link;
			
		}		
		
		$result->free();
	
		$db->disconnect();
		
		return $linkArray;			
	}
	
	//
	// creates a link
	//
	function createLink($Link, $LinkText, $WebsiteKey) {
	
		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "INSERT INTO `Links` (`Link`, `LinkText`, `WebsiteKey`) ";
		$sql .= "Values('$Link', '$LinkText', '$WebsiteKey')";
	
		$result = $db->query($sql);

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

		$db->disconnect();
		
	}	

	//
	// updates a link
	//
	function updateLink($Link, $LinkText, $LinkKey) {

		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "UPDATE `Links` SET " .
			"`Link` = '$Link', " .
			"`LinkText` = '$LinkText' " .
			"WHERE `LinkKey` = '$LinkKey'";

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


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

		$db->disconnect();
				
	}	

	//
	// deletes a Link
	//
	function deleteLink($LinkKey, $website) {
	
		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "DELETE FROM `Links` WHERE `LinkKey` = '$LinkKey'";
	
		$result = $db->query($sql);

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

		$db->disconnect();
	}			
	
	//
	//	save before and after
	//
	function saveLinkBA($WebsiteKey, $before, $after) {

		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "UPDATE `LinkSettings` SET `Before` = '$before', `After` = '$after'  " .
			"WHERE `WebsiteKey` = $WebsiteKey";
	
		$result = $db->query($sql);

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

		$db->disconnect();
		
	}
	
	//
	//	create before and after
	//
	function createLinkBA($WebsiteKey, $before, $after) {

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

		$sql = "INSERT INTO `LinkSettings` (`Before`, `After`, `WebsiteKey`) " .
			"Values ('$before', '$after', $WebsiteKey) ";

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

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

		$db->disconnect();

	}
	
	function getLinkBA($WebsiteKey) {

		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "SELECT `LinkSettingsKey`, `WebsiteKey`, `Before`, `After` " .
			"FROM `LinkSettings` " .
			"WHERE `WebsiteKey` = $WebsiteKey";

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

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

		$ls = new LinkSettings();
		$ls->setLinkSettingsKey(0);
			
		if ($row = $result->fetchRow()) {		
		
			$ls->setLinkSettingsKey($row[0]);
			$ls->setWebsiteKey($row[1]); 
			$ls->setBefore($row[2]); 
			$ls->setAfter($row[3]); 
			
		}
			
		// Always check that $result is not an error
		if (DB::isError($result)) {
	    		die ($result->getMessage());
		}	

		$db->disconnect();
		
		return $ls;
	}	
?>  