I know it must have been many years since you must have thought out this.

I have found your code helpful in allowing me to setup icecast log parsing.

For future stumblers there is two major bugs that needs to be corrected/addressed:

1. If a log file has 199 lines, this code will only capture the first full 100 entries as the insert is only done under the "if hits_counter == HIST_PER_QUERY" section.

2. The "values_to_insert" array needs to be cleared after an insert. if not, you will be compounding duplicate entries.