EQEmulator Forums - COMMITTED: Bazaar focus effect search fix

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