Commit graph

161 commits

Author SHA1 Message Date
Mike Salerno
cc52087788 make clan_id an autoincrement column 2024-12-22 19:50:46 -05:00
Paul Campbell
7fe9fc94c0 feat: Implement a task scheduler
Implemented a light weight mechanism for scheduling recurring tasks.
This can be used to implement, hourly, daily or weekly resets. There is
also an intention to use the mechanism to check for seasonal events and
turn on/off depending on the date.
2024-12-15 08:29:07 -05:00
Paul Campbell
33c467b269 fix: Correct small issues in multiple world quest files
- Fixed issues related to enemy spawn and NPC text in 50 quest files.
- Fixed an issue in the SQL schema when creating a new database.

Authored-by: Cert
2024-12-12 09:50:13 -05:00
alborrajo
0a11d4c3a6 Save pawn state in the database 2024-12-10 17:47:06 +01:00
Paul Campbell
ec686b8cf2 implement new packets, handlers and database queries
- Implemented many req, res, ntc and handlers for Epitaph content.
- Renamed existing BonusDungeonManager to DungeonManager.
- Implemented database migration from 24 -> 25.
- Implemented a new packet handler which provides a queue which can be
  used to send packets after the response is returned.
- Commented out RPC ping print message.
- Added new NPC behavior to NpcGetExtendedFacilityHandler.
2024-11-24 19:01:03 -05:00
Ryan Yappert
4003b7c1e7 Even more clan stuff; DB migration 23 -> 24 2024-11-22 02:14:50 -08:00
Ryan Yappert
520d94c2a2 Add DB Migration 21 -> 22 2024-10-28 14:18:58 -07:00
Paul Campbell
6d22055f56 DB Migration
Migrate database from 20 to 21.
2024-10-08 21:25:12 -04:00
Ryan Yappert
4f9f18fc8f Cleanup; migration; PeriodicSync object for Clan data. 2024-10-03 23:38:48 -07:00
Ryan Yappert
f60cbeadf7 Creating clans and persistence across logins. 2024-10-03 23:38:48 -07:00
Ryan Yappert
f4f832bf16 Various clan packets. 2024-10-03 23:38:48 -07:00
Asterit
aae8e8b02e Added support for variant quests to drop their independent rewards as defined in their JSON. Renamed variant id to be more explicit within the schema. 2024-08-30 18:20:15 +01:00
Asterit
763c9bfb0f Added a way for variant quests to be added to the project. This version stored a variant id within quest progress if a quest has started. This is used to find the specific quest version the client needs to show the correct enemies. Rewards may still not work as expected. Needs further looking at. 2024-08-29 18:27:23 +01:00
Paul Campbell
68c7b1a730 feat: Add support to hire pawns
Added the ability to hire other player pawns through the rift crystal.
2024-08-26 15:21:32 -04:00
Sehkah
11dde93b0d Add TODOs for orb unlock & expand other DB syntax replacement cases. 2024-08-23 23:47:29 +02:00
Sehkah
e6409908de Merge branch 'develop' of https://github.com/Sehkah/Arrowgene.DragonsDogmaOnline into feature/further-investigate-crafting-packets 2024-08-23 23:14:06 +02:00
Paul Campbell
2fdc6a7988 Code Review Feedback
- Added comments documenting some special numbers.
- Fixed an issue with GetContentStatusFromOmReq.
- Updated migration logic to use sql commands directly.
- Fixed an issue a crash occured after resetting progress and changing
  jobs.
- S2CBattleContentAreaChange.cs => S2CBattleContentAreaChangeNtc.cs.
- Moved loot generation into instanced manager for BBM.
- Moved SwapCharacterInventories to CharacterSwitchGameModeHandler.
- Added a DB query to get all storages by character id.
- Fixed issue with new character creation.
- Fixed an issue where main quests didn't start.
- Delete BBM character when main character is deleted
2024-08-23 15:14:39 -04:00
Paul Campbell
0f5fbf3bbb Database Migration
Added a new migration strategy to migrate the database from version 11
to 12.
2024-08-23 15:14:39 -04:00
Paul Campbell
250d47ac61 feat: Add support for Bitterblack Maze
Added support for the player to participate in Bitterblack Maze. This
content allows the player to collect bracelets and earrings which gain
randomized stats based on the job they are collected on. The player uses
currency earned during the event to transfer items from the bitterblack
maze content to the normal game content.

Co-authored-by: Cert
Co-authored-by: @Conner-Schaffer
Co-authored-by: Dark Warrior
Co-authored-by: @Sehkah
Co-authored-by: Sera Eidolon

What works:
- Add support for creating a new character for BBM
- Add class randomized loot
- Bitterblack Maze special jewelry rewards
- Add BBM Spawns
- Add support for different Lyka menu options
  - Report Search Results
  - Reset Progress
  - Bitterblack Shop
  - Rare Item Appraisal
  - Bitterblack Item Takeaway
- Equip items directly from treasure chest
- Homepoint to Bitterblack Maze Cove when dead in the maze
- Update Schema for new tables and provide migration strategy

What doesn't work:
- Using Pawns
- Bitterblack Equipment Effect Seal
- Player ready up menu
- Item sort messes up sort between different modes
- Clear timestamp is incorrect
- Tracking treasure claimed
- Inventory is not deleted when home pointing after death
- Some enemies get stuck on terrain (probably wrong mob for area)
- Original quest to start BBM not implemented
- Reset progress doesn't consume reset tickets
- Reset tickets not awarded
- Players not in party sometimes can't be seen

DB Migration:
To update an existing database run 'dotnet run dbmigration' to upgrade from version '11' to version '12'.
2024-08-23 15:14:34 -04:00
Sehkah
94e8752dfb Support deleting pawns; also improve base schema consistency and add some missing delete cascades. 2024-08-23 16:51:59 +02:00
Sehkah
516091d245 Fix various crafting exp, rank & promotion-related bugs. 2024-08-18 11:09:47 +02:00
Ryan Yappert
07a576814f Provide all characters a blank blob in migration. Target DB v10 -> v11. 2024-08-15 21:22:46 -07:00
Ryan Yappert
00be912b8c DB stuff for binary data. 2024-08-15 21:22:46 -07:00
Sehkah
853efba76c Add craft progress table to base schema & fix some syntax errors. 2024-08-11 20:42:14 +02:00
Ryan Yappert
7cb688f9b7 Preset database stuff. 2024-08-10 15:24:06 -07:00
Conner
fc4add73b4
Merge branch 'develop' into develop 2024-08-05 17:11:45 +02:00
Ryan Yappert
c605d7323b Actually get stamp DB stuff fixed. 2024-08-05 01:32:56 -07:00
meecube
d8aff9b82a Merge remote-tracking branch 'upstream/develop' into develop 2024-08-03 16:27:15 +02:00
Ryan Yappert
f347e6c905 Various hotfixes. 2024-08-03 03:22:31 -07:00
meecube
4106643b7b Merge remote-tracking branch 'upstream/develop' into develop 2024-08-03 11:28:12 +02:00
meecube
08270ac032 Merge remote-tracking branch 'upstream/develop' into develop 2024-08-02 19:28:23 +02:00
meecube
d4c30a239b commented out addstatus stuff it appears to potentially be a much bigger system 2024-08-02 19:24:35 +02:00
meecube
99615a8411 some reveiw addressed and fixes AdditionalStatus 2024-08-02 16:17:59 +02:00
Paul Campbell
5044bf597c Add ability to remove crests
Added support to destroy crests already attached.
2024-08-02 08:24:19 -04:00
Ryan Yappert
38e212c5a2 Review comments. 2024-07-31 21:35:35 -07:00
Ryan Yappert
a26ffdfdca Database versioning. 2024-07-31 21:35:35 -07:00
Ryan Yappert
d4438433a2 Stamp DB stuff. 2024-07-31 21:35:33 -07:00
meecube
5b7d6d1826 Merge remote-tracking branch 'upstream/develop' into develop 2024-07-31 00:15:02 +02:00
meecube
a066af14ef Additional status stuff working quite well but doesnt update client side properly 2024-07-31 00:07:07 +02:00
meecube
fe3fb5ab3d re attempting AddStatus 2024-07-29 23:53:27 +02:00
Ryan Yappert
12c175e82b Address review comments, change DB PlayPoint stuff to use character_id instead of character_common_id. 2024-07-29 13:24:14 -07:00
meecube
101f673aea Restore upgrading functionality 2024-07-29 20:16:04 +02:00
meecube
d8607c1d97 Merge remote-tracking branch 'pacampbell/all_items_uid' into develop 2024-07-29 16:57:47 +02:00
Paul Campbell
ce6622fb65 Add UID Migration strategy
Added strategy to create new UID for every item.
2024-07-28 19:41:02 -04:00
meecube
c68aa0835c Merge remote-tracking branch 'upstream/develop' into develop 2024-07-28 03:22:03 +02:00
Ryan Yappert
c706f95850 Adjust PlayPoint migration. Fix typo in Equip Migration :^) 2024-07-26 23:30:32 -07:00
Paul Campbell
62fff4d369 Add primary key 2024-07-30 00:43:01 -04:00
Paul Campbell
5134ad32be Make schema match migration
UNIQUE vs PRIMARY key constraint for ddon_storage_item.
2024-07-29 21:56:14 -04:00
Paul Campbell
c6affd209c Add Item Migration
- Created a migration for the currently equipped items.
- Created a new SystemMailService class to help with delivering mail
  items to players.
- Changed existing database functions so they can be used inside the
  migration files.
2024-07-25 23:45:53 -04:00
meecube
f42fb06792 Merge remote-tracking branch 'upstream/develop' into develop 2024-07-25 06:56:14 +02:00