| 1 | <?php
 | 
  
    | 2 | /**
 | 
  
    | 3 |  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
 | 
  
    | 4 |  *
 | 
  
    | 5 |  * This program is free software: you can redistribute it and/or modify
 | 
  
    | 6 |  * it under the terms of the GNU General Public License as published by
 | 
  
    | 7 |  * the Free Software Foundation, either version 3 of the License, or
 | 
  
    | 8 |  * (at your option) any later version.
 | 
  
    | 9 |  *
 | 
  
    | 10 |  * This program is distributed in the hope that it will be useful,
 | 
  
    | 11 |  * but WITHOUT ANY WARRANTY; without even the implied warranty of
 | 
  
    | 12 |  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 | 
  
    | 13 |  * GNU General Public License for more details.
 | 
  
    | 14 |  *
 | 
  
    | 15 |  * You should have received a copy of the GNU General Public License
 | 
  
    | 16 |  * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 | 
  
    | 17 |  */
 | 
  
    | 18 | 
 | 
  
    | 19 | /**
 | 
  
    | 20 |  * initialize.php
 | 
  
    | 21 |  *
 | 
  
    | 22 |  * @category     Core
 | 
  
    | 23 |  * @package      Core_Environment
 | 
  
    | 24 |  * @author       Werner v.d.Decken <wkl@isteam.de>
 | 
  
    | 25 |  * @copyright    Werner v.d.Decken <wkl@isteam.de>
 | 
  
    | 26 |  * @license      http://www.gnu.org/licenses/gpl.html   GPL License
 | 
  
    | 27 |  * @version      0.0.1
 | 
  
    | 28 |  * @revision     $Revision: 2136 $
 | 
  
    | 29 |  * @link         $HeadURL: svn://isteam.dynxs.de/wb-archiv/branches/2.8.x/wb/framework/initialize.php $
 | 
  
    | 30 |  * @lastmodified $Date: 2015-10-22 01:11:20 +0200 (Thu, 22 Oct 2015) $
 | 
  
    | 31 |  * @since        File replaced since 05.02.2013
 | 
  
    | 32 |  * @description  set the basic environment to run WebsiteBaker
 | 
  
    | 33 |  */
 | 
  
    | 34 | 
 | 
  
    | 35 | /* *** define some helper functions *** */
 | 
  
    | 36 | /**
 | 
  
    | 37 |  * sanitize $_SERVER['HTTP_REFERER']
 | 
  
    | 38 |  * @param string $sWbUrl qualified startup URL of current application
 | 
  
    | 39 |  */
 | 
  
    | 40 |     function initSanitizeHttpReferer($sWbUrl) {
 | 
  
    | 41 |         $sTmpReferer = '';
 | 
  
    | 42 |         if (isset($_SERVER['HTTP_REFERER']) && $_SERVER['HTTP_REFERER'] != '') {
 | 
  
    | 43 |             define('ORG_REFERER', ($_SERVER['HTTP_REFERER'] ?: ''));
 | 
  
    | 44 |             $sTmpReferer = $_SERVER['HTTP_REFERER'];
 | 
  
    | 45 |             $aRefUrl = parse_url($_SERVER['HTTP_REFERER']);
 | 
  
    | 46 |             if ($aRefUrl !== false) {
 | 
  
    | 47 |                 $aRefUrl['host'] = isset($aRefUrl['host']) ? $aRefUrl['host'] : '';
 | 
  
    | 48 |                 $aRefUrl['path'] = isset($aRefUrl['path']) ? $aRefUrl['path'] : '';
 | 
  
    | 49 |                 $aRefUrl['fragment'] = isset($aRefUrl['fragment']) ? '#'.$aRefUrl['fragment'] : '';
 | 
  
    | 50 |                 $aWbUrl = parse_url($sWbUrl);
 | 
  
    | 51 |                 if ($aWbUrl !== false) {
 | 
  
    | 52 |                     $aWbUrl['host'] = isset($aWbUrl['host']) ? $aWbUrl['host'] : '';
 | 
  
    | 53 |                     $aWbUrl['path'] = isset($aWbUrl['path']) ? $aWbUrl['path'] : '';
 | 
  
    | 54 |                     if (strpos($aRefUrl['host'].$aRefUrl['path'],
 | 
  
    | 55 |                                $aWbUrl['host'].$aWbUrl['path']) !== false) {
 | 
  
    | 56 |                         $aRefUrl['path'] = preg_replace('#^'.$aWbUrl['path'].'#i', '', $aRefUrl['path']);
 | 
  
    | 57 |                         $sTmpReferer = $sWbUrl.$aRefUrl['path'].$aRefUrl['fragment'];
 | 
  
    | 58 |                     }
 | 
  
    | 59 |                     unset($aWbUrl);
 | 
  
    | 60 |                 }
 | 
  
    | 61 |                 unset($aRefUrl);
 | 
  
    | 62 |             }
 | 
  
    | 63 |         }
 | 
  
    | 64 |         $_SERVER['HTTP_REFERER'] = $sTmpReferer;
 | 
  
    | 65 |     }
 | 
  
    | 66 | /**
 | 
  
    | 67 |  * Set constants for system/install values
 | 
  
    | 68 |  * @throws RuntimeException
 | 
  
    | 69 |  */
 | 
  
    | 70 |     function initSetInstallPathConstants() {
 | 
  
    | 71 |         if(!defined('DEBUG')){ define('DEBUG', false); } // normaly set in config file
 | 
  
    | 72 |         if(!defined('ADMIN_DIRECTORY')){ define('ADMIN_DIRECTORY', 'admin'); }
 | 
  
    | 73 |         if(!preg_match('/xx[a-z0-9_][a-z0-9_\-\.]+/i', 'xx'.ADMIN_DIRECTORY)) {
 | 
  
    | 74 |             throw new RuntimeException('Invalid admin-directory: ' . ADMIN_DIRECTORY);
 | 
  
    | 75 |         }
 | 
  
    | 76 |         if(!defined('WB_PATH')){ define('WB_PATH', dirname(__DIR__)); }
 | 
  
    | 77 |         if(!defined('ADMIN_URL')){ define('ADMIN_URL', rtrim(WB_URL, '/\\').'/'.ADMIN_DIRECTORY); }
 | 
  
    | 78 |         if(!defined('ADMIN_PATH')){ define('ADMIN_PATH', WB_PATH.'/'.ADMIN_DIRECTORY); }
 | 
  
    | 79 |         if(!defined('WB_REL')){
 | 
  
    | 80 |             $x1 = parse_url(WB_URL);
 | 
  
    | 81 |             define('WB_REL', (isset($x1['path']) ? $x1['path'] : ''));
 | 
  
    | 82 |         }
 | 
  
    | 83 |         if(!defined('ADMIN_REL')){ define('ADMIN_REL', WB_REL.'/'.ADMIN_DIRECTORY); }
 | 
  
    | 84 |         if(!defined('DOCUMENT_ROOT')) {
 | 
  
    | 85 |             define('DOCUMENT_ROOT', preg_replace('/'.preg_quote(str_replace('\\', '/', WB_REL), '/').'$/', '', str_replace('\\', '/', WB_PATH)));
 | 
  
    | 86 |             $_SERVER['DOCUMENT_ROOT'] = DOCUMENT_ROOT;
 | 
  
    | 87 |         }
 | 
  
    | 88 |         if(!defined('TMP_PATH')){ define('TMP_PATH', WB_PATH.'/temp'); }
 | 
  
    | 89 |     }
 | 
  
    | 90 | /**
 | 
  
    | 91 |  * checkValidCaller
 | 
  
    | 92 |  * @param array $aCaller list of allowed scripts
 | 
  
    | 93 |  * @return true || Exception
 | 
  
    | 94 |  * @throws RuntimeException
 | 
  
    | 95 |  * @description test if acctual file is called from one of the given list
 | 
  
    | 96 |  */
 | 
  
    | 97 |     function initCheckValidCaller(array $aCaller)
 | 
  
    | 98 |     {
 | 
  
    | 99 |         return true;
 | 
  
    | 100 |         $x = debug_backtrace();
 | 
  
    | 101 |         if(sizeof($x) == 0) {
 | 
  
    | 102 |             return true;
 | 
  
    | 103 |         }
 | 
  
    | 104 |         $sPattern = '/('.str_replace('#', '|', preg_quote(implode('#', $aCaller), '/')).')$/si';
 | 
  
    | 105 |         foreach($x as $aStep) {
 | 
  
    | 106 |             // define the scripts which can read the configuration
 | 
  
    | 107 |             if(preg_match($sPattern, $aStep['file'])) {
 | 
  
    | 108 |                 return true;
 | 
  
    | 109 |             }
 | 
  
    | 110 |         }
 | 
  
    | 111 |         throw new RuntimeException('illegal file request!');
 | 
  
    | 112 |     }
 | 
  
    | 113 | /**
 | 
  
    | 114 |  * Read DB settings from configuration file
 | 
  
    | 115 |  * @return array
 | 
  
    | 116 |  * @throws RuntimeException
 | 
  
    | 117 |  *
 | 
  
    | 118 |  */
 | 
  
    | 119 |     function initReadSetupFile()
 | 
  
    | 120 |     {
 | 
  
    | 121 |     // check for valid file request. Becomes more stronger in next version
 | 
  
    | 122 |         initCheckValidCaller(array('save.php','index.php','config.php','upgrade-script.php'));
 | 
  
    | 123 |         $aCfg = array();
 | 
  
    | 124 |         $sSetupFile = dirname(__DIR__).'/setup.ini.php';
 | 
  
    | 125 |         if(is_readable($sSetupFile)) {
 | 
  
    | 126 |             $aCfg = parse_ini_file($sSetupFile, true);
 | 
  
    | 127 |             if (!isset($aCfg['Constants']) || !isset($aCfg['DataBase'])) {
 | 
  
    | 128 |                 throw new InvalidArgumentException('configuration missmatch in setup.ini.php');
 | 
  
    | 129 |             }
 | 
  
    | 130 |             foreach($aCfg['Constants'] as $key=>$value) {
 | 
  
    | 131 |                 switch($key):
 | 
  
    | 132 |                     case 'DEBUG':
 | 
  
    | 133 |                         $value = filter_var($value, FILTER_VALIDATE_BOOLEAN);
 | 
  
    | 134 |                         if(!defined('DEBUG')) { define('DEBUG', $value); }
 | 
  
    | 135 |                         break;
 | 
  
    | 136 |                     case 'WB_URL': // << case is set deprecated
 | 
  
    | 137 |                     case 'AppUrl':
 | 
  
    | 138 |                         $value = trim(str_replace('\\', '/', $value), '/');
 | 
  
    | 139 |                         if(!defined('WB_URL')) { define('WB_URL', $value); }
 | 
  
    | 140 |                         break;
 | 
  
    | 141 |                     case 'ADMIN_DIRECTORY': // << case is set deprecated
 | 
  
    | 142 |                     case 'AcpDir':
 | 
  
    | 143 |                         $value = trim(str_replace('\\', '/', $value), '/');
 | 
  
    | 144 |                         if(!defined('ADMIN_DIRECTORY')) { define('ADMIN_DIRECTORY', $value); }
 | 
  
    | 145 |                         break;
 | 
  
    | 146 |                     default:
 | 
  
    | 147 |                         if(!defined($key)) { define($key, $value); }
 | 
  
    | 148 |                         break;
 | 
  
    | 149 |                 endswitch;
 | 
  
    | 150 |             }
 | 
  
    | 151 |         }
 | 
  
    | 152 |         return $aCfg;
 | 
  
    | 153 | //      throw new RuntimeException('unable to read setup.ini.php');
 | 
  
    | 154 |     }
 | 
  
    | 155 | /**
 | 
  
    | 156 |  * GetDbConnectData
 | 
  
    | 157 |  * @param array $aCfg
 | 
  
    | 158 |  * @param string $sDbConnectType  can be 'url' or 'dsn'
 | 
  
    | 159 |  * @return array
 | 
  
    | 160 |  *
 | 
  
    | 161 |  */
 | 
  
    | 162 |     function initGetDbConnectData(array $aCfg, $sDbConnectType = 'url')
 | 
  
    | 163 |     {
 | 
  
    | 164 |         if(defined('DB_TYPE'))
 | 
  
    | 165 |         {
 | 
  
    | 166 |         // import constants for compatibility reasons
 | 
  
    | 167 |             $db = array();
 | 
  
    | 168 |             if(defined('DB_TYPE'))      { $db['type']         = DB_TYPE; }
 | 
  
    | 169 |             if(defined('DB_USERNAME'))  { $db['user']         = DB_USERNAME; }
 | 
  
    | 170 |             if(defined('DB_PASSWORD'))  { $db['pass']         = DB_PASSWORD; }
 | 
  
    | 171 |             if(defined('DB_HOST'))      { $db['host']         = DB_HOST; }
 | 
  
    | 172 |             if(defined('DB_PORT'))      { $db['port']         = DB_PORT; }
 | 
  
    | 173 |             if(defined('DB_NAME'))      { $db['name']         = DB_NAME; }
 | 
  
    | 174 |             if(defined('DB_CHARSET'))   { $db['charset']      = DB_CHARSET; }
 | 
  
    | 175 |             if(defined('TABLE_PREFIX')) { $db['table_prefix'] = TABLE_PREFIX; }
 | 
  
    | 176 |             $aCfg['DataBase'] = $db;
 | 
  
    | 177 |         }
 | 
  
    | 178 |         // sanitize values
 | 
  
    | 179 |         $db = $aCfg['DataBase'];
 | 
  
    | 180 |         $db['type'] = isset($db['type']) ? $db['type'] : 'mysql';
 | 
  
    | 181 |         $db['user'] = isset($db['user']) ? $db['user'] : 'foo';
 | 
  
    | 182 |         $db['pass'] = isset($db['pass']) ? $db['pass'] : 'bar';
 | 
  
    | 183 |         $db['host'] = isset($db['host']) ? $db['host'] : 'localhost';
 | 
  
    | 184 |         $db['port'] = isset($db['port']) ? $db['port'] : '3306';
 | 
  
    | 185 |         $db['port'] = ($db['port'] != '3306') ? $db['port'] : '';
 | 
  
    | 186 |         $db['socket'] = isset($db['socket']) ? $db['socket'] : '';
 | 
  
    | 187 |         $db['name'] = isset($db['name']) ? $db['name'] : 'dummy';
 | 
  
    | 188 |         $db['charset'] = isset($db['charset']) ? trim($db['charset']) : 'utf8';
 | 
  
    | 189 |         $db['table_prefix'] = (isset($db['table_prefix']) ? $db['table_prefix'] : '');
 | 
  
    | 190 |         if (isset($db['options']) && is_array($db['options'])) {
 | 
  
    | 191 |             foreach ($db['options'] as $key=>$value) {
 | 
  
    | 192 |                 $aRetval['options'][constant($key)] = $value;
 | 
  
    | 193 |             }
 | 
  
    | 194 |         }
 | 
  
    | 195 |         if(!defined('TABLE_PREFIX')) { define('TABLE_PREFIX', $db['table_prefix']); }
 | 
  
    | 196 |         if($sDbConnectType == 'dsn') {
 | 
  
    | 197 |         // build dsn to connect
 | 
  
    | 198 |             $aRetval['dsn']      = $db['type'].':dbname='.$db['name'].';host='.$db['host']
 | 
  
    | 199 |                                  . ($db['port'] != '' ? ';port='.(int)$db['port'] : '');
 | 
  
    | 200 |             if ($db['charset'] == 'utf8') {
 | 
  
    | 201 |                 $aRetval['dsn'] .= ';charset=UTF8';
 | 
  
    | 202 |                 $aRetval['options'][constant('PDO::MYSQL_ATTR_INIT_COMMAND')]  = 'SET NAMES \'UTF8\'';
 | 
  
    | 203 |             }
 | 
  
    | 204 |             $aRetval['options']  = '';
 | 
  
    | 205 |             $aRetval['user']     = $db['user'];
 | 
  
    | 206 |             $aRetval['password'] = $db['pass'];
 | 
  
    | 207 |             $aRetval['addons']   = array('CHARSET' => $db['charset'], 'TABLE_PREFIX' => $db['table_prefix']);
 | 
  
    | 208 |         }else {
 | 
  
    | 209 |         // build url to connect
 | 
  
    | 210 |             $aRetval['url'] = $db['type'].'://'.$db['user'].':'.$db['pass'].'@'
 | 
  
    | 211 |                             . $db['host'].($db['port'] != '' ? ':'.$db['port'] : '').'/'.$db['name']
 | 
  
    | 212 |                             . '?Charset='.$db['charset'].'&TablePrefix='.$db['table_prefix'];
 | 
  
    | 213 |         }
 | 
  
    | 214 |         return $aRetval;
 | 
  
    | 215 |     }
 | 
  
    | 216 | 
 | 
  
    | 217 |     function WbErrorHandler($iErrorCode, $sErrorText, $sErrorFile, $iErrorLine)
 | 
  
    | 218 |     {
 | 
  
    | 219 |         if (!(error_reporting() & $iErrorCode)) {
 | 
  
    | 220 |             return false;
 | 
  
    | 221 |         }
 | 
  
    | 222 |         $bRetval = false;
 | 
  
    | 223 |         $aErrors = array(
 | 
  
    | 224 |             E_USER_DEPRECATED => 'E_USER_DEPRECATED',
 | 
  
    | 225 |             E_USER_NOTICE     => 'E_USER_NOTICE',
 | 
  
    | 226 |             E_USER_WARNING    => 'E_USER_WARNING',
 | 
  
    | 227 |             E_DEPRECATED      => 'E_DEPRECATED',
 | 
  
    | 228 |             E_NOTICE          => 'E_NOTICE',
 | 
  
    | 229 |             E_WARNING         => 'E_WARNING',
 | 
  
    | 230 |             E_CORE_WARNING    => 'E_CORE_WARNING',
 | 
  
    | 231 |             E_COMPILE_WARNING => 'E_COMPILE_WARNING',
 | 
  
    | 232 |             E_STRICT          => 'E_STRICT',
 | 
  
    | 233 |         );
 | 
  
    | 234 |         if (array_key_exists($iErrorCode, $aErrors)) {
 | 
  
    | 235 |             $sErrorType = $aErrors[$iErrorCode];
 | 
  
    | 236 |             $bRetval = true;
 | 
  
    | 237 |         }
 | 
  
    | 238 |         $aBt= debug_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS);
 | 
  
    | 239 |         $x = sizeof($aBt) -1;
 | 
  
    | 240 |         $x = $x < 2 ? $x : 2;
 | 
  
    | 241 |         $sEntry = date('c').' '.'['.$sErrorType.'] '.str_replace(dirname(__DIR__), '', $sErrorFile).':['.$iErrorLine.'] '
 | 
  
    | 242 |                 . ' from '.str_replace(dirname(__DIR__), '', $aBt[$x]['file']).':['.$aBt[$x]['line'].'] '
 | 
  
    | 243 |                 . (@$aBt[$x]['class'] ? $aBt[$x]['class'].$aBt[$x]['type'] : '').$aBt[$x]['function'].' '
 | 
  
    | 244 |                 . '"'.$sErrorText.'"'.PHP_EOL;
 | 
  
    | 245 |         file_put_contents(dirname(__DIR__).'/var/log/error.log', $sEntry, FILE_APPEND);
 | 
  
    | 246 |         return $bRetval;
 | 
  
    | 247 |     }
 | 
  
    | 248 | /* ***************************************************************************************
 | 
  
    | 249 |  * Start initialization                                                                  *
 | 
  
    | 250 |  ****************************************************************************************/
 | 
  
    | 251 | // activate errorhandler
 | 
  
    | 252 |     set_error_handler('WbErrorHandler');
 | 
  
    | 253 | // reset global output buffering
 | 
  
    | 254 |     while (ob_get_level()) { ob_end_clean(); }
 | 
  
    | 255 | // test for existing and active old config.php
 | 
  
    | 256 |     if (defined('TABLE_PREFIX')) { /** TODO */ }
 | 
  
    | 257 | // set system defaults
 | 
  
    | 258 |     date_default_timezone_set('UTC');
 | 
  
    | 259 | // set internal character encoding to UTF-8
 | 
  
    | 260 |     mb_internal_encoding('UTF-8');
 | 
  
    | 261 | 
 | 
  
    | 262 | // initialize debug evaluation values ---
 | 
  
    | 263 |     $starttime = array_sum(explode(" ",microtime()));
 | 
  
    | 264 |     $iPhpDeclaredClasses = sizeof(get_declared_classes());
 | 
  
    | 265 |     $sDbConnectType = 'url'; // depending from class WbDatabase it can be 'url' or 'dsn'
 | 
  
    | 266 |     // calculate maximum timestamp
 | 
  
    | 267 |     if (!defined('MAX_TIMESTAMP')) { define('MAX_TIMESTAMP', pow(2, 31)-1); } // 2038-01-19 04:14:07
 | 
  
    | 268 | // PHP less then 5.4.0 is prohibited ---
 | 
  
    | 269 |     if (version_compare(PHP_VERSION, '5.4.0', '<')) {
 | 
  
    | 270 |         $sMsg = '<p style="color: #ff0000;">WebsiteBaker is not able to run with PHP-Version less then 5.4.0!!<br />'
 | 
  
    | 271 |               . 'Please change your PHP-Version to any kind from 5.4.0 and up!<br />'
 | 
  
    | 272 |               . 'If you have problems to solve that, ask your hosting provider for it.<br  />'
 | 
  
    | 273 |               . 'The very best solution is the use of PHP-5.5 and up</p>';
 | 
  
    | 274 |         die($sMsg);
 | 
  
    | 275 |     }
 | 
  
    | 276 |     if (! defined('SYSTEM_RUN')) { define('SYSTEM_RUN', true); }
 | 
  
    | 277 | // load configuration ---
 | 
  
    | 278 |     $aCfg = initReadSetupFile();
 | 
  
    | 279 | 
 | 
  
    | 280 | // sanitize $_SERVER['HTTP_REFERER'] ---
 | 
  
    | 281 |     initSetInstallPathConstants();
 | 
  
    | 282 |     initSanitizeHttpReferer(WB_URL);
 | 
  
    | 283 | // register WB basic autoloader ---
 | 
  
    | 284 |     $sTmp = __DIR__.'/WbAutoloader.php';
 | 
  
    | 285 |     if(!class_exists('WbAutoloader')){
 | 
  
    | 286 |         include($sTmp);
 | 
  
    | 287 |     }
 | 
  
    | 288 |     WbAutoloader::doRegister( array(
 | 
  
    | 289 |         'a' => trim(str_replace('\\', '/',ADMIN_DIRECTORY), '/'),
 | 
  
    | 290 |         'm' => 'modules',
 | 
  
    | 291 |         't' => 'templates',
 | 
  
    | 292 |         'i' => 'include',
 | 
  
    | 293 |         'v' => 'vendor'
 | 
  
    | 294 |     ));
 | 
  
    | 295 | //    WbAutoloader::doRegister(array(ADMIN_DIRECTORY=>'a', 'modules'=>'m', 'templates'=>'t', 'include'=>'i'));
 | 
  
    | 296 | // instantiate and initialize adaptor for temporary registry replacement ---
 | 
  
    | 297 |     $oReg = WbAdaptor::getInstance();
 | 
  
    | 298 |     $oReg->getWbConstants();
 | 
  
    | 299 | // register TWIG autoloader ---
 | 
  
    | 300 |     $sTmp = dirname(__DIR__).'/include/Sensio/Twig/lib/Twig/Autoloader.php';
 | 
  
    | 301 |     if(!class_exists('Twig_Autoloader') && is_readable($sTmp)) {
 | 
  
    | 302 |         include($sTmp);
 | 
  
    | 303 |         Twig_Autoloader::register();
 | 
  
    | 304 |     }
 | 
  
    | 305 | // register PHPMailer autoloader ---
 | 
  
    | 306 |     $sTmp = dirname(__DIR__).'include/phpmailer/PHPMailerAutoload.php';
 | 
  
    | 307 |     if (!function_exists('PHPMailerAutoload') && is_readable($sTmp)) {
 | 
  
    | 308 |         require($sTmp);
 | 
  
    | 309 |     }
 | 
  
    | 310 | // aktivate exceptionhandler ---
 | 
  
    | 311 |     if(!function_exists('globalExceptionHandler')) {
 | 
  
    | 312 |         include(__DIR__.'/globalExceptionHandler.php');
 | 
  
    | 313 |     }
 | 
  
    | 314 | // check logfiles and compress it if needed
 | 
  
    | 315 |     $oLogRotate = new LogRotation($oReg);
 | 
  
    | 316 |     $oLogRotate->execute();
 | 
  
    | 317 |     unset($oLogRotate);
 | 
  
    | 318 | // ---------------------------
 | 
  
    | 319 | // get Database connection data from configuration
 | 
  
    | 320 |     $aSqlData = initGetDbConnectData($aCfg, $sDbConnectType);
 | 
  
    | 321 | // Create global database instance ---
 | 
  
    | 322 |     $oDb = $database = WbDatabase::getInstance();
 | 
  
    | 323 |     if($sDbConnectType == 'dsn') {
 | 
  
    | 324 |         $bTmp = $oDb->doConnect($aSqlData['dsn'], $aSqlData['user'], $aSqlData['password'], null, $aSqlData['addons']);
 | 
  
    | 325 |     }else {
 | 
  
    | 326 |         $bTmp = $oDb->doConnect($aSqlData['url']);
 | 
  
    | 327 |     }
 | 
  
    | 328 | // remove critical data from memory
 | 
  
    | 329 |     unset($aSqlData, $aCfg);
 | 
  
    | 330 | 
 | 
  
    | 331 |     if(!defined('TABLE_PREFIX')) { define('TABLE_PREFIX', $oDb->TablePrefix); }
 | 
  
    | 332 | 
 | 
  
    | 333 | // load global settings from database and define global consts from ---
 | 
  
    | 334 |     $sql = 'SELECT `name`, `value` FROM `'.$oDb->TablePrefix.'settings`';
 | 
  
    | 335 |     if(($oSettings = $oDb->doQuery($sql))) {
 | 
  
    | 336 |         if (($aRecords = $oSettings->fetchAll(MYSQLI_ASSOC))) {
 | 
  
    | 337 |             for ($i = 0, $iNum = sizeof($aRecords); $i < $iNum; $i++) {
 | 
  
    | 338 |                 //sanitize true/false values
 | 
  
    | 339 |                 $aRecords[$i]['value'] = ($aRecords[$i]['value'] == 'true'
 | 
  
    | 340 |                                       ? true
 | 
  
    | 341 |                                       : ($aRecords[$i]['value'] == 'false'
 | 
  
    | 342 |                                          ? false
 | 
  
    | 343 |                                          : $aRecords[$i]['value'])
 | 
  
    | 344 |                                      );
 | 
  
    | 345 |                 $sSettingName = strtoupper($aRecords[$i]['name']);
 | 
  
    | 346 |                 switch($sSettingName):
 | 
  
    | 347 |                     case 'STRING_FILE_MODE':
 | 
  
    | 348 |                         $iTmp = ((intval(octdec($aRecords[$i]['value'])) & ~0111)|0600);
 | 
  
    | 349 |                         if(!defined('OCTAL_FILE_MODE')) { define('OCTAL_FILE_MODE', $iTmp); } // deprecated
 | 
  
    | 350 |                         if(!defined('FILE_MODE_OCTAL')) { define('FILE_MODE_OCTAL', $iTmp); } // deprecated
 | 
  
    | 351 |                         if(!defined('STRING_FILE_MODE')) { define('STRING_FILE_MODE', sprintf('0%03o', $iTmp)); } // deprecated
 | 
  
    | 352 |                         if(!defined('FILE_MODE')) { define('FILE_MODE', $iTmp); }
 | 
  
    | 353 |                         if(!defined('FILE_MODE_STRING')) { define('FILE_MODE_STRING', sprintf('0%03o', $iTmp)); }
 | 
  
    | 354 |                         break;
 | 
  
    | 355 |                     case 'STRING_DIR_MODE':
 | 
  
    | 356 |                         $iTmp = (intval(octdec($aRecords[$i]['value'])) |0711);
 | 
  
    | 357 |                         if(!defined('OCTAL_DIR_MODE')) { define('OCTAL_DIR_MODE', $iTmp); } // deprecated
 | 
  
    | 358 |                         if(!defined('DIR_MODE_OCTAL')) { define('DIR_MODE_OCTAL', $iTmp); } // deprecated
 | 
  
    | 359 |                         if(!defined('STRING_DIR_MODE')) { define('STRING_DIR_MODE', sprintf('0%03o', $iTmp)); } // deprecated
 | 
  
    | 360 |                         if(!defined('DIR_MODE')) { define('DIR_MODE', $iTmp); }
 | 
  
    | 361 |                         if(!defined('DIR_MODE_STRING')) { define('DIR_MODE_STRING', sprintf('0%03o', $iTmp)); }
 | 
  
    | 362 |                         break;
 | 
  
    | 363 |                     case 'PAGES_DIRECTORY':
 | 
  
    | 364 |                         // sanitize pages_directory
 | 
  
    | 365 |                         $sTmp = trim($aRecords[$i]['value'], '/');
 | 
  
    | 366 |                         $sTmp = ($sTmp == '' ? '' : '/'.$sTmp);
 | 
  
    | 367 |                         if(!defined('PAGES_DIRECTORY')) { define('PAGES_DIRECTORY', $sTmp); }
 | 
  
    | 368 |                         break;
 | 
  
    | 369 |                     default: // make global const from setting
 | 
  
    | 370 |                         if(!defined($sSettingName)) { define($sSettingName, $aRecords[$i]['value']); }
 | 
  
    | 371 |                         break;
 | 
  
    | 372 |                 endswitch;
 | 
  
    | 373 |             }
 | 
  
    | 374 |             unset($aRecords);
 | 
  
    | 375 |         } else {
 | 
  
    | 376 |             throw new AppException('no settings found');
 | 
  
    | 377 |         }
 | 
  
    | 378 |     } else {
 | 
  
    | 379 |         throw new AppException($oDb->getError());
 | 
  
    | 380 |     }
 | 
  
    | 381 |     $oReg->getWbConstants();
 | 
  
    | 382 | // set error-reporting from loaded settings ---
 | 
  
    | 383 |     $iErrorLevel = intval(ER_LEVEL);
 | 
  
    | 384 |     if ($iErrorLevel >= 0 && $iErrorLevel <= E_ALL) {
 | 
  
    | 385 |         error_reporting($iErrorLevel);
 | 
  
    | 386 |     } else {
 | 
  
    | 387 |     // on invalid value in ER_LEVEL activate E_ALL
 | 
  
    | 388 |         error_reporting(E_ALL);
 | 
  
    | 389 |     }
 | 
  
    | 390 | // activate display_errors
 | 
  
    | 391 |     if( intval(ini_get ( 'display_errors' )) == 0 ) {
 | 
  
    | 392 |         ini_set('display_errors', 1);
 | 
  
    | 393 |     }
 | 
  
    | 394 | // Start a session ---
 | 
  
    | 395 |     if(!defined('SESSION_STARTED')) {
 | 
  
    | 396 |         session_name(APP_NAME.'_session_id');
 | 
  
    | 397 |         @session_start();
 | 
  
    | 398 |         define('SESSION_STARTED', true);
 | 
  
    | 399 |     }
 | 
  
    | 400 | // get/set server timezone ---
 | 
  
    | 401 |     if(!defined('SERVER_TIMEZONE')) { define('SERVER_TIMEZONE', "UTC"); }
 | 
  
    | 402 |     if(!defined('MAX_TIME')) { define('MAX_TIME', (pow(2, 31)-1)); } // 32-Bit Timestamp of 19 Jan 2038 03:14:07 GMT
 | 
  
    | 403 |     $sTmp = (isset($_SERVER['HTTP_DNT']) && $_SERVER['HTTP_DNT'] != '') ? $_SERVER['HTTP_DNT'] : '0';
 | 
  
    | 404 |     if(!defined('DO_NOT_TRACK')) { define('DO_NOT_TRACK', ($sTmp[0] == '1')); }
 | 
  
    | 405 | // get/set users timezone ---
 | 
  
    | 406 |     if(!defined('TIMEZONE')) { define('TIMEZONE', (isset($_SESSION['TIMEZONE']) ? $_SESSION['TIMEZONE'] : DEFAULT_TIMEZONE)); }
 | 
  
    | 407 |     if(!defined('DATE_FORMAT')) { define('DATE_FORMAT', (isset($_SESSION['DATE_FORMAT']) ? $_SESSION['DATE_FORMAT'] : DEFAULT_DATE_FORMAT)); }
 | 
  
    | 408 |     if(!defined('TIME_FORMAT')) { define('TIME_FORMAT', (isset($_SESSION['TIME_FORMAT']) ? $_SESSION['TIME_FORMAT'] : DEFAULT_TIME_FORMAT)); }
 | 
  
    | 409 | // set Theme directory ---
 | 
  
    | 410 |     if(!defined('THEME_URL')) { define('THEME_URL',  WB_URL.'/templates/'.DEFAULT_THEME); }
 | 
  
    | 411 |     if(!defined('THEME_PATH')) { define('THEME_PATH', WB_PATH.'/templates/'.DEFAULT_THEME); }
 | 
  
    | 412 |     if(!defined('THEME_REL')) { define('THEME_REL',  WB_REL.'/templates/'.DEFAULT_THEME); }
 | 
  
    | 413 | // extended wb editor settings
 | 
  
    | 414 |     if(!defined('EDIT_ONE_SECTION')) { define('EDIT_ONE_SECTION', false); }
 | 
  
    | 415 |     if(!defined('EDITOR_WIDTH')) { define('EDITOR_WIDTH', 0); }
 | 
  
    | 416 | // *** begin deprecated part *************************************************************
 | 
  
    | 417 | // load settings for use in Captch and ASP module
 | 
  
    | 418 |     if (!defined('WB_INSTALL_PROCESS') && !defined('ENABLED_CAPTCHA')) {
 | 
  
    | 419 |         $sql = 'SELECT * FROM `'.$oDb->TablePrefix.'mod_captcha_control`';
 | 
  
    | 420 |         // request settings from database
 | 
  
    | 421 |         if(($oSettings = $oDb->doQuery($sql))) {
 | 
  
    | 422 |             if(($aSetting = $oSettings->fetchAssoc())) {
 | 
  
    | 423 |                 define('ENABLED_CAPTCHA', ($aSetting['enabled_captcha'] == '1'));
 | 
  
    | 424 |                 define('ENABLED_ASP', ($aSetting['enabled_asp'] == '1'));
 | 
  
    | 425 |                 define('CAPTCHA_TYPE', $aSetting['captcha_type']);
 | 
  
    | 426 |                 define('ASP_SESSION_MIN_AGE', (int)$aSetting['asp_session_min_age']);
 | 
  
    | 427 |                 define('ASP_VIEW_MIN_AGE', (int)$aSetting['asp_view_min_age']);
 | 
  
    | 428 |                 define('ASP_INPUT_MIN_AGE', (int)$aSetting['asp_input_min_age']);
 | 
  
    | 429 |             }
 | 
  
    | 430 |         }
 | 
  
    | 431 |     }
 | 
  
    | 432 |     if(defined('ENABLED_ASP') && ENABLED_ASP && !isset($_SESSION['session_started'])) {
 | 
  
    | 433 |         $_SESSION['session_started'] = time();
 | 
  
    | 434 |     }
 | 
  
    | 435 | // *** end of deprecated part ************************************************************
 | 
  
    | 436 | // get user language ---
 | 
  
    | 437 |     $sRequestMethod = '_'.strtoupper($_SERVER['REQUEST_METHOD']);
 | 
  
    | 438 |     // check if get/post value is available
 | 
  
    | 439 |     $sTempLanguage = (isset(${$sRequestMethod}['lang']) ? ${$sRequestMethod}['lang'] : '');
 | 
  
    | 440 |     // validate language code
 | 
  
    | 441 |     if (preg_match('/^[a-z]{2}$/si', $sTempLanguage)) {
 | 
  
    | 442 |     // if there's valid get/post
 | 
  
    | 443 |         define('LANGUAGE', strtoupper($sTempLanguage));
 | 
  
    | 444 |     } else {
 | 
  
    | 445 |         if (!defined('LANGUAGE')) {
 | 
  
    | 446 |             if(isset($_SESSION['LANGUAGE']) && $_SESSION['LANGUAGE']) {
 | 
  
    | 447 |             // if there's valid session value
 | 
  
    | 448 |                 define('LANGUAGE', $_SESSION['LANGUAGE']);
 | 
  
    | 449 |             } else {
 | 
  
    | 450 |             // otherwise set to default
 | 
  
    | 451 |                 define('LANGUAGE', DEFAULT_LANGUAGE);
 | 
  
    | 452 |             }
 | 
  
    | 453 |         }
 | 
  
    | 454 |     }
 | 
  
    | 455 |     $_SESSION['LANGUAGE'] = LANGUAGE;
 | 
  
    | 456 | // activate translations / load language definitions
 | 
  
    | 457 | /** begin of deprecated part || will be replaced by class Translate **/
 | 
  
    | 458 | // Load Language file
 | 
  
    | 459 |     if(!file_exists(WB_PATH.'/languages/'.LANGUAGE.'.php')) {
 | 
  
    | 460 |         $sMsg = 'Error loading language file '.LANGUAGE.', please check configuration';
 | 
  
    | 461 |         throw new AppException($sMsg);
 | 
  
    | 462 |     } else {
 | 
  
    | 463 |     // include language file
 | 
  
    | 464 |         require_once(WB_PATH.'/languages/'.LANGUAGE.'.php');
 | 
  
    | 465 |     }
 | 
  
    | 466 | /** end of deprecated part **/
 | 
  
    | 467 | // instantiate and initialize adaptor for temporary registry replacement ---
 | 
  
    | 468 |     $oReg->getWbConstants();
 | 
  
    | 469 | // load and activate new global translation table
 | 
  
    | 470 |     $oTrans = Translate::getInstance();
 | 
  
    | 471 | /* initializise Translate old style *************************************************** */
 | 
  
    | 472 | 
 | 
  
    | 473 |     $oTrans->initialize(
 | 
  
    | 474 |         'en',
 | 
  
    | 475 |         (defined('DEFAULT_LANGUAGE') ? DEFAULT_LANGUAGE : ''),
 | 
  
    | 476 |         (defined('LANGUAGE') ? LANGUAGE : ''),
 | 
  
    | 477 |         'WbOldStyle',
 | 
  
    | 478 | //        (Translate::CACHE_DISABLED|Translate::KEEP_MISSING),
 | 
  
    | 479 |         (DEBUG ? Translate::CACHE_DISABLED|Translate::KEEP_MISSING : 0)
 | 
  
    | 480 |     );
 | 
  
    | 481 | 
 | 
  
    | 482 | /* initializise Translate new style *************************************************** */
 | 
  
    | 483 | /*
 | 
  
    | 484 |     $oTrans->initialize(
 | 
  
    | 485 |         new TranslateAdaptorWbOldStyle($oReg),
 | 
  
    | 486 |         'en',
 | 
  
    | 487 |         (defined('DEFAULT_LANGUAGE') ? DEFAULT_LANGUAGE : ''),
 | 
  
    | 488 |         (defined('LANGUAGE') ? LANGUAGE : ''),
 | 
  
    | 489 |         (DEBUG ? Translate::CACHE_DISABLED|Translate::KEEP_MISSING : 0),
 | 
  
    | 490 |         $oReg->DirModeOctal,
 | 
  
    | 491 |         $oReg->TempPath
 | 
  
    | 492 |     );
 | 
  
    | 493 | */
 | 
  
    | 494 | /* ****** */
 | 
  
    | 495 |     $oReg->setDatabase(WbDatabase::getInstance());
 | 
  
    | 496 |     $oReg->setTranslate(Translate::getInstance());
 | 
  
    | 497 |     if(!class_exists('PasswordHash', false)) { include(WB_PATH.'/include/phpass/PasswordHash.php'); }
 | 
  
    | 498 |     $oPass = Password::getInstance(new PasswordHash(Password::CRYPT_LOOPS_DEFAULT, Password::HASH_TYPE_AUTO));
 | 
  
    | 499 |     if(defined('PASSWORD_CRYPT_LOOPS')) { $oPass->setIteration(PASSWORD_CRYPT_LOOPS); }
 | 
  
    | 500 |     if(defined('PASSWORD_HASH_TYPES'))  { $oPass->setHashType(PASSWORD_HASH_TYPES); }
 | 
  
    | 501 | /* *** END OF FILE ******************************************************************** */
 |