Location: PHPKode > projects > Viscacha > modules/1/related.php
$ignorewords = $lang->get_words();
$ignorewords = array_map("strtolower", $ignorewords);

$searchtopic = splitWords(strtolower($info['topic']));

$sqltopic = array();
foreach ($searchtopic as $val) {
	if (strlen($val) > 3) {
		if (in_array($val, $ignorewords)) {
			continue;
		}
		$sqltopic[] = $val;
	}
}
$sqltopic = array_unique($sqltopic);

$searchdata = array();
$rows = array();

if (count($sqltopic) > 0) {
	$matchsql = implode(' ', $sqltopic);

	$slog->GlobalPermissions();
	$boardsql = $slog->sqlinboards('board', 1);

	$result = $db->query("
	SELECT id, board, topic, MATCH (topic) AGAINST ('{$matchsql}') AS af
	FROM {$db->pre}topics
	WHERE {$boardsql} id != '{$_GET['id']}' AND status != '2' AND MATCH (topic) AGAINST ('$matchsql') > 0.6
	ORDER BY af DESC
	LIMIT {$config['viscacha_related_topics']['relatednum']}"
	);

	if ($db->num_rows($result) > 0) {
		while ($line = $db->fetch_assoc($result)) {
			$line['topic'] = $gpc->prepare($line['topic']);
			$rows[] = $line;
		}
	}
}
if ((count($rows) > 0 && $config['viscacha_related_topics']['hide_empty'] == 1) || $config['viscacha_related_topics']['hide_empty'] != 1) {
	echo $tpl->parse("modules/{$pluginid}/related");
}
Return current item: Viscacha