Phew - wish I'd searched for this bug before spending 90 mins on it! Oh well, thanks for the note anyway.
Printable View
No prob! The latest version works like a charm though.. you can delete whichever cart you want to.. very useful:)
One bug, howver this is probably a ZC bug instead of a RCS bug. When a customer has a cart, but the customer is deleted.. the cart remains in the database.. and RCS pulls the data without a customer, resulting in stuff that can't be deleted through the admin panel. You can go back into the DB and drop it though, and its removed from RCS
Note: the code for deleting customer carts is in Zen Cart code for when a customer is deleted ...
PHP Code:
$db->Execute("delete from " . TABLE_CUSTOMERS_BASKET . "
where customers_id = '" . (int)$customers_id . "'");
$db->Execute("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . "
where customers_id = '" . (int)$customers_id . "'");
Hi Andrew,
I see you updated your RCS version on Feb 27, 2007. :thumbsup:
Can you confirm if the fixes employed in previous versions released by both Quentin and Brent Friar (and available in ZC Downloads area) are also implemented in your most recent RCS version available on your website?
http://www.zen-cart.com/index.php?ma...roducts_id=100
Thanks for the upgrades!
Woody
Hi Andrew-
I forgot to ask in my last post what is best method to indentify your recovercart version installed? My file dates get messed around all the time so not a good method to use to identify anything.
the current recover_cart_sales.php shows:
The ID string appears to remain the same since September even though several updates have been released since? Are there version numbers located somewhere else or some other method used to identify your versions? Thanks.Code:* @version $Id: recover_cart_sales.php 2.12 17.09.2006 22:25 Andrew Berezin $
Woody
Hm.. I use 1.3.7.. I was speaking from prior experience to the cart that was patched up to 1.3.7. I'm running on a fresh install now and I haven't had to do anything like that yet.. I'll give it a test to see if its still doing it. I checked the admin/customers.php file on my old site and its exactly the same one thats on my new site.. with this in the header comments:
Code:* @version $Id: customers.php 4280 2006-08-26 03:32:55Z drbyte $
So am I:
Lines 252-299Code:* @version $Id: customers.php 4280 2006-08-26 03:32:55Z drbyte $
Code:case 'deleteconfirm':
// demo active test
if (zen_admin_demo()) {
$_GET['action']= '';
$messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');
zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')), 'NONSSL'));
}
if (isset($_POST['delete_reviews']) && ($_POST['delete_reviews'] == 'on')) {
$reviews = $db->Execute("select reviews_id
from " . TABLE_REVIEWS . "
where customers_id = '" . (int)$customers_id . "'");
while (!$reviews->EOF) {
$db->Execute("delete from " . TABLE_REVIEWS_DESCRIPTION . "
where reviews_id = '" . (int)$reviews->fields['reviews_id'] . "'");
$reviews->MoveNext();
}
$db->Execute("delete from " . TABLE_REVIEWS . "
where customers_id = '" . (int)$customers_id . "'");
} else {
$db->Execute("update " . TABLE_REVIEWS . "
set customers_id = null
where customers_id = '" . (int)$customers_id . "'");
}
$db->Execute("delete from " . TABLE_ADDRESS_BOOK . "
where customers_id = '" . (int)$customers_id . "'");
$db->Execute("delete from " . TABLE_CUSTOMERS . "
where customers_id = '" . (int)$customers_id . "'");
$db->Execute("delete from " . TABLE_CUSTOMERS_INFO . "
where customers_info_id = '" . (int)$customers_id . "'");
$db->Execute("delete from " . TABLE_CUSTOMERS_BASKET . "
where customers_id = '" . (int)$customers_id . "'");
$db->Execute("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . "
where customers_id = '" . (int)$customers_id . "'");
$db->Execute("delete from " . TABLE_WHOS_ONLINE . "
where customer_id = '" . (int)$customers_id . "'");
zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')), 'NONSSL'));
break;
default:
did anyone get the email thing working cause i have tried it out and none seems to be recieving any emails when i try to contact them