Detailed Statistics?

[gorcutt]

Is there a place where statistic data about access can be extracted? I'm looking for info about date, pictures and albums seen, originating IP or domain etc. If not, it's easy to a PHP newbie to implement these features?
Thanks for reading.

[Tranz]

All the data is in the MySQL database. So, yes, it should be possible to pull statistics out.

[gorcutt]

All the data is in the MySQL database. So, yes, it should be possible to pull statistics out.

I'm browsing the tables generated in the database and can't find this information. I'm looking for some analytical data like date, time, originator IP, album and picture. What am I missing?

[Tranz]

The bulk of the information is in cpgprefix_pictures table.

I just reread your first post and I think I overlooked a key word 'seen'.

You want to track the viewing habits of viewers? You would then need to look at your server's raw logs and use a log analyzer.

Please describe exactly your needs.

[gorcutt]

Thanks for the reply. Yes, I want to analyze how many hits a given picture or album receives during a period. The apache logs has all this information but very hard to use as the images and albums are not organized in a logical way. What I mean is if the structure of directories was like 'catalog/album/pics' it would be easy to filter this information from the raw logs, but the data that defines if a picture is from album 'A' or 'B' is in the database, so not shown on the HTTP GET statement. Sorry, but sometimes I feel hard to express myself in English in a way to make things clear, I hope you got my point.
I'm not good in PHP, but with some help maybe I could write a simple statement that can write this sort of information in some table or text file.
Thanks again.

[Tranz]

I guess in that case you could just output your own 'logs'. All the server logs do is capture data that you can get via PHP server variables. So, you would then 'log' activity in a flat (text) file instead of a database. If you make your own 'log' you could presumably use whatever variables you want, like album name, IP, etc.

Then to do analysis, develop a database to read the fields that you record.

I just don't know what affect this would have on CPU processing, and if it would slow down your page.

[gorcutt]

I'll try to code something and see if it works.
Thanks for the help

[Tarique Sani]

Detailed stats recording has been added to the CVS version and is admin settable - however only 2 reports are available at the moment - Vote details per picture (how many of what rate)  and visit details. Since the data is recorded you can create more complex reports from it

[gorcutt]

Yesterday night I was thinking in start to give a look on the source codes but I have to confess that this would not be an easy task to me. Thanks a lot for the very good news.