aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSerpaa <Serpaa@users.noreply.github.com>2017-12-27 19:46:35 +0100
committerKillyana <morphone1@gmail.com>2017-12-27 19:46:35 +0100
commitea1387efde1d58cf13240481c931ad8e528c8d45 (patch)
tree56f1d9d6cab61927ecdee50ba803b9aca8765fcf
parent84f69a3b6c9ead74e69475a799fcef409f4369a4 (diff)
DB/Creature: Restore deleted pool
Closes #21130
-rw-r--r--sql/updates/world/3.3.5/2017_12_27_00_world.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2017_12_27_00_world.sql b/sql/updates/world/3.3.5/2017_12_27_00_world.sql
new file mode 100644
index 00000000000..3021baaba55
--- /dev/null
+++ b/sql/updates/world/3.3.5/2017_12_27_00_world.sql
@@ -0,0 +1,11 @@
+-- Restore deleted pool
+SET @POOL_1 := 382;
+
+DELETE FROM `pool_template` WHERE `entry`=@POOL_1;
+INSERT INTO `pool_template` VALUES
+(@POOL_1, 1, "Eye of DarKhan/Wailer Spawn 1");
+
+DELETE FROM `pool_creature` WHERE `guid` IN (82897, 85744);
+INSERT INTO `pool_creature` VALUES
+(82897, @POOL_1, 0, "Wailer Spawn 1"),
+(85744, @POOL_1, 0, "Eye of DarKhan Spawn 1");