Crafting bug (missing content)

[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

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