For anyone having trouble getting the normal price to show in 4.2.3 (not the list price) I had to update the query in newproducts.php (from the original post) like so:
Code:
SELECT xcart_products.*, xcart_pricing.*, xcart_quick_flags.* from xcart_products LEFT JOIN xcart_quick_flags ON xcart_quick_flags.productid = xcart_products.productid LEFT JOIN xcart_pricing ON xcart_pricing.productid = xcart_products.productid WHERE forsale = 'Y' ORDER BY add_date DESC LIMIT 12
So that problem is taken care of. My final problem is getting the buy now button to work. Has anyone gotten the buy_now button functioning with this mod?