DB/Creatures: added all new 4.4.2 creature entries for the MoP promotion mounts and Element Rune Protocol: Twilight

1 files changed, 82 insertions, 0 deletions

diff --git a/sql/updates/world/cata_classic/2025_04_05_00_world.sql b/sql/updates/world/cata_classic/2025_04_05_00_world.sql
new file mode 100644
index 00000000000..e9899a5a60b
--- /dev/null
+++ b/sql/updates/world/cata_classic/2025_04_05_00_world.sql
@@ -0,0 +1,82 @@
+DELETE FROM `creature_template_difficulty` WHERE (`DifficultyID`=0 AND `Entry` IN (241468,241467,241010,241008,240325,240324,240323,240322,240321,240320,240309,240308,240090,240012,239974,239945,237248,234505,234503,73873));
+INSERT INTO `creature_template_difficulty` (`Entry`, `DifficultyID`, `HealthScalingExpansion`, `HealthModifier`, `ManaModifier`, `CreatureDifficultyID`, `TypeFlags`, `TypeFlags2`) VALUES
+(241468, 0, 2, 1, 1, 0, 0x0, 0), -- Zarstrasza
+(241467, 0, 2, 1, 1, 0, 0x0, 0), -- Sylstrasza
+(241010, 0, 3, 2.65000009536743164, 1, 0, 0x48, 0), -- Forgotten One
+(241008, 0, 3, 1.5, 3367.75927734375, 0, 0x440, 0), -- Mana Void
+(240325, 0, 3, 5, 1, 0, 0x40, 0), -- Shadowed Globule
+(240324, 0, 3, 5, 1, 0, 0x40, 0), -- Glowing Globule
+(240323, 0, 3, 5, 1, 0, 0x40, 0), -- Crimson Globule
+(240322, 0, 3, 5, 1, 0, 0x40, 0), -- Cobalt Globule
+(240321, 0, 3, 5, 1, 0, 0x40, 0), -- Dark Globule
+(240320, 0, 3, 5, 1, 0, 0x40, 0), -- Acidic Globule
+(240309, 0, 3, 25, 10, 0, 0x48, 0), -- Wyrmrest Defender
+(240308, 0, 3, 25, 10, 0, 0x48, 0), -- Wyrmrest Defender
+(240090, 0, 3, 4, 1, 0, 0x8, 0), -- Trop the Heroic
+(240012, 0, 2, 1, 1, 0, 0x1000, 0), -- Dragon Soultaur
+(239974, 0, 0, 1, 1, 0, 0x0, 0), -- Denaa Hollowbark
+(239945, 0, 0, 1, 1, 0, 0x0, 0), -- Alania Hollowbark
+(237248, 0, 0, 1, 1, 0, 0x0, 0), -- Joyous
+(234505, 0, 3, 1, 1, 0, 0x0, 0), -- Sha-Touched Cloud Serpent
+(234503, 0, 3, 1, 1, 0, 0x0, 0), -- Sha-Touched Riding Tiger
+(73873, 0, 0, 1, 1, 0, 0x8000000, 0); -- Shop
+
+UPDATE `creature_template_difficulty` SET `TypeFlags2`=128 WHERE (`Entry`=53695 AND `DifficultyID`=0); -- Rageface
+UPDATE `creature_template_difficulty` SET `TypeFlags2`=128 WHERE (`Entry`=53694 AND `DifficultyID`=0); -- Riplimb
+UPDATE `creature_template_difficulty` SET `TypeFlags2`=128 WHERE (`Entry`=41270 AND `DifficultyID`=0); -- Onyxia
+UPDATE `creature_template_difficulty` SET `TypeFlags2`=128 WHERE (`Entry`=39625 AND `DifficultyID`=0); -- General Umbriss
+
+DELETE FROM `creature_template` WHERE `entry` IN (234503 /*Sha-Touched Riding Tiger*/, 234505 /*Sha-Touched Cloud Serpent*/, 237248 /*Joyous*/, 239945 /*Alania Hollowbark*/, 239974 /*Denaa Hollowbark*/, 240012 /*Dragon Soultaur*/, 240090 /*Trop the Heroic*/, 240308 /*Wyrmrest Defender*/, 240309 /*Wyrmrest Defender*/, 240320 /*Acidic Globule*/, 240321 /*Dark Globule*/, 240322 /*Cobalt Globule*/, 240323 /*Crimson Globule*/, 240324 /*Glowing Globule*/, 240325 /*Shadowed Globule*/, 241008 /*Mana Void*/, 241010 /*Forgotten One*/, 241467 /*Sylstrasza*/, 241468 /*Zarstrasza*/, 73873 /*Shop*/);
+INSERT INTO `creature_template` (`entry`, `Civilian`, `KillCredit1`, `KillCredit2`, `name`, `femaleName`, `subname`, `TitleAlt`, `IconName`, `RequiredExpansion`, `VignetteID`, `unit_class`, `WidgetSetID`, `WidgetSetUnitConditionID`, `Classification`, `family`, `type`, `PetSpellDataId`, `RacialLeader`, `movementId`, `VerifiedBuild`) VALUES
+(234503, 0, 0, 0, 'Sha-Touched Riding Tiger', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 60142), -- Sha-Touched Riding Tiger
+(234505, 0, 0, 0, 'Sha-Touched Cloud Serpent', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 1, 0, 0, 0, 60142), -- Sha-Touched Cloud Serpent
+(237248, 1, 0, 0, 'Joyous', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, 0, 12, 0, 0, 121, 60142), -- Joyous
+(239945, 0, 0, 0, 'Alania Hollowbark', NULL, 'Molten Front Recruiter', NULL, NULL, 0, 0, 1, 0, 0, 0, 0, 7, 0, 0, 0, 60142), -- Alania Hollowbark
+(239974, 0, 0, 0, 'Denaa Hollowbark', NULL, 'Molten Front Recruiter', NULL, NULL, 0, 0, 1, 0, 0, 0, 0, 7, 0, 0, 0, 60142), -- Denaa Hollowbark
+(240012, 1, 0, 0, 'Dragon Soultaur', NULL, 'Dragon Soul Supplies', NULL, NULL, 0, 0, 8, 0, 0, 0, 0, 9, 0, 0, 0, 60142), -- Dragon Soultaur
+(240090, 0, 0, 0, 'Trop the Heroic', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 7, 0, 0, 164, 60142), -- Trop the Heroic
+(240308, 0, 0, 0, 'Wyrmrest Defender', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 7, 0, 0, 0, 60142), -- Wyrmrest Defender
+(240309, 0, 0, 0, 'Wyrmrest Defender', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 7, 0, 0, 0, 60142), -- Wyrmrest Defender
+(240320, 0, 0, 0, 'Acidic Globule', NULL, 'Blood of Shu\'ma', NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 10, 0, 0, 89, 60142), -- Acidic Globule
+(240321, 0, 0, 0, 'Dark Globule', NULL, 'Blood of Shu\'ma', NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 10, 0, 0, 89, 60142), -- Dark Globule
+(240322, 0, 0, 0, 'Cobalt Globule', NULL, 'Blood of Shu\'ma', NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 10, 0, 0, 89, 60142), -- Cobalt Globule
+(240323, 0, 0, 0, 'Crimson Globule', NULL, 'Blood of Shu\'ma', NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 10, 0, 0, 89, 60142), -- Crimson Globule
+(240324, 0, 0, 0, 'Glowing Globule', NULL, 'Blood of Shu\'ma', NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 10, 0, 0, 89, 60142), -- Glowing Globule
+(240325, 0, 0, 0, 'Shadowed Globule', NULL, 'Blood of Shu\'ma', NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 10, 0, 0, 89, 60142), -- Shadowed Globule
+(241008, 0, 0, 0, 'Mana Void', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 10, 0, 0, 70, 60142), -- Mana Void
+(241010, 0, 0, 0, 'Forgotten One', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 1, 0, 10, 0, 0, 150, 60142), -- Forgotten One
+(241467, 1, 0, 0, 'Sylstrasza', NULL, 'Obsidian Fragment Exchange', NULL, NULL, 0, 0, 8, 0, 0, 0, 0, 2, 0, 0, 0, 60142), -- Sylstrasza
+(241468, 1, 0, 0, 'Zarstrasza', NULL, 'Obsidian Fragment Exchange', NULL, NULL, 0, 0, 8, 0, 0, 0, 0, 2, 0, 0, 0, 60142), -- Zarstrasza
+(73873, 0, 0, 0, 'Shop', NULL, NULL, NULL, NULL, 0, 0, 1, 0, 0, 0, 0, 7, 0, 0, 0, 60142); -- Shop
+
+UPDATE `creature_template` SET `name`='Lord Devrestrasz', `VerifiedBuild`=60142 WHERE `entry`=55476; -- Lord Afrasastrasz
+
+DELETE FROM `creature_template_model` WHERE (`Idx`=0 AND `CreatureID` IN (241468,241467,241010,241008,240325,240324,240323,240322,240321,240320,240309,240308,240090,240012,239974,239945,237248,234505,234503,73873)) OR (`Idx`=1 AND `CreatureID` IN (241008,240309,240308)) OR (`Idx`=3 AND `CreatureID` IN (240309,240308)) OR (`Idx`=2 AND `CreatureID` IN (240309,240308));
+INSERT INTO `creature_template_model` (`CreatureID`, `Idx`, `CreatureDisplayID`, `DisplayScale`, `Probability`, `VerifiedBuild`) VALUES
+(241468, 0, 127918, 1, 1, 60142), -- Zarstrasza
+(241467, 0, 28017, 0.800000011920928955, 1, 60142), -- Sylstrasza
+(241010, 0, 27849, 1, 1, 60142), -- Forgotten One
+(241008, 1, 1126, 1, 0, 60142), -- Mana Void
+(241008, 0, 39369, 1, 1, 60142), -- Mana Void
+(240325, 0, 39788, 1, 1, 60142), -- Shadowed Globule
+(240324, 0, 39630, 1, 1, 60142), -- Glowing Globule
+(240323, 0, 39629, 1, 1, 60142), -- Crimson Globule
+(240322, 0, 39787, 1, 1, 60142), -- Cobalt Globule
+(240321, 0, 39786, 1, 1, 60142), -- Dark Globule
+(240320, 0, 39785, 1, 1, 60142), -- Acidic Globule
+(240309, 3, 39610, 1, 1, 60142), -- Wyrmrest Defender
+(240309, 2, 39606, 1, 1, 60142), -- Wyrmrest Defender
+(240309, 1, 39600, 1, 1, 60142), -- Wyrmrest Defender
+(240309, 0, 39599, 1, 1, 60142), -- Wyrmrest Defender
+(240308, 3, 39619, 1, 1, 60142), -- Wyrmrest Defender
+(240308, 2, 39618, 1, 1, 60142), -- Wyrmrest Defender
+(240308, 1, 39614, 1, 1, 60142), -- Wyrmrest Defender
+(240308, 0, 39613, 1, 1, 60142), -- Wyrmrest Defender
+(240090, 0, 3037, 1, 1, 60142), -- Trop the Heroic
+(240012, 0, 21471, 0.85000002384185791, 1, 60142), -- Dragon Soultaur
+(239974, 0, 127435, 1, 1, 60142), -- Denaa Hollowbark
+(239945, 0, 127433, 1, 1, 60142), -- Alania Hollowbark
+(237248, 0, 126072, 0.035000000149011611, 1, 60142), -- Joyous
+(234505, 0, 124486, 1, 0, 60142), -- Sha-Touched Cloud Serpent
+(234503, 0, 124485, 1, 0, 60142), -- Sha-Touched Riding Tiger
+(73873, 0, 11686, 1, 1, 60142); -- Shop