function remove_product($product_id) { // get content of product $product_content_query = olc_db_query("SELECT content_file FROM " . TABLE_PRODUCTS_CONTENT . " WHERE products_id = '" . olc_db_input($product_id) . "'"); // check if used elsewhere, delete db-entry + file if not while ($product_content = olc_db_fetch_array($product_content_query)) { $duplicate_content_query = olc_db_query("SELECT count(*) AS total FROM " . TABLE_PRODUCTS_CONTENT . " WHERE content_file = '" . olc_db_input($product_content['content_file']) . "' AND products_id != '" . olc_db_input($product_id) . "'"); $duplicate_content = olc_db_fetch_array($duplicate_content_query); if ($duplicate_content['total'] == 0) { @unlink(DIR_FS_DOCUMENT_ROOT . 'media/products/' . $product_content['content_file']); } //delete DB-Entry olc_db_query("DELETE FROM " . TABLE_PRODUCTS_CONTENT . " WHERE products_id = '" . olc_db_input($product_id) . "' AND (content_file = '" . $product_content['content_file'] . "' OR content_file = '')"); } $product_image_query = olc_db_query("SELECT products_image FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . olc_db_input($product_id) . "'"); $product_image = olc_db_fetch_array($product_image_query); $duplicate_image_query = olc_db_query("SELECT count(*) AS total FROM " . TABLE_PRODUCTS . " WHERE products_image = '" . olc_db_input($product_image['products_image']) . "'"); $duplicate_image = olc_db_fetch_array($duplicate_image_query); if ($duplicate_image['total'] < 2) { olc_del_image_file($product_image['products_image']); } //delete more images $mo_images_query = olc_db_query("SELECT image_name FROM " . TABLE_PRODUCTS_IMAGES . " WHERE products_id = '" . olc_db_input($product_id) . "'"); while ($mo_images_values = olc_db_fetch_array($mo_images_query)) { $duplicate_more_image_query = olc_db_query("SELECT count(*) AS total FROM " . TABLE_PRODUCTS_IMAGES . " WHERE image_name = '" . $mo_images_values['image_name'] . "'"); $duplicate_more_image = olc_db_fetch_array($duplicate_more_image_query); if ($duplicate_more_image['total'] < 2) { olc_del_image_file($mo_images_values['image_name']); } } olc_db_query("DELETE FROM " . TABLE_SPECIALS . " WHERE products_id = '" . olc_db_input($product_id) . "'"); olc_db_query("DELETE FROM " . TABLE_PRODUCTS . " WHERE products_id = '" . olc_db_input($product_id) . "'"); olc_db_query("DELETE FROM " . TABLE_PRODUCTS_IMAGES . " WHERE products_id = '" . olc_db_input($product_id) . "'"); olc_db_query("DELETE FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE products_id = '" . olc_db_input($product_id) . "'"); olc_db_query("DELETE FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = '" . olc_db_input($product_id) . "'"); olc_db_query("DELETE FROM " . TABLE_PRODUCTS_ATTRIBUTES . " WHERE products_id = '" . olc_db_input($product_id) . "'"); olc_db_query("DELETE FROM " . TABLE_CUSTOMERS_BASKET . " WHERE products_id = '" . olc_db_input($product_id) . "'"); olc_db_query("DELETE FROM " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " WHERE products_id = '" . olc_db_input($product_id) . "'"); $customers_status_array = olc_get_customers_statuses(); for ($i = 0, $n = sizeof($customers_status_array); $i < $n; $i++) { if (isset($customers_statuses_array[$i]['id'])) { olc_db_query("delete from personal_offers_by_customers_status_" . $customers_statuses_array[$i]['id'] . " where products_id = '" . olc_db_input($product_id) . "'"); } } $product_reviews_query = olc_db_query("select reviews_id from " . TABLE_REVIEWS . " where products_id = '" . olc_db_input($product_id) . "'"); while ($product_reviews = olc_db_fetch_array($product_reviews_query)) { olc_db_query("delete from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . $product_reviews['reviews_id'] . "'"); } olc_db_query("delete from " . TABLE_REVIEWS . " where products_id = '" . olc_db_input($product_id) . "'"); if (USE_CACHE == TRUE_STRING_S) { olc_reset_cache_block('categories'); olc_reset_cache_block('also_purchased'); } }
if (file_exists($image_location)) @unlink($image_location); } */ olc_db_query(DELETE_FROM . TABLE_BLACKLIST . " where blacklist_id = '" . olc_db_input($blacklist_id) . APOS); // olc_db_query(DELETE_FROM . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . olc_db_input($manufacturers_id) . APOS); /* if ($_POST['delete_products'] == 'on') { $products_query = olc_db_query("select products_id from " . TABLE_PRODUCTS . " where manufacturers_id = '" . olc_db_input($manufacturers_id) . APOS); while ($products = olc_db_fetch_array($products_query)) { olc_remove_product($products['products_id']); } } else { olc_db_query(SQL_UPDATE . TABLE_PRODUCTS . " set manufacturers_id = '' where manufacturers_id = '" . olc_db_input($manufacturers_id) . APOS); } */ if (USE_CACHE == TRUE_STRING_S) { olc_reset_cache_block('manufacturers'); } olc_redirect(olc_href_link(FILENAME_BLACKLIST, 'page=' . $_GET['page'])); break; } require DIR_WS_INCLUDES . 'header.php'; ?> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td class="columnLeft2" nowrap="nowrap" valign="top"><table border="0" cellspacing="1" cellpadding="1" class="columnLeft" nowrap="nowrap"> <!-- left_navigation //--> <?php require DIR_WS_INCLUDES . 'column_left.php'; ?> <!-- left_navigation_eof //--> </table></td>
function olc_remove_product($product_id) { $where = SQL_WHERE . "products_id = '" . olc_db_input($product_id) . APOS; $product_image_query = olc_db_query(SELECT . "products_image" . SQL_FROM . TABLE_PRODUCTS . $where); $product_image = olc_db_fetch_array($product_image_query); $duplicate_image_query = olc_db_query(SELECT . "count(*) as total" . SQL_FROM . TABLE_PRODUCTS . SQL_WHERE . "products_image = '" . olc_db_input($product_image['products_image']) . APOS); $duplicate_image = olc_db_fetch_array($duplicate_image_query); if ($duplicate_image['total'] < 2) { if (file_exists(DIR_FS_CATALOG_POPUP_IMAGES . $product_image['products_image'])) { @unlink(DIR_FS_CATALOG_POPUP_IMAGES . $product_image['products_image']); } // START CHANGES $image_subdir = BIG_IMAGE_SUBDIR; if (substr($image_subdir, -1) != '/') { $image_subdir .= '/'; } if (file_exists(DIR_FS_CATALOG_IMAGES . $image_subdir . $product_image['products_image'])) { @unlink(DIR_FS_CATALOG_IMAGES . $image_subdir . $product_image['products_image']); } // END CHANGES } $delete = "delete" . SQL_FROM; $where = SQL_WHERE . "products_id = '" . olc_db_input($product_id) . APOS; olc_db_query($delete . TABLE_SPECIALS . $where); olc_db_query($delete . TABLE_PRODUCTS . $where); olc_db_query($delete . TABLE_PRODUCTS_TO_CATEGORIES . $where); olc_db_query($delete . TABLE_PRODUCTS_DESCRIPTION . $where); olc_db_query($delete . TABLE_PRODUCTS_ATTRIBUTES . $where); olc_db_query($delete . TABLE_CUSTOMERS_BASKET . $where); olc_db_query($delete . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . $where); //Xsell olc_db_query($delete . TABLE_PRODUCTS_XSELL . $where . " OR xsell_id = '" . olc_db_input($product_id) . APOS); //Xsell $customers_status_array = olc_get_customers_statuses(); for ($i = 0, $n = sizeof($customers_status_array); $i < $n; $i++) { olc_db_query($delete . TABLE_PERSONAL_OFFERS_BY_CUSTOMERS_STATUS . $i . $where); } $product_reviews_query = olc_db_query(SELECT . "reviews_id" . SQL_FROM . TABLE_REVIEWS . $where); while ($product_reviews = olc_db_fetch_array($product_reviews_query)) { olc_db_query($delete . TABLE_REVIEWS_DESCRIPTION . SQL_WHERE . "reviews_id = '" . $product_reviews['reviews_id'] . APOS); } olc_db_query($delete . TABLE_REVIEWS . $where); if (USE_CACHE == TRUE_STRING_S) { olc_reset_cache_block('categories'); olc_reset_cache_block('also_purchased'); } }