Users Disconnecting

[Altercationz]

Hi,
When a user disconnects it's supposed to update the online column in the users table to 0, and it doesn't when a few users disconnect from the hotel causing the cms to say a false amount of users online because that's how i'm fetching the online users.

How would i fix this and make it put online to 0 for every user that disconnects?

Thanks.

 

[Jerry]

Which emulator are you using?

 

[Altercationz]

Which emulator are you using?

Sledmore's plus edit

 

[Jerry]

Perhaps strict mode is enabled on MySQL.

Run the following query:

SET @@global.sql_mode= ”;

Restart the emulator when done.

 

[Altercationz]

Perhaps strict mode is enabled on MySQL.

Run the following query:


Restart the emulator when done.

I'll do that tomorrow as I'm in bed, thanks
 
It's still doing this.

 

[n4te]

Go into class.core and replace this

final public function getOnline()
    {
        global $engine;
        return $engine->result("SELECT status FROM server_status");
    }

With this

final public function getOnline()
    {
        global $engine;
    return $engine->result("SELECT Count(*) FROM users WHERE `online`='1'");
    }

that should do it.

 

[Altercationz]

Hi, I already have that.
That's how i'm selecting my online users and when 2 or 3 users log out it doesn't update and displays the incorrect user count on the cms.

 

[n4te]

Oh. Unfortunately, that was my only solution. I apologize.