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

[Boofo]

You know, attacking my mascot (the mouse) is not nice, young lady. And he's not "flapping", he's dancing. His twin brother is on the vBHome Lite page (www.bearfacts2.com).

The central search section is because I added the MySQL 4 Search hack (here at vb.org). If you are running MySQL version 4 on your host server, you can run this hack, too.

I can pm you the instructions for my search setup if you want them. The part for the code without the lines is in there, too. Jump on the site and pm me if you want it, and I will get it to you.

[Talisman]

Today at 12:03 AM Boofo said this in Post #151
His twin brother is on the vBHome Lite page (www.bearfacts2.com).

Oh sure...... like having one freaked out rodent at the site's not weird enough, you've got to have two of them.



(I'll be right over.)

[Boofo]

You need to turn on private messaging on the site or I can't send you anything.

[Talisman]

(Hehe.... what an impatient fella, he is.)

[Talisman]

I really appreciate your help, Boof. I guess the problem is something to do with how my database tables are set up or the way my query is running..... maybe?

When I installed the hack, I moved the columns and variables around like they did at this site ..... (it's a nicer layout). Looks like you did the same thing in the code you sent me. Only you figured out how to also get rid of the lines (which I couldn't do).

Just to be sure, though, I threw out my formatting changes and overwrote that portion of my code with yours. (Thankfully, we didn't pick up any stray hairs from that jumping rat you hang out with.) :cheeky:

Even so.... the search list indexing still doesn't work the same way at my site as it does at your site. Even when this part of our php file and our template were the same for this hack. So I guess that leaves the database as the place to check, right? Or maybe there's some other instruction further up in the search.php file that has an affect on this? (I am using an older vB 2.2.6...... but then, this hack has been out for a while, too.)

You can see how the search list is displayed in the screenshot I attached here. I put a red mark by the ones I searched for a second time. See how the date was overwritten? And these two items stayed on the list in the same position. They didn't repeat and didn't move up to the top like yours does.

And when I searched again for a keyword that's already dropped off the list ..... it didn't show up at all.

[Boofo]

That's how it is supposed to work. That's how it works on my site. The only way it will add a new entry on the list for a word that is already on the list is if the amount of posts that has that word in it has changed. Go ahead and make a test message with one of the words on the list in it and then do another search for that word and you will see what I mean.

[Talisman]

No, it doesn't. That's what I checked there last night.

Go look at your search list now and you'll see the keyword search for "testing" is listed three different times..... and always in the order in which it was searched.

At my site, the previous instance gets overwritten. And it won't show at all if it's something that has been on the list previously.

[Talisman]

Hey..... I see now. Those "testing" searches did show up again because there were new posts in the result that weren't included in the earlier searches.

I just went there and picked a different keyword already on your list. No new posts have been made containing the word "mouse," (lol..... no wonder?) ..... so it didn't need a new entry. Just changed the date/time.

[Boofo]

I just looked at it and the amount of post matches is different for each instance of "testing". When I was testing it yesterday, the only thing that was changing for a word that was already in the list, was the time was being overwritten if I searched for a word that was already on the list, which is what it should do instead of having the same word listed over and over.

[Boofo]

LOL We wrote at the same time. Is that how you wanted it to work?