db_open();
if (isset($_REQUEST["bt_update"])) {
    if ($_REQUEST["add_name"] != "") {
        db_query("\r\n      INSERT INTO category(type, name, value_type)\r\n      VALUES ('" . $_REQUEST["add_type"] . "', '" . $_REQUEST["add_name"] . "', '" . $_REQUEST["value_type"] . "')\r\n    ");
        add_request_message("Category added");
    }
    if (isset($_REQUEST["ids"])) {
        db_query("\r\n      DELETE FROM category\r\n      WHERE id IN (" . implode(',', $_REQUEST["ids"]) . ")\r\n    ");
        add_request_message(sizeof($_REQUEST["ids"]) . " categori(es) deleted");
    }
    if (isset($_REQUEST["new_names"])) {
        $count = 0;
        foreach ($_REQUEST["new_names"] as $cat_id => $new_name) {
            $new_name = trim($new_name);
            if ($new_name != '') {
                db_query("\r\n          UPDATE category\r\n          SET name='{$new_name}'\r\n          WHERE id='{$cat_id}'\r\n          AND type='" . $_REQUEST["add_type"] . "'\r\n        ");
                $count++;
            }
        }
        if ($count > 0) {
            add_request_message("{$count} categori(es) renamed");
        }
    }
}
if (isset($_REQUEST['type'])) {
    $type = $_REQUEST['type'];
} else {
    $type = CATEGORY_FILE;
}
$categories = db_query("\r\n\tSELECT * \r\n\tFROM category\r\n\tWHERE type={$type}\r\n\tORDER BY type, name\r\n");
include 'categories.php_html';
<?php

include_once 'include/Category.php';
include_once 'include/Messages.php';
if ($_REQUEST['cat_op'] == 'add') {
    $count = addCategoryToDisks($_REQUEST['category'], $ids);
    add_request_message("Applied category to {$count} disks");
} else {
    if ($_REQUEST['cat_op'] == 'del') {
        $count = removeCategoryFromDisks($_REQUEST['category'], $ids);
        add_request_message("Removed category from disks");
    }
}
echo render_messages();
echo returnToSearchResultsButton();
<?php

include_once 'include/Category.php';
include_once 'include/Messages.php';
if ($_REQUEST['cat_op'] == 'add') {
    $count = addCategoryToFiles($_REQUEST['category'], $ids, $_REQUEST['cat_value']);
    add_request_message("Applied category to {$count} files");
} else {
    if ($_REQUEST['cat_op'] == 'del') {
        $count = removeCategoryFromFiles($_REQUEST['category'], $ids);
        add_request_message("Removed category from files");
    }
}
echo render_messages();
echo returnToSearchResultsButton();
<?php

include_once 'include/common.php';
include_once 'include/File.php';
include_once 'include/Messages.php';
include_once 'include/html.php';
db_open();
$ids = $_REQUEST['ids'];
$ids = array_diff($ids, array($_REQUEST['main_file']));
updateFile($ids, array('main_file' => $_REQUEST['main_file']));
add_request_message("Created multi-file entry");
echo render_messages();
echo returnToSearchResultsButton();