<?php
global $db;
require_once '../confy.php';
require_once '../functions.php';
require_once '../functions-2.php';
tep_db_connect();
use_class('jng_sp_catalog');
$class_jc = new jng_sp_catalog();
$products_ids = explode(',', tep_db_prepare_input($_GET['pids']));
foreach ($products_ids as $pid) {
$check = tep_db_query("SELECT * FROM products_removed WHERE products_id = '{$pid}'");
if (tep_db_num_rows($check) == 0) {
$r_data = array();
$r_data['products_id'] = $pid;
$r_data['removed_date'] = date('Y-m-d H:i:s');
tep_db_perform('products_removed', $r_data);
$catalog_ids = $class_jc->retrieveProductCatalogIDs($pid);
foreach ($catalog_ids as $catalog_id) {
$class_jc->updateField($catalog_id, array('active_status' => '0'));
}
tep_db_perform('products', array('products_status' => '0'), 'update', "products_id = '{$pid}'");
//HIDE FROM JnG SHOWROOM
echo "Products {$pid} is KILLED succesfully !<br/>";
}
}
