ConvertUtf8mb4()

Complexity

Conditions	14
Paths	8192

Size

Total Lines	171
Code Lines	75

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function ConvertUtf8mb4()
{
	global $scripturl, $context, $txt, $language, $db_character_set, $db_name;
	global $modSettings, $user_info, $sourcedir, $smcFunc, $db_prefix;

	// Show me your badge!
	isAllowedTo('admin_forum');

	// Confirm utf8mb4 is supported
	$request = $smcFunc['db_query']('', '
		SHOW CHARACTER SET',
		array(
		)
	);

	$db_charsets = array();
	while ($row = $smcFunc['db_fetch_assoc']($request))
		$db_charsets[] = $row['Charset'];
	$smcFunc['db_free_result']($request);

	if (!in_array('utf8mb4', $db_charsets))
		fatal_lang_error('utf8_charset_not_supported');

	// Identify all tables
	// Note we do all tables in order to set default collation at table level
	$request = $smcFunc['db_query']('', '
		SELECT DISTINCT TABLE_NAME
		FROM information_schema.COLUMNS
		WHERE TABLE_SCHEMA = {string:cur_schema}
			AND TABLE_NAME LIKE {string:table_pattern}',
		array(
			'cur_schema' => $db_name,
			'table_pattern' => $db_prefix . '%',
		)
	);

	$db_tables = array();
	while ($row = $smcFunc['db_fetch_assoc']($request))
		$db_tables[] = $row['TABLE_NAME'];
	$smcFunc['db_free_result']($request);

	// Check each of the three indexes that may need updating - #1
	$request = $smcFunc['db_query']('', '
		SELECT SUB_PART
		FROM information_schema.STATISTICS
		WHERE TABLE_NAME = {string:cur_table}
			AND TABLE_SCHEMA = {string:cur_schema}
			AND INDEX_NAME = \'idx_real_name\'
			AND COLUMN_NAME = \'real_name\'',
		array(
			'cur_schema' => $db_name,
			'cur_table' => $db_prefix . 'members',
		)
	);

	list($fix_real_name) = $smcFunc['db_fetch_row']($request);
	if ($fix_real_name == null)
		$fix_real_name = true;
	else
		$fix_real_name = false;

	$smcFunc['db_free_result']($request);

	// Check each of the three indexes that may need updating - #2
	$request = $smcFunc['db_query']('', '
		SELECT SUB_PART
		FROM information_schema.STATISTICS
		WHERE TABLE_NAME = {string:cur_table}
			AND TABLE_SCHEMA = {string:cur_schema}
			AND INDEX_NAME = \'idx_email_address\'
			AND COLUMN_NAME = \'email_address\'',
		array(
			'cur_schema' => $db_name,
			'cur_table' => $db_prefix . 'members',
		)
	);

	list($fix_email_address) = $smcFunc['db_fetch_row']($request);
	if ($fix_email_address == null)
		$fix_email_address = true;
	else
		$fix_email_address = false;

	$smcFunc['db_free_result']($request);

	// Check each of the three indexes that may need updating - #3
	$request = $smcFunc['db_query']('', '
		SELECT SUB_PART
		FROM information_schema.STATISTICS
		WHERE TABLE_NAME = {string:cur_table}
			AND TABLE_SCHEMA = {string:cur_schema}
			AND INDEX_NAME = \'idx_lngfile\'
			AND COLUMN_NAME = \'lngfile\'',
		array(
			'cur_schema' => $db_name,
			'cur_table' => $db_prefix . 'qanda',
		)
	);

	list($fix_lngfile) = $smcFunc['db_fetch_row']($request);
	if ($fix_lngfile == null)
		$fix_lngfile = true;
	else
		$fix_lngfile = false;

	$smcFunc['db_free_result']($request);

	// After this point we are starting the conversion. But first: session check.
	checkSession();

	// First, drop the three indexes if they need fixing...
	if ($fix_real_name)
		$request = $smcFunc['db_query']('', '

The assignment to $request is dead and can be removed.

			ALTER TABLE {db_prefix}members
				DROP INDEX idx_real_name',
			array(
			)
		);
	if ($fix_email_address)
		$request = $smcFunc['db_query']('', '
			ALTER TABLE {db_prefix}members
				DROP INDEX idx_email_address',
			array(
			)
		);
	if ($fix_lngfile)
		$request = $smcFunc['db_query']('', '
			ALTER TABLE {db_prefix}qanda
				DROP INDEX idx_lngfile',
			array(
			)
		);

	// Next, loop thru & fix each table
	foreach ($db_tables AS $cur_table)
	{
		$request = $smcFunc['db_query']('', '
			ALTER TABLE ' . $cur_table . ' CONVERT TO CHARACTER SET \'utf8mb4\' COLLATE \'utf8mb4_unicode_ci\'',
			array(
			)
		);
	}

	// Next, fix the three indexes...
	if ($fix_real_name)
		$request = $smcFunc['db_query']('', '
			ALTER TABLE {db_prefix}members
				ADD INDEX idx_real_name (real_name(191))',
			array(
			)
		);
	if ($fix_email_address)
		$request = $smcFunc['db_query']('', '
			ALTER TABLE {db_prefix}members
				ADD INDEX idx_email_address (email_address(191))',
			array(
			)
		);
	if ($fix_lngfile)
		$request = $smcFunc['db_query']('', '
			ALTER TABLE {db_prefix}qanda
				ADD INDEX idx_lngfile (lngfile(191))',
			array(
			)
		);

	// Finally, note we are now mb4 in Settings.php
	require_once($sourcedir . '/Subs-Admin.php');
	updateSettingsFile(array('db_character_set' => 'utf8mb4', 'db_mb4' => true));

	redirectexit('action=admin;area=maintain;sa=database;done=convertutf8mb4');
}
?>