vB3 15 Most Recent Searches Made By Our Members

vB3 15 Most Recent Searches Made By Our Members
Version 1.1
(By Boofo and EvilLS1)

What does this hack do?
This hack 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. The Admin, Supermod and Mod searches will not show up in the listing. It is done this way so any searches made in your private forums are not shown to the regular members.

Credits:
A big thank you goes out to AntiOnline for his original "Last 10 Searches" hack for vB2, partly on which this hack is based.

Version Information:
Version 1.0 --Initial release
Version 1.1 --Re-did the template code to make it match the default style a little better and also added the ability to collaspe the table.

Installation overview:
Files to edit: (1)
--search.php
Templates to edit: (1)
--search_forums

For those wanting the HTL file for this, thanks to Frank, you can get it from this post.

The first image is what the other members will see and the second image is what the Admin will see.

[djohn]

Any way to limit the number of recent searches to, for example 5? 15 is way too much for me

[lokki]

This is what I'm trying to reduce the number. If this is in error or incomplete, I'd really appreciate a correction!

in search.php find:

if ($numqueries > 15){
$numqueries = 15;
}

and replace both 15s with whatever you like.

then find:

$lastsearches=$DB_site-> (SNIP) ORDER BY searchid desc LIMIT 0,15");

and change that, too.

[Boofo]

Originally Posted by djohn

Any way to limit the number of recent searches to, for example 5? 15 is way too much for me

lokki's partly right, but all you really need to change is this part of the query:

LIMIT 0,15

Change ther 15 to whatever you need and that's all you need to change.

You also need to click the install button.

[djohn]

yep, thanks, you got it
/me clicks install

[Boofo]

You're very welcome, sir.

[milkmycow]

does this work with gold?

[Alien]

Yes.

[Boofo]

Thanks, Jason.

[Alien]

No thanks necessary, I love it!

[Boofo]

It's people like you, Jason, that make coding hacks like this a pleasure. I wish more people felt like you do about hacks here. Thank you, again.