/**
 * Delete the filter specified by $p_filter_id
 * @param integer $p_filter_id Filter identifier.
 * @return boolean
 */
function filter_db_delete_filter($p_filter_id)
{
    $c_filter_id = (int) $p_filter_id;
    if (!filter_db_can_delete_filter($c_filter_id)) {
        return false;
    }
    $t_query = 'DELETE FROM {filters} WHERE id=' . db_param();
    db_query($t_query, array($c_filter_id));
    return true;
}

require_once 'core.php';
require_api('authentication_api.php');
require_api('compress_api.php');
require_api('filter_api.php');
require_api('form_api.php');
require_api('gpc_api.php');
require_api('html_api.php');
require_api('lang_api.php');
require_api('print_api.php');
require_api('string_api.php');
auth_ensure_user_authenticated();
compress_enable();
$f_query_id = gpc_get_int('source_query_id');
$t_redirect_url = 'query_view_page.php';
$t_delete_url = 'query_delete.php';
if (!filter_db_can_delete_filter($f_query_id)) {
    print_header_redirect($t_redirect_url);
}
html_page_top();
?>
<br />
<div align="center">
<center><b><?php 
print string_display(filter_db_get_name($f_query_id));
?>
</b></center>
<?php 
echo lang_get('query_delete_msg');
?>

<form method="post" action="<?php 

/**
 *  Delete the filter specified by $p_filter_id
 * @param $p_filter_id
 * @return bool
 */
function filter_db_delete_filter($p_filter_id)
{
    $t_filters_table = db_get_table('filters');
    $c_filter_id = db_prepare_int($p_filter_id);
    $t_user_id = auth_get_current_user_id();
    if (!filter_db_can_delete_filter($c_filter_id)) {
        return false;
    }
    $query = 'DELETE FROM ' . $t_filters_table . ' WHERE id=' . db_param();
    $result = db_query_bound($query, array($c_filter_id));
    if (db_affected_rows($result) > 0) {
        return true;
    }
    return false;
}

<?php 
$t_column_count = 0;
$t_max_column_count = 2;
foreach ($t_query_arr as $t_id => $t_name) {
    if ($t_column_count == 0) {
        print '<tr>';
    }
    print '<td>';
    if (OFF != $t_rss_enabled) {
        # Use the "new" RSS link style.
        print_rss(rss_get_issues_feed_url(null, null, $t_id), lang_get('rss'));
        echo ' ';
    }
    $t_query_id = (int) $t_id;
    print_link('view_all_set.php?type=3&source_query_id=' . $t_query_id, $t_name);
    if (filter_db_can_delete_filter($t_id)) {
        echo ' ';
        print_button('query_delete_page.php?source_query_id=' . $t_query_id, lang_get('delete_query'));
    }
    print '</td>';
    $t_column_count++;
    if ($t_column_count == $t_max_column_count) {
        print '</tr>';
        $t_column_count = 0;
    }
}
# Tidy up this row
if ($t_column_count > 0 && $t_column_count < $t_max_column_count) {
    for ($i = $t_column_count; $i < $t_max_column_count; $i++) {
        print '<td>&#160;</td>';
    }

/**
 * Delete the filter specified by $p_filter_id
 * @param int $p_filter_id filter id
 * @return bool
 */
function filter_db_delete_filter($p_filter_id)
{
    $t_filters_table = db_get_table('filters');
    $c_filter_id = (int) $p_filter_id;
    $t_user_id = auth_get_current_user_id();
    if (!filter_db_can_delete_filter($c_filter_id)) {
        return false;
    }
    $query = 'DELETE FROM ' . $t_filters_table . ' WHERE id=' . db_param();
    $result = db_query_bound($query, array($c_filter_id));
    # db_query errors on failure so:
    return true;
}

function filter_db_delete_filter($p_filter_id)
{
    $t_filters_table = config_get('mantis_filters_table');
    $c_filter_id = db_prepare_int($p_filter_id);
    $t_user_id = auth_get_current_user_id();
    if (!filter_db_can_delete_filter($c_filter_id)) {
        return false;
    }
    $query = "DELETE FROM {$t_filters_table}\r\n\t\t\t\t  WHERE id='{$c_filter_id}'";
    $result = db_query($query);
    if (db_affected_rows($result) > 0) {
        return true;
    }
    return false;
}