Commit graph

136 commits

Author SHA1 Message Date
sruon
c131efc69b 30260604_0 Version Update Items 2026-06-10 02:46:20 -06:00
sruon
179bd6512c 30260429_1 new items 2026-05-20 23:51:52 -06:00
sruon
ea0859a360 Audit weapon damage type 2026-04-10 22:38:51 -06:00
sruon
370ef5efca Audit weapons skill, damage, delay 2026-04-10 20:47:35 -06:00
sruon
427cfc249a Add missing equipment and weapon items 2026-04-09 22:01:36 -06:00
MrSent
c70813af68 Audit and addition of all jug pet jug items 2026-03-03 18:40:56 +00:00
Will Buck
f65bda686c Item mod corrections: SC DMG, Crit Evasion 2026-02-22 14:58:12 -06:00
WinterSolstice8
a69b09dab9 [sql] Replace zeroed damage types with appropriate defaults 2025-12-11 20:12:33 -07:00
Rosienaikanaro
ab6f7a2e82 Cosmetic Armor Update
Adds the AA sets, Ilm set, Poroggo Fleece, and Erudite Staff.
2025-11-02 19:39:32 -05:00
MrSent
31b816b67a Dispelga usable with daybreak 2025-10-16 21:13:57 +01:00
sruon
15d49f322b itemutils: Use type column in DB 2025-09-19 14:10:15 -06:00
sruon
8af667b9f4 Items: deprecate _sql 2025-09-13 01:40:05 -06:00
MowFord
381c9e2949
Implement Jug pet: Sweet Caroline 2025-09-10 22:21:35 -05:00
9001-Solutions
e96c78c815 Ranged Distance Penalty 2025-07-09 11:23:16 -04:00
WinterSolstice8
2b838e9bae [sql] Update Ungur Boomerang to have Piercing damage type 2024-08-24 12:42:54 -06:00
0x05010705
39e6eaac49
Add Levin Stats (#6028) 2024-07-22 12:05:44 +01:00
Chris Honkonen
e25099b587 adding ranine weapon to item_weapon
fixing bad sql syntax/removing whitespaces after commas in sql file
2024-06-12 10:26:30 -04:00
MowFord
2c2a609ee5
Update damage type on Tyro Katars 2024-05-21 22:07:25 -05:00
MowFord
a442583b01 Marvelous Cheer is a cosmetic item only 2024-04-14 11:31:20 -05:00
Carver
1c4511caae
Add Sha Wujing's lance (#5105)
* add wiring for sha wujings lance

* Minor cleanup:
- Correct item dispensing animation and remove 'todo'
- Switch to modifier from slot check, because historically checking gear slots in item scripts is HEAVILY discouraged with many good reasons
- Fix a typo in an unrelated item name comment along the way.
- Add several missing for "eat raw meat" and "eat raw fish" items.

---------

Co-authored-by: TeoTwawki <arawn.annwn@yandex.com>
2024-02-08 05:52:09 -05:00
Helix Hamin
4d6031d514 [SQL][Items] Item mods 19029-20625 2024-01-25 09:38:40 +08: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
Delaide
b41626e82d
[SQL] Add some missing item_equipment and item_weapon entries. Fix some incorrect MIDs
With corrections to item_basic.sql
As per the previous PR request, single space between EOL and comment.
2023-08-14 21:31:38 -04:00
claywar
5b881a73d5
[db/enum] Add missing entries from Mog Bonanza 2023-07-28 18:35:45 -04:00
N3ckB3ard
e028769759
[SQL] [LUA] Add Login Campaign Rewards: Mutsunokami, "Fancy" sets (#3569)
* Add Login Campaign Reward Items

Adds new items:
Fancy Sets (Summer clothing)

Fancy Gilet: Dispense: persikos snow cone
Fancy Top: Dispense: persikos snow cone

Fancy Trunks: FIRE RESIST and WATER RESIST + 10 (Summer Tidings)
Fancy Shorts: FIRE RESIST and WATER RESIST + 10 (Summer Tidings)

Mutsunokami

Corrects a issue when using Persikos Snow Cone. The LUA file was named the Sorthand rather than the ItemName

* Fix EOL error

* Fix Dupe Entry

* Add "Persikos" to itemids.lua
2023-02-08 14:16:45 +00:00
Zach Toogood
edc817a2d7 [db] Make all tables CHARSET=utf8mb4 2023-02-05 21:13:32 +00:00
Xaver-DaRed
5d4a0994e0 Implement "Agwus Scythe" Weapon
Co-authored-by: Schaedelschaden <Schaedelschaden@users.noreply.github.com>
2023-01-13 16:50:35 +01:00
SirGouki
66eede4c0b Add Helgoland
Corrected incorrect slot for Helgoland in item_equipment.sql
Added Helgoland to item_weapon.sql
2022-11-07 17:44:07 -08:00
Xsoulsin
8871700af2 Update locations for gear
Update locations for the gear
2022-06-06 20:26:50 -07:00
Xsoulsin
f5fc19cc26 Gear Update
Added in gear updates for lvl 99, Missing Mods, Equipment
2022-06-06 18:23:50 -07:00
claywar
b2e26a5863
Merge branch 'base' into base 2021-11-26 16:38:01 -05:00
Helix Hamin
ddca4501b4 Add some missing items, weapons, mods, etc.
Giving up on trying to complete the list this time around, before something comes in and messes up what I have done so far...

Also, added require("scripts/globals/items") to the item luas, and added the new use items to items.lua.

Update: Fixed the item luas to change the item id to the item name after adding to items.lua.
2021-11-19 14:33:36 +08: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
Helix Hamin
a840857a96 Submit missing and corrected H2H weapon information
Should be fixed and ready for base integration. No additional effects added or changed.

All information checked with DAT file information, and with FFXIAH and both wikis. Information based on item check screen, not on assumptions of the values and effects.
2021-09-22 12:55:50 +08:00
claywar
f9442c0606
Update Automaton stand back logic, add Animator II subskill 2021-08-06 12:43:16 -04:00
wrenffxi
3aabfefcad [version update] items 2021-05-11 12:37:26 -04:00
wrenffxi
cfe2256b3b [client update] items 2021-04-29 10:58:24 -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
wrenffxi
997c35fb3b [version update] titles, items, spells 2020-12-13 08:38:49 +02:00
wrenffxi
3eadba2833 [client update] items 2020-11-11 00:03:51 -05:00
Zach Toogood
13984d8472 Add basic information for event sword: Nihility 2020-09-11 20:04:59 +03:00
Helix Hamin
95677cde61 Updates for item_equipment.sql, item_latents.sql, item_weapon.sql from lelia
Still need to do item_mods, but holding to prevent conflict with https://github.com/project-topaz/topaz/pull/752
Still need to add lelia scripts, but I will do that in a separate PR.
2020-06-29 13:52:16 +08:00
Topaz
aa6e168add Commits from upstream, 2019/12/11 to 2019/01/13 2020-01-13 10:25:10 -08:00
wrenffxi
e6344ced9b [client update] items 2019-12-18 18:17:40 -05:00