I am sorry to answer this with a NO for large sites. Not sure why, as it onmly seems to add 1 query....but it must be a big one. So...Why does it kill the server on large sites? Anyway around this?

Dave:

We have over 90,000 registered members, and get around 6-7 million page views / month, and we've had no performance problems from this hack.

Although, we do run the site off of a dedicated Sun Enterprise 450 =x

Thanks for the reply...

http://www.avsforum.com see 30,000 unique visitors a day and we run the site off of two Dell Poweredge 2550 server's. Each have two 1 ghz processors, 2 gigs of RAM, and are both run a 128 meg RAID 5 controller (3 - 10,000 RPM SCSI-3 drives). One server is for web, the other for DB. (another server also for ads.)

Not sure what to say...but we have over a million posts and do about 12.5 million page views a month. I do not think the user count matters as much as the posts in this case. As I write this there are 714 members on-line.

I would love to use this with our forum...but when I press the button to got into the search area...It just takes so long and server load goes up.

Anyone, anyone....Buler, Buler?

Greetings all: very easy to install and very effectiv....if it works. But i had a Problem with it.
My searchresults are displayed but the last one was on 5.6.2002 0.19 . The hack where installed on 12.00 today. I made many searches but nothing whered displayed.
what can i do, .... :confused:
Thanx for youre support.
And please excuse my bad english!! ;)

Sorry, vorget about it. It works!! Some Stupid Mistake from me... :D

how can i change it so it displays it like this results - query - date

also, can i set it to only display the last 5 not 10?

Change the LIMIT 10 in the query to LIMIT 5.

also getting this error Parse error: parse error in /usr/home/emusa/emusanet.com/public_html/forums/search.php on line 225


this is line 225 lend."</tr>";

Mone',

Did you ever get an answer to this question or get it figured out? I'd like to know myself. :)

all of my past search where showing 1 more than the result so I just added this line and now they are ok

This is a great help to me. Thanks!

I'm wondering about making it possible for admin to see the users on this page? (Or have a page just for admin to see the searches?)

I have an ex-moderator who has been spending hours each day searching our forums. She left under unhappy circumstances (I caught her attempting to do other things in the control panel, underhanded things...... :( ) and now I'd like to know what she is spending her days "searching".

I'd like to just turn off her ability to search. Is that possible to turn one member off from ability to search the forums? In the meantime, this hack will help me to see what she is searching for...I think!

One more question abuot this hack. If a person searches the forum by "membername" does this search show up? All I see are "keywords" and I think I might be interested in seeing (atleast for a while...) the membernames that are being searched.

Thanks!

Installed on 2.2.6, running well. Thanks! :D

Is there anyway of having the "username" searched show up on this list? You know...not the keyword but the username (not the one who is searching but the username that is being searched).

This would really help me out for a while....

Thanks!

My searches aren't showing on the page. Hmmmm.

Admins' and mods' searches do not appear.

cool hack.

i modified it so that everyone's searches appear (including mods and admins).

roxie, you can do that by removing this from the hack modification:

great modification, thank you :)

regards,
Schorsch

Great Hack!

Thank You ... Clicking Installed

Destee

I've installed this, but will it be possible for someone to code up the look to resemble the mods done by Chen for vB.org's last 10 searches?

Works a treat with 2.2.7. Cheers. :D

You do realize that by doing this people can view your admin forums, right??? Or at least the threads from that forum returned in the results...

Mine shows quantity 1 more than actual amount of results. So if it shows 3, there are always 2.

Using 87GTR's suggestion on page 6 of this thread works, but now shows 1 when there are indeed no results. So if it shows 1 result and you click on it, there could be either 1 or none. Very weird.

Working great on 2.2.7!

5 Stars...

Nice hack, Thanks.

And i don't think you want to have Mods and admins searches shown...unless there is a way of checking user permissions in the search(if the user is an admin or mod then it shows All post by the admin or mod). IMO, a serious flaw in security.

I discovered that quite awhile back. Before i took over the Current forum (yes you know which one:p ;)) A mod posted a Search on a Admins post and I saw every thread in the private mods forum. with a small bit of his post.

Working like a dream with 2.2.8. Thanks again! :)

Gamer:mad: - https://vborg.vbsupport.ru/showthrea...&postid=316171

Satan

LOL
All the posts in full releases either has working, or 2.2.8, or 2.2.7

-Arunan

Indeed...

Please stop Gamer...

Satan

At least DrkFusion had the sense to PM me rather than posting in every thread behind me - which I'm quite unlikely to read. Fear the brain power!

You read most of the replies, so it wasn't unlikely you were going to read them :p

I only read them because I got the PM from DrkFusion and saw how many times Satan had decided to post!

Thanks will try it.

working on 2.2.9 thx!!!

Strange, its not really working for me. After I installed, one search showed up under latest searches, so I thought it was working. However, whenever I search something, it doesnt update the search list, it only shows the same one.

any ideas?

Chris,

Installed on 2.2.9 :)

;)

Nevermind I just noticed it does not display mods/admins searches

I just made a search as admin in a private forum and then logged in as a regular user, tried to view the results of the search i just did by using the search id and it didn't show up any results. However, when i went back to the search page I could see which query has been run and how many results were returned.
Some of those security issues were apparently solved, but not every one of them as it seems.
The regular user can still see what an admin/mod was looking for and how many results were returned, although you don't see the actual results. This is not necessarily a security issue, but a privacy issue.
Let's assume the following: An admin searched for "ban AND user x", the reason why he did this is not really relevant, as this scenario is hypothetical. Now user y finds out that there was this search and that several results were returned, he tells this user x and user x makes it public.

Now what? Or am I just being paranoid?

Icheb

Hey FireFly, you might want to check me on this one...

I looked into this because I have not been able to see any searchs that I am performing.. Based on the below quote from the MySQL manual:

If the search was performed by a guest which has an account value of "0", it tries to do the NOT IN which it can not compare to anything because that account does not exist in the user table...

I think this should be a correct query, I have tested here and it is working with no issues:

SELECT searchid,postids,dateline,querystring FROM search LEFT JOIN user USING (userid) WHERE querystring!="" AND (usergroupid NOT IN (5,6,7) OR search.userid = "0") ORDER BY searchid desc LIMIT 0,10

Also, as a note to some people, I had to upgrade my search.php in order the get the links created correctly so other users could access them. Otherwise, I got a user is not authorized message.

Enjoy this info folks.... !!