phpBB.de

Code: Alles auswählen

if ( isset($_POST['mode']) || isset($_GET['mode']) )
{
	$mode = ( isset($_POST['mode']) ) ? $_POST['mode'] : $_GET['mode'];
}
else
{
	$mode = '';
}

if ( isset($_POST['search_keywords']) || isset($_GET['search_keywords']) )
{
	$search_keywords = ( isset($_POST['search_keywords']) ) ? $_POST['search_keywords'] : $_GET['search_keywords'];
}
else
{
	$search_keywords = '';
}

if ( isset($_POST['search_querry']) || isset($_GET['search_querry']) )
{
	$search_querry = ( $_POST['search_querry'] == 'news_subject' || $_GET['search_querry'] == 'news_subject' ) ? 'news_subject' : 'news_content' ;
}
else
{
	$search_querry = '';
}


if ( $mode == 'results' && $search_keywords == '' )
{
	message_die(GENERAL_ERROR, 'Could not obtain matched posts list', '', __LINE__, __FILE__, $sql);
}

else if ( $mode == 'results' && $search_keywords != '' )
{
	$split_search = array();
	$split_search = ( !strstr($multibyte_charset, 'iso-8859-1') ) ?  split_words(clean_words(stripslashes($search_keywords))) : split(' ', $search_keywords);	

	$page_title = 'News Search';
	include($inu_root_path . 'includes/page_header.'.$phpEx);
	include($inu_root_path . 'includes/page_left.'.$phpEx);

	$template->set_filenames(array(
		'body' => 'news_search_results.tpl')
	);

	for($i = 0; $i < count($split_search); $i++)
	{
		switch ( $split_search[$i] )
		{
			case 'and':
			$current_match_type = 'and';
			break;

			case 'or':
			$current_match_type = 'or';
			break;

			case 'not':
			$current_match_type = 'not';
			break;

			default:
			$current_match_type = 'and';

			$match_word =  addslashes('%' . str_replace('*', '', $split_search[$i]) . '%');
				
			$sql = "SELECT news_id, news_date, news_subject, news_content
					FROM " . NEWS_TABLE . "
					WHERE " . $search_querry . " LIKE '$match_word' ";
			
			if ( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not obtain matched posts list', '', __LINE__, __FILE__, $sql);
			}

			while( $row = $db->sql_fetchrow($result) )
			{
				$template->assign_block_vars('news_search_results', array( 
					$search_ids[] = $row['news_id'],
					
					'L_SUBJECT' => $row['news_subject'],
					'L_DATE' => $row['news_date'],

					'U_SUBJECT' => $post_url)
				);
			}
			
			$db->sql_freeresult($result);
			
		}
	}
	
	$total_match_count = count($search_ids);

	$template->assign_vars(array(
		'L_SUBJECT' => 'Titel',
		'L_DATE' => 'Datum',
		
		'L_COUNTER' => $total_match_count,
		
		'U_SUBJECT' => 'index.'.$phpEx.'?show=news_search&mode=results&search_keywords='.$search_keywords.'&search_querry='.$search_querry.'&order=news_subject',
		'U_DATE' => 'index.'.$phpEx.'?show=news_search&mode=results&search_keywords='.$search_keywords.'&search_querry='.$search_querry.'&order=news_date')
	);

	$template->pparse('body');

	include($inu_root_path . 'includes/page_tail.'.$phpEx);
}

Code: Alles auswählen

function clean_words($entry)
{
	static $drop_char_match =   array('^', '$', '&', '(', ')', '<', '>', '`', '\'', '"', '|', ',', '@', '_', '?', '%', '-', '~', '+', '.', '[', ']', '{', '}', ':', '\\', '/', '=', '#', '\'', ';', '!');
	static $drop_char_replace = array(' ', ' ', ' ', ' ', ' ', ' ', ' ', '',  '',   ' ', ' ', ' ', ' ', '',  ' ', ' ', '',  ' ',  ' ', ' ', ' ', ' ', ' ', ' ', ' ', ' ' , ' ', ' ', ' ', ' ',  ' ', ' ');

	$entry = ' ' . strip_tags(strtolower($entry)) . ' ';

	$entry = str_replace(' +', ' and ', $entry);
	$entry = str_replace(' -', ' not ', $entry);

	//
	// Filter out strange characters like ^, $, &, change "it's" to "its"
	//
	for($i = 0; $i < count($drop_char_match); $i++)
	{
		$entry =  str_replace($drop_char_match[$i], $drop_char_replace[$i], $entry);
	}

	$entry = str_replace('*', ' ', $entry);
	$entry = preg_replace('/[ ]([\S]{1,2}|[\S]{21,})[ ]/',' ', $entry);

	return $entry;
}