Sql statement for tradeskill edit?

[Shendare]

You bet!

Though I got in a hurry to leave the office and forgot to break down what it does so you can be sure before you run it.

If you read it logically right-to-left:

1. ... (SELECT recipe_id FROM tradeskill_recipe_entries e WHERE e.item_id=17187)

Tells the database to make a list of all recipe_ids that work with container item # 17187, which an earlier post said was your desired container)

2. SELECT r.id, 17187, 0, 0, 0, 0, 1 FROM tradeskill_recipe r WHERE r.tradeskill=68 AND r.id NOT IN ...

Tells the database to build a set of recipe_entry records containing the recipe.id, container_id, and proper counts & flags for all recipes in the tradeskill_recipe table that are Jewelcrafting recipes (an earlier post said it was type 68) but are NOT in the list of recipes from #1 above that already work with container # 17187.

3. INSERT INTO tradeskill_recipe_entries (recipe_id, item_id, successcount, failcount, componentcount, salvagecount, iscontainer)

Tells the database to insert those newly built records into the tradeskill_recipe_entries table.

All together, the query creates a new tradeskill_recipe_entries record with containerid 17187 for each Jewelcrafting recipe it finds that does not already have a recipe_entries record for item 17187.