Merge pull request #9280 from horn/summons

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.

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 */;