Changeset 3364780

Timestamp:

09/19/2025 10:45:07 PM (5 months ago)

Author:

designful

Message:

Update to version 1.1.6 from GitHub

Location:

seo-ai-audit-tool

Files:

• tags/1.1.6 (copied) (copied from seo-ai-audit-tool/trunk)
• tags/1.1.6/assets/css/seoaudp-style.css (modified) (6 diffs)
• tags/1.1.6/assets/js/seoaudp-script.js (modified) (3 diffs)
• tags/1.1.6/changelog.txt (modified) (1 diff)
• tags/1.1.6/includes/class-seo-audit-data-import.php (modified) (17 diffs)
• tags/1.1.6/includes/class-seo-audit-db.php (modified) (4 diffs)
• tags/1.1.6/includes/class-seo-audit-settings-page.php (modified) (2 diffs)
• tags/1.1.6/includes/models/class-seo-audit-model.php (modified) (13 diffs)
• tags/1.1.6/includes/views/class-seo-audit-view.php (modified) (1 diff)
• tags/1.1.6/includes/views/partials/default-category-rows-partial.php (modified) (1 diff)
• tags/1.1.6/includes/views/partials/table-header-partial.php (modified) (1 diff)
• tags/1.1.6/readme.md (modified) (1 diff)
• tags/1.1.6/seo-ai-audit-tool.code-workspace (modified) (1 diff)
• tags/1.1.6/seo-ai-audit-tool.php (modified) (3 diffs)
• trunk/assets/css/seoaudp-style.css (modified) (6 diffs)
• trunk/assets/js/seoaudp-script.js (modified) (3 diffs)
• trunk/changelog.txt (modified) (1 diff)
• trunk/includes/class-seo-audit-data-import.php (modified) (17 diffs)
• trunk/includes/class-seo-audit-db.php (modified) (4 diffs)
• trunk/includes/class-seo-audit-settings-page.php (modified) (2 diffs)
• trunk/includes/models/class-seo-audit-model.php (modified) (13 diffs)
• trunk/includes/views/class-seo-audit-view.php (modified) (1 diff)
• trunk/includes/views/partials/default-category-rows-partial.php (modified) (1 diff)
• trunk/includes/views/partials/table-header-partial.php (modified) (1 diff)
• trunk/readme.md (modified) (1 diff)
• trunk/seo-ai-audit-tool.code-workspace (modified) (1 diff)
• trunk/seo-ai-audit-tool.php (modified) (3 diffs)

seo-ai-audit-tool/tags/1.1.6/assets/css/seoaudp-style.css

@@ -803 +803 @@
 }
 
+.seoaudp-grid-two-columns {
+    display: grid;
+    grid-template-columns: 1fr 1fr;
+    gap: 20px;
+}
+
+.seoaudp-grid-two-columns .seoaudp-column { display: contents; }
+
+.seoaudp-gsc-sub-columns { display: contents; }
+
+.seoaudp-ahrefs-sub-columns { display: contents; }
+
+/* Responsive design for smaller screens */
+@media (max-width: 768px) {
+    .seoaudp-grid-two-columns {
+        grid-template-columns: 1fr;
+    }
+}
+
 .seoaudp-form-group {
     margin-bottom: 20px;
@@ -1402 +1421 @@
     color: rgba(26, 41, 72, 1);
     font-weight: 500;
+}
+.seoaudp-page-title-text{
+    display: inline-block;
+    max-width: 220px;
+    white-space: nowrap;
+    overflow: hidden;
+    text-overflow: ellipsis;
+    vertical-align: bottom;
 }
 .seoaudp-page-title-container a small{
@@ -1907 +1934 @@
 
 .seoaudp-sticky-title {
-    position: relative;
+    position: relative; /* allow JS transform without native sticky gaps */
     transition: transform 0.02s ease-out;
     background: white;
@@ -1923 +1950 @@
     box-shadow: 0 2px 4px rgba(0, 0, 0, 0.3);
 }
+.seoaudp-is-scrolled .seoaudp-sticky-title .seoaudp-checkbox { display: none; }
+.seoaudp-is-scrolled .seoaudp-sticky-title br { display: none; }
+/* Show only the slug on sticky */
+.seoaudp-is-scrolled .seoaudp-sticky-title .seoaudp-page-title-text { display: none; }
+.seoaudp-is-scrolled .seoaudp-sticky-title a small { display: inline-block; font-size: 13px; }
 .seoaudp-page-name-column {
     position: relative;
@@ -1957 +1989 @@
 /* Responsive adjustments */
 @media screen and (max-width: 782px) {
-    .seoaudp-sticky-header {
-        top: 46px; /* Adjusted for mobile WP admin bar */
-    }
-    
-    .seoaudp-sticky-title {
-        padding: 10px;
-    }
+    .seoaudp-sticky-title { padding: 10px; }
 }
 
@@ -3613 +3639 @@
     }
 }
+
+/* Banner Styles */
+.seoaudp-banner {
+    margin: 20px 0;
+    padding: 15px 20px;
+    border-radius: 6px;
+    box-shadow: 0 2px 4px rgba(0,0,0,0.1);
+    position: relative;
+    display: flex;
+    align-items: flex-start;
+    gap: 12px;
+}
+
+.seoaudp-banner--warning {
+    border: 2px solid #ffb900;
+    background: #fff8e5;
+    color: #8a6914;
+}
+
+.seoaudp-banner--info {
+    border: 2px solid #0073aa;
+    background: #e7f3ff;
+    color: #0073aa;
+}
+
+.seoaudp-banner--success {
+    border: 2px solid #00a32a;
+    background: #e7f7e7;
+    color: #00a32a;
+}
+
+.seoaudp-banner--error {
+    border: 2px solid #d63638;
+    background: #fce8e8;
+    color: #d63638;
+}
+
+.seoaudp-banner__icon {
+    flex-shrink: 0;
+    margin-top: 2px;
+    font-size: 20px;
+}
+
+.seoaudp-banner__content {
+    flex: 1;
+    padding-right: 25px;
+}
+
+.seoaudp-banner__title {
+    margin: 0 0 8px 0;
+    font-weight: 600;
+    font-size: 16px;
+}
+
+.seoaudp-banner__message {
+    margin: 0 0 12px 0;
+    font-size: 14px;
+    line-height: 1.5;
+}
+
+.seoaudp-banner__actions {
+    margin: 0;
+}
+
+.seoaudp-banner__close {
+    position: absolute;
+    top: 8px;
+    right: 8px;
+    background: none;
+    border: none;
+    font-size: 18px;
+    cursor: pointer;
+    padding: 4px;
+    line-height: 1;
+    opacity: 0.7;
+    transition: opacity 0.2s;
+}
+
+.seoaudp-banner__close:hover {
+    opacity: 1;
+}

seo-ai-audit-tool/tags/1.1.6/assets/js/seoaudp-script.js

@@ -849 +849 @@
     });
 
-    // Handler to open the Searchers Intention modal
-    jQuery('.seoaudp-open-intention-modal').on('click', function(e) {
+    // Handler to open the Searchers Intention modal (custom modal)
+    jQuery(document).on('click', '.seoaudp-open-intention-modal', function(e) {
         e.preventDefault();
         var pageId = jQuery(this).data('page-id');
         var keywords = window.seoaudp_keywordIntentions[pageId] || [];
 
-        // Generate the modal content
-        var modalContent = jQuery('<div id="seoaudp-search-intention-modal" class="seoaudp-modal"></div>');
-        var table = jQuery('<table class="wp-list-table widefat fixed striped seoaudp-intention-table">').appendTo(modalContent);
-        
-        // Add table header
-        var thead = $('<thead>').appendTo(table);
-        var headerRow = $('<tr>').appendTo(thead);
-        [
-            'Keyword',
-            'Search Volume', 
-            'Search Intent',
-            'SERP Features'
-        ].forEach(function(headerText) {
-            $('<th>').text(headerText).appendTo(headerRow);
-        });
-
-        // Add table body
-        var tbody = $('<tbody>').appendTo(table);
-        
+        var $modal = jQuery('#intention-modal-' + pageId);
+        if (!$modal.length) {
+            return;
+        }
+
+        var $contentContainer = $modal.find('.intention-details-content');
+        $contentContainer.empty();
+
+        var $table = jQuery('<table class="wp-list-table widefat fixed striped seoaudp-intention-table">');
+        var $thead = jQuery('<thead>').appendTo($table);
+        var $headerRow = jQuery('<tr>').appendTo($thead);
+        ['Keyword', 'Search Volume', 'Search Intent', 'SERP Features'].forEach(function(headerText) {
+            jQuery('<th>').text(headerText).appendTo($headerRow);
+        });
+
+        var $tbody = jQuery('<tbody>').appendTo($table);
         if (keywords.length > 0) {
             keywords.forEach(function(item) {
-                var row = $('<tr>').appendTo(tbody);
-                
-                // Keyword column
-                $('<td>').text(item.keyword || 'N/A').appendTo(row);
-                
-                // Search Volume column
-                $('<td>').text(item.volume ? Number(item.volume).toLocaleString() : 'N/A').appendTo(row);
-                
-                // Search Intent column (from database flags)
+                var $row = jQuery('<tr>').appendTo($tbody);
+                jQuery('<td>').text(item.keyword || 'N/A').appendTo($row);
+                jQuery('<td>').text(item.volume ? Number(item.volume).toLocaleString() : 'N/A').appendTo($row);
+
                 var intentV2 = [];
                 if (item.intent_flags) {
@@ -894 +886 @@
                     if (item.intent_flags.transactional) intentV2.push('Transactional');
                 }
-                $('<td>').html(intentV2.length ? intentV2.join('<br>') : 'N/A').appendTo(row);
-                
-                // SERP Features column
-                $('<td>').text(item.serp_features || 'N/A').appendTo(row);
+                jQuery('<td>').html(intentV2.length ? intentV2.join('<br>') : 'N/A').appendTo($row);
+                jQuery('<td>').text(item.serp_features || 'N/A').appendTo($row);
             });
         } else {
-            $('<tr>').append(
-                $('<td colspan="4">').text('No keywords available.')
-            ).appendTo(tbody);
-        }
-
-        // Append modal to body and initialize
-        $('body').append(modalContent);
-        $('#seoaudp-search-intention-modal').dialog({
-            modal: true,
-            width: 'auto',
-            maxWidth: '90%',
-            minWidth: 800,
-            height: 'auto',
-            maxHeight: $(window).height() * 0.9,
-            title: 'Searchers Intention Details',
-            classes: {
-                "ui-dialog": "seoaudp-modal-dialog"
-            },
-            close: function() {
-                $(this).dialog('destroy').remove();
-            }
-        });
+            jQuery('<tr>').append(
+                jQuery('<td colspan="4">').text('No keywords available.')
+            ).appendTo($tbody);
+        }
+
+        $contentContainer.append($table);
+        if (typeof window.seoaudp_openModal === 'function') {
+            window.seoaudp_openModal('intention-modal-' + pageId);
+        } else {
+            $modal.show();
+        }
+    });
+
+    // Close handlers for the custom modal
+    jQuery(document).on('click', '.seoaudp-modal .seoaudp-close', function() {
+        jQuery(this).closest('.seoaudp-modal').hide();
+    });
+    jQuery(document).on('click', '.seoaudp-modal', function(e) {
+        if (jQuery(e.target).is('.seoaudp-modal')) {
+            jQuery(this).hide();
+        }
     });
 
@@ -1011 +1000 @@
     function seoaudp_handleScroll() {
         const stickyHeaders = document.querySelectorAll('.seoaudp-sticky-header');
-        const stickyTitles = document.querySelectorAll('.seoaudp-sticky-title');
-        const headerOffset = 32; // WP admin bar height
+        const headerOffset = 0; // No extra gap above sticky slug
         stickyHeaders.forEach(header => {
-            const headerRect = header.getBoundingClientRect();
             const parentTable = header.closest('table');
             const tableRect = parentTable.getBoundingClientRect();
-            
+            const stickyTitles = header.querySelectorAll('.seoaudp-sticky-title');
             if (tableRect.top < headerOffset) {
                 header.classList.add('seoaudp-is-scrolled');
+                const translateY = Math.abs(tableRect.top - headerOffset);
                 stickyTitles.forEach(title => {
-                    title.style.transform = `translateY(${Math.abs(tableRect.top - headerOffset)}px)`;
+                    title.style.transform = `translateY(${translateY}px)`;
                 });
             } else {

seo-ai-audit-tool/tags/1.1.6/changelog.txt

@@ +1 @@
+= 1.1.6 2025-09-19
+
+Improved: Check message consistency on Page auditor
+Added: Import GSC & Ahrefs checklist
+Improved: GUI improvements
+Fixed: Broken pop-up modal when clicking 'Searchers Intention'
+Added: GPT-5 settings support for respective pro Addon version
+Added: Outdated Pro Addon message when manual update is necessary
+
 = 1.1.5 2025-09-11
 

seo-ai-audit-tool/tags/1.1.6/includes/class-seo-audit-data-import.php

@@ -82 +82 @@
         <div class="wrap seoaudp-container">
             <h1 class="seoaudp-title">Import SEO Metrics</h1>
-            <div class="seoaudp-grid">
-                <div class="seoaudp-card">
-                    <div class="seoaudp-card-header">
-                        <h2>Google Search Console</h2>
+            <div class="seoaudp-grid-two-columns">
+                <div class="seoaudp-column">
+                    <div class="seoaudp-gsc-sub-columns">
+                        <div class="seoaudp-card">
+                            <div class="seoaudp-card-header">
+                                <h2>Google Search Console (Pages)</h2>
                         <?php if ($has_gsc_data): ?>
                             <span class="seoaudp-checkmark" title="Data exists in database">✓ <span class="seoaudp-checkmark-tooltip">Data exists in database</span></span>
@@ -145 +147 @@
                 </div>
 
-                <div class="seoaudp-card">
-                    <div class="seoaudp-card-header">
-                        <h2>Google Search Console</h2>
-                        <?php if ($has_gsc_queries_data): ?>
-                            <span class="seoaudp-checkmark" title="Data exists in database">✓ <span class="seoaudp-checkmark-tooltip">Data exists in database</span></span>
-                        <?php endif; ?>
-                    </div>
-                    <h4>Queries.csv Import</h4>
+                        <div class="seoaudp-card">
+                            <div class="seoaudp-card-header">
+                                <h2>Google Search Console (Queries)</h2>
+                                <?php if ($has_gsc_queries_data): ?>
+                                    <span class="seoaudp-checkmark" title="Data exists in database">✓ <span class="seoaudp-checkmark-tooltip">Data exists in database</span></span>
+                                <?php endif; ?>
+                            </div>
+                            <h4>Queries.csv Import</h4>
                     <div class="seoaudp-steps">
                         <h3>How to export GSC Queries data:</h3>
@@ -205 +207 @@
                         </form>
                     </div>
+                        </div>
+                    </div>
                 </div>
 
-                <div class="seoaudp-card">
-                    <div class="seoaudp-card-header">
-                        <h2>Ahrefs Keywords</h2>
+                <div class="seoaudp-column">
+                    <div class="seoaudp-ahrefs-sub-columns">
+                        <div class="seoaudp-card">
+                            <div class="seoaudp-card-header">
+                                <h2>Ahrefs Keywords</h2>
                         <?php if ($has_ahrefs_data): ?>
                             <span class="seoaudp-checkmark" title="Data exists in database">✓ <span class="seoaudp-checkmark-tooltip">Data exists in database</span></span>
@@ -221 +227 @@
                             <li>Enter your domain</li>
                             <li>Click <b>Organic Keywords</b> (set the target country)</li>
+                            <li>Click <b>By location</b> under Organic Keywords so the Keyword Intent columns are included</li>
                             <li>Click Export</li>
                             <li>Select all, select CSV <span style="color: red;">(UTF-8)</span></li>
@@ -269 +276 @@
                 </div>
 
-                <div class="seoaudp-card">
-                    <div class="seoaudp-card-header">
-                        <h2>Ahrefs Backlinks</h2>
+                        <div class="seoaudp-card">
+                            <div class="seoaudp-card-header">
+                                <h2>Ahrefs Backlinks</h2>
                         <?php if ($has_ahrefs_backlinks_data): ?>
                             <span class="seoaudp-checkmark" title="Data exists in database">✓ <span class="seoaudp-checkmark-tooltip">Data exists in database</span></span>
@@ -327 +334 @@
                         </form>
                     </div>
+                        </div>
+                    </div>
                 </div>
             </div>
@@ -377 +386 @@
             <p>You are about to import <?php echo intval($page_count); ?> pages of GSC data.</p>
             <p><strong>Warning:</strong> This will overwrite any existing GSC data in the database.</p>
+            <?php
+            // Build a lightweight checklist summary based on columns present in first row
+            $first = $processed_data[0];
+            $has_page = isset($first['page']);
+            $has_clicks = isset($first['clicks']);
+            $has_impr = isset($first['impressions']);
+            $has_ctr = isset($first['ctr']);
+            $has_pos = isset($first['position']);
+            ?>
+            <div style="margin:12px 0; padding:12px; border:1px solid #ddd; background:#fff;">
+                <h2 style="margin:0 0 8px;">Import Checklist</h2>
+                <ul style="margin:0 0 8px 18px; list-style:disc;">
+                    <li style="color:<?php echo $has_page ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_page ? '✓' : '✗'; ?> Page URL</li>
+                    <li style="color:<?php echo $has_clicks ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_clicks ? '✓' : '✗'; ?> Clicks</li>
+                    <li style="color:<?php echo $has_impr ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_impr ? '✓' : '✗'; ?> Impressions</li>
+                    <li style="color:<?php echo $has_ctr ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_ctr ? '✓' : '✗'; ?> CTR</li>
+                    <li style="color:<?php echo $has_pos ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_pos ? '✓' : '✗'; ?> Position</li>
+                </ul>
+                <div style="font-size:12px;color:#555;">Rows detected: <?php echo intval($page_count); ?></div>
+            </div>
             
             <form method="post" action="<?php echo esc_url(admin_url('admin-post.php')); ?>">
@@ -389 +418 @@
 
     private function seoaudp_render_ahrefs_confirmation_page() {
-        $processed_data = get_transient('seoaudp_ahrefs_processed_data');
+        $import_key = isset($_GET['import_key']) ? sanitize_text_field($_GET['import_key']) : get_transient('seoaudp_ahrefs_import_key');
+        $processed_data = $import_key ? get_transient('seoaudp_ahrefs_processed_' . $import_key) : get_transient('seoaudp_ahrefs_processed_data');
         if (!$processed_data) {
             wp_die('No data to import. Please upload a CSV file first.');
@@ -400 +430 @@
             <p><strong>Warning:</strong> This will overwrite any existing Ahrefs data in the database.</p>
             
+            <?php 
+            $import_key = isset($_GET['import_key']) ? sanitize_text_field($_GET['import_key']) : get_transient('seoaudp_ahrefs_import_key');
+            $meta = $import_key ? get_transient('seoaudp_ahrefs_import_meta_' . $import_key) : get_transient('seoaudp_ahrefs_import_meta');
+            $validation_errors = $import_key ? get_transient('seoaudp_ahrefs_validation_errors_' . $import_key) : get_transient('seoaudp_ahrefs_validation_errors');
+            if (is_array($meta)) { 
+                $missing = array_map('esc_html', $meta['missing_optional'] ?? array());
+                $present_required = array_map('esc_html', $meta['present_required'] ?? array());
+                $intent_stats = $meta['intent_stats'] ?? array();
+            ?>
+                <div style="margin:12px 0; padding:12px; border:1px solid #ddd; background:#fff;">
+                    <h2 style="margin:0 0 8px;">Import Checklist</h2>
+                    <ul style="margin:0 0 8px 18px; list-style:disc;">
+                        <?php foreach ($present_required as $req): ?>
+                            <li style="color:#2e7d32;">✓ Required present: <?php echo $req; ?></li>
+                        <?php endforeach; ?>
+                        <?php if (!empty($missing)): ?>
+                            <?php foreach ($missing as $miss): ?>
+                                <li style="color:#b71c1c;">✗ Optional missing: <?php echo $miss; ?></li>
+                            <?php endforeach; ?>
+                        <?php else: ?>
+                            <li style="color:#2e7d32;">✓ All optional columns detected</li>
+                        <?php endif; ?>
+                    </ul>
+                    
+                    <?php if (!empty($intent_stats)): ?>
+                        <div style="margin:8px 0; padding:8px; background:#f8f9fa; border-left:3px solid #007cba;">
+                            <strong>Keyword Intent Data Summary:</strong><br>
+                            <small>
+                                • Rows with intent data: <?php echo intval($intent_stats['rows_with_intent_data'] ?? 0); ?><br>
+                                • Rows missing intent data: <?php echo intval($intent_stats['rows_missing_intent_data'] ?? 0); ?><br>
+                                <?php if (($intent_stats['invalid_intent_values'] ?? 0) > 0): ?>
+                                    • <span style="color:#d63384;">Invalid intent values found: <?php echo intval($intent_stats['invalid_intent_values']); ?></span><br>
+                                <?php endif; ?>
+                            </small>
+                        </div>
+                    <?php endif; ?>
+                    
+                    <?php if (!empty($validation_errors) && is_array($validation_errors)): ?>
+                        <div style="margin:8px 0; padding:8px; background:#fff3cd; border-left:3px solid #ffc107; max-height:150px; overflow-y:auto;">
+                            <strong style="color:#856404;">⚠️ Intent Data Validation Warnings:</strong><br>
+                            <small style="color:#856404;">
+                                <?php foreach (array_slice($validation_errors, 0, 10) as $error): ?>
+                                    • <?php echo esc_html($error); ?><br>
+                                <?php endforeach; ?>
+                                <?php if (count($validation_errors) > 10): ?>
+                                    <em>... and <?php echo count($validation_errors) - 10; ?> more warnings.</em><br>
+                                <?php endif; ?>
+                                <strong>These rows will use default intent values (FALSE).</strong>
+                            </small>
+                        </div>
+                    <?php endif; ?>
+                    
+                    <div style="font-size:12px;color:#555;">Valid rows: <?php echo intval($meta['valid_rows'] ?? 0); ?> / Total rows: <?php echo intval($meta['total_rows'] ?? 0); ?></div>
+                </div>
+            <?php } ?>
+
             <form method="post" action="<?php echo esc_url(admin_url('admin-post.php')); ?>">
                 <input type="hidden" name="action" value="seoaudp_confirm_ahrefs_import">
+                <input type="hidden" name="import_key" value="<?php echo isset($import_key) ? esc_attr($import_key) : ''; ?>">
                 <?php wp_nonce_field('seoaudp_confirm_ahrefs_import', 'seoaudp_ahrefs_confirm_nonce'); ?>
                 <?php submit_button('Confirm Import'); ?>
@@ -421 +508 @@
             <p>You are about to import <?php echo intval($query_count); ?> queries of GSC data.</p>
             <p><strong>Warning:</strong> This will overwrite any existing GSC queries data in the database.</p>
+            <?php
+            $first = $processed_data[0];
+            $has_query = isset($first['query']);
+            $has_clicks = isset($first['clicks']);
+            $has_impr = isset($first['impressions']);
+            $has_ctr = isset($first['ctr']);
+            $has_pos = isset($first['position']);
+            ?>
+            <div style="margin:12px 0; padding:12px; border:1px solid #ddd; background:#fff;">
+                <h2 style="margin:0 0 8px;">Import Checklist</h2>
+                <ul style="margin:0 0 8px 18px; list-style:disc;">
+                    <li style="color:<?php echo $has_query ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_query ? '✓' : '✗'; ?> Query</li>
+                    <li style="color:<?php echo $has_clicks ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_clicks ? '✓' : '✗'; ?> Clicks</li>
+                    <li style="color:<?php echo $has_impr ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_impr ? '✓' : '✗'; ?> Impressions</li>
+                    <li style="color:<?php echo $has_ctr ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_ctr ? '✓' : '✗'; ?> CTR</li>
+                    <li style="color:<?php echo $has_pos ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_pos ? '✓' : '✗'; ?> Position</li>
+                </ul>
+                <div style="font-size:12px;color:#555;">Rows detected: <?php echo intval($query_count); ?></div>
+            </div>
             
             <form method="post" action="<?php echo esc_url(admin_url('admin-post.php')); ?>">
@@ -651 +757 @@
         // Remove header row if it exists
         $header = array_shift($csv_data);
-
-        // Check if the header contains expected columns
-        $required_columns = ['Keyword', 'Volume', 'KD', 'CPC', 'Current position', 'Current URL', 'SERP features'];
-        $traffic_column = in_array('Organic traffic', $header) ? 'Organic traffic' : 'Current organic traffic';
-        $required_columns[] = $traffic_column;
-
-        $missing_columns = array_diff($required_columns, $header);
-
-        if (!empty($missing_columns)) {
-            wp_die('The CSV file is missing the following required columns: ' . implode(', ', array_map('esc_html', $missing_columns)));
-        }
-
-        // Get column indexes
+        if (!$header || !is_array($header)) {
+            wp_die('Invalid CSV: missing header row.');
+        }
+        $header = array_map('trim', $header);
         $column_indexes = array_flip($header);
+
+        // Required columns (super mandatory)
+        $required_columns = ['Keyword', 'Current URL'];
+        $missing_required = array_values(array_filter($required_columns, function($c) use ($column_indexes){ return !isset($column_indexes[$c]); }));
+
+        // Optional columns (nice-to-haves)
+        $optional_columns = ['Volume','KD','CPC','Current position','SERP features','Organic traffic','Current organic traffic','Branded','Local','Navigational','Informational','Commercial','Transactional'];
+        $missing_optional = array_values(array_filter($optional_columns, function($c) use ($column_indexes){ return !isset($column_indexes[$c]); }));
+
+        if (!empty($missing_required)) {
+            wp_die('The CSV file is missing required columns: ' . implode(', ', array_map('esc_html', $missing_required)));
+        }
+
+        // Traffic column can be either of these
+        $traffic_column = isset($column_indexes['Organic traffic']) ? 'Organic traffic' : (isset($column_indexes['Current organic traffic']) ? 'Current organic traffic' : null);
 
         // Define the boolean columns we expect
@@ -675 +787 @@
             'Transactional'
         ];
-        foreach ($csv_data as $row) {
-            // Check if the row has the expected number of columns
-            if (count($row) !== count($header)) {
-                continue;
-            }
+
+        $validation_errors = array();
+        $intent_validation_stats = array(
+            'rows_with_intent_data' => 0,
+            'rows_missing_intent_data' => 0,
+            'invalid_intent_values' => 0
+        );
+
+        foreach ($csv_data as $row_index => $row) {
+            if (empty($row)) { continue; }
+            // Skip if required fields are empty
+            if (!isset($row[$column_indexes['Keyword']]) || !isset($row[$column_indexes['Current URL']])) { continue; }
 
             $url = trim($row[$column_indexes['Current URL']]);
-            if (!empty($url)) {
-                $data = array(
-                    'keyword' => trim($row[$column_indexes['Keyword']]),
-                    'volume' => intval($row[$column_indexes['Volume']]),
-                    'kd' => intval($row[$column_indexes['KD']]),
-                    'cpc' => floatval($row[$column_indexes['CPC']]),
-                    'traffic' => intval($row[$column_indexes[$traffic_column]]),
-                    'position' => intval($row[$column_indexes['Current position']]),
-                    'page_url' => $url,
-                    'serp_features' => trim($row[$column_indexes['SERP features']]),
-                );
-
-                // Process boolean columns
-                foreach ($boolean_columns as $column) {
-                    if (isset($column_indexes[$column])) {
-                        $value = trim($row[$column_indexes[$column]]);
-                        // Convert various TRUE values to 1, everything else to 0
-                        $data[strtolower($column)] = in_array(strtoupper($value), ['TRUE', '1', 'YES', 'Y'], true) ? 1 : 0;
+            if ($url === '') { continue; }
+
+            $data = array(
+                'keyword'       => trim($row[$column_indexes['Keyword']]),
+                'volume'        => isset($column_indexes['Volume']) ? intval($row[$column_indexes['Volume']] ?? 0) : 0,
+                'kd'            => isset($column_indexes['KD']) ? intval($row[$column_indexes['KD']] ?? 0) : 0,
+                'cpc'           => isset($column_indexes['CPC']) ? floatval($row[$column_indexes['CPC']] ?? 0) : 0.0,
+                'traffic'       => $traffic_column ? intval($row[$column_indexes[$traffic_column]] ?? 0) : 0,
+                'position'      => isset($column_indexes['Current position']) ? intval($row[$column_indexes['Current position']] ?? 0) : 0,
+                'page_url'      => $url,
+                'serp_features' => isset($column_indexes['SERP features']) ? trim($row[$column_indexes['SERP features']] ?? '') : '',
+            );
+
+            // Validate and process intent boolean columns
+            $has_intent_data = false;
+            $intent_validation_errors = array();
+            
+            foreach ($boolean_columns as $column) {
+                $key = strtolower($column);
+                if (isset($column_indexes[$column])) {
+                    $value = trim($row[$column_indexes[$column]] ?? '');
+                    
+                    // Check if this row has any intent data
+                    if ($value !== '' && $value !== '0' && strtoupper($value) !== 'FALSE') {
+                        $has_intent_data = true;
                     }
+                    
+                    // Validate intent column values
+                    $valid_values = ['TRUE', 'FALSE', '1', '0', 'YES', 'NO', 'Y', 'N', ''];
+                    if ($value !== '' && !in_array(strtoupper($value), $valid_values, true)) {
+                        $intent_validation_errors[] = "Row " . ($row_index + 2) . ": Invalid value '{$value}' in column '{$column}'. Expected TRUE/FALSE, 1/0, YES/NO, or empty.";
+                        $intent_validation_stats['invalid_intent_values']++;
+                    }
+                    
+                    // Set boolean value
+                    $data[$key] = in_array(strtoupper($value), ['TRUE','1','YES','Y'], true) ? 1 : 0;
+                } else {
+                    $data[$key] = 0;
                 }
-
-                $processed_data[] = $data;
-            }
+            }
+
+            // Track intent data statistics
+            if ($has_intent_data) {
+                $intent_validation_stats['rows_with_intent_data']++;
+            } else {
+                $intent_validation_stats['rows_missing_intent_data']++;
+            }
+
+            // Add any validation errors for this row
+            if (!empty($intent_validation_errors)) {
+                $validation_errors = array_merge($validation_errors, $intent_validation_errors);
+            }
+
+            $processed_data[] = $data;
         }
 
@@ -711 +861 @@
         }
 
+        // Handle validation errors - show warnings but don't stop import
+        if (!empty($validation_errors)) {
+            $error_message = '<strong>Intent Data Validation Warnings:</strong><br>' . implode('<br>', array_slice($validation_errors, 0, 10));
+            if (count($validation_errors) > 10) {
+                $error_message .= '<br><em>... and ' . (count($validation_errors) - 10) . ' more warnings.</em>';
+            }
+            $error_message .= '<br><br><strong>These rows will be imported with default intent values (FALSE). Continue?</strong>';
+            
+            // Store validation errors in transient for confirmation page
+            set_transient('seoaudp_ahrefs_validation_errors', $validation_errors, HOUR_IN_SECONDS);
+        }
+
+        // Save import meta for checklist UI on confirmation
+        $import_meta = array(
+            'total_rows'            => count($csv_data),
+            'valid_rows'            => count($processed_data),
+            'missing_optional'      => $missing_optional,
+            'present_required'      => $required_columns,
+            'intent_stats'          => $intent_validation_stats,
+            'has_validation_errors' => !empty($validation_errors),
+            'validation_error_count' => count($validation_errors),
+        );
+        set_transient('seoaudp_ahrefs_import_meta', $import_meta, HOUR_IN_SECONDS);
+
+        // Generate a unique import key so multiple imports won't collide and to reduce cache misses
+        $import_key = wp_generate_password(12, false);
+        set_transient('seoaudp_ahrefs_import_key', $import_key, HOUR_IN_SECONDS);
+        set_transient('seoaudp_ahrefs_import_meta_' . $import_key, $import_meta, HOUR_IN_SECONDS);
+        // Also store validation errors with the keyed name if present
+        $existing_validation_errors = get_transient('seoaudp_ahrefs_validation_errors');
+        if (!empty($existing_validation_errors)) {
+            set_transient('seoaudp_ahrefs_validation_errors_' . $import_key, $existing_validation_errors, HOUR_IN_SECONDS);
+        }
+
         // Check if existing data is present
         $existing_data = $this->db->get_ahrefs_data_count();
@@ -716 +900 @@
         if ($existing_data && $existing_data > 0) {
             // Store the processed data in a transient for later use
-            set_transient('seoaudp_ahrefs_processed_data', $processed_data, 60 * 60); // 1 hour expiration
+            set_transient('seoaudp_ahrefs_processed_data', $processed_data, 60 * 60); // legacy key for backward compatibility
+            set_transient('seoaudp_ahrefs_processed_' . $import_key, $processed_data, 60 * 60);
             
             // Redirect to confirmation page
-            wp_redirect(add_query_arg(['page' => 'seo-audit-gsc', 'step' => 'confirm_ahrefs'], admin_url('admin.php')));
+            wp_redirect(add_query_arg(['page' => 'seo-audit-gsc', 'step' => 'confirm_ahrefs', 'import_key' => $import_key], admin_url('admin.php')));
             exit;
         } else {
@@ -743 +928 @@
         check_admin_referer('seoaudp_confirm_ahrefs_import', 'seoaudp_ahrefs_confirm_nonce');
 
-        $processed_data = get_transient('seoaudp_ahrefs_processed_data');
+        $import_key = isset($_POST['import_key']) ? sanitize_text_field($_POST['import_key']) : get_transient('seoaudp_ahrefs_import_key');
+        $processed_data = $import_key ? get_transient('seoaudp_ahrefs_processed_' . $import_key) : get_transient('seoaudp_ahrefs_processed_data');
 
         if (!$processed_data) {
@@ -756 +942 @@
 
         delete_transient('seoaudp_ahrefs_processed_data');
+        if ($import_key) {
+            delete_transient('seoaudp_ahrefs_processed_' . $import_key);
+            delete_transient('seoaudp_ahrefs_import_meta_' . $import_key);
+            delete_transient('seoaudp_ahrefs_validation_errors_' . $import_key);
+        }
+        delete_transient('seoaudp_ahrefs_import_meta');
+        delete_transient('seoaudp_ahrefs_validation_errors');
         if ($result) {
             update_option('seoaudp_ahrefs_last_import', current_time('mysql'));
@@ -868 +1061 @@
         // Import new data
         $result = $this->db->seoaudp_store_gsc_queries_data($processed_data);
-
+        
         delete_transient('seoaudp_gsc_queries_processed_data');
 

seo-ai-audit-tool/tags/1.1.6/includes/class-seo-audit-db.php

@@ -738 +738 @@
         global $wpdb;
         $this->ensure_table_exists($this->ahrefs_keywords_table);
+        // Safety guard: ensure page_id is nullable to allow external URLs
+        $col_info = $wpdb->get_row("SHOW COLUMNS FROM {$this->ahrefs_keywords_table} LIKE 'page_id'");
+        if ($col_info && strtoupper($col_info->Null) === 'NO') {
+            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared
+            $wpdb->query("ALTER TABLE {$this->ahrefs_keywords_table} MODIFY page_id bigint(20) DEFAULT NULL");
+        }
         
         $success = true;
@@ -909 +915 @@
         $sql = "CREATE TABLE IF NOT EXISTS $table_name (
             id mediumint(9) NOT NULL AUTO_INCREMENT,
-            page_id bigint(20) NOT NULL,
+            page_id bigint(20) DEFAULT NULL,
             keyword varchar(255) NOT NULL,
             volume int(11) NOT NULL,
@@ -932 +938 @@
         dbDelta($sql);
 
+        // Ensure page_id allows NULL in case older installs have NOT NULL
+        $col_info = $wpdb->get_row("SHOW COLUMNS FROM $table_name LIKE 'page_id'");
+        if ($col_info && strtoupper($col_info->Null) === 'NO') {
+            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared
+            $wpdb->query("ALTER TABLE $table_name MODIFY page_id bigint(20) DEFAULT NULL");
+        }
+
         // Add new columns if they don't exist
         $new_columns = array(
@@ -1187 +1200 @@
                 }
             } else {
-                // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Base query is escaped
-                $query = $wpdb->prepare($base_query, []);
+                // No dynamic placeholders; use the base query directly
+                // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Base query is built safely above
+                $query = $base_query;
             }
             

seo-ai-audit-tool/tags/1.1.6/includes/class-seo-audit-settings-page.php

@@ -31 +31 @@
         add_action('wp_ajax_seoaudp_clear_ai_logs', array($this, 'seoaudp_clear_ai_logs'));
         $this->db = new \SEO_Audit_Tool\SEO_Audit_DB();
+    }
+
+    /**
+     * Check if GPT-5 support is enabled (pro version 1.1.4 or greater)
+     */
+    private function is_gpt_5_support_enabled() {
+        if (!seoaudp_pro_active()) {
+            return false;
+        }
+        
+        if (defined('SEO_AUDIT_PRO_ADDON_VERSION')) {
+            $pro_version = SEO_AUDIT_PRO_ADDON_VERSION;
+            return version_compare($pro_version, '1.1.4', '>=');
+        }
+        
+        return false;
     }
 
@@ -182 +198 @@
                             title="Select the AI model that best fits your needs - newer models generally provide better results but may cost more"
                             <?php echo seoaudp_pro_active() ? '' : 'disabled="disabled"'; ?>>
-                        <!-- <option value="gpt-5" <!?php selected(get_option('seoaudp_openai_model'), 'gpt-5'); ?>>GPT-5 (latest)</option>
-                        <option value="gpt-5-mini" <!?php selected(get_option('seoaudp_openai_model'), 'gpt-5-mini'); ?>>GPT-5 Mini (recommended)</option> -->
-                        <option value="gpt-4.1-mini" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1-mini'); ?>>GPT-4.1 Mini (recommended)</option>
-                        <option value="gpt-4.1" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1'); ?>>GPT-4.1</option>
-                        <option value="gpt-4.1-nano" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1-nano'); ?>>GPT-4.1 Nano</option>
-                        <option value="o4-mini" <?php selected(get_option('seoaudp_openai_model'), 'o4-mini'); ?>>O4 Mini</option>
-                        <option value="gpt-4o" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4o'); ?>>GPT-4o</option>
+                        <?php 
+                        $is_gpt_5_support_enabled = $this->is_gpt_5_support_enabled();
+                        
+                        if ($is_gpt_5_support_enabled) {
+                            // Show only GPT-5 models for version 1.1.4 or greater
+                            ?>
+                            <option value="gpt-5-mini" <?php selected(get_option('seoaudp_openai_model'), 'gpt-5-mini'); ?>>GPT-5 Mini (recommended)</option>
+                            <option value="gpt-5" <?php selected(get_option('seoaudp_openai_model'), 'gpt-5'); ?>>GPT-5 (latest)</option>
+                            <?php
+                        } else {
+                            // Show all models except GPT-5 for older versions
+                            ?>
+                            <option value="gpt-4.1-mini" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1-mini'); ?>>GPT-4.1 Mini (recommended)</option>
+                            <option value="gpt-4.1" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1'); ?>>GPT-4.1</option>
+                            <option value="gpt-4.1-nano" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1-nano'); ?>>GPT-4.1 Nano</option>
+                            <option value="o4-mini" <?php selected(get_option('seoaudp_openai_model'), 'o4-mini'); ?>>O4 Mini</option>
+                            <option value="gpt-4o" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4o'); ?>>GPT-4o</option>
+                            <?php
+                        }
+                        ?>
                     </select>
                 </div>

seo-ai-audit-tool/tags/1.1.6/includes/models/class-seo-audit-model.php

@@ -275 +275 @@
         return array(
             'status' => $status,
-            'message' => implode(". ", $message),
+            'message' => $status === 'pass' ? "Pass" : "Fail",
             'details' => "<strong>Title:</strong> {$title}<br>" .
                         "<strong>Keyword:</strong> {$keyword}<br>" .
@@ -367 +367 @@
         return array(
             'status' => $descLength > 50 && $descLength <= 160 && $hasKeyword ? 'pass' : 'fail',
-            'message' => sprintf(
-                "Length: %d chars. Keyword match: %.1f%%", 
-                $descLength, 
-                $matchPercentage
-            ),
+            'message' => $descLength > 50 && $descLength <= 160 && $hasKeyword ? "Pass" : "Fail",
             'details' => "<strong>Description:</strong> " . $highlightedDesc . "<br>" .
                         "<strong>Source:</strong> " . esc_html($description_source) . "<br>" .
@@ -457 +453 @@
         return array(
             'status' => !empty($h1_content) && $hasKeyword ? 'pass' : 'fail',
-            'message' => sprintf(
-                "H1 %s. Keyword match: %.1f%%",
-                empty($h1_content) ? "not found" : "found",
-                $matchPercentage
-            ),
+            'message' => !empty($h1_content) && $hasKeyword ? "Pass" : "Fail",
             'details' => sprintf(
                 "<strong>H1 Tag (%s):</strong> %s<br><strong>Keyword:</strong> %s",
@@ -521 +513 @@
         return array(
             'status' => $hasKeyword ? 'pass' : 'fail',
-            'message' => sprintf(
-                "Keyword in first H2: %.1f%%",
-                $matchPercentage
-            ),
+            'message' => $hasKeyword ? "Pass" : "Fail",
             'details' => "<strong>First H2:</strong> {$highlightedH2}<br><strong>Keyword:</strong> " . esc_html($keyword)
         );
@@ -573 +562 @@
         return array(
             'status' => $hasKeyword ? 'pass' : 'fail',
-            'message' => sprintf(
-                "Keyword in first 100 words: %.1f%%",
-                $matchPercentage
-            ),
+            'message' => $hasKeyword ? "Pass" : "Fail",
             'details' => "<strong>First 100 words:</strong><br>" . $highlightedContent . "<br><br><strong>Keyword:</strong> " . esc_html($keyword)
         );
@@ -586 +572 @@
         return array(
             'status' => $wordCount >= 300 ? 'pass' : 'fail',
-            'message' => "Word count: {$wordCount}",
+            'message' => $wordCount >= 300 ? "Pass" : "Fail",
             'details' => "<strong>Word count:</strong> {$wordCount}<br><strong>Recommended minimum:</strong> 300 words"
         );
@@ -599 +585 @@
         return array(
             'status' => $days <= 90 ? 'pass' : 'fail',
-            'message' => "Last modified: {$lastModified} ({$days} days ago)",
+            'message' => $days <= 90 ? "Pass" : "Fail",
             'details' => "<strong>Last modified:</strong> {$lastModified}<br><strong>Days since last update:</strong> {$days}<br><strong>Recommendation:</strong> " . ($days <= 90 ? "Content is up to date" : "Content may need updating")
         );
@@ -633 +619 @@
         return array(
             'status' => $bodyLinks > 0 ? 'pass' : 'fail',
-            'message' => $bodyLinks > 0 ? "Found {$bodyLinks} internal link(s)" : "No internal links found - Add internal links to improve SEO and user navigation",
+            'message' => $bodyLinks > 0 ? $bodyLinks : "",
             'details' => $details
         );
@@ -667 +653 @@
         return array(
             'status' => $uniqueExternalLinks > 0 ? 'pass' : 'fail',
-            'message' => $uniqueExternalLinks > 0 ? "Found {$uniqueExternalLinks} external link(s)" : "No external links found - Consider adding links to authoritative sources",
+            'message' => $uniqueExternalLinks > 0 ? $uniqueExternalLinks : "",
             'details' => $details
         );
@@ -743 +729 @@
 
         $status = ($imagesWithAlt === $totalImages && $imagesWithKeyword > 0) ? 'pass' : 'fail';
-        $message = "Images with alt text: {$imagesWithAlt}/{$totalImages}";
+        $message = $status === 'pass' ? "Pass" : "Fail";
         $details = "<strong>Total images:</strong> {$totalImages}<br><strong>With alt:</strong> {$imagesWithAlt}<br><strong>Without alt:</strong> {$imagesWithoutAlt}<br>"
                  . "<strong>With keyword:</strong> {$imagesWithKeyword}<br><strong>WebP format:</strong> {$webpImages}<br><br>"
@@ -786 +772 @@
         return array(
             'status' => count($keywordRichImages) > 0 ? 'pass' : 'fail',
-            'message' => "Images with keyword in filename: " . count($keywordRichImages) . "/" . count($images),
+            'message' => count($keywordRichImages) > 0 ? "Pass" : "Fail",
             'details' => $details
         );
@@ -825 +811 @@
         
         $status = $allWebP ? 'pass' : 'fail';
-        $message = $allWebP ? "All images are in WebP format" : "Not all images are in WebP format";
+        $message = $status === 'pass' ? "Pass" : "Fail";
         
         $details = "<strong>WebP images:</strong> {$webpCount}<br>"
@@ -925 +911 @@
         return array(
             'status' => $hasKeyword ? 'pass' : 'fail',
-            'message' => sprintf(
-                "%s (%.1f%% match)", 
-                $hasKeyword ? "Keyword found in URL" : "Keyword not sufficiently represented in URL",
-                $matchPercentage
-            ),
+            'message' => $hasKeyword ? "Pass" : "Fail",
             'details' => "<strong>URL:</strong> {$highlightedUrl}<br>" .
                         "<strong>Keyword:</strong> {$keyword}<br>" .

seo-ai-audit-tool/tags/1.1.6/includes/views/class-seo-audit-view.php

@@ -110 +110 @@
         <div class="wrap seoaudp-wrapper">
             <?php include(plugin_dir_path(__FILE__) . 'partials/header-partial.php'); ?>
+            
+            <?php if (seoaudp_is_pro_version_outdated()): ?>
+            <div class="seoaudp-banner seoaudp-banner--warning">
+                <div class="seoaudp-banner__icon">
+                    <span class="dashicons dashicons-warning"></span>
+                </div>
+                <div class="seoaudp-banner__content">
+                    <h4 class="seoaudp-banner__title">
+                        SEO AI Audit Tool Pro Addon Update Required
+                    </h4>
+                    <p class="seoaudp-banner__message">
+                        Your SEO AI Audit Tool <strong>Pro Addon</strong> is outdated. If you're having trouble updating from the plugins page, 
+                        download the new version from your <a href="https://seo-ai-audit-tool.designful.ca/my-account/" target="_blank"><strong>Members portal</strong></a>.
+                    </p>
+                    <p class="seoaudp-banner__actions">
+                        <a href="https://seo-ai-audit-tool.designful.ca/my-account/" 
+                           target="_blank" 
+                           class="button button-primary">
+                            <span class="dashicons dashicons-external" style="margin-right: 5px; font-size: 14px; vertical-align: middle;"></span>
+                            Go to Members Portal
+                        </a>
+                    </p>
+                </div>
+            </div>
+            <?php endif; ?>
+            
             <div class="seoaudp-wrapper-body">
             <input type="hidden" id="seoaudp-page-filter" value="<?php echo esc_attr(sanitize_text_field($_GET['post_type'] ?? 'all')); ?>">

seo-ai-audit-tool/tags/1.1.6/includes/views/partials/default-category-rows-partial.php

@@ -29 +29 @@
                     <?php 
                     if (in_array($item, ['Internal Link Count', 'External Link Count'])) {
-                        echo esc_html(ucfirst($result['status']) . ' (' . $result['message'] . ')');
+                        if (!empty($result['message'])) {
+                            echo esc_html(ucfirst($result['status']) . ' (' . $result['message'] . ')');
+                        } else {
+                            echo esc_html(ucfirst($result['status']));
+                        }
                     } else {
                         echo esc_html(ucfirst($result['status']));

seo-ai-audit-tool/tags/1.1.6/includes/views/partials/table-header-partial.php

@@ -18 +18 @@
                         </label>
                         <?php } ?>
-                        <a href="<?php echo esc_url(get_permalink($page->ID)); ?>" target="_blank">
-                            <?php echo esc_html($page->post_title); ?><br>
+                        <a href="<?php echo esc_url(get_permalink($page->ID)); ?>" target="_blank" title="<?php echo esc_attr($page->post_title); ?>">
+                            <span class="seoaudp-page-title-text" title="<?php echo esc_attr($page->post_title); ?>"><?php echo esc_html($page->post_title); ?></span><br>
                             <small><?php echo esc_html($page->post_name); ?> <span class="dashicons dashicons-admin-links"></span></small>
                         </a>

seo-ai-audit-tool/tags/1.1.6/readme.md

@@ -2 +2 @@
 Contributors: Designful
 Plugin URL: https://seo-ai-audit-tool.designful.ca/
-Version: 1.1.5
+Version: 1.1.6
 Tags: seo audit, ai seo, conversion optimization, content analysis, search intent
 Requires at least: 4.0
 Tested up to: 6.8
-Stable tag: 1.1.5
+Stable tag: 1.1.6
 Requires PHP: 7.4
 License: GPLv2 or later

seo-ai-audit-tool/tags/1.1.6/seo-ai-audit-tool.code-workspace

@@ -8 +8 @@
         }
     ],
-    "settings": {}
+    "settings": {
+        "workbench.colorCustomizations": {
+            "titleBar.activeBackground": "#8f6cff",
+            "titleBar.activeForeground": "#ffffff",
+            "titleBar.inactiveBackground": "#8f6cff",
+            "titleBar.inactiveForeground": "#ffffff",
+            "statusBar.background": "#5a1d5a",
+            "statusBar.foreground": "#e7e7e7"
+        }
+    }
 }

seo-ai-audit-tool/tags/1.1.6/seo-ai-audit-tool.php

@@ -4 +4 @@
  * Plugin URI: https://designful.ca/apps/seo-ai-audit-tool/
  * Description: A WordPress plugin to audit SEO elements of pages and perform AI-powered content analysis
- * Version:     1.1.5
+ * Version:     1.1.6
  * Author:      Designful
  * License:     GPL2
@@ -20 +20 @@
 define('SEOAUDP_PLUGIN_DIR', plugin_dir_path(__FILE__));
 define('SEOAUDP_PLUGIN_URL', plugin_dir_url(__FILE__));
-define('SEOAUDP_PLUGIN_VERSION', '1.1.5');
+define('SEOAUDP_PLUGIN_VERSION', '1.1.6');
 define('SEOAUDP_PLUGIN_BETA_VERSION', false);
-define('SEOAUDP_DB_VERSION', '1.8');
+define('SEOAUDP_DB_VERSION', '1.9');
 define('SEOAUDP_EDD_ITEM_ID', 307);
 define('SEOAUDP_STORE_URL', 'https://seo-ai-audit-tool.designful.ca');
@@ -390 +390 @@
 }
 
+function seoaudp_is_pro_version_outdated() {
+    if (!seoaudp_pro_active()) {
+        return false;
+    }
+    
+    if (defined('SEO_AUDIT_PRO_ADDON_VERSION')) {
+        $pro_version = SEO_AUDIT_PRO_ADDON_VERSION;
+        return version_compare($pro_version, '1.1.2', '<');
+    }
+    
+    return false;
+}
+
 function seoaudp_init_hooks() {
     add_action('admin_print_scripts', 'seoaudp_hide_admin_page');

seo-ai-audit-tool/trunk/assets/css/seoaudp-style.css

@@ -803 +803 @@
 }
 
+.seoaudp-grid-two-columns {
+    display: grid;
+    grid-template-columns: 1fr 1fr;
+    gap: 20px;
+}
+
+.seoaudp-grid-two-columns .seoaudp-column { display: contents; }
+
+.seoaudp-gsc-sub-columns { display: contents; }
+
+.seoaudp-ahrefs-sub-columns { display: contents; }
+
+/* Responsive design for smaller screens */
+@media (max-width: 768px) {
+    .seoaudp-grid-two-columns {
+        grid-template-columns: 1fr;
+    }
+}
+
 .seoaudp-form-group {
     margin-bottom: 20px;
@@ -1402 +1421 @@
     color: rgba(26, 41, 72, 1);
     font-weight: 500;
+}
+.seoaudp-page-title-text{
+    display: inline-block;
+    max-width: 220px;
+    white-space: nowrap;
+    overflow: hidden;
+    text-overflow: ellipsis;
+    vertical-align: bottom;
 }
 .seoaudp-page-title-container a small{
@@ -1907 +1934 @@
 
 .seoaudp-sticky-title {
-    position: relative;
+    position: relative; /* allow JS transform without native sticky gaps */
     transition: transform 0.02s ease-out;
     background: white;
@@ -1923 +1950 @@
     box-shadow: 0 2px 4px rgba(0, 0, 0, 0.3);
 }
+.seoaudp-is-scrolled .seoaudp-sticky-title .seoaudp-checkbox { display: none; }
+.seoaudp-is-scrolled .seoaudp-sticky-title br { display: none; }
+/* Show only the slug on sticky */
+.seoaudp-is-scrolled .seoaudp-sticky-title .seoaudp-page-title-text { display: none; }
+.seoaudp-is-scrolled .seoaudp-sticky-title a small { display: inline-block; font-size: 13px; }
 .seoaudp-page-name-column {
     position: relative;
@@ -1957 +1989 @@
 /* Responsive adjustments */
 @media screen and (max-width: 782px) {
-    .seoaudp-sticky-header {
-        top: 46px; /* Adjusted for mobile WP admin bar */
-    }
-    
-    .seoaudp-sticky-title {
-        padding: 10px;
-    }
+    .seoaudp-sticky-title { padding: 10px; }
 }
 
@@ -3613 +3639 @@
     }
 }
+
+/* Banner Styles */
+.seoaudp-banner {
+    margin: 20px 0;
+    padding: 15px 20px;
+    border-radius: 6px;
+    box-shadow: 0 2px 4px rgba(0,0,0,0.1);
+    position: relative;
+    display: flex;
+    align-items: flex-start;
+    gap: 12px;
+}
+
+.seoaudp-banner--warning {
+    border: 2px solid #ffb900;
+    background: #fff8e5;
+    color: #8a6914;
+}
+
+.seoaudp-banner--info {
+    border: 2px solid #0073aa;
+    background: #e7f3ff;
+    color: #0073aa;
+}
+
+.seoaudp-banner--success {
+    border: 2px solid #00a32a;
+    background: #e7f7e7;
+    color: #00a32a;
+}
+
+.seoaudp-banner--error {
+    border: 2px solid #d63638;
+    background: #fce8e8;
+    color: #d63638;
+}
+
+.seoaudp-banner__icon {
+    flex-shrink: 0;
+    margin-top: 2px;
+    font-size: 20px;
+}
+
+.seoaudp-banner__content {
+    flex: 1;
+    padding-right: 25px;
+}
+
+.seoaudp-banner__title {
+    margin: 0 0 8px 0;
+    font-weight: 600;
+    font-size: 16px;
+}
+
+.seoaudp-banner__message {
+    margin: 0 0 12px 0;
+    font-size: 14px;
+    line-height: 1.5;
+}
+
+.seoaudp-banner__actions {
+    margin: 0;
+}
+
+.seoaudp-banner__close {
+    position: absolute;
+    top: 8px;
+    right: 8px;
+    background: none;
+    border: none;
+    font-size: 18px;
+    cursor: pointer;
+    padding: 4px;
+    line-height: 1;
+    opacity: 0.7;
+    transition: opacity 0.2s;
+}
+
+.seoaudp-banner__close:hover {
+    opacity: 1;
+}

seo-ai-audit-tool/trunk/assets/js/seoaudp-script.js

@@ -849 +849 @@
     });
 
-    // Handler to open the Searchers Intention modal
-    jQuery('.seoaudp-open-intention-modal').on('click', function(e) {
+    // Handler to open the Searchers Intention modal (custom modal)
+    jQuery(document).on('click', '.seoaudp-open-intention-modal', function(e) {
         e.preventDefault();
         var pageId = jQuery(this).data('page-id');
         var keywords = window.seoaudp_keywordIntentions[pageId] || [];
 
-        // Generate the modal content
-        var modalContent = jQuery('<div id="seoaudp-search-intention-modal" class="seoaudp-modal"></div>');
-        var table = jQuery('<table class="wp-list-table widefat fixed striped seoaudp-intention-table">').appendTo(modalContent);
-        
-        // Add table header
-        var thead = $('<thead>').appendTo(table);
-        var headerRow = $('<tr>').appendTo(thead);
-        [
-            'Keyword',
-            'Search Volume', 
-            'Search Intent',
-            'SERP Features'
-        ].forEach(function(headerText) {
-            $('<th>').text(headerText).appendTo(headerRow);
-        });
-
-        // Add table body
-        var tbody = $('<tbody>').appendTo(table);
-        
+        var $modal = jQuery('#intention-modal-' + pageId);
+        if (!$modal.length) {
+            return;
+        }
+
+        var $contentContainer = $modal.find('.intention-details-content');
+        $contentContainer.empty();
+
+        var $table = jQuery('<table class="wp-list-table widefat fixed striped seoaudp-intention-table">');
+        var $thead = jQuery('<thead>').appendTo($table);
+        var $headerRow = jQuery('<tr>').appendTo($thead);
+        ['Keyword', 'Search Volume', 'Search Intent', 'SERP Features'].forEach(function(headerText) {
+            jQuery('<th>').text(headerText).appendTo($headerRow);
+        });
+
+        var $tbody = jQuery('<tbody>').appendTo($table);
         if (keywords.length > 0) {
             keywords.forEach(function(item) {
-                var row = $('<tr>').appendTo(tbody);
-                
-                // Keyword column
-                $('<td>').text(item.keyword || 'N/A').appendTo(row);
-                
-                // Search Volume column
-                $('<td>').text(item.volume ? Number(item.volume).toLocaleString() : 'N/A').appendTo(row);
-                
-                // Search Intent column (from database flags)
+                var $row = jQuery('<tr>').appendTo($tbody);
+                jQuery('<td>').text(item.keyword || 'N/A').appendTo($row);
+                jQuery('<td>').text(item.volume ? Number(item.volume).toLocaleString() : 'N/A').appendTo($row);
+
                 var intentV2 = [];
                 if (item.intent_flags) {
@@ -894 +886 @@
                     if (item.intent_flags.transactional) intentV2.push('Transactional');
                 }
-                $('<td>').html(intentV2.length ? intentV2.join('<br>') : 'N/A').appendTo(row);
-                
-                // SERP Features column
-                $('<td>').text(item.serp_features || 'N/A').appendTo(row);
+                jQuery('<td>').html(intentV2.length ? intentV2.join('<br>') : 'N/A').appendTo($row);
+                jQuery('<td>').text(item.serp_features || 'N/A').appendTo($row);
             });
         } else {
-            $('<tr>').append(
-                $('<td colspan="4">').text('No keywords available.')
-            ).appendTo(tbody);
-        }
-
-        // Append modal to body and initialize
-        $('body').append(modalContent);
-        $('#seoaudp-search-intention-modal').dialog({
-            modal: true,
-            width: 'auto',
-            maxWidth: '90%',
-            minWidth: 800,
-            height: 'auto',
-            maxHeight: $(window).height() * 0.9,
-            title: 'Searchers Intention Details',
-            classes: {
-                "ui-dialog": "seoaudp-modal-dialog"
-            },
-            close: function() {
-                $(this).dialog('destroy').remove();
-            }
-        });
+            jQuery('<tr>').append(
+                jQuery('<td colspan="4">').text('No keywords available.')
+            ).appendTo($tbody);
+        }
+
+        $contentContainer.append($table);
+        if (typeof window.seoaudp_openModal === 'function') {
+            window.seoaudp_openModal('intention-modal-' + pageId);
+        } else {
+            $modal.show();
+        }
+    });
+
+    // Close handlers for the custom modal
+    jQuery(document).on('click', '.seoaudp-modal .seoaudp-close', function() {
+        jQuery(this).closest('.seoaudp-modal').hide();
+    });
+    jQuery(document).on('click', '.seoaudp-modal', function(e) {
+        if (jQuery(e.target).is('.seoaudp-modal')) {
+            jQuery(this).hide();
+        }
     });
 
@@ -1011 +1000 @@
     function seoaudp_handleScroll() {
         const stickyHeaders = document.querySelectorAll('.seoaudp-sticky-header');
-        const stickyTitles = document.querySelectorAll('.seoaudp-sticky-title');
-        const headerOffset = 32; // WP admin bar height
+        const headerOffset = 0; // No extra gap above sticky slug
         stickyHeaders.forEach(header => {
-            const headerRect = header.getBoundingClientRect();
             const parentTable = header.closest('table');
             const tableRect = parentTable.getBoundingClientRect();
-            
+            const stickyTitles = header.querySelectorAll('.seoaudp-sticky-title');
             if (tableRect.top < headerOffset) {
                 header.classList.add('seoaudp-is-scrolled');
+                const translateY = Math.abs(tableRect.top - headerOffset);
                 stickyTitles.forEach(title => {
-                    title.style.transform = `translateY(${Math.abs(tableRect.top - headerOffset)}px)`;
+                    title.style.transform = `translateY(${translateY}px)`;
                 });
             } else {

seo-ai-audit-tool/trunk/changelog.txt

@@ +1 @@
+= 1.1.6 2025-09-19
+
+Improved: Check message consistency on Page auditor
+Added: Import GSC & Ahrefs checklist
+Improved: GUI improvements
+Fixed: Broken pop-up modal when clicking 'Searchers Intention'
+Added: GPT-5 settings support for respective pro Addon version
+Added: Outdated Pro Addon message when manual update is necessary
+
 = 1.1.5 2025-09-11
 

seo-ai-audit-tool/trunk/includes/class-seo-audit-data-import.php

@@ -82 +82 @@
         <div class="wrap seoaudp-container">
             <h1 class="seoaudp-title">Import SEO Metrics</h1>
-            <div class="seoaudp-grid">
-                <div class="seoaudp-card">
-                    <div class="seoaudp-card-header">
-                        <h2>Google Search Console</h2>
+            <div class="seoaudp-grid-two-columns">
+                <div class="seoaudp-column">
+                    <div class="seoaudp-gsc-sub-columns">
+                        <div class="seoaudp-card">
+                            <div class="seoaudp-card-header">
+                                <h2>Google Search Console (Pages)</h2>
                         <?php if ($has_gsc_data): ?>
                             <span class="seoaudp-checkmark" title="Data exists in database">✓ <span class="seoaudp-checkmark-tooltip">Data exists in database</span></span>
@@ -145 +147 @@
                 </div>
 
-                <div class="seoaudp-card">
-                    <div class="seoaudp-card-header">
-                        <h2>Google Search Console</h2>
-                        <?php if ($has_gsc_queries_data): ?>
-                            <span class="seoaudp-checkmark" title="Data exists in database">✓ <span class="seoaudp-checkmark-tooltip">Data exists in database</span></span>
-                        <?php endif; ?>
-                    </div>
-                    <h4>Queries.csv Import</h4>
+                        <div class="seoaudp-card">
+                            <div class="seoaudp-card-header">
+                                <h2>Google Search Console (Queries)</h2>
+                                <?php if ($has_gsc_queries_data): ?>
+                                    <span class="seoaudp-checkmark" title="Data exists in database">✓ <span class="seoaudp-checkmark-tooltip">Data exists in database</span></span>
+                                <?php endif; ?>
+                            </div>
+                            <h4>Queries.csv Import</h4>
                     <div class="seoaudp-steps">
                         <h3>How to export GSC Queries data:</h3>
@@ -205 +207 @@
                         </form>
                     </div>
+                        </div>
+                    </div>
                 </div>
 
-                <div class="seoaudp-card">
-                    <div class="seoaudp-card-header">
-                        <h2>Ahrefs Keywords</h2>
+                <div class="seoaudp-column">
+                    <div class="seoaudp-ahrefs-sub-columns">
+                        <div class="seoaudp-card">
+                            <div class="seoaudp-card-header">
+                                <h2>Ahrefs Keywords</h2>
                         <?php if ($has_ahrefs_data): ?>
                             <span class="seoaudp-checkmark" title="Data exists in database">✓ <span class="seoaudp-checkmark-tooltip">Data exists in database</span></span>
@@ -221 +227 @@
                             <li>Enter your domain</li>
                             <li>Click <b>Organic Keywords</b> (set the target country)</li>
+                            <li>Click <b>By location</b> under Organic Keywords so the Keyword Intent columns are included</li>
                             <li>Click Export</li>
                             <li>Select all, select CSV <span style="color: red;">(UTF-8)</span></li>
@@ -269 +276 @@
                 </div>
 
-                <div class="seoaudp-card">
-                    <div class="seoaudp-card-header">
-                        <h2>Ahrefs Backlinks</h2>
+                        <div class="seoaudp-card">
+                            <div class="seoaudp-card-header">
+                                <h2>Ahrefs Backlinks</h2>
                         <?php if ($has_ahrefs_backlinks_data): ?>
                             <span class="seoaudp-checkmark" title="Data exists in database">✓ <span class="seoaudp-checkmark-tooltip">Data exists in database</span></span>
@@ -327 +334 @@
                         </form>
                     </div>
+                        </div>
+                    </div>
                 </div>
             </div>
@@ -377 +386 @@
             <p>You are about to import <?php echo intval($page_count); ?> pages of GSC data.</p>
             <p><strong>Warning:</strong> This will overwrite any existing GSC data in the database.</p>
+            <?php
+            // Build a lightweight checklist summary based on columns present in first row
+            $first = $processed_data[0];
+            $has_page = isset($first['page']);
+            $has_clicks = isset($first['clicks']);
+            $has_impr = isset($first['impressions']);
+            $has_ctr = isset($first['ctr']);
+            $has_pos = isset($first['position']);
+            ?>
+            <div style="margin:12px 0; padding:12px; border:1px solid #ddd; background:#fff;">
+                <h2 style="margin:0 0 8px;">Import Checklist</h2>
+                <ul style="margin:0 0 8px 18px; list-style:disc;">
+                    <li style="color:<?php echo $has_page ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_page ? '✓' : '✗'; ?> Page URL</li>
+                    <li style="color:<?php echo $has_clicks ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_clicks ? '✓' : '✗'; ?> Clicks</li>
+                    <li style="color:<?php echo $has_impr ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_impr ? '✓' : '✗'; ?> Impressions</li>
+                    <li style="color:<?php echo $has_ctr ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_ctr ? '✓' : '✗'; ?> CTR</li>
+                    <li style="color:<?php echo $has_pos ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_pos ? '✓' : '✗'; ?> Position</li>
+                </ul>
+                <div style="font-size:12px;color:#555;">Rows detected: <?php echo intval($page_count); ?></div>
+            </div>
             
             <form method="post" action="<?php echo esc_url(admin_url('admin-post.php')); ?>">
@@ -389 +418 @@
 
     private function seoaudp_render_ahrefs_confirmation_page() {
-        $processed_data = get_transient('seoaudp_ahrefs_processed_data');
+        $import_key = isset($_GET['import_key']) ? sanitize_text_field($_GET['import_key']) : get_transient('seoaudp_ahrefs_import_key');
+        $processed_data = $import_key ? get_transient('seoaudp_ahrefs_processed_' . $import_key) : get_transient('seoaudp_ahrefs_processed_data');
         if (!$processed_data) {
             wp_die('No data to import. Please upload a CSV file first.');
@@ -400 +430 @@
             <p><strong>Warning:</strong> This will overwrite any existing Ahrefs data in the database.</p>
             
+            <?php 
+            $import_key = isset($_GET['import_key']) ? sanitize_text_field($_GET['import_key']) : get_transient('seoaudp_ahrefs_import_key');
+            $meta = $import_key ? get_transient('seoaudp_ahrefs_import_meta_' . $import_key) : get_transient('seoaudp_ahrefs_import_meta');
+            $validation_errors = $import_key ? get_transient('seoaudp_ahrefs_validation_errors_' . $import_key) : get_transient('seoaudp_ahrefs_validation_errors');
+            if (is_array($meta)) { 
+                $missing = array_map('esc_html', $meta['missing_optional'] ?? array());
+                $present_required = array_map('esc_html', $meta['present_required'] ?? array());
+                $intent_stats = $meta['intent_stats'] ?? array();
+            ?>
+                <div style="margin:12px 0; padding:12px; border:1px solid #ddd; background:#fff;">
+                    <h2 style="margin:0 0 8px;">Import Checklist</h2>
+                    <ul style="margin:0 0 8px 18px; list-style:disc;">
+                        <?php foreach ($present_required as $req): ?>
+                            <li style="color:#2e7d32;">✓ Required present: <?php echo $req; ?></li>
+                        <?php endforeach; ?>
+                        <?php if (!empty($missing)): ?>
+                            <?php foreach ($missing as $miss): ?>
+                                <li style="color:#b71c1c;">✗ Optional missing: <?php echo $miss; ?></li>
+                            <?php endforeach; ?>
+                        <?php else: ?>
+                            <li style="color:#2e7d32;">✓ All optional columns detected</li>
+                        <?php endif; ?>
+                    </ul>
+                    
+                    <?php if (!empty($intent_stats)): ?>
+                        <div style="margin:8px 0; padding:8px; background:#f8f9fa; border-left:3px solid #007cba;">
+                            <strong>Keyword Intent Data Summary:</strong><br>
+                            <small>
+                                • Rows with intent data: <?php echo intval($intent_stats['rows_with_intent_data'] ?? 0); ?><br>
+                                • Rows missing intent data: <?php echo intval($intent_stats['rows_missing_intent_data'] ?? 0); ?><br>
+                                <?php if (($intent_stats['invalid_intent_values'] ?? 0) > 0): ?>
+                                    • <span style="color:#d63384;">Invalid intent values found: <?php echo intval($intent_stats['invalid_intent_values']); ?></span><br>
+                                <?php endif; ?>
+                            </small>
+                        </div>
+                    <?php endif; ?>
+                    
+                    <?php if (!empty($validation_errors) && is_array($validation_errors)): ?>
+                        <div style="margin:8px 0; padding:8px; background:#fff3cd; border-left:3px solid #ffc107; max-height:150px; overflow-y:auto;">
+                            <strong style="color:#856404;">⚠️ Intent Data Validation Warnings:</strong><br>
+                            <small style="color:#856404;">
+                                <?php foreach (array_slice($validation_errors, 0, 10) as $error): ?>
+                                    • <?php echo esc_html($error); ?><br>
+                                <?php endforeach; ?>
+                                <?php if (count($validation_errors) > 10): ?>
+                                    <em>... and <?php echo count($validation_errors) - 10; ?> more warnings.</em><br>
+                                <?php endif; ?>
+                                <strong>These rows will use default intent values (FALSE).</strong>
+                            </small>
+                        </div>
+                    <?php endif; ?>
+                    
+                    <div style="font-size:12px;color:#555;">Valid rows: <?php echo intval($meta['valid_rows'] ?? 0); ?> / Total rows: <?php echo intval($meta['total_rows'] ?? 0); ?></div>
+                </div>
+            <?php } ?>
+
             <form method="post" action="<?php echo esc_url(admin_url('admin-post.php')); ?>">
                 <input type="hidden" name="action" value="seoaudp_confirm_ahrefs_import">
+                <input type="hidden" name="import_key" value="<?php echo isset($import_key) ? esc_attr($import_key) : ''; ?>">
                 <?php wp_nonce_field('seoaudp_confirm_ahrefs_import', 'seoaudp_ahrefs_confirm_nonce'); ?>
                 <?php submit_button('Confirm Import'); ?>
@@ -421 +508 @@
             <p>You are about to import <?php echo intval($query_count); ?> queries of GSC data.</p>
             <p><strong>Warning:</strong> This will overwrite any existing GSC queries data in the database.</p>
+            <?php
+            $first = $processed_data[0];
+            $has_query = isset($first['query']);
+            $has_clicks = isset($first['clicks']);
+            $has_impr = isset($first['impressions']);
+            $has_ctr = isset($first['ctr']);
+            $has_pos = isset($first['position']);
+            ?>
+            <div style="margin:12px 0; padding:12px; border:1px solid #ddd; background:#fff;">
+                <h2 style="margin:0 0 8px;">Import Checklist</h2>
+                <ul style="margin:0 0 8px 18px; list-style:disc;">
+                    <li style="color:<?php echo $has_query ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_query ? '✓' : '✗'; ?> Query</li>
+                    <li style="color:<?php echo $has_clicks ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_clicks ? '✓' : '✗'; ?> Clicks</li>
+                    <li style="color:<?php echo $has_impr ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_impr ? '✓' : '✗'; ?> Impressions</li>
+                    <li style="color:<?php echo $has_ctr ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_ctr ? '✓' : '✗'; ?> CTR</li>
+                    <li style="color:<?php echo $has_pos ? '#2e7d32' : '#b71c1c'; ?>;"><?php echo $has_pos ? '✓' : '✗'; ?> Position</li>
+                </ul>
+                <div style="font-size:12px;color:#555;">Rows detected: <?php echo intval($query_count); ?></div>
+            </div>
             
             <form method="post" action="<?php echo esc_url(admin_url('admin-post.php')); ?>">
@@ -651 +757 @@
         // Remove header row if it exists
         $header = array_shift($csv_data);
-
-        // Check if the header contains expected columns
-        $required_columns = ['Keyword', 'Volume', 'KD', 'CPC', 'Current position', 'Current URL', 'SERP features'];
-        $traffic_column = in_array('Organic traffic', $header) ? 'Organic traffic' : 'Current organic traffic';
-        $required_columns[] = $traffic_column;
-
-        $missing_columns = array_diff($required_columns, $header);
-
-        if (!empty($missing_columns)) {
-            wp_die('The CSV file is missing the following required columns: ' . implode(', ', array_map('esc_html', $missing_columns)));
-        }
-
-        // Get column indexes
+        if (!$header || !is_array($header)) {
+            wp_die('Invalid CSV: missing header row.');
+        }
+        $header = array_map('trim', $header);
         $column_indexes = array_flip($header);
+
+        // Required columns (super mandatory)
+        $required_columns = ['Keyword', 'Current URL'];
+        $missing_required = array_values(array_filter($required_columns, function($c) use ($column_indexes){ return !isset($column_indexes[$c]); }));
+
+        // Optional columns (nice-to-haves)
+        $optional_columns = ['Volume','KD','CPC','Current position','SERP features','Organic traffic','Current organic traffic','Branded','Local','Navigational','Informational','Commercial','Transactional'];
+        $missing_optional = array_values(array_filter($optional_columns, function($c) use ($column_indexes){ return !isset($column_indexes[$c]); }));
+
+        if (!empty($missing_required)) {
+            wp_die('The CSV file is missing required columns: ' . implode(', ', array_map('esc_html', $missing_required)));
+        }
+
+        // Traffic column can be either of these
+        $traffic_column = isset($column_indexes['Organic traffic']) ? 'Organic traffic' : (isset($column_indexes['Current organic traffic']) ? 'Current organic traffic' : null);
 
         // Define the boolean columns we expect
@@ -675 +787 @@
             'Transactional'
         ];
-        foreach ($csv_data as $row) {
-            // Check if the row has the expected number of columns
-            if (count($row) !== count($header)) {
-                continue;
-            }
+
+        $validation_errors = array();
+        $intent_validation_stats = array(
+            'rows_with_intent_data' => 0,
+            'rows_missing_intent_data' => 0,
+            'invalid_intent_values' => 0
+        );
+
+        foreach ($csv_data as $row_index => $row) {
+            if (empty($row)) { continue; }
+            // Skip if required fields are empty
+            if (!isset($row[$column_indexes['Keyword']]) || !isset($row[$column_indexes['Current URL']])) { continue; }
 
             $url = trim($row[$column_indexes['Current URL']]);
-            if (!empty($url)) {
-                $data = array(
-                    'keyword' => trim($row[$column_indexes['Keyword']]),
-                    'volume' => intval($row[$column_indexes['Volume']]),
-                    'kd' => intval($row[$column_indexes['KD']]),
-                    'cpc' => floatval($row[$column_indexes['CPC']]),
-                    'traffic' => intval($row[$column_indexes[$traffic_column]]),
-                    'position' => intval($row[$column_indexes['Current position']]),
-                    'page_url' => $url,
-                    'serp_features' => trim($row[$column_indexes['SERP features']]),
-                );
-
-                // Process boolean columns
-                foreach ($boolean_columns as $column) {
-                    if (isset($column_indexes[$column])) {
-                        $value = trim($row[$column_indexes[$column]]);
-                        // Convert various TRUE values to 1, everything else to 0
-                        $data[strtolower($column)] = in_array(strtoupper($value), ['TRUE', '1', 'YES', 'Y'], true) ? 1 : 0;
+            if ($url === '') { continue; }
+
+            $data = array(
+                'keyword'       => trim($row[$column_indexes['Keyword']]),
+                'volume'        => isset($column_indexes['Volume']) ? intval($row[$column_indexes['Volume']] ?? 0) : 0,
+                'kd'            => isset($column_indexes['KD']) ? intval($row[$column_indexes['KD']] ?? 0) : 0,
+                'cpc'           => isset($column_indexes['CPC']) ? floatval($row[$column_indexes['CPC']] ?? 0) : 0.0,
+                'traffic'       => $traffic_column ? intval($row[$column_indexes[$traffic_column]] ?? 0) : 0,
+                'position'      => isset($column_indexes['Current position']) ? intval($row[$column_indexes['Current position']] ?? 0) : 0,
+                'page_url'      => $url,
+                'serp_features' => isset($column_indexes['SERP features']) ? trim($row[$column_indexes['SERP features']] ?? '') : '',
+            );
+
+            // Validate and process intent boolean columns
+            $has_intent_data = false;
+            $intent_validation_errors = array();
+            
+            foreach ($boolean_columns as $column) {
+                $key = strtolower($column);
+                if (isset($column_indexes[$column])) {
+                    $value = trim($row[$column_indexes[$column]] ?? '');
+                    
+                    // Check if this row has any intent data
+                    if ($value !== '' && $value !== '0' && strtoupper($value) !== 'FALSE') {
+                        $has_intent_data = true;
                     }
+                    
+                    // Validate intent column values
+                    $valid_values = ['TRUE', 'FALSE', '1', '0', 'YES', 'NO', 'Y', 'N', ''];
+                    if ($value !== '' && !in_array(strtoupper($value), $valid_values, true)) {
+                        $intent_validation_errors[] = "Row " . ($row_index + 2) . ": Invalid value '{$value}' in column '{$column}'. Expected TRUE/FALSE, 1/0, YES/NO, or empty.";
+                        $intent_validation_stats['invalid_intent_values']++;
+                    }
+                    
+                    // Set boolean value
+                    $data[$key] = in_array(strtoupper($value), ['TRUE','1','YES','Y'], true) ? 1 : 0;
+                } else {
+                    $data[$key] = 0;
                 }
-
-                $processed_data[] = $data;
-            }
+            }
+
+            // Track intent data statistics
+            if ($has_intent_data) {
+                $intent_validation_stats['rows_with_intent_data']++;
+            } else {
+                $intent_validation_stats['rows_missing_intent_data']++;
+            }
+
+            // Add any validation errors for this row
+            if (!empty($intent_validation_errors)) {
+                $validation_errors = array_merge($validation_errors, $intent_validation_errors);
+            }
+
+            $processed_data[] = $data;
         }
 
@@ -711 +861 @@
         }
 
+        // Handle validation errors - show warnings but don't stop import
+        if (!empty($validation_errors)) {
+            $error_message = '<strong>Intent Data Validation Warnings:</strong><br>' . implode('<br>', array_slice($validation_errors, 0, 10));
+            if (count($validation_errors) > 10) {
+                $error_message .= '<br><em>... and ' . (count($validation_errors) - 10) . ' more warnings.</em>';
+            }
+            $error_message .= '<br><br><strong>These rows will be imported with default intent values (FALSE). Continue?</strong>';
+            
+            // Store validation errors in transient for confirmation page
+            set_transient('seoaudp_ahrefs_validation_errors', $validation_errors, HOUR_IN_SECONDS);
+        }
+
+        // Save import meta for checklist UI on confirmation
+        $import_meta = array(
+            'total_rows'            => count($csv_data),
+            'valid_rows'            => count($processed_data),
+            'missing_optional'      => $missing_optional,
+            'present_required'      => $required_columns,
+            'intent_stats'          => $intent_validation_stats,
+            'has_validation_errors' => !empty($validation_errors),
+            'validation_error_count' => count($validation_errors),
+        );
+        set_transient('seoaudp_ahrefs_import_meta', $import_meta, HOUR_IN_SECONDS);
+
+        // Generate a unique import key so multiple imports won't collide and to reduce cache misses
+        $import_key = wp_generate_password(12, false);
+        set_transient('seoaudp_ahrefs_import_key', $import_key, HOUR_IN_SECONDS);
+        set_transient('seoaudp_ahrefs_import_meta_' . $import_key, $import_meta, HOUR_IN_SECONDS);
+        // Also store validation errors with the keyed name if present
+        $existing_validation_errors = get_transient('seoaudp_ahrefs_validation_errors');
+        if (!empty($existing_validation_errors)) {
+            set_transient('seoaudp_ahrefs_validation_errors_' . $import_key, $existing_validation_errors, HOUR_IN_SECONDS);
+        }
+
         // Check if existing data is present
         $existing_data = $this->db->get_ahrefs_data_count();
@@ -716 +900 @@
         if ($existing_data && $existing_data > 0) {
             // Store the processed data in a transient for later use
-            set_transient('seoaudp_ahrefs_processed_data', $processed_data, 60 * 60); // 1 hour expiration
+            set_transient('seoaudp_ahrefs_processed_data', $processed_data, 60 * 60); // legacy key for backward compatibility
+            set_transient('seoaudp_ahrefs_processed_' . $import_key, $processed_data, 60 * 60);
             
             // Redirect to confirmation page
-            wp_redirect(add_query_arg(['page' => 'seo-audit-gsc', 'step' => 'confirm_ahrefs'], admin_url('admin.php')));
+            wp_redirect(add_query_arg(['page' => 'seo-audit-gsc', 'step' => 'confirm_ahrefs', 'import_key' => $import_key], admin_url('admin.php')));
             exit;
         } else {
@@ -743 +928 @@
         check_admin_referer('seoaudp_confirm_ahrefs_import', 'seoaudp_ahrefs_confirm_nonce');
 
-        $processed_data = get_transient('seoaudp_ahrefs_processed_data');
+        $import_key = isset($_POST['import_key']) ? sanitize_text_field($_POST['import_key']) : get_transient('seoaudp_ahrefs_import_key');
+        $processed_data = $import_key ? get_transient('seoaudp_ahrefs_processed_' . $import_key) : get_transient('seoaudp_ahrefs_processed_data');
 
         if (!$processed_data) {
@@ -756 +942 @@
 
         delete_transient('seoaudp_ahrefs_processed_data');
+        if ($import_key) {
+            delete_transient('seoaudp_ahrefs_processed_' . $import_key);
+            delete_transient('seoaudp_ahrefs_import_meta_' . $import_key);
+            delete_transient('seoaudp_ahrefs_validation_errors_' . $import_key);
+        }
+        delete_transient('seoaudp_ahrefs_import_meta');
+        delete_transient('seoaudp_ahrefs_validation_errors');
         if ($result) {
             update_option('seoaudp_ahrefs_last_import', current_time('mysql'));
@@ -868 +1061 @@
         // Import new data
         $result = $this->db->seoaudp_store_gsc_queries_data($processed_data);
-
+        
         delete_transient('seoaudp_gsc_queries_processed_data');
 

seo-ai-audit-tool/trunk/includes/class-seo-audit-db.php

@@ -738 +738 @@
         global $wpdb;
         $this->ensure_table_exists($this->ahrefs_keywords_table);
+        // Safety guard: ensure page_id is nullable to allow external URLs
+        $col_info = $wpdb->get_row("SHOW COLUMNS FROM {$this->ahrefs_keywords_table} LIKE 'page_id'");
+        if ($col_info && strtoupper($col_info->Null) === 'NO') {
+            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared
+            $wpdb->query("ALTER TABLE {$this->ahrefs_keywords_table} MODIFY page_id bigint(20) DEFAULT NULL");
+        }
         
         $success = true;
@@ -909 +915 @@
         $sql = "CREATE TABLE IF NOT EXISTS $table_name (
             id mediumint(9) NOT NULL AUTO_INCREMENT,
-            page_id bigint(20) NOT NULL,
+            page_id bigint(20) DEFAULT NULL,
             keyword varchar(255) NOT NULL,
             volume int(11) NOT NULL,
@@ -932 +938 @@
         dbDelta($sql);
 
+        // Ensure page_id allows NULL in case older installs have NOT NULL
+        $col_info = $wpdb->get_row("SHOW COLUMNS FROM $table_name LIKE 'page_id'");
+        if ($col_info && strtoupper($col_info->Null) === 'NO') {
+            // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.PreparedSQL.NotPrepared
+            $wpdb->query("ALTER TABLE $table_name MODIFY page_id bigint(20) DEFAULT NULL");
+        }
+
         // Add new columns if they don't exist
         $new_columns = array(
@@ -1187 +1200 @@
                 }
             } else {
-                // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Base query is escaped
-                $query = $wpdb->prepare($base_query, []);
+                // No dynamic placeholders; use the base query directly
+                // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Base query is built safely above
+                $query = $base_query;
             }
             

seo-ai-audit-tool/trunk/includes/class-seo-audit-settings-page.php

@@ -31 +31 @@
         add_action('wp_ajax_seoaudp_clear_ai_logs', array($this, 'seoaudp_clear_ai_logs'));
         $this->db = new \SEO_Audit_Tool\SEO_Audit_DB();
+    }
+
+    /**
+     * Check if GPT-5 support is enabled (pro version 1.1.4 or greater)
+     */
+    private function is_gpt_5_support_enabled() {
+        if (!seoaudp_pro_active()) {
+            return false;
+        }
+        
+        if (defined('SEO_AUDIT_PRO_ADDON_VERSION')) {
+            $pro_version = SEO_AUDIT_PRO_ADDON_VERSION;
+            return version_compare($pro_version, '1.1.4', '>=');
+        }
+        
+        return false;
     }
 
@@ -182 +198 @@
                             title="Select the AI model that best fits your needs - newer models generally provide better results but may cost more"
                             <?php echo seoaudp_pro_active() ? '' : 'disabled="disabled"'; ?>>
-                        <!-- <option value="gpt-5" <!?php selected(get_option('seoaudp_openai_model'), 'gpt-5'); ?>>GPT-5 (latest)</option>
-                        <option value="gpt-5-mini" <!?php selected(get_option('seoaudp_openai_model'), 'gpt-5-mini'); ?>>GPT-5 Mini (recommended)</option> -->
-                        <option value="gpt-4.1-mini" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1-mini'); ?>>GPT-4.1 Mini (recommended)</option>
-                        <option value="gpt-4.1" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1'); ?>>GPT-4.1</option>
-                        <option value="gpt-4.1-nano" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1-nano'); ?>>GPT-4.1 Nano</option>
-                        <option value="o4-mini" <?php selected(get_option('seoaudp_openai_model'), 'o4-mini'); ?>>O4 Mini</option>
-                        <option value="gpt-4o" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4o'); ?>>GPT-4o</option>
+                        <?php 
+                        $is_gpt_5_support_enabled = $this->is_gpt_5_support_enabled();
+                        
+                        if ($is_gpt_5_support_enabled) {
+                            // Show only GPT-5 models for version 1.1.4 or greater
+                            ?>
+                            <option value="gpt-5-mini" <?php selected(get_option('seoaudp_openai_model'), 'gpt-5-mini'); ?>>GPT-5 Mini (recommended)</option>
+                            <option value="gpt-5" <?php selected(get_option('seoaudp_openai_model'), 'gpt-5'); ?>>GPT-5 (latest)</option>
+                            <?php
+                        } else {
+                            // Show all models except GPT-5 for older versions
+                            ?>
+                            <option value="gpt-4.1-mini" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1-mini'); ?>>GPT-4.1 Mini (recommended)</option>
+                            <option value="gpt-4.1" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1'); ?>>GPT-4.1</option>
+                            <option value="gpt-4.1-nano" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4.1-nano'); ?>>GPT-4.1 Nano</option>
+                            <option value="o4-mini" <?php selected(get_option('seoaudp_openai_model'), 'o4-mini'); ?>>O4 Mini</option>
+                            <option value="gpt-4o" <?php selected(get_option('seoaudp_openai_model'), 'gpt-4o'); ?>>GPT-4o</option>
+                            <?php
+                        }
+                        ?>
                     </select>
                 </div>

seo-ai-audit-tool/trunk/includes/models/class-seo-audit-model.php

@@ -275 +275 @@
         return array(
             'status' => $status,
-            'message' => implode(". ", $message),
+            'message' => $status === 'pass' ? "Pass" : "Fail",
             'details' => "<strong>Title:</strong> {$title}<br>" .
                         "<strong>Keyword:</strong> {$keyword}<br>" .
@@ -367 +367 @@
         return array(
             'status' => $descLength > 50 && $descLength <= 160 && $hasKeyword ? 'pass' : 'fail',
-            'message' => sprintf(
-                "Length: %d chars. Keyword match: %.1f%%", 
-                $descLength, 
-                $matchPercentage
-            ),
+            'message' => $descLength > 50 && $descLength <= 160 && $hasKeyword ? "Pass" : "Fail",
             'details' => "<strong>Description:</strong> " . $highlightedDesc . "<br>" .
                         "<strong>Source:</strong> " . esc_html($description_source) . "<br>" .
@@ -457 +453 @@
         return array(
             'status' => !empty($h1_content) && $hasKeyword ? 'pass' : 'fail',
-            'message' => sprintf(
-                "H1 %s. Keyword match: %.1f%%",
-                empty($h1_content) ? "not found" : "found",
-                $matchPercentage
-            ),
+            'message' => !empty($h1_content) && $hasKeyword ? "Pass" : "Fail",
             'details' => sprintf(
                 "<strong>H1 Tag (%s):</strong> %s<br><strong>Keyword:</strong> %s",
@@ -521 +513 @@
         return array(
             'status' => $hasKeyword ? 'pass' : 'fail',
-            'message' => sprintf(
-                "Keyword in first H2: %.1f%%",
-                $matchPercentage
-            ),
+            'message' => $hasKeyword ? "Pass" : "Fail",
             'details' => "<strong>First H2:</strong> {$highlightedH2}<br><strong>Keyword:</strong> " . esc_html($keyword)
         );
@@ -573 +562 @@
         return array(
             'status' => $hasKeyword ? 'pass' : 'fail',
-            'message' => sprintf(
-                "Keyword in first 100 words: %.1f%%",
-                $matchPercentage
-            ),
+            'message' => $hasKeyword ? "Pass" : "Fail",
             'details' => "<strong>First 100 words:</strong><br>" . $highlightedContent . "<br><br><strong>Keyword:</strong> " . esc_html($keyword)
         );
@@ -586 +572 @@
         return array(
             'status' => $wordCount >= 300 ? 'pass' : 'fail',
-            'message' => "Word count: {$wordCount}",
+            'message' => $wordCount >= 300 ? "Pass" : "Fail",
             'details' => "<strong>Word count:</strong> {$wordCount}<br><strong>Recommended minimum:</strong> 300 words"
         );
@@ -599 +585 @@
         return array(
             'status' => $days <= 90 ? 'pass' : 'fail',
-            'message' => "Last modified: {$lastModified} ({$days} days ago)",
+            'message' => $days <= 90 ? "Pass" : "Fail",
             'details' => "<strong>Last modified:</strong> {$lastModified}<br><strong>Days since last update:</strong> {$days}<br><strong>Recommendation:</strong> " . ($days <= 90 ? "Content is up to date" : "Content may need updating")
         );
@@ -633 +619 @@
         return array(
             'status' => $bodyLinks > 0 ? 'pass' : 'fail',
-            'message' => $bodyLinks > 0 ? "Found {$bodyLinks} internal link(s)" : "No internal links found - Add internal links to improve SEO and user navigation",
+            'message' => $bodyLinks > 0 ? $bodyLinks : "",
             'details' => $details
         );
@@ -667 +653 @@
         return array(
             'status' => $uniqueExternalLinks > 0 ? 'pass' : 'fail',
-            'message' => $uniqueExternalLinks > 0 ? "Found {$uniqueExternalLinks} external link(s)" : "No external links found - Consider adding links to authoritative sources",
+            'message' => $uniqueExternalLinks > 0 ? $uniqueExternalLinks : "",
             'details' => $details
         );
@@ -743 +729 @@
 
         $status = ($imagesWithAlt === $totalImages && $imagesWithKeyword > 0) ? 'pass' : 'fail';
-        $message = "Images with alt text: {$imagesWithAlt}/{$totalImages}";
+        $message = $status === 'pass' ? "Pass" : "Fail";
         $details = "<strong>Total images:</strong> {$totalImages}<br><strong>With alt:</strong> {$imagesWithAlt}<br><strong>Without alt:</strong> {$imagesWithoutAlt}<br>"
                  . "<strong>With keyword:</strong> {$imagesWithKeyword}<br><strong>WebP format:</strong> {$webpImages}<br><br>"
@@ -786 +772 @@
         return array(
             'status' => count($keywordRichImages) > 0 ? 'pass' : 'fail',
-            'message' => "Images with keyword in filename: " . count($keywordRichImages) . "/" . count($images),
+            'message' => count($keywordRichImages) > 0 ? "Pass" : "Fail",
             'details' => $details
         );
@@ -825 +811 @@
         
         $status = $allWebP ? 'pass' : 'fail';
-        $message = $allWebP ? "All images are in WebP format" : "Not all images are in WebP format";
+        $message = $status === 'pass' ? "Pass" : "Fail";
         
         $details = "<strong>WebP images:</strong> {$webpCount}<br>"
@@ -925 +911 @@
         return array(
             'status' => $hasKeyword ? 'pass' : 'fail',
-            'message' => sprintf(
-                "%s (%.1f%% match)", 
-                $hasKeyword ? "Keyword found in URL" : "Keyword not sufficiently represented in URL",
-                $matchPercentage
-            ),
+            'message' => $hasKeyword ? "Pass" : "Fail",
             'details' => "<strong>URL:</strong> {$highlightedUrl}<br>" .
                         "<strong>Keyword:</strong> {$keyword}<br>" .

seo-ai-audit-tool/trunk/includes/views/class-seo-audit-view.php

@@ -110 +110 @@
         <div class="wrap seoaudp-wrapper">
             <?php include(plugin_dir_path(__FILE__) . 'partials/header-partial.php'); ?>
+            
+            <?php if (seoaudp_is_pro_version_outdated()): ?>
+            <div class="seoaudp-banner seoaudp-banner--warning">
+                <div class="seoaudp-banner__icon">
+                    <span class="dashicons dashicons-warning"></span>
+                </div>
+                <div class="seoaudp-banner__content">
+                    <h4 class="seoaudp-banner__title">
+                        SEO AI Audit Tool Pro Addon Update Required
+                    </h4>
+                    <p class="seoaudp-banner__message">
+                        Your SEO AI Audit Tool <strong>Pro Addon</strong> is outdated. If you're having trouble updating from the plugins page, 
+                        download the new version from your <a href="https://seo-ai-audit-tool.designful.ca/my-account/" target="_blank"><strong>Members portal</strong></a>.
+                    </p>
+                    <p class="seoaudp-banner__actions">
+                        <a href="https://seo-ai-audit-tool.designful.ca/my-account/" 
+                           target="_blank" 
+                           class="button button-primary">
+                            <span class="dashicons dashicons-external" style="margin-right: 5px; font-size: 14px; vertical-align: middle;"></span>
+                            Go to Members Portal
+                        </a>
+                    </p>
+                </div>
+            </div>
+            <?php endif; ?>
+            
             <div class="seoaudp-wrapper-body">
             <input type="hidden" id="seoaudp-page-filter" value="<?php echo esc_attr(sanitize_text_field($_GET['post_type'] ?? 'all')); ?>">

seo-ai-audit-tool/trunk/includes/views/partials/default-category-rows-partial.php

@@ -29 +29 @@
                     <?php 
                     if (in_array($item, ['Internal Link Count', 'External Link Count'])) {
-                        echo esc_html(ucfirst($result['status']) . ' (' . $result['message'] . ')');
+                        if (!empty($result['message'])) {
+                            echo esc_html(ucfirst($result['status']) . ' (' . $result['message'] . ')');
+                        } else {
+                            echo esc_html(ucfirst($result['status']));
+                        }
                     } else {
                         echo esc_html(ucfirst($result['status']));

seo-ai-audit-tool/trunk/includes/views/partials/table-header-partial.php

@@ -18 +18 @@
                         </label>
                         <?php } ?>
-                        <a href="<?php echo esc_url(get_permalink($page->ID)); ?>" target="_blank">
-                            <?php echo esc_html($page->post_title); ?><br>
+                        <a href="<?php echo esc_url(get_permalink($page->ID)); ?>" target="_blank" title="<?php echo esc_attr($page->post_title); ?>">
+                            <span class="seoaudp-page-title-text" title="<?php echo esc_attr($page->post_title); ?>"><?php echo esc_html($page->post_title); ?></span><br>
                             <small><?php echo esc_html($page->post_name); ?> <span class="dashicons dashicons-admin-links"></span></small>
                         </a>

seo-ai-audit-tool/trunk/readme.md

@@ -2 +2 @@
 Contributors: Designful
 Plugin URL: https://seo-ai-audit-tool.designful.ca/
-Version: 1.1.5
+Version: 1.1.6
 Tags: seo audit, ai seo, conversion optimization, content analysis, search intent
 Requires at least: 4.0
 Tested up to: 6.8
-Stable tag: 1.1.5
+Stable tag: 1.1.6
 Requires PHP: 7.4
 License: GPLv2 or later

seo-ai-audit-tool/trunk/seo-ai-audit-tool.code-workspace

@@ -8 +8 @@
         }
     ],
-    "settings": {}
+    "settings": {
+        "workbench.colorCustomizations": {
+            "titleBar.activeBackground": "#8f6cff",
+            "titleBar.activeForeground": "#ffffff",
+            "titleBar.inactiveBackground": "#8f6cff",
+            "titleBar.inactiveForeground": "#ffffff",
+            "statusBar.background": "#5a1d5a",
+            "statusBar.foreground": "#e7e7e7"
+        }
+    }
 }

seo-ai-audit-tool/trunk/seo-ai-audit-tool.php

@@ -4 +4 @@
  * Plugin URI: https://designful.ca/apps/seo-ai-audit-tool/
  * Description: A WordPress plugin to audit SEO elements of pages and perform AI-powered content analysis
- * Version:     1.1.5
+ * Version:     1.1.6
  * Author:      Designful
  * License:     GPL2
@@ -20 +20 @@
 define('SEOAUDP_PLUGIN_DIR', plugin_dir_path(__FILE__));
 define('SEOAUDP_PLUGIN_URL', plugin_dir_url(__FILE__));
-define('SEOAUDP_PLUGIN_VERSION', '1.1.5');
+define('SEOAUDP_PLUGIN_VERSION', '1.1.6');
 define('SEOAUDP_PLUGIN_BETA_VERSION', false);
-define('SEOAUDP_DB_VERSION', '1.8');
+define('SEOAUDP_DB_VERSION', '1.9');
 define('SEOAUDP_EDD_ITEM_ID', 307);
 define('SEOAUDP_STORE_URL', 'https://seo-ai-audit-tool.designful.ca');
@@ -390 +390 @@
 }
 
+function seoaudp_is_pro_version_outdated() {
+    if (!seoaudp_pro_active()) {
+        return false;
+    }
+    
+    if (defined('SEO_AUDIT_PRO_ADDON_VERSION')) {
+        $pro_version = SEO_AUDIT_PRO_ADDON_VERSION;
+        return version_compare($pro_version, '1.1.2', '<');
+    }
+    
+    return false;
+}
+
 function seoaudp_init_hooks() {
     add_action('admin_print_scripts', 'seoaudp_hide_admin_page');