diff options
| -rw-r--r-- | sql/updates/world/2014_01_04_01_world_spelldifficulty_dbc.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/sql/updates/world/2014_01_04_01_world_spelldifficulty_dbc.sql b/sql/updates/world/2014_01_04_01_world_spelldifficulty_dbc.sql new file mode 100644 index 00000000000..b32a5bce948 --- /dev/null +++ b/sql/updates/world/2014_01_04_01_world_spelldifficulty_dbc.sql @@ -0,0 +1,27 @@ +DELETE FROM `spelldifficulty_dbc` WHERE `spellid0` IN (36924,37162,48133,48849,49381,49518,49527,49528,49537,49544,49548,49555,50761,50830,50831,50834,51849,52469,52592,53472,54479,55959,56130,65868,67875,67883,68783,67881); +INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`, `spellid2`, `spellid3`) VALUES +(36924,36924,39017,0,0), +(37162,37162,39019,0,0), +(48133,48133,59271,0,0), +(48849,48849,59422,0,0), +(49381,49381,59805,0,0), +(49518,49518,59971,0,0), +(49527,49527,59972,0,0), +(49528,49528,59973,0,0), +(49537,49537,59963,0,0), +(49544,49544,59965,0,0), +(49548,49548,59969,0,0), +(49555,49555,59807,0,0), +(50761,50761,59727,0,0), +(50830,50830,59844,0,0), +(50831,50831,59845,0,0), +(50834,50834,59846,0,0), +(51849,51849,59861,0,0), +(52469,52469,59364,0,0), +(52592,52592,59368,0,0), +(53472,53472,59433,0,0), +(54479,54479,59471,0,0), +(55959,55959,59513,0,0), +(56130,56130,59467,0,0); + +UPDATE `spelldifficulty_dbc` SET `id` = `spellid0`; |