aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorKeader <keader.android@gmail.com>2016-06-23 02:30:07 +0200
committerjoschiwald <joschiwald.trinity@gmail.com>2016-07-16 16:35:43 +0200
commit64f0691a27d6ef818a612913dde405ae90d9b4bc (patch)
treeb2b60f52881d071bc9aa1577313292dd5c51e116 /sql/updates
parent1849a4fcc197d38233eda4d11593f5bee11faa06 (diff)
Core/Scripts: Hallow's End Pumpkin Treat
Add all 6 spells available from item 20557, Hallow's End Pumpkin Treat: - Hallow's End Candy, Orange Giant (24924) - Hallow's End Candy, Skeleton (24925) - Hallow's End Candy, Pirate (24926) - Hallow's End Candy, Ghost (24927) - Hallow's End Candy, Female Defias Pirate (44742) - Hallow's End Candy, Male Defias Pirate (44743) Thanks @Keader for creating the new spell scripts & SQL, saved me a lot of time! :-) (cherry picked from commit cee1c0789acb7d75e453ed355a5d68781a5dec4c)
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/6.x/2016_07_16_02_world_2016_07_16_07_world.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/6.x/2016_07_16_02_world_2016_07_16_07_world.sql b/sql/updates/world/6.x/2016_07_16_02_world_2016_07_16_07_world.sql
new file mode 100644
index 00000000000..75af8add3d1
--- /dev/null
+++ b/sql/updates/world/6.x/2016_07_16_02_world_2016_07_16_07_world.sql
@@ -0,0 +1,5 @@
+-- enable 2 new spell scripts: spell_hallow_end_candy & spell_hallow_end_candy_pirate
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_hallow_end_candy','spell_hallow_end_candy_pirate');
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(24930,'spell_hallow_end_candy'),
+(24926,'spell_hallow_end_candy_pirate');