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
|