Index: trunk/kernel/include/advsearch.php =================================================================== diff -u -r1188 -r1566 --- trunk/kernel/include/advsearch.php (.../advsearch.php) (revision 1188) +++ trunk/kernel/include/advsearch.php (.../advsearch.php) (revision 1566) @@ -44,9 +44,10 @@ } else { $tables = Array(1 => 'Category', 2 => 'News', - 3 => 'Topic', 4 => 'Link'); + 3 => 'Topic', 4 => 'Link', + 11 => 'Products'); $table = $tables[$ItemType]; - $sql = "SELECT sc.* FROM ".$objSearchConfig->SourceTable." AS sc LEFT JOIN ".GetTablePrefix()."CustomField AS cf ON sc.CustomFieldId = cf.CustomFieldId WHERE TableName='$table' OR (TableName='".GetTablePrefix()."CustomField' AND cf.Type = $ItemType) AND AdvancedSearch=1 ORDER BY sc.DisplayOrder"; + $sql = "SELECT sc.* FROM ".$objSearchConfig->SourceTable." AS sc LEFT JOIN ".GetTablePrefix()."CustomField AS cf ON sc.CustomFieldId = cf.CustomFieldId WHERE TableName='$table' OR ((TableName='".GetTablePrefix()."CustomField' OR TableName='CustomField') AND cf.Type = $ItemType) AND AdvancedSearch=1 ORDER BY sc.DisplayOrder"; $objSearchConfig->Query_Item($sql); } }