Scripts/Events Implement Pilgrim's Bounty Bountiful Table

1 files changed, 30 insertions, 0 deletions

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
new file mode 100644
index 00000000000..514169cb5c8
--- /dev/null
+++ b/sql/updates/world/3.3.5/9999_99_99_99_world_Pilgrim.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');