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');
}
}
