Value not found!'; $txt['default_value'] = 'Recommended value'; $txt['other_possible_value'] = 'Other possible value'; $txt['no_default_value'] = 'No recommended value'; $txt['save_settings'] = 'Save Settings'; $txt['remove_file'] = 'Remove this file. Careful, it may not work in all servers!'; $txt['restore_all_settings'] = 'Apply all recommendations'; $txt['not_writable'] = 'Settings.php cannot be written to by your webserver. Please modify the permissions on this file to allow write access.'; $txt['recommend_blank'] = '(blank)'; $txt['database_settings_hidden'] = 'Some settings are not being shown because the database connection information is incorrect.
Check your database login details, table prefix and that the database actually contains your SMF tables.'; $txt['no_sources'] = 'We were unable to detect your Sources folder. This is crucial for this tool to work. Please be sure it exists.'; $txt['settings_saved'] = 'Your settings were saved. Please confirm all the paths and URLs below, and that your forum works.
Make sure you remove this file!'; $txt['remove_hooks'] = 'Remove all hooks'; $txt['disable_hooks'] = 'Disable all hooks'; $txt['hooks_removed'] = 'All your existing hooks were removed from the database. Do note that existing MODs that rely on hooks will not work anymore.
Make sure you remove this file!'; $txt['hooks_disabled'] = 'All your existing hooks were disabled. Do note that existing MODs that rely on hooks will not work anymore. You can enable these again from Forum Maintenance
Make sure you remove this file!'; $txt['critical_settings'] = 'Critical Settings'; $txt['critical_settings_info'] = 'These are the settings most likely to be screwing up your board, but try the things below (especially the path and URL ones) if these don\'t help. You can click on the recommended value to use it.'; $txt['maintenance'] = 'Maintenance Mode'; $txt['maintenance0'] = 'Off (recommended)'; $txt['maintenance1'] = 'Enabled'; $txt['maintenance2'] = 'Unusable (not recommended!)'; $txt['language'] = 'Language File'; $txt['cookiename'] = 'Cookie Name'; $txt['queryless_urls'] = 'Queryless URLs'; $txt['queryless_urls0'] = 'Off (recommended)'; $txt['queryless_urls1'] = 'On'; $txt['enableCompressedOutput'] = 'Output Compression'; $txt['enableCompressedOutput0'] = 'Off (recommended if you have problems)'; $txt['enableCompressedOutput1'] = 'On (saves a lot of bandwidth)'; $txt['databaseSession_enable'] = 'Database driven sessions'; $txt['databaseSession_enable0'] = 'Off (not recommended)'; $txt['databaseSession_enable1'] = 'On (recommended)'; $txt['theme_default'] = 'Set SMF Default theme as overall forum default
for all users'; $txt['theme_default0'] = 'No (keep the current users\' theme settings)'; $txt['theme_default1'] = 'Yes (recommended if you have problems)'; $txt['database_settings'] = 'Database Info'; $txt['database_settings_info'] = 'This is the server, username, password, and database for your server.'; $txt['db_type'] = 'Database Engine'; $txt['db_server'] = 'Server'; $txt['db_name'] = 'Database name'; $txt['db_user'] = 'Username'; $txt['db_passwd'] = 'Password'; $txt['ssi_db_user'] = 'SSI Username'; $txt['ssi_db_passwd'] = 'SSI Password'; $txt['ssi_db_user_desc'] = '(Optional)'; $txt['ssi_db_passwd_desc'] = '(Optional)'; $txt['db_prefix'] = 'Table prefix'; $txt['db_persist'] = 'Connection type'; $txt['db_persist0'] = 'Standard (recommended)'; $txt['db_persist1'] = 'Persistent (might cause problems)'; $txt['db_mysql'] = 'MySQL'; $txt['db_postgresql'] = 'PostgreSQL'; $txt['db_sqlite'] = 'SQLite'; $txt['cache_settings'] = 'Cache Settings'; $txt['cache_settings_info'] = 'These are the cache settings to your SMF installation, and can cause big problems when they are wrong.'; $txt['cache_accelerator'] = 'Cache System'; $txt['cache_accelerator_help'] = 'Choose: apc, eaccelerator, memcache, mmcache, output_cache, smf, or xcache'; $txt['cache_enable'] = 'Enable Caching'; $txt['cache_enable0'] = 'Off'; $txt['cache_enable1'] = 'On (recommended)'; $txt['cachedir'] = 'Cache Directory'; $txt['cache_memcached'] = 'Memcache Servers'; $txt['path_url_settings'] = 'Paths & URLs'; $txt['path_url_settings_info'] = 'These are the paths and URLs to your SMF installation, and can cause big problems when they are wrong. Sorry, there are a lot of them.'; $txt['boardurl'] = 'Forum URL'; $txt['boarddir'] = 'Forum Directory'; $txt['sourcedir'] = 'Sources Directory'; $txt['tasksdir'] = 'Tasks Directory'; $txt['packagesdir'] = 'Packages Directory'; $txt['export_dir'] = 'Exports Directory'; $txt['attachment_basedirectories'] = 'Attachment Basedirectory'; $txt['attachmentUploadDir'] = 'Attachment Directory'; $txt['avatar_url'] = 'Avatar URL'; $txt['avatar_directory'] = 'Avatar Directory'; $txt['custom_avatar_url'] = 'Custom Avatar URL'; $txt['custom_avatar_dir'] = 'Custom Avatar Directory'; $txt['smileys_url'] = 'Smileys URL'; $txt['smileys_dir'] = 'Smileys Directory'; $txt['theme_url'] = 'Default Theme URL'; $txt['images_url'] = 'Default Theme Images URL'; $txt['theme_dir'] = 'Default Theme Directory'; $txt['theme_path_url_settings'] = 'Paths & URLs For Themes'; $txt['theme_path_url_settings_info'] = 'These are the paths and URLs to your SMF themes.'; // Fix Database title to use $db_type if available if (!empty($db_type) && isset($txt['db_' . $db_type])) $txt['database_settings'] = $txt['db_' . $db_type] . ' ' . $txt['database_settings']; if (isset($_POST['submit'])) set_settings(); if (isset($_POST['remove_hooks'])) remove_hooks(); // try to find the smflogo: could be a .gif or a .png or an .svg if (file_exists(dirname(__FILE__) . "/Themes/default/images/smflogo.svg")) $smflogo = "Themes/default/images/smflogo.svg"; elseif (file_exists(dirname(__FILE__) . "/Themes/default/images/smflogo.png")) $smflogo = "Themes/default/images/smflogo.png"; else $smflogo = "Themes/default/images/smflogo.gif"; // Note that we're using the default URLs because we aren't even going to try to use Settings.php's settings. echo ' ', isset($context['smfVersion']) ? sprintf($txt['smf_repair_settings'], $context['smfVersion']) : $txt['smf11_repair_settings'], '
'; show_settings(); echo '
'; function initialize_inputs() { global $smcFunc, $db_connection, $sourcedir, $db_server, $db_name, $db_user, $db_passwd, $db_prefix, $db_type, $context, $sources_exist, $sources_found_path, $db_type_options; // Turn off magic quotes runtime and enable error reporting. if (function_exists('set_magic_quotes_runtime') && strnatcmp(phpversion(), '5.3.0') < 0) @set_magic_quotes_runtime(0); error_reporting(E_ALL); if (ini_get('session.save_handler') == 'user') ini_set('session.save_handler', 'files'); @session_start(); if (function_exists('get_magic_quotes_gpc') && @get_magic_quotes_gpc() != 0) { foreach ($_POST as $k => $v) if (is_array($v)) foreach ($v as $k2 => $v2) $_POST[$k][$k2] = stripslashes($v2); else $_POST[$k] = stripslashes($v); } foreach ($_POST as $k => $v) { if (is_array($v)) foreach ($v as $k2 => $v2) $_POST[$k][$k2] = addcslashes($v2, '\'\\'); else $_POST[$k] = addcslashes($v, '\'\\'); } // Https? $context['schema'] = isset($_SERVER['HTTPS']) || (isset($_SERVER['REQUEST_SCHEME']) && strtolower($_SERVER['REQUEST_SCHEME']) == 'https') ? 'https' : 'http'; // This is really quite simple; if ?delete is on the URL, delete the installer... if (isset($_GET['delete']) || isset($_POST['remove_file'])) { @unlink(__FILE__); // Now just redirect to a blank.gif... header('Location: ' . $context['schema'] . '://' . (isset($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : $_SERVER['SERVER_NAME'] . ':' . $_SERVER['SERVER_PORT']) . dirname($_SERVER['PHP_SELF']) . '/index.php'); exit; } $db_connection = false; $sources_exist = false; $context['smfVersion'] = 'N/A'; $sources_found_path = ''; if (isset($sourcedir) && (file_exists(dirname(__FILE__) . '/Sources/Load.php'))) $sources_exist = true; else { //Find Sources folder! $sourcedir = findSources(); $sources_found_path = $sourcedir; $sources_exist = !empty($sourcedir); } if ($sources_exist) { if (!defined('SMF')) define('SMF', 1); if (!defined('POSTGRE_TITLE')) define('POSTGRE_TITLE', 'PostgreSQL'); if (!defined('MYSQL_TITLE')) define('MYSQL_TITLE', 'MySQL'); if (!defined('TIME_START')) define('TIME_START', microtime(true)); if (empty($smcFunc)) $smcFunc = array(); // Default the database type to MySQLi. In 2.1 Beta 3, mysql was removed, this will put it back to mysqli. $db_type_options = array('default' => 'mysql', 'options' => array('mysql' => 'MySQL')); if (empty($db_type) || !file_exists($sourcedir . '/Subs-Db-' . $db_type . '.php')) $db_type = 'mysql'; //require_once($sourcedir . '/Load.php'); //require_once($sourcedir . '/Subs-Auth.php'); // compat mode. Active! $context['is_legacy'] = true; // Try to detect if we even have the database functions.. if ( ($db_type == 'mysql' && !function_exists('mysql_connect') && !function_exists('mysqli_connect')) || ($db_type == 'mysqli' && !function_exists('mysqli_connect')) || ($db_type == 'postgresql' && !function_exists('pg_pconnect')) ) $db_connection = null; // This is SMF 1.x as far as we can tell, as we don't know/have any database files. elseif (!file_exists($sourcedir . '/Subs-Db-' . $db_type . '.php') && $db_type == 'mysql') { $context['smfVersion'] = '1.1'; $db_connection = smc_compat_initiate($db_server, $db_name, $db_user, $db_passwd, $db_prefix, array('non_fatal' => true)); } else { // Far as I know, this is 2.0. $context['is_legacy'] = false; $context['smfVersion'] = '2.0'; // Try to see if this is 2.1. Maybe include more checks. if (file_exists($sourcedir . '/Class-TOTP.php')) $context['smfVersion'] = '2.1'; // We should try to use the proper extension function if at all possible. require_once($sourcedir . '/Subs-Db-' . $db_type . '.php'); if (function_exists('db_extend')) db_extend('extra'); else require_once($sourcedir . '/DbExtra-' . $db_type . '.php'); $db_connection = smf_db_initiate($db_server, $db_name, $db_user, $db_passwd, $db_prefix, array('non_fatal' => true)); db_extra_init(); //Fixes error with $db_connection not false if database name is incorrect. This is because the connection is established //without this parameter, thus performing incorrectly. if ($db_connection == true) { if (!$smcFunc['db_select_db'] ($db_name, $db_connection)) $db_connection = null; else { $tables = $smcFunc['db_list_tables']($db_name); if (!(is_array($tables) && in_array($db_prefix . 'settings', $tables))) $db_connection = null; } } else $db_connection = null; } // See if we have PostgreSQL files, we should. if (file_exists($sourcedir . '/Subs-Db-postgresql.php')) { $db_type_options['options']['postgresql'] = 'PostgreSQL'; // If we are currently postgresql, it should be the default. if ($db_type == 'postgresql') $db_type_options['default'] = $db_type; } // 2.1 Beta 1 and 2 supported mysqli, this was removed and merged into mysql in Beta 3. if (file_exists($sourcedir . '/Subs-Db-mysqli.php')) { $db_type_options['options']['mysqli'] = 'MySQLi'; // Suggest that we move back to mysql. if ($db_type == 'mysqli') $db_type_options['default'] = 'mysql'; } // 2.0 supports sqlite. if (file_exists($sourcedir . '/Subs-Db-sqlite.php') && (empty($context['smfVersion']) || $context['smfVersion'] == '2.0')) { $db_type_options['options']['sqlite'] = 'SQLite'; if ($db_type == 'sqlite') $db_type_options['default'] = $db_type; } } } function show_settings() { global $txt, $smcFunc, $db_connection, $db_type, $db_name, $db_prefix, $context, $sources_exist, $sources_found_path, $db_type_options; // Check to make sure Settings.php exists! if (file_exists(dirname(__FILE__) . '/Settings.php')) $settingsArray = file(dirname(__FILE__) . '/Settings.php'); else $settingsArray = array(); if (count($settingsArray) == 1) $settingsArray = preg_split('~[\r\n]~', $settingsArray[0]); $settings = array(); for ($i = 0, $n = count($settingsArray); $i < $n; $i++) { $settingsArray[$i] = rtrim(stripslashes($settingsArray[$i])); if (isset($settingsArray[$i][0]) && $settingsArray[$i][0] != '.') { preg_match('~^[$]([a-zA-Z_]+)\s*=\s*(?:(["\'])(?:(.*?)["\'])(?:\\2)?|(.*?)(?:\\2)?);~', $settingsArray[$i], $match); if (isset($match[3])) { if ($match[3] == 'dirname(__FILE__)') $settings[$match[1]] = dirname(__FILE__); elseif ($match[3] == 'dirname(__FILE__) . \'/Sources\'') $settings[$match[1]] = dirname(__FILE__) . '/Sources'; elseif ($match[3] == '$boarddir . \'/Sources\'') $settings[$match[1]] = $settings['boarddir'] . '/Sources'; elseif ($match[3] == 'dirname(__FILE__) . \'/cache\'') $settings[$match[1]] = dirname(__FILE__) . '/cache'; // Values of 1, true and false seem to create a $mach[4]. This gets around this until a better regex can be found. elseif (isset($match[4]) && in_array($match[4], array('0', '1', '2', 'false', 'true'))) $settings[$match[1]] = $match[4]; else $settings[$match[1]] = $match[3]; } } } if ($db_connection == true) { $request = $smcFunc['db_query'](true, ' SELECT DISTINCT variable, value FROM {db_prefix}settings', array( 'db_error_skip' => true ), $db_connection ); while ($row = $smcFunc['db_fetch_assoc']($request)) { // Skip this setting on 2.1. if ($context['smfVersion'] == '2.1' && $row['variable'] == 'cache_enable') continue; $settings[$row['variable']] = $row['value']; } $smcFunc['db_free_result']($request); // Load all the themes. $request = $smcFunc['db_query'](true, ' SELECT variable, value, id_theme FROM {db_prefix}themes WHERE id_member = 0 AND variable IN ({array_string:variables})', array( 'variables' => array('theme_dir', 'theme_url', 'images_url', 'name'), 'db_error_skip' => true ) ); $theme_settings = array(); while ($row = $smcFunc['db_fetch_row']($request)) $theme_settings[$row[2]][$row[0]] = $row[1]; $smcFunc['db_free_result']($request); $show_db_settings = $request; } else $show_db_settings = false; $known_settings = array( 'critical_settings' => array( 'maintenance' => array('flat', 'int', 2), 'language' => array('flat', 'string', 'english'), 'cookiename' => array('flat', 'string', 'SMFCookie' . (!empty($db_name) ? abs(crc32($db_name . preg_replace('~[^A-Za-z0-9_$]~', '', $db_prefix)) % 1000) : '20')), 'queryless_urls' => array('db', 'int', 1), 'enableCompressedOutput' => array('db', 'int', 1), 'databaseSession_enable' => array('db', 'int', 1), 'theme_default' => array('db', 'int', 1), ), 'database_settings' => array( 'db_type' => array('flat', 'select', $db_type_options['default'], $db_type_options['options']), 'db_server' => array('flat', 'string', 'localhost'), 'db_name' => array('flat', 'string'), 'db_user' => array($db_type == 'sqlite' ? 'hidden' : 'flat', 'string'), 'db_passwd' => array($db_type == 'sqlite' ? 'hidden' : 'flat', 'string'), 'ssi_db_user' => array($db_type == 'sqlite' ? 'hidden' : 'flat', 'string'), 'ssi_db_passwd' => array($db_type == 'sqlite' ? 'hidden' : 'flat', 'string'), 'db_prefix' => array('flat', 'string'), 'db_persist' => array('flat', 'int', 1), ), 'path_url_settings' => array( 'boardurl' => array('flat', 'string'), 'boarddir' => array('flat', 'string'), 'sourcedir' => array('flat', 'string'), 'tasksdir' => array('flat', 'string'), 'packagesdir' => array('flat', 'string'), 'export_dir' => array('db', 'string'), 'attachment_basedirectories' => array('db', 'array_string'), 'attachmentUploadDir' => array('db', 'array_string'), 'avatar_url' => array('db', 'string'), 'avatar_directory' => array('db', 'string'), 'custom_avatar_url' => array('db', 'string'), 'custom_avatar_dir' => array('db', 'string'), 'smileys_url' => array('db', 'string'), 'smileys_dir' => array('db', 'string'), ), 'cache_settings' => array( 'cache_accelerator' => array('flat', 'string'), 'cache_enable' => array('flat', 'int', 1), 'cachedir' => array('flat', 'string'), 'cache_memcached' => array('flat', 'string') ), 'theme_path_url_settings' => array(), ); // These settings are optional and won't be shown if the don't exist $optional_settings = array( 'path_url_settings' => array( 'attachment_basedirectories' ) ); // 1.x didn't have ssi_x, nor cachedir if ($context['is_legacy']) unset($known_settings['database_settings']['ssi_db_user'], $known_settings['database_settings']['ssi_db_passwd'], $known_settings['cache_settings']['cachedir'], $known_settings['path_url_settings']['custom_avatar_url'], $known_settings['path_url_settings']['custom_avatar_dir']); // These settings didn't exist in 2.0 or 1.1 if ($context['smfVersion'] == '2.0' || $context['smfVersion'] == '1.1') unset($known_settings['cache_settings']['cache_accelerator'], $known_settings['cache_settings']['cache_enable'], $known_settings['cache_settings']['cache_memcached'], $known_settings['path_url_settings']['tasksdir'], $known_settings['path_url_settings']['export_dir'], $known_settings['path_url_settings']['packagesdir'], $known_settings['path_url_settings']['attachment_basedirectories']); // Let's assume we don't want to change the current theme $settings['theme_default'] = 0; $host = empty($_SERVER['HTTP_HOST']) ? $_SERVER['SERVER_NAME'] . (empty($_SERVER['SERVER_PORT']) || $_SERVER['SERVER_PORT'] == '80' || ($_SERVER['SERVER_PORT'] == '443' && $context['schema'] == 'https') ? '' : ':' . $_SERVER['SERVER_PORT']) : $_SERVER['HTTP_HOST']; $url = $context['schema'] . '://' . $host . substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'], '/')); $known_settings['path_url_settings']['boardurl'][2] = $url; $known_settings['path_url_settings']['boarddir'][2] = dirname(__FILE__); if (file_exists(dirname(__FILE__) . '/Sources')) $known_settings['path_url_settings']['sourcedir'][2] = realpath(dirname(__FILE__) . '/Sources'); elseif (!empty($sources_found_path)) $known_settings['path_url_settings']['sourcedir'][2] = realpath($sources_found_path); if ($context['smfVersion'] == '2.1' && file_exists(dirname(__FILE__) . '/Sources/tasks')) $known_settings['path_url_settings']['tasksdir'][2] = realpath(dirname(__FILE__) . '/Sources/tasks'); if ($context['smfVersion'] == '2.1' && file_exists(dirname(__FILE__) . '/exports')) $known_settings['path_url_settings']['export_dir'][2] = realpath(dirname(__FILE__) . '/exports'); if (file_exists(dirname(__FILE__) . '/cache') && isset($known_settings['cache_settings']['cachedir'])) $known_settings['cache_settings']['cachedir'][2] = realpath(dirname(__FILE__) . '/cache'); if (file_exists(dirname(__FILE__) . '/avatars')) { $known_settings['path_url_settings']['avatar_url'][2] = $url . '/avatars'; $known_settings['path_url_settings']['avatar_directory'][2] = realpath(dirname(__FILE__) . '/avatars'); } if (!$context['is_legacy'] && file_exists(dirname(__FILE__) . '/custom_avatar')) { $known_settings['path_url_settings']['custom_avatar_url'][2] = $url . '/custom_avatar'; $known_settings['path_url_settings']['custom_avatar_dir'][2] = realpath(dirname(__FILE__) . '/custom_avatar'); } if (file_exists(dirname(__FILE__) . '/Smileys')) { $known_settings['path_url_settings']['smileys_url'][2] = $url . '/Smileys'; $known_settings['path_url_settings']['smileys_dir'][2] = realpath(dirname(__FILE__) . '/Smileys'); } if ($context['smfVersion'] == '2.1' && file_exists(dirname(__FILE__) . '/Packages')) { $known_settings['path_url_settings']['packagesdir'][2] = realpath(dirname(__FILE__) . '/Packages'); } /* if (file_exists(dirname(__FILE__) . '/Themes/default')) { $known_settings['path_url_settings']['theme_url'][2] = $url . '/Themes/default'; $known_settings['path_url_settings']['images_url'][2] = $url . '/Themes/default/images'; $known_settings['path_url_settings']['theme_dir'][2] = realpath(dirname(__FILE__) . '/Themes/default'); } */ if (!empty($theme_settings)) { // Create the values for the themes. foreach ($theme_settings as $id => $theme) { $this_theme = ($pos = strpos($theme['theme_url'], '/Themes/')) !== false ? substr($theme['theme_url'], $pos + 8) : ''; if (!empty($this_theme)) $exist = file_exists(dirname(__FILE__) . '/Themes/' . $this_theme); else $exist = false; $known_settings['theme_path_url_settings'] += array( 'theme_' . $id . '_theme_url'=>array('theme', 'string', $exist && !empty($this_theme) ? $url . '/Themes/' . $this_theme : null), 'theme_' . $id . '_images_url'=>array('theme', 'string', $exist && !empty($this_theme) ? $url . '/Themes/' . $this_theme . '/images' : null), 'theme_' . $id . '_theme_dir' => array('theme', 'string', $exist && !empty($this_theme) ? realpath(dirname(__FILE__) . '/Themes/' . $this_theme) : null), ); $settings += array( 'theme_' . $id . '_theme_url' => $theme['theme_url'], 'theme_' . $id . '_images_url' => $theme['images_url'], 'theme_' . $id . '_theme_dir' => $theme['theme_dir'], ); $txt['theme_' . $id . '_theme_url'] = $theme['name'] . ' URL'; $txt['theme_' . $id . '_images_url'] = $theme['name'] . ' Images URL'; $txt['theme_' . $id . '_theme_dir'] = $theme['name'] . ' Directory'; } } if (!$sources_exist) { echo '
', $txt['no_sources'], '
'; } if ($db_connection == true) { $request = $smcFunc['db_list_tables']('', ' {db_prefix}log_topics', array( 'db_error_skip' => true, ) ); if ($request == true) { if ($smcFunc['db_num_rows']($request) == 1) list ($known_settings['database_settings']['db_prefix'][2]) = preg_replace('~log_topics$~', '', $smcFunc['db_fetch_row']($request)); $smcFunc['db_free_result']($request); } if (!empty($context['settings_saved'])) { echo '
', $txt['settings_saved'], '
'; } if (!empty($context['hooks_removed'])) { echo '
', $txt['hooks_' . ($context['smfVersion'] == '2.1' ? 'disabled' : 'removed')], '
'; } } elseif (empty($show_db_settings)) { echo '
', $txt['database_settings_hidden'], '
'; } echo '
'; foreach ($known_settings as $settings_section => $section) { echo '

', $txt[$settings_section], '

', $txt[$settings_section . '_info'], '

'; foreach ($section as $setting => $info) { if (!array_key_exists($setting, $settings) && isset($optional_settings[$settings_section]) && in_array($setting, $optional_settings[$settings_section])) continue; if ($info[0] == 'hidden') continue; if ($info[0] != 'flat' && empty($show_db_settings)) continue; echo ' '; } echo '
', $txt[$setting], ': ' . (isset($txt[$setting . '_desc']) ? '' . $txt[$setting . '_desc'] . '' : '') . ' ', !isset($settings[$setting]) && $info[1] != 'check' ? '
' . $txt['no_value'] : '', ' 		'; if ($info[1] == 'int' || $info[1] == 'check') { for ($i = 0; $i <= $info[2]; $i++) echo '
'; } elseif ($info[1] == 'string') { echo ' '; if (isset($txt[$setting . '_help'])) echo '
', $txt[$setting . '_help'], '
'; if (isset($info[2])) echo ' ', $info[2] == '' ? '' : ($setting != 'language' && $setting != 'cookiename' ? ' ' : ''); } elseif ($info[1] == 'array_string') { if (!is_array($settings[$setting]) && $context['smfVersion'] == '2.1') $array_settings = json_decode($settings[$setting], true); // Maybe its a seraialized array, we only support those, so test for it in a simple way. if (!(isset($array_settings) && is_array($array_settings)) && !is_array($settings[$setting])) $array_settings = @unserialize($settings[$setting]); if (!isset($array_settings) || !is_array($array_settings)) $array_settings = array(1 => $settings[$setting]); foreach ($array_settings as $item => $array_setting) { $suggested = false; echo ' '; $suggested = guess_attachments_directories($item, $array_setting); if (!empty($suggested)) { echo ' ', $suggested[0] == '' ? '' : ' '; for ($i = 1; $i < count($suggested); $i++) echo ' '; } else echo '
', $txt['no_default_value'], '
'; $item++; } } elseif ($info[1] == 'select' && !empty($info[3])) { echo ' '; if (isset($txt[$setting . '_help'])) echo '
', $txt[$setting . '_help'], '
'; if (!is_null($info[2])) echo '
', $txt['default_value'], ': "' . $info[3][$info[2]], '".
', $info[2] == '' ? '' : ($setting != 'language' && $setting != 'cookiename' ? ' ' : ''); } echo '
'; } echo '
'; $failure = false; if (strpos(__FILE__, ':\\') !== 1) { // On linux, it's easy - just use is_writable! $failure |= !is_writable('Settings.php') && !chmod('Settings.php', 0777); } // Windows is trickier. Let's try opening for r+... else { // Funny enough, chmod actually does do something on windows - it removes the read only attribute. chmod(dirname(__FILE__) . '/' . 'Settings.php', 0777); $fp = @fopen(dirname(__FILE__) . '/' . 'Settings.php', 'r+'); // Hmm, okay, try just for write in that case... if (!$fp) $fp = @fopen(dirname(__FILE__) . '/' . 'Settings.php', 'w'); $failure |= !$fp; fclose($fp); } if ($failure) echo '
', $txt['not_writable']; else { echo ' [', $txt['restore_all_settings'], '] '; if (!$context['is_legacy']) echo ' '; } //In either case, an easy remove button? This has a long name in it, so let's break a line echo '
'; echo '
'; } function guess_attachments_directories($id, $array_setting) { global $smcFunc, $context; static $usedDirs; if (empty($userdDirs)) { $usedDirs = array(); $request = $smcFunc['db_query'](true, ' SELECT {raw:select_tables}, file_hash FROM {db_prefix}attachments {raw:smf1_limit}', array( 'select_tables' => $context['is_legacy'] ? ($id . ' as id_folder, ID_ATTACH as id_attach') : 'DISTINCT(id_folder), id_attach', // If it's SMF 1.x then check only the last attachment loaded 'smf1_limit' => $context['is_legacy'] ? ' ORDER BY ID_ATTACH DESC LIMIT 1' : '', ) ); if ($smcFunc['db_num_rows']($request) > 0) { while ($row = $smcFunc['db_fetch_assoc']($request)) $usedDirs[$row['id_folder']] = $row; $smcFunc['db_free_result']($request); } } if ($basedir = opendir(dirname(__FILE__))) { $availableDirs = array(); while (false !== ($file = readdir($basedir))) if ($file != '.' && $file != '..' && is_dir($file) && $file != 'Sources' && $file != 'Packages' && $file != 'Themes' && $file != 'cache' && $file != 'avatars' && $file != 'Smileys') $availableDirs[] = $file; } // 1st guess: let's see if we can find a file...if there is at least one. if (isset($usedDirs[$id]) || ($context['is_legacy'] && isset($usedDirs[$id]))) foreach ($availableDirs as $aDir) if (file_exists(dirname(__FILE__) . '/' . $aDir . '/' . $usedDirs[$id]['id_attach'] . '_' . $usedDirs[$id]['file_hash'])) return array(dirname(__FILE__) . '/' . $aDir); // 2nd guess: directory name if (!empty($availableDirs)) foreach ($availableDirs as $dirname) if (strrpos($array_setting, $dirname) == (strlen($array_setting) - strlen($dirname))) return array(dirname(__FILE__) . '/' . $dirname); // 3rd guess: sub directory names if (!empty($availableDirs)) foreach ($availableDirs as $dirname) if (strrpos($array_setting, DIRECTORY_SEPARATOR . $dirname . DIRECTORY_SEPARATOR) > 0) { $subdir = opendir(dirname(__FILE__) . DIRECTORY_SEPARATOR . $dirname); while (false !== ($file = readdir($subdir))) if (strrpos($array_setting, $dirname . DIRECTORY_SEPARATOR . $file) == (strlen($array_setting) - strlen($dirname . DIRECTORY_SEPARATOR . $file))) return array(dirname(__FILE__) . DIRECTORY_SEPARATOR . $dirname . DIRECTORY_SEPARATOR . $file); } // Doing it later saves in case the attached files have been deleted from the file system if (empty($usedDirs) && empty($availableDirs)) return false; elseif (empty($usedDirs) && !empty($availableDirs)) { $guesses = array(); // attachments is the first guess foreach ($availableDirs as $dir) if ($dir == 'attachments') $guesses[] = dirname(__FILE__) . '/' . $dir; // all the others foreach ($availableDirs as $dir) if ($dir != 'attachments') $guesses[] = dirname(__FILE__) . '/' . $dir; return $guesses; } } function set_settings() { global $smcFunc, $context, $db_connection, $db_server, $db_name, $db_user, $db_passwd, $db_prefix, $db_type; $db_updates = isset($_POST['dbsettings']) ? $_POST['dbsettings'] : array(); $theme_updates = isset($_POST['themesettings']) ? $_POST['themesettings'] : array(); $file_updates = isset($_POST['flatsettings']) ? $_POST['flatsettings'] : array(); $attach_dirs = array(); $attach_base_dirs = array(); if (empty($db_updates['theme_default'])) unset($db_updates['theme_default']); else { $db_updates['theme_guests'] = 1; $smcFunc['db_query'](true, ' UPDATE {db_prefix}members SET {raw:theme_column} = 0', array( 'theme_column' => $context['is_legacy'] ? 'ID_THEME' : 'id_theme', ) ); } // Remove the redirect... file_put_contents( dirname(__FILE__) . '/Settings.php', preg_replace( '~^if\s*\(file_exists\(dirname\(__FILE__\)\s*\.\s*\'/install\.php\'\)\)\s*(?:({(?'.'>[^{}]|(?1))*})\h*|header(\((?' . '>[^()]|(?2))*\));\n)~m', '', file_get_contents(dirname(__FILE__) . '/Settings.php') ) ); $settingsArray = file(dirname(__FILE__) . '/Settings.php'); $settings = array(); for ($i = 0, $n = count($settingsArray); $i < $n; $i++) { $settingsArray[$i] = rtrim($settingsArray[$i]); if (isset($settingsArray[$i][0]) && $settingsArray[$i][0] != '.' && preg_match('~^[$]([a-zA-Z_]+)\s*=\s*(?:(["\'])(.*?["\'])(?:\\2)?|(.*?)(?:\\2)?);~', $settingsArray[$i], $match) == 1) $settings[$match[1]] = stripslashes($match[3]); foreach ($file_updates as $var => $val) { if (strncasecmp($settingsArray[$i], '$' . $var, 1 + strlen($var)) == 0) { $comment = strstr($settingsArray[$i], '#'); // Ints, should be ints, not strings. Bools too. if (in_array($val, array('0', '1', '2', 'true', 'false'))) $settingsArray[$i] = '$' . $var . ' = ' . $val . ';' . ($comment != '' ? "\t\t" . $comment : ''); else $settingsArray[$i] = '$' . $var . ' = \'' . $val . '\';' . ($comment != '' ? "\t\t" . $comment : ''); } } } // Blank out the file - done to fix a oddity with some servers. $fp = @fopen(dirname(__FILE__) . '/Settings.php', 'w'); fclose($fp); $fp = fopen(dirname(__FILE__) . '/Settings.php', 'r+'); $lines = count($settingsArray); for ($i = 0; $i < $lines - 1; $i++) { // Don't just write a bunch of blank lines. if ($settingsArray[$i] != '' || $settingsArray[$i - 1] != '') fwrite($fp, $settingsArray[$i] . "\n"); } fwrite($fp, $settingsArray[$i]); fclose($fp); // Make sure it works. require(dirname(__FILE__) . '/Settings.php'); //We need to re-try the database settings, right? $context['settings_test'] = 1; initialize_inputs(); //if database settings are wrong, we will not try anything else! if ($db_connection != true) return; $setString = array(); foreach ($db_updates as $var => $val) $setString[] = array($var, stripslashes($val)); // Attachments dirs if ($context['is_legacy']) { foreach ($setString as $key => $value) if (strpos($value[0], 'attachmentUploadDir') == 0 && strpos($value[0], 'attachmentUploadDir') !== false) { $attach_dirs[0] = $value[1]; unset($setString[$key]); } } else { foreach ($setString as $key => $value) if (strpos($value[0], 'attachmentUploadDir') == 0 && strpos($value[0], 'attachmentUploadDir') !== false) { $index = substr($value[0], strlen('attachmentUploadDir_')); $attach_dirs[$index] = $value[1]; unset($setString[$key]); } elseif (strpos($value[0], 'attachment_basedirectories') == 0 && strpos($value[0], 'attachment_basedirectories') !== false) { $index = substr($value[0], strlen('attachment_basedirectories_')); $attach_base_dirs[$index] = $value[1]; unset($setString[$key]); } } // Build the update string for attachment dirs if (!empty($attach_dirs)) { // In SMF 2.1, its always an array. if ($context['smfVersion'] == '2.1') { $setString[] = array('attachmentUploadDir', json_encode($attach_dirs)); if (!empty($attach_base_dirs)) $setString[] = array('attachment_basedirectories', json_encode($attach_base_dirs)); } // Only one dir...or maybe nothing at all elseif (count($attach_dirs) > 1) { $setString[] = array('attachmentUploadDir', @serialize($attach_dirs)); } elseif (!$context['is_legacy'] && isset($attach_dirs[1])) { $setString[] = array('attachmentUploadDir', $attach_dirs[1]); $setString[] = array('currentAttachmentUploadDir', 0); } elseif ($context['is_legacy'] && isset($attach_dirs[0])) { $setString[] = array('attachmentUploadDir', $attach_dirs[0]); } else { $setString[] = array('attachmentUploadDir', ''); $setString[] = array('currentAttachmentUploadDir', 0); } } if (!empty($setString)) $smcFunc['db_insert']('replace', '{db_prefix}settings', array('variable' => 'string', 'value' => 'string-65534'), $setString, array('variable') ); $setString = array(); foreach ($theme_updates as $var => $val) { // Extract the data preg_match('~theme_([\d]+)_(.+)~', $var, $match); if (empty($match[0])) continue; $setString[] = array($match[1], 0, $match[2], stripslashes($val)); } if (!empty($setString)) $smcFunc['db_insert']('replace', '{db_prefix}themes', array('id_theme' => 'int', 'id_member' => 'int', 'variable' => 'string', 'value' => 'string-65534'), $setString, array('id_theme', 'id_member', 'variable') ); //If we got here, all is good :) $context['settings_saved'] = 1; } function remove_hooks() { global $smcFunc, $sourcedir, $context; // For SMF 2.1, we can just disable them. if ($context['smfVersion'] == '2.1') $smcFunc['db_query']('', ' UPDATE {db_prefix}settings SET value = CONCAT(value, {string:disable}) WHERE variable LIKE {string:variable} AND value NOT LIKE {string:disableMatch}', array( 'disable' => '!', 'variable' => 'integrate_%', 'disableMatch' => '%!', ) ); else $smcFunc['db_query']('', ' DELETE FROM {db_prefix}settings WHERE variable LIKE {string:variable}', array( 'variable' => 'integrate_%' ) ); // Now fixing the cache... require_once($sourcedir . '/Load.php'); cache_put_data('modsettings', null, 0); //Let's say we did it $context['hooks_removed'] = 1; } // Compat mode! function smc_compat_initiate($db_server, $db_name, $db_user, $db_passwd, $db_prefix, $db_options = array()) { global $sourcedir, $db_connection, $db_prefix, $smcFunc, $mysqli_found; // Add mysqli support in case someone is trying to resurrect an old forum on a new server $mysqli_found = function_exists('mysqli_connect'); if ($mysqli_found) if (!empty($db_options['persist'])) $db_connection = @mysqli_connect('p:' . $db_server, $db_user, $db_passwd); else $db_connection = @mysqli_connect($db_server, $db_user, $db_passwd); else if (!empty($db_options['persist'])) $db_connection = @mysql_pconnect($db_server, $db_user, $db_passwd); else $db_connection = @mysql_connect($db_server, $db_user, $db_passwd); // Something's wrong, show an error if its fatal (which we assume it is) if (!$db_connection) { if (!empty($db_options['non_fatal'])) return null; else { if (file_exists($sourcedir . '/Errors.php')) { require_once($sourcedir . '/Errors.php'); display_db_error(); } exit('Sorry, SMF was unable to connect to database.'); } } // If DB not found, then dbname is wrong, return null if ($mysqli_found) { if (mysqli_select_db($db_connection, $db_name) === false) return null; } else { if (mysql_select_db($db_name, $db_connection) === false) return null; } // Some core functions, but only once, yes? if (!function_exists('smf_db_replacement__callback')) { function smf_db_replacement__callback($matches) { global $db_callback, $user_info, $db_prefix, $mysqli_found; list ($values, $connection) = $db_callback; if ($matches[1] === 'db_prefix') return $db_prefix; if ($matches[1] === 'query_see_board') return $user_info['query_see_board']; if ($matches[1] === 'query_wanna_see_board') return $user_info['query_wanna_see_board']; if (!isset($matches[2])) smf_db_error_backtrace('Invalid value inserted or no type specified.', '', E_USER_ERROR, __FILE__, __LINE__); if (!isset($values[$matches[2]])) smf_db_error_backtrace('The database value you\'re trying to insert does not exist: ' . htmlspecialchars($matches[2]), '', E_USER_ERROR, __FILE__, __LINE__); $replacement = $values[$matches[2]]; switch ($matches[1]) { case 'int': if (!is_numeric($replacement) || (string) $replacement !== (string) (int) $replacement) smf_db_error_backtrace('Wrong value type sent to the database. Integer expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); return (string) (int) $replacement; break; case 'string': case 'text': if ($mysqli_found) return sprintf('\'%1$s\'', mysqli_real_escape_string($connection, $replacement)); else return sprintf('\'%1$s\'', mysql_real_escape_string($replacement, $connection)); break; case 'array_int': if (is_array($replacement)) { if (empty($replacement)) smf_db_error_backtrace('Database error, given array of integer values is empty. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); foreach ($replacement as $key => $value) { if (!is_numeric($value) || (string) $value !== (string) (int) $value) smf_db_error_backtrace('Wrong value type sent to the database. Array of integers expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); $replacement[$key] = (string) (int) $value; } return implode(', ', $replacement); } else smf_db_error_backtrace('Wrong value type sent to the database. Array of integers expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); break; case 'array_string': if (is_array($replacement)) { if (empty($replacement)) smf_db_error_backtrace('Database error, given array of string values is empty. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); foreach ($replacement as $key => $value) if ($mysqli_found) $replacement[$key] = sprintf('\'%1$s\'', mysqli_real_escape_string($connection, $value)); else $replacement[$key] = sprintf('\'%1$s\'', mysql_real_escape_string($value, $connection)); return implode(', ', $replacement); } else smf_db_error_backtrace('Wrong value type sent to the database. Array of strings expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); break; case 'date': if (preg_match('~^(\d{4})-([0-1]?\d)-([0-3]?\d)$~', $replacement, $date_matches) === 1) return sprintf('\'%04d-%02d-%02d\'', $date_matches[1], $date_matches[2], $date_matches[3]); else smf_db_error_backtrace('Wrong value type sent to the database. Date expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); break; case 'float': if (!is_numeric($replacement)) smf_db_error_backtrace('Wrong value type sent to the database. Floating point number expected. (' . $matches[2] . ')', '', E_USER_ERROR, __FILE__, __LINE__); return (string) (float) $replacement; break; case 'identifier': // Backticks inside identifiers are supported as of MySQL 4.1. We don't need them for SMF. return '`' . strtr($replacement, array('`' => '', '.' => '')) . '`'; break; case 'raw': return $replacement; break; default: smf_db_error_backtrace('Undefined type used in the database query. (' . $matches[1] . ':' . $matches[2] . ')', '', false, __FILE__, __LINE__); break; } } } // Because this is just compat mode, this is good enough. if (!function_exists('smf_db_query')) { function smf_db_query($execute = true, $db_string = '', $db_values = []) { global $db_callback, $db_connection, $mysqli_found; // Only bother if there's something to replace. if (strpos($db_string, '{') !== false) { // This is needed by the callback function. $db_callback = array($db_values, $db_connection); // Do the quoting and escaping $db_string = preg_replace_callback('~{([a-z_]+)(?::([a-zA-Z0-9_-]+))?}~', 'smf_db_replacement__callback', $db_string); // Clear this global variable. $db_callback = array(); } // We actually make the query in compat mode. if ($execute === false) return $db_string; if ($mysqli_found) return mysqli_query($db_connection, $db_string); else return mysql_query($db_string, $db_connection); } } // Insert some data... if (!function_exists('smf_db_insert')) { function smf_db_insert($method = 'replace', $table = '', $columns = [], $data = [], $keys = [], $disable_trans = false) { global $smcFunc, $db_connection, $db_prefix; // With nothing to insert, simply return. if (empty($data)) return; // Replace the prefix holder with the actual prefix. $table = str_replace('{db_prefix}', $db_prefix, $table); // Inserting data as a single row can be done as a single array. if (!is_array($data[array_rand($data)])) $data = array($data); // Create the mold for a single row insert. $insertData = '('; foreach ($columns as $columnName => $type) { // Are we restricting the length? if (strpos($type, 'string-') !== false) $insertData .= sprintf('SUBSTRING({string:%1$s}, 1, ' . substr($type, 7) . '), ', $columnName); else $insertData .= sprintf('{%1$s:%2$s}, ', $type, $columnName); } $insertData = substr($insertData, 0, -2) . ')'; // Create an array consisting of only the columns. $indexed_columns = array_keys($columns); // Here's where the variables are injected to the query. $insertRows = array(); foreach ($data as $dataRow) $insertRows[] = smf_db_query(false, $insertData, array_combine($indexed_columns, $dataRow)); // Determine the method of insertion. $queryTitle = ($method == 'replace') ? 'REPLACE' : (($method == 'ignore') ? 'INSERT IGNORE' : 'INSERT'); // Do the insert. $smcFunc['db_query'](true, ' ' . $queryTitle . ' INTO ' . $table . '(`' . implode('`, `', $indexed_columns) . '`) VALUES ' . implode(', ', $insertRows), array( 'security_override' => true, ) ); } } // This function tries to work out additional error information from a back trace. if (!function_exists('smf_db_error_backtrace')) { function smf_db_error_backtrace($error_message, $log_message = '', $error_type = false, $file = null, $line = null) { if (empty($log_message)) $log_message = $error_message; // A special case - we want the file and line numbers for debugging. if ($error_type == 'return') return array($file, $line); // Is always a critical error. if (function_exists('log_error')) log_error($log_message, 'critical', $file, $line); if ($error_type) trigger_error($error_message . ($line !== null ? '(' . basename($file) . '-' . $line . ')' : ''), $error_type); else trigger_error($error_message . ($line !== null ? '(' . basename($file) . '-' . $line . ')' : '')); } } // Returns all tables if (!function_exists('smf_db_list_tables')) { function smf_db_list_tables($db = false, $filter = false) { global $db_name, $smcFunc; $db = $db == false ? $db_name : $db; $db = trim($db); $filter = $filter == false ? '' : ' LIKE \'' . $filter . '\''; $request = $smcFunc['db_query'](true, ' SHOW TABLES FROM `{raw:db}` {raw:filter}', array( 'db' => $db[0] == '`' ? strtr($db, array('`' => '')) : $db, 'filter' => $filter, ) ); $tables = array(); while ($row = $smcFunc['db_fetch_row']($request)) $tables[] = $row[0]; $smcFunc['db_free_result']($request); return $tables; } } // Now, go functions, spread your love. if ($mysqli_found) { $smcFunc['db_free_result'] = 'mysqli_free_result'; $smcFunc['db_fetch_row'] = 'mysqli_fetch_row'; $smcFunc['db_fetch_assoc'] = 'mysqli_fetch_assoc'; $smcFunc['db_num_rows'] = 'mysqli_num_rows'; } else { $smcFunc['db_free_result'] = 'mysql_free_result'; $smcFunc['db_fetch_row'] = 'mysql_fetch_row'; $smcFunc['db_fetch_assoc'] = 'mysql_fetch_assoc'; $smcFunc['db_num_rows'] = 'mysql_num_rows'; } $smcFunc['db_insert'] = 'smf_db_insert'; $smcFunc['db_query'] = 'smf_db_query'; $smcFunc['db_quote'] = 'smf_db_query'; $smcFunc['db_error_backtrace'] = 'smf_db_error_backtrace'; $smcFunc['db_list_tables'] = 'smf_db_list_tables'; // One last check - prefix $tables = smf_db_list_tables(); if (!(is_array($tables) && in_array($db_prefix . 'settings', $tables))) $db_connection = null; $db_prefix = is_numeric(substr($db_prefix, 0, 1)) ? $db_name . '.' . $db_prefix : '`' . $db_name . '`.' . $db_prefix; return $db_connection; } //Function to find Sources automatically. If it's here, we find it :) function findSources() { $basedir = dirname(__FILE__); //Our location :) $dirs = array(); $dir = dir($basedir); //All our folders while ($line = $dir->read()) { if (in_array($line, array('.', '..', 'blank.gif', 'index', '.htaccess'))) continue; if (is_dir($line)) $dirs[] = $line; else $files[] = $line; } $dir->close(); foreach ($dirs as $key => $value) //Let's find Load.php!!! { //Files in this folder $current_folder = $basedir . '/' . $value; $dir = dir($current_folder); while ($line = $dir->read()) { if (in_array($line, array('.', '..', 'blank.gif', 'index', '.htaccess'))) continue; //We are looking for Load.php. As good as any other :) if (!is_dir($line) && ($line == 'Load.php')) return $current_folder; } $dir->close(); } //If we get to the end, well, we didn't find it... return null; }