X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmysql-connect.php;h=e01516610f9900711d3adc77b499b871496e6fdb;hb=dff82554761a7fe1a34d3ce2d4922b4b1f3cd6b9;hp=2ce61d8c16b78b208564ea3438b7f0657adebfc0;hpb=60494e212a67fe360bfbb481eb4928480a6f379b;p=mailer.git diff --git a/inc/mysql-connect.php b/inc/mysql-connect.php index 2ce61d8c16..e01516610f 100644 --- a/inc/mysql-connect.php +++ b/inc/mysql-connect.php @@ -44,63 +44,64 @@ define('DEBUG_SQL', false); // Load library require_once(PATH."inc/db/lib.php"); +// Load general functions +require_once(PATH."inc/functions.php"); // Non-database functions +require_once(PATH."inc/extensions.php"); +require_once(PATH."inc/language.php"); + // Check if the user setups his MySQL stuff... -if ((empty($MySQL['login'])) && (!mxchange_installing) && (!isset($_GET['installing'])) && (mxchange_installed)) -{ +if ((empty($MySQL['login'])) && (!isBooleanConstantAndTrue('mxchange_installing')) && (!isset($_GET['installing'])) && (isBooleanConstantAndTrue('mxchange_installed'))) { // No login entered and outside installation mode echo "".LANG_WARNING.": "; - if (mxchange_installed) - { + if (isBooleanConstantAndTrue('mxchange_installed')) { // You have changed my configuration file! die(DIE_CONFIG_CHANGED_YOU); - } - else - { + } 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)) -{ +} elseif ((!isBooleanConstantAndTrue('mxchange_installing')) && (!isset($_GET['installing'])) && (empty($MySQL['password'])) && (isBooleanConstantAndTrue('warn_no_pass'))) { // No database password entered!!! echo "".LANG_WARNING.": ".WARN_NULL_PASSWORD; } + +// Init configuration arrays +$_CONFIG = array( + 'code_length' => 0 +); + // Check if this file is writeable or read-only and warn the user -if ((!mxchange_installing) && (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") && (admin_registered)) - { + 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); } - - // 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 + // Load "databases" aka static arrays 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 + global $link; $link = 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__); // 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__); + $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 @@ -120,7 +121,7 @@ if ((!mxchange_installing) && (mxchange_installed)) require_once(PATH."inc/mysql-manager.php"); // Functions which interact with the database // 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)) { + if ((date("d", $_CONFIG['last_update']) != date("d", time()) || ((isBooleanConstantAndTrue('DEBUG_MODE')))) && (!isBooleanConstantAndTrue('mxchange_installing')) && (isBooleanConstantAndTrue('mxchange_installed')) && (isBooleanConstantAndTrue('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"; @@ -160,11 +161,8 @@ if ((!mxchange_installing) && (mxchange_installed)) // Secure and validate user ID from cookie UPDATE_LOGIN_DATA(); - // Get session ID - if (empty($_COOKIE['PHPSESSID'])) $_COOKIE['PHPSESSID'] = session_id(); - // Update online list - UPDATE_ONLINE_LIST($_COOKIE['PHPSESSID'], $GLOBALS['module'], $GLOBALS['action'], $GLOBALS['what']); + UPDATE_ONLINE_LIST(get_session('PHPSESSID'), $GLOBALS['module'], $GLOBALS['action'], $GLOBALS['what']); // Load theme name $CurrTheme = GET_CURR_THEME(); @@ -231,7 +229,6 @@ if ((!mxchange_installing) && (mxchange_installed)) // 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"); @@ -244,7 +241,7 @@ if ((!mxchange_installing) && (mxchange_installed)) } // Double-check installation mode - if ((!mxchange_installed) || (!admin_registered)) { + if ((!isBooleanConstantAndTrue('mxchange_installed')) || (!isBooleanConstantAndTrue('admin_registered'))) { // Check for file permissions if (!is_INCWritable("config")) { ADD_FATAL(CONFIG_IS_WRITE_PROTECTED); @@ -260,7 +257,7 @@ if ((!mxchange_installing) && (mxchange_installed)) // Any fatal messages? if (!is_array($FATAL)) $FATAL = array(); -if (((sizeof($FATAL) > 0) || (!empty($FATAL[0]))) && (mxchange_installed) && (!mxchange_installing) && ($CSS != "1")) +if (((sizeof($FATAL) > 0) || (!empty($FATAL[0]))) && (isBooleanConstantAndTrue('mxchange_installed')) && (!isBooleanConstantAndTrue('mxchange_installing')) && ($CSS != "1")) { // One or more fatal error(s) occur during connect... include (PATH."inc/header.php");