Seems like things are more evident now, but since it was asked.
Consider the following two questions and how you’d answer them from the API:
- What can I craft from mithril ore?
- What recipes can my Scribe (level xx) craft?
I develop my tool as an application, not a web-project, so for me running though some lists or dictionaries looks like a faster way to get things done, then requesting server for each action.
Question 1: It can be split into two different actions, first being an addition to the second:
1. Connect user input “Mithril Ore” with the item ID (if it is a user input and we don’t know the ID). I’ve added it not so long ago, so: I have two lists: one if integer – IDs, second of string (item names). The search function creates the list of indexes of items in the 2nd list, containing “Mithril Ore”, then converts it into the list of item IDs from the 1st list (item #10 corresponds to the item #10), so the list of item IDs is returned to the table, from which Mithril Ore can be selected – we get our ID.
2. Code:
Public Function GetRecipesUsingItem(i_ItemID As Integer) As List(Of cls_HolderAPI2RecipeDetails)
Dim lst_return As New List(Of cls_HolderAPI2RecipeDetails)
For Each item In dic_RecipesDetails
For Each item2 In item.Value.ingredients
If item2.item_id = i_ItemID Then
Dim lst_LvlUPRecipes As New List(Of cls_HolderAPI2RecipeDetails)
lst_LvlUPRecipes = GetRecipesUsingItem(item.Value.output_item_id)
If lst_LvlUPRecipes IsNot Nothing Then
lst_return.AddRange(lst_LvlUPRecipes)
End If
lst_return.Add(item.Value)
End If
Next
Next
If lst_return.Count = 0 Then
Return Nothing
Else
Return lst_return
End If
End Function
This recursive function returns the list of all recipes, in which the given item and its “children” are used as ingredients. Then another function converts it into the list of results item IDs, which is then converted into names at the stage of filling the result table. It can be converted directly, but the program works with IDs, not names, I only use names when it is something the user is to see.
Conversion to name is simple, item details are stored in the dictionary of item details classes, with item IDs being keys. So, for example
[pre]msgbox (GetItemForID(i_ItemID).name)
Public Function GetItemForID(i_ID As Integer) As cls_HolderAPI2ItemDetails
If dic_ItemsDetails.ContainsKey(i_ID) = True Then
Return dic_ItemsDetails.Item(i_ID)
End If
Dim cls_ZeroResult As New cls_HolderAPI2ItemDetails
cls_ZeroResult.name = “N/A”
Return cls_ZeroResult
End Function[/pre]
“What recipes can my Scribe (level xx) craft?”
I have a boolean function b_IsNeededDiscipline, that checks: is the given recipe corresponds to the given recipe search settings (discipline and level), like Scribe (level xx) . It is used on several occasions, in your task it will be cycling through all the recipes, creating the list of recipes IDs, that correspond to the given setting.
I’m sorry for much text, and possibly sorry for stupid code – I’m not a pro.
P.S. I understand that using a local database would be the right way to do it, but had my reasons to do it this way.
Ok, but since there is an index to find recipes by ingredient and output, at least there was some hope this would be doable.