DB/Creature: Remove wrong spawns related to Pilgrim's Bounty

No need to comment about missing chairs or their positions, accessories are not installed correctly and there's already an issue: https://github.com/TrinityCore/TrinityCore/issues/15224

4 files changed, 6 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2016_12_26_07_world.sql b/sql/updates/world/3.3.5/2016_11_26_07_world.sql
index 3a6457edabd..3a6457edabd 100644
--- a/sql/updates/world/3.3.5/2016_12_26_07_world.sql
+++ b/sql/updates/world/3.3.5/2016_11_26_07_world.sql
diff --git a/sql/updates/world/3.3.5/2016_12_26_08_world335.sql b/sql/updates/world/3.3.5/2016_11_26_08_world335.sql
index e97774cdab8..e97774cdab8 100644
--- a/sql/updates/world/3.3.5/2016_12_26_08_world335.sql
+++ b/sql/updates/world/3.3.5/2016_11_26_08_world335.sql
diff --git a/sql/updates/world/3.3.5/2016_12_26_09_world335.sql b/sql/updates/world/3.3.5/2016_11_26_09_world335.sql
index 9b57c0bb58a..9b57c0bb58a 100644
--- a/sql/updates/world/3.3.5/2016_12_26_09_world335.sql
+++ b/sql/updates/world/3.3.5/2016_11_26_09_world335.sql
diff --git a/sql/updates/world/3.3.5/2016_11_27_02_world.sql b/sql/updates/world/3.3.5/2016_11_27_02_world.sql
new file mode 100644
index 00000000000..425ee9ee931
--- /dev/null
+++ b/sql/updates/world/3.3.5/2016_11_27_02_world.sql
@@ -0,0 +1,6 @@
+-- 
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (34812, 34823,34819,34822, 34824, 32830, 32840, 32824, 32827, 32831, 32825, 32829, 32839));
+DELETE FROM `game_event_creature` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (34812, 34823,34819,34822, 34824, 32830, 32840, 32824, 32827, 32831, 32825, 32829, 32839));
+DELETE FROM `creature` WHERE `id` IN (34812, 34823,34819,34822, 34824, 32830, 32840, 32824, 32827, 32831, 32825, 32829, 32839);
+-- Fix DB error
+UPDATE `smart_scripts` SET `link`=10 WHERE `entryorguid`=27959 AND `source_type`=0 AND `id`=9;