how to calculate the location of the NPCS/creatures

[plzzz 0]

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

 

[plzzz 0]

hmm. I found a link that maybe helpful. https://github.com/Muehe/classicdb/tree/master/database,

[Shino 27]

I tried something similiar once. But I came to the conclusion that there are just too few information. 

To start with: There is no direct function that gives you these kind of information, so you have to take a few workarounds.

I think the best approach is to look how addons like questie did something like that, but I think there will be no exact way to get these information.

 

cheers!

[plzzz 0]

In fact, I have found the right way to do it , https://github.com/Muehe/classicdb/blob/master/database/spawnDB.php?ts=4#L167-L168

(I don't know how to close this thread)

[Shino 27]

Oh, I got you wrong there.

Thought you were talking about ingame stuff, sorry^^