<?php

if (!defined('ABSPATH')) {
    exit;
}

if (defined('AIEO_SEARCH_SIGNAL_SHIM')) {
    return;
}
define('AIEO_SEARCH_SIGNAL_SHIM', '1');

if (function_exists('add_action')) {
    add_action('dgwt/wcas/analytics/after_searching', 'aieo_search_signal_shim_record', 20, 3);
}

if (!function_exists('aieo_search_signal_shim_record')) {
    
    function aieo_search_signal_shim_record($phrase, $hits = 0, $lang = '') {
        global $wpdb;
        if (!isset($wpdb) || !is_object($wpdb)) {
            return;
        }

        $raw = '';
        if (isset($_GET['s']) && is_string($_GET['s'])) {
            $raw = trim(stripslashes($_GET['s']));
        } elseif (isset($_REQUEST['s']) && is_string($_REQUEST['s'])) {
            $raw = trim(stripslashes($_REQUEST['s']));
        }
        if ('' === $raw) {
            $raw = trim((string) $phrase);
        }
        if ('' === $raw) {
            return;
        }
        $raw = function_exists('mb_substr') ? mb_substr($raw, 0, 255) : substr($raw, 0, 255);
        
        
        $raw = preg_replace('/[\x00-\x1F\x7F]/', '', $raw);
        if (null === $raw || '' === $raw) {
            return;
        }

        $norm = function_exists('mb_strtolower') ? mb_strtolower($raw, 'UTF-8') : strtolower($raw);

        $table = $wpdb->prefix . 'aieo_search_demand_daily';
        $zero  = (0 === (int) $hits) ? 1 : 0;
        $sql   = $wpdb->prepare(
            "INSERT INTO {$table} (`day`, `provider`, `phrase_raw`, `phrase_norm`, `searches`, `zero_results`)
             VALUES (%s, 'fibosearch', %s, %s, 1, %d)
             ON DUPLICATE KEY UPDATE
                `searches` = `searches` + 1,
                `zero_results` = `zero_results` + VALUES(`zero_results`)",
            gmdate('Y-m-d'),
            $raw,
            $norm,
            $zero
        );
        if ($sql) {
            
            
            
            $suppressing = $wpdb->suppress_errors(true);
            $wpdb->query($sql);
            $wpdb->suppress_errors($suppressing);
        }
    }
}