diff options
| author | horn <pankrac.ja@seznam.cz> | 2013-02-23 01:50:52 +0100 |
|---|---|---|
| committer | horn <pankrac.ja@seznam.cz> | 2013-02-24 17:10:02 +0100 |
| commit | ba549ddc30fd09f7591f0619a59cee1cd9e20574 (patch) | |
| tree | 1454385a43d0eb02e97b29ae70478b828c05c25a /sql | |
| parent | 06257d10348ba62ff0cb098e3cbe74aa948a261c (diff) | |
Core/Summons: Implement summon groups system to be able to summon multiple NPCs at once without need of hardcoding the positions. Almost all hardcoded positions can now be moved to DB.
Thx to @Shauren for his help.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2013_02_24_00_world_creature_summon_groups.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/2013_02_24_00_world_creature_summon_groups.sql b/sql/updates/world/2013_02_24_00_world_creature_summon_groups.sql new file mode 100644 index 00000000000..409f79bb2aa --- /dev/null +++ b/sql/updates/world/2013_02_24_00_world_creature_summon_groups.sql @@ -0,0 +1,16 @@ +DROP TABLE IF EXISTS `creature_summon_groups`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `creature_summon_groups` ( + `summonerId` mediumint(8) unsigned NOT NULL DEFAULT '0', + `summonerType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `groupId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', + `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', + `summonType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `summonTime` int(10) unsigned NOT NULL DEFAULT '0' +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; |
