View Single Post
  #1  
Old 12-30-2003, 03:01 AM
Muuss
Dragon
 
Join Date: May 2003
Posts: 539
Default tradeskillrecipe table

in table 'tradeskillrecipe', the field named 'product' (smallint(6)) is set to 'unique'. If you wanna create 2 recipes with the same product as result, it leads you to use product2 instead of product to set the recipe's result. If you have more than 2 recipes returning both the same product and product2, you're blocked.

Returning several items from tradeskill recipes happens quite a lot when you start using tools, like knives in tailoring or hammers in smithing, and you need to use the failproduct field for the tool in case the combine fails.

So the question is :
Is there an alternate way for those situations or do we really need that 'unique' statement on that field?

L8rs
__________________
Muuss - [PEQGC] Dobl, the ogre that counts for 2 !
http://www.vilvert.fr/page.php?id=10
Reply With Quote