<?php

	include_once("classes.inc");
	include_once("DBUtils.inc");	

	//
	// gets link information
	//
	function getEmailSetting($WebsiteKey) {

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

		$sql = "SELECT `EmailSettingsKey`, `From`, `To`, `CC`, `Subject`, `Redirect`, `SaveEmail`, `SaveFile`, `FieldName`, `MultiEmail`, `EmailArray`, `WebsiteKey` ";
		$sql .= "FROM `EmailSettings` ";
		$sql .= "WHERE `WebsiteKey` = $WebsiteKey";
		

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

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

		$emailSettings = new EmailSettings();

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

			$emailSettings->setEmailSettingsKey($row[0]);
			$emailSettings->setFrom($row[1]);
			$emailSettings->setTo($row[2]);
			$emailSettings->setCC($row[3]);
			$emailSettings->setSubject($row[4]);
			$emailSettings->setRedirect($row[5]);
			$emailSettings->setSaveEmail($row[6]);
			$emailSettings->setSaveFile($row[7]);
			$emailSettings->setFieldName($row[8]);
			$emailSettings->setMultiEmail($row[9]);
			$emailSettings->setEmailArray($row[10]);
			$emailSettings->setWebsiteKey($row[11]);
		
		}
		
		$result->free();
		
		$db->disconnect();

		return $emailSettings ;			
	}

	//
	// create a link
	//
	function createEmailSettings($WebsiteKey, $From, $To, $CC, $Subject, $Redirect, $SaveEmail, $SaveFile, $FieldName, $MultiEmail, $EmailArray) {

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

		$sql = "INSERT INTO `EmailSettings` (`From`, `To`, `CC`, `Subject`, `Redirect`, `SaveEmail`, `SaveFile`, `FieldName`, `MultiEmail`, `EmailArray`, `WebsiteKey`) " .
            "Values ('$From', '$To', '$CC', '$Subject', '$Redirect', '$SaveEmail', '$SaveFile', '$FieldName', '$MultiEmail', '$EmailArray', $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 updateEmailSettings($WebsiteKey, $From, $To, $CC, $Subject, $Redirect, $SaveEmail, $SaveFile, $FieldName, $MultiEmail, $EmailArray) {

		$db = getConnection();
		if (DB::isError($db)) {
		    	die($db->getMessage());
		}
	
		$sql = "UPDATE `EmailSettings` SET " .
			"`From` = '$From', " .
			"`To` = '$To', " .
			"`CC` = '$CC', " .
			"`Subject` = '$Subject', " .
			"`Redirect` = '$Redirect', " .
			"`SaveEmail` = '$SaveEmail', " .
			"`SaveFile` = '$SaveFile', " .
			"`FieldName` = '$FieldName', " .
			"`MultiEmail` = '$MultiEmail', " .																								
			"`EmailArray` = '$EmailArray' " .
            "WHERE `WebsiteKey` = $WebsiteKey";
            
		$result = $db->query($sql);


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

		$db->disconnect();
				
	}	

	
?>