View Single Post
  #2  
Old 01-23-2007, 07:15 PM
sfisque
Hill Giant
 
Join Date: Oct 2006
Posts: 248
Default slight fix

replace
sprintf( buf2, "%s", "SELECT tre.recipe_id, count( tre.item_id ) "

with
sprintf( buf2, "%s", "SELECT tre.recipe_id, sum( tre.componentcount ) "

the first line was too restrictive and didnt allow for "experimentation" with recipes that require multiples of the same item (studs for example, which require 3 metal bits).

the new query will allow for those, but there is a very small chance on false positives for recipes that have the exact same ingredients but only vary on the specific quantities of each ingredient but whose sum of ingredients is the same. if you find any such combines, post them to the forum so that we can work out a fix for it.

== sfisque

Last edited by sfisque; 01-24-2007 at 03:17 AM.. Reason: -- wrong line
Reply With Quote