DB/Creature: Wyrmrest Protector & Warden of the Chamber

(cherry picked from commit 08013512851feb185118da2096689c96a68c4f03)

1 files changed, 93 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_03_05_20_world_2020_12_25_00_world.sql b/sql/updates/world/master/2022_03_05_20_world_2020_12_25_00_world.sql
new file mode 100644
index 00000000000..f8bc43d1715
--- /dev/null
+++ b/sql/updates/world/master/2022_03_05_20_world_2020_12_25_00_world.sql
@@ -0,0 +1,93 @@
+-- Sniffed
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 50158; -- Wyrmrest Temple - Protector Transform (Red)
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 50159; -- Wyrmrest Temple - Protector Transform (Green)
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 50160; -- Wyrmrest Temple - Protector Transform (Bronze)
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 51117; -- Wyrmrest Temple - Protector Transform (Black)
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 51118; -- Wyrmrest Temple - Protector Transform (Blue)
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 51119; -- Wyrmrest Temple - Protector Transform (Nether)
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 55827; -- Wyrmrest Temple - Warden Transform (Black)
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 55828; -- Wyrmrest Temple - Warden Transform (Blue)
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 55829; -- Wyrmrest Temple - Warden Transform (Green)
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 55830; -- Wyrmrest Temple - Warden Transform (Bronze)
+UPDATE `serverside_spell` SET `ProcChance` = 101 WHERE `Id` = 55831; -- Wyrmrest Temple - Warden Transform (Red)
+
+DELETE FROM `serverside_spell_effect` WHERE `SpellID` IN (50158,50159,50160,51117,51118,51119,55827,55828,55829,55830,55831);
+INSERT INTO `serverside_spell_effect` (`SpellID`, `EffectIndex`, `Effect`, `EffectAura`, `EffectMiscValue1`, `ImplicitTarget1`) VALUES
+(50158, 0, 6, 56, 27952, 1),
+(50159, 0, 6, 56, 27954, 1),
+(50160, 0, 6, 56, 27955, 1),
+(51117, 0, 6, 56, 28250, 1),
+(51118, 0, 6, 56, 28251, 1),
+(51119, 0, 6, 56, 28252, 1),
+(55827, 0, 6, 56, 30077, 1),
+(55828, 0, 6, 56, 30076, 1),
+(55829, 0, 6, 56, 30073, 1),
+(55830, 0, 6, 56, 30059, 1),
+(55831, 0, 6, 56, 30072, 1);
+
+-- Warden of the Chamber, auras are static
+DELETE FROM `creature_addon` WHERE `guid` IN (105487,105488,105489,105495,131055,131056,131058,131059,131063,131064);
+INSERT INTO `creature_addon` (`guid`,`bytes2`,`auras`) VALUES
+(131063,257,"55827"),
+(131064,257,"55827"),
+(105495,257,"55828"),
+(105487,257,"55828"),
+(131058,257,"55829"),
+(131055,257,"55829"),
+(105489,257,"55830"),
+(105488,257,"55830"),
+(131056,257,"55831"),
+(131059,257,"55831");
+
+-- Native model, 14357 is disabled
+UPDATE `creature` SET `modelid` = 20737, `VerifiedBuild` = 12340 WHERE `id` = 30058;
+-- Fix positions
+UPDATE `creature` SET `position_x` = 3590.49, `position_y` = 190.253, `position_z` = -113.678, `orientation` = 6.0912 WHERE `guid` = 131056 AND `id` = 30058;
+UPDATE `creature` SET `position_x` = 3611.36, `position_y` = 204.749, `position_z` = -113.681, `orientation` = 5.46288 WHERE `guid` = 131059 AND `id` = 30058;
+
+-- Wyrmrest Protector, auras and equipment are linked together
+-- all spawned with position_z > 100 are temp summons and always spawns with random model from template (not from auras)
+-- and their equipment is always 7. No idea what exactly they do, there are multiple spawn positions and seems like some
+-- of them moves randomly on walks on paths. Don't wanna add more of them or remove existing because I have no idea how they works
+-- Since we can't add guid scripts to all of them(100 rows), non-static ones will share the same script
+DELETE FROM `creature_equip_template` WHERE `CreatureID` = 27953;
+INSERT INTO `creature_equip_template` (`CreatureID`, `ID`, `ItemID1`, `ItemID2`, `ItemID3`, `VerifiedBuild`) VALUES
+(27953, 7, 31273, 0, 19368, 12340), -- 27953
+(27953, 6, 32729, 0, 19368, 12340), -- 27953 51118 Wyrmrest Temple - Protector Transform (Blue) 14356
+(27953, 5, 38488, 0, 19368, 12340), -- 27953 50158 Wyrmrest Temple - Protector Transform (Red) 14357
+(27953, 4, 38209, 0, 19368, 12340), -- 27953 50159 Wyrmrest Temple - Protector Transform (Green) 14359
+(27953, 3, 38487, 0, 19368, 12340), -- 27953 51117 Wyrmrest Temple - Protector Transform (Black) 14355
+(27953, 2, 38491, 0, 19368, 12340), -- 27953 50160 Wyrmrest Temple - Protector Transform (Bronze) 14358
+(27953, 1, 38490, 0, 19368, 12340); -- 27953 51119 Wyrmrest Temple - Protector Transform (Nether) 25257
+
+-- Native model is random
+UPDATE `creature` SET `modelid` = 0, `equipment_id` = 0, `VerifiedBuild` = 12340 WHERE `id` = 27953 AND `position_z` < 100;
+UPDATE `creature` SET `modelid` = 0, `equipment_id` = 7 WHERE `id` = 27953 AND `position_z` > 100;
+
+-- Missing
+DELETE FROM `creature` WHERE `guid` = 131122 AND `id` = 27953;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnDifficulties`, `phaseId`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `wander_distance`, `MovementType`, `VerifiedBuild`) VALUES
+(131122, 27953, 571, '0', 0, 0, 3452.65, 250.009, 52.3788, 3.29867, 300, 0, 0, 12340);
+
+DELETE FROM `smart_scripts` WHERE `entryorguid` = 27953 AND `source_type` = 0 AND `id` = 4;
+DELETE FROM `smart_scripts` WHERE `entryorguid` BETWEEN 2795300 AND 2795305 AND `source_type` = 9;
+INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`event_param5`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_param4`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES
+(27953,0,4,0,63,0,100,0,0,0,0,0,0,88,2795300,2795305,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Just Created - Run Random Script"),
+
+(2795300,9,0,0,0,0,100,0,0,0,0,0,0,75,51119,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Add Aura 'Wyrmrest Temple - Protector Transform (Nether)'"),
+(2795300,9,1,0,0,0,100,0,0,0,0,0,0,71,1,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Change Equipment"),
+
+(2795301,9,0,0,0,0,100,0,0,0,0,0,0,75,50160,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Add Aura 'Wyrmrest Temple - Protector Transform (Bronze)'"),
+(2795301,9,1,0,0,0,100,0,0,0,0,0,0,71,2,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Change Equipment"),
+
+(2795302,9,0,0,0,0,100,0,0,0,0,0,0,75,51117,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Add Aura 'Wyrmrest Temple - Protector Transform (Black)'"),
+(2795302,9,1,0,0,0,100,0,0,0,0,0,0,71,3,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Change Equipment"),
+
+(2795303,9,0,0,0,0,100,0,0,0,0,0,0,75,50159,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Add Aura 'Wyrmrest Temple - Protector Transform (Green)'"),
+(2795303,9,1,0,0,0,100,0,0,0,0,0,0,71,4,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Change Equipment"),
+
+(2795304,9,0,0,0,0,100,0,0,0,0,0,0,75,50158,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Add Aura 'Wyrmrest Temple - Protector Transform (Red)'"),
+(2795304,9,1,0,0,0,100,0,0,0,0,0,0,71,5,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Change Equipment"),
+
+(2795305,9,0,0,0,0,100,0,0,0,0,0,0,75,51118,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Add Aura 'Wyrmrest Temple - Protector Transform (Blue)'"),
+(2795305,9,1,0,0,0,100,0,0,0,0,0,0,71,6,0,0,0,0,0,1,0,0,0,0,0,0,0,0,"Wyrmrest Protector - On Script - Change Equipment");