Commit graph

161 commits

Author SHA1 Message Date
Paul Campbell
edfc30246e Fix issue with SQL
Fixed an issue with the SQL statements in the base file.
2024-07-17 17:52:26 -04:00
Paul Campbell
9f2dd53ffd Add support for system mail deliveries
Added support for system mail to deliver items to the player.
2024-07-17 17:52:26 -04:00
alborrajo
c01875d27a Added example db migration for the mail update 2024-07-17 21:49:02 +02:00
alborrajo
6781a2b652 Added new "meta" table to DB
This table will hold information about the database schema itself
2024-07-17 21:49:02 +02:00
meecube
b7f565f0a9 mostly implemented additional status to DB 2024-07-16 21:19:57 +02:00
meecube
a5a56d94ec fixed UID errors and added equippoints 2024-07-15 07:52:12 +02:00
meecube
b49902192c clean up 2024-07-15 02:02:46 +02:00
Conner
efadaed1fc
Merge branch 'develop' into develop 2024-07-12 01:15:58 +02:00
meecube
76dab0944f attempting to implement equippoints 2024-07-12 01:14:32 +02:00
Paul Campbell
2c771ef882 Add support for quests in party
- Party list updates with proper progress.
- Track completion of world quests.
- Treat quest accept as a checkpoint for saving progress.
- Fix issue where shallow copy didn't really shallow copy in the quest
  structure.
- Fix issue where changing additional members of quest structure on accident.
- Added checkpoints to 1.0 MSQ.
2024-06-22 08:38:13 -04:00
Paul Campbell
aaa78bb608 Add support for saving quest progress in DB
Added support for saving the progress of a quest when it is completed.
Note that if you perform some intermediate steps and then log out, you
need to do all those steps again.
2024-06-08 16:52:32 -04:00
alborrajo
573c68ad57 Allow having different pawn SP skills equipped per job 2024-06-02 23:57:18 +02:00
Paul Campbell
26352a4216 Save Rewards in the db
- Save unclaimed rewards in the database.
- Limit up to 100 items stored per character.
- Add check for more than 4 random rewards for a quest in the asset
  deserializer.
- Added a req packet for the box list handler and changed the parent
  type.
2024-06-02 16:46:08 -04:00
alborrajo
9447382d78 Persist bazaar state in database 2024-05-31 23:36:28 +02:00
alborrajo
3bc80e20fc Store max bazaar exhibits in database 2024-05-31 22:18:46 +02:00
alborrajo
0d03eda48e Correct pawn sp skill sql table definition 2024-05-23 16:38:22 +02:00
Mike
6accc605d6 fix schema so it properly generates for postgres 2024-05-16 23:30:42 -04:00
alborrajo
c5571b26a4 Persist pawn training in the database 2024-05-09 23:24:24 +02:00
Paul Campbell
911c345d6c feat: Track HP and Stamina properly after upgrades and logout
When a user logs out or disconnects, the disconnect notification is raised.
When this happens, the current value of green and white HP is stored in the
DB. This value will then be used the next time the character is logged into.
When the user purchases an upgrade at the white dragon, HP and Stamina are
refilled to the max value.
2024-05-02 19:50:55 -04:00
Paul Campbell
55a2137b70 refactor: Remove unused stats from the DB
Removed stats related to gain params which are now tracked by the dragon
force augmentation table.
2024-05-01 23:44:23 -04:00
Paul Campbell
c22cdc7eca refactor: Removed unused jewelry_slot_num field
Since the dragon force augment mechanic was implemented, the
jewelry_slot_num field in the DB is no longer used, so remove it.
2024-04-30 08:17:14 -04:00
Mike Salerno
5a442eff93
Merge branch 'develop' into feature/friend-list 2024-04-28 18:58:08 -04:00
Paul Campbell
c47670cd1a feat: Add limited support for "Dragon Force Augment"
- Added preliminary support for the "Dragon Force Augment" mechanism for
  player characters.
  - It is possible to buy all nodes in the tree, but not all
    purchases work as intended. Purchases reflect properly in the
    tree GUI. They also display properly in the currency and
    dragon force tabs in the Status/Equipment menu.
      - What works:
        - Unlocking stats like Strength, Magick, MaxHp, MaxStamina,
	  Physical Defense, Magick Defense, Augment Points, Secret Abilities,
	  Rift Points and Gold.
      - What sorta works:
        - Jewelry Slots (requires to log out and back in to unlock in menu)
      - What doesn't work:
        - Unlocking different types of pawns and item slots.
- Added an empty screen which no longer hangs the game when the user
  selects "Skill Augmentation" from the white dragon.
- Disabled menus which don't work and refactored ingame packet to match
  actual contents of the packet.
- Removed most secret augments being added by default. Added special
  event augments which can't be acquired through normal means.
- Fixed an exception made when augments are removed.
2024-04-28 18:12:51 -04:00
Mike Salerno
beea1c6028 remove online_status column and get from client.character 2024-04-28 17:00:36 -04:00
Mike
5df5e1e790 sync online status on ligin/logou/dc 2024-04-27 21:35:46 -04:00
alborrajo
fe7bef27ca
Update schema_sqlite.sql
Added missing semicolon
2023-10-16 16:00:35 +02:00
alborrajo
fb237a60d6 Moved Warp Points to database 2023-10-13 18:11:56 +02:00
Sehkah
0d6a23aed4 Further reduce differences between database schemas. 2023-09-23 00:35:53 +02:00
Sehkah
8ccb17fbbf Reduce differences between database schemas. 2023-09-23 00:06:03 +02:00
alborrajo
503837ef18 Equip job items 2023-08-09 20:41:52 +02:00
alborrajo
07496ea741 moved skill/aug learning to DB 2023-06-07 21:03:49 +02:00
alborrajo
266f0699a8 corrected db schema 2023-04-30 16:07:27 +02:00
alborrajo
739414c3a3 pawn reaction and sp skill in db 2023-04-30 01:39:01 +02:00
alborrajo
ee271534c7 Deleting a character also deletes the ddon_character_common row 2023-04-29 22:40:04 +02:00
alborrajo
3b1826247a db refactoring to accomodate for CharacterCommon 2023-04-29 22:12:55 +02:00
alborrajo
e037baaf4a Stored wallet points in DB 2023-03-13 21:20:09 +01:00
alborrajo
5f26dc8997 Fixed DB schema constraints 2023-01-05 17:17:57 +01:00
alborrajo
b6221bed88 Generation of Item UId by hashing their properties 2023-01-05 01:59:05 +01:00
alborrajo
9163c7f7d0 Moved item_num from the item table to the storage_item table 2023-01-04 21:54:53 +01:00
alborrajo
c942a41ac8 Implemented item sortdata storing and retrieving 2023-01-04 19:01:14 +01:00
alborrajo
fd783cc721 Moved items and storage to DB, changed equipment to use DB items 2023-01-02 22:24:16 +01:00
alborrajo
5c39fabc7f Equip items now have UIDs 2022-12-07 22:20:33 +01:00
alborrajo
1d729d8a0d Fixed terrible choice of primary keys made when sleepy at 1am 2022-10-04 21:31:59 +02:00
alborrajo
52095c82c6 Persist shortcuts and comunication shortcuts in DB 2022-10-04 00:32:47 +02:00
alborrajo
d1c472a350 Separate tables and model for skills and abilities 2022-10-01 01:06:25 +02:00
alborrajo
cf6e0f76fa Abilities now work properly 2022-09-25 23:24:57 +02:00
sebastian-heinz
243bf6283e typo 2022-09-23 15:31:50 +08:00
sebastian-heinz
a42ef4250b use serverId for connection tracking 2022-09-23 15:02:20 +08:00
sebastian-heinz
e6b263055b keep track of connection via db 2022-09-22 20:37:13 +08:00
sebastian-heinz
76548d1b12 server transition time 2022-09-22 17:29:21 +08:00