query($wpdb->prepare( 'INSERT INTO %i (subject, window_start, hits) VALUES (%s, %s, 1) ON DUPLICATE KEY UPDATE hits = IF(window_start < VALUES(window_start), 1, hits + 1), window_start = GREATEST(window_start, VALUES(window_start))', $table, $subject, $window )); if ($inserted === false) { return false; } $hits = $wpdb->get_var($wpdb->prepare('SELECT hits FROM %i WHERE subject = %s', $table, $subject)); return $hits !== null && (int) $hits <= $limit; } public static function remoteAddress(\WP_REST_Request $request): string { $address = sanitize_text_field(wp_unslash((string) ($_SERVER['REMOTE_ADDR'] ?? ''))); if ($address === '' || !filter_var($address, FILTER_VALIDATE_IP)) { return 'unknown'; } return $address; } }