diff options
author | Serpaa <Serpaa@users.noreply.github.com> | 2017-12-27 19:46:35 +0100 |
---|---|---|
committer | Killyana <morphone1@gmail.com> | 2017-12-27 19:46:35 +0100 |
commit | ea1387efde1d58cf13240481c931ad8e528c8d45 (patch) | |
tree | 56f1d9d6cab61927ecdee50ba803b9aca8765fcf | |
parent | 84f69a3b6c9ead74e69475a799fcef409f4369a4 (diff) |
DB/Creature: Restore deleted pool
Closes #21130
-rw-r--r-- | sql/updates/world/3.3.5/2017_12_27_00_world.sql | 11 |
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"); |