detectFulltextIndex()

Complexity

Conditions	19
Paths	26

Size

Total Lines	75
Code Lines	34

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
function detectFulltextIndex()
{
	global $smcFunc, $context, $db_prefix;

	// We need this for db_get_version
	db_extend();

	if ($smcFunc['db_title'] == 'PostgreSQL')
	{
		$request = $smcFunc['db_query']('', '
			SELECT
				indexname
			FROM pg_tables t
				LEFT OUTER JOIN
					(SELECT c.relname AS ctablename, ipg.relname AS indexname, indexrelname FROM pg_index x
						JOIN pg_class c ON c.oid = x.indrelid
						JOIN pg_class ipg ON ipg.oid = x.indexrelid
						JOIN pg_stat_all_indexes psai ON x.indexrelid = psai.indexrelid)
					AS foo
					ON t.tablename = foo.ctablename
			WHERE t.schemaname= {string:schema} and indexname = {string:messages_ftx}',
			array(
				'schema' => 'public',
				'messages_ftx' => $db_prefix . 'messages_ftx',
			)
		);
		while ($row = $smcFunc['db_fetch_assoc']($request))
			$context['fulltext_index'][] = $row['indexname'];
	}
	else
	{
		$request = $smcFunc['db_query']('', '
			SHOW INDEX
			FROM {db_prefix}messages',
			array(
			)
		);
		$context['fulltext_index'] = array();
		if ($request !== false || $smcFunc['db_num_rows']($request) != 0)
		{
			while ($row = $smcFunc['db_fetch_assoc']($request))
				if ($row['Column_name'] == 'body' && (isset($row['Index_type']) && $row['Index_type'] == 'FULLTEXT' || isset($row['Comment']) && $row['Comment'] == 'FULLTEXT'))
					$context['fulltext_index'][] = $row['Key_name'];
			$smcFunc['db_free_result']($request);

			if (is_array($context['fulltext_index']))
				$context['fulltext_index'] = array_unique($context['fulltext_index']);
		}

		if (preg_match('~^`(.+?)`\.(.+?)$~', $db_prefix, $match) !== 0)
			$request = $smcFunc['db_query']('', '
				SHOW TABLE STATUS
				FROM {string:database_name}
				LIKE {string:table_name}',
				array(
					'database_name' => '`' . strtr($match[1], array('`' => '')) . '`',
					'table_name' => str_replace('_', '\_', $match[2]) . 'messages',
				)
			);
		else
			$request = $smcFunc['db_query']('', '
				SHOW TABLE STATUS
				LIKE {string:table_name}',
				array(
					'table_name' => str_replace('_', '\_', $db_prefix) . 'messages',
				)
			);

		if ($request !== false)
		{
			while ($row = $smcFunc['db_fetch_assoc']($request))
				if (isset($row['Engine']) && strtolower($row['Engine']) != 'myisam' && !(strtolower($row['Engine']) == 'innodb' && version_compare($smcFunc['db_get_version'](), '5.6.4', '>=')))
					$context['cannot_create_fulltext'] = true;

			$smcFunc['db_free_result']($request);
		}
?>