How to know if an account is online?

[myraje]

Hi,

I'm working on a PHP application.

I would like to know what account is online.

I can know it with the field "realmlist.active_realm_id" or if a characters is online but when player is in the characters screen, how to know it?

regards

[Meltie]

There should be a online column in the accounts table, but there isn't.. This should be added in that truly tells if the account is online or not. All I know, TrinityCore has it in their accounts table.

Anyways, good luck.

[Necrovoice]

what core you trying to work with that does not have this field? zero, one, two...?

[Meltie]

By the looks of it, all the cores for getmangos, does not have this field.

This includes zero, one, & two.

Not much else I can say.

[Hikari]

As you mentioned yourself you can find out how many characters are actually in the world by counting the online field in the characters table.

The command .server info on the other hand returns the number of accounts which are online. This includes accounts which are only on the character selection screen.

Maybe you can use the SOAP service (activate it in your mangos.conf file) and call it from your php script in order get the information you need.

Unfortunately I never worked with SOAP. So I can't give you a detailed advice.

[myraje]

Hey,

Try this command

.account onlinelist

See attached .png to see what it displays.

Yes it's work if you have a character in game but not when you are in logon screen..

[myraje]

Well, thank you for your replies.

The SOAP service isn't difficult to understand but if I send the command ".server info", I will only have the number of account online and not ID or account name.

Like Hurahi suggested, I'm looking at trinitycore for modify my core and the database as well.

Thank you

[Meltie]

Hopefully, you can get it to work, myraje. Good luck!

[madmax]

Hey,

Try this command

.account onlinelist

See attached .png to see what it displays.

[attachment deleted by admin]

[Necrovoice]

In the account table there is a column called last_login, it will update when someone logs in and can be seen as an active online account at character select screen. I am not bign into php so I can only offer table data. sorry and I hope this helps.