chyde
|
| Posted: 11/05/2002, 11:54 PM |
|
I am using CC/ASP and have tried to use what has been posted in the discussion boards to no avail.
Can some one post the code and instructions to track users login? I would very much appreciate it.
Thanks in advance
|
|
|
 |
EMG
|
| Posted: 11/06/2002, 1:58 PM |
|
on your login page put the this in Sub LoginAction under the
if bPassed > 0 then line :
cn.execute("update users set LastLogin = " & ToSQL(Now(),"Date") & ", RemoteAddress = " & ToSQL(Request.ServerVariables("REMOTE_ADDR"), "Text") & ", UserAgent = " & ToSQL(Request.ServerVariables("HTTP_USER_AGENT"),"Text") & " Where UserName = " & ToSQL(username, "Text") )
(your column names should match the above statement)
|
|
|
|
chyde
|
| Posted: 11/06/2002, 4:27 PM |
|
I do very much appreciate you taking the time to post this code. Unfortunately, I don't even know what I am supposed to replace in the statement with my own information.
If you could tell me which statements to replace with my own, I think I can stop bugging people on the board.
If it helps, I am using the Portal database and have left it pretty much the same as I try to learn the program.
Again, Thank you
|
|
|
|
EMG
|
| Posted: 11/07/2002, 6:27 AM |
|
CC Portal sql: (the portal table does not have a field for the user's os/browser so I took it out)
on your login page put the this in Sub LoginAction under the
if bPassed > 0 then line :
cn.execute("update users set date_last_login = " & ToSQL(Now(),"Date") & ", ip_update = " & ToSQL(Request.ServerVariables("REMOTE_ADDR"), "Text") & " Where user_login = " & ToSQL(username, "Text") )
|
|
|
|
|
