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?