where is user's current map saved in database?

[serverkid]

like the title says..

where is user's current map saved in database?

 

[Brynner]

on your char table. and look for save_map

 

[serverkid]

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]

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]

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

 

[GodLesZ]

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]

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]

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.