From 75df296bb6f8d30a65f669dab6af3d1b2d6046f7 Mon Sep 17 00:00:00 2001 From: sirikfoll Date: Mon, 19 Dec 2016 12:11:02 -0200 Subject: Scripts/Events Implement Pilgrim's Bounty Bountiful Table --- .../world/3.3.5/9999_99_99_99_world_Pilgrim.sql | 30 ++++++++++++++++++++++ 1 file changed, 30 insertions(+) create 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/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'); -- cgit v1.2.3