Index: trunk/kernel/include/searchitems.php =================================================================== diff -u -r120 -r191 --- trunk/kernel/include/searchitems.php (.../searchitems.php) (revision 120) +++ trunk/kernel/include/searchitems.php (.../searchitems.php) (revision 191) @@ -293,7 +293,7 @@ } else $or=""; - $w .= "$or $FieldName LIKE '%".$required[$i]."%')"; + $w .= "$or $FieldName LIKE '%".$required[$i]."%'"; } } if(strlen($w)>0) @@ -313,7 +313,7 @@ { static $SelectSQL, $OldItemType; global $objSession, $objItemTypes; - + //echo "perfirming Simple Search
"; //echo "Old Item Type: $OldItemType New: $ItemType
\n"; if($ItemType != $OldItemType) $SelectSQL = ""; @@ -325,6 +325,9 @@ $result=0; $PopField = $ctype->Get("PopField"); $RateField = $ctype->Get("RateField"); + + //print_pre($this->keywords); + if(!strlen($SelectSQL)) { $typestr = str_pad($ItemType,2,"0",STR_PAD_LEFT); @@ -358,13 +361,13 @@ { if($this->RequiredRelevance>0) $weight = $this->FieldWeight[$f] + ($this->FieldWeight[$f]*($this->RequiredRelevance/100)); - + if($k != $full || $single) { $s[] = " (IF ($f LIKE '%$k%', ".$weight.", 0))"; } } - //echo "
";print_r($s); echo "
"; + // echo "
";print_r($s); echo "
"; $txt = implode("+",$s); //echo $txt."
\n"; $ifs[] = $txt; @@ -445,7 +448,7 @@ else { $full_sql = "INSERT INTO ".$this->ResultTable." (Relevance,ItemId,ResourceId,ItemType,EdPick) ".$SelectSQL; -// echo "[".$full_sql."]
\n"; + //echo "[".htmlspecialchars($full_sql)."]
\n"; $this->adodbConnection->Execute($full_sql); //echo $this->adodbConnection->ErrorMsg()."
\n"; }