Last 10 Searches

Greetings All:

Updated 3/11/2002: Hack now shows the date and time each search was made, plus the number of results. Also included is the security fix by firefly (thanks).

Updated 3/8/2002: It now also links those search words to the previous search results.

Here's just a little fun feature that I added for my users, and thought that I would share with everyone else. It works with versions 2.03 and up, requires no modifications to your database, and should take less than 2 minutes to install:

This hack displays the last 10 searches made by your users on your main site search page. It uses your censor options to make sure nothing naughty shows up (unless, that is, you want it to).

Demo at http://www.AntiOnline.com/search.php

Enjoy!

Yours In CyberSpace,
John Vranesevich
Founder, AntiOnline

[Intex]

Installed and works fine - just make sure you set the correct usergroup ID's dependent upon who you want to list search results for, whilst taking into consideration the security implications.

[high]* Intex clicks install .[/high]

[0ptima]

I installed it on 2.3.0

[neocorteqz]

12-25-02 at 07:05 PM Da`Nacho said this in Post #124
Just so everyone knows, I think this was fixed in vBulletin 2.2.8 so that permissions are checked before sending the user the search results. I've checked on my forum and search results matching threads said user doesn't have access to no longer seem to show up. As a result I have removed the 'not in 5,6,7' part of the hack on my forums and things are working peachy.

Nice, thanks for letting us know that.

I'd also like to know if it's possible to list which user searched for what.. For admins only of course.

[Doubledoom]

installed on 2.3.0 and removed the NOT IN part and permissions are working fine.

Thanks.

[:Judge:]

I had trouble at first tryin to edit www/search.php

I figured out that I needed to edit www/forums/search.php so it is workin now like a charm.

I don't know if I missed something here but this does not look like the last 10 searchs here, mine is pretty big.

The last 10 takes up alot of space on the page, anyway to slim it down some?

Might help if I add a link
http://www.planetquintessa.com/forums/search.php?

[OmaniMan]

Great :cheeky: ,,
WellDone :bandit: ,,
Wish You The Best ...

[S.Shady]

get it working on 2.3.0 any one ?

[OmaniMan]

Yes S.Shady,,
It works with me easily ...

[S.Shady]

04-22-02 at 06:59 AM 212rikanmofo said this in Post #64
this hack doesnt show up anything for me when i use

$lastsearches=$DB_site->query('SELECT searchid,postids,dateline,querystring FROM search LEFT JOIN user USING (userid) WHERE querystring!="" AND usergroupid NOT IN (5,6,7) ORDER BY searchid desc LIMIT 0,10');

but it shows up when i use:

$lastsearches=$DB_site->query('SELECT searchid,querystring FROM search WHERE querystring!="" ORDER BY searchid desc LIMIT 0,10');


what gives??? and how come it doesnt display the user who ran the search like on here?

I have the same thing here and im on vB 2.3.0. Also on my board it says the date as 12-31-1969 at 07:00 PM

screen shot of my board is in attachment.

@ OmaniMan > can you pm me what you have in your search.php that you added ?


[edit] nvm i got it to work. How? i don't know lol but its working fine. Thanks for the great hack

[mmmender]

works great for me, thanks! 2.2.9