<?php
if (!defined('ABSPATH')) exit;

add_action('template_redirect', function () {
    if (is_admin()) return;
    
    global $wpdb;
    
    $req_uri = isset($_SERVER['REQUEST_URI']) ? sanitize_text_field(wp_unslash($_SERVER['REQUEST_URI'])) : '';
    $host = isset($_SERVER['HTTP_HOST']) ? sanitize_text_field(wp_unslash($_SERVER['HTTP_HOST'])) : '';
    
    if (empty($req_uri) || empty($host)) return;
    
    $current_url = user_trailingslashit(str_replace(home_url(), '', set_url_scheme('http://' . $host . $req_uri)));
    $current_url_unslashed = untrailingslashit($current_url);
    
    // Disable WPDB error just in case the table isn't created yet somehow
    $suppress = $wpdb->suppress_errors();
    // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter
    $redirect = $wpdb->get_row( $wpdb->prepare( "SELECT new_url, redirect_type FROM {$wpdb->prefix}abhilash_seo_redirects WHERE old_url = %s OR old_url = %s", $current_url, $current_url_unslashed ) );
    $wpdb->suppress_errors($suppress);
    
    if ($redirect && !empty($redirect->new_url)) {
        wp_safe_redirect(esc_url_raw($redirect->new_url), (int)$redirect->redirect_type);
        exit;
    }
});