View Single Post
  #3  
Old 03-19-2008, 10:34 PM
 
deffe deffe is offline
 

Member
  
Join Date: Oct 2007
Posts: 27
 

Default Re: Show Wholesale Products

And here is the allowed product listing. In /include/func/func.product.php, ~line 668, comment all three SQL condition variables and replace with:

Code:
$membershipid_condition = " AND ($sql_tbl[category_memberships].membershipid = '2' OR $sql_tbl[category_memberships].membershipid IS NULL) "; $p_membershipid_condition = " AND ($sql_tbl[product_memberships].membershipid = '2' OR $sql_tbl[product_memberships].membershipid IS NULL) "; $price_condition = " AND $sql_tbl[quick_prices].membershipid ".((empty($membershipid) || empty($active_modules['Wholesale_Trading'])) ? "= '0'" : "IN ('$membershipid', '0')")." AND $sql_tbl[quick_prices].priceid = $sql_tbl[pricing].priceid";

Love it when I answer my own questions.
__________________
Version 4.3.2
Reply With Quote