At Simon's prodding I almost have a new version of the Visitor Stats Plugin ready for the world. I am doing final testing and need to update the install and docs. Here is what I have changed/added.

1) To make it work on high volume sites.
Added several indexes to speed things up.
Broken several of the slow pages up to make them faster.
(Tested on one of my sites that has about 10,000 visitors and 40,000 page views per month with 9 months of data).
2) Fixes
Worked on the permissions so other than 'root' can access stats
Fixed JLH's lookup feature at his suggestion.
Made it so user totals are more accurate
3) Additions
Added ignore pages like ignore users and ips
Added rudimentary net block ignore
Provide list of popular spider ip's you can import
Provide sql to clean you database of spider accesses (too slow for web page).

If you have any burning things that need fixed or added, speak up now or hold your peace.

TomW

Good to see you back Tom. It has been a while since you last made the oink that blesses the Geeklog community.

If it is at all possible. A feature that deletes the old stats would be great. Or may be a backup system that ignore the stats. The reason is because last time when I restore a site, 95% of my bauckup data belonged to the vistor stat.


Sam

Is it possible to exlude bots from stats. Like e.g. crawl24.googlebot.com they have new ips all the time.

---

Geeklog Polish Support Team

Deleting stats by month would be easy -- I will put that in.

Blocking bots is already included by the ability to block ranges. I have included the most common bot ip ranges that you can import.

TomW

An addition to ignore specific referrers would be nice. Especially with the Chatterblock installed, each time it refreshes, visitor stats makes a new entry.

---

~Brian

Hi Tom,

If you need a french (canadian) translation of the language file I\'m available!

A module to select data within a date range and export it to CSV or any other delimited text file that could be imported in Excel or Access would be nice. This selection could also be \"dropped\" to reduce the database size. And why not use \"gzip\" before sending the file !

Presently to speed up my sites I dump the data in a text file using phpMyAdmin and load it in Excel and then drop the selected data, so I have a \"zipped\" backup of all the database since the beginning, and a smaller and faster site.

I\'m looking forward to this new version.


If you need my email add. let me know.

Alain Ponton

Would it be possible to show what each registered user did? Like, show the URLs that he visited? I\'m guessing no, but just thought I\'d ask.

Also, another thing I\'d like to see would be the amount of hits an article got that day. Just so I know that any of my obscure articles may be getting hits.

Arn\'t these already part to your current Visitor Stats?

Mine is working that way. It records everyone, registered or not, regarding the pages the person visited and the url that s/he came from. And the articles s/he read.

Sam

I\'m sure you noticed, that the \"GeekTools Whois Proxy\" link (the one clicking on an IP links to) has changed?

Greetings,
Georg

No my stats don\'t list the articles people read. For example, I\'d like to see a list of articles/pages Username1 accessed that day.Is that implemented because its not shown up in mine

Hmm, see what you mean here. Then you would have to enter your own site. It seems that then you would loose all access after a visitor hit your site. This is probably not what you want. Chatterblock does not make a unique url with its refreshes. Don\'t see how I could implement this.

TomW

I have looked into exporting the data and after seeing all the problems that a simple thing like backups has caused the Geeklog Team, I have shelved the idea. For those who want to it is a simple thing to use phpmyadmin or just the command line to save the data and then delete it from the database.

Maybe someday when I get brave I will do this. With the new version I am running a site with a 25mb userstats file that is working ok.

I will contact you Alain to update the translation when I am done.

TomW

Both of these are already in the current version. From the main index page click on an individual month to show the days. From the day screen you can click on the Registered Visitors link for each to see what each visitor did. From the day screen click on the Pages Viewed link for each day to see how many times each pages was viewed that day. Or from the month screen click on the Pages Viewed link to see how many times each page was viewed that month.

Click around nearly all the items are clickable to get details.

TomW

Yeah you can change the config.php variables in current version even to

$_ST_Whois_URL_start = \'\';

and it will work again.

TomW

Hi Tom

It would be great if we were able to do a search (in a day, week or month) within the stats ie. finding a particular IP, or a particular user who assessed the site. Or for that matter, find the number of people or individuals assessing a particular URL or page.

I know the data is there already. Trying to check who assessed is really time consuming because we cannot sort the info by IP or user or page. or categorize them within the day, week or month. In my opinion, it would be great if there is such a facility.

Thanks

Sorry to keep bugging, but was just wondering if you had any idea when it would be released? I\'ve had to re-install a couple of times already, and am now getting 1034: Incorrect key file for table: \'gl_userstats\'. Try to repair it, so instead of the old un-install re-install biz, thought I might wait and see if you have the sucker ready. Lemme know :-)

BTW, thanks I never knew I could see what my readers were doing. Thank you very much. I love your plugin chief!

I'd be quite keen to see the feature that Anon:Cheese is talking about... ie ability to filter the page views by a user so you can see a user's recent activity. This would list all of their page views (across all sessions) say within the month being viewed.

Also the initial stats page that lists the months (/vstats/index.php) should probably be listed in date descending order rather than alpha. At the moment I have:

August 03
July 03
June 03
Sep 03

... which is obviously a little unintuitive.

Great package btw!

Hi Barry,

The ability to sort is already there. Just click the column head you want to sort by. Click again to sort the opposite way.

I get the feeling many of you do not know half what the plugin will do. Like I have said almost everything is clickable including headings. Experiment a little.

TomW

The month sort is fixed in the new version.

Right now I am down to final testing on different websites and updating the docs. If I had nothing else to do today I could get it out today, but I have lots to do today and will probably not have a chance to do much. Hopefully within a week it will be ready.

TomW