View Single Post
  #101  
Old 04-11-2009, 05:29 PM
Cheesypeas
Fire Beetle
 
Join Date: Jun 2008
Location: UK
Posts: 4
Default

If anyone is still having trouble with the item search function throwing up items you wouldn't expect as mentioned above, it can be easily fixed by capitalising $query on lines 89 - 96 of items.php so that it looks like this:

PHP Code:
 if($iclass 0)    { $Query.=$s ($tbitems.classes & $iclass) ";    $s="AND"; }
  if(
$ideity 0)    { $Query.=$s ($tbitems.deity   & $ideity) ";    $s="AND"; }
  if(
$irace 0)     { $Query.=$s ($tbitems.races   & $irace) ";     $s="AND"; }
  if(
$itype >= 0)    { $Query.=$s ($tbitems.itemtype=$itype) ";      $s="AND"; }
  if(
$islot 0)     { $Query.=$s ($tbitems.slots   & $islot) ";     $s="AND"; }
  if(
$iaugslot 0)  { $Query.=$s ($tbitems.augtype=$iaugslot) ";    $s="AND"; }
  if(
$ireqlevel 0) { $Query.=$s ($tbitems.reqlevel<=$ireqlevel) "$s="AND"; }
  if(!(
$inodrop))    { $Query.=$s ($tbitems.nodrop=1)";              $s="AND"; } 
Hope this helps someone
Reply With Quote