aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorVincent_Michael <Vincent_Michael@gmx.de>2013-01-11 23:36:23 +0100
committerVincent_Michael <Vincent_Michael@gmx.de>2013-01-11 23:37:54 +0100
commit2fcd4c381c4b44082fd24afb6e6d11fc242636dc (patch)
treebb3aa031faa54b09adb461c69eb35885545ce507 /sql
parentb13e5694b6972ea523b44382788bff267f0f5dfa (diff)
DB/Conditions: Convert shadowstep spell script in conditions
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2013_01_11_01_world_conditions.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/world/2013_01_11_01_world_conditions.sql b/sql/updates/world/2013_01_11_01_world_conditions.sql
new file mode 100644
index 00000000000..352efb792b4
--- /dev/null
+++ b/sql/updates/world/2013_01_11_01_world_conditions.sql
@@ -0,0 +1,5 @@
+DELETE FROM `spell_script_names` WHERE `spell_id`=36554;
+
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=36554;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(17, 0, 36554, 0, 0, 21, 0, 1024, 0, 0, 1, 103, 0, '', 'Shadowstep - not using Shadowstep while rooted');