PDA

View Full Version : Small recipe retrieval change.


Rabayn
06-15-2009, 01:45 AM
This little query change should make it so there is no need for redundant fail/succeed/component rows for the same item in a recipe entry.

In zone\tradeskills.cpp GetTradeRecipe()

Replace:
qlen = MakeAnyLenString(&query, "SELECT item_id,successcount FROM tradeskill_recipe_entries"
" WHERE successcount>0 AND componentcount=0 AND recipe_id=%u", recipe_id);

With:
qlen = MakeAnyLenString(&query, "SELECT item_id,successcount FROM tradeskill_recipe_entries"
" WHERE successcount>0 AND recipe_id=%u", recipe_id);

and Replace:
qlen = MakeAnyLenString(&query, "SELECT item_id,failcount FROM tradeskill_recipe_entries"
" WHERE failcount>0 AND componentcount=0 AND recipe_id=%u", recipe_id);

with:
qlen = MakeAnyLenString(&query, "SELECT item_id,failcount FROM tradeskill_recipe_entries"
" WHERE failcount>0 AND recipe_id=%u", recipe_id);

trevius
06-22-2009, 05:59 AM
This has now been added to Revision 702 on the SVN.