<?php
   
   ini_set('display_errors', '1');
   error_reporting(E_ALL ^ E_NOTICE);

   // $DATABASE_SETTINGS['lamp']->hostname = "cmysql5-5.wadns.net";
   // $DATABASE_SETTINGS['lamp']->username = "databaseuser3333";
   // $DATABASE_SETTINGS['lamp']->password = "apie13";
   // $DATABASE_SETTINGS['lamp']->database = "AnniesEmailTask";
   // $DATABASE_SETTINGS['lamp']->sessionpath = $_SERVER['DOCUMENT_ROOT']."/anniesemailtask/SESSION/";
   
   // $DATABASE_SETTINGS["192.168.100.6"]->hostname = "cmysql5-5.wadns.net";
   // $DATABASE_SETTINGS["192.168.100.6"]->username = "databaseuser3333";
   // $DATABASE_SETTINGS["192.168.100.6"]->password = "apie13";
   // $DATABASE_SETTINGS["192.168.100.6"]->database = "AnniesEmailTask";
   // $DATABASE_SETTINGS["192.168.100.6"]->sessionpath = $_SERVER['DOCUMENT_ROOT']."/anniesemailtask/SESSION/";

   //e.g. for other environments
   //live 1
   // $DATABASE_SETTINGS["www.overdrive.co.za"]->hostname = "cmysql5-5.wadns.net";
   // $DATABASE_SETTINGS["www.overdrive.co.za"]->username = "databaseuser3333";
   // $DATABASE_SETTINGS["www.overdrive.co.za"]->password = "apie13";
   // $DATABASE_SETTINGS["www.overdrive.co.za"]->database = "AnniesEmailTask";
   // $DATABASE_SETTINGS["www.overdrive.co.za"]->sessionpath = $_SERVER['DOCUMENT_ROOT']."/webadmin/SESSION/";

//20160125 - updated details - pj
   $DATABASE_SETTINGS["dev.overdrive.co.za"]->hostname = "sql24.jnb1.host-h.net";
   $DATABASE_SETTINGS["dev.overdrive.co.za"]->username = "annies_user";
   $DATABASE_SETTINGS["dev.overdrive.co.za"]->password = "Mpi9eY5I09Tw4y4jKO4C";
   $DATABASE_SETTINGS["dev.overdrive.co.za"]->database = "Annies_dev";
   $DATABASE_SETTINGS["dev.overdrive.co.za"]->sessionpath = $_SERVER['DOCUMENT_ROOT']."/webadmin/SESSION/";

   if($_SERVER[SERVER_NAME] == "overdrive.co.za")
   {
      $_SERVER[SERVER_NAME] = "www.overdrive.co.za";
   }
   elseif($_SERVER[SERVER_NAME] == "lamp")
   {
      $_SERVER[SERVER_NAME] = "lamp";
   }
   elseif($_SERVER[SERVER_NAME] == "192.168.100.6")
   {
      $_SERVER[SERVER_NAME] = "192.168.100.6";
   }
   else
   {
      $_SERVER[SERVER_NAME] = "dev.overdrive.co.za";
   }

   $SystemSettings[SERVER_NAME] = $_SERVER[SERVER_NAME];

   $strTemp = explode("/", $_SERVER[SERVER_PROTOCOL]);
   $SystemSettings[SERVER_PROTOCOL] = strtolower($strTemp[0]);
   $strTemp = array_reverse(explode("/", $_SERVER[SCRIPT_NAME]));
   $SystemSettings[SCRIPT_NAME] = $strTemp[0];
   $SystemSettings[REQUEST_URI] = $_SERVER[REQUEST_URI];

   $SystemSettings[FULL_URL] = $SystemSettings[SERVER_PROTOCOL] ."://". $SystemSettings[SERVER_NAME] . $_SERVER[REQUEST_URI];
   $SystemSettings[FULL_PATH] = $SystemSettings[SERVER_PROTOCOL] ."://". $SystemSettings[SERVER_NAME] . $_SERVER[SCRIPT_NAME];
   $SystemSettings[BASE_URL] = $SystemSettings[SERVER_PROTOCOL] ."://". $SystemSettings[SERVER_NAME] . str_replace($SystemSettings[SCRIPT_NAME], "", $_SERVER[SCRIPT_NAME]);
   $SystemSettings[argv] = $_SERVER[argv];

   //ini_set("session.gc_maxlifetime","7200");
   //ini_set("session.save_path", $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->sessionpath);
   //session_start();

   include_once "system.functions.inc.php";
   include_once "project.functions.inc.php";
   global $xdb, $HTTP, $MYSQLI;

   $HTTP = "http://";
      //print_rr($DATABASE_SETTINGS);
      //print_rr($_SERVER);
      //print_rr($SystemSettings);

   //20141126 - new mysqli class - http://php.net/manual/en/mysqlinfo.api.choosing.php - pj
   $db =
   $MYSQLI = mysqli_connect($DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->hostname
                       , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->username
                       , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->password
                       , $DATABASE_SETTINGS[$SystemSettings[SERVER_NAME]]->database);

   if(mysqli_connect_errno()) {
      $SystemMessage->Message = "Database Connection has Failed! [". mysqli_connect_error() ."]";
      $SystemMessage->Type = "Critical Error";
      //print_rr($DATABASE_SETTINGS);
      //print_rr($SystemSettings);
      print_rr($SystemMessage);

   }else{
      $xdb = new NemoDatabase("sysSettings");
      //$row = $xdb->getRowSQL("SELECT * FROM sysSettings WHERE strSetting = 'Rows per Page'");
      //$arrSys["Rows per Page"] = $row->strValue;
      $xdb->getList();
      while($row = $xdb->fetch())
      {
         $strSetting = $row->strSetting;
         $SystemSettings[$strSetting] = $row->strValue;
      }
   }



?>