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

[Admin]

The result number is the number of posts + clicking the link searches for threads = your explanation.

[Tim Wheatley]

If you are worried about private forums etc, and are in the same situation as me where the only forums which need the ability to search are the public ones, simply disable searching for admin and mods of the private forums, that way no private posts can be found in any hole in the scripts, because no private posts will ever be searched.

I'm personally not too bothered, the private game editing forums on my forums are all search disabled and hidden too, normal users can get NO access. But even if they could it's no biggie.

[TheCaver]

Has the performance issue with this hack been resolved?

TIA!

JC

[99SIVTEC]

Hmm any idea why it isn't showing anything on my site? I'm using 2.2.4 http://www.sportcompactracing.com/vbulletin/search.php

[Xanthine]

It isnt showing for me either, Using 2.2.5. I have the table there just the posts arent appearing. Anyone know whats going on?

[Xanthine]

Nevermind I just noticed it does not display mods/admins searches, thanks for the hack

[akaler]

Thanks for the great hack.

I had some problems, too. I just installed this on my vb 2.2.5 board, and nothing was showing for me. I tried logging out, logging in as a normal user, using the vb as a guest, etc. Nothing. Then I read through all the messages carefully, and found the original $lastsearch= code. I changed

$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');

to the original

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

Then EVERYTHING appeared.

I then reverted it back to the new code... and bam... it continued working.

As I see a lot of the people here had the original code, then updated it to the security corrected code... I think there might be some issues for brand new installs. Something overlooked.

Also, searches by guests don't show with the security corrected code. Only ones made by normal users. Is that normal?

[nuno]

heh thx akaler that one was a huge tip man :-)
nice hack AntiOnline

[Legacy]

GJ..installed on 2.2.5 not to many problems as long as you read all these threads carefully

GJ...thx

[Crazy Mofo]

how can you make it like here so it doesnt show the black lines?