Commit graph

85 commits

Author SHA1 Message Date
Critical
1f8c0d05d8 [lua, sql, c++] Ranger job adjustments 2026-02-14 11:34:11 -07:00
sruon
53904008b3 PUP Repair Self-Cast, lower recast to 90s, lower merit effect to 3s 2025-12-05 20:58:20 +01:00
sruon
95e961d892 Merits: Deprecate _sql 2025-09-08 15:26:25 -06:00
WinterSolstice8
1b8d3a7519 [core] [sql] [lua] Audit Chakra to match retail 2024-11-23 20:06:17 -07:00
WinterSolstice8
2c4ff04b47 [core] [lua] [sql] Update Dodge & Focus to new retail versions 2024-11-23 20:05:05 -07:00
WinterSolstice8
5a1e315add [core] [sql] Implement retail Sange
https://www.bg-wiki.com/ffxi/Sange
https://wiki.ffo.jp/html/3068.html
2024-11-18 20:20:09 -07:00
Xaver-DaRed
249c537e74 Audit "Diabolic Eye" Ability and Effect
Co-authored-by: Schaedelschaden <Schaedelschaden@users.noreply.github.com>
2024-07-21 21:30:30 +02:00
MowFord
03038ad82e
Merit BloodPacts should give +400tp per level 2024-05-23 15:45:56 -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
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
claywar
6fba06f76b
Fix Merit Point WS Learning and Upgrades 2023-05-21 10:34:43 -04:00
Xaver-DaRed
5dd34cfed8 Fix max merits allowed in "max merits" 2023-04-12 09:41:06 +02:00
Xaver-DaRed
a554964539 Correct Building and Wild Flourish use logic 2023-02-17 23:56:20 +01:00
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00:00
Xaver-DaRed
ba7657dbb0 Correct Elemental debuff merit potency value 2023-01-23 11:51:18 +01:00
Schaedelschaden
b0fa914bb9 Dark Knight Update Consume Mana & Dark Seal 2022-11-06 23:46:59 -07:00
MrSent
5111f2c16e Geo Abilities and Luopan abilities 2022-05-11 02:00:49 +01:00
MrSent
c86bc6201e
[Geo] Basic luopan positioning and corrected Luopan size (#1454) 2022-04-07 12:01:29 +03:00
WinterSolstice8
f1c415bb23 Implement Rune Fencer merits
"Power" values taken from https://www.bg-wiki.com/ffxi/Merit_Points#Rune_Fencer
2022-03-09 22:33:01 +02: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
claywar
febab45707
Fix Weaponskill Merit Upgrade ID 2021-08-09 08:21:08 -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
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
wrenffxi
ea3e5c345b snake eye merits grant +10%/merit after first of doubl-upping to 11
this bonus is applied when current roll is 5+
2020-12-28 17:31:07 -05:00
59blargedy
34563d3ff8 fixing values based on 1000 tp model and fixing overflow 2020-06-17 09:20:12 -04: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
kaincenteno
df7c7a3d0a Changed Shield Bash for Paladin UPDATE: 12FEB2020
https://forum.square-enix.com/ffxi/threads/56444-February-12-2020-%28JST%29-Version-Update
This was changed with the update for 12FEB2020
Made change to merit as it went down from 6 seconds to 2.
2020-06-04 00:35:53 -07:00
Topaz
aa6e168add Commits from upstream, 2019/12/11 to 2019/01/13 2020-01-13 10:25:10 -08:00
m241dan
2effc1ae16 PR: New merits to match the client and retail (#6359)
* PR: SQL: Updated tables for new merits

* PR: Lua / C++:  Setup Basics for new merits

Increased merit group size
Added variables with appropriate values

* PR: Lua: Black Mage merits

* PR: Lua / C++: Red Mages minus ImmunoBreak

ImmunoBreak is going to need... some thinking.

* PR: Lua: White Mage Merits

* PR: Lua: Adjusted ShellraV and ProtectraV

Their merits no longer exist, so set their base
power to bg-wiki values

* PR: Lua / C++: Ninja Merits
2020-01-09 20:29:59 -07:00
Caelic
8241330b56
Update merits.sql
every merit upgrade gives +1 buff transferred, not +5
2020-01-03 12:01:26 -05:00
Topaz
3eb1c1570f Remove DSP branding (copyright notices retained) 2019-12-02 12:40:02 -08:00
nfaletra
d7110d34db Haste Rewrite 2018-08-10 23:55:10 -06:00
nfaletra
6b5bdfd4f7 Added Undead Killer Tiers
Fixed Resist Sleep Values
Added Resist Sleep Tiers
Added Shield Mastery Item mod
Implemented Iron Will
Added Shield Def. Bonus
Implemented Crit. Def. Bonus
2018-05-16 16:16:09 -06:00
nfaletra
b67dea77ab Fixed Attack bonus levels/tiers
Fixed Desperate Blows db, core, and scripts
Fixed Resist Paralyze levels/values
Added Arcana Killer tier
Added Crit. Atk. Bonus
Added Smite
Added Occult Acumen
Implemented Stalwart Soul
Implemented Muted Soul
Fixed Afflatus Solace/Misery to be WHM main only
2018-05-04 00:04:06 -06:00
UnknownX
3880a0bf35 Fixed merit values for Role Reversal and Ventriloquy 2017-04-07 00:57:29 -05:00
UnknownX
a9c3b04e4f Added new PUP merits to the SQL 2017-04-06 20:00:14 -05:00
TeoTwawki
03d150e865 Remove quotes from non strings in several sql tables..No values are changed in this commit. 2017-01-31 11:11:32 -05:00
Timothy Uptain
c1a6481807 Implemented Ikishoten and fixed Shikikoyo upgrades. 2016-06-29 00:07:45 -05:00
Hozu
295388a732 Core/SQL: Fix Overwhelm check
-Moved the check to before damage was actually dealt to the target.
-Added a check to make Overwhelm only apply to melee Weaponskills.
-Replaced the redundant job/level check (since it's already done when fetching merit value) with an objtype check, since there are some mobskills that use battleutils::TakeWeaponskillDamage (and thus battleutils::getOverWhelmDamageBonus).
-Fixed the merit power value since the value fetched for merits is the total power value, not the amount of upgrades in the category.
2016-04-22 13:41:19 -04:00
TeoTwawki
8209f73159 Line ends, round 2. Fight! 2016-01-16 01:26:33 -05:00
Hozu
f5ebd689f3 SQL: Correct power of RDM group 1 magic accuracy merits.
When checking out the fetched value for BLM potency merits, I tested out a RDM one that I had to see if I did it correctly and it returned 15 instead of 10. Oops. Should be 2 acc per merit, not 3.
2015-10-23 00:37:45 -04:00
Hozu
ba45dfa0f9 Scripts/SQL/Core: Implement Angon + item depletion for Repair/Tomahawk.
Scripted Angon, inflicts 20% defense down, requires Angon item to be equipped.
Changed the merit power of Angon to 15 for the duration (15 + merit power for 30-90 sec depending on investment).
Gave the proper model for the Angon item, as well as the Throwing Tomahawk.
Made the Angon/Throwing Tomahawk/Automaton Oils deplete upon using their respective ability (Tomahawk ability is currently unscripted so I merely put in the framework for it - whoever scripts it has to make sure to have the ammo ID check in OnAbilityCheck).
2015-08-15 03:00:25 -04:00
Alex Goolsby
2ace854b41 SQL: add merit template definitions for geomancy and handbell fixes #1905 2015-08-12 11:34:56 -04:00
whasf
e2b8f0bd05 Merge pull request #1866 from Hozu/patch-58
Scripts/SQL: NIN T1/T2 nuke merits + Innin/Yonin adjustment
2015-08-08 19:25:15 -05:00
Hozu
86ce13812a Core/SQL: Implement new merit category max upgrades
Merit points have undergone the following adjustments
The Attributes category has had its maximum ability increases raised from 45 to 60
The Combat Skills category has had its maximum ability increases raised from 56 to 112.
The Magic Skills category has had its maximum ability increases raised from 48 to 80.

http://forum.square-enix.com/ffxi/threads/47901-Aug-5-2015-%28JST%29-Version-Update

Bumped up defensive skills in merits.sql from 4 to 8 to reflect the actual cap.
2015-08-07 15:47:48 -04:00