Please help me

[pd91233]

Please help me

My shop is oscommerce-2.2rc2a + STSv4.6_1 + multi-store_v2.1 + extra_fields_v2_1_1

 

extra_fields_v2_1_1 installation step 8.

 

catalog / advanced_search_result.php

 

$ from_str = "from". TABLE_PRODUCTS. "p left join". TABLE_MANUFACTURERS. "m using (manufacturers_id),". TABLE_PRODUCTS_DESCRIPTION. "pd left join". TABLE_SPECIALS. "s on p.products_id = s.products_id,". TABLE_CATEGORIES . "c,". TABLE_PRODUCTS_TO_CATEGORIES. "p2c";

 

With:

 

/ / START: Extra Fields Contribution

/ / $ From_str = "from". TABLE_PRODUCTS. "P left join". TABLE_MANUFACTURERS. "M using (manufacturers_id),". TABLE_PRODUCTS_DESCRIPTION. "Pd left join". TABLE_SPECIALS. "S on p.products_id = s.products_id," . TABLE_CATEGORIES. "c,". TABLE_PRODUCTS_TO_CATEGORIES. "p2c";

$ from_str = "from". TABLE_PRODUCTS. "p left join". TABLE_PRODUCTS_TO_PRODUCTS_EXTRA_FIELDS. "p2pef on p.products_id = p2pef.products_id left join". TABLE_MANUFACTURERS. "m on p.manufacturers_id = m.manufacturers_id left join". TABLE_SPECIALS. " s on p.products_id = s.products_id ";

/ / END: Extra Fields Contribution

 

 

But my multi-store_v2.1 the catalog / advanced_search_result.php

 

$ from_str = "from". TABLE_PRODUCTS. "p left join". TABLE_MANUFACTURERS. "m using (manufacturers_id) left join". TABLE_SPECIALS. "s on p.products_id = s.products_id and s.stores_id = '". STORES_ID. "'INNER JOIN ". TABLE_PRODUCTS_TO_STORES." p2s ON p.products_id = p2s.products_id ";

 

How do I change?