How to calculate AreaMap from GameObject Coordinates ?

[Alberto Pittaluga]

Hello all

in order to make some offline cleaning work on existing gameobjects (such as herbs, veins) I am looking at a method to determine onto which GAME AREA (such as Elwynn, Duskwood, etc) a certain Game Object falls.

Of course I can get this info from the .GPS command in-game, but I want to do this outside the game, with a batch procedure.

I dug around quite a bit and find our the various .DBC files contents.
In particular, WorldAreaMap.DBC contains each world area "zone rectangle" coordinates. Problem is: those rectangles overlap each other BIG time, a "simple" overlaying rule such as "when you have an overlap, take the one with higher ID" simply does not work.

Anyone can suggest how to do this?
I could of course reverse-engineer the .gps command sourcecode but I'm not expert enough...

Thanks in advance for any help!
Ciao
Alberto

[stoneharry]

You're thinking about it wrong. GameObjects are a server side entity - no spawns are stored in the client. As such you won't find the data within the DBC's.

You can retrieve the zone based on the coordinates from the server. This is all in the database.

But the way you phrase your question makes me think you don't have access to the server resources you are trying to do this for?

[Alberto Pittaluga]

You're thinking about it wrong. GameObjects are a server side entity - no spawns are stored in the client. As such you won't find the data within the DBC's.

You can retrieve the zone based on the coordinates from the server. This is all in the database.

But the way you phrase your question makes me think you don't have access to the server resources you are trying to do this for?

Thanks for the quick answer.
I have phrased it wrongly, let me be more precise.

First of all, I do have my own mangozero server up, so I can access both server-side data (like gameobjects from the DB) and client-side data (like worldareamap coordinates from the relevant .DBC files, read and interpreted with the various tools you can find online).

So I have
- on one side, a nice list of "objects", each one with its own X, Y, Z ( +map ID ) coordinates-
- on the other side, another nice list of "zones", each one described as a "rectangle", with its own left, right, top, bottom side coordinate.

What I want is to "tag" each object with the name of the zone its coordinates fall into.

Seems easy. It is not. Why? Because the "zones rectangles" are not adjacent to each-other, but they overlap.
So I need another piece of info from somewhere else. But I don't know where from

ciao
A.

[stoneharry]

ZMP - WoWDev

[18:37] <schmoeckwitz> stoneharry: there are client side objects since cata or mop, in a dbc.
[18:41] <stoneharry> Oh, I see. Not looked at anything post-wotlk really.
[18:42] <schmoeckwitz> nevertheless, that is an interesting issue, tbh.
[18:42] <schmoeckwitz> The key might be the lesser known ZMP - WoWDev
[18:48] <schmoeckwitz> Might be completely misleading.
[18:48] <schmoeckwitz> in that case, sorry.