pd91233 Posted October 3, 2013 Share Posted October 3, 2013 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.