############################################################## 
## MOD Title: 		Last Search Queries
## MOD Author: Xpert < xpert@phpbbguru.net > (N/A) http://www.phpbbguru.net/
## MOD Description: 	This mod shows last search queries on search page. 
## MOD Version: 	1.0.4 
## 
## Installation Level: 	Easy 
## Installation Time: 	5 Minutes 
## Files To Edit (3): 	search.php
##			lang_main.php
##			templates/subSilver/search_body.tpl
##			
## Included Files: 	n/a
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/ 
##############################################################
## Author Notes: 
##
## Since version 1.0.4 mod works only with phpBB 2.0.20 or better.
## 
############################################################## 
## MOD History: 
##
##	2006-05-09 - Version 1.0.4 
##	- Fixed wrong result issue (1.0.3 affected only).
##	- Results are now returned as topics (thanks to ferdinand).
##
##	2006-05-01 - Version 1.0.3 
##	- Mod updated for phpBB 2.0.20
##
##	2006-03-21 - Version 1.0.2 
##	- How-to update for MODDB
##
##	2006-01-01 - Version 1.0.1 
##	- Fixed an issue with quotes.
##	- Added links on to search last queries (thanks to Sergey aka Porutchik)
##
##	2005-11-17 - Version 1.0.0 
##	- Initial Release
## 
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 

#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE `phpbb_search_results` ADD `search_query` VARCHAR( 100 ) NOT NULL ;

#
#-----[ OPEN ]------------------------------------------
#
search.php

# 
#-----[ FIND ]------------------------------------------ 
# 
$show_results = ( isset($HTTP_POST_VARS['show_results']) ) ? $HTTP_POST_VARS['show_results'] : 'posts'; 

# 
#-------[ REPLACE WITH ]------------ 
#
// [begin] Last Search Queries 1.0.4 
if ( isset($HTTP_POST_VARS['show_results']) || isset($HTTP_GET_VARS['show_results']) ) 
{ 
   $show_results = ( isset($HTTP_POST_VARS['show_results']) ) ? $HTTP_POST_VARS['show_results'] : $HTTP_GET_VARS['show_results']; 
} 
else 
{ 
   $show_results = 'posts'; 
}
// [end] Last Search Queries 1.0.4

#
#-----[ FIND ]------------------------------------------
#
		$search_id = mt_rand();
		
#
#-----[ AFTER, ADD ]------------------------------------------
#
		// [begin] Last Search Queries 1.0.4
		$search_query = trim(str_replace("\'", "''", $search_keywords));
		// [end] Last Search Queries 1.0.4

#
#-----[ FIND ]------------------------------------------
#
			SET search_id = $search_id
			
#
#-----[ IN-LINE FIND ]------------------------------------------
#
$result_array) . "'

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, search_query = '$search_query'

#
#-----[ FIND ]------------------------------------------
#
			$sql = "INSERT INTO " . SEARCH_TABLE . " (search_id
			
#
#-----[ IN-LINE FIND ]------------------------------------------
#
, search_array

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, search_query

#
#-----[ FIND ]------------------------------------------
#
				VALUES($search_id
				
#
#-----[ IN-LINE FIND ]------------------------------------------
#
$result_array) . "'

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
, '$search_query'

#
#-----[ FIND ]------------------------------------------
#
//
// Output the basic page
//

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// [begin] Last Search Queries 1.0.4
$sql = "SELECT search_query FROM " . SEARCH_TABLE . " WHERE search_query != '' ORDER BY search_time DESC LIMIT 5";
$result = $db->sql_query($sql) or message_die(GENERAL_ERROR, 'Could not obtain last queries info', '', __LINE__, __FILE__, $sql);

if ($db->sql_numrows($result))
{
	$last_queries_arr = array();
	while( $row = $db->sql_fetchrow($result) )
	{
		$last_queries_arr[] = '<a class="gensmall" href="' . append_sid("search.$phpEx?mode=results&amp;show_results=topics&amp;search_keywords=" . urlencode($row['search_query'])) . '">' . htmlspecialchars($row['search_query']) . '</a>';
	}
	$last_queries_info = implode(', ', $last_queries_arr);
}
else
{
	$last_queries_info = $lang['No_last_search_queries'];
}
// [end] Last Search Queries 1.0.4

#
#-----[ FIND ]------------------------------------------
#
	'S_SORT_OPTIONS' => $s_sort_by,
	
#
#-----[ AFTER, ADD ]------------------------------------------
#
	// [begin] Last Search Queries 1.0.4
	'L_LAST_SEARCH_QUERIES_INFO' => $lang['Last_search_queries_info'],
	'LAST_SEARCH_QUERIES_INFO' => $last_queries_info,
	// [end] Last Search Queries 1.0.4
	
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
?>

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// [begin] Last Search Queries 1.0.4
$lang['Last_search_queries_info'] = 'Last queries';
$lang['No_last_search_queries'] = 'No queries';
// [end] Last Search Queries 1.0.4

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/search_body.tpl

#
#-----[ FIND ]------------------------------------------
#
		<td class="row2" colspan="2" valign="top"><span class="genmed"><input type="text" style="width: 300px" class="post" name="search_keywords" size="30" />
		
#
#-----[ IN-LINE FIND ]------------------------------------------
#
<input type="text" style="width: 300px" class="post" name="search_keywords" size="30" />

#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
<br /><span class="gensmall">{L_LAST_SEARCH_QUERIES_INFO}: {LAST_SEARCH_QUERIES_INFO}</span>

# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM