X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmysql-connect.php;h=326edc5cebe82223b7de24dd11af802d0b5a9d6c;hp=966f799f5691ae0f14a0d39c94345a00a6f5ca1a;hb=3af8b17c962e094e3eaffbd6d111290cdb286c92;hpb=e6c2226d9fce4452118cf6fe68bab72e6623cc2e diff --git a/inc/mysql-connect.php b/inc/mysql-connect.php index 966f799f56..326edc5ceb 100644 --- a/inc/mysql-connect.php +++ b/inc/mysql-connect.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Verbindet zu Ihrer Datenbank * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $Date:: $ * + * $Tag:: 0.2.1-FINAL $ * + * $Author:: $ * + * Needs to be in all Files and every File needs "svn propset * + * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -37,121 +42,60 @@ if (!defined('__SECURITY')) { require($INC); } -// CFG: DEBUG-SQL (if enabled and DEBUG_MODE is enabled all SQL queries will be logged to debug.log) -define('DEBUG_SQL', false); - // Non-database functions -LOAD_INC_ONCE("inc/functions.php"); - -// Filter functions -LOAD_INC_ONCE("inc/filters.php"); - -// Functions which interact with the database -LOAD_INC_ONCE("inc/mysql-manager.php"); - -// Load extensions and language -LOAD_INC_ONCE("inc/extensions.php"); +require("inc/functions.php"); -// Load database library -LOAD_INC_ONCE("inc/db/lib.php"); - -// Error handler function -function __errorHandler ($errno, $errstr, $errfile, $errline) { - // Construct message - $msg = sprintf("errno=%s,errstr=%s,errfile=%s,errline=%s", - $errno, - $errstr, - basename($errfile), - $errline - ); - - // Write debug log message - DEBUG_LOG(__FUNCTION__, __LINE__, "".$msg, true); - - // Output message to user and die - if (EXT_IS_ACTIVE("debug")) { - // Debug extension found! So Output a small message - mxchange_die("Error message written to debug.log. Please try to call the main page to continue."); - } else { - // No debug extension found, so regular output - debug_report_bug(); - } -} +// Load more function libraries or includes +foreach (array('request-functions', 'session-functions', 'config-functions', 'code-functions', 'inc-functions', 'filters', 'mysql-manager', 'extensions', 'db/lib', 'handler', 'hooks') as $lib) { + // Load special functions + LOAD_INC_ONCE(sprintf("inc/%s.php", $lib)); +} // END - foreach // Set error handler set_error_handler('__errorHandler'); -// Call-back function for running shutdown functions and close database connection -function __SHUTDOWN_HOOK () { - global $link; - - // Call the filter chain 'shutdown' - RUN_FILTER('shutdown', null, false); - - if (is_resource($link)) { - // Close link - SQL_CLOSE($link, __FILE__, __LINE__); - } else { - // No database link - addFatalMessage(getMessage('NO_DB_LINK')); - } -} - -// 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'])) && (!isInstalling()) && (!REQUEST_ISSET_GET('installing')) && (isInstalled())) { // No login entered and outside installation mode OUTPUT_HTML("{--LANG_WARNING--}: "); - if (isBooleanConstantAndTrue('mxchange_installed')) { + if (isInstalled()) { // You have changed my configuration file! - mxchange_die("{--DIE_CONFIG_CHANGED_YOU--}"); + app_die(__FILE__, __LINE__, "{--DIE_CONFIG_CHANGED_YOU--}"); } else { // Please run the installation script (maybe again) - mxchange_die("{--DIE_RUN_INSTALL_MYSQL--}"); + app_die(__FILE__, __LINE__, "{--DIE_RUN_INSTALL_MYSQL--}"); } -} elseif ((!isBooleanConstantAndTrue('mxchange_installing')) && (!isset($_GET['installing'])) && (empty($MySQL['password'])) && (isBooleanConstantAndTrue('warn_no_pass'))) { +} elseif ((!isInstalling()) && (empty($MySQL['password'])) && (isBooleanConstantAndTrue('warn_no_pass'))) { // No database password entered!!! OUTPUT_HTML("
{--LANG_WARNING--}:
{--WARN_NULL_PASSWORD--}"); } -// Set dummy $_CONFIG array -$_CONFIG = array( - 'code_length' => 0, - 'patch_level' => 0, - 'last_update' => time() -); +// Set dummy config array +initConfig(); -// Init important $header variable -global $header; -$header = 0; +// Set important header_sent +$GLOBALS['header_sent'] = 0; // Init fatal messages -global $FATAL; -$FATAL = array(); +initFatalMessages(); // Check if this file is writeable or read-only and warn the user -if ((!isBooleanConstantAndTrue('mxchange_installing')) && (isBooleanConstantAndTrue('mxchange_installed'))) { +if ((!isInstalling()) && (isInstalled())) { // Check for write-permission for config.php and inc directory + if (empty($GLOBALS['module'])) $GLOBALS['module'] = REQUEST_GET('module'); if (empty($GLOBALS['module'])) $GLOBALS['module'] = "index"; // CSS array - $EXT_CSS_FILES = 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) { + if (SQL_SELECT_DB($MySQL['dbase'], __FILE__, __LINE__) === true) { // This is required for extension 'optimize' to work define('__DB_NAME', $MySQL['dbase']); @@ -159,17 +103,20 @@ if ((!isBooleanConstantAndTrue('mxchange_installing')) && (isBooleanConstantAndT unset($MySQL); // Load configuration stuff - mergeConfig(LOAD_CONFIG()); + loadConfiguration(); // Load "databases" aka static arrays LOAD_INC_ONCE("inc/databases.php"); + // Init session + LOAD_INC_ONCE("inc/session.php"); + + // Load versions + LOAD_INC_ONCE("inc/versions.php"); + // Loading patching system is required here... LOAD_INC_ONCE("inc/patch-system.php"); // Initialize patch system - // Session management - LOAD_INC_ONCE("inc/session.php"); - // Run daily reset LOAD_INC_ONCE("inc/check-reset.php"); @@ -182,7 +129,7 @@ if ((!isBooleanConstantAndTrue('mxchange_installing')) && (isBooleanConstantAndT //* 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']); @@ -193,11 +140,11 @@ if ((!isBooleanConstantAndTrue('mxchange_installing')) && (isBooleanConstantAndT } // Run the init filter chain - RUN_FILTER('init'); + runFilterChain('init'); // Set default 'what' value //* DEBUG: */ OUTPUT_HTML("-".$GLOBALS['module']."/".$GLOBALS['what']."-
"); - if ((empty($GLOBALS['what'])) && (empty($GLOBALS['action'])) && ($CSS != 1) && ($CSS != -1)) { + 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']); @@ -212,13 +159,11 @@ if ((!isBooleanConstantAndTrue('mxchange_installing')) && (isBooleanConstantAndT } // END - if // Update sending pool - if (($CSS != "1") && ($CSS != "-1")) LOAD_INC_ONCE("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 - $dummy = CHECK_MODULE($GLOBALS['module']); - if ($dummy == "done") COUNT_MODULE($GLOBALS['module']); - unset($dummy); + if (checkModulePermissions($GLOBALS['module']) == "done") countModuleHit($GLOBALS['module']); // Shall we activate the exchange? if (getConfig('activate_xchange') > 0) activateExchange(); @@ -226,36 +171,22 @@ if ((!isBooleanConstantAndTrue('mxchange_installing')) && (isBooleanConstantAndT // 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, "")); - } + define('RAND_NUMBER', generateRandomCodde(10, mt_rand(10000,32766), getUserId(), "")); } else { // Generate weak (!!!) code define('RAND_NUMBER', mt_rand(1000000, 9999999)); } } else { - // Add language system - LOAD_INC_ONCE("inc/language.php"); - // Wrong database? - addFatalMessage(getMessage('WRONG_DB_SELECTED')); + addFatalMessage(__FILE__, __LINE__, getMessage('WRONG_DB_SELECTED')); } } else { - // Add language system - LOAD_INC_ONCE("inc/language.php"); - // No link to database! - addFatalMessage(getMessage('NO_DB_LINK')); - $db = false; + addFatalMessage(__FILE__, __LINE__, getMessage('NO_DB_LINK')); } } else { - // Add language system - LOAD_INC_ONCE("inc/language.php"); - // Maybe you forgot to enter your MySQL data? - addFatalMessage(getMessage('MYSQL_DATA_MISSING')); + addFatalMessage(__FILE__, __LINE__, getMessage('MYSQL_DATA_MISSING')); } } else { /////////////////////////////////////////////////// @@ -263,35 +194,45 @@ if ((!isBooleanConstantAndTrue('mxchange_installing')) && (isBooleanConstantAndT /////////////////////////////////////////////////// // Set other missing variables - if (!isset($CSS)) $CSS = "0"; - $link = false; // No database link by default + if (!isset($GLOBALS['output_mode'])) $GLOBALS['output_mode'] = "0"; - // Include required files + // Include databases.php LOAD_INC_ONCE("inc/databases.php"); + + // Init session LOAD_INC_ONCE("inc/session.php"); + // Load versions + LOAD_INC_ONCE("inc/versions.php"); + // Check if we are in installation routine - if ((basename($_SERVER['PHP_SELF']) != "install.php") && ($CSS != "1") && ($CSS != -1)) { + if ((!isInstalling()) && ($GLOBALS['output_mode'] != "1") && ($GLOBALS['output_mode'] != -1)) { // Redirect to the installation system LOAD_URL("install.php"); } // END - if // Double-check installation mode - if ((!isBooleanConstantAndTrue('mxchange_installed')) || (!isBooleanConstantAndTrue('admin_registered'))) { + if ((!isInstalled()) || (!isAdminRegistered())) { // Check for file permissions if (!IS_INC_WRITEABLE("config")) { - addFatalMessage(getMessage('CONFIG_IS_WRITE_PROTECTED')); + addFatalMessage(__FILE__, __LINE__, getMessage('CONFIG_IS_WRITE_PROTECTED')); } // END - if if (!IS_INC_WRITEABLE("dummy")) { - addFatalMessage(getMessage('DUMMY_IS_WRITE_PROTECTED')); + addFatalMessage(__FILE__, __LINE__, getMessage('DUMMY_IS_WRITE_PROTECTED')); } // END - if if (!IS_INC_WRITEABLE(".secret/dummy")) { - addFatalMessage(getMessage('SECRET_IS_WRITE_PROTECTED')); + addFatalMessage(__FILE__, __LINE__, getMessage('SECRET_IS_WRITE_PROTECTED')); } // END - if } // END - if + + // Run the init filter chain + runFilterChain('init'); + + // Load extension 'sql_patches' + LOAD_EXTENSION("sql_patches"); } -if ((getTotalFatalErrors() > 0) && (isBooleanConstantAndTrue('mxchange_installed')) && (!defined('mxchange_installing')) && ($CSS != "1")) { +if ((getTotalFatalErrors() > 0) && (isInstalled()) && (!isInstalling()) && ($GLOBALS['output_mode'] != "1")) { // One or more fatal error(s) occur during connect... LOAD_INC_ONCE("inc/header.php"); LOAD_INC_ONCE("inc/fatal_errors.php");