DB/Creature: Add some of MountCreatureID

1 files changed, 42 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2021_10_04_00_world.sql b/sql/updates/world/3.3.5/2021_10_04_00_world.sql
new file mode 100644
index 00000000000..baa42f5590f
--- /dev/null
+++ b/sql/updates/world/3.3.5/2021_10_04_00_world.sql
@@ -0,0 +1,42 @@
+--
+UPDATE `creature_template_addon` SET `MountCreatureID` = 24217 WHERE `entry` = 23580;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 3574  WHERE `entry` = 28743;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 14330 WHERE `entry` = 13144;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 14333 WHERE `entry` = 13143;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 25185 WHERE `entry` = 23340;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 19280 WHERE `entry` = 20159;
+UPDATE `creature_addon` SET `MountCreatureID` = 19280 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` = 20159) AND `mount` = 18696;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 14544 WHERE `entry` = 40192;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 14332 WHERE `entry` IN (12783,13138,13296,13300,15541,15542,19855,21390,30231,31036);
+UPDATE `creature_addon` SET `MountCreatureID` = 14332 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (12783,13138,13296,13300,15541,15542,19855,21390,30231,31036)) AND `mount` = 14337;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 14335 WHERE `entry` IN (13297,13318,15862,19907,25816);
+UPDATE `creature_addon` SET `MountCreatureID` = 14335 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (13297,13318,15862,19907,25816)) AND `mount` = 14577;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 14331 WHERE `entry` IN (19905,23998,27028,27367,29302,31651);
+UPDATE `creature_addon` SET `MountCreatureID` = 14331 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (19905,23998,27028,27367,29302,31651)) AND `mount` = 10719;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 33416 WHERE `entry` IN (33739,35330);
+UPDATE `creature_template_addon` SET `MountCreatureID` = 33298 WHERE `entry` IN (33738,35332);
+UPDATE `creature_template_addon` SET `MountCreatureID` = 33414 WHERE `entry` IN (33384,33749,35327);
+UPDATE `creature_template_addon` SET `MountCreatureID` = 14553 WHERE `entry` IN (26907,33629);
+UPDATE `creature_addon` SET `MountCreatureID` = 14553 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (26907,33629)) AND `mount` = 14374;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 14563 WHERE `entry` = 33558;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 14540 WHERE `entry` IN (15700,28613);
+UPDATE `creature_template_addon` SET `MountCreatureID` = 33408 WHERE `entry` IN (33743,35329);
+UPDATE `creature_template_addon` SET `MountCreatureID` = 33300 WHERE `entry` IN (33748,35325);
+UPDATE `creature_template_addon` SET `MountCreatureID` = 33409 WHERE `entry` IN (33520,33521,33744,35314);
+UPDATE `creature_addon` SET `MountCreatureID` = 33409 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (31564)) AND `mount` = 29260;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 33299 WHERE `entry` IN (33745,35323,39173,39654,40391);
+UPDATE `creature_template_addon` SET `MountCreatureID` = 33418 WHERE `entry` IN (33746,35326);
+UPDATE `creature_template_addon` SET `MountCreatureID` = 35148 WHERE `entry` = 35589;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 35362 WHERE `entry` IN (26007);
+UPDATE `creature_addon` SET `MountCreatureID` = 35362 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (26007)) AND `mount` = 29794;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 39938 WHERE `entry` = 39103;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 39973 WHERE `entry` = 39837;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 40057 WHERE `entry` = 39271;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 40415 WHERE `entry` = 40416;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 34156 WHERE `entry` IN (11701,11702);
+UPDATE `creature_addon` SET `MountCreatureID` = 34156 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (11701,11702)) AND `mount` = 29102;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 34017 WHERE `entry` = 33561;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 22000 WHERE `entry` IN (21719,22006,22197,22274,23321,23440,23441);
+UPDATE `creature_addon` SET `MountCreatureID` = 22000 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (21719,22006,22197,22274,23321,23440,23441)) AND `mount` = 20684;
+UPDATE `creature_template_addon` SET `MountCreatureID` = 21627 WHERE `entry` IN (19806,22018);
+UPDATE `creature_addon` SET `MountCreatureID` = 21627 WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (19806,22018)) AND `mount` = 20937;