Online status reset during update loop

[GoogleCodeExporter]

By celtus (25 November 2010 - automatically ported issue):

At some point during update, the values of characters.online and 
account.active_realm_id are reset to 0, even though the character is still in 
the world.
MySQL Log:
101125 11:47:19    9666 Query       SELECT 
id,receiver,subject,message,money,item,item_count FROM mail_external
                   9666 Query       SELECT id FROM auctionhouse WHERE itemowner<>2 AND buyguid<>2
                   9667 Query       UPDATE account SET active_realm_id = 0 WHERE id = 2
                   9666 Query       UPDATE characters SET online = 0 WHERE account = 2

Original issue reported on code.google.com by stfxm...@gmail.com on 30 Dec 2010 at 4:38

[GoogleCodeExporter]

By celtus:
These queries are run together, in this order, in WorldSession.cpp on lines 80 
and 81 in the WorldSession destructor (WorldSession::WorldSession()).
If the destructor is being called while the character is still logged in, there 
may be more serious issues resulting than just the status values.

Original comment by stfxm...@gmail.com on 30 Dec 2010 at 4:38

[GoogleCodeExporter]

Original comment by stfxm...@gmail.com on 30 Dec 2010 at 6:13

• Changed state: Accepted
• Added labels: Com-General