aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorKillyana <morphone1@gmail.com>2019-03-11 21:36:48 +0100
committerKillyana <morphone1@gmail.com>2019-03-11 21:36:48 +0100
commit1b4d3698650712516c2c28f1d945813284405e3f (patch)
treecf0836d49b8496fcd8ad4b00fc0310be06e25ccd
parent42258d4f5fa856182d0592146fb4ce88ca68506c (diff)
DB/GameObject: Fix pooling related to Razormaw Matriarch's Nest
-rw-r--r--sql/updates/world/3.3.5/2019_03_11_02_world_335.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_03_11_02_world_335.sql b/sql/updates/world/3.3.5/2019_03_11_02_world_335.sql
new file mode 100644
index 00000000000..578e7a1635a
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_03_11_02_world_335.sql
@@ -0,0 +1,6 @@
+--
+DELETE FROM `gameobject` WHERE `guid` IN (14999) AND `id`=202083;
+DELETE FROM `gameobject_addon` WHERE `guid` IN (14999);
+DELETE FROM `pool_gameobject` WHERE `guid` IN (14999,6248) AND `pool_entry`=202482;
+INSERT INTO `pool_gameobject` (`guid`, `pool_entry`, `chance`, `description`) VALUES
+(6248, 202482, 25, "Razormaw Matriarch's Nest (202083) P1");