[Help] Question concerning a custom Mu program (Non-Noob)

[rolex inc.]

Ok so here's the deal..
I had an idea and started coding a program that displays all connected user's locations on maps of each area. The main part of the code was connecting to the sql database and checking:

• MuOnline.Tables.Character.MapNumber
• MuOnline.Tables.Character.MapPosX
• MuOnline.Tables.Character.MapPosY

Now after I spent a half hour programming this, I load up the server and guess what? Apparently these sql fields are only updated after you log off or switch chars! WTF?! This crap makes all of this code worthless.

Now, after analyzing this problem for a second, I'm pretty sure all of the character positions are stored in the GameServer's Memory.

So my question is, can someone pleeease tell me there's an sql field that stores this info? (I'm 95% sure there isn't, but I'm hoping there is cause this was gonna be a sick program.)

-rolex

 

[bramdebouvere]

its just in the gs memory, untill its saved onto the database..