View Single Post
  #7  
Old 04-10-2008, 03:25 PM
 
MACWIllo MACWIllo is offline
 

Member
  
Join Date: Nov 2006
Posts: 17
 

Default Re: Show Wholesale Products

Hmm. Can't seem to get it to work. My "Retail" membership is membershipid '9', and so I replaced your default wholesale value of '2' to my '9' in the hope that this would display any products available to "Retail" memberships to anyone not logged in.

This is my search.php code:

Code:
if ($current_area == 'C') { /*if ($user_account['membershipid'] == 0) { $where[] = "$sql_tbl[category_memberships].membershipid IS NULL AND $sql_tbl[product_memberships].membershipid IS NULL"; } else { $where[] = "($sql_tbl[category_memberships].membershipid IS NULL OR $sql_tbl[category_memberships].membershipid = '$user_account[membershipid]')"; $where[] = "($sql_tbl[product_memberships].membershipid IS NULL OR $sql_tbl[product_memberships].membershipid = '$user_account[membershipid]')"; }*/ $where[] = "($sql_tbl[category_memberships].membershipid IS NULL OR $sql_tbl[category_memberships].membershipid = '9')"; $where[] = "($sql_tbl[product_memberships].membershipid IS NULL OR $sql_tbl[product_memberships].membershipid = '9')"; $where[] = "$sql_tbl[categories].avail = 'Y'"; }

I've also done the changes to the func.product.php:

Code:
if ($current_area == "C") { /*$membershipid_condition = " AND ($sql_tbl[category_memberships].membershipid = '$membershipid' OR $sql_tbl[category_memberships].membershipid IS NULL) "; $p_membershipid_condition = " AND ($sql_tbl[product_memberships].membershipid = '$membershipid' 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";*/ $membershipid_condition = " AND ($sql_tbl[category_memberships].membershipid = '9' OR $sql_tbl[category_memberships].membershipid IS NULL) "; $p_membershipid_condition = " AND ($sql_tbl[product_memberships].membershipid = '9' 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"; } else {

Any ideas why it wouldn't be working?
__________________
X-cart 4.1.8
www.mooo.com.au
Reply With Quote