Commit graph

142 commits

Author SHA1 Message Date
Lance
ef0136b8a4
[lua] [sql] [cpp] Add ROTZ Content Tag (#10213)
* Add ROTZ Content Tag

* Tag ROTZ abilities, NPCs, spells and traits
2026-06-02 11:21:22 +02:00
Critical
bed3acfa48 [lua, sql, c++][module] DRG Era Audit 2026-02-24 09:02:57 +01:00
Critical
6b06adc932 [lua, sql, cpp] DRK era audit 2026-01-31 13:07:45 -07:00
WinterSolstice8
6e386228e4
Minor trait audit (#9291)
* [sql] Fix Clear Mind trait tier 4 for some jobs

* [sql] Fix RNG out of order job trait for Recycle
2026-01-29 18:02:39 +01:00
Critical
8519b5283b [lua, sql] Monk RoV Era Module 2026-01-28 11:23:53 -07:00
Critical
53e6d594ca [sql] Block job traits behind associated merit unlocks 2026-01-25 22:41:41 -07:00
sruon
740bee77c9 MAX_HP_BOOST trait 2025-10-07 16:46:36 -06:00
WinterSolstice8
7f73822d8c [sql] Audit Accuracy Bonus trait 2025-10-01 14:42:57 -06:00
WinterSolstice8
0f437381d6 [sql] Add gilfinder 2 trait to lvl 90 thf 2025-09-13 20:49:25 -06:00
Tucker
0453a73043 add content tag to PLDs shield mastery and auto refresh traits 2025-04-24 23:06:08 -04:00
Aeshur
619b1b2013 [sql] Fix MNK Counter rate 2025-03-19 22:28:54 -04:00
pd123123
ff227e0dfd
Update DRG Accuracy Bonus III 78->76 2025-03-07 17:29:35 -08:00
FlamXI
8381a69590 [SQL] Adjust DRK trait "Resist Paralyze" acquisition level 2025-02-09 09:05:25 -06:00
WinterSolstice8
79f160369e [sql] Add Max HP Boost II 2024-11-26 15:11:37 -08:00
WinterSolstice8
dd12553960 Audit HP/MP calculations (incl curse, weakness, hp%, food)
Add new mods for weakness/curse as they are not additive to hpp/mpp
Move everything to correct places based on retail testing
Move HP/MP traits to "base" HP/MP via new mods
2024-11-26 15:11:37 -08:00
Xaver-DaRed
337fc54a20 Properly divide capped and uncapped "magic burst bonus" types 2024-07-18 15:41:16 +02:00
Ampitere
942875e36a add: Shield Barrier trait functionality 2024-05-13 08:53:46 -07:00
MowFord
c92222c9e8 Winning streak and Loaded deck merit lock 2024-04-14 12:35:43 -05:00
AppleCronch
e9147a4ed1 [lua][sql][core] DMG Limit Implementation 2024-03-04 03:19:54 +07:00
TeoTwawki
eefa916217
Merge pull request #4981 from CatsAndBoats/bst_tandem_x_plumbing
[Core] Adds tandem blow/strike traits to sql and mods to cpp/lua
2024-01-31 09:03:50 -05:00
Corey Sotiropoulos
f202e592e7 [sql] Speed up Aria table inserts
See:
https://mariadb.com/kb/en/aria-storage-engine/
2024-01-11 22:33:23 -05:00
MowFord
9987816995 Adds tandem blow/strike traits to sql and mods to cpp/lua 2024-01-11 14:40:04 -06:00
Zach Toogood
24f35c4c5e [sql] Replace MyISAM engine with Aria 2024-01-04 18:43:36 +00:00
Zach Toogood
ca3bdd22fe [SQL] Add COLLATE=utf8mb4_general_ci to all tables 2024-01-04 18:25:12 +00:00
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00:00
WinterSolstice8
fe72e783f9 [sql] Fix wrong tier on Dragon Killer II 2022-11-13 20:01:41 -08:00
WinterSolstice8
ff56a9f947 Fix Tactical Parry III level for RUN
* source: https://www.bg-wiki.com/ffxi/Tactical_Parry
2022-03-09 22:33:01 +02:00
TeoTwawki
306deae2ae Add DRGs WS dmg boost job trait 2022-01-02 14:01:27 -05:00
TeoTwawki
dd02066118 Convert tables that are never written to back to MyISAM. Only tables we write to need InnoDB.
MyISAM = table level locking, fast but not safe for multiple simultaneous writes
InnoDB = row level locking, slow, but is safe for multiple simultaneous writes

```
Features                            MyISAM                        InnoDB
Type                                Non-Transactional             Transactional
Locking                             Table locking                 Row-level locking
Foreign keys                        No                            Yes
Table, index, data storage          Three separate files          Combined Tablespace
ACID                                No                            Yes
```
2021-11-10 08:09:45 -05: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
MrSent
6da97e001f DRG merit Strafe change
Was originally only a merit category but in September 9, 2014 version update was added as a job trait and the merit point category increased the effect and changed to Strafe Effect.

• Changed Strafe to a native trait obtained through levels
• Changed the merit Strafe to Strafe Effect.
• Added the mod WYVERN_BREATH_MACC to both modifier.h and status.lua
• made this trait actually do something, as this did nothing previously, now adds MACC mod on wyvern spawn based on trait and merit

links:
https://www.bg-wiki.com/ffxi/Strafe
https://ffxiclopedia.fandom.com/wiki/Strafe_Effect
2021-01-30 19:34:44 +00:00
Tyler
172ff87bb5 Implements dead aim trait 2020-08-28 02:15:31 -07:00
Apocarypse
1832bd82f3
Add Inquartata trait (#807)
* Inquartata trait
Added mod enum for Inquartata in modifier.h
Added entries for Inquartata in traits.sql
Applied Inquartata bonus logic to GetParryRate()

* Removed the trait check
inquartataBonus should be giving 0 any time
it's called and entity doesn't have the trait.
2020-07-15 16:51:22 +00:00
ibm2431
43ff6186b0 Merge branch 'traits-update' into release 2020-06-10 18:58:38 -07:00
ibm2431
45bfc2d4f6
GEO SQL and Header changes (#689)
* GEO SQL and header files

* Spell list additions and cleanup

* Adjust automaton controller to use new effect enums
2020-06-06 02:48:43 +00:00
Apocalypse
30e094e583 added missing traits and updated existing ones 2020-05-27 11:21:38 -05:00
Apocalypse
df18ada06c added missing traits and updated existing ones 2020-05-21 16:23:42 -05:00
MrSent
575e388301 Fix for DNC closed position ability to be added only after a merit has been added to the trait.
This fixes the following issue:

Closed Position trait is given freely at 75 without putting merits in it. #512
2020-04-25 11:40:04 +01:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
isotor
3e4aa77454 Correct content tags for a number of abilities and traits 2019-05-09 14:52:15 +03:00
TeoTwawki
08ec63ada7
Merge pull request #5673 from davismj/traits/drg-traits
traits(dragoon): Add Dragon Killer II, Smite I and II to DRG
2019-02-14 19:06:13 -06:00
TeoTwawki
cb44227af1
Merge pull request #5672 from davismj/trait/conserve-tp
trait(conserve tp): Add Conserve TP
2019-02-14 19:02:35 -06:00
TeoTwawki
1f7f4a5c3f
use NULL value and not 'NULL' string
The price is NULL Bob!
2019-02-12 16:25:03 -05:00
isotor
e8a466e276
Remove WOTG tag from RDM MAB trait
MAB1 and MAB2 traits not tied to WOTG, so simply updating the field to NULL to correct.
2019-02-12 07:57:08 +03:00
Matthew James Davis
304eba1d48 traits(dragoon): Add Dragon Killer II, Smite I and II to DRG 2019-01-29 12:47:55 +09:00
Matthew James Davis
b0a7734030 trait(conserve tp): Add Conserve TP 2019-01-29 12:30:35 +09:00