RF455-078 RF 4.55: no Lv70 (Patron) gear can be crafted, because nothing gives the three High crystals

Game: RF 4.55 (Dragonborn), server v0.3.1, Windows build (stock gameserver.exe). Client: the supported Taiwan build, RF_Online.bin SHA-256 46528aac…2bbc558 (2025-07-16), Language=Taiwan. Expected (wiki) credits to RFDB for https://wiki.rfdatabase.net/ : Update 4.15 "Age of Patron": Patron weapons and armour (Lv70) are crafted from three crystals farmed in Novajan. The Flawless Metallic Crystal crafts the weapons and drops from the Snatcher family. The Flawless Stone Crystal crafts the helmet, upper and gloves and drops from the Crawler family. The Flawless Mineral Crystal crafts the lower, shoes and Shield 70 and drops from the Vafer family.

Summary

• Every Lv70 recipe needs one of the three crystals (read, gamedata_rf455.db itemmakedata). Of the 290 recipes whose output is a Lv70 item, the first material is always one of these:

That is the wiki's split exactly (metal → weapons, stone → helmet/upper/gloves, mineral → lower/shoes/shield). Example: recipe 214 makes iwkna70 Patron Beam Saber from iymkw03 ×140, irrio05 ×94, irrus05 ×94, irria05 ×378 and iymkw04 ×35.

• Nothing in the game gives any of the three crystals (read). The codes appear only in their own bootyitem rows and as recipe materials. So no Patron item can be crafted; the only Patron gear in play is the rare direct drop.
• The Novajan families drop other things, never a crystal (read). Take the Novazan monsters from the 4.15 tables, monstercharacter 1343–1354: the NCO, Junior and Novazan Snatchers, Crawlers and Vafers, and the three Captains 04308, 04407 and 04508. Their itemlooting rows (14 each, 9 for the Captains) hold Lv67 gear (iwknb67 …), gems, charms and potions, but none of the three crystals.

Server side (v0.3.1)

• Crafting itself works (read). (*Server).handleMakeItem 0x140979ce0:
  • it loads the recipe with gamedata.(*Data).CraftManualByIndex (SELECT … FROM itemmakedata WHERE m_dwIndex = ?);
  • it needs a make tool in the bag, then checks and consumes the materials over several stacks (consumeN 0x14097d760, u32 counts), so the 140–648 counts are fine;
  • it picks the output by rand.Intn(10000) over m_dwPdProp and rolls craftSuccessPercent 0x140979b00 (0–95 %). The materials are consumed before that roll, as in RF.
  • So the only thing missing is the crystals.
• Supply (read). A search of every text cell in every gamedata_rf455.db table finds iymkw03, iymka06 and iymka07 only in bootyitem / bootyitem_str (and GoMMO's _client_synced_cells cache) and in itemmakedata.m_itmPdMat. In particular, none of these tables lists them:
  • itemlooting__m_itmlootcodekey (0 rows), boxitemout;
  • storelist__m_stritemlist, cashshop, specialstore;
  • quest, questgainitemevent, eventitem;
  • combinetable, combinetable2, linkedresult__m_strlinkitemout;
  • cfg_event_looting, cfg_event_set_looting_item, cfg_golden_box_reward.

They aren't in gommo_rf455.db either. The other two materials are sold: iymkw04 "Super Energy Core" and iymka08 "Energy Core" are each in 15 storelist rows.

• Loot keys (read): the server loads SELECT _rid, m_strCode, m_nLootRate, m_nOperationCount FROM itemlooting and SELECT _rid, m_itmLootCodeKey FROM itemlooting__m_itmlootcodekey (strings in gameserver.exe). That itemlooting.m_strCode is the monster code is inferred from the values: they match monstercharacter.m_strCode.
• Patron gear drops (read): iwkna70 is in 18 itemlooting rows, at m_nLootRate 10737418 or 21474836 (out of 2³², so 0.25 % or 0.5 %). Their codes include 04312, 04413 and 04511 (Regular Army Crawler, Vafer and Snatcher Rex), 1551c (Crawler Axe Soldier), 0d82c (Snatcher Sniper) and 1561c (Snatcher Archer), but none of the Novazan monsters above.

Suggested fix

• Add the crystals to the Novazan families' itemlooting rows (monstercharacter 1343–1354 at least): iymkw03 for the Snatchers, iymka06 for the Crawlers and iymka07 for the Vafers.

Local workaround

A GM can grant the crystals. Crafting then works as in any other recipe.