Login Script: "Is Online"

[conker87]

I've got a pretty simple yet effective login script, works great.

 

Now I'm wanting to take it a little further and show when the user(s) in online on the member list. I know I can do this through sql, adding an `online` field to the db, but the only problem is if the user doesn't click the 'logout' link and the session expires then the db will not be updated (and so the user will be shown as still logged in even though said session is no more).

 

Anyone got any ideas on how I could actually make this work?

 

Ta.

[trq]

You need to run a cron job which deletes users who have been inactive for a set amount of time.

[conker87]

Hmm, I'm not looking at removing people who hasn't been online in a set amount of time. I'm looking for something that will give a visual notice (IE, "<user> Is online!") in the members list and when they logout this notice is removed.

[mmarif4u]

Thorpe is not talking about to delete users from db.

He mean,make separate table in db and store sessions related data there.

Then run cron job at a specific amount of time.Then delete the data after some time.

[conker87]

Ahha. I shall have to have a look whether the host does cron jobs, if it does I shall look into it. )

[moon 111]

Since the only time it will be seen is when a user views the page that shows it, you can update the list when someone views the page.

 

Basicly have two fields online and last_seen. Online is a boolean reffering to if he is online or not and last_seen is the "time()" value of when he was last seen. Then when someone views the page you can go through the list and delete those that haven't been seen in a set period of time (delete as in set online to 0). A cron job however would be much less CPU intensive.