</tr> <tr> <td class="main"><font color="#ff0000"><?php echo sprintf(TEXT_AFTER_EMAIL_INSTRUCTIONS, $i); ?> </font></td> </tr> <tr> <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?> </td> </tr> <tr> <td align="center"><?php zen_restore_language($_POST['admin_language']); echo '<a href="' . zen_href_link(FILENAME_NEWSLETTERS, 'page=' . $_GET['page'] . '&nID=' . $_GET['nID']) . '">' . zen_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?> </td> </tr> <?php } else { ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NEWSLETTERS; ?>
$reviews = $db->Execute("select reviews_id\r\n from " . TABLE_REVIEWS . "\r\n where customers_id = '" . (int) $customers_id . "'"); while (!$reviews->EOF) { $db->Execute("delete from " . TABLE_REVIEWS_DESCRIPTION . "\r\n where reviews_id = '" . (int) $reviews->fields['reviews_id'] . "'"); $reviews->MoveNext(); } $db->Execute("delete from " . TABLE_REVIEWS . "\r\n where customers_id = '" . (int) $customers_id . "'"); } else { $db->Execute("update " . TABLE_REVIEWS . "\r\n set customers_id = null\r\n where customers_id = '" . (int) $customers_id . "'"); } $db->Execute("delete from " . TABLE_ADDRESS_BOOK . "\r\n where customers_id = '" . (int) $customers_id . "'"); $db->Execute("delete from " . TABLE_CUSTOMERS . "\r\n where customers_id = '" . (int) $customers_id . "'"); $db->Execute("delete from " . TABLE_CUSTOMERS_INFO . "\r\n where customers_info_id = '" . (int) $customers_id . "'"); $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET . "\r\n where customers_id = '" . (int) $customers_id . "'"); $db->Execute("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . "\r\n where customers_id = '" . (int) $customers_id . "'"); $db->Execute("delete from " . TABLE_WHOS_ONLINE . "\r\n where customer_id = '" . (int) $customers_id . "'"); zen_restore_language($admin_language); zen_redirect(zen_href_link(FILENAME_CUSTOMERS, zen_get_all_get_params(array('cID', 'action')), 'NONSSL')); break; default: // ->furikana if (FURIKANA_NESESSARY) { $customers = $db->Execute("select c.customers_id, c.customers_gender, c.customers_firstname,\r\n c.customers_lastname, c.customers_dob, c.customers_email_address,\r\n c.customers_firstname_kana, c.customers_lastname_kana,\r\n a.entry_company, a.entry_street_address, a.entry_suburb,\r\n a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id,\r\n a.entry_country_id, a.entry_telephone, a.entry_fax,\r\n c.customers_newsletter, c.customers_default_address_id,\r\n c.customers_email_format, c.customers_group_pricing,\r\n c.customers_authorization, c.customers_referral\r\n from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a\r\n on c.customers_default_address_id = a.address_book_id\r\n where a.customers_id = c.customers_id\r\n and c.customers_id = '" . (int) $customers_id . "'"); } else { $customers = $db->Execute("select c.customers_id, c.customers_gender, c.customers_firstname,\r\n c.customers_lastname, c.customers_dob, c.customers_email_address,\r\n a.entry_company, a.entry_street_address, a.entry_suburb,\r\n a.entry_postcode, a.entry_city, a.entry_state, a.entry_zone_id,\r\n a.entry_country_id, a.entry_telephone, a.entry_fax,\r\n c.customers_newsletter, c.customers_default_address_id,\r\n c.customers_email_format, c.customers_group_pricing,\r\n c.customers_authorization, c.customers_referral\r\n from " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a\r\n on c.customers_default_address_id = a.address_book_id\r\n where a.customers_id = c.customers_id\r\n and c.customers_id = '" . (int) $customers_id . "'"); } // <-furikana // -> set number_of_reviews in $cInfo (jp6) // $cInfo = new objectInfo($customers->fields); $reviews = $db->Execute("select count(*) as number_of_reviews\r\n from " . TABLE_REVIEWS . " where customers_id = '" . (int) $customers->fields['customers_id'] . "'"); $cInfo_array = array_merge($customers->fields, $reviews->fields); $cInfo = new objectInfo($cInfo_array);