Created a new Table with item ids that are used for professions or created by professions
Added this table to the sql query in AuctionHouseBotConfig.cpp
To get these item ids, i selected all spell ids from "SkillLineAbility.dbc" which are connected to a profession.
More information about these spells are stored in "Spell.dbc", so i selected all spells with the ids that i got from the first step and exported the item ids of the fields "Reagent_1" - "Reagent_8" and "EffectItemType_1" - "EffectItemType_3".
Removed the duplicates and stored them in a new table called "auctionhousebot_professionItems"
If someone is interested, i can also upload my php script to get the ids.
Issues Addressed:
Many items that are important for professions are missing in the auctionhouse
Applied the changes, recompiled and looked for profession related items in the auctionhouse.
For example "silver rod" was missing before theses changes. Now I can find it in the ah
Changes Proposed:
To get these item ids, i selected all spell ids from "SkillLineAbility.dbc" which are connected to a profession. More information about these spells are stored in "Spell.dbc", so i selected all spells with the ids that i got from the first step and exported the item ids of the fields "Reagent_1" - "Reagent_8" and "EffectItemType_1" - "EffectItemType_3". Removed the duplicates and stored them in a new table called "auctionhousebot_professionItems"
If someone is interested, i can also upload my php script to get the ids.
Issues Addressed:
Tests Performed:
Applied the changes, recompiled and looked for profession related items in the auctionhouse. For example "silver rod" was missing before theses changes. Now I can find it in the ah
How to Test the Changes:
just compile, run and check the ah