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
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 Topic: Login checking
    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
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 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
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.188 seconds.