Can be possible a little change at DB structure ?
At roster_recipes the fields categories & item_level are not used ... delete it.
And add the "RecipeID" and ItemID(first number from Item field) both can be parsed from .lua
example of actual recipe at .lua
- Code: Select all
["Nature Protection Potion"] = {
["Difficulty"] = 3,
["Item"] = "6052:0:0:0:0:0:0:0",
["Icon"] = "INV_Potion_06",
["Color"] = "ffffff",
["Tooltip"] = "Nature Protection Potion<br>Requires Level 28<br>Use: Absorbs 1350 to 2250 nature damage. Lasts 2 min.",
["RecipeID"] = 7259,
["Reagents"] = {
{
["Name"] = "Liferoot",
["Count"] = 1,
["itemID"] = "3357",
}, -- [1]
{
["Name"] = "Stranglekelp",
["Count"] = 1,
["itemID"] = "3820",
}, -- [2]
{
["Name"] = "Leaded Vial",
["Count"] = 1,
["itemID"] = "3372",
}, -- [3]
},
},
I don't say change the structure of all .. and only save itemid .. (sure these be at next major version) but at moment get these ID can get a better form to get multilanguage recipes better and fast.
