Welcome to Geeklog, Anonymous Tuesday, October 15 2024 @ 09:27 pm EDT
Geeklog Forums
New Version of Visitor Stats almost ready.
Page navigation
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
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
26
26
Quote
Status: offline
samstone
Forum User
Full Member
Registered: 09/29/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
27
25
Quote
TomW
Anonymous
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
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
17
26
Quote
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
20
28
Quote
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.
22
24
Quote
Status: offline
samstone
Forum User
Full Member
Registered: 09/29/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
23
27
Quote
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
22
20
Quote
Status: offline
tomw
Forum User
Full Member
Registered: 08/12/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
20
21
Quote
Status: offline
tomw
Forum User
Full Member
Registered: 08/12/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
28
23
Quote
Status: offline
tomw
Forum User
Full Member
Registered: 08/12/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
18
20
Quote
Status: offline
tomw
Forum User
Full Member
Registered: 08/12/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
22
29
Quote
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
23
23
Quote
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 :-)
21
25
Quote
Cheese
Anonymous
BTW, thanks I never knew I could see what my readers were doing. Thank you very much. I love your plugin chief!
29
22
Quote
Status: offline
Agent X20
Forum User
Junior
Registered: 06/11/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!
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!
24
23
Quote
Status: offline
tomw
Forum User
Full Member
Registered: 08/12/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
18
25
Quote
Status: offline
tomw
Forum User
Full Member
Registered: 08/12/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
18
28
Quote
Page navigation
All times are EDT. The time is now 09:27 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