aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorhorn <pankrac.ja@seznam.cz>2011-12-18 23:42:23 +0100
committerhorn <pankrac.ja@seznam.cz>2011-12-18 23:42:23 +0100
commitb119558ee1d8198ef29ed393badf6e0ad9491de1 (patch)
tree3765adf73ab41f7fc109805d9543b8861680fbd2 /sql
parent7a2f7b0e6344bd5659d35f6ef50f23656cd68140 (diff)
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');