U souboru 2013_02_28_00_world_playercreateinfo_spell.sql my to nahlásilo tuto chybu
[Err] 1054 - Unknown column 'race' in 'where clause'
[Err] -- 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');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
a u souboru 2013_03_11_01_world_playercreateinfo_spell.sql tuto i po nahrání zbytku to nejde ..
[Err] 1054 - Unknown column 'race' in 'playercreateinfo_spell'
[Err] -- playercreateinfo_spell
TRUNCATE TABLE `playercreateinfo_spell`;
ALTER TABLE `playercreateinfo_spell`
CHANGE `race` `racemask` INT(10) UNSIGNED DEFAULT 0 NOT NULL,
CHANGE `class` `classmask` INT(10) UNSIGNED DEFAULT 0 NOT NULL;
ALTER TABLE `playercreateinfo_spell_custom`
CHANGE `race` `racemask` INT(10) UNSIGNED DEFAULT 0 NOT NULL,
CHANGE `class` `classmask` INT(10) UNSIGNED DEFAULT 0 NOT NULL;
INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei
-- Classes: Warrior
(0x4FF, 0x1, 78, "Heroic Strike"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x6FF, 0x5FF, 81, "Dodge"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Shaman
(0x6FF, 0x43, 107, "Block"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Hunter, Death Knight
(0x6FF, 0x25, 196, "One-Handed Axes"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Priest, Shaman, Druid
(0x6FF, 0x453, 198, "One-Handed Maces"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Death Knight
(0x6FF, 0x27, 201, "One-Handed Swords"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x6FF, 0x5FF, 203, "Unarmed"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x6FF, 0x5FF, 204, "Defense"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x6FF, 0x5FF, 522, "SPELLDEFENSE (DND)"),
-- Races: Human, Dwarf, Night elf, Gnome, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x44D, 0x5FF, 668, "Language Common"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x6FF, 0x5FF, 1843, "Disarm"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x6FF, 0x5FF, 2382, "Generic"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei
-- Classes: Warrior
(0x4FF, 0x1, 2457, "Battle Stance"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x6FF, 0x5FF, 2479, "Honorless Target"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x6FF, 0x5FF, 3050, "Detect"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x6FF, 0x5FF, 3365, "Opening"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Dranei
-- Classes: Warrior
(0x4FF, 0x1, 5301, "Defensive State (DND)"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Classes: Warrior, Paladin, Hunter, Rogue, Priest, Death Knight, Shaman, Mage, Warlock, Druid
(0x6FF, 0x5FF, 6233, "Closing"),
-- Races: Human, Orc, Dwarf, Night elf, Undead, Tauren, Gnome, Troll, Blood elf, Dranei
-- Class
[Msg] Finished - Unsuccessfully
--------------------------------------------------