| Author |
 Topic  |
|
rgrund
Junior Member
Austria
206 Posts |
 Posted - 13 December 2002 : 15:56:03
|
Hi,
Boy one is away some times and then so many responses!!
The Counters:
They are from my point very accurate!
Every time a page is loaded the page counted is increased.
The visitor is a session cookie, so after the the visitor will not be counted twice during the first twenty minutes, after the twenty minutes the visitor counter is increased again and a new session cookie is placed.
I am a bit surprised now that the database is increasing itself so much, have to check my site out as well. What I find strange is that there will only be one line entry for each month in the database table.
Serverhacker: I am using your snitz version and it is working fine for me.
Have you checked that all the application variables are included in the config.asp page?
Robert |
Internet should be OPENSOURCEd! |
 |
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 13 December 2002 : 16:04:11
|
Serverhacker,
Just checked your url!
the counters are only shown when the counter settings are on in the admin_sitestat.asp section. As you are mentioning that they are not holding nothing will be shown as they are not on! You will need to see if your config has them included (application variables). If they are included then boy I have no idea as it runs on so many sites proper!
Hope that this helps?!
Robert |
Internet should be OPENSOURCEd! |
Edited by - rgrund on 13 December 2002 16:10:49 |
|
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 13 December 2002 : 16:07:23
|
Gee,
I have now a different question, as i am working on Version 2 right now.
I am looking for a script which tells me from were the visitor comes from. Looking for a script which gives me the country information.
Does any one have any idea how you do that, or from where I could get this script (open source!)
Robert |
Internet should be OPENSOURCEd! |
|
|
|
serverhacker
Junior Member
USA
125 Posts |
Posted - 14 December 2002 : 05:24:06
|
rgrund, I got it working  , I forgot to add the part to the config.asp file...LOL |
|
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 14 December 2002 : 05:39:31
|
Good to hear that!
Looking forward seeing the script running on your site!
Are you also implementing the script in your snitz version?
Robert |
Internet should be OPENSOURCEd! |
|
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 14 December 2002 : 05:45:29
|
Update Info concerning the upcoming Version 2:
i have decided to add an option where one wants to store the data. One will now have the option to decide for a) the access database or b) a simple txt file!
This should solve then the size of the file!
best regards,
Robert  |
Internet should be OPENSOURCEd! |
|
|
|
serverhacker
Junior Member
USA
125 Posts |
Posted - 14 December 2002 : 05:53:55
|
If a may? I would like to add it to the code  |
Edited by - serverhacker on 14 December 2002 05:54:14 |
|
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 14 December 2002 : 11:33:20
|
No problem! Will you send me then the modification? I will add your contribution and name within the script!
Robert |
Internet should be OPENSOURCEd! |
|
|
|
serverhacker
Junior Member
USA
125 Posts |
Posted - 14 December 2002 : 12:21:30
|
| sure, i will get it to you tonight. |
|
|
|
serverhacker
Junior Member
USA
125 Posts |
Posted - 15 December 2002 : 01:30:58
|
| rgrund, I sent you an email with the changed files |
|
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 15 December 2002 : 05:05:08
|
Hi serverhacker,
have seen want you have done. I will add the part into the inc_sitestat.aspfile and as an option within the admin_sitestat.asp. Further as mentioned I am adding you at the top of the contributors.
Lets keep up the sharing of open source!!
Robert |
Internet should be OPENSOURCEd! |
|
|
|
TERM
New Member
82 Posts |
Posted - 15 December 2002 : 15:10:23
|
Is version 2 out yet? If so where can I find it?
I am on a somewhat limited server size, and I host game ladders and mods, and would rather not use alot of server space on the forums database. My site gets roughly 5000-15000 hits per day (not unique) but most people hang around, so a text based file would be better for me as long as it takes up less space. |
|
|
|
rgrund
Junior Member
Austria
206 Posts |
Posted - 15 December 2002 : 16:38:50
|
Hi Term,
I am nearly finished with Version 1.1. Version 2 will only have further admin mode, meaning you will get more graphs to analyse the habits from your visitors.
Version 1.1, which is not yet out, has now the following new features:
a. The table of counts can be shown as either two rows and one column or two columns in one row.
b. The admin can now choose which type of storage he prefers access or text based
c. added the members counter as well (thanks Serverhacher!)
The text based file currently is about 1K. Nice reduction I would say. (tested the counter as if two years have passed)
I just have still one problem, the data is still being deleted at one point and I somehow can not get the logic together with the OpenTextFile Object. Modifying a line is not as simple as using sql!!!
I hope to have the latest version 1.1 out in the next few days. (I need to finish this as I will be on vacation w/o a PC for the next one week as of 21st of Dec)
Robert
|
Internet should be OPENSOURCEd! |
|
|
|
TERM
New Member
82 Posts |
Posted - 15 December 2002 : 20:00:21
|
awesome. ill be looking forward to seeing it.
|
|
|
|
serverhacker
Junior Member
USA
125 Posts |
Posted - 16 December 2002 : 03:28:23
|
I found an error in the code, that i fixed in the files i sent you, but i forgot to tell ya about it, so here it goes:
In inc_sitestat.asp, you have "strTotalVisitor" two times see the red code:
'We get the Total Visit
If strTotalVisitor = "1" then
strSql = "SELECT Sum(SITESTAT_MONTH_VISITOR) AS Total_Visit FROM " & strMemberTablePrefix & "SITESTAT"
set rs = my_conn.execute(strSql,adOpenStatic,adCmdTxt)
Total_Visit=rs("TOTAL_VISIT") + strVisitorCountEdit
End If
'We get the Total Year Visit
If strTotalYearVisitor = "1" then
strSql = "SELECT Sum(SITESTAT_MONTH_VISITOR) AS Year_Visit FROM " & strMemberTablePrefix & "SITESTAT WHERE (((SITESTAT_YEAR)="& strSS_Year & "))"
set rs = my_conn.execute(strSql,adOpenStatic,adCmdTxt)
Year_VISIT=rs("Year_Visit")
End If
'We get the Total Month Visit
If strTotalMonthVisitor = "1" then
strSql = "SELECT SITESTAT_MONTH_VISITOR AS Month_Visit FROM " & strMemberTablePrefix & "SITESTAT WHERE (((SITESTAT_YEAR)=" & strSS_Year & ") AND ((SITESTAT_MONTH)=" & strSS_Month &"))"
set rs = my_conn.execute(strSql,adOpenStatic,adCmdTxt)
Month_Visit=rs("Month_VISIT")
End If
'We get the Total Day Visit
If strTotalVisitor = "1" then
strSql = "SELECT SITESTAT_DAY_Visitor AS Day_Visit FROM " & strMemberTablePrefix & "SITESTAT WHERE (((SITESTAT_YEAR)=" & strSS_Year & ") AND ((SITESTAT_MONTH)=" & strSS_Month & ") AND ((SITESTAT_TODAY)=" & strSS_Day & "))"
set rs = my_conn.execute(strSql,adOpenStatic,adCmdTxt)
DAY_Visit=rs("DAY_Visit")
End If
Shold be this, see red code again:
'We get the Total Visit
If strTotalVisitor = "1" then
strSql = "SELECT Sum(SITESTAT_MONTH_VISITOR) AS Total_Visit FROM " & strMemberTablePrefix & "SITESTAT"
set rs = my_conn.execute(strSql,adOpenStatic,adCmdTxt)
Total_Visit=rs("TOTAL_VISIT") + strVisitorCountEdit
End If
'We get the Total Year Visit
If strTotalYearVisitor = "1" then
strSql = "SELECT Sum(SITESTAT_MONTH_VISITOR) AS Year_Visit FROM " & strMemberTablePrefix & "SITESTAT WHERE (((SITESTAT_YEAR)="& strSS_Year & "))"
set rs = my_conn.execute(strSql,adOpenStatic,adCmdTxt)
Year_VISIT=rs("Year_Visit")
End If
'We get the Total Month Visit
If strTotalMonthVisitor = "1" then
strSql = "SELECT SITESTAT_MONTH_VISITOR AS Month_Visit FROM " & strMemberTablePrefix & "SITESTAT WHERE (((SITESTAT_YEAR)=" & strSS_Year & ") AND ((SITESTAT_MONTH)=" & strSS_Month &"))"
set rs = my_conn.execute(strSql,adOpenStatic,adCmdTxt)
Month_Visit=rs("Month_VISIT")
End If
'We get the Total Day Visit
If strTotalDayVisitor = "1" then
strSql = "SELECT SITESTAT_DAY_Visitor AS Day_Visit FROM " & strMemberTablePrefix & "SITESTAT WHERE (((SITESTAT_YEAR)=" & strSS_Year & ") AND ((SITESTAT_MONTH)=" & strSS_Month & ") AND ((SITESTAT_TODAY)=" & strSS_Day & "))"
set rs = my_conn.execute(strSql,adOpenStatic,adCmdTxt)
DAY_Visit=rs("DAY_Visit")
End If
Just wanted to let you know
Also just an idea, how about showing yesterday totals, or dayly totals in a graph form for the month? |
Edited by - serverhacker on 16 December 2002 03:37:26 |
|
|
|
Topic |
|
Topic Locked
