add_session(ERROR_ADMIN_DEMO, 'caution'); zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $_GET['cPath'] . '&pID=' . $_GET['pID'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : ''))); } $do_delete_flag = false; //echo 'products_id=' . $_POST['products_id'] . '
'; if (isset($_POST['products_id']) && isset($_POST['product_categories']) && is_array($_POST['product_categories'])) { $product_id = zen_db_prepare_input($_POST['products_id']); $product_categories = $_POST['product_categories']; $do_delete_flag = true; if (!isset($delete_linked)) $delete_linked = 'true'; } if (zen_not_null($cascaded_prod_id_for_delete) && zen_not_null($cascaded_prod_cat_for_delete) ) { $product_id = $cascaded_prod_id_for_delete; $product_categories = $cascaded_prod_cat_for_delete; $do_delete_flag = true; // no check for $delete_linked here, because it should already be passed from categories.php } if ($do_delete_flag) { //--------------PRODUCT_TYPE_SPECIFIC_INSTRUCTIONS_GO__BELOW_HERE-------------------------------------------------------- // Delete media components, but only if the product is no longer cross-linked to another: $resVal = $db->Execute("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "'"); if ($resVal->RecordCount() < 2) { // First we delete related records from related product-type tables: //echo 'SQL=' . "select media_id from " . TABLE_MEDIA_TO_PRODUCTS . " where product_id = '" . (int)$product_id . "'
"; $product_media = $db->Execute("select media_id from " . TABLE_MEDIA_TO_PRODUCTS . " where product_id = '" . (int)$product_id . "'"); //echo 'media count =' . $product_media->RecordCount() . '
'; while (!$product_media->EOF) { //echo 'media delete=' . $product_media->fields['media_id'] . '
'; $db->Execute("delete from " . TABLE_MEDIA_TO_PRODUCTS . " where media_id='" . (int)zen_db_input($product_media->fields['media_id']) . "' and product_id = '" . (int)$product_id . "'"); $product_media->MoveNext(); } //echo 'SQL=' . "select artists_id, record_company_id, music_genre_id from " . TABLE_PRODUCT_MUSIC_EXTRA . " where products_id = '" . (int)$product_id . "'
"; $music_extra = $db->Execute("select artists_id, record_company_id, music_genre_id from " . TABLE_PRODUCT_MUSIC_EXTRA . " where products_id = '" . (int)$product_id . "'"); //echo 'media count =' . $music_extra->RecordCount() . '
'; if ($music_extra->RecordCount()>0) { //echo 'artists_id delete=' . $music_extra->fields['artists_id'] . '
'; //echo 'record_company_id delete=' . $music_extra->fields['record_company_id'] . '
'; //echo 'music_genre_id delete=' . $music_extra->fields['music_genre_id'] . '
'; $db->Execute("delete from " . TABLE_PRODUCT_MUSIC_EXTRA . " where products_id = '" . (int)$product_id . "' and artists_id = '" . zen_db_input($music_extra->fields['artists_id']) . "' and record_company_id = '" . zen_db_input($music_extra->fields['record_company_id']) . "' and music_genre_id = '" . zen_db_input($music_extra->fields['music_genre_id']) . "'"); } } //--------------PRODUCT_TYPE_SPECIFIC_INSTRUCTIONS_GO__ABOVE__HERE-------------------------------------------------------- // now do regular non-type-specific delete: // remove product from all its categories: for ($k=0, $m=sizeof($product_categories); $k<$m; $k++) { $db->Execute("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "' and categories_id = '" . (int)$product_categories[$k] . "'"); } // confirm that product is no longer linked to any categories $count_categories = $db->Execute("select count(categories_id) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '" . (int)$product_id . "'"); // echo 'count of category links for this product=' . $count_categories->fields['total'] . '
'; // if not linked to any categories, do delete: if ($count_categories->fields['total'] == '0') { zen_remove_product($product_id, $delete_linked); } } // endif $do_delete_flag // if this is a single-product delete, redirect to categories page // if not, then this file was called by the cascading delete initiated by the category-delete process if ($action == 'delete_product_confirm') zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));