| Author |
 Topic  |
|
frankie
Junior Member
Vatican City
304 Posts |
 Posted - 20 February 2001 : 03:35:10
|
I took the original code of this application and heavily modifed it to be used on snitz forums
or the website for the forum.
Demo: http://www.eastpasco.com/reports.asp
Download: http://www16.brinkster.com/studentwave/stats_reports.zip
Description:
Stat_Reports Mod is a statistics reporting application written in pure ASP. It collects data from the visitors of your site and stores it into the forum database. You may view the analysis results using the Reports page.
Being a lot more powerful than a simple page counter,Stat_Reports features detailed access statistics using ASP and an Access database tables. By executing SQL queries on the collected data, Stat_Reports Mod generates the following reports:
Individual Statistics:
» Page Views,
» Browser Type,
» Operating System,
» Screen Resolution,
» Color Depth,
» Visitor IP's,
» Referer Information.
Detailed Web Site Statistics:
» A detailed summary report showing an overview of all individual
statistics,
» Total pageviews for entire site,
» Pageviews for each page,
» All referrers to the site.
Graphical Reports:
» Graphical representation of Page Views and Visitors by Hour,
» Day of Week,
» Day of Month,
» Week of Year,
» Month,
» Year.
Detailed Visitor Statistics:
» Total number of unique visitors for entire site,
» Visitors for each page,
» Visitors for a specific time period,
» IP addresses and click paths for all visitors.
* Reports can be viewed for all tracked data, or viewed by
year, month, week, day, hour, or day of week.
The basic idea behind Stat_Reports Mod is to use an image as a
counter. You will add the counter code provided below into the files
which you want to count (at the vey end of inc_footer.asp of snitz forums!!):
............
ô¿~
Edited by - frankie on 20 February 2001 19:35:34
Edited by - frankie on 22 February 2001 23:07:59 |
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 20 February 2001 : 03:36:51
|
.........
<a href="reports.asp" title="Review our website Stats">
<script type="text/javascript" language="JavaScript">
// Define the location of stats_functions.asp
// Using a path, you may use this code in any subfolder
var file='stats_functions.asp'; // if wanna use in a subfolder use the virtual path
var d=new Date();
var s=d.getSeconds();
var m=d.getMinutes();
var x=s*m;
f='' + escape(document.referrer);
if (navigator.appName=='Netscape'){b='NS';}
if (navigator.appName=='Microsoft Internet Explorer'){b='MSIE';}
if (navigator.appVersion.indexOf('MSIE 3')>0) {b='MSIE';}
u='' + escape(document.URL); w=screen.width; h=screen.height;
v=navigator.appName;
fs = window.screen.fontSmoothingEnabled;
if (v != 'Netscape') {c=screen.colorDepth;}
else {c=screen.pixelDepth;}
j=navigator.javaEnabled();
info='w=' + w + '&h=' + h + '&c=' + c + '&r=' + f + '&u='+ u + '&fs=' + fs + '&b=' + b + '&x=' + x;
document.write('<img src="' + file + '?'+info+ '" width=20 height=20 border=0>');
</script>
</a>
<noscript>
<a href="reports.asp" title="Review our website Stats">
<img src="stats_functions.asp" width=20 height=20 border=0></a>
</noscript>
Stat_Reports Mod features Data Normalization
to minimize the storage required to save the collected data in
the database.
Installation:
1. Open the zip file and extract the contents to the forum folder.
2. Run stats_reports_setup.asp from your browser to create required tables.
3. Copy the above code in the page you want to counted (inc_footer.asp for snitz forums).
4. Configuration Switches (See stats_config.asp for more explanations.):
sFilterIps = ""
List IP addresses that should not be tracked by Stat_Reports
separate by commas.
bShowLinks = True
Should links be displayed as links in reports?
bRefThisServer = False
Count your own server as referer?
bStripPathParameters = True
Strip off the parameters from the path name?
bStripPathProtocol = True
Strip off the protocol from the path name?
bStripRefParameters = True
Strip off the parameters from the referer name?
bStripRefProtocol = True
Strip off the protocol from the referer name?
bStripRefFile = False
Strip off the path and file name from the referer name?
5. Counter Image:
You may want to change the counter image. You need to complete
the following steps if you want to use a different image:
1. Select an image to put on all pages, such as your logo. You
may use the provided image on your pages if you want to. You'll need the
location, width and height of this image.
2. Find the line beginning with
"document.write" in the code you inserted in inc_footer.asp.
This line generates the "img" tag. Replace the width
and height with your own image's width and height. (You may use
width=0 and height=0 if you dont want to display the image.)
3. Open stats_config.asp file; Find the line:
const sImageLocation = "meter.gif"
This line specifies the location of the counter image. You may
use a relative path to stats_functions.asp file.
If the counter image and stats_functions.asp file are in the same
folder, you dont need to specify a path.
NOTE: You should modify the img tag in "noscript"
for browsers that doesn't run Javascript.
Please feel free to suggest add-ons or modify code. Enjoy and god bless  .
Not: thos mod works with mod commander.
ô¿~
Edited by - frankie on 20 February 2001 11:41:58 |
 |
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 20 February 2001 : 03:48:17
|
Ok..Setup went fine.. Install went fine, but when I tried to access the counter I got this error:
Microsoft VBScript runtime error '800a01a8'
Object required: 'rs'
/forums/stats_config.asp, line 95
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 20 February 2001 : 04:09:23
|
rick,
try accessing a couple of pages before you hit the counter. I got to go to sleep now (long day tommorow) but I will check on this from school later on!
ô¿~ |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 20 February 2001 : 04:12:16
|
Still does it.. Get some sleep I'll catch up with you tomorrow.
Thanks,
Rick
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 20 February 2001 : 11:27:09
|
All files are fixed, please redownload(zip file updated).
I did some tweaking to the connection and recordset objects. .
rick, would you please set this up on your test site for a demo (if you can!)? Thank you .
ô¿~
Edited by - frankie on 20 February 2001 11:43:04 |
|
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 20 February 2001 : 13:16:02
|
Hey frankie ....
I'm impressed, this is quite a Stats report
Another toy for me to play with 
Intrepidone
Edited by - Intrepidone on 20 February 2001 18:26:30 |
|
|
|
frankie
Junior Member
Vatican City
304 Posts |
Posted - 20 February 2001 : 13:26:12
|
Intrepidone,
I'm glad it worked fine for you. If you want to change the colors of the data cells text or the header text, do that in the included .css file (so easy to configure).
I noticed you don't have the dividers in your tabls (is that delibrate)?
BTW, how come the urls are not showing in your pages of this mod?
Peace
ô¿~
Edited by - frankie on 20 February 2001 13:33:22 |
|
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 20 February 2001 : 13:33:59
|
No the dividers is not deliberate
I'm just going to dig into the .css file to maybe make the font a size bigger. In Netscape it is very hard to read. You know me and Netscape ehh!! we don't get along..lol
Very informative MOD thought frankie. I'll keep you posted. For now I'll leave it visible for everyone to see as a demo but in the future I'll hide it so only admin can see it.
Intrepidone
Edited by - Intrepidone on 20 February 2001 13:36:00 |
|
|
|
tteal
Junior Member
USA
438 Posts |
Posted - 20 February 2001 : 13:58:33
|
This is an outstanding modification indeed!
Only problem I'm having is when I attempt to view the reports.asp file I'm getting this error:
Invalid object name 'TopPageViewsPerDay'
reports.asp, line 70
I think it's because I'm using SQL Server 7.0 and you're creating a view, however, it had errors when running the setup file. I think maybe the create view script might be the culprit but unsure... just my thoughts.
Tim |
|
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 20 February 2001 : 14:07:02
|
frankie ...
On line 103 of reports.asp I changed this
bgcolor="<%= strCategoryCellColor %>
to this
bgcolor="<%= strTableBorderColor %>
that fixed the dividers in the table
(on my intranet, have not uploaded changes to internet yet)
Intrepidone |
|
|
|
redbrad0
Advanced Member
USA
3725 Posts |
Posted - 20 February 2001 : 14:26:24
|
nice mod. looks just like the stats program at http://www.2enetworx.com/dev/projects/statcountex.asp but with modification.
the problem I have with this, which might not be that bad for 2 many others is the amount of data that has to be inserted into the database just for the stats. with most users using access this could cause their whole site 2 start running slow.
THIS IS JUST MY OPINION, but i think its a great mod other then this fact
Brad |
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 20 February 2001 : 14:28:29
|
Frankie... It's up on my test site....
I'm going to upload the new files now.
Rick
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser.
Edited by - rick7165 on 20 February 2001 15:11:15 |
|
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 20 February 2001 : 14:40:29
|
redbrad0 ...
I just checked my db and in the last hour it has grown 8k in size, which on a busy site that would build fast.
I'll experiment a little later and just enable certain features and watch the db see how it grows, but you are right, with all features enabled the db would get to big.
Maybe instead of having it on inc_footer.asp, put it on default.asp or maybe just the .asp files you want tracked, like my guestbook.....see how many ppl access it but don't sign it.....lol
Intrepidone |
|
|
|
Intrepidone
Average Member
Canada
515 Posts |
Posted - 20 February 2001 : 14:58:21
|
rick7165 ....
I just checked my stats_config.asp and have no line 95, it stops at line 94
88 sub w(sText)
89 'A Quickie ;)
90 response.write sText & vbCrLf
91 end sub
92
93
94 %>
and I did get that same error on your site
|
|
|
|
rick7165
Senior Member
USA
1094 Posts |
Posted - 20 February 2001 : 15:03:57
|
Ok.. Got it working... I still had 1 old file before Frankie's update left on the site..
Everything works fine.
Frankie it's up and running on my test site so people can see it now.
Thanks For the Great Mod!
Rick
Test Site
www.eastpasco.com
Running on HuwR's SR4 release. Colors and Graphic scheme done by Richard Kinser. |
|
|
|
Topic |
|
Topic Locked
