X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmysql-connect.php;h=15a5e4f7919ff90f690bd7ba9c1783625d7a989f;hb=af59daf6541b279989547829c95adc5bee8ca11d;hp=600eae105304340a7a8d000062b7b800f14500f8;hpb=e6e3183f794b385f5acc38b371c220cc35cdac38;p=mailer.git diff --git a/inc/mysql-connect.php b/inc/mysql-connect.php index 600eae1053..15a5e4f791 100644 --- a/inc/mysql-connect.php +++ b/inc/mysql-connect.php @@ -40,86 +40,97 @@ if (!defined('__SECURITY')) { // CFG: DEBUG-SQL (if enabled and DEBUG_MODE is enabled all SQL queries will be logged to debug.log) define('DEBUG_SQL', false); -// Default is not a frameset -global $isFrameset; -$isFrameset = false; +// Non-database functions +require("inc/functions.php"); -// Load library -require_once(PATH."inc/db/lib.php"); +// Load more function libraries +foreach (array('request-functions', 'config-functions', 'filters', 'mysql-manager', 'extensions', 'db/lib', 'handler', 'hooks') as $lib) { + // Load special functions + LOAD_INC_ONCE(sprintf("inc/%s.php", $lib)); +} // END - foreach -// Load general functions -require_once(PATH."inc/functions.php"); // Non-database functions -require_once(PATH."inc/extensions.php"); -require_once(PATH."inc/language.php"); +// Set error handler +set_error_handler('__errorHandler'); + +// Register shutdown hook +register_shutdown_function('__SHUTDOWN_HOOK'); // Check if the user setups his MySQL stuff... -if ((empty($MySQL['login'])) && (!defined('mxchange_installing')) && (!isset($_GET['installing'])) && (isBooleanConstantAndTrue('mxchange_installed'))) { +if ((empty($MySQL['login'])) && (!defined('mxchange_installing')) && (!REQUEST_ISSET_GET(('installing'))) && (isBooleanConstantAndTrue('mxchange_installed'))) { // No login entered and outside installation mode - echo "".LANG_WARNING.": "; + OUTPUT_HTML("{--LANG_WARNING--}: "); if (isBooleanConstantAndTrue('mxchange_installed')) { // You have changed my configuration file! - die(DIE_CONFIG_CHANGED_YOU); + mxchange_die("{--DIE_CONFIG_CHANGED_YOU--}"); } else { // Please run the installation script (maybe again) - die(DIE_RUN_INSTALL_MYSQL); + mxchange_die("{--DIE_RUN_INSTALL_MYSQL--}"); } -} elseif ((!defined('mxchange_installing')) && (!isset($_GET['installing'])) && (empty($MySQL['password'])) && (isBooleanConstantAndTrue('warn_no_pass'))) { +} elseif ((!isBooleanConstantAndTrue('mxchange_installing')) && (!REQUEST_ISSET_GET(('installing'))) && (empty($MySQL['password'])) && (isBooleanConstantAndTrue('warn_no_pass'))) { // No database password entered!!! - echo "".LANG_WARNING.": ".WARN_NULL_PASSWORD; + OUTPUT_HTML("
{--LANG_WARNING--}:
{--WARN_NULL_PASSWORD--}"); } +// Set dummy $_CONFIG array +$_CONFIG = array( + 'code_length' => 0, + 'patch_level' => 0, + 'last_update' => time() +); + +// Set important header_sent +$GLOBALS['header_sent'] = 0; + +// Init fatal messages +initFatalMessages(); + // Check if this file is writeable or read-only and warn the user -if ((!defined('mxchange_installing')) && (isBooleanConstantAndTrue('mxchange_installed'))) { +if ((!isBooleanConstantAndTrue('mxchange_installing')) && (isBooleanConstantAndTrue('mxchange_installed'))) { // Check for write-permission for config.php and inc directory if (empty($GLOBALS['module'])) $GLOBALS['module'] = "index"; - if (($GLOBALS['module'] != "admin") && (isBooleanConstantAndTrue('admin_registered')) && (!isset($_SERVER['WINDIR']))) { - if (is_INCWritable("config")) ADD_FATAL(FATAL_CONFIG_WRITABLE); - if (is_INCWritable("dummy")) ADD_FATAL(FATAL_INC_WRITABLE); - } - $EXT_CSS_FILES = array(); + + // CSS array + EXT_INIT_CSS_FILES(); if ((!empty($MySQL['host'])) && (!empty($MySQL['login'])) && (!empty($MySQL['password'])) && (!empty($MySQL['dbase']))) { // Connect to DB - global $link; - $link = SQL_CONNECT($MySQL['host'], $MySQL['login'], $MySQL['password'], __FILE__, __LINE__); + SQL_CONNECT($MySQL['host'], $MySQL['login'], $MySQL['password'], __FILE__, __LINE__); // Is the link valid? - if (is_resource($link)) { - // Choose the database - global $db; - $db = SQL_SELECT_DB($MySQL['dbase'], $link, __FILE__, __LINE__); - + if (SQL_IS_LINK_UP()) { // Is it a valid resource? - if ($db === true) { - // Load more include files - require_once(PATH."inc/mysql-manager.php"); // Functions which interact with the database + if (SQL_SELECT_DB($MySQL['dbase'], __FILE__, __LINE__) === true) { + // This is required for extension 'optimize' to work + define('__DB_NAME', $MySQL['dbase']); - // Load configuration stuff - $_CONFIG = LOAD_CONFIG(); + // Remove MySQL array from namespace + unset($MySQL); - // Initialize include-file-pool - $INC_POOL = array(); + // Load configuration stuff + mergeConfig(LOAD_CONFIG()); // Load "databases" aka static arrays - require_once(PATH."inc/databases.php"); + LOAD_INC_ONCE("inc/databases.php"); // Loading patching system is required here... - require_once(PATH."inc/patch-system.php"); // Initialize patch system + LOAD_INC_ONCE("inc/patch-system.php"); // Initialize patch system - // Functions which are related to themes - require_once(PATH."inc/theme-manager.php"); + // Session management + LOAD_INC_ONCE("inc/session.php"); // Run daily reset - require_once(PATH."inc/check-reset.php"); + LOAD_INC_ONCE("inc/check-reset.php"); // Load admin include file if he is admin if (IS_ADMIN()) { // Administrative functions - require_once(PATH."inc/modules/admin/admin-inc.php"); + LOAD_INC_ONCE("inc/modules/admin/admin-inc.php"); } // END - if + //* DEBUG: */ ADD_POINTS_REFSYSTEM("test", 36, 1000); + //* DEBUG: */ die(); // Get all values - if (($CSS != 1) && ($CSS != -1)) { + if (($GLOBALS['output_mode'] != 1) && ($GLOBALS['output_mode'] != -1)) { if (empty($GLOBALS['module'])) $GLOBALS['module'] = "empty"; if (empty($GLOBALS['what'])) $GLOBALS['what'] = GET_WHAT($GLOBALS['module']); if (empty($GLOBALS['action'])) $GLOBALS['action'] = GET_ACTION($GLOBALS['module'], $GLOBALS['what']); @@ -129,22 +140,19 @@ if ((!defined('mxchange_installing')) && (isBooleanConstantAndTrue('mxchange_ins $GLOBALS['what'] = ""; } - // Secure and validate user ID from cookie - UPDATE_LOGIN_DATA(); - - // Update online list - UPDATE_ONLINE_LIST($PHPSESSID, $GLOBALS['module'], $GLOBALS['action'], $GLOBALS['what']); + // Run the init filter chain + RUN_FILTER('init'); // Set default 'what' value - //* DEBUG */ echo "-".$GLOBALS['module']."/".$GLOBALS['what']."-
\n"; - if ((empty($GLOBALS['what'])) && (empty($GLOBALS['action'])) && ($CSS != 1) && ($CSS != -1)) { + //* DEBUG: */ OUTPUT_HTML("-".$GLOBALS['module']."/".$GLOBALS['what']."-
"); + if ((empty($GLOBALS['what'])) && (empty($GLOBALS['action'])) && ($GLOBALS['output_mode'] != 1) && ($GLOBALS['output_mode'] != -1)) { if ($GLOBALS['module'] == "admin") { // Set 'action' value to 'login' in admin menu $GLOBALS['action'] = GET_ACTION($GLOBALS['module'], $GLOBALS['what']); } elseif (($GLOBALS['module'] == "index") || ($GLOBALS['module'] == "login")) { // Set 'what' value to 'welcome' in guest and member menu $GLOBALS['what'] = "welcome"; - if (!empty($_CONFIG['index_home'])) $GLOBALS['what'] = $_CONFIG['index_home']; + if (getConfig('index_home') != "") $GLOBALS['what'] = getConfig('index_home'); } else { // Anything else like begging link $GLOBALS['what'] = ""; @@ -152,7 +160,7 @@ if ((!defined('mxchange_installing')) && (isBooleanConstantAndTrue('mxchange_ins } // END - if // Update sending pool - if (($CSS != "1") && ($CSS != "-1")) require_once(PATH."inc/pool-update.php"); // Sends out mails in configureable steps + if (($GLOBALS['output_mode'] != "1") && ($GLOBALS['output_mode'] != "-1")) LOAD_INC_ONCE("inc/pool-update.php"); // Sends out mails in configureable steps // Load all active extension including language files when not upgrading. // Check module for testing and count one click @@ -161,77 +169,80 @@ if ((!defined('mxchange_installing')) && (isBooleanConstantAndTrue('mxchange_ins unset($dummy); // Shall we activate the exchange? - if ($_CONFIG['activate_xchange'] > 0) activateExchange(); + if (getConfig('activate_xchange') > 0) activateExchange(); - // Generate random number - if (isset($GLOBALS['userid'])) { - define('RAND_NUMBER', GEN_RANDOM_CODE(10, mt_rand(10000,32766), $GLOBALS['userid'], "")); + // Is the extension sql_patches installed and at least 0.3.6? + if (GET_EXT_VERSION("sql_patches") >= "0.3.6") { + // Generate random number + if (isset($GLOBALS['userid'])) { + define('RAND_NUMBER', GEN_RANDOM_CODE(10, mt_rand(10000,32766), $GLOBALS['userid'], "")); + } else { + define('RAND_NUMBER', GEN_RANDOM_CODE(10, mt_rand(10000,32766), 0, "")); + } } else { - define('RAND_NUMBER', GEN_RANDOM_CODE(10, mt_rand(10000,32766), 0, "")); + // Generate weak (!!!) code + define('RAND_NUMBER', mt_rand(1000000, 9999999)); } } else { + // Add language system + LOAD_INC_ONCE("inc/language.php"); + // Wrong database? - ADD_FATAL(WRONG_DB_SELECTED); + addFatalMessage(getMessage('WRONG_DB_SELECTED')); } } else { + // Add language system + LOAD_INC_ONCE("inc/language.php"); + // No link to database! - ADD_FATAL(NO_DB_LINK); - $db = false; + addFatalMessage(getMessage('NO_DB_LINK')); } } else { + // Add language system + LOAD_INC_ONCE("inc/language.php"); + // Maybe you forgot to enter your MySQL data? - ADD_FATAL(MYSQL_DATA_MISSING); + addFatalMessage(getMessage('MYSQL_DATA_MISSING')); } } else { /////////////////////////////////////////////////// // Include neccessary functions for installation // /////////////////////////////////////////////////// - // Set CONFIG array - $_CONFIG = array( - 'code_length' => 0 - ); - // Set other missing variables - $link = false; // No database link by default + if (!isset($GLOBALS['output_mode'])) $GLOBALS['output_mode'] = "0"; // Include required files - require_once(PATH."inc/databases.php"); - require_once(PATH."inc/theme-manager.php"); + LOAD_INC_ONCE("inc/databases.php"); + LOAD_INC_ONCE("inc/session.php"); // Check if we are in installation routine - $installPhp = basename($_SERVER['PHP_SELF']); - if (($installPhp != "install.php") && ($CSS != "1") && ($CSS != -1)) { + if ((basename($_SERVER['PHP_SELF']) != "install.php") && ($GLOBALS['output_mode'] != "1") && ($GLOBALS['output_mode'] != -1)) { // Redirect to the installation system LOAD_URL("install.php"); - } + } // END - if // Double-check installation mode - if ((!defined('mxchange_installed')) || (!defined('admin_registered'))) { + if ((!isBooleanConstantAndTrue('mxchange_installed')) || (!isBooleanConstantAndTrue('admin_registered'))) { // Check for file permissions - if (!is_INCWritable("config")) { - ADD_FATAL(CONFIG_IS_WRITE_PROTECTED); - } - if (!is_INCWritable("dummy")) { - ADD_FATAL(DUMMY_IS_WRITE_PROTECTED); - } - if (!is_INCWritable(".secret/dummy")) { - ADD_FATAL(SECRET_IS_WRITE_PROTECTED); - } - } + if (!IS_INC_WRITEABLE("config")) { + addFatalMessage(getMessage('CONFIG_IS_WRITE_PROTECTED')); + } // END - if + if (!IS_INC_WRITEABLE("dummy")) { + addFatalMessage(getMessage('DUMMY_IS_WRITE_PROTECTED')); + } // END - if + if (!IS_INC_WRITEABLE(".secret/dummy")) { + addFatalMessage(getMessage('SECRET_IS_WRITE_PROTECTED')); + } // END - if + } // END - if } -// Any fatal messages? -if (!is_array($FATAL)) $FATAL = array(); -if (((sizeof($FATAL) > 0) || (!empty($FATAL[0]))) && (isBooleanConstantAndTrue('mxchange_installed')) && (!defined('mxchange_installing')) && ($CSS != "1")) -{ +if ((getTotalFatalErrors() > 0) && (isBooleanConstantAndTrue('mxchange_installed')) && (!defined('mxchange_installing')) && ($GLOBALS['output_mode'] != "1")) { // One or more fatal error(s) occur during connect... - include (PATH."inc/header.php"); - include (PATH."inc/fatal_errors.php"); - unset($FATAL); - include (PATH."inc/footer.php"); - exit; -} + LOAD_INC_ONCE("inc/header.php"); + LOAD_INC_ONCE("inc/fatal_errors.php"); + LOAD_INC_ONCE("inc/footer.php"); +} // END - if // ?>