How do I verify if someone is connected or not

Hello,

I'm working in a game where the players have to loggin and they connect through ajax/PHP to a MySQL database, and then they get all the game stats. My problem is that in this very moment I can't avoid that 2 (or more) people connect to the same player account, so I want to verify if someone is allready connected to avoid to make simmultaneous connections.

I thought to put a value in the database table called "connected" as token, so then, when the player is connected I changed the value to 1 (or true) but I don't know how to change it to 0 (or false) when the player loggout or close the navigator, so it keeps allways "connected".... My server is a normal web server (for the moment), so I can't install any application...

Any ideas?

thanks for your help.

Anybody have a suggestion?

It sounds more like an issue on server side where you should handle something like a timeout for a connection.

If the account hasn't been accessed for X time, then pass the account to "not connected".

To be honest, this is out of the scope of C2 as, as mentioned, this is more server side.

On C2's end, as the tab/browser is closed there is no way to handle this behavior.

If the player does voluntary logout from a "logout" button in your game though, you should be able to handle this through AJAX.

Wish you much fun!

http://php.net/manual/en/book.session.php

Something like this? http://stackoverflow.com/questions/13872598/autorunning-query-in-mysql

That is perfect for you:

http://www.sitepoint.com/users-php-sessions-mysql/

Part two is control access. If this not help, better ask in a php forum.

I work with SmartFox, all learned by myself with google and testing.

That is perfect for you:

http://www.sitepoint.com/users-php-sessions-mysql/

Part two is control access. If this not help, better ask in a php forum.

I work with SmartFox, all learned by myself with google and testing.

I'm not a expert with mysql sentences but I think I can do this.

Thanks.