From 579cc91ea7f3600330c2a83355f2467b9d415f74 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Sat, 26 Nov 2016 19:32:30 +0000 Subject: DB/Misc: Pooling Fix Silithid Invader again, --- sql/updates/world/3.3.5/2016_12_26_09_world335.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 sql/updates/world/3.3.5/2016_12_26_09_world335.sql (limited to 'sql/updates') diff --git a/sql/updates/world/3.3.5/2016_12_26_09_world335.sql b/sql/updates/world/3.3.5/2016_12_26_09_world335.sql new file mode 100644 index 00000000000..9b57c0bb58a --- /dev/null +++ b/sql/updates/world/3.3.5/2016_12_26_09_world335.sql @@ -0,0 +1,20 @@ +SET @CGUID := 86075; +SET @POOL := 32492; + +DELETE FROM `pool_creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+6 AND `pool_entry` BETWEEN @Pool AND @Pool+6; +DELETE FROM `pool_creature` WHERE `guid` IN(21317,21318,21314,21324,21323,21325,21327) AND `pool_entry` BETWEEN @Pool AND @Pool+6; +INSERT INTO `pool_creature` (`guid`, `pool_entry`, `chance`, `description`) VALUES +(@CGUID+1, @Pool, 0, 'Silithyd Invader'), +(21317, @Pool, 0, 'Silithyd Hive Drone'), +(@CGUID+2, @Pool+1, 0, 'Silithyd Invader'), +(21318, @Pool+1, 0, 'Silithyd Hive Drone'), +(@CGUID+0, @Pool+2, 0, 'Silithyd Invader'), +(21314, @Pool+2, 0, 'Silithyd Hive Drone'), +(@CGUID+4, @Pool+3, 0, 'Silithyd Invader'), +(21324, @Pool+3, 0, 'Silithyd Hive Drone'), +(@CGUID+3, @Pool+4, 0, 'Silithyd Invader'), +(21323, @Pool+4, 0, 'Silithyd Hive Drone'), +(@CGUID+5, @Pool+5, 0, 'Silithyd Invader'), +(21325, @Pool+5, 0, 'Silithyd Hive Drone'), +(@CGUID+6, @Pool+6, 0, 'Silithyd Invader'), +(21327, @Pool+6, 0, 'Silithyd Hive Drone'); -- cgit v1.2.3