where is user's current map saved in database?

[serverkid 1]

like the title says..

 

where is user's current map saved in database?

[Brynner 34]

on your char table. and look for save_map

[serverkid 1]

isn't save_map field is where you're character is saved.

 

what i mean is the character's current location. last_map is only updated when you warped to another location or when the player relogs.

[Brynner 34]

when the player logout it will save its last location. the last warp and save map is not the same. the save map only save if you talk to kafra.

[serverkid 1]

yeah, save_map is where your character is saved. i'm looking for the field where you're character is currently at.

[GodLesZ 1]

Your current map is saved as `last_map` (including `last_x` and `last_y`) every n seconds (defined in /conf/map-server.conf as `autosave_time`; see also `save_settings` setting).

[serverkid 1]

which is better, getting the last_map from database or

 

attaching the account_id (from sql) then doing something like

getmapxy(.@qmap$,.@qmapx,.@qmapy,0);

[GodLesZ 1]

which is better, getting the last_map from database or attaching the account_id (from sql) then doing something like

[...]

If you already did a mysql query to fetch anything for char or login table, its a simple JOIN to fetch the online character including his last_map info too.

But in general, if you got the choice, getmapxy should be faster i guess.