function _process()
{
global $messageStack, $osC_Database, $osC_Customer, $Qglobal;
$updated = false;
if (isset($_POST['product_global']) && is_numeric($_POST['product_global'])) {
$product_global = $_POST['product_global'];
} else {
$product_global = '0';
}
if (isset($_POST['products'])) {
(array) ($products = $_POST['products']);
} else {
$products = array();
}
if ($product_global != $Qglobal->valueInt('global_product_notifications')) {
$product_global = $Qglobal->valueInt('global_product_notifications') == '1' ? '0' : '1';
$Qupdate = $osC_Database->query('update :table_customers_info set global_product_notifications = :global_product_notifications where customers_info_id = :customers_info_id');
$Qupdate->bindTable(':table_customers_info', TABLE_CUSTOMERS_INFO);
$Qupdate->bindInt(':global_product_notifications', $product_global);
$Qupdate->bindInt(':customers_info_id', $osC_Customer->id);
$Qupdate->execute();
if ($Qupdate->affectedRows() == 1) {
$updated = true;
}
} elseif (sizeof($products) > 0) {
$products_parsed = tep_array_filter($products, 'is_numeric');
if (sizeof($products_parsed) > 0) {
$Qcheck = $osC_Database->query('select count(*) as total from :table_products_notifications where customers_id = :customers_id and products_id not in :products_id');
$Qcheck->bindTable(':table_products_notifications', TABLE_PRODUCTS_NOTIFICATIONS);
$Qcheck->bindInt(':customers_id', $osC_Customer->id);
$Qcheck->bindRaw(':products_id', '(' . implode(',', $products_parsed) . ')');
$Qcheck->execute();
if ($Qcheck->valueInt('total') > 0) {
$Qdelete = $osC_Database->query('delete from :table_products_notifications where customers_id = :customers_id and products_id not in :products_id');
$Qdelete->bindTable(':table_products_notifications', TABLE_PRODUCTS_NOTIFICATIONS);
$Qdelete->bindInt(':customers_id', $osC_Customer->id);
$Qdelete->bindRaw(':products_id', '(' . implode(',', $products_parsed) . ')');
$Qdelete->execute();
if ($Qdelete->affectedRows() > 0) {
$updated = true;
}
}
}
} else {
$Qcheck = $osC_Database->query('select count(*) as total from :table_products_notifications where customers_id = :customers_id');
$Qcheck->bindTable(':table_products_notifications', TABLE_PRODUCTS_NOTIFICATIONS);
$Qcheck->bindInt(':customers_id', $osC_Customer->id);
$Qcheck->execute();
if ($Qcheck->valueInt('total') > 0) {
$Qdelete = $osC_Database->query('delete from :table_products_notifications where customers_id = :customers_id');
$Qdelete->bindTable(':table_products_notifications', TABLE_PRODUCTS_NOTIFICATIONS);
$Qdelete->bindInt(':customers_id', $osC_Customer->id);
$Qdelete->execute();
if ($Qdelete->affectedRows() > 0) {
$updated = true;
}
}
}
if ($updated === true) {
$messageStack->add_session('account', SUCCESS_NOTIFICATIONS_UPDATED, 'success');
}
tep_redirect(tep_href_link(FILENAME_ACCOUNT, '', 'SSL'));
}
function tep_parse_category_path($cPath)
{
// make sure the category IDs are integers
$cPath_array = tep_array_filter(explode('_', $cPath), 'is_numeric');
// make sure no duplicate category IDs exist which could lock the server in a loop
return array_unique($cPath_array);
}
