$manufacturer_result = $dbconn->Execute("SELECT manufacturers_image FROM {$manufacturerstable} WHERE manufacturers_id = '" . oos_db_input($manufacturers_id) . "'");
$manufacturer = $manufacturer_result->fields;
$image_location = OOS_ABSOLUTE_PATH . OOS_IMAGES . $manufacturer['manufacturers_image'];
if (file_exists($image_location)) {
@unlink($image_location);
}
}
$manufacturerstable = $oostable['manufacturers'];
$dbconn->Execute("DELETE FROM {$manufacturerstable} WHERE manufacturers_id = '" . oos_db_input($manufacturers_id) . "'");
$manufacturers_infotable = $oostable['manufacturers_info'];
$dbconn->Execute("DELETE FROM {$manufacturers_infotable} WHERE manufacturers_id = '" . oos_db_input($manufacturers_id) . "'");
if (isset($_POST['delete_products']) && $_POST['delete_products'] == 'on') {
$productstable = $oostable['products'];
$products_result = $dbconn->Execute("SELECT products_id FROM {$productstable} WHERE manufacturers_id = '" . oos_db_input($manufacturers_id) . "'");
while ($products = $products_result->fields) {
oos_remove_product($products['products_id']);
// Move that ADOdb pointer!
$products_result->MoveNext();
}
// Close result set
$products_result->Close();
} else {
$productstable = $oostable['products'];
$dbconn->Execute("UPDATE {$productstable} SET manufacturers_id = '' WHERE manufacturers_id = '" . oos_db_input($manufacturers_id) . "'");
}
oos_redirect_admin(oos_href_link_admin($aFilename['manufacturers'], 'page=' . $_GET['page']));
break;
}
}
require 'includes/oos_header.php';
?>
while (list($key) = each($products_delete)) {
oos_remove_product($key);
}
}
oos_redirect_admin(oos_href_link_admin($aFilename['categories'], 'categories=' . $categories));
break;
case 'delete_product_confirm':
if ($_POST['products_id'] && $_POST['product_categories'] && is_array($_POST['product_categories'])) {
$product_categories = $_POST['product_categories'];
for ($i = 0, $n = count($product_categories); $i < $n; $i++) {
$dbconn->Execute("DELETE FROM " . $oostable['products_to_categories'] . " WHERE products_id = '" . (int) $products_id . "' and categories_id = '" . (int) $product_categories[$i] . "'");
}
$product_categories_result = $dbconn->Execute("SELECT COUNT(*) AS total FROM " . $oostable['products_to_categories'] . " WHERE products_id = '" . (int) $products_id . "'");
$product_categories = $product_categories_result->fields;
if ($product_categories['total'] == '0') {
oos_remove_product($products_id);
}
}
oos_redirect_admin(oos_href_link_admin($aFilename['categories'], 'categories=' . $categories));
break;
case 'move_category_confirm':
if ($_POST['categories_id'] && $_POST['categories_id'] != $_POST['move_to_category_id']) {
$new_parent_id = $move_to_category_id;
$dbconn->Execute("UPDATE " . $oostable['categories'] . " SET parent_id = '" . oos_db_input($new_parent_id) . "', last_modified = '" . date("Y-m-d H:i:s", time()) . "' WHERE categories_id = '" . oos_db_input($categories_id) . "'");
}
oos_redirect_admin(oos_href_link_admin($aFilename['categories'], 'categories=' . $new_parent_id . '&cID=' . $categories_id));
break;
case 'move_product_confirm':
$products_id = oos_db_prepare_input($_POST['products_id']);
$new_parent_id = oos_db_prepare_input($_POST['move_to_category_id']);
$duplicate_check_result = $dbconn->Execute("SELECT COUNT(*) AS total FROM " . $oostable['products_to_categories'] . " WHERE products_id = '" . oos_db_input($products_id) . "' and categories_id = '" . oos_db_input($new_parent_id) . "'");
