Miscellaneous Hacks - vB3.5 15 Most Recent Searches Made By Our Members

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)

[Boofo]

Originally Posted by CSS59

how do i remove the usernames so members don't see who serched

The staff is the only one who can see the user names. Regulars users never see them. Look at the 2 pics in the first post.

[Boofo]

Originally Posted by Psionic Vision

Perhaps you should store the data for this hack in a separate table (or a datastore). That's because vbulletin's searches expire and get erased after a certain amount of time, and your hack seems to draw info from there.

If you choose to store things in a separate place, it should have fields: userid (left join usertable for username), keywords, dateline, resulttype, resultcount. It would be easier to store this in a datastore because then you can strip everything that's more than x number that you wanna show without any extra queries. Just a suggestion

We thought about doing that even in the 3.0 version but decided it against it as I wanted to stay with how it had been done since the "Chen" days. On busier boards the list can stay pretty well filled up as there are usually more searches. The only thing it would be good for is smaller boards, I guess.

[SnickersTK]

Originally Posted by cudaxtreme

its in /includes/cron/cleanup.php

//searches expire after one hour
$vbulletin->db->query_write("
DELETE FROM " . TABLE_PREFIX . "search
WHERE dateline < " . (TIMENOW - 2592000) . "
### Remove stale searches ###

change the timing in green

thanks man

[TheBlackPoet]

no errors... i installed it and it works great.. the problem i had is that since it was only a xml, i didnt really read through the dirty details that i've read before on other hacks...
the problem was i didnt know where to go on my test server to verify this hack works...
when i slowed down to re read the instructions it was there... MAIN SEARCH PAGE... SO GO JOB!!

[Spiffware]

whats nice ill hit installed

[nerofix]

sorry for this question, i did install this product but i cant find where it appears o_O

[futuredood]

is their any way to get this to work in the memberinfo page so that it links people with the $post[fieldxx]? (this links people with the same interests)..

[Smitty]

Anyone have this on 3.6?

[Kihon Kata]

Also requesting this on 3.6 Anyone?

[zeropaid]

Just installed and nothing is showing up. I am running 3.5.4.

Do i need to make any changes to the templates?