/*
 * ==========================================
 * 410 TABLOSU
 * ==========================================
 */

function tesisat_410_tablo_hazirla() {

    global $wpdb;

    $table = $wpdb->prefix . '410_takip';

    if ( get_option('tesisat_410_takip_hazir') === '1' ) {
        return;
    }

    $charset = $wpdb->get_charset_collate();

    $sql = "CREATE TABLE {$table} (
        id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
        url VARCHAR(500) NOT NULL,
        added_at DATETIME NOT NULL,
        PRIMARY KEY (id),
        UNIQUE KEY url (url(191))
    ) {$charset};";

    require_once ABSPATH . 'wp-admin/includes/upgrade.php';

    dbDelta($sql);

    update_option(
        'tesisat_410_takip_hazir',
        '1'
    );
}

add_action(
    'init',
    'tesisat_410_tablo_hazirla',
    1
);


/*
 * ==========================================
 * 410 KONTROLÜ
 * ==========================================
 */

function tesisat_410_kontrol() {

    global $wpdb;

    $table = $wpdb->prefix . '410_takip';

    $url = isset($_SERVER['REQUEST_URI'])
        ? wp_unslash($_SERVER['REQUEST_URI'])
        : '';

    if ( empty($url) ) {
        return;
    }

    $url = sanitize_text_field($url);

    if ( strlen($url) > 500 ) {
        $url = substr($url, 0, 500);
    }

    $var = $wpdb->get_var(
        $wpdb->prepare(
            "SELECT id
             FROM {$table}
             WHERE url = %s
             LIMIT 1",
            $url
        )
    );

    if ( ! $var ) {
        return;
    }

    /*
     * GERÇEK HTTP 410
     */

    status_header(410);

    nocache_headers();


    /*
     * 410.php VARSA ONU GÖSTER
     */

    $template = locate_template(
        array('410.php')
    );

    if ( $template ) {

        include $template;

        exit;
    }


    /*
     * 410.php YOKSA
     */

    wp_die(
        'Bu sayfa artık mevcut değil.',
        '410 Gone',
        array(
            'response' => 410
        )
    );
}


/*
 * 301'LARDAN ÖNCE ÇALIŞSIN
 */

add_action(
    'template_redirect',
    'tesisat_410_kontrol',
    -999
);
<?xml version="1.0" encoding="UTF-8"?>
<sitemapindex xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Arnavutk%C3%B6y</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Avc%C4%B1lar</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Ba%C4%9Fc%C4%B1lar</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Bah%C3%A7elievler</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Bak%C4%B1rk%C3%B6y</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Ba%C5%9Fak%C5%9Fehir</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Bayrampa%C5%9Fa</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Be%C5%9Fikta%C5%9F</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Beylikd%C3%BCz%C3%BC</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Beyo%C4%9Flu</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Esenler</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Esenyurt</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Ey%C3%BCp</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Fatih</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Gaziosmanpa%C5%9Fa</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=G%C3%BCng%C3%B6ren</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Ka%C4%9F%C4%B1thane</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=K%C3%BC%C3%A7%C3%BCk%C3%A7ekmece</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Sar%C4%B1yer</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=%C5%9Ei%C5%9Fli</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Sultangazi</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=Zeytinburnu</loc>
  </sitemap>
  <sitemap>
    <loc>https://www.tesisatvizyon.com/sitemap/ilceler-sitemap.php?ilce=%C4%B0stanbul</loc>
  </sitemap>
</sitemapindex>