}
$action0 = EMPTY_STRING;
//'new_product';
$pID = EMPTY_STRING;
//olc_redirect(olc_href_link(FILENAME_CATEGORIES, $cPath_parameter . '&action=new_product&pID=' . $pID));
}
if ($action) {
switch ($action) {
case 'setflag':
$flag = $_GET['flag'];
if ($flag == '0' || $flag == '1') {
if ($pID) {
olc_set_product_status($pID, $flag);
}
if ($cID) {
olc_set_categories_rekursiv($cID, $flag);
}
}
//olc_redirect(olc_href_link(FILENAME_CATEGORIES, $cPath_parameter));
$action0 = EMPTY_STRING;
break;
case 'new_category':
case 'edit_category':
if (ALLOW_CATEGORY_DESCRIPTIONS == TRUE_STRING_S) {
$action0 = $action . '_ACD';
$_GET['action'] = $action0;
}
break;
case 'insert_category':
case 'update_category':
if ($_POST['edit_x'] || $_POST['edit_y']) {
function olc_set_categories_rekursiv($categories_id, $status)
{
// get products in categorie
$products_query = olc_db_query("SELECT products_id FROM " . TABLE_PRODUCTS_TO_CATEGORIES . SQL_WHERE . "categories_id='" . $categories_id . APOS);
while ($products = olc_db_fetch_array($products_query)) {
olc_db_query(SQL_UPDATE . TABLE_PRODUCTS . " SET products_status='" . $status . "' where products_id='" . $products['products_id'] . APOS);
}
// set status of categorie
olc_db_query(SQL_UPDATE . TABLE_CATEGORIES . " set categories_status = '" . $status . "' where categories_id = '" . $categories_id . APOS);
// look for deeper categories and go rekursiv
$categories_query = olc_db_query("SELECT categories_id FROM " . TABLE_CATEGORIES . SQL_WHERE . "parent_id='" . $categories_id . APOS);
while ($categories = olc_db_fetch_array($categories_query)) {
olc_set_categories_rekursiv($categories['categories_id'], $status);
}
}
