// Start session management

//

$userdata = $session->start();

//

// End session management

//

{

if ( $userdata['session_logged_in'] )

{

WHERE post_time >= " . $userdata['user_lastvisit'];

}

else

{

if ( $userdata['session_logged_in'] )

{

WHERE poster_id = " . $userdata['user_id'];;

}

else

else

{

$search_author = str_replace('*', '%', trim($search_author));

$sql = "SELECT user_id

FROM " . USERS_TABLE . "

WHERE username LIKE '" . str_replace("\'", "''", $search_author) . "'";

message_die(MESSAGE, $lang['No_search_match']);

}

WHERE poster_id IN ($matching_userids)";

}

}

else if ( $search_keywords != '' )

{

$split_search = array();

$cleaned_search = clean_words('search', stripslashes($search_keywords), $stopword_array, $synonym_array);

$split_search = split_words($cleaned_search, 'search');

$match_word = str_replace('*', '%', $split_search[$i]);

$search_msg_only";

if ( !($result = $db->sql_query($sql)) )

{

{

$search_ids[] = $post_id;

}

unset($result_list);

$total_match_count = count($search_ids);

}

$auth_sql = "f.cat_id = $search_cat";

}

@reset($auth_ary);

$allowed_forum_sql = '';

}

//

//

if ( $search_author != '' )

{

if ( $search_author == '' && $auth_sql == '' )

{

FROM " . POSTS_TABLE . "

GROUP BY topic_id";

}

else

{

if ( $search_author != '' )

{

$where_sql .= " AND f.forum_id = p.forum_id AND $auth_sql";

}

GROUP BY p.topic_id";

}

$db->sql_freeresult($result);

$total_match_count = sizeof($search_ids);

}

else if ( $search_author != '' || $search_time || $auth_sql != '' )

{

$where_sql .= " AND u.user_id = p.poster_id AND u.username LIKE '$search_author'";

}

WHERE $where_sql";

if ( !($result = $db->sql_query($sql)) )

{

{

$sql = "SELECT t.topic_id, f.forum_id

FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f

AND t.forum_id = f.forum_id

AND t.topic_moved_id = 0

AND $auth_sql";

}

else

{

AND topic_moved_id = 0";

}

if ( !($result = $db->sql_query($sql)) )

{

message_die(ERROR, 'Could not obtain post ids', '', __LINE__, __FILE__, $sql);

// Finish building query (for all combinations)

// and run it ...

//

FROM " . SESSIONS_TABLE;

if ( $result = $db->sql_query($sql) )

{

if ( count($delete_search_ids) )

{

WHERE session_id NOT IN (" . implode(", ", $delete_search_ids) . ")";

if ( !$result = $db->sql_query($sql) )

{

mt_srand ((double) microtime() * 1000000);

$search_id = mt_rand();

SET search_id = $search_id, search_array = '$result_array'

WHERE session_id = '" . $userdata['session_id'] . "'";

if ( !($result = $db->sql_query($sql)) || !$db->sql_affectedrows() )

{

VALUES($search_id, '" . $userdata['session_id'] . "', '" . str_replace("\'", "''", $result_array) . "')";

if ( !($result = $db->sql_query($sql)) )

{

{

if ( intval($search_id) )

{

AND session_id = '". $userdata['session_id'] . "'";

if ( !($result = $db->sql_query($sql)) )

{

{

if ( $show_results == 'posts' )

{

WHERE p.post_id IN ($search_results)

AND pt.post_id = p.post_id

AND f.forum_id = p.forum_id

}

else

{

FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2

AND t.topic_poster = u.user_id

AND p.post_id = t.topic_first_post_id

AND p2.post_id = t.topic_last_post_id

AND u2.user_id = p2.poster_id";

{

$searchset[] = $row;

}

//

// Define censored word matches

//

// Output header

//

$page_title = $lang['Search'];

if ( $show_results == 'posts' )

{

$l_search_matches = ( $total_match_count == 1 ) ? sprintf($lang['Found_search_match'], $total_match_count) : sprintf($lang['Found_search_matches'], $total_match_count);

$template->assign_vars(array(

'L_TOPIC' => $lang['Topic'])

);

$highlight_active .= " " . $split_word;

for ($k = 0; $k < count($synonym_array); $k++)

if ( $replace_synonym == $split_word )

{

$highlight_match[] = '#\b(' . str_replace("*", "([\w]+)?", $replace_synonym) . ')\b#is';

$highlight_active .= ' ' . $match_synonym;

}

}

}

$mini_post_alt = $lang['Post'];

}

'TOPIC_TITLE' => $topic_title,

'FORUM_NAME' => $searchset[$i]['forum_name'],

'POST_SUBJECT' => $post_subject,

'TOPIC_REPLIES' => $searchset[$i]['topic_replies'],

'TOPIC_VIEWS' => $searchset[$i]['topic_views'],

'MESSAGE' => $message,

'U_POST' => $post_url,

'U_TOPIC' => $topic_url,

if ( $userdata['session_logged_in'] )

{

{

if ( !empty($tracking_topics) || !empty($tracking_forums) || isset($HTTP_COOKIE_VARS[$board_config['cookie_name'] . '_f_all']) )

{

}

}

{

$folder_image = $folder_new;

$folder_alt = $lang['New_posts'];

$newest_post_img = '<a href="' . append_sid("viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&amp;view=newest") . '"><img src="' . $images['icon_newest_reply'] . '" alt="' . $lang['View_newest_post'] . '" title="' . $lang['View_newest_post'] . '" border="0" /></a> ';

}

{

$folder_image = $folder;

$folder_alt = ( $searchset[$i]['topic_status'] == TOPIC_LOCKED ) ? $lang['Topic_locked'] : $lang['No_new_posts'];

$last_post_url = '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $searchset[$i]['topic_last_post_id']) . '#' . $searchset[$i]['topic_last_post_id'] . '"><img src="' . $images['icon_latest_reply'] . '" alt="' . $lang['View_latest_post'] . '" title="' . $lang['View_latest_post'] . '" border="0" /></a>';

'FORUM_NAME' => $searchset[$i]['forum_name'],

'FORUM_ID' => $forum_id,

'TOPIC_ID' => $topic_id,

'FOLDER' => $folder_image,

'GOTO_PAGE' => $goto_page,

'REPLIES' => $replies,

'TOPIC_TITLE' => $topic_title,

'TOPIC_TYPE' => $topic_type,

'VIEWS' => $views,

'LAST_POST_TIME' => $last_post_time,

'LAST_POST_AUTHOR' => $last_post_author,

'LAST_POST_IMG' => $last_post_url,

'U_VIEW_TOPIC' => $topic_url)

);

}

$template->assign_vars(array(

'PAGINATION' => generate_pagination($base_url, $total_match_count, $per_page, $start),

'L_AUTHOR' => $lang['Author'],

'L_MESSAGE' => $lang['Message'],

'L_REPLIES' => $lang['Replies'],

'L_VIEWS' => $lang['Views'],

'L_POSTS' => $lang['Posts'],

'L_SUBJECT' => $lang['Subject'],

'L_GOTO_PAGE' => $lang['Goto_page'])

//

// Search forum

//

FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f

ORDER BY c.cat_id, f.forum_order";

$result = $db->sql_query($sql);

}

$template->assign_vars(array(

'L_SEARCH_AUTHOR' => $lang['Search_author'],

'L_SEARCH_ANY_TERMS' => $lang['Search_for_any'],

'L_RETURN_FIRST' => $lang['Return_first'],

'L_SORT_BY' => $lang['Sort_by'],

'L_SORT_ASCENDING' => $lang['Sort_Ascending'],

'L_SORT_DESCENDING' => $lang['Sort_Descending'],

'L_FORUM' => $lang['Forum'],

'L_TOPICS' => $lang['Topics'],

'L_POSTS' => $lang['Posts'],

'S_SEARCH_ACTION' => "search.$phpEx$SID&amp;mode=results",

'S_CHARACTER_OPTIONS' => $s_characters,

'S_SORT_OPTIONS' => $s_sort_by,

'S_HIDDEN_FIELDS' => $s_hidden_fields)

);

$order_by = $sort_by_types[$sort_by] . ' ' . ( ( $sort_order == 'a' ) ? 'ASC' : 'DESC' );

$where_sql";

$result = $db->sql_query($sql);

);

$template->assign_vars(array(

'PAGINATION' => $pagination,

'L_ICQ_NUMBER' => $lang['ICQ'],

'L_MESSENGER' => $lang['MSNM'],

'L_YAHOO' => $lang['YIM'],

'L_SORT_BY' => $lang['Sort_by'],

'L_SORT_ASCENDING' => $lang['Sort_Ascending'],

'S_SEARCH_ACTION' => "search.$phpEx$SID&amp;mode=searchuser&amp;field=$field")

);

LIMIT $start, " . $board_config['topics_per_page'];

$result = $db->sql_query($sql);

$profile = '<a href="' . $temp_url . '">' . $lang['Read_profile'] . '</a>';

$template->assign_block_vars('memberrow', array(

'USERNAME' => $username,

'JOINED' => $joined,

);

$i++;