Advertisement
Parranoia

Weapon/Armor skills

Sep 7th, 2012
1,597
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.14 KB | None | 0 0
  1. /* CREATED BY: Parranoia
  2.     CLASS           CLASSMASK
  3.     -------------------------
  4.     Warrior     1
  5.     Paladin     2
  6.     Hunter      4
  7.     Rogue       8
  8.     Priest      16
  9.     DK      32
  10.     Shaman      64
  11.     Mage        128
  12.     Warlock     256
  13.     Druid       1024
  14. */
  15.  
  16. DELETE FROM `playercreateinfo_spell` WHERE `Note` IN('Polearms', 'One-Handed Swords', 'Daggers', 'Two-Handed Axes', 'One-Handed Axes', 'Two-Handed Swords', 'Two-Handed Maces', 'One-Handed Maces', 'Thrown', 'Throw', 'Bows', 'Guns', 'Polearms', 'Fist Weapons', 'Crossbows', 'Mail Armor', 'Plate Armor', 'Staves', 'Dual-Wield');
  17.  
  18. INSERT INTO `playercreateinfo_spell` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
  19. (0, 399, 201, 'One-Handed Swords'),
  20. (0, 477, 1180, 'Daggers'),
  21. (0, 71, 197, 'Two-Handed Axes'),
  22. (0, 1123, 199, 'Two-Handed Maces'),
  23. (0, 7, 202, 'Two-Handed Swords'),
  24. (0, 1147, 198, 'One-Handed Maces'),
  25. (0, 79, 196, 'One-Handed Axes'),
  26. (0, 1031, 200, 'Polearms'),
  27. (0, 13, 2567, 'Thrown'),
  28. (0, 13, 2764, 'Throw'),
  29. (0, 13, 264, 'Bows'),
  30. (0, 13, 266, 'Guns'),
  31. (0, 13, 5011, 'Crossbows'),
  32. (0, 77, 15590, 'Fist Weapons'),
  33. (0, 1493, 227, 'Staves'),
  34. (0, 5, 674, 'Dual-Wield'),
  35. (0, 68, 8737, 'Mail Armor'),
  36. (0, 3, 750, 'Plate Armor');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement