DB/Creature: Migrate elder's auras to c_t_a (Lunar Festival)

Closes #24896

(cherry picked from commit d5be1e7b1f0d63913b6614c185a05f91adc17044)

1 files changed, 82 insertions, 0 deletions

diff --git a/sql/updates/world/master/2022_01_21_22_world_2020_07_05_02_world.sql b/sql/updates/world/master/2022_01_21_22_world_2020_07_05_02_world.sql
new file mode 100644
index 00000000000..fd346065db4
--- /dev/null
+++ b/sql/updates/world/master/2022_01_21_22_world_2020_07_05_02_world.sql
@@ -0,0 +1,82 @@
+--
+UPDATE `creature_template` SET `AIName` = "" WHERE `entry` IN (15549,15556,15557,15558,15559,15560,15561,15562,15563,15564,15565,15566,15567,15568,15569,15570,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15607,15871,30348,30357,30358,30359,30360,30362,30363,30364,30365,30367,30368,30369,30370,30371,30372,30373,30374,30375,30531,30533,30534,30535,30536,30537,30538);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (15549,15556,15557,15558,15559,15560,15561,15562,15563,15564,15565,15566,15567,15568,15569,15570,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15607,15871,30348,30357,30358,30359,30360,30362,30363,30364,30365,30367,30368,30369,30370,30371,30372,30373,30374,30375,30531,30533,30534,30535,30536,30537,30538) AND `source_type` = 0;
+UPDATE `creature` SET `spawntimesecs` = 300 WHERE `id` IN (15549,15556,15557,15558,15559,15560,15561,15562,15563,15564,15565,15566,15567,15568,15569,15570,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15607,15871,30348,30357,30358,30359,30360,30362,30363,30364,30365,30367,30368,30369,30370,30371,30372,30373,30374,30375,30531,30533,30534,30535,30536,30537,30538);
+DELETE FROM `creature_addon` WHERE `guid` IN (SELECT `guid` FROM `creature` WHERE `id` IN (15549,15556,15557,15558,15559,15560,15561,15562,15563,15564,15565,15566,15567,15568,15569,15570,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15607,15871,30348,30357,30358,30359,30360,30362,30363,30364,30365,30367,30368,30369,30370,30371,30372,30373,30374,30375,30531,30533,30534,30535,30536,30537,30538));
+DELETE FROM `creature_template_addon` WHERE `entry` IN (15549,15556,15557,15558,15559,15560,15561,15562,15563,15564,15565,15566,15567,15568,15569,15570,15572,15573,15574,15575,15576,15577,15578,15579,15580,15581,15582,15583,15584,15585,15586,15587,15588,15592,15593,15594,15595,15596,15597,15598,15599,15600,15601,15602,15603,15604,15605,15606,15607,15871,30348,30357,30358,30359,30360,30362,30363,30364,30365,30367,30368,30369,30370,30371,30372,30373,30374,30375,30531,30533,30534,30535,30536,30537,30538);
+INSERT INTO `creature_template_addon` (`entry`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`visibilityDistanceType`,`auras`) VALUES
+(15549,0,0,0,4097,0,0,"25824"),
+(15556,0,0,0,4097,0,0,"25824"),
+(15557,0,0,0,4097,0,0,"25824"),
+(15558,0,0,0,4097,0,0,"25824"),
+(15559,0,0,0,4097,0,0,"25824"),
+(15560,0,0,0,4097,0,0,"25824"),
+(15561,0,0,0,4097,0,0,"25824"),
+(15562,0,0,0,4097,0,0,"25824"),
+(15563,0,0,0,4097,0,0,"25824"),
+(15564,0,0,0,4097,0,0,"25824"),
+(15565,0,0,0,4097,0,0,"25824"),
+(15566,0,0,0,4097,0,0,"25824"),
+(15567,0,0,0,4097,0,0,"25824"),
+(15568,0,0,0,4097,0,0,"25824"),
+(15569,0,0,0,4097,0,0,"25824"),
+(15570,0,0,0,4097,0,0,"25824"),
+(15572,0,0,0,4097,0,0,"25824"),
+(15573,0,0,0,4097,0,0,"25824"),
+(15574,0,0,0,4097,0,0,"25824"),
+(15575,0,0,0,4097,0,0,"25824"),
+(15576,0,0,0,4097,0,0,"25824"),
+(15577,0,0,0,4097,0,0,"25824"),
+(15578,0,0,0,4097,0,0,"25824"),
+(15579,0,0,0,4097,0,0,"25824"),
+(15580,0,0,0,4097,0,0,"25824"),
+(15581,0,0,0,4097,0,0,"25824"),
+(15582,0,0,0,4097,0,0,"25824"),
+(15583,0,0,0,4097,0,0,"25824"),
+(15584,0,0,0,4097,0,0,"25824"),
+(15585,0,0,0,4097,0,0,"25824"),
+(15586,0,0,0,4097,0,0,"25824"),
+(15587,0,0,0,4097,0,0,"25824"),
+(15588,0,0,0,4097,0,0,"25824"),
+(15592,0,0,0,4097,0,0,"25824"),
+(15593,0,0,0,4097,0,0,"25824"),
+(15594,0,0,0,4097,0,0,"25824"),
+(15595,0,0,0,4097,0,0,"25824"),
+(15596,0,0,0,4097,0,0,"25824"),
+(15597,0,0,0,4097,0,0,"25824"),
+(15598,0,0,0,4097,0,0,"25824"),
+(15599,0,0,0,4097,0,0,"25824"),
+(15600,0,0,0,4097,0,0,"25824"),
+(15601,0,0,0,4097,0,0,"25824"),
+(15602,0,0,0,4097,0,0,"25824"),
+(15603,0,0,0,4097,0,0,"25824"),
+(15604,0,0,0,4097,0,0,"25824"),
+(15605,0,0,0,4097,0,0,"25824"),
+(15606,0,0,0,4097,0,0,"25824"),
+(15607,0,0,0,4097,0,0,"25824"),
+(15871,0,0,0,4097,0,0,"25824"),
+(30348,0,0,0,4097,0,0,"25824"),
+(30357,0,0,0,4097,0,0,"25824"),
+(30358,0,0,0,4097,0,0,"25824"),
+(30359,0,0,0,4097,0,0,"25824"),
+(30360,0,0,0,4097,0,0,"25824"),
+(30362,0,0,0,4097,0,0,"25824"),
+(30363,0,0,0,4097,0,0,"25824"),
+(30364,0,0,0,4097,0,0,"25824"),
+(30365,0,0,0,4097,0,0,"25824"),
+(30367,0,0,0,4097,0,0,"25824"),
+(30368,0,0,0,4097,0,0,"25824"),
+(30369,0,0,0,4097,0,0,"25824"),
+(30370,0,0,0,4097,0,0,"25824"),
+(30371,0,0,0,4097,0,0,"25824"),
+(30372,0,0,0,4097,0,0,"25824"),
+(30373,0,0,0,4097,0,0,"25824"),
+(30374,0,0,0,4097,0,0,"25824"),
+(30375,0,0,0,4097,0,0,"25824"),
+(30531,0,0,0,4097,0,0,"25824"),
+(30533,0,0,0,4097,0,0,"25824"),
+(30534,0,0,0,4097,0,0,"25824"),
+(30535,0,0,0,4097,0,0,"25824"),
+(30536,0,0,0,4097,0,0,"25824"),
+(30537,0,0,0,4097,0,0,"25824"),
+(30538,0,0,0,4097,0,0,"25824");