gameobject

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	bigint	unsigned	PRI	NO	0
id	int	unsigned		NO	0		Gameobject Identifier
map	smallint	unsigned		NO	0		Map Identifier
zoneId	smallint	unsigned		NO	0		Zone Identifier
areaId	smallint	unsigned		NO	0		Area Identifier
spawnDifficulties	varchar(100)			NO	0
phaseUseFlags	tinyint	unsigned		NO	0
PhaseId	int	signed		YES	0
PhaseGroup	int	signed		YES	0
terrainSwapMap	int	signed		NO	-1
position_x	float			NO	0
position_y	float			NO	0
position_z	float			NO	0
orientation	float			NO	0
rotation0	float			NO	0
rotation1	float			NO	0
rotation2	float			NO	0
rotation3	float			NO	0
spawntimesecs	int	signed		NO	0
animprogress	tinyint	unsigned		NO	0
state	tinyint	unsigned		NO	0
ScriptName	varchar(64)			NO	''
StringId	varchar(64)			YES	NULL
VerifiedBuild	int	signed		NO	0

 

Description of fields

guid

The global unique identifier for the game object. This field must be unique among all game objects.
If a new gameobject will be spawned it should be within the GUID range of the current expansion when gameobject was added initially on retail.

For example a gameobject in Orgrimmar and Stormwind was added in Shadowlands (9.x) on retail (expansion 8), so it would get a GUID between 8000000 and 8999999 assigned.

Classic Only Spawns: Some spawns in 4.4.x are different then 4.3.x, we use last 10k

The GUID ranges are defined as followed:

Expansion	GUID range start	GUID range end	ℹ️ Event GUID subrange start	ℹ️ Event GUID subrange end	Classic Only range start	Classic Only range end
Vanilla (1.x)	1	249999
The Burning Crusade (2.x)	1	249999
Wrath of the Lich King (3.x)	2000000	2989999	2800000	2989999	2990000	2999999
Cataclysm (4.x)	3000000	3989999	3800000	3989999	3990000	3999999
Mists of Pandaria (5.x)	4000000	4999999	4800000	4999999
Warlords of Draenor (6.x)	5000000	5999999	5800000	5999999
Legion (7.x)	6000000	6999999	6800000	6999999
Battle for Azeroth (8.x)	7000000	7999999	7800000	7999999
Shadowlands (9.x)	8000000	8999999	8800000	8999999
Dragonflight (10.x)	9000000	9999999	9800000	9999999
The War Within (11.x)	10000000	10799999	10800000	10999999
Midnight (12.x)	11000000	11799999	11800000	11999999
⚠️ Wrath of the Lich King (3.x)	1	249999
⚠️ Legacy Cataclysm (4.x)	250000	449999
⚠️ Legacy Mists of Pandaria (5.x)	250000	449999
⚠️ Legacy Warlords of Draenor (6.x)	450000	649999
⚠️ Legacy Legion (7.x)	650000	849999
⚠️ Legacy Battle for Azeroth (8.x)	850000	1049999
⚠️ Legacy Shadowlands (9.x)	1050000	1249999

Because the limit of several old ranges was reached, new ranges have been defined with the nomenclature {ExpID}000000 - {ExpID}999999. The old ranges should not be used.

Due to the revamp of events/holidays during the last few expansions, one subrange per expansion has been reserved to avoid leaving gaps when deleting old spawns. All holiday spawns should use this subrange.

id

This links to gameobject_template_entry
 

map

The ID of the map that the gameobject is spawned on.
 

zoneId

The ID of the zone that the gameobject is spawned on.
 

areaId

The ID of the area that the gameobject is spawned on.
 

spawnDifficulties

Comma separated list of difficulties.

Name	Value
DIFFICULTY_NONE	0
DIFFICULTY_NORMAL	1
DIFFICULTY_HEROIC	2
DIFFICULTY_10_N	3
DIFFICULTY_25_N	4
DIFFICULTY_10_HC	5
DIFFICULTY_25_HC	6
DIFFICULTY_LFR	7
DIFFICULTY_MYTHIC_KEYSTONE	8
DIFFICULTY_40	9
DIFFICULTY_3_MAN_SCENARIO_HC	11
DIFFICULTY_3_MAN_SCENARIO_N	12
DIFFICULTY_NORMAL_RAID	14
DIFFICULTY_HEROIC_RAID	15
DIFFICULTY_MYTHIC_RAID	16
DIFFICULTY_LFR_NEW	17
DIFFICULTY_EVENT_RAID	18
DIFFICULTY_EVENT_DUNGEON	19
DIFFICULTY_EVENT_SCENARIO	20
DIFFICULTY_MYTHIC	23
DIFFICULTY_TIMEWALKING	24
DIFFICULTY_WORLD_PVP_SCENARIO	25
DIFFICULTY_5_MAN_SCENARIO_N	26
DIFFICULTY_20_MAN_SCENARIO_N	27
DIFFICULTY_PVEVP_SCENARIO	29
DIFFICULTY_EVENT_SCENARIO_6	30
DIFFICULTY_WORLD_PVP_SCENARIO_2	32
DIFFICULTY_TIMEWALKING_RAID	33
DIFFICULTY_PVP	34
DIFFICULTY_NORMAL_ISLAND	38
DIFFICULTY_HEROIC_ISLAND	39
DIFFICULTY_MYTHIC_ISLAND	40
DIFFICULTY_PVP_ISLAND	45
DIFFICULTY_NORMAL_WARFRONT	147
DIFFICULTY_HEROIC_WARFRONT	149
DIFFICULTY_LFR_15TH_ANNIVERSARY	151
DIFFICULTY_VISIONS_OF_NZOTH	152
DIFFICULTY_TEEMING_ISLAND	153

 

phaseUseFlags

Name	Value
PHASE_USE_FLAGS_NONE	0x0
PHASE_USE_FLAGS_ALWAYS_VISIBLE	0x1
PHASE_USE_FLAGS_INVERSE	0x2

 

PhaseId

Determines in which phase the gameobject is in.
Available phases can be found in Phase.db2
 

PhaseGroup

Determines in which PhaseGroup the gameobject is in.
A PhaseGroup sets a gameobject in multiple phases at once.
PhaseGroups can contain more Phases than you actually need.
Available PhaseGroups can be found in PhaseGroup.db2
 

terrainSwapMap

- no description -
 

position_x

The X position of the gameobject spawn point.
 

position_y

The Y position of the gameobject spawn point.
 

position_z

The Z position of the gameobject spawn point.
 

orientation

The orientation of the gameobject spawn point.

Position	Radian	Decimal
North	0 / 2π	6.28319
West	0.5π	1.57080
South	π	3.14159
East	1.5π	4.71239

 

rotation0

- no description -
 

rotation1

- no description -
 

rotation2

- no description -
 

rotation3

- no description -
 

spawntimesecs

The respawn time, in seconds, of the gameobject.
 

animprogress

- no description -
 

state

For chests and doors.

State	Value
open	0
closed	1

 

ScriptName

The name of the script that this gameobject uses, if any. This ties a script from a scripting engine to this creature.
 

StringId

- no description -
 

VerifiedBuild

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.

If value is -Client Build then it was parsed with WDB files from that specific client build and manually edited later for some special necessity.