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

	//
	// gets page information
	//
	function getWebsitePageInfo($PageName, $WebsiteKey) {

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

		$sql = "SELECT `PageKey`, `PageName`, `WebsiteKey`, `PageDescription`,
        `Title`, `Description`, `Keywords`, `Body`, `MetaTags`, `Footer`, `Javascript`,
        `Phpscript`, `LeftSide`, `RightSide`, `Google`, `Affiliate`, `Header`,
        `RequestInfo` ";
		$sql .= "FROM `Pages` ";
		$sql .= "WHERE `WebsiteKey` = $WebsiteKey AND `PageName` = '$PageName'";

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

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

		$page = new Page();

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

			$page->setPageKey($row[0]); 
			$page->setName($row[1]); 
			$page->setWebsiteKey($row[2]); 
			$page->setDisplayName($row[3]);
			$page->setTitle($row[4]); 
			$page->setDescription($row[5]); 
			$page->setKeywords($row[6]); 
			$page->setBody($row[7]); 			
			$page->setMetaTag($row[8]); 			
			$page->setFooter($row[9]); 			
			$page->setJavascript($row[10]); 			
			$page->setPhpscript($row[11]); 			
			$page->setLeftSide($row[12]); 			
			$page->setRightSide($row[13]); 			
			$page->setGoogle($row[14]);
			$page->setAffiliate($row[15]);
			$page->setHeader($row[16]);			
			$page->setRequestInfo($row[17]);						
		
		}
		
		$result->free();
		
		$db->disconnect();

		return $page;			
	}
	
	//
	// gets page information
	//
	function getPageInfo($PageKey) {

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

		$sql = "SELECT `PageKey`, `PageName`, `WebsiteKey`, `PageDescription`,
        `Title`, `Description`, `Keywords`, `Body`, `MetaTags`, `Footer`, `Javascript`,
        `Phpscript`, `LeftSide`, `RightSide`, `Google`, `Affiliate`, `Header`,
        `RequestInfo` ";
		$sql .= "FROM `Pages` ";
		$sql .= "WHERE `PageKey` = '$PageKey' ";

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

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

		$page = new Page();

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

			$page->setPageKey($row[0]);
			$page->setName($row[1]);
			$page->setWebsiteKey($row[2]);
			$page->setDisplayName($row[3]);
			$page->setTitle($row[4]);
			$page->setDescription($row[5]);
			$page->setKeywords($row[6]);
			$page->setBody($row[7]);
			$page->setMetaTag($row[8]);
			$page->setFooter($row[9]);
			$page->setJavascript($row[10]);
			$page->setPhpscript($row[11]);
			$page->setLeftSide($row[12]);
			$page->setRightSide($row[13]);
			$page->setGoogle($row[14]);
			$page->setAffiliate($row[15]);
			$page->setHeader($row[16]);
			$page->setRequestInfo($row[17]);

		}

		$result->free();

		$db->disconnect();

		return $page;
	}

	//
	// gets all pages
	//
	function getPages($websiteKey) {

		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "SELECT `PageKey`, `PageName`, `PageDescription`, `Title`, `Description`, `Keywords`, `Body`, `MetaTags`, `Footer`, `Javascript`, `Phpscript`, `LeftSide`, `RightSide`, `Google`, `Affiliate`, `Header`, `RequestInfo` ";
		$sql .= "FROM `Pages` ";
		$sql .= "WHERE `WebsiteKey` = '$websiteKey'";
		$sql .= "ORDER BY `PageName`";		
			
		$result = $db->query($sql);

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

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

			$page = new Page();
			
			$page->setPageKey($row[0]); 
			$page->setName($row[1]); 
			$page->setDisplayName($row[2]);
			$page->setTitle($row[3]); 
			$page->setDescription($row[4]); 
			$page->setKeywords($row[5]); 
			$page->setBody($row[6]); 			
			$page->setMetaTag($row[7]); 			
			$page->setFooter($row[8]); 			
			$page->setJavascript($row[9]); 			
			$page->setPhpscript($row[10]); 			
			$page->setLeftSide($row[11]); 			
			$page->setRightSide($row[12]); 			
			$page->setGoogle($row[13]);
			$page->setAffiliate($row[14]);
			$page->setHeader($row[15]);			
			$page->setRequestInfo($row[16]);
									
			$pageArray[] = $page;
			
		}		
		
		$db->disconnect();
		
		return $pageArray;			
	}
	
	//
	// creates a page
	//
	function createPage($PageName, $WebsiteKey, $PageDescription, $Title, $Description, $Keywords, $Body, $MetaTags, $Footer, $Javascript, $Phpscript, $LeftSide, $RightSide, $Google, $Affiliate, $Header, $RequestInfo) {
	
		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "INSERT INTO `Pages` (`PageName`, `WebsiteKey`, `PageDescription`, `Title`, `Description`, `Keywords`, `Body`, `MetaTags`, `Footer`, `Javascript`, `Phpscript`, `LeftSide`, `RightSide`, `Google`, `Affiliate`, `Header`, `RequestInfo`) ";
		$sql .= "Values('$PageName', '$WebsiteKey', '$PageDescription', '$Title', '$Description', '$Keywords', '$Body', '$MetaTags', '$Footer', '$Javascript', '$Phpscript', '$LeftSide', '$RightSide', '$Google', '$Affiliate', '$Header', '$RequestInfo')";
	

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

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

		$db->disconnect();
		
	}	

	//
	// updates a page
	//
	function updatePage($PageName, $PageDescription, $Title, $Description, $Keywords, $Body, $MetaTags, $Footer, $Javascript, $Phpscript, $LeftSide, $RightSide, $Google, $Affiliate, $Header, $RequestInfo, $PageKey) {

		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "UPDATE `Pages` SET " .
			"`PageName` = '$PageName', " .
			"`PageDescription` = '$PageDescription', " .
			"`Title` = '$Title', " . 
			"`Description` = '$Description', " .
			"`Keywords` = '$Keywords', " .
			"`Body` = '$Body', " .
			"`MetaTags` = '$MetaTags', " .
			"`Footer` = '$Footer', " .
			"`Javascript` = '$Javascript', " .
			"`Phpscript` = '$Phpscript', " .
			"`LeftSide` = '$LeftSide', " .
			"`RightSide` = '$RightSide', " .
			"`Google` = '$Google', ".
			"`Affiliate` = '$Affiliate', " .
			"`Header` = '$Header', " .			
			"`RequestInfo` = '$RequestInfo' " .						
			"WHERE `PageKey` = '$PageKey'";

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


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

		$db->disconnect();
				
	}	

	//
	// deletes a page
	//
	function deletePage($PageKey) {
	
		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "DELETE FROM `Pages` WHERE `PageKey` = '$PageKey'";
	
		$result = $db->query($sql);

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

		$db->disconnect();		
	}			
	
	//
	// substitiute term
	//
	function subsTerm($page, $searchTerm, $replaceTerm) {

		return str_replace ( $searchTerm, $replaceTerm, $page);

	}				

?>