disable the display from slave article in all products

[paulchen2005]

Hi,

 

i use the contrib all products and there will be displayed the slave products too...

 

what can i do to disable the display from slave article in this list (all products)

 

 

and

 

in my normal productlist has every article a buy now button,

 

if some article have a slave article must the button change in a button "to article" because the customer must meet a selection...

 

 

can someone help me please, i dont know where I must change it

 

thanks

[paulchen2005]

Hi,

 

this is the code to change...

 

$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";

 

can someone help me please ?

 

what must I write that only the articles should be indicated which have the Status=1 ?

 

 

thank you very much

Paul