Creature staticspawns

From ArcEmu-Wiki
Revision as of 16:04, 15 June 2010 by Marforius (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Information

Staticspawns prevent units from being unallocated when maps are shutdown. Commonly used for transports, as there is no other reason to optimize in this way unless the spawn or unit, is moving, or is on a schedule.


Contents



SQL Structure

CREATE TABLE `creature_staticspawns` (
  `id` int(30) unsigned NOT NULL auto_increment,
  `entry` int(30) NOT NULL,
  `Map` int(30) NOT NULL,
  `x` float NOT NULL,
  `y` float NOT NULL,
  `z` float NOT NULL,
  `o` float NOT NULL,
  `movetype` int(30) NOT NULL default '0',
  `displayid` int(30) unsigned NOT NULL default '0',
  `factionid` int(30) NOT NULL default '35',
  `flags` int(30) NOT NULL default '0',
  `bytes0` int(30) NOT NULL default '0',
  `bytes1` int(30) NOT NULL default '0',
  `bytes2` int(30) NOT NULL default '0',
  `emote_state` int(30) NOT NULL default '0',
  `npc_respawn_link` int(30) NOT NULL default '0',
  `channel_spell` int(30) NOT NULL default '0',
  `channel_target_sqlid` int(30) NOT NULL default '0',
  `channel_target_sqlid_creature` int(30) NOT NULL default '0',
  `standstate` int(10) NOT NULL default '0',
  `mountdisplayid` int(10) unsigned NOT NULL default '0',
  `slot1item` int(10) unsigned NOT NULL default '0',
  `slot2item` int(10) unsigned NOT NULL default '0',
  `slot3item` int(10) unsigned NOT NULL default '0',
  `CanFly` smallint(3) NOT NULL default '0',
  `phase` int(10) unsigned NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Spawn System' AUTO_INCREMENT=1 ;
Personal tools