Total time online ?
Snitz™ Forums 2000https://forum.snitz.com/forumTopic/Posts/65042?pagenum=1
05 November 2025, 09:24
Topic
Replies ...
PPSSWeb
24 July 2007, 15:46
Very true., I guess that is what I get for answering without fully understanding the question.
Sorry for the hasty reply.
In that case, it looks like Shaggy hit it right on the head in the post above.
I think you will also have to add the calculation to the deleteInactiveUsers() function to capture all cases where the user is removed from the active users.
If I am looking at this right though, I am not sure this will be accurate. I think both of these functions operate on timeouts, so this will not cover the function where they log out directly. In this case their time will keep increasing until the next timeout. Is this right? Even still, this will only execute when someone else loads these functions. So if I am thinking right, this could keep counting users time until someone else logs in, even if the other user left a and timed out a long time ago.<
24 July 2007, 15:46
Originally posted by tribaliztic
But this will only show online time for THIS session? Not all sessions since registering? Or am I wrong?
Very true., I guess that is what I get for answering without fully understanding the question.
Sorry for the hasty reply.
In that case, it looks like Shaggy hit it right on the head in the post above.
I think you will also have to add the calculation to the deleteInactiveUsers() function to capture all cases where the user is removed from the active users.
If I am looking at this right though, I am not sure this will be accurate. I think both of these functions operate on timeouts, so this will not cover the function where they log out directly. In this case their time will keep increasing until the next timeout. Is this right? Even still, this will only execute when someone else loads these functions. So if I am thinking right, this could keep counting users time until someone else logs in, even if the other user left a and timed out a long time ago.<
pitstraight
25 July 2007, 23:54
25 July 2007, 23:54
I don't see the problem with everyone seeing it, but if someone can write the code Im sure I can make it show the way I want.
also VERY glad to see some life in this thread<
also VERY glad to see some life in this thread
<
PPSSWeb
26 July 2007, 10:06
26 July 2007, 10:06
I am not sure how this will work as I havn't had time to really test it, but maybe this will give you a start.
As stated you will need to add a field to the Members table. With a numeric value started at 0. Make sure you chose a data type that will have enough room so you will not be likely to over run the value if you forum stays up for a number of years.
To get the total time value from the database and current active time then add the two and update the total time, you will need something like this.
It has been mentioned that this should go in inc_func_common. I am just not sure where it is best to put it at the moment. I added it to the ActiveUserTracker() function and it has not run when I expected it to. Or maybe I was just too impatient.
Where you want to display this information, you will need to put something like this:
I am pretty sure this code will need some tweaking and cleanup. But perhaps it will give you a start.
<
As stated you will need to add a field to the Members table. With a numeric value started at 0. Make sure you chose a data type that will have enough room so you will not be likely to over run the value if you forum stays up for a number of years.
To get the total time value from the database and current active time then add the two and update the total time, you will need something like this.
Code:
'##Total online time##
if MemberID="-1" then 'If this is a Guest, do nothing
else 'If this is a Member, get Login Time
strSql = "SELECT AU_LOGINTIME FROM " & strTablePrefix & "ACTIVE_USERS WHERE MEMBER_ID = " & MemberID
set rsAM = my_conn.execute (strSql)
if rs.EOF or rs.BOF then 'do nothing
else 'get Total Time online
strSQL = "SELECT M_TIMEONLINE FROM " & strTablePrefix & "MEMBERS WHERE (MEMBER_ID = " & MemberID & " AND MEMBER_ID <> -1)"
set rs = my_conn.execute (strSql)
if rs.EOF or rs.BOF then 'do nothing
Else 'update total time online
onlineTime = rs("M_TIMEONLINE") + abs(DateDiff("n",StrToDate(rsAM("AU_LOGINTIME")),strForumTimeAdjust))
strSql = "UPDATE " & strTablePrefix & "MEMBERS SET M_TIMEONLINE='" & onlineTime & "'" & _
"WHERE MEMBER_ID = " & MemberID
my_conn.execute (strSql)
End IF
end if
rsAM.close
set rsAM = Nothing
rs.close
set rs = Nothing
end if
'######It has been mentioned that this should go in inc_func_common. I am just not sure where it is best to put it at the moment. I added it to the ActiveUserTracker() function and it has not run when I expected it to. Or maybe I was just too impatient.
Where you want to display this information, you will need to put something like this:
Code:
strSQL = "SELECT M_TIMEONLINE FROM " & strTablePrefix & "MEMBERS WHERE (MEMBER_ID = " & MemberID & " AND MEMBER_ID <> -1)"
set rs = my_conn.execute (strSql)
if rs.EOF or rs.BOF then 'do nothing
Else 'output total time online
Response.Write " Total Time Online: " & rs("M_TIMEONLINE")
End ifI am pretty sure this code will need some tweaking and cleanup. But perhaps it will give you a start.
<