ddon-server/Arrowgene.Ddon.Database/Files/Database/Script/migration_recycle_equipment.sql
Paul Campbell 8c03891849 feat: Add support for "Arms Resource Disassembly"
Added support to breakdown equipment into BO, R, G and some random items
based on some parameters. Exposed the item selection algorithm as a new
script equipment_recycle.csx. Added a new settings script under the
uncategorized section called equipment_recycle.csx. This contains
settings related to disassembly of equipment.

Addiitonal Changes:
- Fixed an issue with the task scheduler where timers were not stored in
  the task manager, which leads to them eventually getting garbage
  collected.
- Updated the schedule script to print what type of task it is reporting
  for.
- Added behavior for Custom-Made Service Ticket and Silver Ticket when
  the player receives them as an item from a quest to put them in the
  wallet.
2025-03-24 22:39:20 -04:00

9 lines
399 B
SQL

INSERT INTO ddon_schedule_next(type, timestamp) VALUES (24, 0);
CREATE TABLE "ddon_recycle_equipment"
(
"character_id" INTEGER NOT NULL,
"num_attempts" INTEGER NOT NULL,
CONSTRAINT pk_ddon_recycle_equipment PRIMARY KEY ("character_id"),
CONSTRAINT fk_ddon_recycle_equipment_character_id FOREIGN KEY ("character_id") REFERENCES "ddon_character" ("character_id") ON DELETE CASCADE
);