Commit graph

64 commits

Author SHA1 Message Date
lefneer311
cb1ea02dc9
Fixes augment 1152 - DEF +10
Fixes augment 1152 to match the in-client dat (+10 per step).

Modifies multiplier from 0 to 10, and reduces value from 10 to 1.  Results in +10 steps tested and verified.
2026-05-04 09:12:55 -05:00
lefneer311
03929f83e4
Update augments.sql dmg & delay
Wires in values for the augments which deal with melee and ranged damage and delay modifications.
2026-03-09 17:15:31 -05:00
WinterSolstice8
1099324777
Merge pull request #9503 from lefneer311/base
Adding Enspell Damage Percent Multiplier Effect
2026-02-28 20:23:29 -07:00
Will Buck
f65bda686c Item mod corrections: SC DMG, Crit Evasion 2026-02-22 14:58:12 -06:00
lefneer311
b409ca3548
Update augments.sql to enable enspell_dmg_pct 2026-02-20 10:55:09 -06:00
Will Buck
76ec225a92 Implement recast mods for healing, enf, enh 2026-01-04 02:28:25 -06:00
WinterSolstice8
083cd09f23 [lua] [core] [sql] add Enhances Sange mod
Add said mod to the applicable augment as well
2024-11-18 20:18:48 -07:00
Xaver-DaRed
5a6e657548 Replace already-in-use mod Ids with non used ones 2024-04-13 21:48:05 +02:00
AppleCronch
e9147a4ed1 [lua][sql][core] DMG Limit Implementation 2024-03-04 03:19:54 +07: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
TeoTwawki
59405d63b7
Merge pull request #4954 from LandSandBoat/force_collation
[dbtool] Make sure CHARSET and COLLATE are set on new dbs
2024-01-06 04:25:33 -05: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
MowFord
493876fcef Adjust multiplicative augments to behave properly 2024-01-03 18:42:26 -06:00
MowFord
047febfbf3 relic magian dmg augment addition 2024-01-02 16:22:00 -06:00
MowFord
72ba0b0cd7 Followup to getSpeed() updates
Updates to augments, item latents, and mob spawn mods
2023-11-21 14:49:30 -06:00
MowFord
f053b35dbc Missing augments from mini expansions
Call beast recast reduction
Sic/Ready recast reduction
Quick Draw recast reduction
Waltz cost reduction
Barrage shot count increase
Phantom recast reduction
WS total dmg increase
2023-10-09 18:34:22 -05:00
Mi
d25e71f3f3 Add Phantom Roll recast modifier and correct Phantom Roll Recast 2023-09-03 20:16:06 -04:00
Mi
a70b2af15e Updates incorrect modifier IDs within augments.sql 2023-04-05 18:04:50 -04:00
Xaver-DaRed
15a8b8e828 Document augments 72 and 73 2023-02-15 15:55:51 +01:00
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00:00
Schaedelschaden
b0fa914bb9 Dark Knight Update Consume Mana & Dark Seal 2022-11-06 23:46:59 -07:00
Schaedelschaden
71a721052d Dark Knight job_utils and Job Abilities 2022-11-04 22:43:21 -06:00
DiscipleOfEris
569a658bea Apply DMG_RATING mod and EQUIPPED_IN_SLOT latents
NOTE: the Coffinmaker had an incorrect (?) Crit Rate +6% mod. This does not appear on the wiki and this commit removes the mod.

NOTE: Sirius Axe was adding the `DMG` and `MAIN_DMG_RATING` mods... `DMG` is "Reduce all damage by %". This damage reduction has been removed.
2022-10-06 09:47:29 -07:00
Schaedelschaden
76e8351d3b Update PLD specific augments 2022-09-27 15:08:36 -06:00
Grave Taker
dafcb3af5e Fixed haste Augments
was having issue where haste augment wasnt reading like it should
2022-09-22 02:01:25 -04:00
NeuromancerXI
237ad7c054 Aptitude Mantle MODs / Cap. Point Augment
Adds Missing MODs for Aptitude Mantle
Populates Augment ID 74/75 with CAPACITY_BONUS
2022-08-21 07:28:37 -07:00
claywar
90df63aade
Interaction - Mission: Lest We Forget
Safety Checkin and Initial Blocking

Implement second augment update parameter


Remove reference table


Complete mission reward event


Update amount tables to reflect required values


Add mission repeat logic
2022-08-20 06:51:34 -04:00
TeoTwawki
6462aa9334 Misc text corrections 2022-08-18 18:19:56 -04:00
Daniel Koris
6012107b3d [sql] changed damage % taken mods to fit the new 10k scale
1% should be 100 value
2022-05-30 17:39:49 -06:00
claywar
e9ee327483
Merge pull request #1701 from Omnione/geo
Geo Abilities and Luopan abilities
2022-05-12 12:40:52 -04:00
MrSent
5111f2c16e Geo Abilities and Luopan abilities 2022-05-11 02:00:49 +01:00
NeuromancerXI
36ce7cee9e Augment Discovery 2022-05-10
Cycled through the augment list 1-2047 to look for Augment new IDs.

Used `!additem 27631 1 <augid> 1` to check for augments that weren't
already documented. Wired up augments where possible, and captured
augment text in places where MODs weren't yet present.
2022-05-10 14:46:12 -07:00
MrSent
556d653c40 Added Life Cycle JA, AF+Relic gear mods 2022-04-28 20:16:09 +01:00
EpicTaru
eb905fc17f Verified all ModIds and values of existing augments with modifiers.h
Added applicable ModIds and values for any augments that were previously zeroed out.
2021-12-07 19:21:44 -06: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
9788aeab0b Realign augments and item_latents tables to use corrected resistance modifier IDs too.. Checked pet tables, none affected. 2021-07-06 01:21:40 -04: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
Sylvain Santucci
4cd4cac9b8
Implement trials for relic lv 75 to lv 95 (#2354)
* Add trials for all relic

* Extract from FFXI Client (with POLUtils)

* Add Slot for Ranged

* Remove trials.csv and trials.xml and rewrite name of function in camelCase

* Fix some ids
2021-01-04 20:26:05 +02:00
NeuromancerXI
39d965dca3 Assassins Charge Fixes
Typo correction in effect script, update augment table, and tweaked ability script.

Will now properly apply both Quad Rate AND Crit Rate.
2020-10-31 13:50:34 -07:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
nfaletra
842a7b3aad Augments for haste rewrite 2018-08-16 13:04:34 -06:00
TeoTwawki
5b0b7df077 Add some missing augment modifiers. 2018-07-21 16:40:32 -04:00
TeoTwawki
d2154d34ed Identify some augments for future use. Mods not added yet, some do not yet exist.
Thanks to Aale on the forums https://forums.dspt.info/viewtopic.php?f=19&t=21951&sid=a65ef44aef0ed15c5d2280fc69c64fe4
2018-07-21 16:18:37 -04:00
TeoTwawki
85aeaac5d2 Augment data corrections 2018-02-02 20:51:47 -05:00
TeoTwawki
67abb62c0a Moved fan_dance.lua waltz recast adjustment into directly checking the merits in the waltz scripts, re-purposed the modifier into "waltz ability delay". 2017-04-19 21:53:00 -04:00