Hello Matti et all
Good news, :lol:
The N to N master slave relationship (aka Master products version 2) is one step closer. THis means you can assign a slave to many masters. Not easy, but possible.
I need some expert help to make it work, but here is where we are so far in combining Johnson's contrib with Galen's contrib.
The additions need to be used with Master product 1.1.5 files.
Please read all post before proceeding with changes. The imperfect way it works now is explained at the end. Thank you.
Step 1- Insert a new table to hold the M-S relationships
SQL query using PHPMY Admin:
CREATE TABLE `products_to_master` (
`slave_id` int(11) NOT NULL default '0',
`master_id` int(11) NOT NULL default '0'
);
2. in catalog/includes/modules/master_products.php
replace
$master_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_tax_class_id, s.specials_new_products_price, s.status, p.products_price from ". TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_master = '" . $thisquery['products_master'] . "' and p.products_status = '1' and pd.language_id = '" . (int)$languages_id . "'";
WITH
$master_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, pm.master_id, pm.slave_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_MASTER . " pm, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and p.products_id=pm.slave_id and pm.master_id=" . $_GET['products_id'] ;
Step 3
Corection to add to cart in catalog/includes/application_top.php
FIND
// customer adds a product from the products page
case 'add_product' : if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) {
$cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+1, $HTTP_POST_VARS['id']);
}
tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters)));
break;
After above INSERT/OR REPLACE if case 'add_slave' exists:
//Master Products ENDLICH ?BERHOLT!! Ren? Reineke 06.12.03
// customer adds multiple products from the master_listing page
case 'add_slave' :
foreach ($HTTP_POST_VARS as $keyA => $valueA) {
if (substr($keyA,0,11) == "Qty_ProdId_") {
$prodId = substr($keyA,11);
if ($valueA <= 0 ) continue;
$cart->add_cart($prodId, $cart->get_quantity(tep_get_uprid($prodId, $HTTP_POST_VARS['id']))+($valueA), $HTTP_POST_VARS['id']);
}
}
tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters)));
break;
//Master Products EOF
HOW IT WORKS NOW:
a)
Assign a product as a master and assign one slave to it using Johnson's contrib. (If you remove or do not add this slave, the following will not work any more)
B)
Using PhPMYAdmin add the master slave relationships you want in the products_to_master table.
c)
YOur master product will list all the slaves that you added to the products_to_master table. The Add to cart button will add all of them to the cart.
THINGS WE NEED HELP WITH:
1. a work around issue a). If there is a relationship in the products_to_master table it should be listed even if we did not assign a slave using Johnson's contrib or if we remove that slave
2. A user-friendly admin page where we can assign the slave master relationships in the products_to_master table. It would be excellent if we can assign more slaves/masters at once.
3. A friendly admin page where we can change the status of a product from master to slave and from slave to master.
That's all. I would say with your help this can be functional and friendly in a few days.
Read you soon,
Xena - Xploring 4d ONE :rolleyes:
New 
