I want to get the NPC/creature's coordinates from database. such as:
-- this data copy from !questie, {Continent, Zone, X, Y}
["Gol'dir"] = {2, 1, 0.59957194328308, 0.43740105628967},
["Deino"] = {1, 12, 0.38448387384415, 0.86132436990738},
But I can only get these below, So how to make (683.518, -895.468) convert to (0.59957194328308, 0.43740105628967)
-- 2316 = Gol'dir, 5885 = Deino ......
SELECT id, map, position_x, position_y, position_z FROM `creature` WHERE id IN (2316, 5885)
-- result:
id map position_x position_y position_z
------ ------ ---------- ---------- ------------
2316 0 683.518 -895.468 171.889
5885 1 1468.18 -4219.88 43.0424