StatAugments = { -- max aug value is 31. aug starts at 0 (gives 1 of stat at 0 value)
1,  -- HP
2,  -- hp up to 64
3,  -- hp up to 96
4,  -- hp up to 128
5,  -- hp down to -32
6,  -- hp down to -64
7,  -- hp down to -96
8,  -- hp down to -128

9,  -- MP
10, -- mp up to 64
11, -- mp up to 96
12, -- mp up to 128
13, -- mp down to -32
14, -- mp down to -64
15, -- mp down to -96
16, -- mp down to -128

17, -- hp and mp
18, -- hp and mp up to 64
19, -- hp up, mp down, to 32
20, -- hp up, mp down, to 64
21, -- hp down, mp up, to 32
22, -- hp down, mp up, to 64

23, -- accuracy
24, -- accuracy down
25, -- attack
26, -- attack down
27, -- RACC
28, -- RACC down
29, -- RATT
30, -- RATT down
31, -- evasion
32, -- evasion down
33, -- DEF
34, -- DEF down
35, -- MACC
36, -- MACC down
37, -- MEVA
38, -- MEVA down
39, -- enmity
40, -- enmity down
41, -- crit rate
42, -- enemy crit rate down
43, -- Charm+
44, -- Store TP and Subtle Blow
45, -- DMG
46, -- DMG down
47, -- delay%+
48, -- delay%-
49, -- haste%+
50, -- slow+
51, -- HP recovered while healing
52, -- MP recovered while healing
53, -- spell interruption rate down
54, -- physical damage taken %-
55, -- magic damage taken %-
56, -- breath damage taken %-
57, -- magic crit rate
58, -- magic defense bonus down
59, -- latent effect: "Regain" (value is multiplied by ten)
60, -- latent effect: "Refresh"
61, -- "Occ. inc. resist. to stat. ailments" (exact game text lol)
62, -- accuracy up to 64
63, -- RACC up to 64
64, -- MACC up to 64
65, -- attack up to 64
66, -- RATT up to 64
67, -- all songs+ (this is incredibly insane for ballad)
68, -- ACC and ATT
69, -- RACC and RATT
70, -- MACC and MAB
71, -- damage taken %-
72, -- EXP %+ (confirmed does not work right now)
73, -- EXP %+ up to 64
74, -- capacity points %+
75, -- capacity points %+ up to 64
76, -- DMG up to 64
77, -- delay%- up to 64
78, -- HP up to 64
79, -- HP up to 96
80, -- MACC and Mag. Dmg.
81, -- EVA and MEVA
82, -- MP up to 64
83, -- MP up to 96

-- 84 to 95 appear to have no effect whatsoever, the purple AUG button isn't even on the item

96, -- pet ACC and pet RACC
97, -- pet ATT and pet RATT
98, -- pet EVA
99, -- pet DEF
100, -- pet MACC
101, -- pet MAB
102, -- pet crit rate
103, -- pet enemy crit rate down
104, -- pet enmity+
105, -- pet enmity-
106, -- pet ACC and pet RACC (dupe i guess?)
107, -- pet ATT and pet RATT
108, -- pet MACC and MAB
109, -- pet double attack %+ and crit rate
110, -- pet regen+
111, -- pet haste %+
112, -- pet damage taken %-
113, -- pet RACC
114, -- pet RATT
115, -- pet Store TP
116, -- pet Subtle Blow
117, -- pet MEVA
118, -- pet Physical Damage Taken %-
119, -- pet Mag Def Bonus
120, -- avatar mag atk bonus
121, -- pet Breath +
122, -- pet TP Bonus (value multiplied by 20)
123, -- pet Double Attack %+
124, -- pet ACC/RACC/ATK/RATT +
125, -- pet Mag Acc and Mag Dmg
126, -- pet Magic Damage
127, -- pet Magic Damage Taken %-
128, -- "pet:"

129, -- ACC and RACC
130, -- ATT and RATT
131, -- MACC and MAB
132, -- Double Attack %+ and Crit Rate
133, -- MAB
134, -- Magic Def Bonus
135, -- "Avatar:"
136, -- "137"
137, -- Regen
138, -- Refresh (conf'd works)

139, -- Rapid Shot
140, -- Fast Cast %+ (conf'd works)
141, -- Conserve MP
142, -- Store TP
143, -- Double Attack %+ (conf'd works)
144, -- Triple Attack %+ (conf'd works)
145, -- Counter
146, -- Dual Wield
147, -- TH
148, -- Gilfinder
149, -- "150"
150, -- "151"
151, -- Martial Arts
152, -- "153"
153, -- Shield Mastery
154, -- "155"
155, -- "156"
156, -- "157"
157, -- "158"
158, -- "159"
159, -- "160"
160, -- "161"
161, -- "162"
162, -- "163"
163, -- "164"
164, -- "165"
165, -- "166"
166, -- "167"
167, -- "168"
168, -- "169"
169, -- "170"
170, -- "171"
171, -- "172"
172, -- "173"
173, -- "174"
174, -- "175"
175, -- "176"

176, -- Resist Sleep
177, -- Resist Poison
178, -- Resist Paralyze
179, -- Resist Blind
180, -- Resist Silence
181, -- Resist Petrify
182, -- Resist Virus
183, -- Resist Curse
184, -- Resist Stun
185, -- Resist Bind
186, -- Resist Gravity
187, -- Resist Slow
188, -- Resist Charm

189, -- "190"
190, -- "191"
191, -- "192"
192, -- "193"
193, -- "194"
194, -- Kick Attacks
195, -- Subtle Blow
196, -- "197"
197, -- "198"
198, -- Zanshin
-- 199 to 210 are just numbers
211, -- Snapshot
212, -- Recycle
213, -- "214"
214, -- "215
215, -- Ninja Tool Expertise
-- 216 to 232 are just numbers
233, -- Blood Boon
234, -- "235"
235, -- "236"
236, -- "237"
237, -- Occult Accumen
-- more numbers
251, -- Daken
252, -- "253"
253, -- "254"
254, -- "255"
255, -- "256"
256, -- "256" (yep.)

257, -- Hand-to-Hand Skill
258, -- Dagger Skill
259, -- Sword Skill
260, -- Great Sword Skill
261, -- Axe Skill
262, -- Great Axe Skill
263, -- Scythe Skill
264, -- Polearm Skill
265, -- Katana
266, -- Great Katana
267, -- Club Skill
268, -- Staff Skill
269, -- "269"
270, -- "270"
271, -- "271"
272, -- "272"
273, -- "273"
274, -- "274"
275, -- "275"
276, -- "276"
277, -- "277"
278, -- Melee Skill (doesn't seem to affect any skill levels)
279, -- Ranged Skill (doesn't seem to affect any skill levels)
280, -- Magic Skill (doesn't seem to affect any skill levels)
281, -- Archery Skill
282, -- Marksmanship Skill
283, -- Throwing Skill
284, -- "284"
285, -- "285"
286, -- Shield Skill
287, -- "287"
288, -- Divine Skill
289, -- Healing Skill
290, -- Enhance Skill
291, -- Enfeeble Skill
292, -- Element Skill
293, -- Dark Magic Skill
294, -- Summon Skill
295, -- Ninjitsu Skill
296, -- Singing Skill
297, -- String Skill
298, -- Wind Skill
299, -- Blu Magic Skill
300, -- Geomancy Skill
301, -- Handbell Skill
-- 302 to 319 are numbers
320, -- Blood Pact Ability Delay -
321, -- Avatar Perpetuation Cost - (tested, this is ADDING perpetuation cost...)
-- to fix the perpetuation cost issue:
-- UPDATE dspdb.augments SET value = 1 WHERE augmentId = 321;
-- SELECT * FROM dspdb.augments WHERE augmentId = 321;
322, -- Song Spellcasting Time %-
323, -- Cure Spellcasting Time %-
324, -- Call Beast Ability Delay -
325, -- Quick Draw Ability Delay -
326, -- Weapon Skill ACC
327, -- Weapon Skill Damage %+
328, -- Critical Hit Damage %+
329, -- Cure Potency %+ (conf'd works)
330, -- Waltz Potency %+ (conf'd works)
331, -- Waltz Ability Delay - (conf'd works)
332, -- Skillchain Damage %+
333, -- Conserve TP
334, -- Magic Burst Damage %+
335, -- Magic Crit Damage %+
336, -- Sic and Ready Ability Delay -
337, -- Song Recast Delay -
338, -- Barrage
339, -- Elemental Siphon (value multiplied by 5)
340, -- Phantom Roll Ability Delay -
341, -- Repair Potency %+
342, -- Waltz TP Cost - (conf'd does not work)
343, -- Drain and Aspir Potency %+ (conf'd worked for Drain so assumed working for Aspir)
344, -- "345"
345, -- "346"
346, -- "347"
347, -- Healing Magic Recast Delay - (conf'd does not work)
348, -- Elemental Magic Recast Delay -
349, -- Enfeebling Magic Recast Delay -
350, -- Occ. Maximizes Magic Accuracy %+
351, -- Occ. Quickens Spellcasting %+ (conf'd does not work)
352, -- Occ. grants bonus damage based on TP %+
353, -- TP Bonus + (multiplied value by 50) (doesn't seem to work)
354, -- Quadruple Attack (conf'd works!)
355, -- Enhancing Magic Skill Delay -
356, -- Potency of Cure Effect Received %+ (conf'd works!)
357, -- "358"
358, -- "359"
359, -- "360"
360, -- Save TP (conf'd does not work)
361, -- "362"
362, -- Magic Damage
363, -- Chance of successful block
364, -- "365"
365, -- "366"
366, -- Blood Pact Ability Delay II -
367, -- "368"
368, -- Phalanx (conf'd works. each point adds +1 flat damage reduction)
369, -- Blood Pact Damage + (seems to be working... adds flat damage not % damage)
370, -- Reverse Flourish
371, -- Regen Potency (conf'd does not work)
372, -- Embolden
373, -- "374"
374, -- "375"
375, -- "376"
376, -- "377"
377, -- "378"
378, -- "379"
379, -- Enmity + for each Utsusemi
380, -- Physical Damage Limit %+
381, -- "382"
382, -- "383"
383, -- "384"

-- 384 to 500 have no listed effect

512, -- STR
513, -- DEX
514, -- VIT
515, -- AGI
516, -- INT
517, -- MND
518, -- CHR
519, -- STR-
520, -- DEX-
521, -- VIT-
522, -- AGI-
523, -- INT-
524, -- MND-
525, -- CHR-
-- 526 to 549 are very weird combinations of + and - stats
550, -- STR_DEX_BOTH_UP
551, -- STR_VIT_BOTH_UP
552, -- STR_AGI_BOTH_UP
553, -- DEX_AGI_BOTH_UP
554, -- INT_MND_BOTH_UP
555, -- MND_CHR_BOTH_UP
556, -- INT_MND_CHR_ALL_UP
557, -- STR_CHR_BOTH_UP
558, -- STR_INT_BOTH_UP
559, -- STR_MND_BOTH_UP
-- 560 to 767 have no entries in SQL dspdb.augments so i skipped checking them
746, -- Rng Dmg
768, -- Resist Fire
769, -- Resist Ice
770, -- Resist Wind
771, -- Resist Earth
772, -- Resist Lightning
773, -- Resist Water
774, -- Resist Light
775, -- Resist Dark
776, -- Resist Fire-
777, -- Resist Ice-
778, -- Resist Wind-
779, -- Resist Earth-
780, -- Resist Lightning-
781, -- Resist Water-
782, -- Resist Light-
783, -- Resist Dark-
784, -- fire+, water-
785, -- fire-, ice+
786, -- ice-, wind+
787, -- wind-, earth+
788, -- earth-, lightning+
789, -- lightning-, water+
790, -- light+, dark-
791, -- light-, dark+
792, -- fire,wind,lightning,light
793, -- ice,earth,water,dark
794, -- fire,wind,lightning,light ... ice-,earth-,water-,dark-
795, -- fire-,wind-,lightning-,light- ... ice,earth,water,dark
796, -- all resist
797, -- all resist -

-- no entries in SQL again until 896... i'm getting lazy here

896, -- Sword Enhancement Spell Damage
897, -- Enhances Souleater Effect

-- more missing SQL entries

928, -- fire affinity
929, -- ice affinity
930, -- wind affinity
931, -- earth affinity
932, -- lightning affinity
933, -- water affinity
934, -- light affinity
935, -- dark affinity
936, -- fire affinity MACC
937, -- ice affinity MACC
938, -- wind affinity MACC
939, -- earth affinity MACC
940, -- lightning affinity MACC
941, -- water affinity MACC
942, -- light affinity MACC
943, -- dark affinity MACC
944, -- fire affinity MDamage
945, -- ice affinity MDamage
946, -- wind affinity MDamage
947, -- earth affinity MDamage
948, -- lightning affinity MDamage
949, -- water affinity MDamage
950, -- light affinity MDamage
951, -- dark affinity MDamage
-- these perpetuation costs below need the same fix as before
-- UPDATE dspdb.augments SET value = 1 WHERE augmentId IN (952,953,954,955,956,957,958,959);
-- SELECT * FROM dspdb.augments WHERE augmentId IN (952,953,954,955,956,957,958,959);
952, -- fire affinity PerpCost-
953, -- ice affinity PerpCost-
954, -- wind affinity PerpCost-
955, -- earth affinity PerpCost-
956, -- lightning affinity PerpCost-
957, -- water affinity PerpCost-
958, -- light affinity PerpCost-
959, -- dark affinity PerpCost-
960, -- fire affinity MACC and recast%- (recast is 2x the value)
961, -- ice affinity MACC and recast%- (recast is 2x the value)
962, -- wind affinity MACC and recast%- (recast is 2x the value)
963, -- earth affinity MACC and recast%- (recast is 2x the value)
964, -- lightning affinity MACC and recast%- (recast is 2x the value)
965, -- water affinity MACC and recast%- (recast is 2x the value)
966, -- light affinity MACC and recast%- (recast is 2x the value)
967, -- dark affinity MACC and recast%- (recast is 2x the value)
968, -- fire affinity MDamage and recast%- (recast is 2x the value)
969, -- ice affinity MDamage and recast%- (recast is 2x the value)
970, -- wind affinity MDamage and recast%- (recast is 2x the value)
971, -- earth affinity MDamage and recast%- (recast is 2x the value)
972, -- lightning affinity MDamage and recast%- (recast is 2x the value)
973, -- water affinity MDamage and recast%- (recast is 2x the value)
974, -- light affinity MDamage and recast%- (recast is 2x the value)
975, -- dark affinity MDamage and recast%- (recast is 2x the value)
-- more missing SQL entries
-- augid can be max 2047 apparently
-- im just gonna be listing stuff that has SQL entries at this point
-- because there are some massive gaps here
1000, -- fire affinity MACC and recast%- (recast is 6x the value)
1001, -- ice affinity MACC and recast%- (recast is 6x the value)
1002, -- wind affinity MACC and recast%- (recast is 6x the value)
1003, -- earth affinity MACC and recast%- (recast is 6x the value)
1004, -- lightning affinity MACC and recast%- (recast is 6x the value)
1005, -- water affinity MACC and recast%- (recast is 6x the value)
1006, -- light affinity MACC and recast%- (recast is 6x the value)
1007, -- dark affinity MACC and recast%- (recast is 6x the value)
1008, -- fire affinity MDamage and recast%- (recast is 6x the value)
1009, -- ice affinity MDamage and recast%- (recast is 6x the value)
1010, -- wind affinity MDamage and recast%- (recast is 6x the value)
1011, -- earth affinity MDamage and recast%- (recast is 6x the value)
1012, -- lightning affinity MDamage and recast%- (recast is 6x the value)
1013, -- water affinity MDamage and recast%- (recast is 6x the value)
1014, -- light affinity MDamage and recast%- (recast is 6x the value)
1015, -- dark affinity MDamage and recast%- (recast is 6x the value)

1024, -- Backhand Blow Dmg%+ (value multiplied by 5)
1025, -- Spinning Attack Dmg%+ (value multiplied by 5)
1026, -- Howling Fist Dmg%+ (value multiplied by 5)
1027, -- Dragon Kick Dmg%+ (value multiplied by 5)
1028, -- Viper Bite Dmg%+ (value multiplied by 5) (i tested this one and it works! so i'm assuming all the other WS ones work too)
1029, -- Shadowstitch Dmg%+ (value multiplied by 5)
1030, -- Cyclone Dmg%+ (value multiplied by 5)
1031, -- Evisceration Dmg%+ (value multiplied by 5)
1032, -- Burning Blade Dmg%+ (value multiplied by 5)
1033, -- Shining Blade Dmg%+ (value multiplied by 5)
1034, -- Circle Blade Dmg%+ (value multiplied by 5)
1035, -- Savage Blade Dmg%+ (value multiplied by 5)
1036, -- Freezebite (you get the idea)
1037, -- Shockwave
1038, -- Ground Strike
1039, -- Sickle Moon
1040, -- Gale Axe
1041, -- Spinning Axe
1042, -- Calamity
1043, -- Decimation
1044, -- Iron Tempest
1045, -- Sturmwind
1046, -- Keen Edge
1047, -- Steel Cyclone
1048, -- Nightmare Scythe
1049, -- Spinning Scythe
1050, -- Vorpal Scythe
1051, -- Spiral Hell
1052, -- Leg Sweep
1053, -- Vorpal Thrust
1054, -- Skewer
1055, -- Impulse Drive
1056, -- Blade: To
1057, -- Blade: Chi
1058, -- Blade: Ten
1059, -- Blade: Ku
1060, -- Tachi: Goten
1061, -- Tachi: Jinpu
1062, -- Tachi: Koki
1063, -- Tachi: Kasha
1064, -- Brainshaker
1065, -- Skullbreaker
1066, -- Judgement
1067, -- Black Halo
1068, -- Rock Crusher
1069, -- Shell Crusher
1070, -- Full Swing
1071, -- Retribution
1072, -- Dulling Arrow
1073, -- Blast Arrow
1074, -- Arching Arrow
1075, -- Empyreal Arrow
1076, -- Hot Shot
1077, -- Split Shot
1078, -- Sniper Shot
1079, -- Detonator
1080, -- Weapon Skill Damage %+ (value multiplied by 5) (conf'd it works.)

1152, -- says DEF + 10 times the value but is giving far less than listed value...
1153, -- EVA but gives far less than it actually says
1154, -- Mag Evasion (inaccurate value again)
1155, -- Phys Dmg Taken %+ (double value)
1156, -- Magic Dmg Taken %- (double value)
1157, -- Spell Interruption rate down % (double value)
1158, -- Occ inc resist to stat ailments (double value, conf'd not working anyway)

1246, -- Pet: phys dmg taken %- (double value)
1247, -- Pet: magic dmg taken %- (double value)
1248, -- Enhancing Magic Effect Duration %+ (sadly does not work)
1249, -- Helix Effect Duration + (i think it works)

1377, -- Enhances Feral Howl Effect

1792, -- Pet STR (i'm pretty sure these pet stat modifiers are working)
1793, -- Pet DEX
1794, -- Pet VIT
1795, -- Pet AGI
1796, -- Pet INT
1797, -- Pet MND
1798, -- Pet CHR
1799, -- Pet STR-
1800, -- Pet DEX-
1801, -- Pet VIT-
1802, -- Pet AGI-
1803, -- Pet INT-
1804, -- Pet MND-
1805, -- Pet CHR-
1806 -- Pet STR,DEX,VIT
}