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