Corpses

From ArcEmu-Wiki
Jump to: navigation, search

Description

This table stores information on player corpses.


Contents



guid

The Guid of the player.

It refers to the table characters column Guid


positionX

What "x" positions the corps is at.


positionY

What "y" positions the corps is at.


positionZ

What "z" positions the corps is at.


orientation

The orientation of the corpse.


zoneId

The zoneId the corpse is in.


mapId

The mapId the corpse is in.


instanceId

The instanceId the corpse is in.


data

SQL Structure

CREATE TABLE `corpses` (
  `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
  `positionX` float NOT NULL DEFAULT '0',
  `positionY` float NOT NULL DEFAULT '0',
  `positionZ` float NOT NULL DEFAULT '0',
  `orientation` float NOT NULL DEFAULT '0',
  `zoneId` int(11) NOT NULL DEFAULT '38',
  `mapId` int(11) NOT NULL DEFAULT '0',
  `instanceId` int(11) NOT NULL DEFAULT '0',
  `data` longtext NOT NULL,
  PRIMARY KEY (`guid`),
  KEY `b` (`instanceId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Personal tools