<?php
//
// Set the current Database Mode
//

// Override DB mode based on SESSION variable
if (isset($_SESSION) && array_key_exists('db_mode', $_SESSION) && strlen($_SESSION['db_mode'])) {
   $currentDBMode = $_SESSION['db_mode'];
   // writeLog("config.php:  currentDBMode: $currentDBMode");
}

if (!isset($currentDBMode) || $currentDBMode == '') $currentDBMode = "Current";
if ($currentDBMode == 'Standard') $currentDBMode = "Current";


//
// Determine the current URL
//
if (isset($_SERVER['HTTP_HOST']) && strlen($_SERVER['HTTP_HOST'])) {
   $prefix = "http://";
   if (array_key_exists('HTTPS', $_SERVER)) $prefix = "https://";
   $currentHOST = $prefix . strtolower($_SERVER['HTTP_HOST']);

   $currentURL = strtolower($_SERVER['HTTP_HOST']);
   $http_host = preg_replace("/^www\./","",$currentURL);

   if (preg_match("/^backup-/",$http_host)) {
      $currentDBMode = "Backup";
      $currentURL = preg_replace("/^backup-/","",$currentURL);
   }

   if (preg_match("/^prev-/",$http_host)) {
      $currentDBMode = "Previous";
      $currentURL = preg_replace("/^prev-/","",$currentURL);
   }

   if (preg_match("/^prev2-/",$http_host)) {
      $currentDBMode = "Previous2";
      $currentURL = preg_replace("/^prev2-/","",$currentURL);
   }

   if (preg_match("/^prev3-/",$http_host)) {
      $currentDBMode = "Previous3";
      $currentURL = preg_replace("/^prev3-/","",$currentURL);
   }

   if (preg_match("/^prev4-/",$http_host)) {
      $currentDBMode = "Previous4";
      $currentURL = preg_replace("/^prev4-/","",$currentURL);
   }

   if (preg_match("/^prev5-/",$http_host)) {
      $currentDBMode = "Previous5";
      $currentURL = preg_replace("/^prev5-/","",$currentURL);
   }

   if (preg_match("/^demo-/",$http_host)) {
      $currentDBMode = "Demo";
      $currentURL = preg_replace("/^demo-/","",$currentURL);
   }

}


// Argument override of DB mode
if (array_key_exists('db_mode', $_GET) && strlen($_GET['db_mode'])) {
   $currentDBMode = $_GET['db_mode'];
   $_SESSION['db_mode'] = $currentDBMode;
}


//
// Get set of current databases on server
//
if (isset($_SESSION['UserInfo']['userid']) && $_SESSION['UserInfo']['userid'] == 'superuser') {
   $DBS = array();
   $fp = fopen("/m/data1/app.hotlunches.net/current-dbs.txt","r");
   while (! feof($fp)) {
      $entry = trim(fgets($fp, 1000));
      $DBS[$entry] = $entry;
   }
   fclose($fp);
}


//
// MySQL Database Settings
//
$log_agent = false;
$currentDBTitle = $currentDBMode;
switch ($currentDBMode) {
   case 'Current':
      $db_host    = 'localhost';
      $db_uname   = 'ezssoftwaredb';
      $db_pass    = 'EZsoftware7785422700@@';
      $db_dbname  = 'hotlunch';
      $log_agent  = true;

      if (isset($DBS) && is_array($DBS)) {
         if ($currentDBMode != 'hotlunch' && $currentDBMode != 'Current') {
            if ($DBS[$currentDBMode] == $currentDBMode) {
               $db_dbname = $currentDBMode;
               $log_agent = false;
            }
         }
      }
      break;

   case 'Development':
      $db_host    = 'localhost';
      $db_dbname  = 'hotlunch';
      $db_uname   = 'ezssoftwaredb';
      $db_pass    = 'EZsoftware7785422700@@';
      break;

   case 'Backup':
      $db_host    = 'localhost';
      $db_dbname  = 'hotlunch_backup';
      $db_uname   = 'ezssoftwaredb';
      $db_pass    = 'EZsoftware7785422700@@';
      break;

   case 'Demo':
      $db_host    = 'localhost';
      $db_dbname  = 'hotlunch_demo';
      $db_uname   = 'ezssoftwaredb';
      $db_pass    = 'EZsoftware7785422700@@';
      break;

   case 'Previous':
      $PrevTime = time() - 60 * 60 * 25;
      $currentDBTitle = date("F j, Y",$PrevTime);

      $db_host    = 'localhost';
      $db_dbname  = "hotlunch_" . date("Ymd",$PrevTime);
      $db_uname   = 'ezssoftwaredb';
      $db_pass    = 'EZsoftware7785422700@@';
      $log_agent  = true;
      break;

   case 'Previous2':
      $PrevTime = time() - 60 * 60 * (24 * 2 + 1);
      $currentDBTitle = date("F j, Y",$PrevTime);

      $db_host    = 'localhost';
      $db_dbname  = "hotlunch_" . date("Ymd",$PrevTime);
      $db_uname   = 'ezssoftwaredb';
      $db_pass    = 'EZsoftware7785422700@@';
      $log_agent  = true;
      break;

   case 'Previous3':
      $PrevTime = time() - 60 * 60 * (24 * 3 + 1);
      $currentDBTitle = date("F j, Y",$PrevTime);

      $db_host    = 'localhost';
      $db_dbname  = "hotlunch_" . date("Ymd",$PrevTime);
      $db_uname   = 'ezssoftwaredb';
      $db_pass    = 'EZsoftware7785422700@@';
      $log_agent  = true;
      break;

   case 'Previous4':
      $PrevTime = time() - 60 * 60 * (24 * 4 + 1);
      $currentDBTitle = date("F j, Y",$PrevTime);

      $db_host    = 'localhost';
      $db_dbname  = "hotlunch_" . date("Ymd",$PrevTime);
      $db_uname   = 'ezssoftwaredb';
      $db_pass    = 'EZsoftware7785422700@@';
      $log_agent  = true;
      break;

   case 'Previous5':
      $PrevTime = time() - 60 * 60 * (24 * 5 + 1);
      $currentDBTitle = date("F j, Y",$PrevTime);

      $db_host    = 'localhost';
      $db_dbname  = "hotlunch_" . date("Ymd",$PrevTime);
      $db_uname   = 'ezssoftwaredb';
      $db_pass    = 'EZsoftware7785422700@@';
      $log_agent  = true;
      break;

   default:
      $db_host    = 'localhost';
      $db_dbname  = "hotlunch_$currentDBMode";
      $db_uname   = 'ezssoftwaredb';
      $db_pass    = 'EZsoftware7785422700@@';
      $log_agent  = false;
      break;

}

if (!is_file("databases/$db_dbname")) {
   $db_dbname = "hotlunch";
   $error_message = "Database Not Available";
}

$_SESSION['db_dbname'] = $db_dbname;
$usersTable = 'users';
$userSALT   = '$1$ezssoftw$';

$AdminUserTypes = array('SuperUser','System Administrator','Application Administrator','Administration Team');
$AllAdminUserTypes = array('SuperUser','System Administrator','Application Administrator','Communications Administrator','Administration Team','Schedule Team','Financial','Financial Team');


//
// Session and Cookie Settings
// - session timeout 30 minutes
//
$sessionName    = 'hotlunch';
$sessionTimeout = 60 * 60;
$cookiePath     = '/';


if (session_status() !== PHP_SESSION_ACTIVE) {
   session_name($sessionName);
   session_start();
}


$QueueDelay = 0;


//
// Form processing
//
$FormTarget = "/";


$aliasesDIR = "/etc/exim/domains";
$currentTemplate = "default.html";


//
// Other parameters
//
$default_table_width = '98%';
$default_data_width = '98%';
$default_form_width = '90%';
$recordsPerPage = 50;
$numberOfPageLinks = 30;

$maxImageDimension = 300;
$maxThumbDimension = 50;
$maxGalleryImageDimension = 600;
$maxGalleryThumbDimension = 150;

$otipHDR = "<table cellpadding='1' cellspacing='1' border='0'>";
$otipROWB = "<tr><td align='right' valign='top'>";
$otipROWM = "</td><td align='left' valign='top'><b>";
$otipROWE = "</b></td></tr>";
$otipFTR = "</table>";

$otipTABLE = "<table cellpadding='1' cellspacing='1' border='0'>";
$otipTABLE300 = "<table width='400' cellpadding='1' cellspacing='1' border='0'>";
$otipTABLE400 = "<table width='400' cellpadding='1' cellspacing='1' border='0'>";
$otipTABLE500 = "<table width='400' cellpadding='1' cellspacing='1' border='0'>";
$otipTABLE600 = "<table width='600' cellpadding='1' cellspacing='1' border='0'>";
$otipTABLE700 = "<table width='700' cellpadding='1' cellspacing='1' border='0'>";
$otipWideTABLE = "<table width='400' cellpadding='1' cellspacing='1' border='0'>";
$otipROW1    = "<tr><td align='%s'>%s</td></tr>";
$otipROW2    = "<tr><td align='right' valign='top'>%s</td><td align='left' valign='top'><b>%s</b></td></tr>";
$otipROW2nb  = "<tr><td align='right' valign='top'>%s</td><td align='left' valign='top'>%s</td></tr>";
$otipROW2w   = "<tr><td align='right' width='300' valign='top'>%s</td><td align='left' width='400' valign='top'><b>%s</b></td></tr>";
$otipROW21   = "<tr><td align='%s' colspan='2'>%s</td></tr>";
$otipROW21hr = "<tr><td align='center' colspan='2'><hr width='80%'></td></tr>";
$otipCELL    = "<td align='%s'>%s</td>";

$otipIMG = "<table cellpadding='1' border='0'><tr><td align='center'><img src='%s' height='%d' width='%d' border='1'></td></tr><tr><td align='center'><b>%s</b></td></tr></table>";
$otipNUTRITION = "<table width='450' cellpadding='2' cellspacing='2' border='0'><tr><td align='center' class='heading'><b>Information</b></td></tr><tr><td>%s</td></tr></table>";


// Character normalization
   $normalizeChars = array(chr(192) => 'A', chr(193) => 'A', chr(194) => 'A', chr(195) => 'A', chr(196) => 'A', chr(197) => 'A', chr(198) => 'AE',
                           chr(199) => 'C', chr(200) => 'E', chr(201) => 'E', chr(202) => 'E', chr(203) => 'E', chr(204) => 'I', chr(205) => 'I',
                           chr(206) => 'I', chr(207) => 'I', chr(208) => 'D', chr(209) => 'N', chr(210) => 'O', chr(211) => 'O', chr(212) => 'O',
                           chr(213) => 'O', chr(214) => 'O', chr(215) => '', chr(216) => 'O', chr(217) => 'U', chr(218) => 'U', chr(219) => 'U',
                           chr(220) => 'U', chr(221) => 'Y', chr(222) => 'p', chr(223) => 'B', chr(224) => 'a', chr(225) => 'a', chr(226) => 'a',
                           chr(227) => 'a', chr(228) => 'a', chr(229) => 'a', chr(230) => 'ae', chr(231) => 'c', chr(232) => 'e', chr(233) => 'e',
                           chr(234) => 'e', chr(235) => 'e', chr(236) => 'i', chr(237) => 'i', chr(238) => 'i', chr(239) => 'i', chr(240) => 'o',
                           chr(241) => 'n', chr(242) => 'o', chr(243) => 'o', chr(244) => 'o', chr(245) => 'o', chr(246) => 'o', chr(247) => '',
                           chr(248) => 'o', chr(249) => 'u', chr(250) => 'u', chr(251) => 'u', chr(252) => 'u', chr(253) => 'y', chr(254) => 'p',
                           chr(255) => 'y'
                           );


//
// Default icon definitions
//
$edit_icon               = "<img src='images/icons/edit16.png' alt='Edit' border='0'>";
$delete_icon             = "<img src='images/icons/delete16.png' alt='Delete' border='0'>";
$print_icon              = "<img src='images/icons/printer16.png' alt='Print' border='0'>";
$filedownload_icon       = "<img src='images/icons/filedownload16.png' alt='Download' border='0'>";
$labels_icon             = "<img src='images/icons/textfile-bw16.png' alt='Labels' border='0'>";
$view_icon               = "<img src='images/icons/find16.png' alt='View' border='0'>";
$accept_icon             = "<img src='images/icons/accept16.png' alt='Accept' border='0'>";
$change_icon             = "<img src='images/icons/refresh16.png' alt='Change' border='0'>";
$money_icon              = "<img src='images/icons/money16.png' alt='Account' border='0'>";
$students_icon           = "<img src='images/icons/groupofusers16.png' alt='Manage Students' border='0'>";
$reminder_icon           = "<img src='images/icons/mailsend16.png' alt='Send Account Login Reminder Email' border='0'>";
$email_icon              = "<img src='images/icons/mailsend16.png' alt='Send Email' border='0'>";
$contact_icon            = "<img src='images/icons/userid16.png' alt='View Contact Information' border='0'>";
$clock_icon              = "<img src='images/icons/clock16.png' alt='Login Log' border='0'>";
$info_icon               = "<img src='images/icons/infoabout16.png' alt='Information' border='0'>";
$open_icon               = "<img src='images/icons/folderopenb16.png' alt='Open Folder' border='0'>";
$filesearch_icon         = "<img src='images/icons/filesearch16.png' alt='Detail' border='0'>";


$edit_icon_small         = "<img src='images/icons/edit16.png' alt='Edit' border='0'>";
$delete_icon_small       = "<img src='images/icons/delete16.png' alt='Delete' border='0'>";
$print_icon_small        = "<img src='images/icons/printer16.png' alt='Print' border='0'>";
$filedownload_icon_small = "<img src='images/icons/filedownload16.png' alt='Download' border='0'>";
$labels_icon_small       = "<img src='images/icons/textfile-bw16.png' alt='Labels' border='0'>";
$view_icon_small         = "<img src='images/icons/find16.png' alt='View' border='0'>";
$accept_icon_small       = "<img src='images/icons/accept16.png' alt='Accept' border='0'>";
$change_icon_small       = "<img src='images/icons/refresh16.png' alt='Change' border='0'>";
$money_icon_small        = "<img src='images/icons/money16.png' alt='Account' border='0'>";
$students_icon_small     = "<img src='images/icons/groupofusers16.png' alt='Manage Students' border='0'>";
$reminder_icon_small     = "<img src='images/icons/mailsend16.png' alt='Send Account Login Reminder Email' border='0'>";
$email_icon_small        = "<img src='images/icons/mailsend16.png' alt='Send Email' border='0'>";
$contact_icon_small      = "<img src='images/icons/userid16.png' alt='View Contact Information' border='0'>";
$clock_icon_small        = "<img src='images/icons/clock16.png' alt='Login Log' border='0'>";
$info_icon_small         = "<img src='images/icons/infoabout16.png' alt='Information' border='0'>";
$open_icon_small         = "<img src='images/icons/folderopenb16.png' alt='Open Folder' border='0'>";
$filesearch_icon_small   = "<img src='images/icons/filesearch16.png' alt='Detail' border='0'>";
$file_icon_small         = "<img src='images/icons/textfile16.png' alt='Form' border='0'>";
$users_icon_small        = "<img src='images/icons/groupofusers16.png' alt='Manage Users' border='0'>";
$order_icon_small        = "<img src='images/icons/textfile16.png' alt='View Order' border='0'>";


if (array_key_exists('REMOTE_ADDR',$_SERVER)) $user_ip = $_SERVER["REMOTE_ADDR"];
$markIP = "187.191.8.250";

?>