Player-facing TAKP-canonical alignment — race/class stats, skill caps, tradeskills, items, loot
- System
Items table: 1,184 TAKP raid items restored at canonical IDs (lossless renumber)
Audit of the items table against TAKP found 1,142 ID collisions — TAKP-canonical item IDs in The Last Camp occupied by post-era squatters from a historical PEQ DB import. Iconic PoP raid loot like Walex's Vindication, Zyzzix's Click Stick, Frostbite Cold Blade of Dread, Ultor's Chestguard of Faith — all gone, replaced at their canonical IDs by Berserker Emblems, Shiliskin parts, Drachnid components. Plus 42 TAKP items missing entirely. Fix preserves both datasets: 878 referenced squatters renumbered to high IDs 600000-600877, 16,650+ refs across 10 tables walked to follow them, then TAKP item data written at canonical IDs. Net items grew 118,059 → 118,979.
- 1,142 collisions resolved: 264 unreferenced overwritten directly; 878 referenced renumbered to 600000+ with refs walked
- 42 missing TAKP items inserted at canonical IDs
- Reference walks: 7,000 lootdrop_entries refs + 8,892 tradeskill_recipe_entries refs + 635 merchantlist refs + 78 starting_items + 55 inventory + 39 ground_spawns + 8 misc — all migrated cleanly
- Verified post-apply: 32000 → Walex's Vindication, 32002 → Zyzzix's Click Stick, 32134 → Rizlona's Fiery Chestplate, 32603 → Ultor's Chestguard of Faith. Berserker Emblem preserved at 600852 with all drop chains intact.
- Patch: db-patches/2026-05-06-items-canonical/ · backup at /root/crushbone-backups/items_canon_pre_20260506.sql
- System
Loot system: 58,698 TAKP-canonical drop chain rows restored
Sequel to the items audit. With TAKP items at canonical IDs, the era-correct drop chains were missing in The Last Camp — only 1,276 of TAKP's 20,734 loottable_entries matched, and only 5,054 of 40,425 lootdrop_entries. Restored 9 missing loottables, 3,860 missing lootdrops, 19,458 loottable_entries, and 35,371 lootdrop_entries. Era-correct mobs now drop era-correct loot.
- Fungi Covered Great Staff drops from Myconid Spore King via canonical TAKP chain
- Manastone drops via Legendary_Manastone_Drop chain (0.0001%, era-rare)
- Guise of the Deceiver drops from a_ghoul_assassin
- PoP raid loot range (32000-32615) — restored items table state, but TAKP source has zero lootdrop_entries for these IDs (canonically scripted via player.pl EVENT_DEATH). Founder Rewards Phase 2 will wire those quest-script drops
- Patch: db-patches/2026-05-06-lootdrop-canonical/ · backup at /root/crushbone-backups/lootdrop_pre_canonical_20260506.sql
- System
Race/class starting stats — TAKP-canonical alignment across 137 combos
Krunk audit (lvl 19 Druid) revealed the systemic gap: The Last Camp's Ogre Cleric started with 20 fewer total stat points than Ogre Shaman, despite both being wisdom-casters with identical TAKP class signatures. Server-wide audit found this across all newly-unlocked race/class combos — every The Last Camp-custom combo had ad-hoc base stats diverging from TAKP convention. Aligned 14 base races (Drakkin and Froglok kept their The Last Camp-era flat racial bases). Erudite Monk/Berserker now use Erudite SK base; High Elf Monk/Berserker use High Elf Paladin base. Rangers across every race now get DEX+20 not AGI+20.
- 38 new alloc rows (IDs 500-537), 53 existing alloc rows updated in place, 74 char_create_combinations re-points
- Wisdom-casters (Cleric/Druid/Shaman) all share +5 STA, +25 WIS allocation bonus per TAKP
- Beastlord allocation correctly split off from caster allocs in 17 race-specific cases — was previously sharing one alloc with the wisdom-casters
- Existing characters keep their stats. Only NEW characters created from this point onward get TAKP-canonical starting numbers
- Patch: db-patches/2026-05-06-race-class-canonical/
- System
Skill caps — 1,030 early-level extras zeroed; Rogue Make Poison gap filled
Audit found 1,030 cap>0 entries The Last Camp added at levels BELOW TAKP's start for the (skill, class) — most notably Specializations 20-29 for Cleric/Druid/Shaman (the systemic Krunk-bug enabler). Lvl 20-29 casters can no longer train spec at trainers. Hybrid pre-spell casting skills closed at lvl 1-8 for Pal/Ranger/SK/Bst. Bard skills like Pick Lock, Disarm Traps, Brass/Stringed/Wind Instruments now start at TAKP-canonical levels (Pick Lock at 40 not 10, Brass at 11 not 5). Berserking removed from non-Berserkers. Rogue Make Poison gap at lvl 8-9 filled with TAKP caps 45/50.
- Bard playstyle preserved — TAKP includes all of Bard's utility skills (Pick Lock, Disarm Traps, Forage, instruments). Only the level gates are aligned to era.
- skill_caps loads on zone boot; online players keep cached caps until next zone or relog
- Patch: db-patches/2026-05-06-skill-caps-canonical/ · backup at /root/crushbone-backups/skill_caps_pre_canonical_20260506.sql
- System
Tradeskill recipes — 250 era recipes inserted, 7,766 post-era leakage gated
The Last Camp's tradeskill_recipe table had 22,775 rows (vs TAKP's 7,400) but 12,229 of the extras were silently ungated (min_expansion=-1, max_expansion=-1) — meaning post-PoP recipes from LDoN/GoD/OoW/etc were trainable in the era. Restored 250 missing TAKP recipes with their entries. Gated 7,766 ungated post-era recipes (id > 13634 OR trivial > 250) to min_expansion=9, max_expansion=99 — matches The Last Camp's existing pattern for the 3,297 already-gated extras. Left 4,463 plausibly-era PEQ extensions alone (id ≤ 13634, trivial ≤ 250).
- tradeskill_recipe is read on combine — no restart needed; effect immediate
- Patch: db-patches/2026-05-06-tradeskill-canonical/ · backup at /root/crushbone-backups/tradeskill_pre_canonical_20260506.sql
- Tweak
Site /classes page now reflects The Last Camp's any-race/any-class policy
The /classes page was showing canonical-EQ era restrictions on race lists (Cleric only on 8 races, Monk only Human/Iksar) which contradicted the wiki's documented policy and the live DB. Updated each class's race list to all 16 races (Human through Drakkin). Added Berserker as the sixteenth class entry — previously only documented in the wiki, now visible on the /classes hub.