diff options
| author | sirikfoll <sirikfoll@hotmail.com> | 2016-12-19 12:11:02 -0200 |
|---|---|---|
| committer | DoctorKraft <DoctorKraft@users.noreply.github.com> | 2018-03-12 16:39:45 +0100 |
| commit | 2378266acd7db319e9bcfc2d2ea7e9f5ed337162 (patch) | |
| tree | ace755469955ffe307d3ab3de24ad9bdbf9a1ebf /sql/updates | |
| parent | 50f1b771e84b142c487874fd3e0044d36ddcfc3f (diff) | |
Scripts/Events Implement Pilgrim's Bounty Bountiful Table
(cherry picked from commit 75df296bb6f8d30a65f669dab6af3d1b2d6046f7)
Rename SQL file
(cherry picked from commit 13031f300ff8ef05f2d937d7ce250e6e3cb41531)
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/master/2018_03_12_12_world_2016_12_20_00_world.sql | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/sql/updates/world/master/2018_03_12_12_world_2016_12_20_00_world.sql b/sql/updates/world/master/2018_03_12_12_world_2016_12_20_00_world.sql new file mode 100644 index 00000000000..514169cb5c8 --- /dev/null +++ b/sql/updates/world/master/2018_03_12_12_world_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'); |