Character status (Online / Offline)

[systemous]

Hello. How is possible to add a status column in the rankings which informs if a character is online or offline (for 97d version).

Using the information that the MEMB_STAT table provides, i can only make it show if the account is online and not just the character. Which means even if i inner join the MEMB_STAT with another table like Character to get the character names too, if the account is online, all of the characters appear to be online. Is there a way to do that?

Thank you in advance

[MentaL]

[2009x2014]

AccountCharacter -> GameIDC last logged character

so with acc data (id column) you can check in memb_stat if account of current character is online and display result.