DB/Creature: A some missing auras

By ZenoX92 and AnonXS from https://github.com/cmangos/tbc-db/commit/33b6252f8ce395fdefe16399568cbca3ffe87f37
Closes #23221

1 files changed, 72 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2019_04_30_05_world_335.sql b/sql/updates/world/3.3.5/2019_04_30_05_world_335.sql
new file mode 100644
index 00000000000..fc7abb7b382
--- /dev/null
+++ b/sql/updates/world/3.3.5/2019_04_30_05_world_335.sql
@@ -0,0 +1,72 @@
+-- 
+UPDATE `creature_template_addon` SET `auras` = '3616' WHERE `entry` IN (
+2208, -- Greymist Tidehunter
+2651, -- Witherbark Hideskinner
+2686, -- Witherbark Broodguard
+3260, -- Bristleback Water Seeker
+5224, -- Murk Slitherer
+5856, -- Glassweb Spider
+6004, -- Shadowsworn Cultist
+6551, -- Gorishi Wasp
+8762); -- Timberweb Recluse
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (8556,10882,2644,3767,17236);
+INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES
+(8556, '3616'), -- Crypt Walker
+(10882, '3616'), -- Arikara
+(2644, '3616'), -- Vilebranch Hideskinner
+(3767, '3616'), -- Bleakheart Trickster
+(17236, '3616'); -- Tcha'kaz
+
+-- Add Torch Burn 5680 for 
+UPDATE `creature_template_addon` SET `auras` = '5680' WHERE `entry` IN (2977); -- Venture Co. Taskmaster
+DELETE FROM `creature_template_addon` WHERE `entry` IN (3736);
+INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES
+(3736, '5680'); -- Darkslayer Mordenthal
+UPDATE `creature_addon` SET `auras` = '5680' WHERE `guid` = 32917;
+
+-- Add Phasing Stealth 6718 for
+DELETE FROM `creature_template_addon` WHERE `entry` IN (15609, 15610, 15611);
+INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES
+(15609, '6718'), -- Cenarion Scout Landion
+(15610, '6718'), -- Cenarion Scout Azenel
+(15611, '6718'); -- Cenarion Scout Jalia
+UPDATE `creature_addon` SET `auras` = '6718' WHERE `guid` IN (46164,46165,46166);
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (3806);
+INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES
+(3806, '3616 8218'); -- Forsaken Infiltrator
+UPDATE `creature_addon` SET `auras` = '3616 8218' WHERE `guid` IN (34245, 34244, 34243, 34242, 34241, 34240, 34239, 34238, 34237, 34236);
+
+UPDATE `creature_template_addon` SET `auras` = '8218 8601' WHERE `entry` = 3807; -- Forsaken Assassin
+UPDATE `creature_template_addon` SET `auras` = '8218' WHERE `entry` IN (3804); -- Forsaken Intruder
+
+-- Add Slowing Poison 8601 for 
+UPDATE `creature_template_addon` SET `auras` = '8601' WHERE `entry` IN (
+544, -- Murloc Nightcrawler
+5422, -- Scorpid Hunter
+6554, -- Gorishi Stinger
+8601); -- Noxious Plaguebat
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (1110);
+INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES
+(1110, '8601');-- Skeletal Raider
+UPDATE `creature_addon` SET `auras` = '8601' WHERE `guid` IN (5138, 5137, 5130, 5122, 5121, 5120, 5103, 5102, 5096, 5093, 5091, 5052, 5049, 4977, 4889, 4885);
+
+DELETE FROM `creature_template_addon` WHERE `entry` = 10041;
+INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES (10041, '8601'); -- Gorishi Hive Queen
+
+UPDATE `creature_template_addon` SET `auras` = '3616 8601' WHERE `entry` IN (909); -- Defias Night Blade
+
+DELETE FROM `creature_template_addon` WHERE `entry` IN (4971);
+INSERT INTO `creature_template_addon` (`entry`, `auras`) VALUES
+(4971, '3616 8601'); -- Slim's Friend
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN(7110) AND `source_type`=0 AND `id` IN (0,1);
+
+UPDATE `creature_template_addon` SET `auras` = '6408 8601' WHERE `entry` = 7110; -- Jadefire Shadowstalker
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN(7110) AND `source_type`=0 AND `id`=1;
+
+UPDATE `creature_template` SET `AIName`="" WHERE entry IN (1110,544,5422,8601,3807,3806,5224);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN(7110,6554,6551) AND `source_type`=0 AND `id`=1;
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN(909,1110,544,5422,8601,3807,3806,5224) AND `source_type`=0 AND `id` IN (0,1);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN(3767,5856) AND `source_type`=0 AND `id`=0;