The Arcive of Official vBulletin Modifications Site.

vB3.5 15 Most Recent Searches Made By Our Members · **Released**: 08-28-2005

vB3.5 15 Most Recent Searches Made By Our Members
Version 1.0.4
(By Boofo)

What does this product do?
This product will display the last 15 searches made by your members on your main site search page at the top. The search words are then linked to those search results. It uses your censor options to make sure nothing bad shows up. The searchee will also be visible, but only to Admins. The search box will only show up when searches have been made. Searches made in your private forums are not shown to members who do not have access to those forums. It is now fully permissions based.

Version Information:
Version 1.0.0 --Initial release
Version 1.0.1 --Fixed error for new sites when the search table was empty.
Version 1.0.2 --Product is now fully self-contained. No more need for a template edit. Also changed the product name.
Version 1.0.3 --Fixed search template from repeating itself on each subsequent search.
Version 1.0.4 --Fixed searchee name being blank on a guest search.

Upgrade Instructions:
1. You MUST un-install the old product before upgrading due to the product name being changed.
1. Go to the "search_forums" template and remove "$last15searches" (sans quotes).
2. Install the product.

Credits:
A big thank you goes out to EvilSL1 for co-authoring the vB3.0 version, on which this hack has been converted.

Installation overview:
----------------------------
Products to install: (1)

poliveira · #**102** 10-06-2005, 11:42 PM

Quote:

Originally Posted by Boofo

It's showing fine at the top of your Advanced search page.

I see it now! thanks.

Another question.
How difficult is it to move the "recent queries" results for use in vbAdvanced?

Boofo · #**103** 10-07-2005, 12:05 AM

Quote:

Originally Posted by poliveira

I see it now! thanks.

Another question.
How difficult is it to move the "recent queries" results for use in vbAdvanced?

I have no idea as I don't use vbAdvanced. I'm sure you would probably have to duplicate the code for that and it really wouldn't be worth it as the search table empties every hour on the hour.

rezovor · #**104** 10-07-2005, 12:29 AM

Nice Hack
*installs*

vibe · #**105** 10-09-2005, 06:33 AM

great mod

Julie · #**106** 10-10-2005, 08:18 PM

Brilliant!

Thanks!

*installs*

TundraSoul · #**107** 10-12-2005, 12:21 AM

Hi,

I just installed and a few minutes later started getting these errors:

Database error in vBulletin 3.5.0:
Invalid SQL:

SELECT threadid FROM thread

WHERE threadid IN (27799,45961,32517,44111,2044, there's a couple hundred of them.
AND forumid IN ();

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3 Error Number : 1064

Date : Tuesday, October 11th 2005 @ 07:53:17 PM

Script : http://www.tundrasolutions.com/forums/search.php?s=&action=finduser&userid=677

Referrer :

IP Address : 65.54.188.26
Username : Unregistered
Classname : vb_database

TundraSoul · #**108** 10-12-2005, 12:29 AM

Update: All the errors appear to be coming from unregistered user who can use the search.

Boofo · #**109** 10-12-2005, 02:48 AM

I just tried to search on your site and no matter what words I tried, I got the word cannot be found error. I got no db errors at all.

TundraSoul · #**110** 10-12-2005, 03:18 AM

I disabled the plug-in.. but I'll turn it back on so you can try it.

Quote:

Originally Posted by Boofo

I just tried to search on your site and no matter what words I tried, I got the word cannot be found error. I got no db errors at all.

Boofo · #**111** 10-12-2005, 04:05 AM

You're the first that seems to have run into this problem. We will investigate it and report back in here.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07451 seconds Memory Usage 2,308KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!