From 34fc72cf71e4d54aece21e21f8b47f3a866fe5b4 Mon Sep 17 00:00:00 2001
From: joschiwald <joschiwald@online.de>
Date: Fri, 26 Jul 2013 00:32:09 +0200
Subject: DB/Conditions: Fix gossip condition for Bat Handler Camille <Bat
 Handler>

Closes #10240
---
 .../world/2013_07_25_00_spell_script_names.sql     | 22 ----------------------
 .../2013_07_25_00_world_spell_script_names.sql     | 22 ++++++++++++++++++++++
 .../world/2013_07_25_01_world_conditions.sql       |  2 ++
 3 files changed, 24 insertions(+), 22 deletions(-)
 delete mode 100644 sql/updates/world/2013_07_25_00_spell_script_names.sql
 create mode 100644 sql/updates/world/2013_07_25_00_world_spell_script_names.sql
 create mode 100644 sql/updates/world/2013_07_25_01_world_conditions.sql

(limited to 'sql/updates')

diff --git a/sql/updates/world/2013_07_25_00_spell_script_names.sql b/sql/updates/world/2013_07_25_00_spell_script_names.sql
deleted file mode 100644
index 14e6d16df44..00000000000
--- a/sql/updates/world/2013_07_25_00_spell_script_names.sql
+++ /dev/null
@@ -1,22 +0,0 @@
-DELETE FROM `spell_script_names` WHERE `ScriptName` IN (
-'spell_warl_banish',
-'spell_dru_enrage',
-'spell_pri_mana_burn',
-'spell_pri_guardian_spirit',
-'spell_dk_improved_blood_presence',
-'spell_dk_improved_frost_presence',
-'spell_dk_improved_unholy_presence',
-'spell_dk_presence'
-);
-
-INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
-(-710,  'spell_warl_banish'),
-(5229,  'spell_dru_enrage'),
-(8129,  'spell_pri_mana_burn'),
-(47788, 'spell_pri_guardian_spirit'),
-(-50365,'spell_dk_improved_blood_presence'),
-(-50384,'spell_dk_improved_frost_presence'),
-(-50391,'spell_dk_improved_unholy_presence'),
-(48266, 'spell_dk_presence'),
-(48263, 'spell_dk_presence'),
-(48265, 'spell_dk_presence');
diff --git a/sql/updates/world/2013_07_25_00_world_spell_script_names.sql b/sql/updates/world/2013_07_25_00_world_spell_script_names.sql
new file mode 100644
index 00000000000..14e6d16df44
--- /dev/null
+++ b/sql/updates/world/2013_07_25_00_world_spell_script_names.sql
@@ -0,0 +1,22 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN (
+'spell_warl_banish',
+'spell_dru_enrage',
+'spell_pri_mana_burn',
+'spell_pri_guardian_spirit',
+'spell_dk_improved_blood_presence',
+'spell_dk_improved_frost_presence',
+'spell_dk_improved_unholy_presence',
+'spell_dk_presence'
+);
+
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(-710,  'spell_warl_banish'),
+(5229,  'spell_dru_enrage'),
+(8129,  'spell_pri_mana_burn'),
+(47788, 'spell_pri_guardian_spirit'),
+(-50365,'spell_dk_improved_blood_presence'),
+(-50384,'spell_dk_improved_frost_presence'),
+(-50391,'spell_dk_improved_unholy_presence'),
+(48266, 'spell_dk_presence'),
+(48263, 'spell_dk_presence'),
+(48265, 'spell_dk_presence');
diff --git a/sql/updates/world/2013_07_25_01_world_conditions.sql b/sql/updates/world/2013_07_25_01_world_conditions.sql
new file mode 100644
index 00000000000..1990fe3094b
--- /dev/null
+++ b/sql/updates/world/2013_07_25_01_world_conditions.sql
@@ -0,0 +1,2 @@
+-- Fix gossip condition for Bat Handler Camille <Bat Handler>
+UPDATE `conditions` SET `ConditionTypeOrReference`=28 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8894 AND `SourceEntry`=0 AND `ConditionValue1`=11229;
-- 
cgit v1.2.3