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

[David Bott]

Originally posted by TheCaver
Has the performance issue with this hack been resolved?

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?

[AntiOnline]

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

[David Bott]

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?

[Kars10]

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, ....
Thanx for youre support.
And please excuse my bad english!!

[Kars10]

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

[Keyser S?ze]

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?

[Admin]

Change the LIMIT 10 in the query to LIMIT 5.

[Keyser S?ze]

Originally posted by patvdv


Mone, it's working great for me. What erros are you getting?

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>";

[Boofo]

Mone',

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

Originally posted by Mone'
hack work perfectly !


patvdv your code is giving me error can you check your code as i'd like to have your layout

Mone'

[87GTR]

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

$lastsearchresultscount=sizeof($lastsearchresultscount);
 $lastsearchresultscount=$lastsearchresultscount-1;