if ($_POST['quick_updates_new']['products_image']) { foreach ($_POST['quick_updates_new']['products_image'] as $products_id => $new_value) { if (trim($_POST['quick_updates_new']['products_image'][$products_id]) != trim($_POST['quick_updates_old']['products_image'][$products_id])) { $quick_updates_count['products_image'][$products_id] = $products_id; $db->Execute("UPDATE " . TABLE_PRODUCTS . " SET products_image='" . zen_db_input($new_value) . "', products_last_modified=now() WHERE products_id=" . (int) $products_id); } } } if ($_POST['quick_updates_old']['products_status']) { foreach ($_POST['quick_updates_old']['products_status'] as $products_id => $status) { if (!isset($_POST['quick_updates_new']['products_status'][$products_id])) { $_POST['quick_updates_new']['products_status'][$products_id] = '0'; } if ($_POST['quick_updates_new']['products_status'][$products_id] != $_POST['quick_updates_old']['products_status'][$products_id]) { $quick_updates_count['products_status'][$products_id] = $products_id; zen_set_product_status((int) $products_id, (int) $_POST['quick_updates_new']['products_status'][$products_id]); } } } if ($_POST['quick_updates_new']['products_tax_class_id']) { foreach ($_POST['quick_updates_new']['products_tax_class_id'] as $products_id => $new_value) { if ($_POST['quick_updates_new']['products_tax_class_id'][$products_id] != $_POST['quick_updates_old']['products_tax_class_id'][$products_id]) { $quick_updates_count['products_tax_class_id'][$products_id] = $products_id; $db->Execute("UPDATE " . TABLE_PRODUCTS . " SET products_tax_class_id='" . (int) $new_value . "', products_last_modified=now() WHERE products_id=" . (int) $products_id); } } } if ($_POST['quick_updates_new']['categories_id']) { foreach ($_POST['quick_updates_new']['categories_id'] as $products_id => $new_value) { if ($_POST['quick_updates_new']['categories_id'][$products_id] != $_POST['quick_updates_old']['categories_id'][$products_id]) { if (zen_childs_in_category_count($new_value)) {
} // for } zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $_GET['cPath'] . '&cID=' . $_GET['cID'])); break; case 'remove_type': $sql = "delete from " . TABLE_PRODUCT_TYPES_TO_CATEGORY . "\n where category_id = '" . zen_db_prepare_input($_GET['cID']) . "'\n and product_type_id = '" . zen_db_prepare_input($_GET['type_id']) . "'"; $db->Execute($sql); zen_remove_restrict_sub_categories($_GET['cID'], $_GET['type_id']); $action = "edit"; zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'action=edit_category&cPath=' . $_GET['cPath'] . '&cID=' . zen_db_prepare_input($_GET['cID']))); break; case 'setflag': if ($_GET['flag'] == '0' || $_GET['flag'] == '1') { if (isset($_GET['pID'])) { zen_set_product_status($_GET['pID'], $_GET['flag']); } } zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $_GET['cPath'] . '&pID=' . $_GET['pID'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : ''))); break; case 'insert_category': case 'update_category': if (isset($_POST['add_type']) or isset($_POST['add_type_all'])) { // check if it is already restricted $sql = "select * from " . TABLE_PRODUCT_TYPES_TO_CATEGORY . "\n where category_id = '" . zen_db_prepare_input($_POST['categories_id']) . "'\n and product_type_id = '" . zen_db_prepare_input($_POST['restrict_type']) . "'"; $type_to_cat = $db->Execute($sql); if ($type_to_cat->RecordCount() < 1) { //@@TODO find all sub-categories and restrict them as well. $insert_sql_data = array('category_id' => zen_db_prepare_input($_POST['categories_id']), 'product_type_id' => zen_db_prepare_input($_POST['restrict_type'])); zen_db_perform(TABLE_PRODUCT_TYPES_TO_CATEGORY, $insert_sql_data); /*