automatically delete record ...

botsai

Is it possible to have a record automatically delete (itself?) after a given time?
My problem is that I have a login system in which I record online users in a database.
When the browser of a particular user crashes, he's still in the database, and I want him out of there.

The user should be abe to login more than once (from several locations at a time so, thats why I cannot just delete his online-ness)

How can I do this?

Anon

you cant control users browser :-( is it open or close? and time ist a solution for this (login system) problem.

u can use this:

you are writing your login users somewhere. write their last accesing time there too. so u can control everything.
example:
if their last access to your site was 30 min ago (u can change this time) u can offer them relogin then. OR

if they want to close ask them to click logout button deleting that time from that table.

u must cookies :-)

Anon

When you say several locations do you mean different ip addresses?

if so, just add $REMOTE_ADDR to the data you're tracking.

$ipaddr = ip2long($REMOTE_ADDR);
$hashed_var= md5($ipaddr);

SetCookie("LOGGEDINFROM", "$hashed_var", 0, "/");

then another script

if(!$LOGGEDINFROM) {

$ipaddr = ip2long($REMOTE_ADDR);
$hashed_var= md5($ipaddr);

$qry = "select id from table where loggedinfrom = '$hashed_var'";

if the results is over 0 then

do something.like force another login..

}

this assumes you insert a record for each ip, however, if the user is behind a proxy
this will not work