world_safe_locs
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| ID | int | unsigned | PRI | NO | |||
| MapID | int | unsigned | YES | NULL | |||
| LocX | float | YES | NULL | ||||
| LocY | float | YES | NULL | ||||
| LocZ | float | YES | NULL | ||||
| Facing | float | YES | NULL | ||||
| TransportSpawnId | bigint | unsigned | YES | NULL | |||
| Comment | varchar(255) | YES | NULL | ||||
Description of fields
ID
Unique identifier, as of today ID 7582 is last (leaked) entry since this used to be a shipped DB2 file. New (custom) IDs should be used per expansion as followed:
| Expansion | ID range start | ID range end |
|---|---|---|
| Battle for Azeroth (8.x) | 80000 | 89999 |
| Shadowlands (9.x) | 90000 | 99999 |
| Dragonflight (10.x) | 100000 | 109999 |
| The War Within (11.x) | 110000 | 119999 |
MapID
MapID of the location
LocX
X coordinate of the location
LocY
Y coordinate of the location
LocZ
Z coordinate of the location
Facing
Facing coordinate of the location in degrees
Note: Radians to degrees: Radians / (2 * PI() / 360) (you can use this snippet in SQL)
Alternative in Python you can use this gist.
TransportSpawnId
- no description -
Comment
The usage of the location and where it is (as in zone/map name)