aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorjoschiwald <joschiwald@online.de>2014-01-05 00:49:54 +0100
committerjoschiwald <joschiwald@online.de>2014-01-05 00:49:54 +0100
commit738afccfc1c736109f520d5d60a1f211a4fe6329 (patch)
treea0ea49a2b8cc8302cffd3bd34e62c2bd0b143a19 /sql/updates
parent853b9e9c585aab81d51a3c5878a17b4ce6f179e8 (diff)
DB/Spells: correct more spelldifficulty_dbc entries
* add log message to find wrong entries
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/world/2014_01_04_02_world_spelldifficulty_dbc.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/sql/updates/world/2014_01_04_02_world_spelldifficulty_dbc.sql b/sql/updates/world/2014_01_04_02_world_spelldifficulty_dbc.sql
new file mode 100644
index 00000000000..047d5cb937d
--- /dev/null
+++ b/sql/updates/world/2014_01_04_02_world_spelldifficulty_dbc.sql
@@ -0,0 +1,6 @@
+DELETE FROM `spelldifficulty_dbc` WHERE `spellid0` IN (31956,36127,49380,59803,49381);
+INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`, `spellid2`, `spellid3`) VALUES
+(31956,31956,38801,0,0),
+(36127,36127,39005,0,0),
+(49380,49380,59803,0,0),
+(49381,49381,59805,0,0);