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.
Code:
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.