Suppose I have a table with the current users logged in on my website. And if I there isn't any "activity" from one of his/her username in a time interval it would be deleted from the table.
What would be the easiest way to implement this functionality?
Besides using batch files or something like that.
I searched but database triggers can't be timed programmed, at least from what I gathered.
I'll be using a table with the usernames and timestamps to define their latest activity and consider that those who haven't done nothing in the last 10 mins are logged of.