(int)$clear_exports){ Wpil_Export::clear_exports(); delete_transient('wpil_clear_exports_folder'); } $post = self::getPost(); if (!empty($_GET['csv_export'])) { Wpil_Export::csv(); } if (!empty($_GET['type'])) { // if the current page has a "type" value $type = $_GET['type']; switch ($type) { case 'delete_link': Wpil_Link::delete(); break; case 'inbound_suggestions_page_container': include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/inbound_suggestions_page_container.php'; exit; break; } } if (!empty($_GET['area'])) { switch ($_GET['area']) { case 'wpil_export': Wpil_Export::getInstance()->export($post); break; case 'wpil_export_sitemap_support': self::verify_nonce('wpil_export_sitemap_for_support'); Wpil_Export::getInstance()->export_sitemap_support(); break; case 'wpil_export_ai_token_use_support': self::verify_nonce('wpil_export_ai_token_use_for_support'); Wpil_Export::getInstance()->export_ai_token_use_support(); break; case 'wpil_excel_export': $post = self::getPost(); if (!empty($post)) { try { Wpil_Excel::exportPost($post); } catch (Throwable $t) { } catch (Exception $e) { } } break; } } if (!empty($_POST['hidden_action'])) { switch ($_POST['hidden_action']) { case 'wpil_save_settings': Wpil_Settings::save(); break; case 'activate_license': Wpil_License::activate(); break; } } // if we're on a link whisper page if(isset($_GET['page']) && ('link_whisper' === $_GET['page'] || 'link_whisper_settings' === $_GET['page'])){ // do a version check $version = get_option('wpil_version_check_update', WPIL_PLUGIN_OLD_VERSION_NUMBER); // if the plugin update check hasn't run yet if($version < WPIL_PLUGIN_VERSION_NUMBER){ // create any tables that need creating self::createDatabaseTables(); // and make sure the existing tables are up to date self::updateTables(); // note the updated status update_option('wpil_version_check_update', WPIL_PLUGIN_VERSION_NUMBER); // try pushing a data update since we've clearly updated the plugin Wpil_Telemetry::perform_cron_dashboard_update(); } } //add screen options add_action("load-" . self::$report_menu, function () { add_screen_option( 'report_options', array( 'option' => 'report_options', ) ); }); } /** * This function is used for adding menu and submenus * * * @return void */ public function addMenu() { $capability = apply_filters('wpil_filter_main_permission_check', 'manage_categories', self::get_current_page()); if (!current_user_can($capability)) { return; } if(!WPIL_STATUS_HAS_RUN_SCAN && !Wpil_Settings::has_run_wizard()){ add_menu_page( __('Link Whisper', 'wpil'), __('Link Whisper', 'wpil'), 'manage_categories', 'link_whisper_wizard', [Wpil_Wizard::class, 'init'], plugin_dir_url(__DIR__).'../images/lw-icon-16x16.png' ); return; } if (!Wpil_License::isValid()) { // hide the first item because that's just hte page title add_action('admin_head', function() { echo ''; }); add_menu_page( __('Link Whisper', 'wpil'), __('Link Whisper', 'wpil'), 'manage_categories', 'link_whisper_license', '', plugin_dir_url(__DIR__).'../images/lw-icon-16x16.png' ); add_submenu_page( 'link_whisper_license', __('One Click Setup', 'wpil'), __('One Click Setup', 'wpil'), 'edit_posts', 'link_whisper_wizard', [Wpil_Wizard::class, 'init'] ); add_submenu_page( 'link_whisper_license', __('Activate License', 'wpil'), __('Activate License', 'wpil'), 'edit_posts', 'link_whisper_license', [Wpil_License::class, 'init'] ); return; } add_menu_page( __('Link Whisper', 'wpil'), __('Link Whisper', 'wpil'), 'edit_posts', 'link_whisper', [Wpil_Report::class, 'init'], plugin_dir_url(__DIR__). '../images/lw-icon-16x16.png' ); if(WPIL_STATUS_HAS_RUN_SCAN){ $page_title = __('Internal Links Report', 'wpil'); $menu_title = __('Dashboard', 'wpil'); self::$report_menu = add_submenu_page( 'link_whisper', $page_title, $menu_title, 'edit_posts', 'link_whisper', [Wpil_Report::class, 'init'] ); }else{ // hide the first item because that's just hte page title add_action('admin_head', function() { echo ''; }); } $menu_list = array( // 'link_whisper_dashboard', // we'll always have the main report page since we need to stick the reports to something 'link_whisper_inbound_internal', // 'link_whisper_autolinking', // 'link_whisper_target_keywords', // 'link_whisper_url_changer', // 'link_whisper_settings', // 'link_whisper_wizard', 'link_whisper_ai_subscription' ); $menu_list = apply_filters('wpil_filter_menu_listings', $menu_list); // add the advanced functionality if the first scan has been run if(!empty(WPIL_STATUS_HAS_RUN_SCAN)){ if(in_array('link_whisper_inbound_internal', $menu_list, true)){ add_submenu_page( 'link_whisper', __('Add Inbound Internal Links', 'wpil'), __('Add Inbound Internal Links', 'wpil'), 'edit_posts', 'admin.php?page=link_whisper&type=links' ); } if(in_array('link_whisper_autolinking', $menu_list, true)){ $autolinks = add_submenu_page( 'link_whisper', __('Auto-Linking', 'wpil'), __('Auto-Linking', 'wpil'), 'manage_categories', 'link_whisper_keywords', [Wpil_Keyword::class, 'init'] ); //add autolink screen options add_action("load-" . $autolinks, function () { add_screen_option( 'wpil_keyword_options', array( // todo possibly update 'keywords' to 'autolink' to avoid confusion 'option' => 'wpil_keyword_options', ) ); }); } if(in_array('link_whisper_target_keywords', $menu_list, true)){ $target_keywords = add_submenu_page( 'link_whisper', __('Target Keywords', 'wpil'), __('Target Keywords', 'wpil'), 'manage_categories', 'link_whisper_target_keywords', [Wpil_TargetKeyword::class, 'init'] ); //add target keyword screen options add_action("load-" . $target_keywords, function () { add_screen_option( 'target_keyword_options', array( 'option' => 'target_keyword_options', ) ); }); } if(in_array('link_whisper_url_changer', $menu_list, true)){ add_submenu_page( 'link_whisper', __('URL Changer', 'wpil'), __('URL Changer', 'wpil'), 'manage_categories', 'link_whisper_url_changer', [Wpil_URLChanger::class, 'init'] ); } } if(in_array('link_whisper_wizard', $menu_list, true)){ add_submenu_page( 'link_whisper', __('One Click Setup', 'wpil'), __('One Click Setup', 'wpil'), 'manage_categories', 'link_whisper_wizard', [Wpil_Wizard::class, 'init'] ); } if(in_array('link_whisper_ai_subscription', $menu_list, true) && current_user_can('install_plugins') && empty(Wpil_Settings::getOpenAIKey())){ add_submenu_page( 'link_whisper', __('AI Subscription', 'wpil'), __('AI Subscription', 'wpil'), 'manage_categories', 'link_whisper_ai_subscription', [Wpil_Settings::class, 'ai_init'] ); } if(in_array('link_whisper_settings', $menu_list, true)){ add_submenu_page( 'link_whisper', __('Settings', 'wpil'), __('Settings', 'wpil'), 'manage_categories', 'link_whisper_settings', [Wpil_Settings::class, 'init'] ); } } public static function register_link_health_widget(){ if( !defined('WPIL_STATUS_HAS_RUN_SCAN') || !WPIL_STATUS_HAS_RUN_SCAN || // if they haven't run a link scan !Wpil_License::isValid() // or don't have a vaild license ){ // exist return; } wp_add_dashboard_widget( 'wpil_link_health_widget', __('Link Whisper Site Health Report', 'wpil'), [__CLASS__, 'render_link_health_widget'] ); } public static function render_link_health_widget(){ $rows = self::get_dashboard_widget_rows(); $logo = plugin_dir_url(__DIR__).'../images/lw-icon.png'; ?>
80){ $density_status = 'tag-positive'; $density_subtext = __('Great! The majority of your posts are linked enough.'); }elseif($link_density['percent'] > 60){ $density_status = 'tag-neutral'; $density_subtext = __('Most of the site\'s posts are linked enough.'); }else{ $density_status = 'tag-negative'; $density_subtext = __('Uh oh, the majority of the site\'s posts aren\'t linked enough.'); } } // broken links $broken_link_count = Wpil_Dashboard::getBrokenLinksCount(); $broken_link_percentage = 0; $broken_link_status = 'tag-positive'; $broken_link_subtext = __('Perfect! There aren\'t any broken links on the site.'); if(!empty($broken_link_count)){ $total_links = Wpil_Dashboard::getLinksCount(); if(!empty($total_links)){ $broken_link_percentage = round($broken_link_count / $total_links, 2) * 100; } } if($broken_link_percentage == 0){ $broken_link_status = 'tag-positive'; $broken_link_subtext = __('Perfect! There aren\'t any broken links on the site.'); }elseif($broken_link_percentage < 5){ $broken_link_status = 'tag-positive'; $broken_link_subtext = __('Good! There are a relatively low number of broken links on the site.'); }elseif($broken_link_percentage < 10){ $broken_link_status = 'tag-neutral'; $broken_link_subtext = __('There are a number of broken links on the site that need fixing.'); }else{ $broken_link_status = 'tag-negative'; $broken_link_subtext = __('Houston, we have a problem. There are a lot of broken links on the site'); } $posts_crawled = Wpil_Dashboard::getPostCount(); $posts_crawled_status = (empty($posts_crawled)) ? 'tag-negative': 'tag-positive'; $links_scanned = Wpil_Dashboard::getLinksCount(); $links_scanned_status = (empty($links_scanned)) ? 'tag-negative': 'tag-positive'; $links_inserted = Wpil_Dashboard::get_tracked_link_insert_count(); $links_inserted_status = ($links_inserted > 0) ? 'tag-positive': 'tag-neutral'; $orphaned_posts = Wpil_Dashboard::getOrphanedPostsCount(); if(!empty($orphaned_posts)){ $orphaned_posts_percentage = !empty($posts_crawled) ? round($orphaned_posts / $posts_crawled, 2) * 100 : 0; if($orphaned_posts_percentage == 0){ $orphaned_posts_status = 'tag-positive'; $orphaned_posts_subtext = esc_html__('Awesome! There are no orphaned posts on the site.', 'wpil'); }elseif($orphaned_posts_percentage < 5){ $orphaned_posts_status = 'tag-positive'; $orphaned_posts_subtext = esc_html__('Awesome! There are very few orphaned posts on the site.', 'wpil'); }elseif($orphaned_posts_percentage < 10){ $orphaned_posts_status = 'tag-neutral'; $orphaned_posts_subtext = esc_html__('There are a number of orphaned posts that need some links pointing to them.', 'wpil'); }else{ $orphaned_posts_status = 'tag-negative'; $orphaned_posts_subtext = esc_html__('Uh oh, looks like there are a lot of orphaned posts that need links!', 'wpil'); } }else{ $orphaned_posts_status = 'tag-positive'; $orphaned_posts_subtext = esc_html__('Awesome! There are no orphaned posts on the site.', 'wpil'); } /* $ai_active = Wpil_Settings::can_do_ai_powered_suggestions(); // if we have a API key and at least some of the embedding data processed $link_relatedness = 0; if($ai_active){ $link_relatedness = Wpil_Dashboard::get_related_link_percentage(); if($link_relatedness == 0){ $link_relatedness_status = 'tag-neutral'; $link_relatedness_subtext = esc_html__('Hmm, there\'s no data available. We might need to run a Link Scan.', 'wpil'); }elseif($link_relatedness > 79){ $link_relatedness_status = 'tag-positive'; $link_relatedness_subtext = esc_html__('Amazing! The majority of the site\'s links are going to highly related posts.', 'wpil'); }elseif($link_relatedness > 50){ $link_relatedness_status = 'tag-neutral'; $link_relatedness_subtext = esc_html__('Most of the site\'s links are pointing to topically related posts.', 'wpil'); }else{ $link_relatedness_status = 'tag-negative'; $link_relatedness_subtext = esc_html__('Uh oh, it looks like most of the site\'s links aren\'t going to related posts.', 'wpil'); } }else{ $link_relatedness_status = 'tag-neutral'; $link_relatedness_subtext = esc_html__('Link Whisper\'s AI is not enabled, so we can\'t tell how many links are going to topically related posts.', 'wpil'); } */ // link clicks $click_stats = Wpil_Dashboard::get_click_traffic_stats(); $click_change_indicator = '(0%)'; $click_change_subtext = esc_html__('The number of clicks has remained consistent over the past 30 days.', 'wpil'); $click_change_status = 'tag-neutral'; if($click_stats['percent_change'] > 0){ $click_change_status = 'tag-positive'; $click_change_indicator = '(+' . $click_stats['percent_change'] . '%)'; $click_change_subtext = esc_html__('The number of clicks on the site has gone up over the past 30 days!', 'wpil'); }elseif($click_stats['percent_change'] < 0){ $click_change_status = 'tag-negative'; $click_change_indicator = '(-' . $click_stats['percent_change'] . '%)'; $click_change_subtext = esc_html__('The number of clicks on the site have gone down over the past 30 days.', 'wpil'); } return [ [ 'label' => __('Posts Crawled', 'wpil'), 'value' => $posts_crawled, 'note' => '', 'status'=> $posts_crawled_status, 'status_text' => '', 'url' => admin_url('admin.php?page=link_whisper') ], [ 'label' => __('Links Detected', 'wpil'), 'value' => $links_scanned, 'note' => '', 'status'=> $links_scanned_status, 'status_text' => '', 'url' => admin_url('admin.php?page=link_whisper&type=links') ], [ 'label' => __('Links Inserted', 'wpil'), 'value' => $links_inserted, 'note' => '', 'status'=> $links_inserted_status, 'status_text' => '', 'url' => admin_url('admin.php?page=link_whisper&type=links') ], [ 'label' => __('Link Coverage', 'wpil'), 'value' => $link_density['percent'] . '%', 'note' => '', //$density_subtext, 'status'=> $density_status, 'status_text' => '', 'url' => admin_url('admin.php?page=link_whisper&type=links&link_density=1') ], [ 'label' => __('Orphaned Posts', 'wpil'), 'value' => $orphaned_posts, 'note' => '', // $orphaned_posts_subtext, 'status'=> $orphaned_posts_status, 'status_text' => '', 'url' => admin_url('admin.php?page=link_whisper&type=links&orphaned=1') ], [ 'label' => __('Link Clicks Tracked', 'wpil'), 'value' => $click_stats['clicks_30'], 'note' => '', // $click_change_subtext, 'status'=> $click_change_status, 'status_text' => '', 'url' => admin_url('admin.php?page=link_whisper&type=clicks') ], [ 'label' => __('Broken Links Found', 'wpil'), 'value' => $broken_link_count, 'note' => '', // $broken_link_subtext, 'status'=> $broken_link_status, 'status_text' => '', 'url' => admin_url('admin.php?page=link_whisper&type=error') ], ]; } private static function status_badge($status, $text = '', $url = ''){ $map = [ 'tag-positive' => ['label' => (!empty($text) ? $text: __('Great', 'wpil')), 'class' => 'is-great'], 'tag-neutral' => ['label' => (!empty($text) ? $text: __('OK', 'wpil')), 'class' => 'is-ok'], 'tag-negative' => ['label' => (!empty($text) ? $text: __('Fix', 'wpil')), 'class' => 'is-fix'], 'tag-info' => ['label' => (!empty($text) ? $text: __('Info', 'wpil')), 'class' => 'is-info'], ]; $cfg = isset($map[$status]) ? $map[$status]: $map['tag-info']; $label = esc_html($cfg['label']); $cls = 'lw-badge ' . $cfg['class']; if(!empty($url)){ return ''.$label.''; } return ''.$label.''; } /** * Get post or term by ID from GET or POST request * * @return Wpil_Model_Post|null */ public static function getPost() { if (!empty($_REQUEST['term_id'])) { $post = new Wpil_Model_Post((int)$_REQUEST['term_id'], 'term'); } elseif (!empty($_REQUEST['post_id'])) { $post = new Wpil_Model_Post((int)$_REQUEST['post_id']); } else { $post = null; } return $post; } /** * Show plugin version * * @return string */ public static function showVersion() { $plugin_data = get_plugin_data(WP_INTERNAL_LINKING_PLUGIN_DIR . 'link-whisper.php'); return "

version ".esc_html($plugin_data['Version'])."

"; } public static function show_support_widget(){ if(!empty(get_option('wpil_disable_support_widget', get_option('wpil_disable_tawkto_widget', '')))){ return; }?> $file, $func, $line"; $trace = ''; $bt = debug_backtrace(); $sp = 0; foreach($bt as $k=>$v) { extract($v); $args = ''; if (isset($v['args'])) { $args2 = array(); foreach($v['args'] as $k => $v) { if (!is_scalar($v)) { $args2[$k] = "Array"; } else { $args2[$k] = $v; } } $args = implode(", ", $args2); } $file = substr($file,1+strrpos($file,"/")); $trace .= str_repeat(" ",++$sp); $trace .= "file=$file, line=$line, function=$function(". var_export($args, true).")
"; } $out .= $trace; echo "Error: [$errno] $errstr - $error_file:$error_line



$out"; } /** * Add meta box to the post edit page */ public static function addMetaBoxes() { $capability = apply_filters('wpil_filter_main_permission_check', 'manage_categories', self::get_current_page()); if (!current_user_can($capability)) { return; } if (Wpil_License::isValid()) { $post_id = isset($_REQUEST['post']) ? (int)$_REQUEST['post'] : ''; if ($post_id) { // exit if the post has been ignored $completely_ignored = Wpil_Settings::get_completely_ignored_pages(); if(!empty($completely_ignored) && in_array('post_' . $post_id, $completely_ignored, true)){ return; } } // only show the Target Keywords panel if there's a post id if(!empty($post_id)){ add_meta_box('wpil_target-keywords', 'Link Whisper Target Keywords', [Wpil_Base::class, 'showTargetKeywordsBox'], Wpil_Settings::getPostTypes()); } add_meta_box('wpil_link-articles', 'Link Whisper Suggested Links', [Wpil_Base::class, 'showSuggestionsBox'], Wpil_Settings::getPostTypes()); } } /** * Show meta box on the post edit page */ public static function showSuggestionsBox() { $post_id = isset($_REQUEST['post']) ? (int)$_REQUEST['post'] : ''; $user = wp_get_current_user(); $manually_trigger_suggestions = !empty(get_option('wpil_manually_trigger_suggestions', false)); if ($post_id) { // clear any old links that may still be hiding in the meta delete_post_meta($post_id, 'wpil_links'); include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/link_list_v2.php'; }else{ include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/link_list_please_save_post.php'; } } /** * Show the target keyword metabox on the post edit screen */ public static function showTargetKeywordsBox() { $post_id = isset($_REQUEST['post']) ? (int)$_REQUEST['post'] : ''; $user = wp_get_current_user(); if ($post_id) { $keyword_sources = Wpil_TargetKeyword::get_active_keyword_sources(); $keywords = Wpil_TargetKeyword::get_keywords_by_post_ids($post_id); $post = new Wpil_Model_Post($post_id, 'post'); $is_metabox = true; include WP_INTERNAL_LINKING_PLUGIN_DIR . '/templates/target_keyword_list.php'; } } /** * Makes sure the link suggestions and the target keyword metaboxes are in the same general grouping **/ public static function group_metaboxes($option){ // if there are no grouping settings, exit if(empty($option)){ return $option; } $has_target_keyword = false; $suggestion_box = ''; foreach($option as $position => $boxes){ if(false !== strpos($boxes, 'wpil_target-keywords')){ $has_target_keyword = true; } if(false !== strpos($boxes, 'wpil_link-articles')){ $suggestion_box = $position; } } // if the target keyword box hasn't been set yet, but the suggestion box has if(empty($has_target_keyword) && !empty($suggestion_box)){ // place the target keyword box above the suggestion box $option[$suggestion_box] = str_replace('wpil_link-articles', 'wpil_target-keywords,wpil_link-articles', $option[$suggestion_box]); } return $option; } /** * Add scripts to the admin panel * * @param $hook */ public static function addScripts($hook) { if (strpos($_SERVER['REQUEST_URI'], '/post.php') !== false || strpos($_SERVER['REQUEST_URI'], '/term.php') !== false || (!empty($_GET['page']) && $_GET['page'] == 'link_whisper')) { if(function_exists('wp_enqueue_editor')){ wp_enqueue_editor(); } } $js_path = 'js/wpil_admin.js'; $f_path = WP_INTERNAL_LINKING_PLUGIN_DIR.$js_path; $ver = filemtime($f_path); $current_screen = get_current_screen(); $added_standard = false; if(isset($_GET['page']) && $_GET['page'] == 'link_whisper' || (!empty($current_screen) && $current_screen->base === 'edit')){ self::add_standard_admin_scripts(); $added_standard = true; } // IF if (isset($_GET['page']) && $_GET['page'] == 'link_whisper' && isset($_GET['type']) && ($_GET['type'] == 'inbound_suggestions_page' || // on the Inbound Suggestions page $_GET['type'] == 'click_details_page' || // or the Detailed Click Report page $_GET['type'] == 'links') || // or the Links Report page (!empty($current_screen) && ( // we have the current screen and 'post' === $current_screen->base || // this is a post edit screen OR 'page' === $current_screen->base || // this is a page edit screen OR 'term' === $current_screen->base) // this is a term edit screen ) ){ if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_register_style('wpil_daterange_picker_css', WP_INTERNAL_LINKING_PLUGIN_URL . 'css/daterangepicker.css'); wp_enqueue_style('wpil_daterange_picker_css'); wp_register_style('wpil_select2_css', WP_INTERNAL_LINKING_PLUGIN_URL . 'css/select2.min.css'); wp_enqueue_style('wpil_select2_css'); wp_register_script('wpil_moment', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/moment.js', array('jquery'), $ver, true); wp_enqueue_script('wpil_moment'); wp_register_script('wpil_daterange_picker', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/daterangepicker.js', array('jquery', 'wpil_moment'), $ver, true); wp_enqueue_script('wpil_daterange_picker'); wp_register_script('wpil_select2', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/select2.full.min.js', array('jquery'), $ver, true); // Todo: remove the select2.min.js file when we pass 2.2.0 wp_enqueue_script('wpil_select2'); } if (isset($_GET['page']) && $_GET['page'] == 'link_whisper' && isset($_GET['type']) && $_GET['type'] == 'links') { if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_register_script('wpil_report', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_report.js', array('jquery', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_report'); } if (isset($_GET['page']) && $_GET['page'] == 'link_whisper' && isset($_GET['type']) && $_GET['type'] == 'error') { if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_register_script('wpil_error', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_error.js', array('jquery', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_error'); } if (isset($_GET['page']) && $_GET['page'] == 'link_whisper' && isset($_GET['type']) && $_GET['type'] == 'domains') { if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_register_style('wpil_select2_css', WP_INTERNAL_LINKING_PLUGIN_URL . 'css/select2.min.css'); wp_enqueue_style('wpil_select2_css'); wp_register_script('wpil_select2', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/select2.full.min.js', array('jquery'), $ver, true); // Todo: remove the select2.min.js file when we pass 2.2.0 wp_enqueue_script('wpil_select2'); wp_register_script('wpil_domains', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_domains.js', array('jquery', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_domains'); } if (isset($_GET['page']) && $_GET['page'] == 'link_whisper' && isset($_GET['type']) && ( $_GET['type'] == 'click_details_page' || $_GET['type'] == 'clicks')) { if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_register_script('wpil_click', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_click.js', array('jquery', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_click'); } if (isset($_GET['page']) && $_GET['page'] == 'link_whisper' && isset($_GET['type']) && $_GET['type'] == 'sitemaps') { if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_enqueue_script('wpil_sitemaps', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/sitemaps.min.js', array('jquery', 'wpil_helper'), $ver, true); wp_register_script('wpil_papa_parse', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/papaparse.min.js', array('jquery'), $ver, true); wp_enqueue_script('wpil_papa_parse'); } if (isset($_GET['page']) && $_GET['page'] == 'link_whisper_keywords') { if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_register_script('wpil_keyword', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_keyword.js', array('jquery', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_keyword'); wp_register_script('wpil_papa_parse', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/papaparse.min.js', array('jquery'), $ver, true); wp_enqueue_script('wpil_papa_parse'); } if (isset($_GET['page']) && $_GET['page'] == 'link_whisper_url_changer') { if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_register_script('wpil_keyword', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_url_changer.js', array('jquery', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_keyword'); } if (isset($_GET['page']) && ($_GET['page'] == 'link_whisper_target_keywords' || $_GET['page'] == 'link_whisper' && isset($_GET['type']) && $_GET['type'] === 'inbound_suggestions_page') || ('post' === $current_screen->base || 'term' === $current_screen->base) ) { if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_register_script('wpil_target_keyword', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_target_keyword.js', array('jquery', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_target_keyword'); } if(isset($_GET['page']) && ($_GET['page'] == 'link_whisper_settings')){ if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } $js_path = 'js/wpil_admin_settings.js'; $f_path = WP_INTERNAL_LINKING_PLUGIN_DIR.$js_path; $ver = filemtime($f_path); add_thickbox(); wp_register_script('wpil_admin_settings_script', WP_INTERNAL_LINKING_PLUGIN_URL.$js_path, array('jquery', 'wpil_select2', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_admin_settings_script'); wp_register_style('wpil_select2_css', WP_INTERNAL_LINKING_PLUGIN_URL . 'css/select2.min.css'); wp_enqueue_style('wpil_select2_css'); wp_register_script('wpil_select2', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/select2.full.min.js', array('jquery'), $ver, true); wp_enqueue_script('wpil_select2'); } if(isset($_GET['page']) && ($_GET['page'] == 'link_whisper_ai_subscription')){ if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_enqueue_script('stripe-js', 'https://js.stripe.com/v3/', [], null, true); // TODO: ADD JS IN SPECIFIC FILES /* $js_path = 'js/wpil_admin_settings.js'; $f_path = WP_INTERNAL_LINKING_PLUGIN_DIR.$js_path; $ver = filemtime($f_path); wp_register_script('wpil_admin_settings_script', WP_INTERNAL_LINKING_PLUGIN_URL.$js_path, array('jquery', 'wpil_select2', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_admin_settings_script');*/ } if( isset($_GET['page']) && ($_GET['page'] == 'link_whisper' || $_GET['page'] == 'link_whisper_wizard') ){ if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_enqueue_script('stripe-js', 'https://js.stripe.com/v3/', [], null, true); wp_register_script('wpil_checkout', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_checkout.js', array('jquery', 'wpil_helper', 'stripe-js'), $ver, true); wp_enqueue_script('wpil_checkout'); $payment_params = [ 'stripePublicKey' => 'pk_live_kSOl38xUgfzKw67PzZDQDipr001O3VFl3p', 'apiUrl' => 'https://linkwhisper.com/wp-json/lwasc-checkout/v1', 'userEmail' => Wpil_Settings::get_linkwhisper_ai_user_email(), ]; wp_localize_script('wpil_checkout', 'wpilCheckout', $payment_params); if($_GET['page'] == 'link_whisper_wizard'){ $path = WP_INTERNAL_LINKING_PLUGIN_URL.'css/wpil_wizard.css'; $f_path = WP_INTERNAL_LINKING_PLUGIN_DIR.'css/wpil_wizard.css'; wp_register_style('wpil_wizard_style', $path, $deps=[], filemtime($f_path)); wp_enqueue_style('wpil_wizard_style'); } } $style_path = 'css/wpil_admin.css'; $f_path = WP_INTERNAL_LINKING_PLUGIN_DIR.$style_path; $ver = filemtime($f_path); // if we're NOT on a wizard page! if(!isset($_GET['page']) || $_GET['page'] !== 'link_whisper_wizard'){ // enqueue ALLL of the usual styles. wp_register_style('wpil_admin_style', WP_INTERNAL_LINKING_PLUGIN_URL.$style_path, $deps=[], $ver); wp_enqueue_style('wpil_admin_style'); } // if we're on the Dashboard page! if(isset($_GET['page']) && $_GET['page'] == 'link_whisper' && !isset($_GET['type'])){ /*$style_path = 'css/wpil_tailwind.css'; $f_path = WP_INTERNAL_LINKING_PLUGIN_DIR.$style_path; $ver = filemtime($f_path); // and the tailwind styles!. wp_register_style('wpil_admin_style2', WP_INTERNAL_LINKING_PLUGIN_URL.$style_path, $deps=[], $ver); wp_enqueue_style('wpil_admin_style2');*/ wp_register_style('wpil_select2_css', WP_INTERNAL_LINKING_PLUGIN_URL . 'css/select2.min.css'); wp_enqueue_style('wpil_select2_css'); wp_register_script('wpil_select2', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/select2.full.min.js', array('jquery'), $ver, true); wp_enqueue_script('wpil_select2'); } $disable_fonts = apply_filters('wpil_disable_fonts', false); // we've only got one font ATM if(empty($disable_fonts)){ $style_path = 'css/wpil_fonts.css'; $f_path = WP_INTERNAL_LINKING_PLUGIN_DIR.$style_path; $ver = filemtime($f_path); wp_register_style('wpil_admin_fonts', WP_INTERNAL_LINKING_PLUGIN_URL.$style_path, $deps=[], $ver); wp_enqueue_style('wpil_admin_fonts'); } $dismissedPopups = get_user_meta(get_current_user_id(), 'wpil_dismissed_popups', true); $dismissedPopups = (!empty($dismissedPopups)) ? $dismissedPopups: array(); $ajax_url = admin_url('admin-ajax.php'); $current_page = self::get_current_page(); $explain_page_hidden_on = (array)get_user_meta(get_current_user_id(), 'wpil_hide_explain_page_on', true); $dismiss_explain_page = (!empty(get_user_meta(get_current_user_id(), 'wpil_hide_explain_page_completely', true)) || in_array($current_page, $explain_page_hidden_on)) ? 1: 0; $script_params = []; $script_params['ajax_url'] = $ajax_url; $script_params['wpil_js_path'] = (trailingslashit(WP_INTERNAL_LINKING_PLUGIN_URL) . 'js/'); $script_params['completed'] = __('completed', 'wpil'); $script_params['site_linking_enabled'] = (!empty(get_option('wpil_link_external_sites', false))) ? 1: 0; $script_params['dismissed_popups'] = $dismissedPopups; $script_params['dismiss_popup_nonce'] = wp_create_nonce(get_current_user_id() . 'dismiss-popup-nonce'); $script_params['current_page'] = $current_page; $script_params['plugin_version'] = WPIL_PLUGIN_VERSION_NUMBER; $script_params['dismiss_explain_page'] = $dismiss_explain_page; // Add plugin version for tours if(!function_exists('get_plugin_data')) { require_once(ABSPATH . 'wp-admin/includes/plugin.php'); } $plugin_data = get_plugin_data(WP_INTERNAL_LINKING_PLUGIN_DIR . 'link-whisper.php'); $script_params['version'] = $plugin_data['Version']; $script_params['debug'] = defined('WPIL_DEBUG') && WPIL_DEBUG; $script_params['tour_nonce'] = wp_create_nonce('wpil_load_tours'); $script_params['save_tour_progress_nonce'] = wp_create_nonce('wpil_save_tour_progress'); $script_params['mark_tour_shown_nonce'] = wp_create_nonce('wpil_mark_tour_shown'); $script_params['dismiss_tour_widget_nonce'] = wp_create_nonce('wpil_dismiss_tour_widget'); $script_params['popup_nonce'] = wp_create_nonce('wpil_load_popups'); $script_params['dismiss_popup_nonce'] = wp_create_nonce('wpil_dismiss_popup'); $script_params['telemetry_active'] = Wpil_Settings::get_if_telemetry_active(); $script_params['telemetry_nonce'] = wp_create_nonce(get_current_user_id() . 'wpil-telemetry-nonce'); $script_params['tours_enabled'] = Wpil_Settings::get_tours_enabled(); $script_params['wpil_timepicker_format'] = Wpil_Toolbox::convert_date_format_for_js(); /* $script_params['wpil_help_overlay_controls'] = '
'; */ $script_params['wpil_help_overlay_controls'] = '
'; $script_params['usage_notice_data'] = self::assemble_useage_notice(); $autodismiss = get_option('wpil_telemetry_auto_dismiss_notice', 0); if(empty(get_option('wpil_has_dismissed_telemetry_notice', '0')) && (empty($autodismiss) || time() < $autodismiss)){ if(empty($autodismiss)){ update_option('wpil_telemetry_auto_dismiss_notice', (time() + (DAY_IN_SECONDS * 2))); } $script_params['wpil_telemetry_notice'] = '
Anonymous data collection is on by default to help us create a faster, smarter experience for you!

Your privacy is always protected. We don\'t collect any personal information and you can easily opt-out anytime from the Settings.

'; } // TODO: INSTALL AI NUDGE if (isset($_GET['page']) && $_GET['page'] == 'link_whisper_wizard') { if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_register_script('wpil_wizard', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_wizard.js', array('jquery', 'wpil_base64', 'wpil_tippy', 'wpil_popper', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_wizard'); } if (isset($_GET['page']) && $_GET['page'] == 'link_whisper_maintenance') { if(!$added_standard){ self::add_standard_admin_scripts(); $added_standard = true; } wp_register_script('wpil_maintenance', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_maintenance.js', array('jquery', 'wpil_base64', 'wpil_tippy', 'wpil_popper', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_maintenance'); } if($added_standard){ wp_localize_script('wpil_admin_script', 'wpil_ajax', $script_params); } } public static function add_standard_admin_scripts(){ wp_register_script('wpil_helper', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/wpil_helper.js', array(), filemtime(WP_INTERNAL_LINKING_PLUGIN_DIR . '/js/wpil_helper.js'), true); wp_register_script('wpil_base64', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/base64.js', array(), false, true); wp_enqueue_script('wpil_base64'); wp_register_script('wpil_sweetalert_script_min', WP_INTERNAL_LINKING_PLUGIN_URL . 'js/sweetalert.min.js', array('jquery'), $ver=false, true); wp_enqueue_script('wpil_sweetalert_script_min'); $js_path = 'js/wpil_admin.js'; $f_path = WP_INTERNAL_LINKING_PLUGIN_DIR.$js_path; $ver = filemtime($f_path); $current_screen = get_current_screen(); wp_register_style('wpil_tippy_style', WP_INTERNAL_LINKING_PLUGIN_URL . 'css/tippy.css'); wp_enqueue_style('wpil_tippy_style'); wp_register_script('wpil_popper', WP_INTERNAL_LINKING_PLUGIN_URL.'js/popper.min.js', array(), $ver, true); wp_enqueue_script('wpil_popper'); wp_register_script('wpil_tippy', WP_INTERNAL_LINKING_PLUGIN_URL.'js/tippy.umd.js', array(), $ver, true); wp_enqueue_script('wpil_tippy'); wp_register_script('wpil_admin_script', WP_INTERNAL_LINKING_PLUGIN_URL.$js_path, array('jquery', 'wpil_base64', 'wpil_tippy', 'wpil_popper', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_admin_script'); wp_register_script('wpil_help_overlay', WP_INTERNAL_LINKING_PLUGIN_URL.'js/wpil_help_overlay.js', array('jquery', 'wpil_base64', 'wpil_tippy', 'wpil_popper', 'wpil_helper'), $ver, true); wp_enqueue_script('wpil_help_overlay'); // Tour system assets $tours_css_path = 'css/wpil_tours.css'; $tours_css_file = WP_INTERNAL_LINKING_PLUGIN_DIR . $tours_css_path; $tours_js_path = 'js/wpil_tours.js'; $tours_js_file = WP_INTERNAL_LINKING_PLUGIN_DIR . $tours_js_path; if (file_exists($tours_css_file)) { wp_register_style('wpil_tours_style', WP_INTERNAL_LINKING_PLUGIN_URL . $tours_css_path, array(), filemtime($tours_css_file)); wp_enqueue_style('wpil_tours_style'); } if (file_exists($tours_js_file)) { wp_register_script('wpil_tours', WP_INTERNAL_LINKING_PLUGIN_URL . $tours_js_path, array('jquery', 'wpil_admin_script'), filemtime($tours_js_file), true); wp_enqueue_script('wpil_tours'); } // Telemetry logging system $telemetry_js_path = 'js/wpil_telemetry.js'; $telemetry_js_file = WP_INTERNAL_LINKING_PLUGIN_DIR . $telemetry_js_path; if (file_exists($telemetry_js_file)) { wp_register_script('wpil_telemetry', WP_INTERNAL_LINKING_PLUGIN_URL . $telemetry_js_path, array('jquery', 'wpil_admin_script'), filemtime($telemetry_js_file), true); wp_enqueue_script('wpil_telemetry'); } // Enqueue popup assets $popups_css_path = 'css/wpil_popups.css'; $popups_css_file = WP_INTERNAL_LINKING_PLUGIN_DIR . $popups_css_path; $popups_js_path = 'js/wpil_popups.js'; $popups_js_file = WP_INTERNAL_LINKING_PLUGIN_DIR . $popups_js_path; if (file_exists($popups_css_file)) { wp_register_style('wpil_popups_style', WP_INTERNAL_LINKING_PLUGIN_URL . $popups_css_path, array(), filemtime($popups_css_file)); wp_enqueue_style('wpil_popups_style'); } if (file_exists($popups_js_file)) { wp_register_script('wpil_popups', WP_INTERNAL_LINKING_PLUGIN_URL . $popups_js_path, array('jquery', 'wpil_admin_script'), filemtime($popups_js_file), true); wp_enqueue_script('wpil_popups'); } } /** * Gets the type of page that we're currently on **/ public static function get_current_page(){ if(!function_exists('get_current_screen')){ return ''; } $current_page = get_current_screen(); $page = ''; if(isset($_GET['type'])){ switch($_GET['type']){ case 'links': case 'domains': case 'clicks': case 'error': case 'sitemaps': $page = $_GET['type']; break; case 'inbound_suggestions_page': $page = 'inbound-suggestion-page'; break; } }elseif(isset($_GET['page']) && $_GET['page'] === 'link_whisper'){ $page = 'dashboard'; }elseif(isset($_GET['page']) && $_GET['page'] === 'link_whisper_keywords'){ $page = 'autolinking'; }elseif(isset($_GET['page']) && $_GET['page'] === 'link_whisper_target_keywords'){ $page = 'target-keywords'; }elseif(isset($_GET['page']) && $_GET['page'] === 'link_whisper_url_changer'){ $page = 'url-changer'; }elseif(isset($_GET['page']) && $_GET['page'] === 'link_whisper_ai_subscription'){ $page = 'ai-subscription'; }elseif(!empty($current_page) && $current_page->base === 'post'){ $page = 'post-edit'; }elseif(!empty($current_page) && $current_page->base === 'term'){ $page = 'term-edit'; } return $page; } /** * Gets the available Link Whisper pages and the pages that Link Whisper is active on **/ public static function get_available_pages(){ $pages = array( 'links', 'domains', 'clicks', 'error', 'sitemaps', 'dashboard', 'post-edit', 'term-edit', 'inbound-suggestion-page', 'autolinking', 'target-keywords', 'url-changer'); return $pages; } /** * Determines what page we're on, and where to display the notice that we're supposed to display **/ public static function assemble_useage_notice(){ $possible_notices = array(); // create the possible notices based on the page that we're on $page = self::get_current_page(); switch($page){ case 'dashboard': $possible_notices = array( 'used_links', 'used_domains', 'used_clicks', 'used_detailed_clicks', 'used_broken_links', 'used_visual_maps', 'used_autolinking', 'used_target_keyword_report' ); break; case 'links': $possible_notices = array( // 'used_link_delete', // not currently used 'used_inbound_links', 'used_outbound_links' ); break; case 'domains': $possible_notices = array( 'used_domains_attrs', 'used_domains_untargeted' ); break; case 'clicks': $possible_notices = array( 'used_detailed_clicks' ); break; case 'error': $possible_notices = array( 'used_broken_links_codes', 'used_broken_links_edit_url', 'used_broken_links_delete' ); break; case 'sitemaps': $possible_notices = array( 'used_ai_sitemap', 'used_custom_sitemaps' ); break; case 'inbound-suggestion-page': $possible_notices = array(); break; case 'post-edit': $possible_notices = array(); break; case 'term-edit': $possible_notices = array(); break; case 'autolinking': $possible_notices = array(); break; case 'target-keywords': $possible_notices = array( 'used_gsc', // 'used_target_keywords', // not currently used 'used_target_keyword_refresh' ); break; case 'url-changer': $possible_notices = array(); break; case 'links': $possible_notices = array(); break; } $usage_information = Wpil_Telemetry::create_usage_notice_information($possible_notices); if(!empty($usage_information)){ Wpil_Telemetry::log_user_event_notice_time(); } return $usage_information; } /** * Enqueues the scripts to use on the frontend. **/ public static function enqueue_frontend_scripts(){ global $wp_the_query, $post; // if we're doing a preview of the settings if( isset($_GET['wpil_related_post_preview_nonce']) && isset($_GET['nonce']) && wp_verify_nonce($_GET['nonce'], 'wpil-related-posts-preview-nonce')) { // inline a bit of JS to scroll the window to the RP widget wp_register_script('link-whisper-related-post-preview-inline', ''); wp_enqueue_script('link-whisper-related-post-preview-inline'); wp_add_inline_script('link-whisper-related-post-preview-inline', 'window.location.hash = "#link-whisper-related-posts-widget";'); } // TODO: Add an option to disable the frontend scripts. if(empty($wp_the_query) || !Wpil_License::isValid()){ return; } $posty = $wp_the_query->get_queried_object(); // if we're on a post type archive if($wp_the_query->is_post_type_archive || is_a($posty, 'WP_Post_Type')){ // exit since we can't accurately assign clicks to a post return; } if(empty($posty)){ $posty = $post; } // get if the links are to be opened in new tabs $open_with_js = (!empty(get_option('wpil_js_open_new_tabs', false))) ? 1: 0; $open_all_intrnl = (!empty(get_option('wpil_open_all_internal_new_tab', false))) ? 1: 0; $open_all_extrnl = (!empty(get_option('wpil_open_all_external_new_tab', false))) ? 1: 0; // and if the user has disabled click tracking or there isn't a valid post id $dont_track_clicks = (!empty(get_option('wpil_disable_click_tracking', false)) || empty($posty)) ? 1: 0; // if none of them are, exit if( ($open_with_js == 0 || $open_all_intrnl == 0 && $open_all_extrnl == 0) && $dont_track_clicks == 1){ return; } // put together the ajax variables $ajax_url = get_site_url(null, 'wp-admin/admin-ajax.php', 'relative'); $type = null; $id = null; if(!empty($posty)){ $type = (is_a($posty, 'WP_Term')) ? 'term': 'post'; $id = ($type === 'post') ? $posty->ID: $posty->term_id; } $script_params = []; $script_params['ajaxUrl'] = $ajax_url; $script_params['postId'] = $id; $script_params['postType'] = $type; $script_params['openInternalInNewTab'] = $open_all_intrnl; $script_params['openExternalInNewTab'] = $open_all_extrnl; $script_params['disableClicks'] = $dont_track_clicks; $script_params['openLinksWithJS'] = $open_with_js; $script_params['trackAllElementClicks'] = !empty(get_option('wpil_track_all_element_clicks', 0)) ? 1: 0; // output some actual localizations $script_params['clicksI18n'] = array( 'imageNoText' => __('Image in link: No Text', 'wpil'), 'imageText' => __('Image Title: ', 'wpil'), 'noText' => __('No Anchor Text Found', 'wpil'), ); // enqueue the frontend scripts $filename = 'frontend.min.js'; $file_path = WP_INTERNAL_LINKING_PLUGIN_DIR . 'js/' . $filename; $url_path = WP_INTERNAL_LINKING_PLUGIN_URL . 'js/' . $filename; wp_enqueue_script('wpil-frontend-script', $url_path, array(), filemtime($file_path), true); // output the ajax variables wp_localize_script('wpil-frontend-script', 'wpilFrontend', $script_params); // if we're supposed to add the frontend scripts and the user is able to see them if( isset($_GET['wpil_admin_frontend']) && is_user_logged_in() && current_user_can(apply_filters('wpil_filter_main_permission_check', 'manage_categories', self::get_current_page()))) { $file_path = WP_INTERNAL_LINKING_PLUGIN_DIR . 'js/admin-frontend.js'; $url_path = WP_INTERNAL_LINKING_PLUGIN_URL . 'js/admin-frontend.js'; wp_enqueue_script('wpil-admin-frontend-script', $url_path, array('jquery'), filemtime($file_path), true); } } /** * Show settings link on the plugins page * * @param $links * @return array */ public static function showSettingsLink($links) { if(class_exists('Wpil_License') && !Wpil_License::isValid()){ $links[] = 'Activate License'; }else{ $links[] = 'Settings'; } return $links; } /** * Loads default LinkWhisper settings in to database on plugin activation. */ public static function activate() { // only set default option values if the options are empty if('' === get_option(WPIL_OPTION_LICENSE_STATUS, '')){ update_option(WPIL_OPTION_LICENSE_STATUS, ''); } if('' === get_option(WPIL_OPTION_LICENSE_KEY, '')){ update_option(WPIL_OPTION_LICENSE_KEY, ''); } if('' === get_option(WPIL_OPTION_IGNORE_NUMBERS, '')){ update_option(WPIL_OPTION_IGNORE_NUMBERS, '1'); } if('' === get_option(WPIL_OPTION_POST_TYPES, '')){ update_option(WPIL_OPTION_POST_TYPES, ['post', 'page']); } if('' === get_option(WPIL_OPTION_LINKS_OPEN_NEW_TAB, '')){ update_option(WPIL_OPTION_LINKS_OPEN_NEW_TAB, '0'); } if('' === get_option(WPIL_OPTION_DEBUG_MODE, '')){ update_option(WPIL_OPTION_DEBUG_MODE, '0'); } if('' === get_option(WPIL_OPTION_UPDATE_REPORTING_DATA_ON_SAVE, '')){ update_option(WPIL_OPTION_UPDATE_REPORTING_DATA_ON_SAVE, '0'); } if('' === get_option(WPIL_OPTION_IGNORE_WORDS, '')){ // if there's no ignore words, configure the language settings update_option('wpil_selected_language', Wpil_Settings::getSiteLanguage()); $ignore = "-\r\n" . implode("\r\n", Wpil_Settings::getIgnoreWords()) . "\r\n-"; update_option(WPIL_OPTION_IGNORE_WORDS, $ignore); } if('' === get_option(WPIL_LINK_TABLE_IS_CREATED, '')){ Wpil_Report::setupWpilLinkTable(true); // if the plugin is activating and the link table isn't set up, assume this is a fresh install update_option('wpil_fresh_install', true); // the link table was created with ver 0.8.3 and was the first major table event, so it should be a safe test for new installs } if('' === get_option('wpil_install_date', '')){ // set the install date since it may come in handy update_option('wpil_install_date', current_time('mysql', true)); } // disabling in 2.5.6... Shouldn't need this anymore since it's been ~4 years since the class has been used. //Wpil_Link::removeLinkClass(); // temp cleanup function, remove when we get to 2.7.0 Wpil_AI::clear_duplicate_calculated_embeddings(); self::createDatabaseTables(); self::updateTables(); // note the updated status update_option('wpil_version_check_update', WPIL_PLUGIN_VERSION_NUMBER); } /** * Runs any update routines after the plugin has been updated. */ public static function upgrade_complete($upgrader_object, $options){ // If an update has taken place and the updated type is plugins and the plugins element exists if( $options['action'] == 'update' && $options['type'] == 'plugin' && isset( $options['plugins'] ) ) { // Go through each plugin to see if Link Whisper was updated foreach( $options['plugins'] as $plugin ) { if( $plugin == WPIL_PLUGIN_NAME ) { // create any tables that need creating self::createDatabaseTables(); // and make sure the existing tables are up to date self::updateTables(); // note the updated status update_option('wpil_version_check_update', WPIL_PLUGIN_VERSION_NUMBER); // and push a dashboard data update Wpil_Telemetry::perform_cron_dashboard_update(); } } } } /** * Updates the existing LW data tables with changes as we add them. * Does a version check to see if any DB tables have been updated since the last time this was run. * * @param bool $force_update Setting $force_update to true will ignore the version checks and run all update steps */ public static function updateTables($force_update = false){ global $wpdb; $autolink_tbl = $wpdb->prefix . 'wpil_keyword_links'; $autolink_rule_tbl = $wpdb->prefix . 'wpil_keywords'; $autolink_select_tbl = $wpdb->prefix . 'wpil_keyword_select_links'; $broken_link_tbl = $wpdb->prefix . 'wpil_broken_links'; $ignore_broken_link_tbl = $wpdb->prefix . 'wpil_ignore_links'; $report_links_tbl = $wpdb->prefix . 'wpil_report_links'; $target_keyword_tbl = $wpdb->prefix . 'wpil_target_keyword_data'; $url_changer_tbl = $wpdb->prefix . 'wpil_urls'; $url_links_tbl = $wpdb->prefix . 'wpil_url_links'; $click_tracking_tbl = $wpdb->prefix . 'wpil_click_data'; $related_posts_tbl = $wpdb->prefix . "wpil_related_posts"; $ai_embedding_tbl = $wpdb->prefix . "wpil_ai_embedding_data"; $ai_embedding_calc_tbl = $wpdb->prefix . "wpil_ai_embedding_calculation_data"; $ai_product_tbl = $wpdb->prefix . "wpil_ai_product_data"; $ai_keyword_tbl = $wpdb->prefix . "wpil_ai_keyword_data"; $ai_suggestion_sentence_tbl = $wpdb->prefix . "wpil_ai_processed_sentences"; $ai_suggested_anchor_tbl = $wpdb->prefix . "wpil_ai_suggested_anchors"; $ai_credit_tbl = $wpdb->prefix . "wpil_ai_token_use_data"; $relation_map_tbl = $wpdb->prefix . 'wpil_relation_mapping'; $fresh_install = get_option('wpil_fresh_install', false); // if the DB is up to date, exit if(WPIL_STATUS_SITE_DB_VERSION === WPIL_STATUS_PLUGIN_DB_VERSION && !$force_update){ return; } // if this is a fresh install of the plugin and not a forced update if($fresh_install && empty(WPIL_STATUS_SITE_DB_VERSION) && !$force_update){ // set the DB version as the latest since all the created tables will be up to date update_option('wpil_site_db_version', WPIL_STATUS_PLUGIN_DB_VERSION); update_option('wpil_fresh_install', false); // and exit return; } if((float)WPIL_STATUS_SITE_DB_VERSION < 0.9 || $force_update){ // Added in v1.0.0 // if the error links table exists $error_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$broken_link_tbl}'"); if(!empty($error_tbl_exists)){ // find out if the table has a last_checked col $col = $wpdb->query("SHOW COLUMNS FROM {$broken_link_tbl} LIKE 'last_checked'"); if(empty($col)){ // if it doesn't, add it and a check_count col to the table $update_table = "ALTER TABLE {$broken_link_tbl} ADD COLUMN check_count INT(2) DEFAULT 0 AFTER created, ADD COLUMN last_checked DATETIME NOT NULL DEFAULT NOW() AFTER created"; $wpdb->query($update_table); } } // update the state of the DB to this point update_option('wpil_site_db_version', '0.9'); } // if the current DB version is less than 1.0, run the 1.0 update if((float)WPIL_STATUS_SITE_DB_VERSION < 1.0 || $force_update){ /** added in v1.0.1 **/ // if the error links table exists $error_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$broken_link_tbl}'"); if(!empty($error_tbl_exists)){ // find out if the table has a ignore_link col $col = $wpdb->query("SHOW COLUMNS FROM {$broken_link_tbl} LIKE 'ignore_link'"); if(empty($col)){ // if it doesn't, update it with the "ignore_link" column $update_table = "ALTER TABLE {$broken_link_tbl} ADD COLUMN ignore_link tinyint(1) DEFAULT 0 AFTER `check_count`"; $wpdb->query($update_table); } } // update the state of the DB to this point update_option('wpil_site_db_version', '1.0'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.16 || $force_update){ $error_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$broken_link_tbl}'"); if(!empty($error_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$broken_link_tbl} LIKE 'sentence'"); if (empty($col)) { $update_table = "ALTER TABLE {$broken_link_tbl} ADD COLUMN sentence varchar(1000) AFTER `ignore_link`"; $wpdb->query($update_table); } } $error_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$report_links_tbl}'"); if(!empty($error_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'location'"); if (empty($col)) { $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN location varchar(20) AFTER `post_type`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.16'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.17 || $force_update){ $keywrd_url_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_tbl}'"); if(!empty($keywrd_url_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_tbl} LIKE 'anchor'"); if (empty($col)) { $update_table = "ALTER TABLE {$autolink_tbl} ADD COLUMN anchor text AFTER `post_type`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.17'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.18 || $force_update){ $keywrd_url_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"); if(!empty($keywrd_url_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'restrict_cats'"); if (empty($col)) { $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN restrict_cats tinyint(1) DEFAULT 0 AFTER `link_once`"; $wpdb->query($update_table); } } $keywrd_url_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"); if(!empty($keywrd_url_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'restricted_cats'"); if (empty($col)) { $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN restricted_cats text AFTER `restrict_cats`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.18'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.19 || $force_update){ $keywrd_url_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"); if(!empty($keywrd_url_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'restrict_date'"); if (empty($col)) { $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN restrict_date tinyint(1) DEFAULT 0 AFTER `link_once`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'restricted_date'"); if (empty($col)) { $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN restricted_date DATETIME AFTER `restrict_date`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.19'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.20 || $force_update){ $keywrd_url_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"); if(!empty($keywrd_url_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'select_links'"); if (empty($col)) { $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN select_links tinyint(1) DEFAULT 0 AFTER `link_once`"; $wpdb->query($update_table); } } // make sure the possible links table is created too Wpil_Keyword::preparePossibleLinksTable(); update_option('wpil_site_db_version', '1.20'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.21 || $force_update){ $keywrd_url_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"); if(!empty($keywrd_url_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'set_priority'"); if (empty($col)) { $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN set_priority tinyint(1) DEFAULT 0 AFTER `select_links`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'priority_setting'"); if (empty($col)) { $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN priority_setting int DEFAULT 0 AFTER `set_priority`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.21'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.22 || $force_update){ $changed_urls_exist = $wpdb->query("SHOW TABLES LIKE '{$url_links_tbl}'"); if(!empty($changed_urls_exist)) { $col = $wpdb->query("SHOW COLUMNS FROM {$url_links_tbl} LIKE 'relative_link'"); if (empty($col)) { $update_table = "ALTER TABLE {$url_links_tbl} ADD COLUMN relative_link tinyint(1) DEFAULT 0 AFTER `anchor`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.22'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.23 || $force_update){ $error_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$report_links_tbl}'"); if(!empty($error_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'broken_link_scanned'"); if (empty($col)) { $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN broken_link_scanned tinyint(1) DEFAULT 0 AFTER `location`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.23'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.24 || $force_update){ $trgt_kword_tbl_exists = $wpdb->query("SHOW TABLES LIKE '$target_keyword_tbl'"); if(!empty($trgt_kword_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM $target_keyword_tbl LIKE 'auto_checked'"); if (empty($col)) { $update_table = "ALTER TABLE $target_keyword_tbl ADD COLUMN auto_checked tinyint(1) DEFAULT 0 AFTER `save_date`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.24'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.25 || $force_update){ $clk_tbl_exists = $wpdb->query("SHOW TABLES LIKE '$click_tracking_tbl'"); if(!empty($clk_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM $click_tracking_tbl LIKE 'link_location'"); if (empty($col)) { $update_table = "ALTER TABLE $click_tracking_tbl ADD COLUMN link_location varchar(64) DEFAULT 'Body Content' AFTER `link_anchor`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.25'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.26 || $force_update){ $keywrd_url_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"); if(!empty($keywrd_url_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'case_sensitive'"); if (empty($col)) { $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN case_sensitive tinyint(1) DEFAULT 0 AFTER `restricted_cats`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.26'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.27 || $force_update){ $keywrd_url_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"); if(!empty($keywrd_url_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'force_insert'"); if (empty($col)) { $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN force_insert tinyint(1) DEFAULT 0 AFTER `case_sensitive`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.27'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.28 || $force_update){ $url_changer_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$url_changer_tbl}'"); if(!empty($url_changer_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$url_changer_tbl} LIKE 'wildcard_match'"); if (empty($col)) { $update_table = "ALTER TABLE {$url_changer_tbl} ADD COLUMN wildcard_match tinyint(1) DEFAULT 0 AFTER `new`"; $wpdb->query($update_table); } } $url_links_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$url_links_tbl}'"); if(!empty($url_links_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$url_links_tbl} LIKE 'original_url'"); if (empty($col)) { $update_table = "ALTER TABLE {$url_links_tbl} ADD COLUMN original_url text NOT NULL AFTER `anchor`"; $wpdb->query($update_table); } } $broken_link_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$broken_link_tbl}'"); if(!empty($broken_link_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$broken_link_tbl} LIKE 'anchor'"); if (empty($col)) { $update_table = "ALTER TABLE {$broken_link_tbl} ADD COLUMN anchor text NOT NULL AFTER `sentence`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.28'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.29 || $force_update){ $autolink_rule_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"); if(!empty($autolink_rule_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'link'"); // This time we have to make sure `link` _does_ exist if(!empty($col)){ $update_table = "ALTER TABLE {$autolink_rule_tbl} CHANGE `link` `link` VARCHAR(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.29'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.30 || $force_update){ $autolink_rule_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"); if(!empty($autolink_rule_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'limit_inserts'"); // since we're adding cols, make sure it doens't already exist if(empty($col)){ $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN limit_inserts tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `link_once`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'insert_limit'"); // since we're adding cols, make sure it doens't already exist if(empty($col)){ $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN insert_limit INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `limit_inserts`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'prioritize_longtail'"); // since we're adding cols, make sure it doens't already exist if(empty($col)){ $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN prioritize_longtail tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `priority_setting`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'same_lang'"); // since we're adding cols, make sure it doens't already exist if(empty($col)){ $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN same_lang tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `force_insert`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.30'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.31 || $force_update){ $link_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$report_links_tbl}'"); if(!empty($link_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'target_id'"); // since we're adding cols, make sure it doens't already exist if(empty($col)){ $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN target_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 AFTER `post_id`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'target_type'"); // since we're adding cols, make sure it doens't already exist if(empty($col)){ $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN target_type TEXT AFTER `target_id`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.31'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.32 || $force_update){ $keywrd_url_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_tbl}'"); if(!empty($keywrd_url_tbl_exists)) { $index = $wpdb->query("SHOW INDEX FROM {$autolink_tbl} WHERE COLUMN_NAME = 'keyword_id'"); // since we're adding cols, make sure it doens't already exist if(empty($index)){ $update_table = "ALTER TABLE {$autolink_tbl} ADD INDEX(`keyword_id`)"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.32'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.33 || $force_update){ $link_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$report_links_tbl}'"); if(!empty($link_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'link_whisper_created'"); if (empty($col)) { $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN link_whisper_created tinyint(1) DEFAULT 0 AFTER `broken_link_scanned`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'is_autolink'"); if (empty($col)) { $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN is_autolink tinyint(1) DEFAULT 0 AFTER `link_whisper_created`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.33'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.34 || $force_update){ $error_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$broken_link_tbl}'"); if(!empty($error_tbl_exists)){ // find out if the table has a ignore_link col $row = $wpdb->get_row("SHOW COLUMNS FROM {$broken_link_tbl} LIKE 'post_id'"); if(!empty($row) && isset($row->Type) && is_string($row->Type) && false !== strpos($row->Type, 'int(10)')){ // if it doesn't, update it with the "ignore_link" column $update_table = "ALTER TABLE {$broken_link_tbl} CHANGE `post_id` `post_id` BIGINT(20) UNSIGNED NOT NULL"; $wpdb->query($update_table); } } $ignore_error_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ignore_broken_link_tbl}'"); if(!empty($ignore_error_tbl_exists)){ // find out if the table has a ignore_link col $row = $wpdb->get_row("SHOW COLUMNS FROM {$ignore_broken_link_tbl} LIKE 'post_id'"); if(!empty($row) && isset($row->Type) && is_string($row->Type) && false !== strpos($row->Type, 'int(10)')){ // if it doesn't, update it with the "ignore_link" column $update_table = "ALTER TABLE {$ignore_broken_link_tbl} CHANGE `post_id` `post_id` BIGINT(20) UNSIGNED NOT NULL"; $wpdb->query($update_table); } } if(!empty($wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"))){ // find out if the table has a ignore_link col $row = $wpdb->get_row("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'post_id'"); if(!empty($row) && isset($row->Type) && is_string($row->Type) && false !== strpos($row->Type, 'int(10)')){ // if it doesn't, update it with the "ignore_link" column $update_table = "ALTER TABLE {$autolink_rule_tbl} CHANGE `post_id` `post_id` BIGINT(20) UNSIGNED NOT NULL"; $wpdb->query($update_table); } } if(!empty($wpdb->query("SHOW TABLES LIKE '{$autolink_select_tbl}'"))){ // find out if the table has a ignore_link col $row = $wpdb->get_row("SHOW COLUMNS FROM {$autolink_select_tbl} LIKE 'post_id'"); if(!empty($row) && isset($row->Type) && is_string($row->Type) && false !== strpos($row->Type, 'int(10)')){ // if it doesn't, update it with the "ignore_link" column $update_table = "ALTER TABLE {$autolink_select_tbl} CHANGE `post_id` `post_id` BIGINT(20) UNSIGNED NOT NULL"; $wpdb->query($update_table); } } if(!empty($wpdb->query("SHOW TABLES LIKE '{$url_links_tbl}'"))){ // find out if the table has a ignore_link col $row = $wpdb->get_row("SHOW COLUMNS FROM {$url_links_tbl} LIKE 'post_id'"); if(!empty($row) && isset($row->Type) && is_string($row->Type) && false !== strpos($row->Type, 'int(10)')){ // if it doesn't, update it with the "ignore_link" column $update_table = "ALTER TABLE {$url_links_tbl} CHANGE `post_id` `post_id` BIGINT(20) UNSIGNED NOT NULL"; $wpdb->query($update_table); } } if(!empty($wpdb->query("SHOW TABLES LIKE '{$related_posts_tbl}'"))){ // find out if the table has a ignore_link col $row = $wpdb->get_row("SHOW COLUMNS FROM {$related_posts_tbl} LIKE 'post_id'"); if(!empty($row) && isset($row->Type) && is_string($row->Type) && false !== strpos($row->Type, 'int(10)')){ // if it doesn't, update it with the "ignore_link" column $update_table = "ALTER TABLE {$related_posts_tbl} CHANGE `post_id` `post_id` BIGINT(20) UNSIGNED NOT NULL"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.34'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.35 || $force_update){ if(!empty($wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"))){ // find out if the table has a ignore_link col $exists = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'restrict_to_live'"); if(empty($exists)){ // if it doesn't, update it with the "ignore_link" column $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN restrict_to_live tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `link_once`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.35'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.36 || $force_update){ $clk_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$click_tracking_tbl}'"); if(!empty($clk_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$click_tracking_tbl} LIKE 'tracking_id'"); if (empty($col)) { $update_table = "ALTER TABLE {$click_tracking_tbl} ADD COLUMN tracking_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 AFTER `link_location`, ADD INDEX (`tracking_id`)"; $wpdb->query($update_table); } } $link_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$report_links_tbl}'"); if(!empty($link_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'tracking_id'"); if (empty($col)) { $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN tracking_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 AFTER `is_autolink`, ADD INDEX (`tracking_id`)"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'module_link'"); if (empty($col)) { $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN module_link tinyint(1) DEFAULT 0 AFTER `tracking_id`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'link_context'"); if (empty($col)) { $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN link_context tinyint(1) DEFAULT 0 AFTER `module_link`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.36'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.37 || $force_update){ $link_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$report_links_tbl}'"); if(!empty($link_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'post_type'"); if(!empty($col)){ $index = $wpdb->query("SHOW INDEX FROM {$report_links_tbl} WHERE COLUMN_NAME = 'post_type'"); // since we're adding cols, make sure it doens't already exist if(empty($index)){ $update_table = "ALTER TABLE {$report_links_tbl} ADD INDEX(`post_type`)"; $wpdb->query($update_table); } } } update_option('wpil_site_db_version', '1.37'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.38 || $force_update){ $link_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$report_links_tbl}'"); if(!empty($link_tbl_exists)) { $col = $wpdb->get_row("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'post_type'"); if(!empty($col) && isset($col->Type) && $col->Type === 'text'){ $update_table = "ALTER TABLE {$report_links_tbl} MODIFY `post_type` VARCHAR(8)"; $wpdb->query($update_table); } $col = $wpdb->get_row("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'target_type'"); if(!empty($col) && isset($col->Type) && $col->Type === 'text'){ $update_table = "ALTER TABLE {$report_links_tbl} MODIFY `target_type` VARCHAR(8)"; $wpdb->query($update_table); } // make sure it has an index too! if(!empty($col)){ $index = $wpdb->query("SHOW INDEX FROM {$report_links_tbl} WHERE COLUMN_NAME = 'target_type'"); if(empty($index)){ $update_table = "ALTER TABLE {$report_links_tbl} ADD INDEX(`target_type`)"; $wpdb->query($update_table); } } $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'target_id'"); if(!empty($col)){ $index = $wpdb->query("SHOW INDEX FROM {$report_links_tbl} WHERE COLUMN_NAME = 'target_id'"); if(empty($index)){ $update_table = "ALTER TABLE {$report_links_tbl} ADD INDEX(`target_id`)"; $wpdb->query($update_table); } } } update_option('wpil_site_db_version', '1.38'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.39 || $force_update){ $clk_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$click_tracking_tbl}'"); if(!empty($clk_tbl_exists)) { $index = $wpdb->query("SHOW INDEX FROM {$click_tracking_tbl} WHERE COLUMN_NAME = 'post_type'"); if(empty($index)){ $update_table = "ALTER TABLE {$click_tracking_tbl} ADD INDEX(`post_type`)"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.39'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.40 || $force_update){ $mbddng_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_embedding_tbl}'"); if(!empty($mbddng_tbl_exists)){ $col = $wpdb->query("SHOW COLUMNS FROM {$ai_embedding_tbl} LIKE 'is_empty'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_embedding_tbl} ADD COLUMN `is_empty` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `embed_data`"; $wpdb->query($update_table); } } $mbddng_clc_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_embedding_calc_tbl}'"); if(!empty($mbddng_clc_tbl_exists)){ $col = $wpdb->query("SHOW COLUMNS FROM {$ai_embedding_calc_tbl} LIKE 'calc_index'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_embedding_calc_tbl} ADD COLUMN `calc_index` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 AFTER `calculation`, ADD COLUMN `calc_count` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 AFTER `calc_index`;"; $wpdb->query($update_table); if((float)WPIL_STATUS_SITE_DB_VERSION < 1.40){ $last_ind = Wpil_AI::get_last_embedding_index(); if(!empty($last_ind)){ $wpdb->update($ai_embedding_calc_tbl, array('calc_index' => $last_ind), array('calc_index' => 0)); } } } if(empty(get_option('wpil_term_index_cleanup', '0')) && empty(Wpil_Settings::getTermTypes())){ $wpdb->query("DELETE FROM {$ai_embedding_tbl} WHERE `post_type` = 'term'"); $wpdb->query("DELETE FROM {$ai_embedding_calc_tbl} WHERE `post_type` = 'term'"); $wpdb->query("DELETE FROM {$ai_product_tbl} WHERE `post_type` = 'term'"); $wpdb->query("DELETE FROM {$ai_keyword_tbl} WHERE `post_type` = 'term'"); update_option('wpil_term_index_cleanup', '1'); } } update_option('wpil_site_db_version', '1.40'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.41 || $force_update){ $mbddng_clc_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_embedding_calc_tbl}'"); if(!empty($mbddng_clc_tbl_exists)){ $col = $wpdb->query("SHOW COLUMNS FROM {$ai_embedding_calc_tbl} LIKE 'calc_index'"); if(!empty($col)){ $index = $wpdb->query("SHOW INDEX FROM {$ai_embedding_calc_tbl} WHERE COLUMN_NAME = 'calc_index'"); if(empty($index)){ $update_table = "ALTER TABLE {$ai_embedding_calc_tbl} ADD INDEX(`calc_index`)"; $wpdb->query($update_table); } } } update_option('wpil_site_db_version', '1.41'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.42 || $force_update){ $sggstn_sntnc_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_suggestion_sentence_tbl}'"); if(!empty($sggstn_sntnc_tbl_exists)){ $col = $wpdb->query("SHOW COLUMNS FROM {$ai_suggestion_sentence_tbl} LIKE 'has_link'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_suggestion_sentence_tbl} ADD COLUMN has_link tinyint(1) DEFAULT 0 AFTER `data_type`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.42'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.43 || $force_update){ $sggstd_ncr_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_suggested_anchor_tbl}'"); if(!empty($sggstd_ncr_tbl_exists)){ $col = $wpdb->query("SHOW COLUMNS FROM {$ai_suggested_anchor_tbl} LIKE 'link_score'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_suggested_anchor_tbl} ADD COLUMN link_score int(4) DEFAULT 0 AFTER `target_data_type`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.43'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.44 || $force_update){ $autolink_rule_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$autolink_rule_tbl}'"); if(!empty($autolink_rule_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'auto_imported'"); // since we're adding cols, make sure it doens't already exist if(empty($col)){ $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN auto_imported tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `same_lang`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$autolink_rule_tbl} LIKE 'auto_managed'"); // since we're adding cols, make sure it doens't already exist if(empty($col)){ $update_table = "ALTER TABLE {$autolink_rule_tbl} ADD COLUMN auto_managed tinyint(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `auto_imported`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.44'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.45 || $force_update){ $link_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$report_links_tbl}'"); if(!empty($link_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'anchor_word_count'"); if (empty($col)) { $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN anchor_word_count INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `anchor`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'ai_relation_score'"); if (empty($col)) { $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN ai_relation_score DOUBLE UNSIGNED NOT NULL DEFAULT '0' AFTER `link_context`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.45'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.46 || $force_update){ $link_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_credit_tbl}'"); if(!empty($link_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$ai_credit_tbl} LIKE 'credits_used'"); if (empty($col)) { $update_table = "ALTER TABLE {$ai_credit_tbl} ADD COLUMN credits_used DECIMAL(10,4) UNSIGNED NOT NULL DEFAULT 0.0000 AFTER `total_tokens`"; $wpdb->query($update_table); } } $mbddng_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_embedding_tbl}'"); if(!empty($mbddng_tbl_exists)){ $col = $wpdb->query("SHOW COLUMNS FROM {$ai_embedding_tbl} LIKE 'is_empty'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_embedding_tbl} ADD COLUMN `is_empty` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `embed_data`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.46'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.47 || $force_update){ $error_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$broken_link_tbl}'"); if(!empty($error_tbl_exists)){ // find out if the table has a suggested_url_replacement col $col = $wpdb->query("SHOW COLUMNS FROM {$broken_link_tbl} LIKE 'suggested_url_replacement'"); if (empty($col)) { // if it doesn't, update it with the "suggested_url_replacement" column $update_table = "ALTER TABLE {$broken_link_tbl} ADD `suggested_url_replacement` TEXT NULL DEFAULT NULL AFTER `anchor`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.47'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.48 || $force_update){ $ai_linking_table = $wpdb->prefix . 'wpil_ai_linking'; $ai_linking_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_linking_table}'"); if(!empty($ai_linking_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$ai_linking_table} LIKE 'ai_relation_score'"); if (empty($col)) { $update_table = "ALTER TABLE {$ai_linking_table} ADD COLUMN ai_relation_score DOUBLE UNSIGNED NOT NULL DEFAULT '0' AFTER `sentence_with_anchor_text`"; $wpdb->query($update_table); } } $error_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$broken_link_tbl}'"); if(!empty($error_tbl_exists)){ $col = $wpdb->query("SHOW COLUMNS FROM {$broken_link_tbl} LIKE 'recommended_action'"); if (empty($col)) { $update_table = "ALTER TABLE {$broken_link_tbl} ADD `recommended_action` VARCHAR(32) NULL DEFAULT NULL AFTER `suggested_url_replacement`"; $wpdb->query($update_table); } } // Backfill subscription renewal date on existing installs. if(class_exists('Wpil_License') && method_exists('Wpil_License', 'get_renewal_option_name')){ $renewal_option = Wpil_License::get_renewal_option_name(); if(empty(get_option($renewal_option, ''))){ $license_key = Wpil_License::getKey(); if(!empty($license_key)){ // check-only call to persist renewal date from license response Wpil_License::check($license_key, true, false); } } } update_option('wpil_site_db_version', '1.48'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.49 || $force_update){ $ai_token_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_credit_tbl}'"); if(!empty($ai_token_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$ai_credit_tbl} LIKE 'query_id'"); if (empty($col)) { $update_table = "ALTER TABLE {$ai_credit_tbl} ADD COLUMN query_id VARCHAR(128) NULL DEFAULT NULL AFTER `token_index`, ADD INDEX (`query_id`)"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.49'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.50 || $force_update){ $ai_linking_table = $wpdb->prefix . 'wpil_ai_linking'; $ai_linking_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_linking_table}'"); if(!empty($ai_linking_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$ai_linking_table} LIKE 'sentence_id'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_linking_table} ADD COLUMN sentence_id VARCHAR(168) DEFAULT '' AFTER `sentence_text`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$ai_linking_table} LIKE 'process_key'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_linking_table} ADD COLUMN process_key VARCHAR(64) DEFAULT '' AFTER `inserted`"; $wpdb->query($update_table); } $has_sentence_index = $wpdb->get_var("SHOW INDEX FROM {$ai_linking_table} WHERE Key_name = 'sentence_id'"); if(empty($has_sentence_index)){ $wpdb->query("ALTER TABLE {$ai_linking_table} ADD INDEX (`sentence_id`)"); } $has_index = $wpdb->get_var("SHOW INDEX FROM {$ai_linking_table} WHERE Key_name = 'process_key'"); if(empty($has_index)){ $wpdb->query("ALTER TABLE {$ai_linking_table} ADD INDEX (`process_key`)"); } $wpdb->query("UPDATE {$ai_linking_table} SET sentence_id = MD5(sentence_text) WHERE (sentence_id IS NULL OR sentence_id = '') AND sentence_text IS NOT NULL AND sentence_text != ''"); } update_option('wpil_site_db_version', '1.50'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.51 || $force_update){ $ai_token_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$ai_credit_tbl}'"); if(!empty($ai_token_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$ai_credit_tbl} LIKE 'transaction_type'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_credit_tbl} ADD COLUMN transaction_type VARCHAR(24) NOT NULL DEFAULT 'usage' AFTER `query_id`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$ai_credit_tbl} LIKE 'transaction_ref'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_credit_tbl} ADD COLUMN transaction_ref VARCHAR(128) NULL DEFAULT NULL AFTER `transaction_type`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$ai_credit_tbl} LIKE 'transaction_note'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_credit_tbl} ADD COLUMN transaction_note VARCHAR(64) NULL DEFAULT NULL AFTER `transaction_ref`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$ai_credit_tbl} LIKE 'credits_added'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_credit_tbl} ADD COLUMN credits_added DECIMAL(10,4) UNSIGNED NOT NULL DEFAULT 0.0000 AFTER `credits_used`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$ai_credit_tbl} LIKE 'process_key'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_credit_tbl} ADD COLUMN process_key VARCHAR(64) NOT NULL DEFAULT '' AFTER `process_used`"; $wpdb->query($update_table); } $col = $wpdb->query("SHOW COLUMNS FROM {$ai_credit_tbl} LIKE 'process_id'"); if(empty($col)){ $update_table = "ALTER TABLE {$ai_credit_tbl} ADD COLUMN process_id INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `process_key`"; $wpdb->query($update_table); } $has_index = $wpdb->get_var("SHOW INDEX FROM {$ai_credit_tbl} WHERE Key_name = 'transaction_type'"); if(empty($has_index)){ $wpdb->query("ALTER TABLE {$ai_credit_tbl} ADD INDEX (`transaction_type`)"); } $has_index = $wpdb->get_var("SHOW INDEX FROM {$ai_credit_tbl} WHERE Key_name = 'transaction_ref'"); if(empty($has_index)){ $wpdb->query("ALTER TABLE {$ai_credit_tbl} ADD INDEX (`transaction_ref`)"); } $has_index = $wpdb->get_var("SHOW INDEX FROM {$ai_credit_tbl} WHERE Key_name = 'credit_transaction_ref'"); if(empty($has_index)){ $wpdb->query("ALTER TABLE {$ai_credit_tbl} ADD UNIQUE KEY credit_transaction_ref (`transaction_type`, `transaction_ref`)"); } $has_index = $wpdb->get_var("SHOW INDEX FROM {$ai_credit_tbl} WHERE Key_name = 'process_key_id_time'"); if(empty($has_index)){ $wpdb->query("ALTER TABLE {$ai_credit_tbl} ADD INDEX process_key_id_time (`process_key`, `process_id`, `process_time`)"); } } update_option('wpil_site_db_version', '1.51'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.52 || $force_update){ $report_links_exists = $wpdb->query("SHOW TABLES LIKE '{$report_links_tbl}'"); if(!empty($report_links_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'url_slug_word_count'"); if(empty($col)){ $wpdb->query("ALTER TABLE {$report_links_tbl} ADD COLUMN url_slug_word_count INT(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `anchor_word_count`"); } $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'anchor_slug_positional_match'"); if(empty($col)){ $wpdb->query("ALTER TABLE {$report_links_tbl} ADD COLUMN anchor_slug_positional_match DOUBLE UNSIGNED NOT NULL DEFAULT 0 AFTER `url_slug_word_count`"); } } update_option('wpil_site_db_version', '1.52'); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.53 || $force_update){ $relation_map_exists = $wpdb->query("SHOW TABLES LIKE '{$relation_map_tbl}'"); if(!empty($relation_map_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$relation_map_tbl} LIKE 'post_id'"); if(empty($col)){ $wpdb->query("ALTER TABLE {$relation_map_tbl} ADD COLUMN post_id BIGINT(20) UNSIGNED NOT NULL DEFAULT 0 AFTER `process_key`"); } $col = $wpdb->query("SHOW COLUMNS FROM {$relation_map_tbl} LIKE 'work_scope'"); if(empty($col)){ $wpdb->query("ALTER TABLE {$relation_map_tbl} ADD COLUMN work_scope VARCHAR(24) NOT NULL DEFAULT 'default' AFTER `process_key`"); } $col = $wpdb->query("SHOW COLUMNS FROM {$relation_map_tbl} LIKE 'post_type'"); if(empty($col)){ $wpdb->query("ALTER TABLE {$relation_map_tbl} ADD COLUMN post_type VARCHAR(24) NOT NULL DEFAULT '' AFTER `post_id`"); } $col = $wpdb->query("SHOW COLUMNS FROM {$relation_map_tbl} LIKE 'is_pillar'"); if(empty($col)){ $wpdb->query("ALTER TABLE {$relation_map_tbl} ADD COLUMN is_pillar TINYINT(1) NOT NULL DEFAULT 0 AFTER `post_type`"); } $col = $wpdb->query("SHOW COLUMNS FROM {$relation_map_tbl} LIKE 'item_processed'"); if(empty($col)){ $wpdb->query("ALTER TABLE {$relation_map_tbl} ADD COLUMN item_processed TINYINT(1) NOT NULL DEFAULT 0 AFTER `is_pillar`"); } $col = $wpdb->query("SHOW COLUMNS FROM {$relation_map_tbl} LIKE 'ai_processed'"); if(empty($col)){ $wpdb->query("ALTER TABLE {$relation_map_tbl} ADD COLUMN ai_processed TINYINT(1) NOT NULL DEFAULT 0 AFTER `item_processed`"); } $legacy_unique_keys = $wpdb->get_results("SHOW INDEX FROM {$relation_map_tbl} WHERE Column_name = 'process_key' AND Non_unique = 0"); if(!empty($legacy_unique_keys)){ foreach($legacy_unique_keys as $key){ if(empty($key->Key_name) || $key->Key_name === 'PRIMARY' || $key->Key_name === 'process_key_scope_post_id_type'){ continue; } $wpdb->query("ALTER TABLE {$relation_map_tbl} DROP INDEX `{$key->Key_name}`"); } } $has_index = $wpdb->get_var("SHOW INDEX FROM {$relation_map_tbl} WHERE Key_name = 'process_key_post_id_type'"); if(!empty($has_index)){ $wpdb->query("ALTER TABLE {$relation_map_tbl} DROP INDEX `process_key_post_id_type`"); } $has_index = $wpdb->get_var("SHOW INDEX FROM {$relation_map_tbl} WHERE Key_name = 'process_key_scope_post_id_type'"); if(empty($has_index)){ $wpdb->query("ALTER TABLE {$relation_map_tbl} ADD UNIQUE KEY process_key_scope_post_id_type (`process_key`, `work_scope`, `post_id`, `post_type`)"); } $has_index = $wpdb->get_var("SHOW INDEX FROM {$relation_map_tbl} WHERE Key_name = 'process_key_item_processed'"); if(empty($has_index)){ $wpdb->query("ALTER TABLE {$relation_map_tbl} ADD INDEX process_key_item_processed (`process_key`, `item_processed`)"); } $has_index = $wpdb->get_var("SHOW INDEX FROM {$relation_map_tbl} WHERE Key_name = 'process_key_scope_queue'"); if(empty($has_index)){ $wpdb->query("ALTER TABLE {$relation_map_tbl} ADD INDEX process_key_scope_queue (`process_key`, `work_scope`, `item_processed`, `ai_processed`, `is_pillar`, `id`)"); } if((float)WPIL_STATUS_SITE_DB_VERSION < 1.53){ $wpdb->query("TRUNCATE TABLE {$relation_map_tbl}"); } } update_option('wpil_site_db_version', '1.53'); } // todo create a database index for click tracking's user_ip column if people find that it takes too long to load the user_ip view /* if((float)WPIL_STATUS_SITE_DB_VERSION < 1.23 || $force_update){ $error_tbl_exists = $wpdb->query("SHOW TABLES LIKE '{$report_links_tbl}'"); if(!empty($error_tbl_exists)) { $col = $wpdb->query("SHOW COLUMNS FROM {$report_links_tbl} LIKE 'broken_link_scanned'"); if (empty($col)) { $update_table = "ALTER TABLE {$report_links_tbl} ADD COLUMN broken_link_scanned tinyint(1) DEFAULT 0 AFTER `location`"; $wpdb->query($update_table); } } update_option('wpil_site_db_version', '1.23'); }*/ } /** * Runs our deactivation routines when the plugin is turned off **/ public static function deactivate(){ // clear the cron schedules Wpil_AI::clear_batch_process_cron(); self::clear_cron_schedules(); Wpil_ClickTracker::clear_cron_schedules(); Wpil_Error::clearCronSchedules(); Wpil_Keyword::clear_cron_schedules(); Wpil_TargetKeyword::clear_cron_schedules(); Wpil_Telemetry::clear_batch_process_cron(); } /** * Inits cron. * Currently configured for Suggestions since that is not auto-registered, but may be expanded later **/ public static function init_cron(){ add_filter('cron_schedules', array(__CLASS__, 'add_cron_schedules')); add_action('admin_init', array(__CLASS__, 'schedule_cron_tasks')); // add the cron actions if(!empty(Wpil_Settings::getOpenAIKey()) && !Wpil_Settings::disable_ai_suggestions_cron_task() && Wpil_Settings::get_use_ai_suggestions()){ add_action('wpil_ai_suggestions_cron', array('Wpil_Suggestion', 'cron_get_ai_inbound_suggestions')); }else{ self::clear_cron_schedules('wpil_ai_suggestions_cron'); } } public static function add_cron_schedules($schedules){ if(!isset($schedules['10min'])){ $schedules['10min'] = array( 'interval' => 60 * 10, 'display' => __('Every ten Minutes', 'wpil') ); } return $schedules; } /** * Schedules the broken link checks if the user hasn't disabled checking. * If the user has, then it disables the checks **/ public static function schedule_cron_tasks(){ if(!Wpil_Settings::disable_ai_suggestions_cron_task()){ if(!wp_get_schedule('wpil_ai_suggestions_cron')){ wp_schedule_event(time(), '5min', 'wpil_ai_suggestions_cron'); } }elseif(wp_get_schedule('wpil_ai_suggestions_cron')){ self::clear_cron_schedules('wpil_ai_suggestions_cron'); } } public static function clear_cron_schedules($id = ''){ if(empty($id)){ return false; } $timestamp = wp_next_scheduled($id); wp_unschedule_event($timestamp, $id); } /** * Modifies the post's row actions to add an "Add Inbound Links" button to the row actions. * Only adds the link to post types that we create links for. * * @param $actions * @param $object * @return $actions **/ public static function modify_list_row_actions( $actions, $object ) { $type = is_a($object, 'WP_Post') ? $object->post_type: $object->taxonomy; if(!in_array($type, Wpil_Settings::getAllTypes())){ return $actions; } $page = (isset($_GET['paged']) && !empty($_GET['paged'])) ? '&paged=' . (int)$_GET['paged']: ''; if(is_a($object, 'WP_Post')){ $actions['wpil-add-inbound-links'] = 'ID}&page=link_whisper&type=inbound_suggestions_page&ret_url=" . base64_encode(admin_url("edit.php?post_type={$type}{$page}&direct_return=1"))) . '">Add Inbound Links'; }else{ global $wp_taxonomies; if(isset($wp_taxonomies[$type], $wp_taxonomies[$type]->object_type) && is_array($wp_taxonomies[$type]->object_type)){ $post_type = reset($wp_taxonomies[$type]->object_type); $actions['wpil-add-inbound-links'] = 'term_id}&page=link_whisper&type=inbound_suggestions_page&ret_url=" . base64_encode(admin_url("edit-tags.php?taxonomy={$type}{$page}&post_type={$post_type}&direct_return=1"))) . '">Add Inbound Links'; } } $delete_inbound = Wpil_Settings::delete_inbound_internal_on_post_delete(); if(isset($actions['trash']) && !$delete_inbound){ preg_match('//', $actions['trash'], $link); // if we have the trash link and it doesn't include more than just the link if(isset($link[0]) && strlen($actions['trash']) === strlen($link[0])){ // add the info tooltip $actions['trash'] .= 'automatically remove links pointing to posts you delete?') . '">'; } }elseif(isset($actions['delete']) && !$delete_inbound){ preg_match('//', $actions['delete'], $link); // if we have the delete link and it doesn't include more than just the link if(isset($link[0]) && strlen($actions['delete']) === strlen($link[0])){ // add the info tooltip $actions['delete'] .= 'automatically remove links pointing to posts you delete?') . '">'; } } return $actions; } /** * Add new columns for SEO title, description and focus keywords. * * @param array $columns Array of column names. * * @return array */ public static function add_columns($columns){ global $post_type; if(!in_array($post_type, Wpil_Settings::getPostTypes())){ return $columns; } $columns['wpil-link-stats'] = esc_html__('Link Stats', 'wpil'); return $columns; } /** * Add content for custom column in the posts && pages archives. * * @param string $column_name The name of the column to display. * @param int $post_id The current post ID. */ public static function columns_contents($column_name, $post_id){ if('wpil-link-stats' === $column_name){ $post_status = get_post_status($post_id); // exit if the current post is in a status we don't process if(!in_array($post_status, Wpil_Settings::getPostStatuses())){ $status_obj = get_post_status_object($post_status); $status = (!empty($status_obj)) ? $status_obj->label: ucfirst($post_status); ?> ' . __('not set', 'wpil') . ''); ?> getInboundInternalLinks(true); $outbound_internal = (int) $post->getOutboundInternalLinks(true); $outbound_external = (int) $post->getOutboundExternalLinks(true); $broken_links = Wpil_Error::getBrokenLinkCountByPostId($post_id); $ignored_pages = Wpil_Settings::get_completely_ignored_pages(); // todo create an is_ignored checker for posts $is_ignored = (!empty($ignored_pages) && in_array('post_' . $post_id, $ignored_pages)) ? true: false; $post_type = get_post_type($post_id); $page = (isset($_GET['paged']) && !empty($_GET['paged'])) ? '&paged=' . (int)$_GET['paged']: ''; ?> "> "> 0 ' . __('ignored', 'wpil') . ''); ?> getLinks()->refresh; ?> ]*?href=[\'"]([^\'"]*?)[\'"][^>]*?)>/', $content, $matches ); foreach($matches[0] as $key => $link){ // if the link already opens in a new tab, skip to the next link if(false !== strpos($link, 'target="_blank"')){ continue; } $internal = Wpil_Link::isInternal($matches[2][$key]); if($internal && $open_all_intrnl){ $new_link = str_replace($matches[1][$key], $matches[1][$key] . ' target="_blank"', $link); $content = mb_ereg_replace(preg_quote($link), $new_link, $content); }elseif(!$internal && $open_all_extrnl){ $new_link = str_replace($matches[1][$key], $matches[1][$key] . ' target="_blank"', $link); $content = mb_ereg_replace(preg_quote($link), $new_link, $content); } } } return $content; } /** * Filters the post content to unwrap tracked Link Whisper links that now point to * missing or unpublished internal targets. * @param string $content * @return string **/ public static function filter_link_whisper_frontend_links($content = ''){ if( empty($content) || empty(Wpil_Settings::get_filter_out_frontend_broken_draft_links()) || !Wpil_Report::link_table_is_created() ){ return $content; } preg_match_all('/data-wpil-monitor-id=(["\'])(\d+)\1/i', $content, $matches); if(empty($matches[2])){ return $content; } $invalid_tracking_ids = self::get_invalid_link_whisper_tracking_ids($matches[2]); if(empty($invalid_tracking_ids)){ return $content; } $invalid_tracking_ids = array_fill_keys($invalid_tracking_ids, true); $content = preg_replace_callback('/]*?)data-wpil-monitor-id=(["\'])(\d+)\2([^>]*)>(.*?)<\/a>/is', function($match) use ($invalid_tracking_ids){ $tracking_id = isset($match[3]) ? (int) $match[3] : 0; if(empty($tracking_id) || !isset($invalid_tracking_ids[$tracking_id])){ return $match[0]; } return isset($match[5]) ? $match[5] : ''; }, $content); return $content; } /** * Checks if a tracked Link Whisper link would be hidden by the frontend filter. * @param array|object $link * @param bool $respect_setting * @return bool **/ public static function is_link_whisper_frontend_link_hidden($link = array(), $respect_setting = true){ if(empty($link)){ return false; } if($respect_setting && empty(Wpil_Settings::get_filter_out_frontend_broken_draft_links())){ return false; } $tracking_id = 0; if(is_object($link) && isset($link->tracking_id)){ $tracking_id = (int) $link->tracking_id; }elseif(is_array($link) && isset($link['tracking_id'])){ $tracking_id = (int) $link['tracking_id']; } if(empty($tracking_id)){ return false; } return in_array($tracking_id, self::get_invalid_link_whisper_tracking_ids(array($tracking_id)), true); } /** * Gets the tracked Link Whisper link ids that should be filtered from the frontend. * @param array $tracking_ids * @return array **/ private static function get_invalid_link_whisper_tracking_ids($tracking_ids = array()){ global $wpdb; static $tracking_status_cache = array(); $tracking_ids = array_values(array_unique(array_filter(array_map('intval', (array) $tracking_ids)))); if(empty($tracking_ids)){ return array(); } $uncached_tracking_ids = array(); foreach($tracking_ids as $tracking_id){ if(!array_key_exists($tracking_id, $tracking_status_cache)){ $uncached_tracking_ids[] = $tracking_id; $tracking_status_cache[$tracking_id] = false; } } if(!empty($uncached_tracking_ids)){ $links_table = $wpdb->prefix . 'wpil_report_links'; $placeholders = implode(', ', array_fill(0, count($uncached_tracking_ids), '%d')); $tracked_links = $wpdb->get_results( $wpdb->prepare( "SELECT tracking_id, target_id, target_type FROM {$links_table} WHERE tracking_id IN ({$placeholders}) AND tracking_id > 0 AND link_whisper_created = 1", $uncached_tracking_ids ), ARRAY_A ); if(!empty($tracked_links)){ $tracked_targets = array(); $post_ids = array(); $term_ids = array(); foreach($tracked_links as $tracked_link){ $tracking_id = isset($tracked_link['tracking_id']) ? (int) $tracked_link['tracking_id'] : 0; $target_id = isset($tracked_link['target_id']) ? (int) $tracked_link['target_id'] : 0; $target_type = isset($tracked_link['target_type']) ? (string) $tracked_link['target_type'] : ''; if( empty($tracking_id) || empty($target_id) || !in_array($target_type, array('post', 'term'), true) ){ continue; } $tracked_targets[$tracking_id][] = array( 'id' => $target_id, 'type' => $target_type ); if($target_type === 'post'){ $post_ids[$target_id] = true; }else{ $term_ids[$target_id] = true; } } $post_statuses = self::get_link_whisper_target_post_statuses(array_keys($post_ids)); $existing_terms = self::get_existing_link_whisper_terms(array_keys($term_ids)); foreach($tracked_targets as $tracking_id => $targets){ $all_targets_invalid = true; foreach($targets as $target){ if($target['type'] === 'post'){ if(isset($post_statuses[$target['id']]) && $post_statuses[$target['id']] === 'publish'){ $all_targets_invalid = false; break; } }elseif(isset($existing_terms[$target['id']])){ $all_targets_invalid = false; break; } } $tracking_status_cache[$tracking_id] = $all_targets_invalid; } } } $invalid_tracking_ids = array(); foreach($tracking_ids as $tracking_id){ if(!empty($tracking_status_cache[$tracking_id])){ $invalid_tracking_ids[] = $tracking_id; } } return $invalid_tracking_ids; } /** * Gets the current statuses for the supplied post ids. * @param array $post_ids * @return array **/ private static function get_link_whisper_target_post_statuses($post_ids = array()){ global $wpdb; $post_ids = array_values(array_unique(array_filter(array_map('intval', (array) $post_ids)))); if(empty($post_ids)){ return array(); } $placeholders = implode(', ', array_fill(0, count($post_ids), '%d')); $results = $wpdb->get_results( $wpdb->prepare( "SELECT ID, post_status FROM {$wpdb->posts} WHERE ID IN ({$placeholders})", $post_ids ), ARRAY_A ); $statuses = array(); foreach($results as $result){ $statuses[(int) $result['ID']] = (string) $result['post_status']; } return $statuses; } /** * Gets the term ids that still exist for tracked Link Whisper targets. * @param array $term_ids * @return array **/ private static function get_existing_link_whisper_terms($term_ids = array()){ global $wpdb; $term_ids = array_values(array_unique(array_filter(array_map('intval', (array) $term_ids)))); if(empty($term_ids)){ return array(); } $placeholders = implode(', ', array_fill(0, count($term_ids), '%d')); $results = $wpdb->get_col( $wpdb->prepare( "SELECT term_id FROM {$wpdb->term_taxonomy} WHERE term_id IN ({$placeholders})", $term_ids ) ); $existing_terms = array(); foreach($results as $term_id){ $existing_terms[(int) $term_id] = true; } return $existing_terms; } /** * Filters the post content to remove any attributes that Link Whisper has added to links * @param string $content * @return string $content **/ public static function remove_link_whisper_attrs($content = ''){ if(empty(Wpil_Settings::get_filter_out_frontend_attributes())){ return $content; } $possible_attrs = array( 'data-wpil-keyword-link="linked"', 'data-wpil-monitor-id="[0-9]*"', 'data-wpil="url"', 'data-wpil-url-old=[\'"]([a-zA-Z0-9+=]*?)[\'"]', 'class="wpil_keyword_link"', 'wpil_keyword_link[\s]*?' ); $content = preg_replace('/' . implode('|', $possible_attrs) . '/', '', $content); return $content; } /** * Filters the post content to make links open in new tabs if they don't already. * Differentiates between internal and external links. * @param string $content * @return string $content **/ public static function add_link_attrs($content = ''){ global $post; // if there are no active attrs if(empty(Wpil_Settings::get_active_link_attributes()) && !apply_filters('wpil_add_link_attr_allow_change_url', false)){ // return the content return $content; } // don't apply link attributes to links with these classes $ignore_classes = array( 'page-numbers', 'navigation', 'nav-link' ); // allow users to filter the classes to ignore $ignore_classes = apply_filters('wpil_filter_link_attr_classes', $ignore_classes); // flip the classes for fast searching $ignore_classes = array_flip($ignore_classes); $post_url = (!empty($post) && isset($post->ID)) ? get_the_permalink($post->ID): false; preg_match_all('/<(a\s[^>]*?href=[\'"]([^\'"]*?)[\'"][^>]*?)>/', $content, $matches); foreach($matches[0] as $key => $link){ // if there are classes, check them to see if we should ignored the links $skip = false; if(false !== strpos($link, 'class=')){ preg_match('/class="([^"]*?)"/', $link, $classes); if(!empty($classes)){ $classes = explode(' ', $classes[1]); foreach($classes as $class){ if(isset($ignore_classes[$class])){ $skip = true; break; } } } } // if we found a class to skip if($skip){ // skip continue; } $url = $matches[2][$key]; // if this is a jump link if(Wpil_Report::isJumpLink($url, $post_url)){ // skip continue; } $attrs = Wpil_Settings::get_active_link_attrs($url); // the attrs to be applied $link_attrs = $matches[1][$key]; // the attrs that already exist for the link $extracted_link_attrs = self::extract_link_attributes($link_attrs); // a neatly sorted array of the existing attrs, keyed by the attr name $rel_attrs = array(); foreach($attrs as $attr){ switch ($attr) { case '_blank': if(false === strpos($link, 'target="_blank"') && false === strpos($link, "target='_blank'")){ $link_attrs .= ' target="_blank"'; } break; case 'no_blank': $link_attrs = str_replace(['target="_blank"', "target='_blank'"], '', $link_attrs); break; case 'dofollow': if(isset($extracted_link_attrs['rel'])){ $s = array_search('nofollow', $extracted_link_attrs['rel']); if(false !== $s){ unset($extracted_link_attrs['rel']); } } $rel_attrs[] = $attr; break; case 'nofollow': if(isset($extracted_link_attrs['rel'])){ $s = array_search('dofollow', $extracted_link_attrs['rel']); if(false !== $s){ unset($extracted_link_attrs['rel']); } } $rel_attrs[] = $attr; break; case 'sponsored': $rel_attrs[] = $attr; break; } } // if we have rel attrs to apply, and there were already some in the link if(!empty($rel_attrs)){ // if the link already had some if(isset($extracted_link_attrs['rel']) && !empty($extracted_link_attrs['rel'])){ // find all the compatible ones and add them to the list $rel_attrs = array_merge($rel_attrs, array_diff($extracted_link_attrs['rel'], $rel_attrs)); // and update the rel="" string from the link attrs $link_attrs = mb_ereg_replace('rel="[^"]*?"', 'rel="' . implode(' ', $rel_attrs) . '"', $link_attrs); }else{ // if there aren't any rel attrs in the string, tack ours on the end of the string $link_attrs .= ' rel="' . implode(' ', $rel_attrs) . '" '; } } // if the user reallllllyyyyyy wants to modify his link's URLs if(apply_filters('wpil_add_link_attr_allow_change_url', false)){ $new_url = apply_filters('wpil_add_link_attr_change_url', $url, Wpil_Link::isInternal($url)); if($url !== $new_url && !empty($url)){ $link_attrs = str_replace($url, $new_url, $link_attrs); } } if($matches[1][$key] !== $link_attrs){ $new_link = str_replace($matches[1][$key], $link_attrs, $link); $content = mb_ereg_replace(preg_quote($link), $new_link, $content); } } return $content; } /** * Extracts known link attributes from supplied anchors **/ public static function extract_link_attributes($link = ''){ if(empty($link)){ return array(); } // keep track of the attrs LW supports so we can detect collisions // $supported_attrs = array('nofollow', 'dofollow', '_blank', 'sponsored'); preg_match_all('/([a-zA-Z-]*)="([^"]+)"/', $link, $matches); $found_matches = array(); foreach($matches[0] as $key => $match){ $attr_name = $matches[1][$key]; $attr_value = $matches[2][$key]; // if this is a "rel" attr if($attr_name === 'rel'){ // explode it on any spaces $bits = explode(' ', $attr_value); // check for collisions with supported attrs // $collisions = array_intersect($bits, $supported_attrs); // todo remove after version 2.2.5 if I can't find a use for this (collisions) // if there are collisions // if(!empty($collisions)){ // save a record of them // $found_matches['collisions'] = $collisions; // } // and store the bits $found_matches[$attr_name] = $bits; }else{ $found_matches[$attr_name] = $attr_value; // if(in_array($attr_value, $supported_attrs, true)){ // $found_matches['collisions'][] = $attr_value; // } } } return $found_matches; } /** * Adds icons to links in content to aid in navigation and accessibility. * **/ public static function add_link_icons($content){ global $post; $add_to_external = Wpil_Settings::check_if_add_icon_to_link(); $add_to_internal = Wpil_Settings::check_if_add_icon_to_link(true); if($add_to_external === 'never' && $add_to_internal === 'never'){ return $content; } $ignore_post_external = Wpil_Settings::get_link_icon_ignore_post_list(); $ignore_post_internal = Wpil_Settings::get_link_icon_ignore_post_list(true); $ignored_external_post = (isset($post->ID)) ? in_array($post->ID, $ignore_post_external): false; $ignored_internal_post = (isset($post->ID)) ? in_array($post->ID, $ignore_post_internal): false; // if the user is completely ignoring a page if(!empty($post) && isset($post->ID) && $ignored_internal_post && $ignored_external_post){ // exit now return $content; } $ignore_html_external = Wpil_Settings::get_link_icon_html_exclude_tags(); $ignore_html_internal = Wpil_Settings::get_link_icon_html_exclude_tags(true); $ignore_inner_html_external = Wpil_Settings::get_link_icon_inner_html_exclude_tags(); $ignore_inner_html_internal = Wpil_Settings::get_link_icon_inner_html_exclude_tags(true); preg_match_all('/<(a\s[^>]*?href=[\'"]([^\'"]*?)[\'"][^>]*?)>.*?<\/a>/', $content, $matches); if(!empty($matches)){ // count the tag's ancestors so we can tell if we're supposed to skip adding an icon to it $tag_list = array(); preg_match_all('/]*?>(?:.*?<\/a>)+?|<[a-zA-Z\/]+?[ ]?[^>]*?>/', $content, $tags); if(!empty($tags)){ $link_ancestors = array(); foreach($tags[0] as $key => $tag){ if(empty($tag)){ continue; } if(false === strpos($tag, '/', $tag, $id); if(empty($id) || !isset($id[0])){ continue; } $id = trim(str_replace(['<', '/', '>'], '', $id[0])); if(!isset($link_ancestors[$id])){ $link_ancestors[$id] = 0; } $link_ancestors[$id]++; }else{ $tag_list[$tag] = $link_ancestors; } } } $added_external = false; $added_internal = false; $offset = 0; foreach($matches[0] as $key => $link){ $attrs = isset($matches[1][$key]) && !empty($matches[1][$key]) ? trim($matches[1][$key]): false; $url = isset($matches[2][$key]) && !empty($matches[2][$key]) ? trim($matches[2][$key]): false; $offset = Wpil_Word::mb_strpos($content, $link, $offset); // skip if there's no url if(empty($url)){ continue; } // first check if this is internal or external $internal = Wpil_Link::isInternal($url); if($internal && $ignored_internal_post){ continue; }else if(!$internal && $ignored_external_post){ continue; } if(!$internal){ if(!empty($ignore_html_external) && isset($tag_list[$link])){ foreach($ignore_html_external as $ignore){ if(isset($tag_list[$link][$ignore]) && $tag_list[$link][$ignore] % 2 !== 0){ continue 2; } } } if(!empty($ignore_inner_html_external)){ $inner_search = '<' . implode('\s|<', $ignore_inner_html_external) . '\s'; if(preg_match("/$inner_search/", $link, $m)){ continue; } } }else{ if(!empty($ignore_html_internal) && isset($tag_list[$link])){ foreach($ignore_html_internal as $ignore){ if(isset($tag_list[$link][$ignore]) && $tag_list[$link][$ignore] % 2 !== 0){ continue 2; } } } if(!empty($ignore_inner_html_internal)){ $inner_search = '<' . implode('\s|<', $ignore_inner_html_internal) . '\s'; if(preg_match("/$inner_search/", $link, $m)){ continue; } } } // if it's external and we're supposed to add icons to external links if(!$internal && $add_to_external !== 'never'){ if( $add_to_external === 'always' || // we're supposed to add the icon to all external ($add_to_external === 'new_tab' && $attrs && false !== strpos($attrs, 'target="_blank"')) // Or we're supposed to add the icon to external links that open in new tabs ){ $new_link = $link; $link_close = Wpil_Word::mb_strpos($new_link, ''); $new_start = mb_substr($new_link, 0, $link_close); $new_end = mb_substr($new_link, $link_close); $new_link = $new_start . self::get_link_icon(false, $added_external) . $new_end; $content = mb_ereg_replace(preg_quote($link), $new_link, $content); $added_external = true; } }elseif($internal && $add_to_internal !== 'never'){ if( $add_to_internal === 'always' || // we're supposed to add the icon to all external ($add_to_internal === 'new_tab' && $attrs && false !== strpos($attrs, 'target="_blank"')) // Or we're supposed to add the icon to external links that open in new tabs ){ $new_link = $link; $link_close = Wpil_Word::mb_strpos($new_link, ''); $new_start = mb_substr($new_link, 0, $link_close); $new_end = mb_substr($new_link, $link_close); $new_link = $new_start . self::get_link_icon(true, $added_internal) . $new_end; $content = mb_ereg_replace(preg_quote($link), $new_link, $content); $added_internal = true; } } } } return $content; } /** * Gets the formatted icon that's inserted into a link **/ public static function get_link_icon($internal = false, $return_reference = false){ $icon_name = Wpil_Settings::get_link_icon($internal); $icon_title = Wpil_Settings::get_link_icon_title($internal); $icon_size = Wpil_Settings::get_link_icon_size($internal); $icon_color = Wpil_Settings::get_link_icon_color($internal); $icon_styles = array( 'height' => $icon_size, 'width' => $icon_size, 'fill' => $icon_color, 'stroke' => $icon_color, 'display' => 'inline-block', ); $icon = self::get_svg_icon($icon_name, $return_reference, $icon_styles); $formatted_icon = '' . $icon . ''; return $formatted_icon; } /** * Gets SVG icon content so that we can use the HTML in PHP * **/ public static function get_svg_icon($name = '', $return_reference = false, $styles = array()){ if(empty($name)){ return ''; } $path = ''; $id = ''; $viewbox = ''; $svg = ''; switch ($name){ case 'new-tab-1': $path = ' '; $id = 'wpil-svg-new-tab-1-icon-path'; break; case 'new-tab-2': $path = ' '; $id = 'wpil-svg-new-tab-2-icon-path'; break; case 'outbound-1': $path = ' '; $id = 'wpil-svg-outbound-1-icon-path'; break; case 'outbound-2': $path = ' '; $id = 'wpil-svg-outbound-2-icon-path'; break; case 'outbound-3': $path = ' '; $id = 'wpil-svg-outbound-3-icon-path'; break; case 'outbound-4': $path = ' '; $id = 'wpil-svg-outbound-4-icon-path'; break; case 'outbound-5': $path = ' '; $id = 'wpil-svg-outbound-5-icon-path'; break; case 'outbound-6': $path = ' '; $id = 'wpil-svg-outbound-6-icon-path'; break; case 'outbound-7': $path = ' '; $id = 'wpil-svg-outbound-7-icon-path'; break; case 'outbound-8': $path = ' '; $id = 'wpil-svg-outbound-8-icon-path'; break; case 'previous-track': $path = ' '; $id = 'wpil-svg-previous-track-icon-path'; $viewbox = '0 0 56 56'; break; case 'pause': $path = ' '; $id = 'wpil-svg-pause-icon-path'; $viewbox = '0 0 56 56'; break; case 'play': $path = ' '; $id = 'wpil-svg-play-icon-path'; $viewbox = '0 0 56 56'; break; case 'next-track': $path = ' '; $id = 'wpil-svg-next-track-icon-path'; $viewbox = '0 0 56 56'; break; } if(!empty($path)){ $custom_style = ''; if(!empty($styles)){ $custom_style = Wpil_Toolbox::validate_inline_styles($styles, true); } if(!empty($viewbox) && !empty($custom_style)){ // width="auto" height="auto" $style = ' ' . $custom_style . ' viewBox="'.$viewbox.'"'; }else{ $style = 'width="24" height="24" ' . $custom_style . ' viewBox="0 0 24 24"'; } $svg = ''; if($return_reference){ $svg .= ''; }else{ $svg .= $path; } $svg .= ''; } return $svg; } /** * Gets a list of the possible SVG icons * **/ public static function get_svg_icon_names(){ return array( 'new-tab-1', 'new-tab-2', 'outbound-1', 'outbound-2', 'outbound-3', 'outbound-4', 'outbound-5', 'outbound-6', 'outbound-7', 'outbound-8'); } public static function fixCollation($table) { global $wpdb; $table_status = $wpdb->get_results("SHOW TABLE STATUS where name like '$table'"); if (empty($table_status[0]->Collation) || $table_status[0]->Collation != 'utf8mb4_unicode_ci') { $wpdb->query("alter table $table convert to character set utf8mb4 collate utf8mb4_unicode_ci"); } } public static function verify_nonce($key) { $user = wp_get_current_user(); if(!isset($_REQUEST['nonce']) || !wp_verify_nonce($_REQUEST['nonce'], $user->ID . $key)){ wp_send_json(array( 'error' => array( 'title' => __('Data Error', 'wpil'), 'text' => __('There was an error in processing the data, please reload the page and try again.', 'wpil'), ) )); } } /** * Checks if there's a function hooked to a particular action or filter. * We have to flip through the hooked functions because a lot of the methods use instantiated objects. * Currently only checks for object methods since has_action is all we need for inline functions * * @param string $tag The hook/filter name that the function is hooked to * @param string $object The object who's method we're removing from the hook/filter * @param string $function The object method that we're removing from the hook/filter * @param int|bool $hook_priority The priority of the function that we're removing **/ public static function has_hooked_function($tag, $object, $function, $hook_priority = false){ global $wp_filter; $priority = intval($hook_priority); // if the hook that we're looking for does exist and at the priority we're looking for if( isset($wp_filter[$tag]) && isset($wp_filter[$tag]->callbacks) && !empty($wp_filter[$tag]->callbacks)) { if( isset($wp_filter[$tag]->callbacks[$priority]) && !empty($wp_filter[$tag]->callbacks[$priority])) { // look over all the callbacks in the priority we're looking in foreach($wp_filter[$tag]->callbacks[$priority] as $key => $data) { // if the current item is the callback we're looking for if(isset($data['function']) && (is_a($data['function'][0], $object) || $data['function'][0] === $object) && $data['function'][1] === $function){ // return that we've found it return true; } } }elseif(false === $hook_priority){ // if there's no priority, flip through all the posssible priorities foreach($wp_filter[$tag]->callbacks as $priority => $dat) { foreach($wp_filter[$tag]->callbacks[$priority] as $key => $data) { // if the current item is the callback we're looking for if(isset($data['function']) && (is_a($data['function'][0], $object) || $data['function'][0] === $object) && $data['function'][1] === $function){ // return that we've found it return true; } } } } } return false; } /** * Removes a hooked function from the wp hook or filter. * We have to flip through the hooked functions because a lot of the methods use instantiated objects * * @param string $tag The hook/filter name that the function is hooked to * @param string $object The object who's method we're removing from the hook/filter * @param string $function The object method that we're removing from the hook/filter * @param int $priority The priority of the function that we're removing **/ public static function remove_hooked_function($tag, $object, $function, $priority){ global $wp_filter; $priority = intval($priority); // if the hook that we're looking for does exist and at the priority we're looking for if( isset($wp_filter[$tag]) && isset($wp_filter[$tag]->callbacks) && !empty($wp_filter[$tag]->callbacks) && isset($wp_filter[$tag]->callbacks[$priority]) && !empty($wp_filter[$tag]->callbacks[$priority])) { // look over all the callbacks in the priority we're looking in foreach($wp_filter[$tag]->callbacks[$priority] as $key => $data) { // if the current item is the callback we're looking for if(isset($data['function']) && (is_a($data['function'][0], $object) || $data['function'][0] === $object) && $data['function'][1] === $function){ // remove the callback unset($wp_filter[$tag]->callbacks[$priority][$key]); } } } } /** * Removes all functions that are of a lower priority than the one we supply. * If we're working on a main stack process, and we need to loop back for something, * there shouldn't be a need to re-call all the other functions that have gone before * * @param string $tag The hook/filter name that the functions are hooked to * @param int $priority_limit The limit on how high of priority hooks we should remove **/ public static function remove_lower_priority_hooked_functions($tag, $priority_limit = 0){ global $wp_filter; $priority_limit = intval($priority_limit); // if the hook that we're looking for does exist and at the priority we're looking for if( isset($wp_filter[$tag]) && isset($wp_filter[$tag]->callbacks) && !empty($wp_filter[$tag]->callbacks)) { foreach($wp_filter[$tag]->callbacks as $priority => $callbacks){ if($priority < $priority_limit){ unset($wp_filter[$tag]->callbacks[$priority]); } } } } /** * Checks to see if one of the calling ancestors of the current function is what we're looking for **/ public static function has_ancestor_function($function_name = '', $class_name = ''){ if(empty($function_name)){ return false; } $call_stack = debug_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS); if(!empty($call_stack)){ foreach($call_stack as $call){ if( isset($call['function']) && $call['function'] === $function_name && (empty($class_name) || isset($call['class']) && $call['class'] === $class_name) ){ return true; } } } return false; } /** * Updates the WP option cache independently of the update_options functionality. * I've found that for some users the cache won't update and that keeps some option based processing from working. * The code is mostly pulled from the update_option function * * @param string $option The name of the option that we're saving. * @param mixed $value The option value that we're saving. **/ public static function update_option_cache($option = '', $value = ''){ $option = trim( $option ); if ( empty( $option ) ) { return false; } $serialized_value = maybe_serialize( $value ); $alloptions = wp_load_alloptions( true ); if ( isset( $alloptions[ $option ] ) ) { $alloptions[ $option ] = $serialized_value; wp_cache_set( 'alloptions', $alloptions, 'options' ); } else { wp_cache_set( $option, $serialized_value, 'options' ); } } /** * Makes sure that the transients are set and that the option cache is updated when data is saved. * There are some cases of the transients not sticking, even though they are supposed to be active. * I believe the issue is object caching catching the update information, and then not passing it back when we ask for it. * * Uses the same arguments as the WP transient function **/ public static function set_transient($transient, $value, $expiration = 0) { $expiration = (int) $expiration; $transient_timeout = '_transient_timeout_' . $transient; $transient_option = '_transient_' . $transient; if(false === get_option($transient_option)){ $autoload = 'yes'; if($expiration){ $autoload = 'no'; add_option($transient_timeout, time() + $expiration, '', 'no'); } $result = add_option($transient_option, $value, '', $autoload); }else{ /* * If expiration is requested, but the transient has no timeout option, * delete, then re-create transient rather than update. */ $update = true; if($expiration){ if(false === get_option($transient_timeout)){ delete_option($transient_option); add_option($transient_timeout, time() + $expiration, '', 'no'); $result = add_option($transient_option, $value, '', 'no'); $update = false; }else{ update_option($transient_timeout, time() + $expiration); self::update_option_cache($transient_timeout, time() + $expiration); } } if($update){ $result = update_option($transient_option, $value); self::update_option_cache($transient_option, $value); } } return $result; } /** * Deletes all Link Whisper related data on plugin deletion **/ public static function delete_link_whisper_data(){ global $wpdb; // if we're not really sure that the user wants to delete all data, exit if('1' !== get_option('wpil_delete_all_data', false)){ return; } // create a list of all possible tables $tables = self::getDatabaseTableList(); // go over the list of tables and delete all tables that exist foreach($tables as $table){ $table_exists = $wpdb->get_var("SHOW TABLES LIKE '{$table}'"); if($table_exists === $table){ $wpdb->query("DROP TABLE {$table}"); } } // delete all of the settings from the options table $wpdb->query("DELETE FROM {$wpdb->options} WHERE `option_name` LIKE 'wpil_%'"); // clear all of the transients $wpdb->query("DELETE FROM {$wpdb->options} WHERE `option_name` LIKE '_transient_wpil_%' OR `option_name` LIKE '_transient_timeout_wpil_%'"); // delete all of the link metafields Wpil_Report::clearMeta(); } /** * Checks to see if we're over the time limit. * * @param int $time_pad The amount of time in advance of the PHP time limit that is considered over the time limit * @param int $max_time The absolute time limit that we'll wait for the current process to complete * @return bool **/ public static function overTimeLimit($time_pad = 0, $max_time = null, $return_time_limit = false){ $limit = ini_get( 'max_execution_time' ); // if there is no limit or the limit is larger than 90 seconds if(empty($limit) || $limit === '-1' || $limit > 90){ // create a self imposed limit so the user know LW is still working on looped actions $limit = 90; } // filter the limit so users with special constraints can make adjustments $limit = apply_filters('wpil_filter_processing_time_limit', $limit); // if the exit time pad is less than the limit if($limit < $time_pad){ // default to a 5 second pad $time_pad = 5; } // if we're supposed to return the time limit if($return_time_limit){ // find the shortest processing time and return it return ($max_time !== null && $max_time < ($limit - $time_pad)) ? $max_time: ($limit - $time_pad); } // get the current time $current_time = microtime(true); // if we've been running for longer than the PHP time limit minus the time pad, OR // a max time has been set and we've passed it if( ($current_time - WPIL_STATUS_PROCESSING_START) > ($limit - $time_pad) || $max_time !== null && ($current_time - WPIL_STATUS_PROCESSING_START) > $max_time) { // signal that we're over the time limit return true; }else{ return false; } } /** * Creates the database tables so we're sure that they're all set. * I'll still use the old method of creation for a while as a fallback. * But this will make LW more plug-n-play **/ public static function createDatabaseTables(){ Wpil_ClickTracker::prepare_table(); Wpil_Error::prepareTable(false); Wpil_Error::prepareIgnoreTable(); Wpil_Keyword::prepareTable(); // also prepares the possible links table Wpil_TargetKeyword::prepareTable(); Wpil_URLChanger::prepareTable(); Wpil_Widgets::prepare_table(); Wpil_AI::prepare_table(); Wpil_Report::prepare_link_tracking_table(); Wpil_Sitemap::prepare_table(); Wpil_Telemetry::prepare_table(); Wpil_LinkMapping::prepare_table(); Wpil_Error::prepareSnoozeTable(); // search console table not included because it's explicitly activated by the user // linked site data table also not included because it's explicitly activated by the user } /** * Returns an array of all the tables created by Link Whisper. * @param bool $should_prefix Should the returned tables have the site's database prefix attached? * @return array **/ public static function getDatabaseTableList($should_prefix = true){ global $wpdb; if($should_prefix){ $prefix = $wpdb->prefix; }else{ $prefix = ''; } return array( "{$prefix}wpil_broken_links", "{$prefix}wpil_ignore_links", "{$prefix}wpil_click_data", "{$prefix}wpil_keywords", "{$prefix}wpil_keyword_links", "{$prefix}wpil_keyword_select_links", "{$prefix}wpil_report_links", "{$prefix}wpil_tracked_link_ids", "{$prefix}wpil_search_console_data", "{$prefix}wpil_site_linking_data", "{$prefix}wpil_target_keyword_data", "{$prefix}wpil_urls", "{$prefix}wpil_url_links", "{$prefix}wpil_related_posts", "{$prefix}wpil_ai_post_data", "{$prefix}wpil_ai_product_data", "{$prefix}wpil_ai_keyword_data", "{$prefix}wpil_ai_token_use_data", "{$prefix}wpil_ai_embedding_data", "{$prefix}wpil_ai_embedding_calculation_data", "{$prefix}wpil_ai_embedding_phrase_data", "{$prefix}wpil_ai_embedding_phrase_calculation_data", "{$prefix}wpil_ai_suggested_anchors", "{$prefix}wpil_ai_processed_sentences", "{$prefix}wpil_ai_batch_log", "{$prefix}wpil_ai_error_log", "{$prefix}wpil_ai_system_error_log", "{$prefix}wpil_ai_completed_batch_log", ); } /** * Helper function to set WP to not use external object caches when doing AJAX **/ public static function ignore_external_object_cache($ignore_ajax = false){ if( (defined('DOING_AJAX') && DOING_AJAX || $ignore_ajax) && function_exists('wp_using_ext_object_cache') && file_exists( WP_CONTENT_DIR . '/object-cache.php') && wp_using_ext_object_cache()) { if(!defined('WP_REDIS_DISABLED') && defined('WP_REDIS_FILE')){ define('WP_REDIS_DISABLED', true); } wp_using_ext_object_cache(false); } if(defined('DOING_AJAX') && DOING_AJAX || $ignore_ajax){ if(function_exists('nocache_headers')){ nocache_headers(); } if(!defined('DONOTCACHEOBJECT')){ define('DONOTCACHEOBJECT', true); } if(!defined('DONOTCACHEDB')){ define('DONOTCACHEDB', true); } } } /** * Helper function to remove any problem hooks interfering with our AJAX requests * * @param bool $ignore_ajax True allows the removing of hooks when ajax is not running **/ public static function remove_problem_hooks($ignore_ajax = false){ $admin_ajax = is_admin() && defined('DOING_AJAX') && DOING_AJAX; if( ($admin_ajax || $ignore_ajax) && defined('TOC_VERSION')){ remove_all_actions('wp_enqueue_scripts'); } } /** * Tracks actions that have taken place so we can tell if something in a distantly connected part of Link Whisper happened * * @param string $action The name we've given to the action that's happened * @param mixed $value The value of the action that we're watching * @param bool $overwrite_true Should we overwrite TRUE results with whatever we currently have? By default, we don't so we can track if a result happened somewhere **/ public static function track_action($action = '', $value = null, $overwrite_true = false){ if(empty($action) || !is_string($action)){ return; } // if the action has happened AND we should overwrite that status with the most recent one if(isset(self::$action_tracker[$action]) && !empty(self::$action_tracker[$action]) && $overwrite_true){ self::$action_tracker[$action] = $value; }elseif(!array_key_exists($action, self::$action_tracker)){ // if the event has not happened yet self::$action_tracker[$action] = $value; }elseif(array_key_exists($action, self::$action_tracker) && empty(self::$action_tracker[$action]) && !empty($value)){ // if the event has been attempted and hasn't succeeded yet, but we now have a record of it happening! self::$action_tracker[$action] = $value; } } public static function action_happened($action = '', $return_result = true){ if(empty($action) || !is_string($action)){ return false; } $logged = array_key_exists($action, self::$action_tracker); if(!$logged){ return false; } return ($return_result) ? self::$action_tracker[$action]: $logged; } public static function clear_tracked_action($action = ''){ if(empty($action) || !is_string($action)){ return; } if(array_key_exists($action, self::$action_tracker)){ unset(self::$action_tracker[$action]); } } public static function ajax_term_search(){ $return = array(); if(isset($_POST['select_type']) && !empty($_POST['select_type'])){ $terms = array(); if($_POST['select_type'] === 'tag-search'){ $terms = self::search_terms_by_name_for_post_types($_POST['search'], false, Wpil_Settings::getPostTypes()); }elseif($_POST['select_type'] === 'cat-search'){ $terms = self::search_terms_by_name_for_post_types($_POST['search'], true, Wpil_Settings::getPostTypes()); } if(!empty($terms)){ foreach($terms as $term){ $return[] = array('id' => $term->term_id, 'text' => esc_attr($term->name)); } } } wp_send_json($return); } public static function search_terms_by_name_for_post_types($term_name, $is_hierarchical, $post_types = array('post')) { Wpil_Base::verify_nonce('wpil_multiselect_term_search_nonce'); // Get all taxonomies for the specified post types $filtered_taxonomies = array(); foreach ($post_types as $post_type) { $taxonomies = get_object_taxonomies($post_type, 'objects'); foreach ($taxonomies as $taxonomy => $details) { if ($details->hierarchical == $is_hierarchical) { $filtered_taxonomies[] = $taxonomy; } } } // Remove duplicate taxonomies $filtered_taxonomies = array_unique($filtered_taxonomies); // If no taxonomies match the criteria, return an empty array if (empty($filtered_taxonomies)) { return array(); } // Search for terms by name in the filtered taxonomies $terms = get_terms(array( 'taxonomy' => $filtered_taxonomies, 'search' => $term_name, 'hide_empty' => false, )); return $terms; } public static function ajax_post_search(){ $return = array(); if(isset($_POST['select_type']) && !empty($_POST['select_type'])){ $post = array(); if($_POST['select_type'] === 'post-search'){ $posts = self::search_posts_by_name_for_post_types($_POST['search'], Wpil_Settings::getPostTypes()); } if(!empty($posts)){ foreach($posts as $post){ $return[] = array('id' => $post->ID, 'text' => esc_attr($post->post_title)); } } } wp_send_json($return); } public static function search_posts_by_name_for_post_types($post_name, $post_types = array('post')) { Wpil_Base::verify_nonce('wpil_multiselect_post_search_nonce'); $args = array( 'post_type' => $post_types, 'post_status' => 'publish', 's' => sanitize_text_field($post_name), 'search_columns' => array('post_title'), 'posts_per_page' => -1 ); $posts = get_posts($args); return $posts; } public static function ajax_hide_explain_page(){ Wpil_Base::verify_nonce('wpil-floating-help-menu-nonce'); $user_id = get_current_user_id(); if(isset($_POST['hide_on_all_pages']) && !empty((int)$_POST['hide_on_all_pages'])){ update_user_meta($user_id, 'wpil_hide_explain_page_completely', '1'); }else{ if(isset($_POST['current_page']) && !empty($_POST['current_page'])){ $available_pages = self::get_available_pages(); if(in_array($_POST['current_page'], $available_pages)){ $hidden_pages = get_user_meta($user_id, 'wpil_hide_explain_page_on', true); if(empty($hidden_pages)){ $hidden_pages = array(); } $hidden_pages[] = trim($_POST['current_page']); update_user_meta($user_id, 'wpil_hide_explain_page_on', $hidden_pages); } } } } public static function ajax_save_wizard_settings(){ Wpil_Base::verify_nonce('wpil_wizard_save_nonce'); $response = array('status' => 'invalid', 'message' => 'please select all of the required options to proceed'); if(isset($_POST['settings']) && !empty($_POST['settings'])){ // verify the settings $settings = array( 'wpil_setup_wizard_existing_user', 'wpil_setup_wizard_configure_settings', 'wpil_setup_wizard_run_linking' ); $acceptable_values = array( 'yes', 'no' ); $save_settings = array(); foreach($_POST['settings'] as $key => $value){ if(in_array($key, $settings, true) && in_array($value, $acceptable_values, true)){ $save_settings[$key] = $value; } } if(!empty($save_settings)){ update_option('wpil_wizard_settings_selected', $save_settings); // if we're not just saving the settings if(!isset($_POST['temp_save']) || empty($_POST['temp_save'])){ self::configure_wizard_settings(); } } // log that the user has run the wizard since this should happen right before all the scanning takes placce Wpil_Telemetry::log_event('ran_installation_wizard'); $response = array('status' => 'valid', 'message' => 'Settings Saved!'); } wp_send_json($response); } public static function configure_wizard_settings(){ delete_option('wpil_wizard_import_autolink_rules'); $settings = get_option('wpil_wizard_settings_selected'); $preconfigured = array( 'wpil_add_destination_title' => '1', 'wpil_ignore_tags_from_linking' => array('code', 'pre'), 'wpil_ignore_latest_posts' => '1', 'wpil_update_reusable_block_links' => '1', 'wpil_override_global_post_during_scan' => '1', 'wpil_use_link_data_table' => '1', 'wpil_make_suggestion_filtering_persistent' => '1', 'wpil_disable_click_tracking_info_gathering' => '1', 'wpil_override_global_post_during_scan' => '1', 'wpil_use_link_data_table' => '1', 'wpil_ignore_latest_posts' => '1', 'wpil_remove_noindex_post_suggestions' => '1', 'wpil_ignore_image_urls' => '1', 'wpil_suggestion_anchor_max_size' => '7', 'wpil_suggestion_anchor_min_size' => '3' ); if( isset($settings['wpil_setup_wizard_configure_settings']) && $settings['wpil_setup_wizard_configure_settings'] === 'yes' || isset($settings['wpil_setup_wizard_run_linking']) && $settings['wpil_setup_wizard_run_linking'] === 'yes' // if they're having us do the linking, assume they want us to do the settings too for the time being ){ foreach($preconfigured as $key => $value){ update_option($key, $value); } $ignore_pages = Wpil_Settings::get_service_pages_to_ignore(); if(!empty($ignore_pages)){ $links = get_option('wpil_ignore_pages_completely', ''); $links_array = explode("\n", $links); foreach($ignore_pages as $id){ $post = new Wpil_Model_Post($id); $post_link = $post->getViewLink(); if(!empty($post_link) && !in_array($post_link, $links_array)){ $links .= "\n" . $post_link; } } // clear any ignore link cache that exists delete_transient('wpil_ignore_pages_completely'); // save the ignore link update_option('wpil_ignore_pages_completely', $links); } update_option('wpil_wizard_import_autolink_rules', 1); // set the flag to say that we'll be importing autolinhk rules delete_option('wpil_wizard_settings_selected'); // clear the setting data so we done redo the settings without the user selecting it } } public static function ajax_wizard_save_oai_key(){ Wpil_Base::verify_nonce('wpil_wizard_save_nonce'); if(isset($_POST['key']) && !empty($_POST['key'])){ // update the api key update_option('wpil_open_ai_api_key', Wpil_Toolbox::encrypt(trim(sanitize_text_field($_POST['key'])))); // and check if this is a free key Wpil_AI::is_free_oai_subscription(true); } wp_send_json(array('status' => 'valid')); } public static function ajax_clear_process_tracker(){ delete_option('wpil_ai_linking_process_key'); delete_transient('wpil_review_served_' . get_current_user_id()); delete_transient('wpil_loading_progress_tracker'); delete_transient('wpil_wizard_has_completed'); delete_transient('wpil_wizard_inserting_autolinks'); update_option('wpil_wizard_start_time', time()); // note the start time wp_send_json(array('status' => 'tracker_cleared')); } /** * Set a flahg so we know that the user has run the wizard **/ public static function ajax_has_run_wizard(){ Wpil_Settings::set_run_wizard(); } /** * Set a flahg so we know that the user has run the wizard **/ public static function ajax_set_processing_complete_flag(){ // set the completion flag set_transient('wpil_wizard_has_completed', 1, HOUR_IN_SECONDS); // if the notification emails are enabled if(Wpil_Settings::email_notifications_are_enabled()){ // send the completion email Wpil_Email::send_email_notification('wizard-complete'); } } /** * Checks to see how many links have been inserted since the wizard began **/ public static function ajax_get_wizard_insert_count(){ self::verify_nonce('wpil_dashboard_loading_nonce'); global $wpdb; $table = $wpdb->prefix . 'wpil_tracked_link_ids'; $start_time = get_option('wpil_wizard_start_time', time()); $link_count = $wpdb->get_col("SELECT COUNT(*) FROM {$table} WHERE `creation_time` > {$start_time}"); wp_send_json(array('data' => array('link_inserts' => $link_count, 'finished' => (!empty(get_transient('wpil_wizard_has_completed')) || empty(get_transient('wpil_doing_ajax_autolinks')))))); } /** * **/ public static function ajax_dismiss_ai_popup_banner(){ update_user_meta(get_current_user_id(), 'wpil_dismissed_ai_notice_banner', '1'); } public static function ajax_update_expanded_details_toggle(){ $status = (!isset($_POST['status']) || empty($_POST['status'])) ? 0: 1; update_option('wpil_show_expanded_suggestion_details', $status); wp_send_json('updated details!'); } }