From c417c5a1c7787d6b0dea241046de86eb8bf75221 Mon Sep 17 00:00:00 2001 From: Trista Date: Thu, 28 Feb 2013 18:45:00 +0200 Subject: 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. --- .../world/2013_02_28_00_world_playercreateinfo_spell.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 sql/updates/world/2013_02_28_00_world_playercreateinfo_spell.sql (limited to 'sql') 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'); -- cgit v1.2.3