| Author |
 Topic  |
|
dayve
Forum Moderator
USA
5820 Posts |
 Posted - 16 May 2001 : 14:11:27
|
so what is a good workaround for the negative time showing? why is the time relative? is it because of the timezone or the way sessions are being handled?
Dayve |
 |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 16 May 2001 : 18:17:12
|
do you have a site i can look at where it's negative numbers. I'm not getting it on neither of my sites.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 17 May 2001 : 21:57:57
|
just an update, here is what my statistics show:
10 Members Last Seen
No. Member Name Last Seen
1. nineinchnailz -51 minutes ago.
2. wendy -51 minutes ago.
3. imnothing666 -46 minutes ago.
4. Star****er#1 -22 minutes ago.
5. creeping death -16 minutes ago.
6. fragilegodess -28 minutes ago.
7. fade -20 minutes ago.
8. oneweeknosebleed -14 minutes ago.
9. NINYC -55 minutes ago.
10. ViperX -55 minutes ago.
Dayve |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 18 May 2001 : 01:38:44
|
I think I found the problem. I changed this line:
<% minutesTotal = datediff("n",strtodate(rs("m_lastheredate")),now())
to this:
<% minutesTotal = datediff("n",strtodate(rs("m_lastheredate")),strForumTimeAdjust)
and it works...no more negative numbers...
Dayve |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 May 2001 : 03:35:11
|
quote:
I think I found the problem. I changed this line:
<% minutesTotal = datediff("n",strtodate(rs("m_lastheredate")),now())
to this:
<% minutesTotal = datediff("n",strtodate(rs("m_lastheredate")),strForumTimeAdjust)
and it works...no more negative numbers...
Dayve
This would be entirely correct, now() should not beused since it is not relative to the forum, but the server
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
|
|
wedont
Junior Member
Canada
344 Posts |
Posted - 22 May 2001 : 16:43:44
|
Very nice Dayve,
The zip file does'nt appear in winzip!
Do you have it as a .text file ?
Wedont
snitz ver3.1 sr2
access 2k.
Edited by - wedont on 22 May 2001 16:44:50 |
|
|
|
DocEVL
Starting Member
USA
19 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 22 May 2001 : 19:08:02
|
how weird, it works for me and I am using WinZip. anywhoooooooo, here is the .txt version:
http://www.nineinchnailz.com/statistics_graph.txt
btw, I will be applying this to statistics.asp as well, this add on was done to aznknights statistics2.asp.
sorry I didn't comment the code, good news is you don't have to do a line for line edit.
Dayve
Edited by - dayve on 22 May 2001 22:43:05 |
|
|
|
Jeepaholic
Average Member
USA
697 Posts |
Posted - 24 June 2001 : 01:27:07
|
Has anyone noticed that the post statistics seem to be inaccurate? If you look at the # posts per day...then you look at the # posts for this month (June), you'll see a discrepancy. The total doesn't add up to as much as the individual days put together. I've checked a number of different sites, and everyone's is off.
http://www.jeepaholics.com/citizensband/forum/statistics2.asp
The topic count, btw, seems to be right on the nose... Thoughts?
Hey Dayve, none of your graphing links are working (txt or zip)...can you put these back up? I'd like to use this code! As well, any word on implementing the graphing for the other stats page? Thanks...
Al Bsharah
Jeepaholics Anonymous
Edited by - Jeepaholic on 24 June 2001 01:30:04
Edited by - Jeepaholic on 24 June 2001 01:30:54 |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 24 June 2001 : 13:54:25
|
how much is it off by?
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
Jeepaholic
Average Member
USA
697 Posts |
Posted - 24 June 2001 : 16:29:38
|
3910 : Adding up "Posts per Day" for this month
2546 : Taken from "Posts per Month"
2546/3910 = 65% I'm not really sure which one is wrong...
Alan, your Snitz Resource site shows this:
46/81 = 56%
Al Bsharah
Jeepaholics Anonymous |
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 24 June 2001 : 16:41:04
|
hmm very odd with the discrepancy. Looking at the sql statements for the 2 sections, i can't tell why right now. I'll look at this at the beginning of next month when there's less data to deal with to see what's up with it. Got my hands full right now.
- Alan
www.iamviet.com
www.calvsa.net
Snitz Resource |
|
|
|
RobX
Starting Member
USA
27 Posts |
Posted - 26 June 2001 : 01:08:07
|
Hello Alan,
First of all... I'd like to congratulate you for your iamviet site!!
Now, I tried to install the STATISTICS MOD but unfortunately I got these errors.
When calling statistics.asp, I get:
Members
Total Members: 80
Female members: 23
Male members: 49
Forum
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/forum/statistics.asp, line 290
Then when I try to call statistics2.asp I get:
Microsoft VBScript runtime error '800a01c2'
Wrong number of arguments or invalid property assignment: 'Monthname'
/forum/statistics2.asp, line 311
What should I do?
Thanks!
RobX
|
|
|
|
Topic |
|
Topic Locked
