aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorShauren <none@none>2010-11-18 15:57:23 +0100
committerShauren <none@none>2010-11-18 15:57:23 +0100
commit418cf49a728f96574e924abe0672df0f4261b650 (patch)
treec8aab032b84071ddc669742144d6fb0cead41942 /sql/updates
parent87d723405e5d34bc9b16656f6bf30a48d010c50d (diff)
Scripts/Icecrown Citadel: Changed spell timers for Lord Marrowgar, taken from sniffs
Scripts/Icecrown Citadel: Converted texts to new TextMgr Scripts/Icecrown Citadel: General cleanup & coding style consistency Scripts/Icecrown Citadel: Added missing spell script names --HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/10468_world_script_texts.sql1
-rw-r--r--sql/updates/10468_world_spell_script_names.sql15
2 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/10468_world_script_texts.sql b/sql/updates/10468_world_script_texts.sql
new file mode 100644
index 00000000000..bb3ed4d7299
--- /dev/null
+++ b/sql/updates/10468_world_script_texts.sql
@@ -0,0 +1 @@
+DELETE FROM `script_texts` WHERE `entry` BETWEEN -1631139 AND -1631000;
diff --git a/sql/updates/10468_world_spell_script_names.sql b/sql/updates/10468_world_spell_script_names.sql
new file mode 100644
index 00000000000..89f6b5b79e1
--- /dev/null
+++ b/sql/updates/10468_world_spell_script_names.sql
@@ -0,0 +1,15 @@
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (69057,70826,72088,72089) AND `ScriptName`='spell_marrowgar_bone_spike_graveyard';
+DELETE FROM `spell_script_names` WHERE `spell_id` IN (70903,72498,72499,72500,71236,72495,72496,72497) AND `ScriptName`='spell_cultist_dark_martyrdrom';
+INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES
+(69057,'spell_marrowgar_bone_spike_graveyard'),
+(70826,'spell_marrowgar_bone_spike_graveyard'),
+(72088,'spell_marrowgar_bone_spike_graveyard'),
+(72089,'spell_marrowgar_bone_spike_graveyard'),
+(70903,'spell_cultist_dark_martyrdrom'),
+(72498,'spell_cultist_dark_martyrdrom'),
+(72499,'spell_cultist_dark_martyrdrom'),
+(72500,'spell_cultist_dark_martyrdrom'),
+(71236,'spell_cultist_dark_martyrdrom'),
+(72495,'spell_cultist_dark_martyrdrom'),
+(72496,'spell_cultist_dark_martyrdrom'),
+(72497,'spell_cultist_dark_martyrdrom');