Jump to content
dev osCommerce
Forum
  • Checkout
  • Login
  • Contact Us
  • Get in touch

osCommerce

The e-commerce.

New Demo
Our Partners

Hide products from customer groups for SPPC Help

Guest

By Guest
in General Add-Ons Support

 Share

Recommended Posts

Guest

Guest

Posted
Posted

I have the All Prodcuts contribution installed and just installed Hide Products for SPPC. It works great on everything except the allprods.php page. Any ideas?

 

Here is the code:

 

<?php

 

require('includes/application_top.php');

include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ALLPRODS);

 

$breadcrumb->add(HEADING_TITLE, tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL'));

 

$firstletter=$HTTP_GET_VARS['fl'];

if (is_numeric($firstletter)) {

$where="where pd.products_name like '!%' || pd.products_name like '0%' || pd.products_name like '1%' || pd.products_name like '2%' || pd.products_name like '3%' || pd.products_name like '4%' || pd.products_name like '5%' || pd.products_name like '6%' || pd.products_name like '7%' || pd.products_name like '8%' || pd.products_name like '9%'";

} elseif (!$HTTP_GET_VARS['page']){

$where="where pd.products_name like '$firstletter%'";

} else {

$where="where pd.products_name like '$firstletter%'";

}

 

 

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<?php

// BOF: WebMakers.com Changed: Header Tag Controller v2.55

// Replaced by header_tags.php

if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {

require(DIR_WS_INCLUDES . 'header_tags.php');

} else {

?>

<title><?php echo TITLE ?></title>

<?php

}

// EOF: WebMakers.com Changed: Header Tag Controller v1.0

?>

<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<META HTTP-EQUIV="imagetoolbar" CONTENT="no">

<script LANGUAGE="JavaScript1.1" type="text/javascript">

<!-- Begin

function right(e) {

if (navigator.appName == 'Netscape' &&

(e.which == 3 || e.which == 2))

return false;

else if (navigator.appName == 'Microsoft Internet Explorer' &&

(event.button == 2 || event.button == 3)) {

alert("Function Disabled!");

return false;

}

return true;

}

 

document.onmousedown=right;

document.onmouseup=right;

if (document.layers) window.captureEvents(Event.MOUSEDOWN);

if (document.layers) window.captureEvents(Event.MOUSEUP);

window.onmousedown=right;

window.onmouseup=right;

// End -->

</script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

 

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<?php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {?>

<td><h1><?php echo HEADING_TITLE; ?></h1></td>

<?php } else { ?>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<?php } ?>

</tr>

<tr>

<td class="main"><?php echo HEADING_SUB_TEXT; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td align="center" class="smallText"><?php $firstletter_nav=

'<a href="' . tep_href_link("allprods.php", 'fl=0', 'NONSSL') . '"> # |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=A', 'NONSSL') . '"> A |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=B', 'NONSSL') . '"> B |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=C', 'NONSSL') . '"> C |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=D', 'NONSSL') . '"> D |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=E', 'NONSSL') . '"> E |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=F', 'NONSSL') . '"> F |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=G', 'NONSSL') . '"> G |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=H', 'NONSSL') . '"> H |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=I', 'NONSSL') . '"> I |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=J', 'NONSSL') . '"> J |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=K', 'NONSSL') . '"> K |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=L', 'NONSSL') . '"> L |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=M', 'NONSSL') . '"> M |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=N', 'NONSSL') . '"> N |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=O', 'NONSSL') . '"> O |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=P', 'NONSSL') . '"> P |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Q', 'NONSSL') . '"> Q |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=R', 'NONSSL') . '"> R |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=S', 'NONSSL') . '"> S |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=T', 'NONSSL') . '"> T |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=U', 'NONSSL') . '"> U |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=V', 'NONSSL') . '"> V |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=W', 'NONSSL') . '"> W |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=X', 'NONSSL') . '"> X |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Y', 'NONSSL') . '"> Y |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Z', 'NONSSL') . '"> Z |</A>' .

'<a href="' . tep_href_link("allprods.php", '', 'NONSSL') . '"> <b>ALL</b></A>';

 

echo $firstletter_nav; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td>

<?php

// create column list

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

asort($define_list);

 

$column_list = array();

reset($define_list);

while (list($column, $value) = each($define_list)) {

if ($value) $column_list[] = $column;

}

 

$select_column_list = '';

 

for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {

if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_NAME') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) {

continue;

}

}

 

// listing all products

$listing_sql = "select p.products_id, p.products_model, pd.products_name, p.products_quantity, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name";

 

if (ALL_PRODUCTS_DISPLAY_MODE == 'true')

include(DIR_WS_MODULES . 'product_listing.php'); //display in standard format

else

include(DIR_WS_MODULES . 'allprods.php');

?>

</td>

</tr>

</table></td>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Link to comment
Share on other sites
danil0

danil0

Posted
Posted (edited)
I have the All Prodcuts contribution installed and just installed Hide Products for SPPC. It works great on everything except the allprods.php page. Any ideas?

 

Here is the code:

 

<?php

 

require('includes/application_top.php');

include(DIR_WS_LANGUAGES . $language . '/' . FILENAME_ALLPRODS);

 

$breadcrumb->add(HEADING_TITLE, tep_href_link(FILENAME_ALLPRODS, '', 'NONSSL'));

 

$firstletter=$HTTP_GET_VARS['fl'];

if (is_numeric($firstletter)) {

$where="where pd.products_name like '!%' || pd.products_name like '0%' || pd.products_name like '1%' || pd.products_name like '2%' || pd.products_name like '3%' || pd.products_name like '4%' || pd.products_name like '5%' || pd.products_name like '6%' || pd.products_name like '7%' || pd.products_name like '8%' || pd.products_name like '9%'";

} elseif (!$HTTP_GET_VARS['page']){

$where="where pd.products_name like '$firstletter%'";

} else {

$where="where pd.products_name like '$firstletter%'";

}

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<?php

// BOF: WebMakers.com Changed: Header Tag Controller v2.55

// Replaced by header_tags.php

if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {

require(DIR_WS_INCLUDES . 'header_tags.php');

} else {

?>

<title><?php echo TITLE ?></title>

<?php

}

// EOF: WebMakers.com Changed: Header Tag Controller v1.0

?>

<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

<META HTTP-EQUIV="imagetoolbar" CONTENT="no">

<script LANGUAGE="JavaScript1.1" type="text/javascript">

<!-- Begin

function right(e) {

if (navigator.appName == 'Netscape' &&

(e.which == 3 || e.which == 2))

return false;

else if (navigator.appName == 'Microsoft Internet Explorer' &&

(event.button == 2 || event.button == 3)) {

alert("Function Disabled!");

return false;

}

return true;

}

 

document.onmousedown=right;

document.onmouseup=right;

if (document.layers) window.captureEvents(Event.MOUSEDOWN);

if (document.layers) window.captureEvents(Event.MOUSEUP);

window.onmousedown=right;

window.onmouseup=right;

// End -->

</script>

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

 

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<?php if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {?>

<td><h1><?php echo HEADING_TITLE; ?></h1></td>

<?php } else { ?>

<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

<?php } ?>

</tr>

<tr>

<td class="main"><?php echo HEADING_SUB_TEXT; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td align="center" class="smallText"><?php $firstletter_nav=

'<a href="' . tep_href_link("allprods.php", 'fl=0', 'NONSSL') . '"> # |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=A', 'NONSSL') . '"> A |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=B', 'NONSSL') . '"> B |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=C', 'NONSSL') . '"> C |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=D', 'NONSSL') . '"> D |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=E', 'NONSSL') . '"> E |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=F', 'NONSSL') . '"> F |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=G', 'NONSSL') . '"> G |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=H', 'NONSSL') . '"> H |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=I', 'NONSSL') . '"> I |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=J', 'NONSSL') . '"> J |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=K', 'NONSSL') . '"> K |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=L', 'NONSSL') . '"> L |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=M', 'NONSSL') . '"> M |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=N', 'NONSSL') . '"> N |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=O', 'NONSSL') . '"> O |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=P', 'NONSSL') . '"> P |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Q', 'NONSSL') . '"> Q |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=R', 'NONSSL') . '"> R |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=S', 'NONSSL') . '"> S |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=T', 'NONSSL') . '"> T |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=U', 'NONSSL') . '"> U |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=V', 'NONSSL') . '"> V |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=W', 'NONSSL') . '"> W |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=X', 'NONSSL') . '"> X |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Y', 'NONSSL') . '"> Y |</A>' .

'<a href="' . tep_href_link("allprods.php", 'fl=Z', 'NONSSL') . '"> Z |</A>' .

'<a href="' . tep_href_link("allprods.php", '', 'NONSSL') . '"> <b>ALL</b></A>';

 

echo $firstletter_nav; ?></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

<tr>

<td>

<?php

// create column list

$define_list = array('PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,

'PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,

'PRODUCT_LIST_MANUFACTURER' => PRODUCT_LIST_MANUFACTURER,

'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,

'PRODUCT_LIST_QUANTITY' => PRODUCT_LIST_QUANTITY,

'PRODUCT_LIST_WEIGHT' => PRODUCT_LIST_WEIGHT,

'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE,

'PRODUCT_LIST_BUY_NOW' => PRODUCT_LIST_BUY_NOW);

asort($define_list);

 

$column_list = array();

reset($define_list);

while (list($column, $value) = each($define_list)) {

if ($value) $column_list[] = $column;

}

 

$select_column_list = '';

 

for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {

if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') || ($column_list[$col] == 'PRODUCT_LIST_NAME') || ($column_list[$col] == 'PRODUCT_LIST_PRICE') ) {

continue;

}

}

 

// listing all products

$listing_sql = "select p.products_id, p.products_model, pd.products_name, p.products_quantity, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by pd.products_name";

 

if (ALL_PRODUCTS_DISPLAY_MODE == 'true')

include(DIR_WS_MODULES . 'product_listing.php'); //display in standard format

else

include(DIR_WS_MODULES . 'allprods.php');

?>

</td>

</tr>

</table></td>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

 

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

 

I m looking for the same thing.

 

I made it working when I put this code on line 30

if(!tep_session_is_registered('sppc_customer_group_id')) { 
 $customer_group_id = '0';
 } else {
  $customer_group_id = $sppc_customer_group_id;
 }

 

and I used the SQL LISTING of new_products.php :

 

  $listing_sql = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id = m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c using(products_id) left join " . TABLE_CATEGORIES . " c using(categories_id) where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and find_in_set('".$customer_group_id."', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by pd.products_name";

 

The problem is that this "listing" for some reason doubles my products. HELP SOMEONE!!!

Edited by danil0
Link to comment
Share on other sites
Jan Zonjee

Jan Zonjee

Posted
Posted
I m looking for the same thing.

 

The problem is that this "listing" for some reason doubles my products.

This seems to work:

// BOF Separate Pricing Per Customer/Hide products and categories
 if (isset($_SESSION['sppc_customer_group_id']) && $_SESSION['sppc_customer_group_id'] != '0') {
 $customer_group_id = $_SESSION['sppc_customer_group_id'];
 } else {
  $customer_group_id = '0';
 } 

// listing all products
$listing_sql = "select distinct p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on c.categories_id = p2c.categories_id and pd.language_id = '" . $languages_id . "' $where and find_in_set('" . $customer_group_id . "', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by pd.products_name";
// EOF Separate Pricing Per Customer/Hide products and categories

Link to comment
Share on other sites
danil0

danil0

Posted
Posted
This seems to work:

// BOF Separate Pricing Per Customer/Hide products and categories
 if (isset($_SESSION['sppc_customer_group_id']) && $_SESSION['sppc_customer_group_id'] != '0') {
 $customer_group_id = $_SESSION['sppc_customer_group_id'];
 } else {
  $customer_group_id = '0';
 } 

// listing all products
$listing_sql = "select distinct p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, NULL as specials_new_products_price, p.products_date_added, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on c.categories_id = p2c.categories_id and pd.language_id = '" . $languages_id . "' $where and find_in_set('" . $customer_group_id . "', products_hide_from_groups) = 0 and find_in_set('" . $customer_group_id . "', categories_hide_from_groups) = 0 order by pd.products_name";
// EOF Separate Pricing Per Customer/Hide products and categories

 

Thank you VERY much... its working PERFECT !!!

Link to comment
Share on other sites
  • 1 month later...
devilgrins

devilgrins

Posted
Posted

hi there janz.. i have installed this and i get this error when i head over to categories/products in admin

 

1054 - Unknown column 'c.categories_hide_from_groups' in 'field list'

select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_hide_from_groups from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name

 

yes i do have sppc working b4 i installed this contrib..

 

is there something i am missing

 

hope to hear from you soon.. or from anyone who can lend a hand..

 

cheers

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...