function del_cat_recursive($category_id)
{
$query = "SELECT * FROM categories WHERE category_id='{$category_id}' ";
$result = mysql_query($query) or die(mysql_error() . $query);
$row = mysql_fetch_array($result);
if ($row['obj_count'] > 0 && $_REQUEST['confirm'] == '') {
return -$row['obj_count'];
}
$query = "DELETE\tFROM categories WHERE category_id='{$category_id}' ";
mysql_query($query) or die(mysql_error() . $query);
$query = "DELETE\tFROM cat_name_translations WHERE category_id='{$category_id}' ";
mysql_query($query) or die(mysql_error() . $query);
$query = "SELECT * FROM categories WHERE parent_category_id='{$category_id}' ";
$result = mysql_query($query) or die(mysql_error() . $query);
while ($row = mysql_fetch_array($result)) {
del_cat_recursive($row['category_id']);
}
}
$result = mysql_query($sql) or die(mysql_error());
// update language
$sql = "REPLACE INTO `cat_name_translations` (`category_id`, `lang`, `category_name`) VALUES (" . $category_id . ", '" . $_SESSION['MDS_LANG'] . "', '" . $new_name . "')";
$result = mysql_query($sql) or die(mysql_error());
if ($_REQUEST['save'] != '' && CACHE_ENABLED == 'YES') {
$CACHE_ENABLED = 'NO';
include '../include/codegen_functions.php';
update_category_cache(0);
$CACHE_ENABLED = 'YES';
}
echo "Updated to <b>{$new_name}</b><br>";
}
if ($action == 'del') {
$_REQUEST['cat'] = getCatParent($_REQUEST['category_id']);
// so that we come back to parent..
if (($obj_count = del_cat_recursive($_REQUEST['category_id'])) < 0) {
$obj_count = -$obj_count;
echo "<br><font color='red'><b>Error:</b></font> Cannot delete this category: It looks like you have " . $obj_count . " record(s) in this category! <a href='" . $_SERVER['PHP_SELF'] . "?action=del&category_id=" . $_REQUEST['category_id'] . "&confirm=yes'>Click Here to delete anyway.</a></br>";
}
if ($_REQUEST['save'] != '' && CACHE_ENABLED == 'YES') {
$CACHE_ENABLED = 'NO';
include '../include/codegen_functions.php';
update_category_cache(0);
$CACHE_ENABLED = 'YES';
}
}
if ($_REQUEST['action'] == 'process') {
format_cat_translation_table(0);
if ($_REQUEST['save'] != '' && CACHE_ENABLED == 'YES') {
$CACHE_ENABLED = 'NO';
include '../include/codegen_functions.php';
