log in for price

[Ajeh]

Sorry, thought I put the new code in RED ...

In the function_general.php you will see the line in black:

    $button_check = $db->Execute("select product_is_call, products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "'");

Put the code in RED above that ...

[pageblair]

Ok I put that in and still no prices, I changes store back to 0, normal store (no login) and still shows prices for all including cat 112.

cust details, view shop prices set to # 2 and no prices (for anything) show, please advise.

[Ajeh]

Go to phpMyAdmin and search your table:
products

for one of the products_id that is in the Category 112, and see what is in the field:
master_categories_id

does it read 112?

Did you copy and paste the code in RED into your code or did you try to re-type it?

[oavs]

WOW. this worked like a charm Ajeh! Thanks for this.

No need for elaborate modle installation.

One question, can we add multible categories like so?

 
// bof: Login for Price
$chk_login_for_price = false;
$chk_category_sql = "SELECT master_categories_id FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . (int)$products_id . "'";
$chk_category = $db->Execute($chk_category_sql);
if ($_SESSION['customer_id'] ==0 && in_array((int)$chk_category->fields['master_categories_id'], array(123, 145, 1187)) ) {
return TEXT_LOGIN_FOR_PRICE_BUTTON_REPLACE;
}
// eof: Login for Price

[oavs]

You would need to address the Price and the Add to Cart button ...

In the functions_general.php in the function zen_get_buy_now_button ...

You can add the code in RED:

// bof: Login for Price button      
$chk_login_for_price = false;
$chk_category_sql = "SELECT master_categories_id FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . (int)$product_id . "'";
$chk_category = $db->Execute($chk_category_sql);
if ($_SESSION['customer_id'] ==0 && in_array((int)$chk_category->fields['master_categories_id'], array(10, 12)) ) {
  $login_for_price = '<a href="' . zen_href_link(FILENAME_LOGIN, '', 'SSL') . '">' .  TEXT_LOGIN_FOR_PRICE_BUTTON_REPLACE . '</a>';
  return $login_for_price;
}
// eof: Login for Price button      

    $button_check = $db->Execute("select product_is_call, products_quantity from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "'");

In the function file function_prices in the function zen_get_products_display_price you can add the code in RED:

// show case only
    if (STORE_STATUS != '0') {
      if (STORE_STATUS == '1') {
        return '';
      }
    }

// bof: Login for Price     
$chk_login_for_price = false;
$chk_category_sql = "SELECT master_categories_id FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . (int)$products_id . "'";
$chk_category = $db->Execute($chk_category_sql);
if ($_SESSION['customer_id'] ==0 && in_array((int)$chk_category->fields['master_categories_id'], array(10, 12)) ) {
  return TEXT_LOGIN_FOR_PRICE_BUTTON_REPLACE;
}
// eof: Login for Price

How do you handle for the products have attributes or specials?
I have the categories and the subcategories under the master category working but any products has attributes or specials are still showing their prices. How can I hide those product prices have the attributes and specials as well?

[oavs]

THis works CategoryA> CategoryAB> ProductABC

Is it possible to hide the products under deeper category structure?
CategoryA> CategoryAB> CategoryABC> CategoryABCD> PoductABCDE

Hope Ajeh is still around :-}