[Wayne Luke]

Originally posted by Fred
How do you know how many searches were made in a day?

Luke, do you make the hacks or does someone at your forums do it?

You can get this info by running a SQL query..

This is for Yesterday.

select count(*) from search where dateline > UNIX_TIMESTAMP('2001-08-14') and dateline < ('2001-08-15')

Or since the Search table only holds the search info for the last week you can do something like:

select (count(*)/7) as average from search

I write most of my own hacks though I do have a few from here installed at SPF. I do take suggestions from my forum Members on features but implement it myself.