2016-01-16 01:26:33 -05:00
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
|
-- ----------------------------
|
|
|
|
|
-- Table structure for abilities_charges
|
|
|
|
|
-- ----------------------------
|
|
|
|
|
DROP TABLE IF EXISTS `abilities_charges`;
|
CORE: framework for charge based JAs (stratagems, ready, quick draw)
added more addtypes for job abilities (light arts/dark arts)
centralized calculations for MP cost, cast time and recast time for spells
recast container will now always contain job abilities - they will have a recast of 0 if ready (this is retail behaviour)
lua_baseentity - getMaxSkill(skill, job, level) - returns max skill for parameters
lua_baseentity - recalculateAbilitiesTable - recalculates available job abilities for character (ie. after using light/dark arts)
modifier.h - new mods for scholar (well, moved some old ones that shouldn't have existed yet..)
char_jobs packet - some (untested) changes to sending job level/unlocked jobs - need to unlock geo/run to figure out where their levels go..
spell - added more requirements (tabula rasa)
SCRIPTS - light arts, dark arts (no mods yet), alacrity, celerity, parsimony, penury added
DATABASE: added abilities_charges.sql for ability trees with charges
abilities.sql - fixed a few recast IDs
spell_list.sql - fixed a few SCH levels on some spells (definitely not all)
status_effects.sql - fixed SCH JA's not wearing off at the appropriate time
2013-05-14 20:22:29 +00:00
|
|
|
CREATE TABLE `abilities_charges` (
|
|
|
|
|
`recastId` smallint(5) unsigned NOT NULL,
|
|
|
|
|
`job` tinyint(2) unsigned NOT NULL,
|
|
|
|
|
`level` tinyint(2) unsigned NOT NULL,
|
|
|
|
|
`maxCharges` tinyint(1) unsigned NOT NULL DEFAULT '0',
|
|
|
|
|
`chargeTime` smallint(4) unsigned NOT NULL DEFAULT '0',
|
2016-02-01 00:16:01 -07:00
|
|
|
`meritModID` smallint(4) unsigned NOT NULL DEFAULT '0',
|
CORE: framework for charge based JAs (stratagems, ready, quick draw)
added more addtypes for job abilities (light arts/dark arts)
centralized calculations for MP cost, cast time and recast time for spells
recast container will now always contain job abilities - they will have a recast of 0 if ready (this is retail behaviour)
lua_baseentity - getMaxSkill(skill, job, level) - returns max skill for parameters
lua_baseentity - recalculateAbilitiesTable - recalculates available job abilities for character (ie. after using light/dark arts)
modifier.h - new mods for scholar (well, moved some old ones that shouldn't have existed yet..)
char_jobs packet - some (untested) changes to sending job level/unlocked jobs - need to unlock geo/run to figure out where their levels go..
spell - added more requirements (tabula rasa)
SCRIPTS - light arts, dark arts (no mods yet), alacrity, celerity, parsimony, penury added
DATABASE: added abilities_charges.sql for ability trees with charges
abilities.sql - fixed a few recast IDs
spell_list.sql - fixed a few SCH levels on some spells (definitely not all)
status_effects.sql - fixed SCH JA's not wearing off at the appropriate time
2013-05-14 20:22:29 +00:00
|
|
|
PRIMARY KEY (`recastId`,`job`,`level`)
|
2024-01-04 18:25:12 +00:00
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AVG_ROW_LENGTH=56;
|
2016-01-16 01:26:33 -05:00
|
|
|
|
|
|
|
|
-- ----------------------------
|
|
|
|
|
-- Records
|
|
|
|
|
-- ----------------------------
|
2025-08-28 19:56:13 -06:00
|
|
|
INSERT INTO `abilities_charges` VALUES (102,9,25,3,30,902);
|
2023-08-23 22:21:07 -04:00
|
|
|
INSERT INTO `abilities_charges` VALUES (195,17,40,2,60,1410);
|
|
|
|
|
INSERT INTO `abilities_charges` VALUES (231,20,10,1,240,0);
|
|
|
|
|
INSERT INTO `abilities_charges` VALUES (231,20,30,2,120,0);
|
|
|
|
|
INSERT INTO `abilities_charges` VALUES (231,20,50,3,80,0);
|
|
|
|
|
INSERT INTO `abilities_charges` VALUES (231,20,70,4,60,0);
|
|
|
|
|
INSERT INTO `abilities_charges` VALUES (231,20,90,5,48,0);
|