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';