diff options
| author | Trista <aconstantgoal@abv.bg> | 2013-02-28 18:45:00 +0200 |
|---|---|---|
| committer | Trista <aconstantgoal@abv.bg> | 2013-02-28 18:45:00 +0200 |
| commit | c417c5a1c7787d6b0dea241046de86eb8bf75221 (patch) | |
| tree | 80e773431f418254e0d23006704b6a7b2cd6a99d | |
| parent | 6801314881598f0b1cce7a2e614ca7f314c1e129 (diff) | |
DB/Spells: Opening spell (id: 61437)added to some of Blood Elf's classes
* Add missing generic spell for opening chests for most of Blood Elf's classes. It was preventing them to loot in Eye of Eternity Alexstrasza's Gift Box, Heart of Magic and maybe more.
| -rw-r--r-- | sql/updates/world/2013_02_28_00_world_playercreateinfo_spell.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2013_02_28_00_world_playercreateinfo_spell.sql b/sql/updates/world/2013_02_28_00_world_playercreateinfo_spell.sql new file mode 100644 index 00000000000..9f0ce0d8533 --- /dev/null +++ b/sql/updates/world/2013_02_28_00_world_playercreateinfo_spell.sql @@ -0,0 +1,11 @@ +-- Add missing generic spell for opening chests for most of Blood Elf's classes +-- (was preventing them to loot Eye of Eternity Alexstrasza's Gift Box, Heart of Magic and maybe more.) +DELETE FROM `playercreateinfo_spell` WHERE `race`=10 AND `Spell`=61437; +INSERT INTO `playercreateinfo_spell` (`race`,`class`,`Spell`,`Note`) VALUES +(10,2,61437, 'Opening'), +(10,3,61437, 'Opening'), +(10,4,61437, 'Opening'), +(10,5,61437, 'Opening'), +(10,6,61437, 'Opening'), +(10,8,61437, 'Opening'), +(10,9,61437, 'Opening'); |