Recover Cart [Support Thread]

Probably just a simple swith in this code:

PHP Code:

---

            // BEGIN OF ATTRIBUTE DB CODE
            $prodAttribs = ''; // DO NOT DELETE
            if (RCS_SHOW_ATTRIBUTES == 'true') {
                $attribrecs = $db->Execute("SELECT cba.products_id,
                                                                                     po.products_options_name poname,
                                                                                     pov.products_options_values_name povname
                                                                        FROM " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " cba,
                                                                                 " . TABLE_PRODUCTS_OPTIONS . " po,
                                                                                 " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov,
                                                                                 " . TABLE_LANGUAGES . " l
                                                                        WHERE cba.products_id ='" . (int)$basket->fields['products_id'] . "'
                                                                            AND cba.customers_id = " . $curcus . "
                                                                            AND po.products_options_id = cba.products_options_id
                                                                            AND pov.products_options_values_id = cba.products_options_value_id
                                                                            AND po.language_id =" . (int)$_SESSION['languages_id'] . "
                                                                            AND pov.language_id =" . (int)$_SESSION['languages_id']);
                $hasAttributes = false;
                if ($attribrecs->RecordCount() > 0){
                    $hasAttributes = true;
                    $prodAttribs = '<br />';
                    while (!$attribrecs->EOF){
                        $prodAttribs .= '<small><i> - ' . $attribrecs->fields['poname'] . ' ' . $attribrecs->fields['povname'] . '</i></small><br />';
                        $attribrecs->MoveNext();
                    }
                }
            }
            // END OF ATTRIBUTE DB CODE 


---

If I was any good with PHP I'm sure I'd see how to turn it off, but I amn't and I can't :)

See what happens if you change the references on $cline and $mline for:
$basket->fields['products_id']

to be:
(int)$basket->fields['products_id']

Well, I wasn't 100% sure what you meant about the $cline and $sline so I just replaced all eleven instances with the new (int)$basket->fields['products_id'] and it seems to have done the trick.... Thank you Ajeh, your genious is inspiring!

You really do not want to do that ...

Looking further at this file, I would first try a ...

Search of the file:
/your_secret_admin/recover_cart_sales.php

and search for:
$mline

and only on references to this $mline make the change ...

I am pretty sure if you do make this change in other places that you may actually break things on this program ...

Hi Ajeh,

I've taken your advice, gone back to the original file and replaced only the two instances with the $mline. It was only this line then:

PHP Code:

---

            $mline .= $basket->fields['customers_basket_quantity'] . ' x ' . $products->fields['name'] . "\n";
            $mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. (int)$basket->fields['products_id'] ) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. (int)$basket->fields['products_id'] ) . "</a></blockquote>\n\n";
            $basket->MoveNext(); 


---

Just need to run some tests and make sure it's still picking up on bailed carts.

OK, a quick test and it is no longer collecting data on bailed carts. So, changing that line breaks the mod.

well that is poopie ... :blink:

So you are saying the only change you made is on line 236:

Code:

---

            $mline .= '  <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. (int)$basket->fields['products_id']) . "</a></blockquote>\n\n";

---

and this broke it?

Quote:

---

Originally Posted by Ajeh

well that is poopie ... :blink:

So you are saying the only change you made is on line 236:

Code:

---

            $mline .= '  <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. (int)$basket->fields['products_id']) . "</a></blockquote>\n\n";

---

and this broke it?

---

Not quite. There are two instances of $basket->fields['products_id'] on line 236. I'd changed both of them.... I'm going to re-try with just one of them changed to (int)$basket->fields['products_id']

OK, re-tested with this (just one single change):

PHP Code:

---

$mline .= '   <blockquote><a href="' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. $basket->fields['products_id']) . '">' . zen_catalog_href_link(FILENAME_PRODUCT_INFO, 'products_id='. (int)$basket->fields['products_id']) . "</a></blockquote>\n\n"; 


---

It definitely breaks the mod. What it does is stop it from actually collecting balied cart data.

Weird ... I may have to break down and install this to see how it is really working ...