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.

[chapsrulez]

Originally Posted by Boofo

I don't use these tables in any of the queries. You might want to check the code again.

forosearch
forouser

"foro" is my table prefix.

[gcurrey]

Boofo - Great mod! Do you have some php code that can be run to view ALL searches done which the admin can install/hide somewhere separately from the VB output to keep track of all searches? Maybe this admin version could have a text box so you can specify the amount of entries to display.

[qxh]

Yeah tables with a prefix have problems with this hack.

[cybermomcafe]

I can't get it to work... i use vb3_ as my table prefix... any way to make it work?

Thanks!!

Here's the error I get...

Database error in vBulletin 3.0.3:

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

[cybermomcafe]

I got it to work...

I changed the SELECT query (line 14 of the part to be added to search.php) from:

$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 (the table prefix on my board is vb3_)...

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

I removed the usergroups, because I wanted mod/admin searches to show.

I also wrapped the search_forums template edit with this conditional, because I wanted only Admin to see the recent searches.

<if condition="$bbuserinfo[usergroupid] == 6">

</if>

thanks Boofo!

[cybermomcafe]

One more question... Is there some sort of time limit that the most recent searches are cached for?

When I tested it around 8pm it listed like 4 searches, now it's a bit after 10 and they aren't listed any more?

Thanks!

[Boofo]

Originally Posted by cybermomcafe

I can't get it to work... i use vb3_ as my table prefix... any way to make it work?

Thanks!!

Here's the error I get...

Database error in vBulletin 3.0.3:

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

Try this query:

PHP Code:

$lastsearches=$DB_site->query(" 
SELECT search.searchid,search.orderedids,search.dateline,search.query,search.userid,use    r.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 
"); 


[weirdpixels]

*clicks install
thats now 100 installs well done

[kenji4861]

Works great on VB3.0.3 THANK YOU!

[Boofo]

Originally Posted by kenji4861

Works great on VB3.0.3 THANK YOU!

Don't forget the install button.