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?