Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - Login checking
  FAQ FAQ  Forum Search   Register Register  Login Login

Login checking

 Post Reply Post Reply
Author
TechSquared View Drop Down
Newbie
Newbie


Joined: 01 March 2006
Location: United States
Status: Offline
Points: 15
Post Options Post Options   Thanks (0) Thanks(0)   Quote TechSquared Quote  Post ReplyReply Direct Link To This Post Topic: Login checking
    Posted: 05 December 2007 at 5:10pm
 I'm currently using an ASP web interface.  Has anyone made modifications to one that would make a note in the database as to the last time a client logged in to check mail?  I would like to remove stale login entries from my login table.
 
Sean
Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post Posted: 05 December 2007 at 8:23pm
Sean,
 
That is a definite YES. In my tblLogins, I have several added columns ... one being LastUsed and another being Logins.  When a user registers, I force the Logins (int) to = 1 and the LastUsed (datetime) to the current server date & time.  In my authenticate.asp page, in the place where the user successfully authenticates, I have code that looks like:
 
 Logins = rs("Logins") + 1
 SQL = "UPDATE tblLogins "
 SQL = SQL & "SET Logins = '" & Logins & "' "
 SQL = SQL & "WHERE EMail = '" & EmailTo & "'"
 con.Execute SQL
 
 SQL = "UPDATE tblLogins "
 SQL = SQL & "SET LastUsed = '" & Now() & "' "
 SQL = SQL & "WHERE EMail = '" & EmailTo & "'"
 con.Execute SQL
 
Does that help?
The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.063 seconds.