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.

[Imprezer]

Great hack!
Works great!
Thanks!

- Alex

[FWF]

nice hack

[Onkel_Tom]

Hi Boofo, my old friend, very nice Hack !
clicked install

thank your

[cteselle]

vb is also only showing the last hour of searches for me. This was on a fresh 3.0.3 install on my test board. So I did some investigating. I figured I would start at the scheduled tasks, so I took a look at the "Hourly Cleanup" entries. In the file ./includes/cron/cleanup.php I found:

PHP Code:

//searches expire after one hour
$DB_site->query("
    ### Remove stale searches ###
    DELETE FROM " . TABLE_PREFIX . "search
    WHERE dateline < " . (TIMENOW - 3600)
); 


I have not tested this yet, but I don't know why it wouldn't work. You could change the 3600 to whatever you want to get the desired result. 86400 for 1 day, 604800 or 1 week, etc.

If I have problems I will report back.

[Boofo]

Originally Posted by cteselle

vb is also only showing the last hour of searches for me. This was on a fresh 3.0.3 install on my test board. So I did some investigating. I figured I would start at the scheduled tasks, so I took a look at the "Hourly Cleanup" entries. In the file ./includes/cron/cleanup.php I found:

PHP Code:

//searches expire after one hour
$DB_site->query("
    ### Remove stale searches ###
    DELETE FROM " . TABLE_PREFIX . "search
    WHERE dateline < " . (TIMENOW - 3600)
); 


I have not tested this yet, but I don't know why it wouldn't work. You could change the 3600 to whatever you want to get the desired result. 86400 for 1 day, 604800 or 1 week, etc.

If I have problems I will report back.

Mine have always only showed for 24 hours with vB3. Please keep me posted on what you find out with this.

[j_86]

I am getting this error;

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT search.searchid,search.orderedids,search.dateline,search.query,search.userid,user.username,user.userid,user.usergroupid FROM vb3_search,vb3_user WHERE query!='' AND user.userid = search.userid AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,15
mysql error: Unknown table 'search' in field list

mysql error number: 1109

Date: Saturday 17th of July 2004 12:16:03 PM
Script: http://forum.ugamer.net/search.php?
Referer: 
Username: S------
IP Address: -----------

Any ideas why?

My table prefix is vb3_

I'm running 3.0.3

[Boofo]

JimpsEd,

Change to following queries. They will add the table prefix for you.

Change:

PHP Code:

$querycount=$DB_site->query_first("SELECT COUNT(*) AS orderedids FROM " . TABLE_PREFIX . "search LEFT JOIN " . TABLE_PREFIX . "user USING (userid) WHERE query!='' AND usergroupid NOT IN (5,6,7)"); 


to:

PHP Code:

$querycount=$DB_site->query_first("
SELECT COUNT(*) AS orderedids FROM " . TABLE_PREFIX . "search AS search
LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid)
WHERE query!=''
AND usergroupid NOT IN (5,6,7)
"); 


Change:

PHP Code:

$lastsearches=$DB_site->query("SELECT search.searchid,search.orderedids,search.dateline,search.query,search.userid,user.username,user.userid,user.usergroupid FROM " . TABLE_PREFIX . "search," . TABLE_PREFIX . "user WHERE query!='' AND user.userid = search.userid AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,15"); 


to:

PHP Code:

 $lastsearches=$DB_site->query("
SELECT search.searchid,search.orderedids,search.dateline,search.query,search.userid,user.username,user.userid,user.usergroupid
FROM " . TABLE_PREFIX . "search AS search," . TABLE_PREFIX . "user AS user
WHERE query!=''
AND user.userid = search.userid
AND usergroupid NOT IN (5,6,7)
ORDER BY searchid desc LIMIT 0,15
"); 


That should fix it for you.

Make sure to click install.

[j_86]

Thanks for the tips

But, unfortunatly nothing is showing at all - just nothing.

Even from a clean install of your mod with your changes (and yes, template stuff correct);

http://forum.ugamer.net/search.php?



Not even an error message. ( I have also testing searching as regular user, and also turning off User Group *not** 7,6,5

[Boofo]

Originally Posted by JimpsEd

Thanks for the tips

But, unfortunatly nothing is showing at all - just nothing.

Even from a clean install of your mod with your changes (and yes, template stuff correct);

http://forum.ugamer.net/search.php?



Not even an error message. ( I have also testing searching as regular user, and also turning off User Group *not** 7,6,5

You had to miss something somewhere. Re-check the hack and make sure you didn't miss anything. And also remember, the search listing will not show up until there is at least one successful search made.

[j_86]

Still definetly not working :surprised:

I cannot understand, i've resinstalled the hack, even installed it on a blank forum install.

Attatched is my Search.php and Template file if you can see anything wrong. The Search Template is a reverted one, with the hack added. The same goes for the search.php file, only with your above query modifications.

I have tried rebuilding search indexes etc.