From 1062a0b40f0d7000b7de5ca4df89afb94b13c40c Mon Sep 17 00:00:00 2001 From: Malcrom Date: Tue, 1 Jan 2013 22:28:29 -0330 Subject: Core/Scripts: Added spell scripting for Commander Sarannis. Added Instance Template for The Botanica. Thanks to Vincent Michael --- sql/updates/world/2013_01_02_01_world_spell_script.sql | 3 +++ sql/updates/world/2013_01_02_02_world_instance_template.sql | 1 + 2 files changed, 4 insertions(+) create mode 100644 sql/updates/world/2013_01_02_01_world_spell_script.sql create mode 100644 sql/updates/world/2013_01_02_02_world_instance_template.sql (limited to 'sql') diff --git a/sql/updates/world/2013_01_02_01_world_spell_script.sql b/sql/updates/world/2013_01_02_01_world_spell_script.sql new file mode 100644 index 00000000000..a839ca6dc7b --- /dev/null +++ b/sql/updates/world/2013_01_02_01_world_spell_script.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `spell_id`=34803; +INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES +(34803,'spell_commander_sarannis_summon_reinforcements'); diff --git a/sql/updates/world/2013_01_02_02_world_instance_template.sql b/sql/updates/world/2013_01_02_02_world_instance_template.sql new file mode 100644 index 00000000000..f63a2c3ba2e --- /dev/null +++ b/sql/updates/world/2013_01_02_02_world_instance_template.sql @@ -0,0 +1 @@ +UPDATE `instance_template` SET `script`='instance_the_botanica' WHERE `map`=553; -- cgit v1.2.3