Need a SQL Query Script Please

[Tabasco]

UPDATE `tradeskill_recipe` RIGHT JOIN `tradeskill_recipe_entries` ON (tradeskill_recipe.id = recipe_id) RIGHT JOIN items ON (items.id = item_id) 
SET price = trivial * 10, nodrop = 1
WHERE componentcount > 0 AND iscontainer = 0 AND price = 0

I've tested the select form of that but nothing else.
That should set the price to trivial value * 10 and allow the item to be traded. I don't think vendors will take a nodrop item, but I could be wrong.

[dew1960]

Originally Posted by Tabasco

UPDATE `tradeskill_recipe` RIGHT JOIN `tradeskill_recipe_entries` ON (tradeskill_recipe.id = recipe_id) RIGHT JOIN items ON (items.id = item_id) 
SET price = trivial * 10, nodrop = 1
WHERE componentcount > 0 AND iscontainer = 0 AND price = 0

I've tested the select form of that but nothing else.
That should set the price to trivial value * 10 and allow the item to be traded. I don't think vendors will take a nodrop item, but I could be wrong.

Thank you! I think I saw a variable in the db ruleset to override no drop, but it might have just been for GM's. I am sure this will help tho.

I appreciate it.