Print Page | Close Window

Login checking

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Web Interface Mods
Forum Description: Open to all users who wish to share their quarantine web interface modifications
Printed Date: 18 January 2019 at 9:28am

Topic: Login checking
Posted By: TechSquared
Subject: Login checking
Date 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.

Posted By: Desperado
Date Posted: 05 December 2007 at 8:23pm
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.

Print Page | Close Window