Back-to:Characters
The `corpse` table
This table hold info about character's corpse.
Structure
Field |
Type |
Attributes |
Key |
Null |
Default |
Extra |
Comment |
int(10) |
unsigned |
PRI |
NO |
0 |
Unique |
Global Unique Identifier |
|
int(10) |
unsigned |
|
NO |
0 |
|
Character Global Unique Identifier |
|
float |
signed |
|
NO |
0 |
|
|
|
float |
signed |
|
NO |
0 |
|
|
|
float |
signed |
|
NO |
0 |
|
|
|
float |
signed |
|
NO |
0 |
|
|
|
smallint(5) |
unsigned |
|
NO |
0 |
|
Map Identifier |
|
smallint(5) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
text |
signed |
|
NO |
|
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
|
tinyint(3) |
unsigned |
|
NO |
0 |
|
|
|
int(10) |
unsigned |
|
NO |
0 |
|
|
Description of the fields
corpseGuid
The corpse global unique identifier.
guid
The GUID of the character whose corpse this is. See characters.guid
posX
The X position of the corpse.
posY
The Y position of the corpse.
posZ
The Z position of the corpse.
orientation
The orientation of the corpse. (North = 0.0; South = pi (3.14159))
mapId
The Map ID of the position of the corpse. See Maps.dbc
phaseMask
This is a bitmask field that describes all the phases that a creature will appear in.
displayId
field-no-description|9
itemCache
field-no-description|10
bytes1
field-no-description|11
bytes2
field-no-description|12
guildId
The ID of the guild that the player is a part of. See guild.guildid
flags
Name |
Flag |
Comment |
|
---|---|---|---|
CORPSE_FLAG_NONE |
0x00 |
0 |
|
CORPSE_FLAG_BONES |
0x01 |
1 |
Leaves bones, not the body. |
CORPSE_FLAG_UNK1 |
0x02 |
2 |
|
CORPSE_FLAG_UNK2 |
0x04 |
4 |
|
CORPSE_FLAG_HIDE_HELM |
0x08 |
8 |
Character's corpse has hidden helm. |
CORPSE_FLAG_HIDE_CLOAK |
0x10 |
16 |
|
CORPSE_FLAG_LOOTABLE |
0x20 |
32 |
Makes corpse lootable (like in a BG) |
dynFlags
field-no-description|15
time
field-no-description|16
corpseType
Name |
Type |
Comment |
---|---|---|
CORPSE_BONES |
0 |
|
CORPSE_RESURRECTABLE_PVE |
1 |
|
CORPSE_RESURRECTABLE_PVP |
2 |
|
instanceId
The instance ID. See instance.id