Graveyards

From ArcEmu-Wiki
Jump to: navigation, search

Description

This table controls graveyards. Use the ingame .gps command to receive coordinates.

Contents



id

incrementing ID.


position_x

The X coordinate for the graveyard.


position_y

The Y coordinate for the graveyard.


position_z

The Z coordinate for the graveyard.


orientation

The orientation/direction of the graveyard.


zoneid

The ID of the zone the graveyard is located in.

adjacentzoneid

The ID of the zone adjacent to the zone where the graveyard is located. (?)


mapid

The ID of the map the graveyard is located in.


faction

0 => Alliance
1 => Horde
3 => Both


name

The name of the Graveyard. (Not really usable. Notable that graveyard names are worldport targets for warcraft game masters)


SQL Structure

CREATE TABLE `graveyards` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `position_x` float NOT NULL default '0',
  `position_y` float NOT NULL default '0',
  `position_z` float NOT NULL default '0',
  `orientation` float NOT NULL default '0',
  `zoneid` int(10) unsigned NOT NULL default '0',
  `adjacentzoneid` int(10) unsigned NOT NULL default '0',
  `mapid` int(10) unsigned NOT NULL default '0',
  `faction` int(10) unsigned NOT NULL default '0',
  `name` varchar(255) character set utf8 collate utf8_unicode_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Graveyard System' AUTO_INCREMENT=1417 ;
Personal tools