***********************************************************************/
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$emailAddress = "";
$dataArray = NULL;
$statusMessage = "";
$statusCode = "";
$runLevel = "";
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $emailAddress = $_POST["Email"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'AddEmailAddress Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
$sortDirection = "";
$dataArray = NULL;
$statusMessage = "";
$statusCode = "";
$runLevel = "";
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $classNumber = $_POST["Class"];
        $partNumber = $_POST["PartNumber"];
        $quantity = $_POST["Quantity"];
        $date = $_POST["Date"];
        $sortColumn = $_POST["SortColumn"];
        $sortDirection = $_POST["SortDirection"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'AddNewClassData Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 *  Code written by: Robert Johnson
 *  Reference:
 *  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e0908b2f-4afa-4626-830d-9683486186c8/backup-database?forum=sqldriverforphp
 *  
 *	Date: 18 February 2016
 ***********************************************************************/
header('content-type: text/plain;charset=UTF-8');
include "IMSLog.php";
include "IMSBase.php";
include "IMSSql.php";
$statusMessage = '';
$statusCode = 0;
$sessionID = '';
$dataArray = '';
try {
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
    }
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'CheckThresholds Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
<?php

/***********************************************************************
 * 	Script: Test_MailSend.php
 * 	Description: Script for testing the SendEmail function in IMSBase.
 *
 *	Author: Craig Irvine ()
 *	Date: 24 Feb 2016
 *
 ***********************************************************************/
include "IMSTest.php";
include "../IMSBase.php";
try {
    $base = new IMSBase();
    $subject = "Purchase Requirements";
    $message = "<p>This is a Purchase Requirements email</p>" . "<table><tr><th>Date</th><th>Part</th><th>MFG PN</th><th>Qty</th></tr>" . "<tr><td>Date</td><td>Part</td><td>MFG PN</td><td>Qty</td></tr>" . "<tr><td>Date</td><td>Part</td><td>MFG PN</td><td>Qty</td></tr>" . "</table>";
    $base->sendEmail(array("*****@*****.**"), $subject, $message);
} catch (phpmailerException $e) {
    echo "phpmailerException: " . $e->errorMessage();
} catch (Exception $e) {
    echo "Exception: " . $e->getMessage();
}
?>

include "IMSSql.php";
$sessionID = "";
$statusMessage = "";
$statusCode = 0;
$runLevel = "";
$supplierNumber = "";
$itemLink = "";
$quantity = "";
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $supplierNumber = $_POST["SN"];
        $itemLink = $_POST["IL"];
        $quantity = $_POST["QN"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    $IMSBase->verifyData($supplierNumber, "/^.+\$/", "Supplier Number");
    if ($itemLink == "") {
        $itemLink = "Unknown";
    }
    if ($quantity = "") {
        $quantity = 0;
    }
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'AddPurchaseListItem Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
 ***********************************************************************/
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$partNumber = "";
$statusMessage = "";
$statusCode = "";
$runLevel = "";
$dataArray = NULL;
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $partNumber = $_POST["PartNumber"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'RetriveItem Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$partNumber = "";
$field = "";
$value = "";
$statusMessage = "";
$statusCode = "";
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $partNumber = $_POST["PartNumber"];
        $field = $_POST["Field"];
        $value = $_POST["Value"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'ModifyItem Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 *
 *	Usage: GetOption.php?SID=<session ID>
 ***********************************************************************/
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$statusMessage = "";
$statusCode = 0;
$dataArray = NULL;
$runLevel = "0";
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'GetOption Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 ***********************************************************************/
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$filter = "";
$statusMessage = "";
$statusCode = "";
$runLevel = "";
$suggestionArray = NULL;
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $filter = $_POST["Filter"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'QueryAutocomplete Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 *
 *	Usage: 	RetrieveEmailAddress.php?SID=<session id>
 ***********************************************************************/
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$statusMessage = "";
$statusCode = "";
$runLevel = "";
$dataArray = NULL;
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'RetrieveEmailAddress Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 *  			login: 		SQL server login
 *  			password: 	SQL server password
 *  			DB: 		DB to connect to (most likely will be "Master")
 *  
 *	Date: 26 March 2016
 ***********************************************************************/
header('content-type: text/plain;charset=UTF-8');
include "IMSLog.php";
include "IMSBase.php";
$statusMessage = '';
$statusCode = 0;
$sessionID = '';
$dataArray = '';
$query = array("USE Master", "CREATE DATABASE IMS", "CREATE TABLE [IMS].[dbo].[Class_Data] (\n\t\t\t\tId int NOT NULL PRIMARY KEY IDENTITY (1,1),\n\t\t\t\tClass varchar(50) NOT NULL,\n\t\t\t\tPart varchar(50) NOT NULL,\n\t\t\t\tQuantity int NOT NULL,\n\t\t\t\tDate date NOT NULL)", "CREATE TABLE [IMS].[dbo].[Emails] (\n\t\t\t\tId int NOT NULL PRIMARY KEY IDENTITY (1,1),\n\t\t\t\tRecipients varchar(MAX) NOT NULL,\n\t\t\t\tEmail varchar(MAX) NOT NULL)", "CREATE TABLE [IMS].[dbo].[Inventory] (\n\t\t\t\tId int NOT NULL IDENTITY (1,1),\n\t\t\t\tName varchar(50) NOT NULL PRIMARY KEY DEFAULT 'Empty',\n\t\t\t\tSupplier_Part_Number varchar(50) NOT NULL DEFAULT 'Empty',\n\t\t\t\tQuantity int NOT NULL DEFAULT 0,\n\t\t\t\tDescription varchar(MAX) NOT NULL DEFAULT 'Empty',\n\t\t\t\tLocation varchar(50) NOT NULL DEFAULT 'Empty',\n\t\t\t\tType varchar(50) NOT NULL DEFAULT 'Empty',\n\t\t\t\tOrdering_Threshold int NOT NULL DEFAULT 0,\n\t\t\t\tValue varchar(50) NOT NULL DEFAULT 'Empty',\n\t\t\t\tSuppliers_Name varchar(50) NOT NULL DEFAULT 'Empty',\n\t\t\t\tItem_Link varchar(MAX) NOT NULL DEFAULT 'Empty',\n\t\t\t\tConsumable_Flag bit NOT NULL DEFAULT 0,\n\t\t\t\tEquipment_Flag bit NOT NULL DEFAULT 0,\n\t\t\t\tLab_Part_Flag bit NOT NULL DEFAULT 0,\n\t\t\t\tThreshold_Reported bit NOT NULL DEFAULT 0,\n\t\t\t\tLab_Quantity int NOT NULL DEFAULT 0)", "CREATE TABLE [IMS].[dbo].[Options] (\n\t\t\t\t[Option] varchar(50) NOT NULL PRIMARY KEY,\n\t\t\t\tValue varchar(MAX) NOT NULL)", "CREATE TABLE [IMS].[dbo].[Purchase_List] (\n\t\t\t\tSupplier_Part_Number varchar(50) NOT NULL PRIMARY KEY,\n\t\t\t\tItem_Link varchar(MAX) NOT NULL,\n\t\t\t\tQuantity int NOT NULL DEFAULT 0,\n\t\t\t\tThreshold_Reported bit NOT NULL DEFAULT 0)", "CREATE TABLE [IMS].[dbo].[SID_List] (\n\t\t\t\tID int NOT NULL IDENTITY (1,1),\n\t\t\t\tSID varchar(50) NOT NULL PRIMARY KEY,\n\t\t\t\tCLIENT_IP varchar(50) NOT NULL,\n\t\t\t\tEXPIRE datetime NOT NULL,\n\t\t\t\t[LEVEL] int NOT NULL)", "INSERT INTO [IMS].[dbo].[Options] ([Option], Value) VALUES \n\t\t('Automated_Backups_Enabled', 'False'),\n\t\t('Backup_Frequency', '10'),\n\t\t('Credential_Expiry_Time_Seconds', '3500'),\n\t\t('Debug', 'True'),\n\t\t('Email_fromEmail', '*****@*****.**'),\n\t\t('Email_fromName', 'Your Name'),\n\t\t('Email_Pass', 'Email server password'),\n\t\t('Email_Server', 'smtp.usask.ca'),\n\t\t('Email_User', 'Email server login'),\n\t\t('Log_File_Location', 'C:\\inetpub\\wwwroot\\Back_End\\log\\'),\n\t\t('Remote_Server_Enabled', 'True'),\n\t\t('Thresholds_Enabled', 'True')", "USE [IMS]", "CREATE USER [guest] WITHOUT LOGIN WITH DEFAULT SCHEMA=[dbo]", "GRANT CONNECT to guest", "GRANT DELETE to guest", "GRANT EXECUTE to guest", "GRANT INSERT to guest", "GRANT SELECT to guest", "GRANT UPDATE to guest", "CREATE USER [IMSBackup] WITHOUT LOGIN WITH DEFAULT SCHEMA=[dbo]", "EXEC db_addrolemember 'db_backupoperator', 'IMSBackup'", "EXEC db_addrolemember 'db_denydatareader', 'IMSBackup'", "EXEC db_addrolemember 'db_denydatawriter', 'IMSBackup'");
try {
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $server = $_POST["server"];
        $login = $_POST["login"];
        $password = $_POST["password"];
        $DB = $_POST["DB"];
    }
    $conn = sqlsrv_connect($server, array('UID' => $login, 'PWD' => $password, 'Database' => $DB, 'CharacterSet' => 'UTF-8'));
    if (!$conn) {
        print_r(sqlsrv_errors());
        exit;
    }
    sqlsrv_configure("WarningsReturnAsErrors", 0);
    foreach ($query as $current) {
        if ($stmt = sqlsrv_query($conn, $current)) {
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$option = "";
$data = "";
$statusMessage = "";
$statusCode = 0;
$runlevel = "";
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $option = $_POST["Option"];
        $data = $_POST["Data"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'ModifyOption Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 *
 *	Usage: GeneratePurcahseReport.php?SID=<session ID>&type=<manual or blank>
 ***********************************************************************/
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$statusMessage = "";
$statusCode = 0;
$tableType = "";
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $tableType = $_POST["type"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'GeneratePurchaseReport Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 ***********************************************************************/
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$partNumber = "";
$statusMessage = "";
$statusCode = "";
$runLevel = "";
$partNumberChange = NULL;
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $partNumber = $_POST["PartNumber"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'CreateNewItem Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 *	Usage: 	RetrieveLog.php?SID=<session id>&LogLevel=<log level>
 ***********************************************************************/
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$logLevel = "";
$statusMessage = "";
$statusCode = "";
$runLevel = "";
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $logLevel = $_POST["LogLevel"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'RetrieveLog Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 ***********************************************************************/
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$statusMessage = "";
$statusCode = 0;
$supplierNumber = "";
$itemLink = "";
$quantity = "";
$somevalue = "";
$dataArray = "";
$aItem = "";
try {
    $sql = new IMSSql();
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $aItem = $_POST['itemList'];
        $sessionID = $_POST['SID'];
    }
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'RemoveManualEntries Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
$sessionID = "";
$recordID = "";
$field = "";
$value = "";
$statusMessage = "";
$statusCode = "";
$runLevel = "";
$dataArray = NULL;
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $recordID = $_POST["ID"];
        $field = $_POST["Field"];
        $value = $_POST["Value"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'ModifyEmailAddress Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 *  Code written by: Robert Johnson
 *  Reference:
 *  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e0908b2f-4afa-4626-830d-9683486186c8/backup-database?forum=sqldriverforphp
 *  
 *	Date: 18 February 2016
 ***********************************************************************/
header('content-type: text/plain;charset=UTF-8');
include "IMSLog.php";
include "IMSBase.php";
include "IMSSql.php";
$statusMessage = '';
$statusCode = 0;
$sessionID = '';
$dataArray = '';
try {
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
    }
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'CheckThresholds Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
$statusMessage = "";
$statusCode = "";
$runLevel = "";
$dataArray = NULL;
$sortColumn = "";
$sortDirection = "";
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $recordID = $_POST["ID"];
        $field = $_POST["Field"];
        $value = $_POST["Value"];
        $sortColumn = $_POST["SortColumn"];
        $sortDirection = $_POST["SortDirection"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'ModifyClassData Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
$sortCoumn = "";
$sortDirection = "ASC";
//ascending is default.
$filter = "";
$statusMessage = "";
$statusCode = "";
$runLevel = "";
$dataArray = NULL;
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $sortColumn = $_POST["SortColumn"];
        $sortDirection = $_POST["SortDirection"];
        $filter = $_POST["Filter"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'RetrieveBroswerData Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
 * 				if thresholds_enabled is set in options.
 * 
 * Inputs: SID - Session ID of client
 * 
 * Author: Justin Fraser
 *
 ****************************************************/
include "IMSSql.php";
include "IMSLog.php";
include "IMSBase.php";
$statusArray = "";
$dataArray = "";
$sessionID = "";
$statusCode = 0;
try {
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
    }
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'CheckThresholds Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
 ***********************************************************************/
include "IMSBase.php";
include "IMSLog.php";
include "IMSSql.php";
$sessionID = "";
$id = "";
$statusMessage = "";
$statusCode = "";
$runLevel = "";
$dataArray = NULL;
try {
    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $sessionID = $_POST["SID"];
        $id = $_POST["ID"];
    }
    $IMSBase = new IMSBase();
    $log = new IMSLog();
    $sql = new IMSSql();
    //Set IMSLog options
    $opt_debugLog = $sql->getOption('Debug');
    if ($opt_debugLog === false) {
        $log->add_log($sessionID, 'Warning', 'DeleteEmailAddress Warning: Debug Option missing or invalid.');
    } else {
        if ($opt_debugLog == 'False') {
            $log->opt_debug = false;
        } else {
            $log->opt_debug = true;
        }
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {