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

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.

Has the performance issue with this hack been resolved?

TIA!

JC

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

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?

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

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?

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

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

GJ...thx

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