Stats?

[Anonymous]

Hey PP Gang,

Whilst upgading to PP v1.4, I backed up my database file, and noticed it being rather large. Looking at it, the pixelpost_visitors table is keeping a perminant log of every visitor to hit my site.

What I'm wondering, is there anything that extrapolate the data into something more humanly readable. I'm talking about the likes of Urchin, Webalizer, Http-analyze etc.

Each record contains, date/time, browser, ip, file requested, so it's quite possible to setup something like a program already out there.

If there's nothing out there currently I'll write my own converter so http-analyze and Webalizer can read it (I don't have the time nor skills to write my own stats app)

Thanks,
Wade M

[raminia+]

Yeah! we noticed this and it could make the DB act slowly. We need ideas on this.

[GeoS+]

I've got own stat script for it. AnubisStat - www.anubisdev.com.
I must only speak with main creator of it and maybe we can suply an light version of it for free. It bases on files so it is quite fast.
We will see.

[Anonymous]

raminia: What sort of ideas are you after here???? Features to be placed in it, or ideas on how to code it?

GeoS: I tried checking out your site, but it's not in english so I couldn't get a feel for it.

--Wade M

[GeoS+]

@Guest: Here you get demo of this stats:
http://stats.anubisdev.com/

Now it's in PL, DE, EN, FR, ITA & IND. It won't be hard to translate to other langs.

[raminia+]

the db in visitor table is getting bug. so bug that if you use this for more than a year it will reduce the speed drastically! we should process the visitors info to new tables and then delete them in a scheduled manner.

[GeoS+]

IMHO there should be tables for every month (i.e. called year_month -> 2005_01, 2005_02, 2005_03, etc.) and one global with main stats.

[Anonymous]

GeoS - the Guest was me...never bothered registering an acct here, cheers!

Raminia; GeoS's way is the way I'd plan it as well. Have them broken down per month (any more and it gets messy).

Benefits are that it's only ever 1 month to index @ most, which is going to be nowhere near as heavy as 12 months worth.

Keep the results in a master table and whenever an update is run, look @ the master table to find out where it was up to, and then index from there again.

I'm not running a plog (photolog) 4 the visitors I get, but it would be nice to see who/when/where hits are coming from, how google's indexing the site.

GeoS' program is exactly what I'm talking about, it, in my mind would be perfect if it could some how be intergrated into pixelpost.

Looks like this might be going somewhere!!

[blinking8s+]

i run my blog in a subdomain, and have full stats displayed in both awstats and urchin

[GeoS+]

Originally Posted by blinking8s

i run my blog in a subdomain, and have full stats displayed in both awstats and urchin

Not everyone have such possibility :P
I have own script (Anubis), Urchin, AWstat, Webalizer, Analog, ... but other can have non of them or even not any.