diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2021_10_04_00_world.sql | 42 |
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; |