aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMachiavelli <machiaveltman@gmail.com>2011-12-19 02:13:14 -0800
committerMachiavelli <machiaveltman@gmail.com>2011-12-19 02:13:14 -0800
commit40e235a2ccf3661a5cf18c6946ae95ba2e544771 (patch)
tree7dfdc62af3d94dd5540b5846138a7b2c80d95e3f /sql
parent392baafed4b32c9722d13b9a2552e98f1ab55982 (diff)
parentb119558ee1d8198ef29ed393badf6e0ad9491de1 (diff)
Merge pull request #4387 from horn/master
Core/Dungeon Finder: Fixed LFG rewards in UK, ToCH, CoS and DTK.
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/2011_12_18_04_world_conditions.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2011_12_18_04_world_conditions.sql b/sql/updates/world/2011_12_18_04_world_conditions.sql
new file mode 100644
index 00000000000..a56151a9f8f
--- /dev/null
+++ b/sql/updates/world/2011_12_18_04_world_conditions.sql
@@ -0,0 +1,7 @@
+UPDATE spell_dbc SET EffectImplicitTargetA1 = 22, EffectImplicitTargetB1 = 7 WHERE Id = 58630;
+
+DELETE FROM conditions WHERE SourceTypeOrReferenceId = 13 AND SourceEntry IN (61863, 68663);
+INSERT INTO conditions (SourceTypeOrReferenceId, SourceEntry, ConditionTypeOrReference, ConditionValue1, Comment) VALUES
+(13, 61863, 18, 1, 'The Prophet Tharon''ja - Achievement Check'),
+(13, 68663, 18, 1, 'The Black Knight - Kill Credit'),
+(13, 58630, 18, 1, 'Mal''Ganis - Kill Credit');