PDA

View Full Version : COMMITTED: Bazaar focus effect search fix


wheeljack
08-07-2010, 05:11 PM
This patch fixes a bug where searching for an item with a focus effect in the bazaar always returns 0 results. This bug was caused by the wrong column name being used in the constructed sql statement.

Index: zone/trading.cpp
================================================== =================
--- zone/trading.cpp (revision 1617)
+++ zone/trading.cpp (working copy)
@@ -1230,7 +1230,7 @@
Search.append(" and items.spellid>=1298 and items.spellid<=1307");
break;
case 49:
- Search.append(" and items.focusid>0");
+ Search.append(" and items.focuseffect > 0");
break;
default:
sprintf(Tmp, " and items.itemtype=%i", Type);


If PEQ stays down, who knows what other fixes I'll get coded up. :)

Derision
08-08-2010, 10:11 AM
Committed in Rev 1618. Thanks :)