  |
14 | 14 | | Resize Images To Round Numbers |
| |
15 | 15 | | Use The Correct Country Name Value When Formatting Addresses |
| |
16 | 16 | | Prevent The Session ID Being Passed In Tell-A-Friend E-Mails |
 |
| 17 | + | Properly Remove Deleted Products That Exist In Shopping Carts |
|
17 | 18 | | |
| |
18 | 19 | | ## Update 051113 (13th November 2005) |
| |
19 | 20 | | |
| |
|
|
 |
… |
|
305 | 306 | | |
| |
306 | 307 | | $email_body .= sprintf(TEXT_EMAIL_LINK, tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $HTTP_GET_VARS['products_id'], 'NONSSL', false)) . "\n\n" . |
| |
307 | 308 | | |
|
| 309 | + | ------------------------------------------------------------------------------ |
| |
| 310 | + | Properly Remove Deleted Products That Exist In Shopping Carts |
| |
| 311 | + | http://www.oscommerce.com/community/bugs,3193 |
| |
| 312 | + | http://svn.oscommerce.com/trac/changeset/717 |
| |
| 313 | + | ------------------------------------------------------------------------------ |
| |
| 314 | + | |
| |
| 315 | + | Problem: |
| |
| 316 | + | |
| |
| 317 | + | Deleting products via the Administration Tool would not successfully remove the product from customers shopping carts if the product had attributes. |
| |
| 318 | + | |
| |
| 319 | + | Solution: |
| |
| 320 | + | |
| |
| 321 | + | The following lines must be replaced in catalog/admin/includes/functions/general.php: |
| |
| 322 | + | |
| |
| 323 | + | Lines 900-901, from: |
| |
| 324 | + | |
| |
| 325 | + | tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where products_id = '" . (int)$product_id . "'"); |
| |
| 326 | + | tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where products_id = '" . (int)$product_id . "'"); |
| |
| 327 | + | |
| |
| 328 | + | to: |
| |
| 329 | + | |
| |
| 330 | + | tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where products_id = '" . (int)$product_id . "' or products_id like '" . (int)$product_id . "{'"); |
| |
| 331 | + | tep_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where products_id = '" . (int)$product_id . "' or products_id like '" . (int)$product_id . "{'"); |
| |
| 332 | + | |
|
308 | 333 | | ########################### |
| |
309 | 334 | | ###### Update 051113 ###### |
| |
310 | 335 | | ########################### |