Quest rewards and currency SQL — 2026-09-16

Quest rewards and currency SQL — September 16, 2026

The full published quest collection is exported as MySQL 8.4 SQL, including
146,518 source records, 135,742 with structured rewards, and 206,432 item reward slots.
The maximum retained item quantity is 100,000. Counts include overlapping views.
10,776 website records without structured reward fields retain their original data;
all 10,820 conversion issues are recorded in SQL, not silently discarded.

Rune of Ascension (item 375250) occurs in 13,344 of 18,554 quests in the current
published CoA mode view. The earlier 99.37% stock-overlap figure described NPC
quest relationships, not quest rewards or the proportion of vanilla files.

Loading this file stages data and installs guarded server apply/rollback procedures.
Use a disposable world copy. Explicit dry-run/application chooses one mode-specific
source; no quest defaults or currency definitions are invented. Missing endpoints,
identity conflicts, narrow columns and unsupported core/DBC differences are reported.
Spell/reputation/title/honor-multiplier differences require separate review.
Database validation does not establish currency spending or gameplay behavior.

Import instructions and source:
https://github.com/hertigservices/Ascension_preservation/tree/main/tools/ascension-sql

Site report and filtered export:
https://ascension-db.ascension-archive.workers.dev/quest-sql.html
https://ascension-db.ascension-archive.workers.dev/#search?kind=quest

See report.json for the pinned catalog/revision and per-source counts,
currency-census.json for individual mode observations, verification.json for
validation, and manifest.json for checksums and implementation identities.

Consolidated preservation tools and setup

Ascension Preservation now contains the bridge/testbed, reviewed AuthGate source, character importer and cache consolidator. Component history, licenses and standalone importer commands are retained. Preserved datasets live in hertigservices/ascension-data.

The attached standalone importer wheel is version 1.1.1. Unified setup, compatibility pins, runtime configuration and deployment manifests are included. The revision includes CI portability corrections for Python 3.9, Linux case-sensitive paths and Windows short paths.

The stock-client work remains experimental. The compatibility manifest records local core modifications; it does not claim the installed server can be reproduced from the upstream base alone. Offline validation does not replace in-game acceptance testing.

This .2 release also completes the renamed ascension-data links and makes the tray GUI share the publisher's configured data checkout. Earlier tags remain unchanged.

Consolidated preservation tools and setup

Ascension Preservation now contains the bridge/testbed, reviewed AuthGate source, character importer and cache consolidator. Component history, licenses and standalone importer commands are retained. Preserved datasets live in hertigservices/ascension-data.

The attached standalone importer wheel is version 1.1.1. Unified setup, compatibility pins, runtime configuration and deployment manifests are included. The revision includes CI portability corrections for Python 3.9, Linux case-sensitive paths and Windows short paths.

The stock-client work remains experimental. The compatibility manifest records local core modifications; it does not claim the installed server can be reproduced from the upstream base alone. Offline validation does not replace in-game acceptance testing.