ffxicrafting.com

Crafting data for FFXI era-75 private servers, read from the LandSandBoat server source rather than from wikis.

Built by Secretsos.

Everything on the site is generated from a SQLite database that is itself built by parsing the server's own SQL, Lua and C++. No hand-entered rates.

Layout

data/     ffxi_crafting.db      the database (build it, or copy the prebuilt one in)
tools/    build_db.py           rebuilds the database from a LandSandBoat checkout
          wiki.py               item name -> wiki link helpers
          build_calculator.py   renders public/calculator.html from the database
          templates/            head/body/app source for the calculator
public/   index.html            landing page
          calculator.html       generated

public/ is what gets deployed. Nothing is built on Vercel: the pages are generated locally and committed, so a deploy is a static file copy.

Rebuilding

pip install pyyaml
git clone --depth 1 https://github.com/LandSandBoat/server.git ../lsb-server
python tools/build_db.py ../lsb-server data/ffxi_crafting.db
python tools/build_calculator.py

build_db.py covers items, recipes (synthesis and desynthesis), and every acquisition source the server implements: mob drops and steals, chests and coffers, battlefields, shops, guild shops and rank vendors, regional, conquest and besieged vendors, HELM gathering, chocobo digging, gardening, fishing, clamming, crystals, guild points, and quest rewards.

Deploying

Vercel project settings:

• Framework preset: Other
• Build command: (leave empty)
• Output directory: public

Then point the Cloudflare DNS for the domain at Vercel.

Data and licensing

• The server code this is parsed from (LandSandBoat) is GPLv3.
• The underlying game data belongs to Square Enix. This is a fan resource. Nothing here is sold, and the site carries no game art unless explicitly added.
• The tooling in tools/ is the part worth calling original work.

Accuracy

Numbers come from upstream LandSandBoat. Individual servers run forks with their own settings, so anything server-specific (HQ and drop multipliers, which expansions are enabled, skill caps) is flagged in the UI rather than assumed. The server profile picker exists for exactly this reason.