Crafting at stuff and keg

[Ememjr]

if you try to craft at a stove and keg in frostfang sea crafting area the server will crash
and it appears i crashed emu

[Jabantiz]

Did the other crafting stations work?

[Ememjr]

hmm i thought i posted the fix for this

[Ememjr]

on the current db from svn, there appears to be 147 item numbers missing from the recipe_components table when item slot_id =0 if the primary component item id is missing it caused the server to crash

based on what i have found in most cases the item number in recipe_products for stage 0 matches the item id of the same recipe slot_id 0, which makes since becuase slot_id 0 is the primary compnent, and stage0 item id is the item you get back when failing at the first stage
in fact only seems to be 13 out of 981 that dont follow this

any way here is a sql script you can run to fix the issue and populate the missing data

Code: Select all

UPDATE recipe_components  
INNER JOIN recipe_products 
ON recipe_components.recipe_id = recipe_products.recipe_id
SET recipe_components.item_id = recipe_products.product_id
WHERE recipe_components.slot_id = 0 AND recipe_components.item_id =0

update: that do not dfall into this category are the adornment conversion recipes and the COokies recipes, i will post a fix for those as well

[Cynnar]

As if you can't guess, I'm moving things to archives. This one read to go?

[Ememjr]

only if the above was corrected in the db, i dont seem to have access to check theat