<?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/>"; } }