[freddy]

I recently edited the pod.cgi 'logging' subroutine. Our search log was filling up to rapidly yet I still want the data. So I went to:

print WRITEIT "$datej|$pod_searchwords\n";

AND CHANGED TO:

print WRITEIT "$pod_month_day| $pod_searchwords\n";

Which now only displays the day -aka- 04,05,06 that the words were searched. I also TIME STAMPED the log. I downloaded it, wiped it clean, and placed 01 Nov 2001| DATE STAMP 0415 HOURS in the first line. I'll do this once or twice per month.

Thanks to BerKa's earlier fix I've been able to turn the logging back on. It was really filling up to rapidly before then. Just wanted to share this with my fellow 'podiacs'...

freddy

Side note: Can someone tell me how to buld a database with the search words only (dates would be great too but I'm not greedy). I want to be able to show how many times a certain word (or phrase) had been searched in decending order. I would like a way to turn a 'podsearch log' text file into a database that will count and tally the words. Alphabet order would be a plus...

Trust your ad to See My Ad.Com - www.seemyad.com

[BeRKA]

About the searchword database:
This is how I made a top-10 list at my site. (quick and dirty)
I modified the script that showed the latest searches that I have posted earlier.
(The minimum modifications needed are that the script outputs every line in the log.)
Save the output, and use a texteditor with "text statistics" to count the words.

A more elegant solution would be to have a perlscript to automatically generate
the list from the database, but since I don't have that much traffic yet, I have not
thought it was worth the effort. (Maybe later...)