From 13031f300ff8ef05f2d937d7ce250e6e3cb41531 Mon Sep 17 00:00:00 2001 From: Kittnz Date: Tue, 20 Dec 2016 16:47:52 +0100 Subject: Rename SQL file --- sql/updates/world/3.3.5/2016_12_20_00_world.sql | 30 ++++++++++++++++++++++ .../world/3.3.5/9999_99_99_99_world_Pilgrim.sql | 30 ---------------------- 2 files changed, 30 insertions(+), 30 deletions(-) create mode 100644 sql/updates/world/3.3.5/2016_12_20_00_world.sql delete mode 100644 sql/updates/world/3.3.5/9999_99_99_99_world_Pilgrim.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2016_12_20_00_world.sql b/sql/updates/world/3.3.5/2016_12_20_00_world.sql new file mode 100644 index 00000000000..514169cb5c8 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_12_20_00_world.sql @@ -0,0 +1,30 @@ +UPDATE `creature_template` SET `ScriptName`='npc_bountiful_table' WHERE `entry`=32823; +UPDATE `creature_template_addon` SET `auras`='' WHERE `entry` IN (34812,34819,34822,34823,34824); + +DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( +'spell_pilgrims_bounty_on_plate_turkey', +'spell_pilgrims_bounty_on_plate_cranberries', +'spell_pilgrims_bounty_on_plate_stuffing', +'spell_pilgrims_bounty_on_plate_sweet_potatoes', +'spell_pilgrims_bounty_on_plate_pie', +'spell_pilgrims_bounty_a_serving_of_cranberries', +'spell_pilgrims_bounty_a_serving_of_pie', +'spell_pilgrims_bounty_a_serving_of_stuffing', +'spell_pilgrims_bounty_a_serving_of_turkey', +'spell_pilgrims_bounty_a_serving_of_potatoes'); +INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES +(66250,'spell_pilgrims_bounty_on_plate_turkey'), +(66261,'spell_pilgrims_bounty_on_plate_cranberries'), +(66259,'spell_pilgrims_bounty_on_plate_stuffing'), +(66262,'spell_pilgrims_bounty_on_plate_sweet_potatoes'), +(66260,'spell_pilgrims_bounty_on_plate_pie'), +(61804,'spell_pilgrims_bounty_a_serving_of_cranberries'), +(61805,'spell_pilgrims_bounty_a_serving_of_pie'), +(61806,'spell_pilgrims_bounty_a_serving_of_stuffing'), +(61807,'spell_pilgrims_bounty_a_serving_of_turkey'), +(61808,'spell_pilgrims_bounty_a_serving_of_potatoes'), +(61793,'spell_pilgrims_bounty_a_serving_of_cranberries'), +(61794,'spell_pilgrims_bounty_a_serving_of_pie'), +(61795,'spell_pilgrims_bounty_a_serving_of_stuffing'), +(61796,'spell_pilgrims_bounty_a_serving_of_turkey'), +(61797,'spell_pilgrims_bounty_a_serving_of_potatoes'); diff --git a/sql/updates/world/3.3.5/9999_99_99_99_world_Pilgrim.sql b/sql/updates/world/3.3.5/9999_99_99_99_world_Pilgrim.sql deleted file mode 100644 index 514169cb5c8..00000000000 --- a/sql/updates/world/3.3.5/9999_99_99_99_world_Pilgrim.sql +++ /dev/null @@ -1,30 +0,0 @@ -UPDATE `creature_template` SET `ScriptName`='npc_bountiful_table' WHERE `entry`=32823; -UPDATE `creature_template_addon` SET `auras`='' WHERE `entry` IN (34812,34819,34822,34823,34824); - -DELETE FROM `spell_script_names` WHERE `ScriptName` IN ( -'spell_pilgrims_bounty_on_plate_turkey', -'spell_pilgrims_bounty_on_plate_cranberries', -'spell_pilgrims_bounty_on_plate_stuffing', -'spell_pilgrims_bounty_on_plate_sweet_potatoes', -'spell_pilgrims_bounty_on_plate_pie', -'spell_pilgrims_bounty_a_serving_of_cranberries', -'spell_pilgrims_bounty_a_serving_of_pie', -'spell_pilgrims_bounty_a_serving_of_stuffing', -'spell_pilgrims_bounty_a_serving_of_turkey', -'spell_pilgrims_bounty_a_serving_of_potatoes'); -INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES -(66250,'spell_pilgrims_bounty_on_plate_turkey'), -(66261,'spell_pilgrims_bounty_on_plate_cranberries'), -(66259,'spell_pilgrims_bounty_on_plate_stuffing'), -(66262,'spell_pilgrims_bounty_on_plate_sweet_potatoes'), -(66260,'spell_pilgrims_bounty_on_plate_pie'), -(61804,'spell_pilgrims_bounty_a_serving_of_cranberries'), -(61805,'spell_pilgrims_bounty_a_serving_of_pie'), -(61806,'spell_pilgrims_bounty_a_serving_of_stuffing'), -(61807,'spell_pilgrims_bounty_a_serving_of_turkey'), -(61808,'spell_pilgrims_bounty_a_serving_of_potatoes'), -(61793,'spell_pilgrims_bounty_a_serving_of_cranberries'), -(61794,'spell_pilgrims_bounty_a_serving_of_pie'), -(61795,'spell_pilgrims_bounty_a_serving_of_stuffing'), -(61796,'spell_pilgrims_bounty_a_serving_of_turkey'), -(61797,'spell_pilgrims_bounty_a_serving_of_potatoes'); -- cgit v1.2.3