Whois On code question...

[Anon]

Ok, I think I have a simple whois on system worked out. If anyone else knows of a better way/easy way lemme know. :o)

I'm going to use a user login and a whoison table in a database to see whois on and whois not. When a user logs in, the program selects the user's row then updates the status column to On. Then in the whois on section, the program gets the data from the table then displays those who are on. The only problem I'm finding with this system is the ability for them to go offline. I've already got a Log Off to update the table and set thier status to Off but what if they just close the browser without logging off? Is there away to update the table if they exit the browser like a javascript or something?

[juschillin]

just a thought...

you could use $REMOT_ADDR //i think that is what it is

and checkt their ip address.

write a program that will check all users ip addresses every so often (you might want to try pushed refresh) and then compare them to what is listed on the database. if an ip address is not logged that was once on the database, then remove it.

[fitzbean]

Just set up a "lastaction" timestamp for each user, and when the MINUTE(lastaction) > MINUTE(NOW()) - 20, the user is logged on. Culd be less than 20 obviously.