<?php
//20141126 - new mysqli class - http://php.net/manual/en/mysqlinfo.api.choosing.php - pj
//20170801 - added S3 live/QA urls - maanie
//20170919 - removed webadmin from base url - maanie
//20171005 - added S3 live prod server - maanie
//20171013 -  added QA DB settings - maanie

//test comment
   ini_set('display_errors', '1');
   error_reporting(E_ALL & ~E_STRICT & ~E_NOTICE & ~E_WARNING);

   //load in descending order
   include_once("system.server.PROD.php");
   include_once("system.server.QA.php");
   include_once("system.server.DEV.php");
//print_r($DATABASE_SETTINGS[lamp]);
//S3 LIVE QA
   //$DATABASE_SETTINGS_S3["10.0.0.173"]->hostname = "10.0.0.149";

//S3 LIVE PROD
   //$DATABASE_SETTINGS_S3["10.0.0.173"]->hostname = "10.0.0.60"; //20171005 - added S3 live prod server - maanie

   $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[SERVER_PROTOCOL] = "https";

   $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]);

   //20170801 - added S3 live/QA urls - maanie
   //20170807 - created API BASE_URL - maanie
   //20170919 - removed webadmin from base url - maanie
   /*$SystemSettings[BASE_URL_S3] = $SystemSettings[SERVER_PROTOCOL] ."://". ($SystemSettings[SERVER_NAME] != "lamp" ? $DATABASE_SETTINGS_S3[$SystemSettings[SERVER_NAME]]->hostname : $SystemSettings[SERVER_NAME]) . "/sawis" . ($SystemSettings[SERVER_NAME] != "lamp" ? "" : "/webadmin");*/
   /*$SystemSettings[BASE_URL_S3] = $SystemSettings[SERVER_PROTOCOL] ."://";
   if($SystemSettings[SERVER_NAME] != "lamp") //QA/PROD
   {
      $SystemSettings[BASE_URL_S3] .= $DATABASE_SETTINGS_S3[$SystemSettings[SERVER_NAME]]->hostname;
   }
   else //LAMP
   {
      $SystemSettings[BASE_URL_S3] .= $SystemSettings[SERVER_NAME] . "/sawis/webadmin";
   }*/

   $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 "_framework/system.functions.inc.php";
   include_once "_framework/_nemo.translations.inc.php";
   include_once("_framework/_nemo.menu.cls.php");
   include_once("_framework/_nemo.menu.translator.cls.php");
   include_once "project.functions.inc.php";
   global $xdb, $HTTP, $MYSQLI;

   $HTTP = $SystemSettings[SERVER_PROTOCOL]; //might not work, set manually // = "http://";

   //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";
      vd($_SERVER[SERVER_NAME]);
      //print_rr($DATABASE_SETTINGS);
      //print_rr($SystemSettings);
      print_rr($SystemMessage);

   }else{
      if (!mysqli_set_charset($MYSQLI, "utf8")) { //20180816 - UTF-8 checks - pj
         //printf("Error loading character set utf8: %s\n", mysqli_error($MYSQLI));
      } else {
         //printf("Current character set: %s\n", mysqli_character_set_name($MYSQLI));
      }

      $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;
      }
   }

?>