when a user is logging in with user name "Login1" and another user is trying
to log in with the same user name, what do u want to do? kick out the first
user or stop the second user?
The first case is easy. The second case is harder because you need to clean
up all the dead users in the table. You don't need to create another table to
do this if you are storing the client variables in the database.
J
"Peter Alexandrou" <[EMAIL PROTECTED]> wrote:
> I can think of many similar solutions but they are all useless because most
> of the time users simply close their browsers or their sessions expire.
>
> Surely someone out there has tackled this problem successfully?
>
> ----- Original Message -----
> From: "Pete Freitag" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, October 18, 2000 2:15 PM
> Subject: RE: Preventing Simultaneous Logins
>
>
> > Keep a log of when people login, and when they log out (could get very
> > large, but you could purge it daily). Then when someone logs in do the
> > following...
> >
> > SELECT username FROM audit_table
> > WHERE
> > username = '#form.username#' AND
> > timestamp > #DateAdd("n", -30, Now())#
> > ORDER BY action
> >
> > That will see if the user has been around in the last half hour
> >
> > Action could be a boolean field 1 being login 0 being logout
> > <cfif audit.recordcount>
> > <cfif audit.action>
> > already logged in <cfabort>
> > </cfif>
> > </cfif>
> > login...
> >
> > The problem with this entire process, is that there is no destructor
> called
> > when a session disappears, or times out.
> >
> > ______________________________________________
> > Pete Freitag ([EMAIL PROTECTED])
> > CFDEV.COM / NETDesign Inc.
> > ColdFusion Developer Resources
> > http://www.cfdev.com/
> >
> > -----Original Message-----
> > From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, October 17, 2000 7:37 PM
> > To: CF-Talk
> > Subject: Preventing Simultaneous Logins
> >
> >
> > Hi guys,
> >
> > I'm new to the mailing list and have a quick question for y'all.
> >
> > What is the best way to prevent a userID being logged in twice i.e.
> someone
> > logs in with "login1" and then another user logs in with the same ID.
> >
> > Thanks,
> >
> > Peter Alexandrou
> > Technical Leader
> >
> > tapestry communications : www.tapestry.net.au
> > phone : 0411 445 111
> > e-mail : [EMAIL PROTECTED]
> >
> >
--------------------------------------------------------------------------
> --
> > --------------------
> > Archives: http://www.mail-archive.com/[email protected]/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a
> > message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
> >
> >
--------------------------------------------------------------------------
> ----------------------
> > Archives: http://www.mail-archive.com/[email protected]/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send
> a message with 'unsubscribe' in the body to
> [EMAIL PROTECTED]
>
>
------------------------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
____________________________________________________________________
Get free email and a permanent address at http://www.netaddress.com/?N=1
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
