ReneRe

Worked like a charm, thanks. I tryed to add my price breaks and added products_price1 .. price4 to the sql query and the array and changed if(VAT) { $withoutvat=sprintf("%01.".DIGITS_AFTER_DOT."f",$data_array[9]); $vatprice=sprintf("%01.".DIGITS_AFTER_DOT."f",((VAT/100)*$data_array[9])+$data_array[9]); $vatspecialsprice=sprintf("%01.".DIGITS_AFTER_DOT."f",((VAT/100)*$data_array[8])+$data_array[8]); } if(CURRENCY_RIGHT_OR_LEFT == 'R') { $this->MultiCell(180-$data_array[0],5,$vatprice.CURRENCY."\t".$withoutvat.CURRENCY." (exkl. MwSt.)\t\t\t".$vatspecialsprice.CURRENCY,1,'L',1); } to show prices withput (price break prices should follow) but no output?! only the normal $vatprice appears. anybody willing to help me? :/ thanks!

Hello, since intalling price break per product my sub-total showing up in shopping_cart.php keeps being 0,00 ?. the individual price of a product is displayed correctly -- just sub total is not calculated (and shipping weight isn't either!) here goes the function calculate of catalog/classes/shopping_cart.php: function calculate() { $this->total = 0; $this->weight = 0; if (!is_array($this->contents)) return 0; //price break $pf = new PriceFormatter; //eof price break reset($this->contents); while (list($products_id, ) = each($this->contents)) { $qty = $this->contents[$products_id]['qty']; // products price -- fast komplett ver?ndert durch price break contrib -> classes/PriceFormatter.php if ($product = $pf->loadProduct($products_id)){ $prid = $product['products_id']; $products_tax = tep_get_tax_rate($product['products_tax_class_id']); $products_price = $pf->computePrice($qty); $products_weight = $product['products_weight']; $this->total += tep_add_tax($products_price, $products_tax) * $qty; $this->weight += ($qty * $products_weight); } // attributes price if (isset($this->contents[$products_id]['attributes'])) { reset($this->contents[$products_id]['attributes']); while (list($option, $value) = each($this->contents[$products_id]['attributes'])) { $attribute_price_query = tep_db_query("select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$prid . "' and options_id = '" . (int)$option . "' and options_values_id = '" . (int)$value . "'"); $attribute_price = tep_db_fetch_array($attribute_price_query); if ($attribute_price['price_prefix'] == '+') { $this->total += $qty * tep_add_tax($attribute_price['options_values_price'], $products_tax); } else { $this->total -= $qty * tep_add_tax($attribute_price['options_values_price'], $products_tax); } } } } } and my PriceFormatter.php <?php /* $Id: PriceFormatter.php,v 1.6 2003/06/25 08:29:26 petri Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ /* PriceFormatter.php - module to support quantity pricing Created 2003, Beezle Software based on some code mods by WasaLab Oy (Thanks!) */ class PriceFormatter { var $hiPrice; var $lowPrice; var $quantity; var $hasQuantityPrice; function PriceFormatter($prices=NULL) { $this->productsID = -1; $this->hasQuantityPrice=false; $this->hasSpecialPrice=false; $this->hiPrice=-1; $this->lowPrice=-1; for ($i=1; $i<=4; $i++){ $this->quantity[$i] = -1; $this->prices[$i] = -1; } $this->thePrice = -1; $this->specialPrice = -1; $this->qtyBlocks = 1; if($prices) $this->parse($prices); } function encode() { $str = $this->productsID . ":" . (($this->hasQuantityPrice == true) ? "1" : "0") . ":" . (($this->hasSpecialPrice == true) ? "1" : "0") . ":" . $this->quantity[1] . ":" . $this->quantity[2] . ":" . $this->quantity[3] . ":" . $this->quantity[4] . ":" . $this->price[1] . ":" . $this->price[2] . ":" . $this->price[3] . ":" . $this->price[4] . ":" . $this->thePrice . ":" . $this->specialPrice . ":" . $this->qtyBlocks . ":" . $this->taxClass; return $str; } function decode($str) { list($this->productsID, $this->hasQuantityPrice, $this->hasSpecialPrice, $this->quantity[1], $this->quantity[2], $this->quantity[3], $this->quantity[4], $this->price[1], $this->price[2], $this->price[3], $this->price[4], $this->thePrice, $this->specialPrice, $this->qtyBlocks, $this->taxClass) = explode(":", $str); $this->hasQuantityPrice = (($this->hasQuantityPrice == 1) ? true : false); $this->hasSpecialPrice = (($this->hasSpecialPrice == 1) ? true : false); } function parse($prices) { $this->productsID = $prices['products_id']; $this->hasQuantityPrice=false; $this->hasSpecialPrice=false; $this->quantity[1]=$prices['products_price1_qty']; $this->quantity[2]=$prices['products_price2_qty']; $this->quantity[3]=$prices['products_price3_qty']; $this->quantity[4]=$prices['products_price4_qty']; $this->thePrice=$prices['products_price']; $this->specialPrice=$prices['specials_new_products_price']; $this->hasSpecialPrice=tep_not_null($this->specialPrice); $this->price[1]=$prices['products_price1']; $this->price[2]=$prices['products_price2']; $this->price[3]=$prices['products_price3']; $this->price[4]=$prices['products_price4']; $this->qtyBlocks=$prices['products_qty_blocks']; $this->taxClass=$prices['products_tax_class_id']; if ($this->quantity[1] > 0) { $this->hasQuantityPrice = true; $this->hiPrice = $this->thePrice; $this->lowPrice = $this->thePrice; for($i=1; $i<=4; $i++) { if($this->quantity[$i] > 0) { if ($this->price[$i] > $this->hiPrice) { $this->hiPrice = $this->price[$i]; } if ($this->price[$i] < $this->lowPrice) { $this->lowPrice = $this->price[$i]; } } } } } function loadProduct($product_id, $language_id=1) { $sql="select pd.products_name, p.products_model, p.products_image, p.products_id," . " p.manufacturers_id, p.products_price, p.products_weight," . " p.products_price1,p.products_price2,p.products_price3,p.products_price4," . " p.products_price1_qty,p.products_price2_qty,p.products_price3_qty,p.products_pri ce4_qty," . " p.products_qty_blocks," . " 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" . " from " . TABLE_PRODUCTS_DESCRIPTION . " pd," . " " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id," . " " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id" . " where p.products_status = '1'" . " and p.products_id = '" . (int)$product_id . "'" . " and pd.products_id = '" . (int)$product_id . "'" . " and pd.language_id = '". (int)$language_id ."'"; $product_info_query = tep_db_query($sql); $product_info = tep_db_fetch_array($product_info_query); $this->parse($product_info); return $product_info; } function computePrice($qty) { $qty = $this->adjustQty($qty); $price = $this->thePrice; if ($this->hasSpecialPrice == true) $price = $this->specialPrice; else for ($i=1; $i<=4; $i++) if (($this->quantity[$i] > 0) && ($qty >= $this->quantity[$i])) $price = $this->price[$i]; return $price; } function adjustQty($qty) { // Force QTY_BLOCKS granularity $qb = $this->getQtyBlocks(); if ($qty < 1) $qty = 1; if ($qb >= 1) { if ($qty < $qb) $qty = $qb; if (($qty % $qb) != 0) $qty += ($qb - ($qty % $qb)); } return $qty; } function getQtyBlocks() { return $this->qtyBlocks; } function getPrice() { return $this->thePrice; } function getLowPrice() { return $this->lowPrice; } function getHiPrice() { return $this->hiPrice; } function hasSpecialPrice() { return $this->hasSpecialPrice; } function hasQuantityPrice() { return $this->hasQuantityPrice; } function getPriceString($style='productPriceInBox') { global $currencies; if ($this->hasSpecialPrice == true) { $lc_text = ' <s>' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass)) . '</span> '; } else { // If you want to change the format of the price/quantity table // displayed on the product information page, here is where you do it. if($this->hasQuantityPrice == true) { $lc_text = '<table align="top" border="0" cellspacing="0" cellpadding="0">'; $lc_text .= '<tr><td align="center" class=' . $style. ' colspan="2">' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . '</td></tr>'; $style = 'productPriceInProdInfo'; for($i=1; $i<=4; $i++) { if($this->quantity[$i] > 0) { $lc_text .= '<tr><td class='.$style.'>ab ' . $this->quantity[$i] .' St?ck je </td><td class='.$style.'>' . $currencies->display_price($this->price[$i], tep_get_tax_rate($this->taxClass)) .'</td></tr>'; } } $lc_text .= '</table>'; } else { $lc_text = ' ' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . ' '; } } return $lc_text; } function getPriceStringShort() { global $currencies; if ($this->hasSpecialPrice == true) { $lc_text = ' <s>' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($this->specialPrice, tep_get_tax_rate($this->taxClass)) . '</span> '; } else { if($this->hasQuantityPrice == true) { $lc_text = ' ' . $currencies->display_price($this->lowPrice, tep_get_tax_rate($this->taxClass)) . ' - ' . $currencies->display_price($this->hiPrice, tep_get_tax_rate($this->taxClass)) . ' '; } else { $lc_text = ' ' . $currencies->display_price($this->thePrice, tep_get_tax_rate($this->taxClass)) . ' '; } } return $lc_text; } } ?> I haven't been able to find a solution - your help would be really appreciated! Thanks Ren?

Looking for the same. Any solutions yet?

Add this in shopping_cart.php to link back to the master product instead of a slave! ## after $info_box_contents[$cur_row][] = array('align' => 'center', 'params' => 'class="productListing-data" valign="top"', 'text' => tep_draw_checkbox_field('cart_delete[]', $products[$i]['id'])); ##add this // Ren? Reineke -- link back to master product on shopping cart $master_prod = tep_db_query("select products_master, products_master_status from " . TABLE_PRODUCTS . " where products_id = '" . $products[$i]['id'] . "'"); $master_prod_values = tep_db_fetch_array($master_prod); if (($master_prod_values['products_master_status'] == 0) && ($master_prod_values['products_master'] != 0)) { $products[$i]['id'] = $master_prod_values['products_master']; } // Ren? Reineke MaSTER Mod end creates an extra query. I'm sure it can be optimized but no time now.

Try to replace function add_slave in catalog/includes/application_top.php with the following: ? ? ?//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 ? ? ? Worked for me!

Got it already running. add_slave was infact broken but don't know why. Used a foreach loop und worked after some tries like a charm :) Sorry for bothering!

I have to add something to my last post. I believe that something in application_top.php might go wrong concerning "case: add_slave" That's what I have got: ? ? ?//Master Products ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?// customer adds multiple products from the master_listing page ? ? ?case 'add_slave' : ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?while ( list( $key, $val ) = each( $HTTP_POST_VARS ) ) { ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? if (substr($key,0,11) == "Qty_ProdId_") { ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? $prodId = substr($key,11); ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? $qty = $val; ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? if ($qty <= 0 ) continue; ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? $cart->add_cart($prodId, $cart->get_quantity(tep_get_uprid($prodId, $HTTP_POST_VARS['id']))+($qty), $HTTP_POST_VARS['id']); ? ? echo("$prodId<br>" . $HTTP_POST_VARS['id'] . "<br>" . $HTTP_POST_VARS['id'] . "<br><p>"); ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?} ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?} ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?die; ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?break; ? ? ?//Master Products EOF Trying to locate the source of the error I added a die() function, which gets executed (result: add_slave is called!) but nothing is returned by my echo function (maybe while(...) not workin') a part of the form source follows (product_info.php/master_listing.php) <!-- Master Products //--> ? ? ? ? ? ? ? ? ? ? ?<td width="10"><img src="images/pixel_trans.gif" border="0" alt="" width="10" height="1"></td> ? ? ? ? ? ? ?</tr> ? ? ? ? ? ?</table></td> ? ? ? ? ?</tr> ? ? ? ?</table></td> ? ? ?</tr> ? ? ? ? ? ?<tr> ? ? ? ?<td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="10"></td> ? ? ?</tr> ? <tr> ? ?<td align="left" class="main"> *Bitte wählen Sie unten die gewünschte Anzahl aus.</td> ? </tr> ? ? ?<tr> ? ? ? ?<td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="10"></td> ? ? ?</tr> ? ? <tr> ? ?<td><form name="buy_now_" method="post" action="http://www.hair-xperts.de/product_info.php/cPath/21/products_id/32/sort/3a/[b]action/add_slave[/b]"><form name="buy_now_" method="post" action="http://www.hair-xperts.de/product_info.php/cPath/21/products_id/32/sort/3a/action/add_slave"><table border="0" width="100%" cellspacing="0" cellpadding="2" class="productListing"> ?<tr> ? ?<td class="productListing-heading"> <a href="http://www.hair-xperts.de/product_info.php/cPath/21/products_id/32/page/1/sort/1a" title="Sortierung der Artikel ist aufsteigend nach Modell" class="productListing-heading">Modell</a> </td> ? ?<td align="center" class="productListing-heading"> Beschreibung </td> ? ?<td class="productListing-heading"> <a href="http://www.hair-xperts.de/product_info.php/cPath/21/products_id/32/page/1/sort/3d" title="Sortierung der Artikel ist absteigend nach Name" class="productListing-heading">Name+</a> </td> ? ?<td align="right" class="productListing-heading"> <a href="http://www.hair-xperts.de/product_info.php/cPath/21/products_id/32/page/1/sort/4a" title="Sortierung der Artikel ist aufsteigend nach Preis" class="productListing-heading">Preis</a> </td> ? ?<td align="center" class="productListing-heading"> Jetzt kaufen! </td> ?</tr> ?<tr class="productListing-odd"> ? ?<td class="productListing-data"> 18-CS-1000 </td> ? ?<td class="productListing-data"> Dies ist die 1000ml version des prodkt </td> ? ?<td class="productListing-data"> 1.8 Color Saver Shampoo 1000 ml</a> </td> ? ?<td align="right" class="productListing-data"> 127,60? </td> ? ?<td align="center" class="productListing-data"><select name="Qty_ProdId_33" value="0" class="main" style="width: 40px"> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <option value="0">0</option> ? ? ? ? ? ? ? ? ? ? ? ? ?<option value="1">1</option> ? ? ? ? ? <option value="2">2</option> ? ? ? ? ? ? ? ? ? ? ? ? <option value="3">3</option> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <option value="4">4</option> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <option value="5">5</option> ? ? ? ? ? <option value="6">6</option> ? ? ? ? ? ? ? ? ? <option value="7">7</option> ? ? ? ? ? <option value="8">8</option> ? ? ? ? ? ? ? ? ? <option value="9">9</option> ? ? ? ? ? <option value="10">10</option> ? ? ? ? ? ? ? ? ? <option value="11">11</option> ? ? ? ? ? <option value="12">12</option> ? ? ? ? ? ? ? ? ? <option value="13">13</option> ? ? ? ? ? <option value="14">14</option> ? ? ? ? ? ? ? ? ? ? <option value="15">15</option> ? ? ? ? ? ? <option value="16">16</option> ? ? ? ? ? ? ? ? ? <option value="17">17</option> ? ? ? ? ? <option value="18">18</option> ? ? ? ? ? ? ? ? ? <option value="19">19</option> ? ? ? ? ? ? ? ? ?<option value="20">20</option> ? ? ? ? ? ? ? ? ? </select></td> ?</tr> ?<tr class="productListing-even"> ? ?<td class="productListing-data"> 18-CS-500 </td> ? ?<td class="productListing-data"> 5500 </td> ? ?<td class="productListing-data"> 500 ml</a> </td> ? ?<td align="right" class="productListing-data"> 63,80? </td> ? ?<td align="center" class="productListing-data"><select name="Qty_ProdId_34" value="0" class="main" style="width: 40px"> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <option value="0">0</option> ? ? ? ? ? ? ? ? ? ? ? ? ?<option value="1">1</option> ? ? ? ? ? <option value="2">2</option> ? ? ? ? ? ? ? ? ? ? ? ? <option value="3">3</option> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <option value="4">4</option> ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? <option value="5">5</option> ? ? ? ? ? <option value="6">6</option> ? ? ? ? ? ? ? ? ? <option value="7">7</option> ? ? ? ? ? <option value="8">8</option> ? ? ? ? ? ? ? ? ? <option value="9">9</option> ? ? ? ? ? <option value="10">10</option> ? ? ? ? ? ? ? ? ? <option value="11">11</option> ? ? ? ? ? <option value="12">12</option> ? ? ? ? ? ? ? ? ? <option value="13">13</option> ? ? ? ? ? <option value="14">14</option> ? ? ? ? ? ? ? ? ? ? <option value="15">15</option> ? ? ? ? ? ? <option value="16">16</option> ? ? ? ? ? ? ? ? ? <option value="17">17</option> ? ? ? ? ? <option value="18">18</option> ? ? ? ? ? ? ? ? ? <option value="19">19</option> ? ? ? ? ? ? ? ? ?<option value="20">20</option> ? ? ? ? ? ? ? ? ? </select></td> ?</tr> </table> ? ? <table border="0" width="100%" cellspacing="0" cellpadding="2"> ? ? ?<tr> ? ? ? ?<td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="10"></td> ? ? ?</tr> ? ? ?<tr> ? ? ? ?<td class="main" align="right"><input type="hidden" name="products_id" value="32"><input type="image" src="includes/languages/german/images/buttons/button_in_cart.gif" border="0" alt="In den Warenkorb" title=" In den Warenkorb "></form></td> ? ? </tr> ? ? ?<tr> ? ? ? ?<td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="10"></td> ? ? ?</tr> ? ? </table> ? ? ? ? <table border="0" width="100%" cellspacing="0" cellpadding="2"> ? ? ? ? ? ? ? <tr> ? ? ? ?<td class="smallText">angezeigte Produkte: <b>1</b> bis <b>2</b> (von <b>2</b> insgesamt)</td> ? ? ? ?<td class="smallText" align="right">Seiten: <b>1</b> </td> ? ? </tr> ? ?</table> ? ? ?<tr> ? ? ? ?<td><img src="images/pixel_trans.gif" border="0" alt="" width="100%" height="10"></td> ? ? ?</tr> </td> ? </tr> ? <!-- Master Products EOF //-->

Greetz, I could finally merge the files more or less but now I'm stuck again. http://www.hair-xperts.de/product_info.php/products_id/32 I am able to chose the amount of products but clicking on buy means -> 'empty cart' :( Can't solve that. Anybody able to help? Thanks Ren?

Hello, I'm desperatly trying to combine Master Products with UltraPics/HTMLArea but got into serious problems while trying to join the changes in categories.php. This is a part of my categories.php with UltraPics installed: ? ? ?case 'update_product': ? ? ? ?if (isset($HTTP_POST_VARS['edit_x']) || isset($HTTP_POST_VARS['edit_y'])) { ? ? ? ? ?$action = 'new_product'; ? ? ? ?} else { ? ? ? ? // BOF MaxiDVD: Modified For Ultimate Images Pack! ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_med'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_med']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_lrg'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_lrg']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_sm_1'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_sm_1']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_xl_1'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_xl_1']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_sm_2'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_sm_2']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_xl_2'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_xl_2']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_sm_3'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_sm_3']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_xl_3'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_xl_3']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_sm_4'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_sm_4']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_xl_4'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_xl_4']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_sm_5'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_sm_5']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_xl_5'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_xl_5']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_sm_6'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_sm_6']); ? ? ? ? ? ?} ? ? ? ? ? ?if ($HTTP_POST_VARS['delete_image_xl_6'] == 'yes') { ? ? ? ? ? ? ? ?unlink(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['products_previous_image_xl_6']); ? ? ? ? ? ?} // EOF MaxiDVD: Modified For Ultimate Images Pack! ? ? ? ? ?if (isset($HTTP_GET_VARS['pID'])) $products_id = tep_db_prepare_input($HTTP_GET_VARS['pID']); ? ? ? ? ?$products_date_available = tep_db_prepare_input($HTTP_POST_VARS['products_date_available']); ? ? ? ? ?$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null'; ? ? ? ? ?$sql_data_array = array('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_date_available' => $products_date_available, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_weight' => tep_db_prepare_input($HTTP_POST_VARS['products_weight']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id'])); // BOF MaxiDVD: Modified For Ultimate Images Pack! ? ? ? if (($HTTP_POST_VARS['unlink_image'] == 'yes') or ($HTTP_POST_VARS['delete_image'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image'] = ''; ? ? ? ? ? } else { ? ? ? ? if (isset($HTTP_POST_VARS['products_image']) && tep_not_null($HTTP_POST_VARS['products_image']) && ($HTTP_POST_VARS['products_image'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image'] = tep_db_prepare_input($HTTP_POST_VARS['products_image']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_med'] == 'yes') or ($HTTP_POST_VARS['delete_image_med'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_med'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_med']) && tep_not_null($HTTP_POST_VARS['products_image_med']) && ($HTTP_POST_VARS['products_image_med'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_med'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_med']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_lrg'] == 'yes') or ($HTTP_POST_VARS['delete_image_lrg'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_lrg'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_lrg']) && tep_not_null($HTTP_POST_VARS['products_image_lrg']) && ($HTTP_POST_VARS['products_image_lrg'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_lrg'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_lrg']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_sm_1'] == 'yes') or ($HTTP_POST_VARS['delete_image_sm_1'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_1'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_sm_1']) && tep_not_null($HTTP_POST_VARS['products_image_sm_1']) && ($HTTP_POST_VARS['products_image_sm_1'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_1'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_sm_1']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_xl_1'] == 'yes') or ($HTTP_POST_VARS['delete_image_xl_1'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_1'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_xl_1']) && tep_not_null($HTTP_POST_VARS['products_image_xl_1']) && ($HTTP_POST_VARS['products_image_xl_1'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_1'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_xl_1']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_sm_2'] == 'yes') or ($HTTP_POST_VARS['delete_image_sm_2'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_2'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_sm_2']) && tep_not_null($HTTP_POST_VARS['products_image_sm_2']) && ($HTTP_POST_VARS['products_image_sm_2'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_2'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_sm_2']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_xl_2'] == 'yes') or ($HTTP_POST_VARS['delete_image_xl_2'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_2'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_xl_2']) && tep_not_null($HTTP_POST_VARS['products_image_xl_2']) && ($HTTP_POST_VARS['products_image_xl_2'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_2'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_xl_2']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_sm_3'] == 'yes') or ($HTTP_POST_VARS['delete_image_sm_3'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_3'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_sm_3']) && tep_not_null($HTTP_POST_VARS['products_image_sm_3']) && ($HTTP_POST_VARS['products_image_sm_3'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_3'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_sm_3']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_xl_3'] == 'yes') or ($HTTP_POST_VARS['delete_image_xl_3'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_3'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_xl_3']) && tep_not_null($HTTP_POST_VARS['products_image_xl_3']) && ($HTTP_POST_VARS['products_image_xl_3'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_3'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_xl_3']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_sm_4'] == 'yes') or ($HTTP_POST_VARS['delete_image_sm_4'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_4'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_sm_4']) && tep_not_null($HTTP_POST_VARS['products_image_sm_4']) && ($HTTP_POST_VARS['products_image_sm_4'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_4'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_sm_4']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_xl_4'] == 'yes') or ($HTTP_POST_VARS['delete_image_xl_4'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_4'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_xl_4']) && tep_not_null($HTTP_POST_VARS['products_image_xl_4']) && ($HTTP_POST_VARS['products_image_xl_4'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_4'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_xl_4']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_sm_5'] == 'yes') or ($HTTP_POST_VARS['delete_image_sm_5'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_5'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_sm_5']) && tep_not_null($HTTP_POST_VARS['products_image_sm_5']) && ($HTTP_POST_VARS['products_image_sm_5'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_5'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_sm_5']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_xl_5'] == 'yes') or ($HTTP_POST_VARS['delete_image_xl_5'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_5'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_xl_5']) && tep_not_null($HTTP_POST_VARS['products_image_xl_5']) && ($HTTP_POST_VARS['products_image_xl_5'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_5'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_xl_5']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_sm_6'] == 'yes') or ($HTTP_POST_VARS['delete_image_sm_6'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_6'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_sm_6']) && tep_not_null($HTTP_POST_VARS['products_image_sm_6']) && ($HTTP_POST_VARS['products_image_sm_6'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_sm_6'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_sm_6']); ? ? ? ? ?} ? ? ? ? ?} ? ? ? if (($HTTP_POST_VARS['unlink_image_xl_6'] == 'yes') or ($HTTP_POST_VARS['delete_image_xl_6'] == 'yes')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_6'] = ''; ? ? ? ? ? } else { ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image_xl_6']) && tep_not_null($HTTP_POST_VARS['products_image_xl_6']) && ($HTTP_POST_VARS['products_image_xl_6'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image_xl_6'] = tep_db_prepare_input($HTTP_POST_VARS['products_image_xl_6']); ? ? ? ? ?} ? ? ? ? ?} // EOF MaxiDVD: Modified For Ultimate Images Pack! ? ? ? ? ?if ($action == 'insert_product') { ? ? ? ? ? ?$insert_sql_data = array('products_date_added' => 'now()'); ? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data); ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS, $sql_data_array); ? ? ? ? ? ?$products_id = tep_db_insert_id(); ? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$current_category_id . "')"); ? ? ? ? ?} elseif ($action == 'update_product') { ? ? ? ? ? ?$update_sql_data = array('products_last_modified' => 'now()'); ? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $update_sql_data); ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'"); ? ? ? ? ?} ? ? ? ? ?$languages = tep_get_languages(); ? ? ? ? ?for ($i=0, $n=sizeof($languages); $i<$n; $i++) { ? ? ? ? ? ?$language_id = $languages[$i]['id']; ? ? ? ? ? ?$sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id])); ? ? ? ? ? ?if ($action == 'insert_product') { ? ? ? ? ? ? ?$insert_sql_data = array('products_id' => $products_id, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'language_id' => $language_id); ? ? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data); ? ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array); ? ? ? ? ? ?} elseif ($action == 'update_product') { ? ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "' and language_id = '" . (int)$language_id . "'"); ? ? ? ? ? ?} ? ? ? ? ?} ? ? ? ? ?if (USE_CACHE == 'true') { ? ? ? ? ? ?tep_reset_cache_block('categories'); ? ? ? ? ? ?tep_reset_cache_block('also_purchased'); ? ? ? ? ?} ? ? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products_id)); ? ? ? ?} ? ? ? ?break; ################### ################### and I'm unable to join it with Master Products version, which goes like that: ? ? ?case 'update_product': ? ? ? ?if (isset($HTTP_POST_VARS['edit_x']) || isset($HTTP_POST_VARS['edit_y'])) { ? ? ? ? ?$action = 'new_product'; ? ? ? ?} else { ? ? ? ? ?if (isset($HTTP_GET_VARS['pID'])) $products_id = tep_db_prepare_input($HTTP_GET_VARS['pID']); ? ? ? ? ?$products_date_available = tep_db_prepare_input($HTTP_POST_VARS['products_date_available']); ? ? ? ? ?$products_date_available = (date('Y-m-d') < $products_date_available) ? $products_date_available : 'null'; ? ? ? ? ?$sql_data_array = array('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_date_available' => $products_date_available, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_weight' => tep_db_prepare_input($HTTP_POST_VARS['products_weight']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']), // Master Products ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_listing_status' => tep_db_prepare_input($HTTP_POST_VARS['products_listing_status']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id']), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_master' => tep_db_prepare_input($HTTP_POST_VARS['products_master'])); // Master Products EOF ? ? ? ? ?if (isset($HTTP_POST_VARS['products_image']) && tep_not_null($HTTP_POST_VARS['products_image']) && ($HTTP_POST_VARS['products_image'] != 'none')) { ? ? ? ? ? ?$sql_data_array['products_image'] = tep_db_prepare_input($HTTP_POST_VARS['products_image']); ? ? ? ? ?} ? ? ? ? ?if ($action == 'insert_product') { ? ? ? ? ? ?$insert_sql_data = array('products_date_added' => 'now()'); ? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data); ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS, $sql_data_array); ? ? ? ? ? ?$products_id = tep_db_insert_id(); ? ? ? ? ? ?tep_db_query("insert into " . TABLE_PRODUCTS_TO_CATEGORIES . " (products_id, categories_id) values ('" . (int)$products_id . "', '" . (int)$current_category_id . "')"); ? ? ? ? ?} elseif ($action == 'update_product') { ? ? ? ? ? ?$update_sql_data = array('products_last_modified' => 'now()'); ? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $update_sql_data); ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'"); ? ? ? ? ?} ? ? ? ? ?$languages = tep_get_languages(); ? ? ? ? ?for ($i=0, $n=sizeof($languages); $i<$n; $i++) { ? ? ? ? ? ?$language_id = $languages[$i]['id']; ? ? ? ? ? ?$sql_data_array = array('products_name' => tep_db_prepare_input($HTTP_POST_VARS['products_name'][$language_id]), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_description' => tep_db_prepare_input($HTTP_POST_VARS['products_description'][$language_id]), ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?'products_url' => tep_db_prepare_input($HTTP_POST_VARS['products_url'][$language_id])); ? ? ? ? ? ?if ($action == 'insert_product') { ? ? ? ? ? ? ?$insert_sql_data = array('products_id' => $products_id, ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 'language_id' => $language_id); ? ? ? ? ? ? ?$sql_data_array = array_merge($sql_data_array, $insert_sql_data); ? ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array); ? ? ? ? ? ?} elseif ($action == 'update_product') { ? ? ? ? ? ? ?tep_db_perform(TABLE_PRODUCTS_DESCRIPTION, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "' and language_id = '" . (int)$language_id . "'"); ? ? ? ? ? ?} ? ? ? ? ?} ? ? ? ? ?if (USE_CACHE == 'true') { ? ? ? ? ? ?tep_reset_cache_block('categories'); ? ? ? ? ? ?tep_reset_cache_block('also_purchased'); ? ? ? ? ?} ? ? ? ? ?tep_redirect(tep_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $products_id)); ? ? ? ?} ? ? ? ?break; //Master Products ? ? ? ? I seriously need a solution because I need to be able to set different product weights and ids ! :(( Please give me a hand.. Greetz from Germany Ren? Reineke