Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /* CREATED BY: Parranoia
- * ID RACE
- *-------------------
- * 1 | Human
- * 2 | Orc
- * 3 | Dwarf
- * 4 | Night Elf
- * 5 | Undead
- * 6 | Tauren
- * 7 | Gnome
- * 8 | Troll
- * 10 | Blood Elf
- * 11 | Draenei
- */
- DELETE FROM `playercreateinfo_spell` WHERE `Note` IN('Polearms', 'Swords', 'Daggers', 'Two-Handed Axes', 'One-Handed Axes', 'Two-Handed Swords', 'Two-Handed Maces', 'Maces', 'Thrown', 'Throw', 'Bows', 'Guns', 'Axes', 'Polearms', 'Fist Weapons', 'Crossbows', 'Mail Armor', 'Plate Armor', 'Staves', 'Dual-Wield');
- -- Warrior Spells
- INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
- (0, 1, 201,'Swords'),
- (0, 1, 1180,'Daggers'),
- (0, 1, 197,'Two-Handed Axes'),
- (0, 1, 199,'Two-Handed Maces'),
- (0, 1, 202,'Two-Handed Swords'),
- (0, 1, 198,'Maces'),
- (0, 1, 196,'Axes'),
- (0, 1, 200,'Polearms'),
- (0, 1, 2567,'Thrown'),
- (0, 1, 2764,'Throw'),
- (0, 1, 264,'Bows'),
- (0, 1, 266,'Guns'),
- (0, 1, 5011,'Crossbows'),
- (0, 1, 15590,'Fist Weapons'),
- (0, 1, 227,'Staves'),
- (0, 1, 674, 'Dual-Wield'),
- (0, 1, 750, 'Plate Armor');
- -- Paladin Spells
- INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
- (0, 2, 200,'Polearms'),
- (0, 2, 198,'Maces'),
- (0, 2, 201,'Swords'),
- (0, 2, 202,'Two-Handed Swords'),
- (0, 2, 197,'Two-Handed Axes'),
- (0, 2, 199,'Two-Handed Maces'),
- (0, 2, 196,'Axes'),
- (0, 2, 750, 'Plate Armor');
- -- Hunter Spells
- INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
- (0, 3, 200,'Polearms'),
- (0, 3, 196, 'One-Handed Axes'),
- (0, 3, 674, 'Dual-Wield'),
- (0, 3, 15590, 'Fist Weapons'),
- (0, 3, 2767, 'Thrown'),
- (0, 3, 2764, 'Throw'),
- (0, 3, 264,'Bows'),
- (0, 3, 266,'Guns'),
- (0, 3, 5011,'Crossbows'),
- (0, 3, 201,'Swords'),
- (0, 3, 227,'Staves'),
- (0, 3, 202,'Two-Handed Swords'),
- (0, 3, 197,'Two-Handed Axes'),
- (0, 3, 1180,'Daggers'),
- (0, 3, 8737, 'Mail Armor');
- -- Rogue Spells
- INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
- (0, 4, 1180,'Daggers'),
- (0, 4, 2567,'Thrown'),
- (0, 4, 2764,'Throw'),
- (0, 4, 201,'Swords'),
- (0, 4, 198,'Maces'),
- (0, 4, 196,'Axes'),
- (0, 4, 264,'Bows'),
- (0, 4, 266,'Guns'),
- (0, 4, 5011,'Crossbows'),
- (0, 4, 15590,'Fist Weapons');
- -- Priest
- INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
- (0, 5, 1180,'Daggers'),
- (0, 5, 198,'Maces'),
- (0, 5, 227,'Staves');
- -- Death Knight
- INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
- (0, 6, 199,'Two-Handed Maces'),
- (0, 6, 198,'One-Handed Maces');
- -- Shaman
- INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
- (0, 7, 1180, 'Daggers'),
- (0, 7, 227,'Staves'),
- (0, 7, 198,'Maces'),
- (0, 7, 199,'Two-Handed Maces'),
- (0, 7, 196,'Axes'),
- (0, 7, 197,'Two-Handed Axes'),
- (0, 7, 15590,'Fist Weapons'),
- (0, 7, 8737, 'Mail Armor');
- -- Mage Spells
- INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
- (0, 8, 1180,'Daggers'),
- (0, 8, 201,'Swords'),
- (0, 8, 227,'Staves');
- -- Warlock
- INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
- (0, 9, 1180,'Daggers'),
- (0, 9, 201,'Swords'),
- (0, 9, 227,'Staves');
- -- Druid
- INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
- (0, 11, 198,'Maces'),
- (0, 11, 199,'Two-Handed Maces'),
- (0, 11, 227,'Staves'),
- (0, 11, 200,'Polearms');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement