Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer

Re^5: delete users

by DaWolf (Curate)
on Dec 10, 2004 at 02:46 UTC ( #413740=note: print w/replies, xml ) Need Help??

in reply to Re^4: delete users
in thread delete users


First of all, sorry for the delay. Actually I've made a cron entry that simply calls a script that does the following query (note that the RDBMS is PostGreSQL, so I don't know if this query will run smoothly on any RDBMS):
SELECT SESSION_ID FROM SESSION_ACTIVITY WHERE DT = current_date AND HR < current_time - interval '30 minutes'
This brings the ID's of the expired sessions (in this case those idle for 30 minutes or more), so I can delete them from the database. What happens next is that when the user decides to click another link or something like that, each page checks if the session is still on the database. Since it's not, the user is automatically redirected to the login page with a message telling him his session has expired.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://413740]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (8)
As of 2021-04-19 13:41 GMT
Find Nodes?
    Voting Booth?

    No recent polls found