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'] = 'Restore all settings';
$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 ELK 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 ELK 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 ELK 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 ELK 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['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 ELK 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 logo: it could be a .gif or a .png
$logo = "themes/default/images/logo.png";
if (!file_exists(dirname(__FILE__) . "/" . $logo))
$logo = "themes/default/images/logo.gif";
// Note that we're using the default URLs because we aren't even going to try to use Settings.php's settings.
echo '
', $txt['elkarte_repair_settings'], '
', $txt['elkarte_repair_settings'], '
';
show_settings();
echo '
';
function initialize_inputs()
{
global $db_connection, $sourcedir, $db_server, $db_name, $db_user, $db_passwd, $db_prefix, $db_type, $context, $sources_exist, $sources_found_path, $db_type_options;
$db = database();
// 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;
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
$context['elkVersion'] = '1.0';
// Time to set some constants
DEFINE('BOARDDIR', $boarddir);
DEFINE('AVATARDIR', $boarddir . '/avatars');
DEFINE('PACKAGEDIR', $boarddir . '/packages');
DEFINE('SMILEYDIR', $boarddir . '/smileys');
DEFINE('CACHEDIR', $cachedir);
DEFINE('EXTDIR', $extdir);
DEFINE('LANGUAGEDIR', $languagedir);
DEFINE('SOURCEDIR', $sourcedir);
DEFINE('ADMINDIR', $sourcedir . '/admin');
DEFINE('CONTROLLERDIR', $sourcedir . '/controllers');
DEFINE('DATABASEDIR', $sourcedir . '/database');
DEFINE('SUBSDIR', $sourcedir . '/subs');
unset($boarddir, $cachedir, $sourcedir, $languagedir, $extdir);
$sources_found_path = '';
if (isset($sourcedir) && (file_exists(SOURCEDIR . '/Load.php')))
$sources_exist = true;
else
{
//Find Sources folder!
$sourcedir = findSources();
$sources_found_path = $sourcedir;
$sources_exist = !empty($sourcedir);
}
if ($sources_exist)
{
if (!defined('ELK'))
define('ELK', 1);
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
if (empty($smcFunc))
$smcFunc = array();
// Default the database type to MySQL. In 2.1 Beta 3, mysqli was removed, this will put it back to mysql.
$db_type_options = array('default' => 'mysql', 'options' => array('mysql' => 'MySQL'));
if (empty($db_type) || !file_exists(DATABASEDIR . '/Db-' . $db_type . '.class.php'))
$db_type = 'mysql';
require_once(SOURCEDIR . '/Load.php');
require_once(SUBSDIR . '/Auth.subs.php');
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
// 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 ELK 1.x as far as we can tell, as we don't know/have any database files.
elseif (!file_exists(DATABASEDIR . '/Db-' . $db_type . '.class.php') && $db_type == 'mysql')
{
$db_connection = elk_db_initiate($db_server, $db_name, $db_user, $db_passwd, $db_prefix, array('non_fatal' => true));
}
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
else
{
// Far as I know, this is 1.1.
$context['is_legacy'] = false;
$context['elkVersion'] = '1.1';
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
// Try to see if this is 2.1. Maybe include more checks.
if (file_exists($sourcedir . '/Class-TOTP.php'))
$context['elkVersion'] = '2.1';
// We should try to use the proper extension function if at all possible.
require_once(DATABASEDIR . '/Db-' . $db_type . '.class.php');
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
if (function_exists('db_extend'))
db_extend('extra');
else
require_once($sourcedir . '/DbExtra-' . $db_type . '.php');
$db_connection = elk_db_initiate($db_server, $db_name, $db_user, $db_passwd, $db_prefix, array('non_fatal' => true));
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
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 (!$db->select_db($db_name, $db_connection))
$db_connection = null;
else
{
$tables=$db->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(DATABASEDIR . '/Db-postgresql.class.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;
}
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
// 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';
}
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
// 2.0 supports sqlite.
if (file_exists($sourcedir . '/Subs-Db-sqlite.php') && (empty($context['elkVersion']) || $context['elkVersion'] == '2.0'))
{
$db_type_options['options']['sqlite'] = 'SQLite';
if ($db_type == 'sqlite')
$db_type_options['default'] = $db_type;
}
}
}
function show_settings()
{
global $txt, $db_connection, $db_type, $db_name, $db_prefix, $context, $sources_exist, $sources_found_path, $db_type_options;
$db = database();
// 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]] = SOURCEDIR;
elseif ($match[3] == '$boarddir . \'/sources\'')
$settings[$match[1]] = $settings['boarddir'] . '/sources';
elseif ($match[3] == 'dirname(__FILE__) . \'/cache\'')
$settings[$match[1]] = CACHEDIR;
// 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 = $db->query(true, '
SELECT DISTINCT variable, value
FROM {db_prefix}settings',
array(
'db_error_skip' => true
),
$db_connection
);
while ($row = $db->fetch_assoc($request))
{
// Skip this setting on 2.1.
if ($context['elkVersion'] == '2.1' && $row['variable'] == 'cache_enable')
continue;
$settings[$row['variable']] = $row['value'];
}
$db->free_result($request);
// Load all the themes.
$request = $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];
$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', 'ELKCookie' . (!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'),
'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(),
);
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
// 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']);
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
// These settings didn't exist in 2.0 or 1.1
if ($context['elkVersion'] != '2.1')
unset($known_settings['cache_settings']['cache_accelerator'], $known_settings['cache_settings']['cache_enable'], $known_settings['cache_settings']['cache_memcached']);
// 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(SOURCEDIR))
$known_settings['path_url_settings']['sourcedir'][2] = realpath(SOURCEDIR);
elseif (!empty($sources_found_path))
$known_settings['path_url_settings']['sourcedir'][2] = realpath($sources_found_path);
if ($context['elkVersion'] == '2.1' && file_exists(SOURCEDIR . '/tasks'))
$known_settings['path_url_settings']['tasksdir'][2] = realpath(SOURCEDIR . '/tasks');
if (file_exists(CACHEDIR) && isset($known_settings['cache_settings']['cachedir']))
$known_settings['cache_settings']['cachedir'][2] = realpath(CACHEDIR);
if (file_exists(AVATARDIR))
{
$known_settings['path_url_settings']['avatar_url'][2] = $url . '/avatars';
$known_settings['path_url_settings']['avatar_directory'][2] = realpath(AVATARDIR);
}
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
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(SMILEYDIR))
{
$known_settings['path_url_settings']['smileys_url'][2] = $url . '/smileys';
$known_settings['path_url_settings']['smileys_dir'][2] = realpath(SMILEYDIR);
}
file_exists(PACKAGEDIR))
{
$known_settings['path_url_settings']['packagesdir'][2] = realpath(PACKAGEDIR);
}
/* NOT SURE TO DELETE OR MODIFY - Do we need this? */
/* 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');
}
*/
// STOP FOR REST
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));
$db->free_result($request);
}
if (!empty($context['settings_saved']))
{
echo '
', $txt['settings_saved'], '
';
}
if (!empty($context['hooks_removed']))
{
echo '