Welcome to Geeklog Sunday, May 19 2019 @ 07:11 pm EDT

Geeklog Forums

New Version of Visitor Stats almost ready.


Status: offline

tomw

Forum User
Full Member
Registered: 12/08/02
Posts: 300
curious
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

Status: offline

samstone

Forum User
Full Member
Registered: 29/09/02
Posts: 820
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

Status: offline

Robin

Forum User
Full Member
Registered: 15/02/02
Posts: 725
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

TomW

Anonymous
caffeinated
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

Status: offline

bcbrock

Forum User
Chatty
Registered: 04/02/03
Posts: 64
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

Alain

Anonymous
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

Cheese

Anonymous
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.

Status: offline

samstone

Forum User
Full Member
Registered: 29/09/02
Posts: 820
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

Status: offline

geKow

Forum User
Full Member
Registered: 12/01/03
Posts: 445
I\'m sure you noticed, that the \"GeekTools Whois Proxy\" link (the one clicking on an IP links to) has changed? Greetings, Georg

Cheese

Anonymous
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

Status: offline

tomw

Forum User
Full Member
Registered: 12/08/02
Posts: 300
Quote by bcbrock: An addition to ignore specific referrers would be nice. Especially with the Chatterblock installed, each time it refreshes, visitor stats makes a new entry.
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

Status: offline

tomw

Forum User
Full Member
Registered: 12/08/02
Posts: 300
Quote by Alain: Hi Tom, 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 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

Status: offline

tomw

Forum User
Full Member
Registered: 12/08/02
Posts: 300
Quote by Cheese: 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.
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

Status: offline

tomw

Forum User
Full Member
Registered: 12/08/02
Posts: 300
Quote by geKow: I\'m sure you noticed, that the \"GeekTools Whois Proxy\" link (the one clicking on an IP links to) has changed? Greetings, Georg
Yeah you can change the config.php variables in current version even to $_ST_Whois_URL_start = \'\'; and it will work again. TomW

Barrywong

Anonymous
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

Cheese

Anonymous
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 :-)

Cheese

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

Status: offline

Agent X20

Forum User
Junior
Registered: 11/06/03
Posts: 27
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!

Status: offline

tomw

Forum User
Full Member
Registered: 12/08/02
Posts: 300
Quote by Barrywong: 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
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

Status: offline

tomw

Forum User
Full Member
Registered: 12/08/02
Posts: 300
Quote by Agent X20: 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!
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

All times are EDT. The time is now 07:11 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content