| Author |
 Topic  |
|
rgrund
Junior Member
Austria
206 Posts |
 Posted - 29 November 2002 : 13:18:22
|
Hello,
this is now VERSION 1.1.1.
NEW Database: ACCESS & MySQL (Sqlserver not Tested) NEW
Installing Mode (0-10 10=Hard) = 2
This mod gives you the following counters which can each be turned off or on.
1. Pages viewed today
2. Pages viewed for the current month
3. pages viewed for the current year
4. Total pages viewed
5. Visitors today
6. Visitors for the current month
7. Visitors for the current year
8. Total visitors
9. Yesterdays Pages viewed
10. Yesterdays Visitors
11. Active Forum Member Count
in the admin section i have added a new page where one is able to turn these counters on or off.
Further in the admin section you can also adjust the counter
1. Total pages viewed and
2. Total visitors
You now have the chance to show the statistic table as
a. Two rows and one column
b. two columns and one row
The storage option is NOW available
You can choose one storage option to use from two
a. ACCESS
b. TXT
UPGRADERS: Please follow the instructions in the readme.txt file. You really need to follow it, otherwise you will get an error. the last file to include is the inc_sitestat.asp, after you have set the config within the admin_config_sitestat.asp!!
In the Admin Section you also have the chance to view statistical bar charts. These are growing in size and in bars dynamically.
The table is a simple code to add any where you want or in the footer of the forum. See the readme.txt
run the example sitestat.asp and you will get an impression on how it looks like.
Please get back to me how you like it
sample page www.visaa.net/forum/sitestat.asp The table can be modified to fit your needs.
here is the download zip file: www.gcsk.com/snitz_mod/sitestat11.zip
The file sitestat11.zip includes already the updated version 1.1.1
Robert
Update 17.03.2004 (23:11)NEW
I have updated the inc_sitestat.asp. Have made some modification to the table and also those errors EOF or BOF are now coded out. Here is the file
www.gcsk.com/snitz_mod/inc_sitestat.zip
Update 17.01.2003 (17:48) NEW
Version 1.1.1 is now available
There is only a script change within two files, which resolves problem with the storage option with the TXT file. Please download the zip file to update the two files. You will only need to overwrite them.
www.gcsk.com/snitz_mod/sitestat111.zip
Update 26.12.2002 (17:45)
Version 1.1 is now available.
I have made the following changes:
1. Once logged into the admin section, the counters will not be increased.
2. In the admin section the graphs now include a javascript applet.
3. The storage option TXT is now incorpoarted fully within the script.
Please read the readme file.
Next version of the sitestat MOD will only be the analysis of the data as of Version 2. This will then be a fully back-end application!
Merry Christma from Finland!
Update 20.12.2002 (18:16)
version 1.08 is available. Still Test Phase. If you install the counter for the first time please use version 1.01.
Could some one test version 1.08!
The storage option is bow available. You can choose now between Access or a TXT file.
If you use the TXT option I had to turn off the ability for the graph option within the admin_sitestat. I did not yet have time to rewrite the code. If you use Access, it is still available!
Update 17.12.2002 (20:03)
Version 1.01 is available! See readme.txt
Update 16.12.2002 (13:15)
Serverhacker has made me aware that one variable was not set correct. Thank You!! I have changed the file and have uploaded a new zip file.
If you have already installed the sitestat mod please see page 2 of this topic and the comments from serverhacker at the bottom. Quit simple to correct!!!
Update 3.12.2002 (23:27)
Version 1 is now released. Last amendments concerning the visitor counter has been solved. Charts Added.
Update 1.12.2002 (23:08)
Have found an counter error within the visitor. Have corrected this now as well.
Had a spelling mistake for the font type, so it was not shown with the forum settings. Changed now too.
I am still working on the Graphs. Currently there are two graphs one can look at:
1) Total Years count (pages and visitors)
2) Total Month count (pages and visitors)
I am still thinking of adding the days but this would mean that i have to change the counter mechanic's. Should I stay with just the month or should I convert it down to show days as well?
Will have the offical version 1 soon out to be released!!
Update 30.No 2002 (23:45)
Made a change which should not have any cause to the existing script.
In the Sub Sitestat() I have now defined the variables Day, Month and Year again. So it is not dependant on the counter script.
Update 30.Nov 2002 (8:43 am my time)
Have made a correctionin the inc_sitestat.asp. The Visitor was not calculated properly. Have exchanged the Zip file.
Update 30.Nov 2002 (7:00 am)
I have removed the formatnumber function. Do not know why it is not working as on my machine it is. Have exchanged the Zip file.
|
Internet should be OPENSOURCEd! |
Edited by - rgrund on 17 March 2003 17:22:49 |
|
|
Etymon
Advanced Member
United States
2385 Posts |
Posted - 29 November 2002 : 16:21:16
|
Hi Bob,
Thanks a lot for this MOD. May I convert your work to retrofit and earlier version of Snitz? I am using version 3.3.05.
I am looking forward to installing this MOD. Thanks so much!
Cheers,
Etymon
|
 |
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 29 November 2002 : 16:33:11
|
no problem ! Just go ahead!
Bob |
Internet should be OPENSOURCEd! |
|
|
|
schef
Junior Member
USA
164 Posts |
Posted - 29 November 2002 : 17:29:55
|
dead link  ?? |
ATV Outdoors |
|
|
|
eggyfarts
Junior Member
New Zealand
200 Posts |
Posted - 29 November 2002 : 20:06:55
|
| I just think the whole server is down. I am quite interested in this MOD, maybe I can help you with some graphical graphs |
Cheers,
WeeVaa.
|
|
|
|
tduffy
Junior Member
146 Posts |
Posted - 29 November 2002 : 23:57:43
|
When i try using sitestat.asp, or adding in sitestat() to a file, i get this..
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'formatnumber'
/forums/inc_sitestat.asp, line 118
Line 118 of the file is this:
Total_Count=formatnumber(rs("TOTAL_COUNT") + strPageCountEdit,0)
can you help me? |
|
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 30 November 2002 : 01:10:03
|
Right now it is 7 am in Austria, so I was sleeping while you were posting your problem.
I have uploded a new zip file, you can download it from the first posting at the topic.
I had still a sql error , which is now gone.
I also have taken out the formatnumber (xxx,0) formular. I find this strange that you get an error as this should be working.
Please replace the inc_sitestat.asp file if you have already downloaded the zip file.
eggyfarts
Yes, I would be interested to see how you could help me out with the graphs. I thought of using a java script but this is not shareware or freeware and I do not want to step over the copyright and license.
Bob |
Internet should be OPENSOURCEd! |
Edited by - rgrund on 30 November 2002 04:57:33 |
|
|
|
tduffy
Junior Member
146 Posts |
Posted - 30 November 2002 : 12:38:44
|
your new file gives me this error:
Microsoft JET Database Engine error '80040e14'
Extra ) in query expression '(((SITESTAT_YEAR)=))'.
/forums/inc_sitestat.asp, line 133
|
|
|
|
DJBBIZ
Junior Member
214 Posts |
Posted - 30 November 2002 : 15:09:31
|
| Is your counter text based, does it write to a file or is it server variable based? Or db based? Do you have an example that we can see on a site? Thanks |
"The difference between good ideas and good results is performance"
the management institute | tmiFinance | tmiCreative | ProfileOnDemand |
Edited by - DJBBIZ on 30 November 2002 15:21:30 |
|
|
|
LanKuchang
Junior Member
Malaysia
120 Posts |
Posted - 30 November 2002 : 16:50:05
|
hi bob,
i'm at lost on how to display stat table.
I've tried to display the table on my forum but couldn't use the function call <%
sitestat()
%>.
me site is at http://kondonet.homeip.net/mrsmkb84/forum/default.asp. i want to display the stat table underneath my "Link" which is inside the inc_footer.asp.
please tell me how to do it.
sitestat.asp displays without any problem
|
|
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 30 November 2002 : 17:10:52
|
The counter is located within the snitz database.
I have added for this a complete new table (that's why there is a dbs_sitestat.asp file)
Bob |
Internet should be OPENSOURCEd! |
|
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 30 November 2002 : 17:34:49
|
Hi LanKuchang,
How to add the sitestat() into the footer.
You will need to go to the default.asp file. Goto approx. line 990. We are now in the subroutine WriteStatistics()
Line 991 should be:
if ArchivedPostCount > 0 and strArchiveState = "1" then
Above this line add the following:
Response.Write "<tr>"
Response.Write " <td bgcolor=""" & strForumCellColor & """ colspan=""" & sGetColspan(6,5) &_
""">" & _
"<font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """ color=""" & strForumFontColor & """>"
sitestat()
Response.Write "</font></td>" & vbNewline & _
" </tr>" & vbNewline
I have tested it on my test forum and it worked.
Just get back to me if you have any questions.
Bob |
Internet should be OPENSOURCEd! |
Edited by - rgrund on 30 November 2002 17:41:15 |
|
|
|
tduffy
Junior Member
146 Posts |
Posted - 30 November 2002 : 19:36:21
|
| any answer to my error? |
|
|
|
tduffy
Junior Member
146 Posts |
Posted - 30 November 2002 : 19:49:44
|
after applying your inc_sitestat.asp file again, i'm getting this error now:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forums/inc_sitestat.asp, line 142
|
|
|
|
tduffy
Junior Member
146 Posts |
Posted - 30 November 2002 : 19:54:46
|
| i found my problem, i moved the include file to a different spot(towards the end) of inc_header.asp and now it's working |
|
|
|
LanKuchang
Junior Member
Malaysia
120 Posts |
Posted - 01 December 2002 : 01:32:34
|
thanks bob that's work,
i actually need to correct bits in red--remove it,
Response.Write "<tr>"
Response.Write " <td bgcolor=""" & strForumCellColor & """ colspan=""" & sGetColspan(6,5) &_
""">" & _ "<font face=""" & strDefaultFontFace & """ size=""" & strFooterFontSize & """ color=""" & strForumFontColor & """>"
sitestat()
Response.Write "</font></td>" & vbNewline & _
" </tr>" & vbNewline
so i guess i do need to modify inc_sitestat.asp to tune the table to suit my page layout.
thanks. |
|
|
|
Topic |
|
Topic Locked
