X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmysql-connect.php;h=bd91776d29aeff97a51e04932384e6dc5c7c8c9e;hb=60403e95910ee466e0ef685b068facb88237721f;hp=2ce61d8c16b78b208564ea3438b7f0657adebfc0;hpb=60494e212a67fe360bfbb481eb4928480a6f379b;p=mailer.git diff --git a/inc/mysql-connect.php b/inc/mysql-connect.php index 2ce61d8c16..bd91776d29 100644 --- a/inc/mysql-connect.php +++ b/inc/mysql-connect.php @@ -1,7 +1,7 @@ ".LANG_WARNING.": "; - if (mxchange_installed) - { - // You have changed my configuration file! - die(DIE_CONFIG_CHANGED_YOU); - } - else - { - // Please run the installation script (maybe again) - die(DIE_RUN_INSTALL_MYSQL); - } -} - elseif ((!mxchange_installing) && (!isset($_GET['installing'])) && (empty($MySQL['password'])) && (warn_no_pass)) -{ - // No database password entered!!! - echo "".LANG_WARNING.": ".WARN_NULL_PASSWORD; -} - -// Check if this file is writeable or read-only and warn the user -if ((!mxchange_installing) && (mxchange_installed)) -{ - // Check for write-permission for config.php and inc directory - if (empty($GLOBALS['module'])) $GLOBALS['module'] = "index"; - if (($GLOBALS['module'] != "admin") && (admin_registered)) - { - if (is_INCWritable("config")) ADD_FATAL(FATAL_CONFIG_WRITABLE); - if (is_INCWritable("dummy")) ADD_FATAL(FATAL_INC_WRITABLE); - } - - // Init configuration arrays - $_CONFIG = array( - 'code_length' => 0 - ); - $EXT_CSS_FILES = array(); - - // Load general stuff, like... - require_once(PATH."inc/extensions.php"); // Extension management - require_once(PATH."inc/functions.php"); // Non-database functions - require_once(PATH."inc/databases.php"); // Several hard-coded databases (arrays, constants) - - if ((!empty($MySQL['host'])) && (!empty($MySQL['login'])) && (!empty($MySQL['password'])) && (!empty($MySQL['dbase']))) { - // Connect to DB - $link = SQL_CONNECT($MySQL['host'], $MySQL['login'], $MySQL['password'], __FILE__, __LINE__); - - // Is the link valid? - if (is_resource($link)) { - // Choose the database - $db = SQL_SELECT_DB($MySQL['dbase'], $link, __FILE__, __LINE__); - - // Is it a valid resource? - if ($db === true) { - // Load configuration stuff - $result = SQL_QUERY("SELECT pass_len, points_register, points_ref, least_cats, check_double_email, check_double_pass, admin_notify, url_tlock, test_text, max_tlength, test_subj, autosend_active, max_send, url_blacklist, auto_purge, auto_purge_active, last_update, unconfirmed, profile_lock, online_timeout, mad_timestamp, mad_count, profile_update, send_prof_update, resend_profile_update, code_length, patch_level, patch_ctime, guest_stats, ref_payout, activate_xchange, order_multi_page, display_refid, ip_timeout, allow_direct_pay, config FROM "._MYSQL_PREFIX."_config WHERE config='0' LIMIT 1", __FILE__, __LINE__); - - if (SQL_NUMROWS($result) == 1) { - // Load data when previous SQL query did not fail - if (!$result) { - // Something went wrong - ADD_FATAL(FATAL_CANNOT_LOAD_CONFIG); - return; - } - - // Load the configuration - $_CONFIG = array_merge($_CONFIG, SQL_FETCHARRAY($result)); - - // Initialize include-file-pool - $INC_POOL = array(); - - // Load more include files - require_once(PATH."inc/mysql-manager.php"); // Functions which interact with the database +if (!defined('__SECURITY')) { + die(); +} // END - if - // Run daily reset - if ((date("d", $_CONFIG['last_update']) != date("d", time()) || (DEBUG_MODE == true)) && (!mxchange_installing) && (mxchange_installed) && (admin_registered) && (!isset($_GET['register'])) && ($CSS != 1)) { - // Do daily things in external PHP file but only when script is completely setup - $INC_POOL[] = PATH."inc/reset/reset_daily.php"; +// Load more function libraries or includes +foreach (array('request-functions', 'session-functions', 'code-functions', 'language-functions', 'sql-functions', 'expression-functions', 'filter-functions','revision-functions', 'filters', 'mysql-manager', 'extensions-functions', 'handler') as $lib) { + // Load special functions + loadIncludeOnce('inc/' . $lib . '.php'); +} // END - foreach - // Daily reset was run! - define('__DAILY_RESET', "1"); - } +// Set error handler +set_error_handler('__errorHandler'); - // Load all extensions - require_once(PATH."inc/load_extensions.php"); +// Disable block-mode by default +enableBlockMode(false); - // Loading patching system is required here... - require_once(PATH."inc/patch-system.php"); // Initialize patch system +// Init error handler +initErrorHandler(); - // Functions which are related to themes - require_once(PATH."inc/theme-manager.php"); +// Init request +initRequest(); - // Initialize session management - require_once(PATH."inc/session.php"); +// Init userid +initMemberId(); - // Load admin include file if he is admin - if (IS_ADMIN()) { - // Administrative functions - require_once(PATH."inc/modules/admin/admin-inc.php"); - } +// Set important header_sent +if (!isset($GLOBALS['header_sent'])) $GLOBALS['header_sent'] = '0'; - // Get all values - if (($CSS != 1) && ($CSS != -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']); - } else { - // Set action/what to empty - $GLOBALS['action'] = ""; - $GLOBALS['what'] = ""; - } +// Init fatal messages +initFatalMessages(); - // Secure and validate user ID from cookie - UPDATE_LOGIN_DATA(); +// Init message system +initMessages(); - // Get session ID - if (empty($_COOKIE['PHPSESSID'])) $_COOKIE['PHPSESSID'] = session_id(); +// Are we in installation phase? +if ((!isInstalling()) && (!isInstallationPhase())) { + // Load configuration file(s) here + loadIncludeOnce('inc/load_config.php'); - // Update online list - UPDATE_ONLINE_LIST($_COOKIE['PHPSESSID'], $GLOBALS['module'], $GLOBALS['action'], $GLOBALS['what']); + // Load database layer here + loadIncludeOnce('inc/db/lib.php'); - // Load theme name - $CurrTheme = GET_CURR_THEME(); + // CSS array + initExtensionCssFiles(); - // Set default 'what' value - //* DEBUG */ echo "-".$GLOBALS['module']."/".$GLOBALS['what']."-
\n"; - if ((empty($GLOBALS['what'])) && (empty($GLOBALS['action'])) && ($CSS != 1) && ($CSS != -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']; - } else { - // Anything else like begging link - $GLOBALS['what'] = ""; - } - } + if ((!empty($GLOBALS['mysql']['host'])) && (!empty($GLOBALS['mysql']['login'])) && (!empty($GLOBALS['mysql']['password'])) && (!empty($GLOBALS['mysql']['dbase']))) { + // Connect to DB + SQL_CONNECT($GLOBALS['mysql']['host'], $GLOBALS['mysql']['login'], $GLOBALS['mysql']['password'], __FILE__, __LINE__); - // Update sending pool - if (($CSS != "1") && ($CSS != "-1")) require_once(PATH."inc/pool-update.php"); // Sends out mails in configureable steps + // Is the link valid? + if (SQL_IS_LINK_UP()) { + // Enable exit on error + enableExitOnError(); - // Load all active extension including language files when not upgrading. - // Check module for testing and count one click - $dummy = CHECK_MODULE($GLOBALS['module']); - if ($dummy == "done") COUNT_MODULE($GLOBALS['module']); - unset($dummy); - if ($_CONFIG['activate_xchange'] > 0) activateExchange(); - } else { - // If you will read following error message you probably need to contact me (webmaster@mxchange.org) - // and download the sql-upgrades extension from my server. Please ask me which SQL file(s) you need to - // import *BEFORE* you import them! - ADD_FATAL(FATAL_CANNOT_LOAD_CONFIG); + // Is it a valid resource? + if (SQL_SELECT_DB($GLOBALS['mysql']['dbase'], __FILE__, __LINE__) === true) { + // This is required for extension 'optimize' to work + setConfigEntry('__DB_NAME', $GLOBALS['mysql']['dbase']); + + // Remove MySQL array from namespace + unset($GLOBALS['mysql']); + + // Load cache + loadIncludeOnce('inc/load_cache.php'); + + // Check module for permissions + $checkModule = checkModulePermissions(); + + // Admin module should be accessable by guests to login + if ((getModule() == 'admin') && ($checkModule == 'admin_only')) { + // This is fine and can be ignored + } elseif ($checkModule != 'done') { + // Not fine! + logDebugMessage(__FILE__, __LINE__, sprintf("Check of module %s results in unexpected value: %s", + getModule(), + $checkModule + )); } - - // Free memory - SQL_FREERESULT($result); } else { // Wrong database? - ADD_FATAL(WRONG_DB_SELECTED); + addFatalMessage(__FILE__, __LINE__, getMessage('WRONG_DB_SELECTED')); } } else { // No link to database! - ADD_FATAL(NO_DB_LINK); - $db = false; + addFatalMessage(__FILE__, __LINE__, getMessage('NO_DB_LINK')); } } else { // Maybe you forgot to enter your MySQL data? - ADD_FATAL(MYSQL_DATA_MISSING); + addFatalMessage(__FILE__, __LINE__, getMessage('MYSQL_DATA_MISSING')); } } else { /////////////////////////////////////////////////// // Include neccessary functions for installation // /////////////////////////////////////////////////// - // Set CONFIG array - $_CONFIG = array( - 'code_length' => 0 - ); + // Default output is 'direct' for HTML output + setConfigEntry('OUTPUT_MODE', 'direct'); - // Set other missing variables - $link = false; // No database link by default + // This hack prevents a backtrace in CSS output + if (getOutputMode() == 1) { + // Problem with config so set output mode + setConfigEntry('OUTPUT_MODE', 'render'); + } // END - if - // Include required files - require_once(PATH."inc/databases.php"); - require_once(PATH."inc/extensions.php"); - require_once(PATH."inc/theme-manager.php"); - require_once(PATH."inc/load_extensions.php"); - require_once(PATH."inc/session.php"); + // CFG: DATABASE-TYPE + setConfigEntry('_DB_TYPE', 'mysql3'); - // Check if we are in installation routine - $installPhp = basename($_SERVER['PHP_SELF']); - if (($installPhp != "install.php") && ($CSS != "1") && ($CSS != -1)) { - // Redirect to the installation system - LOAD_URL("install.php"); - } + // Include more + foreach (array('inc/db/lib.php','inc/databases.php','inc/session.php','inc/versions.php','inc/install-functions.php','inc/load_config.php') as $inc) { + // Load the include + loadIncludeOnce($inc); + } // END - foreach - // Double-check installation mode - if ((!mxchange_installed) || (!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); - } - } -} + // Init filter system here + initFilterSystem(); + + // Are we installation routine? + if ((!isInstalling()) && (getOutputMode() != 1) && (getOutputMode() != -1)) { + // You have to install first! + redirectToUrl('install.php'); + } // END - if -// Any fatal messages? -if (!is_array($FATAL)) $FATAL = array(); -if (((sizeof($FATAL) > 0) || (!empty($FATAL[0]))) && (mxchange_installed) && (!mxchange_installing) && ($CSS != "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 cache + loadIncludeOnce('inc/load_cache.php'); + + // Run the init filter chain + runFilterChain('init'); } -// +// Handle fatal errors +runFilterChain('handle_fatal_errors'); + +// [EOF] ?>