Have a list in AdminCP of what people have searched for.

[JTMON]

And show the search phrase in who's online. This would really rock for me as I would like to know what they search for.

[Steve Machol]

That's a neat idea. Me likes!

[OMG - I've been Jakemanized!!!! :eek: ]

[FWC]

Originally posted by smachol
That's a neat idea. Me likes!

[OMG - I've been Jakemanized!!!! :eek: ] I'm not worrying until you start tossing cream pies, Steve. :D

[Steve Machol]

[QUOTE]Originally posted by FWC
I'm not worrying until you start tossing cream pies, Steve. :D

[FWC]

Originally posted by smachol
If that happens I've given my wife orders to shoot me! ;) Yes, that would be the only prudent course of action. :)

[Admin]

This would be very cool (and even easy), but there's one big problem.
Searches expire after one week.

[JTMON]

What does that mean? It just needs to create a list and then if you click on that it will redo a search for the same thing. That way even if it expired, you are renewing the search.

[Admin]

You can only see what people have searched for before a week passes, because then the record is deleted from the search table.

But I guess you can add a searchhistory table, that will contain:
- user who searched
- terms of search
- date of search

[JTMON]

Could you write it to another php file or html? That way you don't have to have extra queries on the db and if you click on the search term in the generated list it will just creat a new search for that term

[Admin]

Why writing things to a static file when you have the MySQL database?
Isn't the point of a database to avoid flat files?

[JTMON]

Just didn't know about adding ever increasing server load with all these hacks.