Jump to content
Latest News: (loading..)

honda4

Members
  • Content count

    13
  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
    Rene van Maanen
  1. Hi, I am planning to install the French Language Pack, but I am not sure where/wich to download. My site is running 2.2 rc2a Any help appreciated. Rene
  2. Recover Cart Sales

    I found this on a French site, it worked for me: Patch for stats_recover_cart_sales.php REPLACE: $orders_query_raw = "select o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where (o.customers_id = " . (int)$cid . ' OR o.customers_email_address like "' . $crec['customers_email_address'] .'" OR o.customers_name like "' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '") and o.orders_status > ' . RCS_PENDING_SALE_STATUS . ' and s.orders_status_id = o.orders_status and o.date_purchased >= "' . $inrec['dateadded'] . '" and ot.class = "ot_total"'; BY: $orders_query_raw = "select o.orders_id, o.customers_id, o.date_purchased, s.orders_status_name, ot.text as order_total, ot.value from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where (o.customers_id = " . (int)$cid . ' OR o.customers_email_address like "' . $crec['customers_email_address'] .'" OR o.customers_name like "' . $crec['customers_firstname'] . ' ' . $crec['customers_lastname'] . '") and orders_status NOT IN (' . implode(unserialize(RCS_PENDING_SALE_STATUS), ',') . ') and s.orders_status_id = o.orders_status and o.date_purchased >= "' . $inrec['dateadded'] . '" and ot.class = "ot_total"';
  3. Recover Cart Sales

    Hi, I have installed this contrib last week and it works to my full statisfaction. :) I have a question however. The installation is 2.2 RC2, with version 2.0a of this contrib. When I sent the e-mails, they arrive in plain text, showing the HTML tags. I can live with is, but this could look better. Is there a setting or patch or so? Cheers, Rene
  4. Bundled Products

    Kick...Anyone?
  5. Bundled Products

    I am currently preparing the install of this excellent module. Can somebody clear out the comment: ***IMPORTANT NOTE If you do not use the MSRP contribution then make sure that you delete the references to products_msrp from both queries above in the section under calculate total MSRP and weight. Waht exacly should the below code be changed to? Thanks so much, HONDA4. // BOF Bundled Products if ($HTTP_POST_VARS['products_bundle'] == "yes") { $to_avoid = bundle_avoid($products_id); $subprods = array(); $subprodqty = array(); tep_db_query("DELETE FROM " . TABLE_PRODUCTS_BUNDLES . " WHERE bundle_id = '" . (int)$products_id . "'"); for ($i=0, $n=100; $i<$n; $i++) { if (isset($HTTP_POST_VARS['subproduct_' . $i . '_qty']) && ((int)$HTTP_POST_VARS['subproduct_' . $i . '_qty'] > 0) && !in_array($HTTP_POST_VARS['subproduct_' . $i . '_id'], $to_avoid)) { if (in_array($HTTP_POST_VARS['subproduct_' . $i . '_id'], $subprods)) { $subprodqty[$HTTP_POST_VARS['subproduct_' . $i . '_id']] += (int)$HTTP_POST_VARS['subproduct_' . $i . '_qty']; tep_db_query('update ' . TABLE_PRODUCTS_BUNDLES . ' set subproduct_qty = ' . (int)$subprodqty[$HTTP_POST_VARS['subproduct_' . $i . '_id']] . ' where bundle_id = ' . (int)$products_id . ' and subproduct_id = ' . (int)$HTTP_POST_VARS['subproduct_' . $i . '_id']); } else { $subprods[] = $HTTP_POST_VARS['subproduct_' . $i . '_id']; $subprodqty[$HTTP_POST_VARS['subproduct_' . $i . '_id']] = (int)$HTTP_POST_VARS['subproduct_' . $i . '_qty']; tep_db_query("INSERT INTO " . TABLE_PRODUCTS_BUNDLES . " (bundle_id, subproduct_id, subproduct_qty) VALUES ('" . (int)$products_id . "', '" . (int)$HTTP_POST_VARS['subproduct_' . $i . '_id'] . "', '" . (int)$HTTP_POST_VARS['subproduct_' . $i . '_qty'] . "')"); } } } if (empty($subprods)) { // not a bundle if no subproducts set tep_db_query('update ' . TABLE_PRODUCTS . ' set products_bundle = "no" where products_id = ' . (int)$products_id); } else { // calculate total MSRP and weight from subproducts $msrp = 0; $weight = 0; foreach ($subprodqty as $id => $qty) { $subprod_query = tep_db_query('select products_msrp, products_weight from ' . TABLE_PRODUCTS . ' where products_id = ' . (int)$id); $subprod = tep_db_fetch_array($subprod_query); $msrp += ($subprod['products_msrp'] * $qty); $weight += ($subprod['products_weight'] * $qty); } tep_db_query('update ' . TABLE_PRODUCTS . ' set products_quantity = 1, products_msrp = "' . tep_db_input($msrp) . '", products_weight = "' . tep_db_input($weight) . '" where products_id = ' . (int)$products_id); } } // EOF Bundled Products
  6. Claudia, excellent Contrib! I was a little hesitating installing the Margin Reports contrib, since it has so much code to change. Everything just works, saves me a lot of time, especially dec 31st/jan 1st. Groeten uit Apeldoorn. Rene
×