Recover Cart [Support Thread]

[limelites]

Probably just a simple swith in this 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 :)

[Ajeh]

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

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

[limelites]

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!

[Ajeh]

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 ...

[limelites]

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:

            $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.

[limelites]

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

[Ajeh]

well that is poopie ...

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

            $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?

[limelites]

well that is poopie ...

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

            $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']

[limelites]

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

$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.

[Ajeh]

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