Custom Recipes not showing up in Profession Spellbook

[krlsmnk]

I fear I'm missing something pretty simple. I've made new items in item_template for the patterns. Updated item.dbc, made custom spells in spell, and also updated spell.dbc.
Made a patch file, and correctly applied it to the client.
Deleted the cache.
Restarted everything (on client and server).

Patterns exist. Can be acquired where I wanted them to.
Can be right-clicked to "use" and chat reports that I have learned the spell.
Doing .lookup spell <spellname> confirms that I know the spell.
The spell / pattern does not show up in my profession manual.
See attached screenshot.

What table / DBC have I failed to update?

smol.jpg

[stoneharry]

It's the SkillLine and SkillLineAbility DBC files.

- Skill Line WoWDev Wiki
- Skill Line Ability WoWDev Wiki

Skill line defines the category. Ability maps the spell ID to the category.

[krlsmnk]

Strange. I overlooked both those tables because they're both empty in my SQL.
Do you ONLY have to do this with new patterns?
Surely the ones from the base game are somewhere?

Edit: To clarify, since I never stated this, I'm not making custom professions. Only new recipes for the existing professions.
Edit 2: Since these tables are empty on my end, is there any precedent I can shamelessly copy from to make sure I don't bork common default values for several hours?

[stoneharry]

Strange. I overlooked both those tables because they're both empty in my SQL.
Do you ONLY have to do this with new patterns?
Surely the ones from the base game are somewhere?

Edit: To clarify, since I never stated this, I'm not making custom professions. Only new recipes for the existing professions.
Edit 2: Since these tables are empty on my end, is there any precedent I can shamelessly copy from to make sure I don't bork common default values for several hours?

Where are you looking? These are client side DBC files. Yes these are needed even for new recipes.

The spell editor supports importing <-> exporting of them from DBC to SQL and back.

Releases . stoneharry/WoW-Spell-Editor . GitHub

[krlsmnk]

So in the SQL, both the tables: spell -> spellLine, and spell->spellLineAbility are empty. No records.
Looking at the DBC files, they have 788 and 20683 entries, respectively.
From a raw numbers perspective, that sounds like "SpellLine" contains all the skills/professions.
And "SpellLineAbility" sounds like would contain all the "crafting recipes" from the base game.
The column names in "SpellLineAbility" don't make sense to me, and the "ID" doesn't seem to correspond to pattern items OR item creation spells.

Let's walk through an example and see where I'm screwing up.

1: I want to make a new blacksmithing recipe for "Belt of Broken Bones".
2: In the item_template table in the SQL, I copy the recipe record for "Plans: Thorium Belt" into a new entry.
3: I rename the new entry to "Plans: Belt of Broken Bones", and change the reagent pointer to use Titansteel instead of Thorium.
4: In the spell table in the SQL, I copy the spell record for "Thorium Belt" into a new ID.
5: I rename the new entry to "Belt of Broken Bones", and change the item pointer to my new Plan's entry.
6: I open the SpellEditor, and make sure it can see my new item creation spell for "Belt of Broken Bones"
7: I export all the .DBC files (check all the boxes) from SpellEditor into a patch.MPQ file.
8: Peek at the .DBC files in the patch.MPQ. If "item.dbc" doesn't have the new pattern: I run the SQL command to get the subset of item_template column data to put in the item.dbc. I append that info to the .DBC file, and close up the patch.MPQ.
9: Do the same "peek and fix" to the server's .DBC files (which SpellEditor points to), if they do not have the new record.
10: Clear the client's cache, and put the patch.MPQ file in its data folder with the rest.
11: Start / Restart the World and Auth servers.
12: Get on the client. Connect. GM give myself the new pattern. Learn it. Open crafting book. See no new record.

So... if a modification to spellLine.dbc and / or spellLineAbility.dbc is required to see the new recipe in the crafting book: in between which two steps above do I make that change, and what would the record look like for the "Belt of Broken Bones" spell?