Commit graph

16 commits

Author SHA1 Message Date
WinterSolstice8
2300b00246 [core] [sql] Fix Ready recast merit, implement Stratagem jp gift 2025-08-28 19:56:56 -06:00
Zach Toogood
ca3bdd22fe [SQL] Add COLLATE=utf8mb4_general_ci to all tables 2024-01-04 18:25:12 +00:00
Corey Sotiropoulos
d92c54d1b4 [dbtool] Add function to dump DB to SQL files
Queries database then scans corresponding SQL file, replacing values
in INSERT statements with data from the database.

Is not smart about which INSERT statement gets which data; line-end
comments can get shuffled around if SQL file INSERTs are out of order
or missing. If you're doing INSERT or DELETE operations, make sure
to add a blank "INSERT INTO `table` VALUES ();" or manually remove
the INSERT statement respectively before dumping tables.
2023-08-23 22:50:08 -04:00
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00:00
TeoTwawki
2589da530c Merge branch 'topaz' of https://github.com/DerpyProjectGroup/topaz into freedom
# Resolved Conflicts:
#	sql/job_points.sql
2021-04-18 13:49:29 -04:00
Ixion
c460a89139 Ixion is Come!
- Rebranding.
- Migrate to GitLab.
- Add support for database updates when using Docker.
- Give purpose to version.h (adjust minor version with client updates).
- Add an in-game `!ver` command.
- Remove references to AGPL.
2021-04-17 18:24:14 -04:00
TeoTwawki
276cf1a095 Merge branch 'canary' of https://github.com/topaz-next/topaz into freedom 2021-04-10 22:55:57 -04:00
TeoTwawki
de3066a3cb Remove even more banding references. The name "topaz" remains in places but all of "tpz" should be gone now. 2021-04-01 16:14:56 -04:00
Zach Toogood
9e4993893d Migrate all SQL tables from MyISAM to InnoDB 2021-02-05 17:07:08 +02:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
Tyler Schneider
1f50e1583c Finished implementation of Ready
Fixes #2824
2016-02-27 14:58:06 -07:00
Tyler Schneider
e6282dad82 Implemented Quick Draw Recast merit
Fixes #2678
2016-02-01 00:16:01 -07:00
TeoTwawki
8209f73159 Line ends, round 2. Fight! 2016-01-16 01:26:33 -05:00
teschnei
5ac9e899c9 SCRIPTS: fixed missing accuracy bonus to quick draw
SQL: fixed quick draw charges on the wrong recastId
2013-11-23 07:21:47 +00:00
PrBlahBlahtson
eaaf672ec7 SQL: Nice of SCHs to mention charges didn't work. Now they do :D 2013-06-03 02:48:28 +00:00
teschnei
d1e4366c76 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