Quote:
Originally Posted by Tabasco
Code:
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. 
__________________
I know we just met and this is crazy but, here's my server, play on it, maybe?
Adventure Unlimted - Underfoot!
|