helper_buff_list.sql 1.5 KB

1234567891011121314151617181920212223242526272829303132
  1. DROP TABLE IF EXISTS `helper_buff_list`;
  2. CREATE TABLE `helper_buff_list` (
  3. `id` tinyint(2) unsigned NOT NULL DEFAULT '0',
  4. `skill_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  5. `name` varchar(25) NOT NULL DEFAULT '',
  6. `skill_level` tinyint(2) unsigned NOT NULL DEFAULT '0',
  7. `lower_level` tinyint(2) unsigned NOT NULL DEFAULT '0',
  8. `upper_level` tinyint(2) unsigned NOT NULL DEFAULT '0',
  9. `is_magic_class` varchar(5) DEFAULT NULL,
  10. `forSummon` varchar(5) DEFAULT NULL,
  11. PRIMARY KEY (`id`)
  12. );
  13. INSERT INTO `helper_buff_list` VALUES
  14. (0,5627,'WindWalk',1,6,75,'false','true'),
  15. (1,5628,'Shield',1,6,75,'false','true'),
  16. (2,4338,'Life Cubic',1,16,34,'false','false'),
  17. (3,5629,'Bless the Body',1,6,75,'false','true'),
  18. (4,5630,'Vampiric Rage',1,6,75,'false','true'),
  19. (5,5631,'Regeneration',1,6,75,'false','true'),
  20. (6,5632,'Haste',1,6,39,'false','true'),
  21. (7,5627,'WindWalk',1,6,75,'true','false'),
  22. (8,5628,'Shield',1,6,75,'true','false'),
  23. (9,4338,'Life Cubic',1,16,34,'true','false'),
  24. (10,5633,'Bless the Soul',1,6,75,'true','true'),
  25. (11,5634,'Acumen',1,6,75,'true','true'),
  26. (12,5635,'Concentration',1,6,75,'true','true'),
  27. (13,5636,'Empower',1,6,75,'true','true'),
  28. (14,5632,'Haste',1,40,75,'false','true'),
  29. (15,5637,'Magic Barrier',1,6,75,'false','true'),
  30. (16,5637,'Magic Barrier',1,6,75,'true','false');
  31. -- (17,5182,'Blessing of Protection',1,1,39,'false'); -- Keeps you safe from an attack by a chaotic character who is more than 10 levels apart from you.