. * For questions related to this program contact post@webraketen-media.de */ namespace SeoAutomatedLinkBuilding; class Plugin { protected $name; public static $domain = 'seo-automated-link-building'; private $dbVersion = '1.4.1'; protected $editData = null; protected $statisticData = null; protected $settings; /** * returns the required capability to make this plugin usable * @return string */ protected function getUserCapability(){ return 'manage_options'; } protected function getEditData() { if($this->editData) { return $this->editData; } $page = null; $link = null; $id = isset($_GET['id']) && ctype_digit($_GET['id']) ? (int)$_GET['id'] : null; if($id && !isset($_GET['action'])) { $link = Link::get($id); if($link && $link->page_id) { $page = Post::query() ->select('ID as id, post_type as type, post_title as title') ->where('ID', $link->page_id) ->get_row(); } } $this->editData = new \stdclass(); $this->editData->link = $link; $this->editData->page = $page; return $this->editData; } /** * @param string|null $key * @param string|null $subkey * * @return mixed */ public function getSettings($key = null, $subkey = null) { if ($key !== null){ if(array_key_exists($key, $this->settings)){ if($subkey !== null) { if(array_key_exists($subkey, $this->settings[$key])) { return $this->settings[$key][$subkey]; } return false; } return $this->settings[$key]; } return false; } return $this->settings; } protected function getStatisticData() { if($this->statisticData) { return $this->statisticData; } $list = new Statistic_List('seo-automated-link-building'); $list->preDisplay(); $maxDays = 28; $dtNow = new \DateTime(); $dtNow->modify('today'); $dtNow->modify('-' . ($maxDays-1) . ' days'); $data = Statistic::query() ->select('count(*) as cnt, YEAR(created_at) as y, MONTH(created_at) as m, DAYOFMONTH(created_at) as d') ->where('created_at', '>', $dtNow->format('Y-m-d H:i:s e')) ->group_by(["YEAR(created_at), MONTH(created_at), DAYOFMONTH(created_at)"]) ->get_results(); $linkTable = Link::get_table_name(); $bestResults = Statistic::query() ->select("count(*) as cnt, link_id, $linkTable.title as title") ->join($linkTable, 'link_id', 'id') ->group_by(['link_id']) ->order_by('cnt', 'desc') ->get_results(); $best = []; foreach($bestResults as $index => $result) { $best[] = ['x' => $index, 'y' => (int)$result['cnt'], 'label' => "{$result['title']} (#{$result['link_id']})"]; } $countsIndex = []; foreach($data as $d) { $countsIndex[$d['y'] . '-' . str_pad($d['m'], 2, '0', STR_PAD_LEFT) . '-' . str_pad($d['d'], 2, '0', STR_PAD_LEFT)] = (int)$d['cnt']; } $counts = []; for($i = 0; $i < 28; $i++) { $key = $dtNow->format('Y-m-d'); $counts[] = [ 'x' => $key, 'y' => array_key_exists($key, $countsIndex) ? $countsIndex[$key] : 0, ]; $dtNow->modify('+1 day'); } $this->statisticData = new \stdclass(); $this->statisticData->list = $list; $this->statisticData->data = $data; $this->statisticData->counts = $counts; $this->statisticData->best = $best; return $this->statisticData; } protected function getPostData($strip = array()) { if(empty($strip)) { return $_POST; } $stripIndex = array_flip($strip); // we dont want to have magic quotes, so removed them form input, but don't change $_POST directly // like described here https://developer.wordpress.org/reference/functions/stripslashes_deep/ // in addition all data returned by this function will be sanitized and/or validated to ensure security // ActiveRecord implementation will quote text for safe database entries $data = array(); foreach($_POST as $key => $value) { $data[$key] = array_key_exists($key, $stripIndex) ? stripslashes_deep($value) : $value; } return $data; } public function __construct($name) { $this->name = $name; add_action( 'init', [$this, 'init'] ); if(is_admin()) { add_filter("plugin_action_links_$name", [$this, 'addActionLinks']); add_filter('set-screen-option', [$this, 'setCMIOptions'], 10, 3); add_action('admin_menu', [$this, 'addMenuItems']); register_activation_hook( $name, [$this, 'updateTable']); register_uninstall_hook( $name, [get_called_class(), 'removeTable']); add_action( 'plugins_loaded', [$this, 'updateTable'] ); add_action( 'admin_post_seo_automated_link_building_add_link', [$this, 'addLink']); add_action( 'admin_post_seo_automated_link_building_import_links', [$this, 'importLinks']); add_action( 'admin_post_seo_automated_link_building_settings', [$this, 'updateSettings']); add_action( 'admin_post_seo_automated_link_building_edit_link', [$this, 'editLink']); add_action( 'wp_ajax_seo_automated_link_building_find_pages', [$this, 'findPages'] ); add_action( 'wp_ajax_seo_automated_link_building_export_links', [$this, 'exportLinks']); add_action( 'admin_enqueue_scripts', [$this, 'enqueueAdminScripts']); add_action( 'wp_ajax_seo_automated_link_building_track_link', [$this, 'trackLink'] ); add_action( 'admin_notices', [$this, 'displayAdminMessage']); } add_action( 'wp_ajax_nopriv_seo_automated_link_building_track_link', [$this, 'trackLink'] ); add_action( 'wp_enqueue_scripts', [$this, 'enqueueScripts'] ); add_filter('the_content', [$this, 'changeContent'], 99); } public function init() { Settings::init(); $this->settings = Settings::get(); } public function enqueueAdminScripts($hook_suffix) { wp_enqueue_script('seo-automated-link-building-common', plugins_url('/js/seo-automated-link-building.admin.js', $this->name ), ['jquery', 'wp-i18n'], '1.0.0', true ); wp_set_script_translations('seo-automated-link-building-common', 'seo-automated-link-building'); // edit/creation page if($hook_suffix === 'internal-links-manager_page_seo-automated-link-building-add-link' || $hook_suffix === 'toplevel_page_seo-automated-link-building-all-links' && $this->getEditData()->link) { // taggle (https://sean.is/poppin/tags) wp_enqueue_script( 'taggle', plugins_url( '/js/external/taggle.min.js', $this->name ), array() ); wp_enqueue_style( 'taggle', plugins_url( '/css/external/taggle.min.css', $this->name ), array() ); // jquery auto-complete wp_enqueue_script( 'jquery.auto-complete', plugins_url( '/js/external/jquery.auto-complete.min.js', $this->name ), array('jquery') ); wp_enqueue_style( 'jquery.auto-complete', plugins_url( '/css/external/jquery.auto-complete.min.css', $this->name ), array() ); // page specific wp_enqueue_style( 'seo-automated-link-building-edit', plugins_url( '/css/edit.css', $this->name ), array() ); wp_enqueue_script( 'seo-automated-link-building-edit', plugins_url( '/js/edit.js', $this->name ), array('taggle', 'jquery.auto-complete') ); $editData = $this->getEditData(); $link = $editData->link; $page = $editData->page; wp_localize_script( 'seo-automated-link-building-edit', 'seoAutomatedLinkBuildingEdit', array( 'titleWarning' => __('Please provide an internal title', 'seo-automated-link-building'), 'urlWarning' => __('Please provide an URL', 'seo-automated-link-building'), 'pageWarning' => __('Please provide a page', 'seo-automated-link-building'), 'keywordsWarning' => __('Please provide keywords', 'seo-automated-link-building'), 'adminAjax' => admin_url( 'admin-ajax.php' ), 'replaceHint' => __('Words to replace...', 'seo-automated-link-building'), 'keywords' => $link ? json_decode($link->keywords) : [], 'page' => $page, )); return; } if($hook_suffix === 'toplevel_page_seo-automated-link-building-all-links') { $action = isset($_POST['action']) ? sanitize_text_field($_POST['action']) : ''; $ids = isset($_REQUEST['id']) ? wp_parse_id_list($_REQUEST['id']) : null; if(is_null($ids) || empty($ids)) { return; } if($action === 'export') { // hack: some html has to be written that exportLinks will work print ''; $export = ImportExport::exportLinks($ids); $export = str_replace("`", "\\`", $export); wp_enqueue_script( 'download.js', plugins_url( '/js/external/download.min.js', $this->name ), array() ); wp_enqueue_script( 'seo-automated-link-building-export', plugins_url( '/js/export.js', $this->name ), array('download.js') ); wp_localize_script( 'seo-automated-link-building-export', 'seoAutomatedLinkBuildingExport', array( 'export' => $export, )); } return; } if($hook_suffix === 'internal-links-manager_page_seo-automated-link-building-settings') { // page specific wp_enqueue_style( 'seo-automated-link-building-settings', plugins_url( '/css/settings.css', $this->name ), array() ); wp_enqueue_script( 'seo-automated-link-building-settings', plugins_url( '/js/settings.js', $this->name ), array('jquery') ); return; } if($hook_suffix === 'internal-links-manager_page_seo-automated-link-building-import-links') { wp_enqueue_script( 'download.js', plugins_url( '/js/external/download.min.js', $this->name ), array() ); wp_enqueue_script( 'dropzone.js', plugins_url( '/js/external/dropzone.min.js', $this->name ), array() ); // page specific wp_enqueue_style( 'seo-automated-link-building-import', plugins_url( '/css/import.css', $this->name ), array() ); wp_enqueue_script( 'seo-automated-link-building-import', plugins_url( '/js/import.js', $this->name ), array('jquery', 'download.js', 'dropzone.js') ); wp_localize_script( 'seo-automated-link-building-import', 'seoAutomatedLinkBuildingImport', array( 'importHint' => __('Drop files here to import', 'seo-automated-link-building'), 'redirectUrl' => admin_url( "admin.php?page=seo-automated-link-building-all-links" ), 'adminAjax' => admin_url( 'admin-ajax.php' ), )); return; } if($hook_suffix === 'internal-links-manager_page_seo-automated-link-building-statistic') { wp_enqueue_script( 'chart.js', plugins_url( '/js/external/Chart.bundle.min.js', $this->name ), array() ); // page specific wp_enqueue_script( 'seo-automated-link-building-statistic', plugins_url( '/js/statistic.js', $this->name ), array('jquery', 'chart.js') ); wp_enqueue_style( 'seo-automated-link-building-statistic', plugins_url( '/css/statistic.css', $this->name ), array() ); $data = $this->getStatisticData()->counts; $best = $this->getStatisticData()->best; wp_localize_script( 'seo-automated-link-building-statistic', 'seoAutomatedLinkBuildingStatistic', array( 'data' => $data, 'label' => __('Clicks', 'seo-automated-link-building'), 'tooltipFormat' => __('MM/DD/YYYY', 'seo-automated-link-building'), 'date' => __('Date', 'seo-automated-link-building'), 'best' => $best, 'title' => __('Title'), )); return; } } public function enqueueScripts() { $activate_tracking = true; $user = wp_get_current_user(); if(Settings::get()['disableStatistics'] || ($user->get('ID') > 0 && Settings::get()['disableAdminTracking'])) { $activate_tracking = false; } if($activate_tracking === true) { wp_enqueue_script( 'seo-automated-link-building', plugins_url( '/js/seo-automated-link-building.js', $this->name ), array('jquery') ); wp_localize_script( 'seo-automated-link-building', 'seoAutomatedLinkBuilding', ['ajaxUrl' => admin_url( 'admin-ajax.php' )]); } } public function createTable() { global $wpdb; $charset_collate = $wpdb->get_charset_collate(); $table_name_links = $wpdb->prefix . str_replace('-', '_', 'seo-automated-link-building'); $table_name_statistic = $wpdb->prefix . str_replace('-', '_', 'seo-automated-link-building') . '_statistic'; $sqlForLinks = "CREATE TABLE $table_name_links ( id mediumint(9) NOT NULL AUTO_INCREMENT, page_id mediumint(9), title varchar(255) NOT NULL, keywords text NOT NULL, url varchar(255) NOT NULL, num smallint(5) NOT NULL DEFAULT 1, target varchar(255) NOT NULL default '_self', nofollow tinyint(1) NOT NULL default 0, notitle tinyint(1) NOT NULL default 0, active tinyint(1) NOT NULL default 1, partly_match tinyint(1) NOT NULL default 0, case_sensitive tinyint(1) NOT NULL default 0, titleattr varchar(255), priority mediumint(9) NOT NULL DEFAULT 0, PRIMARY KEY (id) ) $charset_collate;"; $sqlForStatistic = "CREATE TABLE $table_name_statistic ( id mediumint(9) NOT NULL AUTO_INCREMENT, link_id mediumint(9) NOT NULL, title varchar(255) NOT NULL, source_url varchar(255) NOT NULL, destination_url varchar(255) NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta([ $sqlForLinks, $sqlForStatistic, ]); $domain = static::$domain; // transform keywords to json if(version_compare(get_option( "{$domain}_db_version" ), '1.0.6') === -1) { $links = Link::get(); foreach($links as $link) { $link->keywords = json_encode(array_map(function($item) { return trim($item); }, explode(',', $link->keywords)), JSON_UNESCAPED_UNICODE); $link->save(); } } update_option( "{$domain}_db_version", $this->dbVersion ); } /** * @param $option * @param $message * @param $type * * @return void */ public function displayAdminMessage() { $option = get_option( 'ilm_admin_message' ); if ( isset( $option['message'] ) ) { echo "
"; echo "

{$option['message']}

"; echo "
"; delete_option( 'ilm_admin_message' ); } } public function updateTable() { $domain = static::$domain; $installed_ver = get_option( "{$domain}_db_version" ); if($installed_ver !== $this->dbVersion) { $this->createTable(); } } public static function removeTable() { global $wpdb; $table_name_links = $wpdb->prefix . str_replace('-', '_', 'seo-automated-link-building'); $table_name_statistic = $wpdb->prefix . str_replace('-', '_', 'seo-automated-link-building') . '_statistic'; // delete tables in reverse order $wpdb->query("DROP TABLE IF EXISTS $table_name_statistic"); $wpdb->query("DROP TABLE IF EXISTS $table_name_links"); $domain = static::$domain; delete_option("{$domain}_db_version"); } public function addActionLinks($links) { $actionLinks = [ '' . __('Add New Link', 'seo-automated-link-building') . '', '' . __('All Links', 'seo-automated-link-building') . '', '' . __('Settings') . '', '' . __('Statistic', 'seo-automated-link-building') . '', ]; return array_merge( $actionLinks, $links ); } public function addMenuItems() { add_menu_page( 'Internal Links Manager', 'Internal Links Manager', $this->getUserCapability(), 'seo-automated-link-building-all-links', [$this, 'renderList'], 'data:image/svg+xml;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz48c3ZnIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIgdmlld0JveD0iMCAwIDQxOC44NCA2NjcuNTgiPjxkZWZzPjxzdHlsZT4uY2xzLTF7ZmlsbDpub25lO2lzb2xhdGlvbjppc29sYXRlO30uY2xzLTIsLmNscy0ze2ZpbGw6I2E0YWFhZTt9LmNscy0ze21peC1ibGVuZC1tb2RlOm11bHRpcGx5O29wYWNpdHk6LjM2O308L3N0eWxlPjwvZGVmcz48ZyBjbGFzcz0iY2xzLTEiPjxnIGlkPSJFYmVuZV8yIj48ZyBpZD0iTGF5ZXJfMSI+PHBhdGggY2xhc3M9ImNscy0yIiBkPSJtNjQuMDYsMTQyLjgxQzE2My41Myw1My45MSwyMjguODYsMCwyMjguODYsMGMwLDAsMTEyLjU2LDczLjQ4LDI5LjQ2LDE1MC4zOC04OS4xNiw4Mi41Mi0xNjMuOSwxMjUuMjgtMTAzLjUsMTcwLjQ0LDkyLjM5LDY5LjA5LTEyMC4xNi01MC4zMy0xMjAuMTYtNTAuMzMsMCwwLTI0LjctNzkuNzgsMjkuMzktMTI3LjY4WiIvPjxwYXRoIGNsYXNzPSJjbHMtMiIgZD0ibTI1OC4zMywxNTAuMzhjLTg5LjE2LDgyLjUyLTE2My45LDEyNS4yOC0xMDMuNSwxNzAuNDQsNDguODcsMzYuNTQsMTIuNDIsMjAuMzQtMzIuNzYtMy4wMy05LjM5LTExLjI5LTE3LjkzLTIyLjAyLTI1LjA3LTMwLjI4LTI5LjQxLTM0LjA1LTE1LjA1LTgxLjM0LDU3Ljc4LTEzMS40NkMyMjcuNiwxMDUuOTIsMjg4LjEzLDQwLjY3LDIyOC44NiwwYzAsMCwxMTIuNTYsNzMuNDgsMjkuNDYsMTUwLjM4WiIvPjxwYXRoIGNsYXNzPSJjbHMtMyIgZD0ibTM0LjY3LDI3MC40OXMtMjQuNy03OS43OCwyOS4zOS0xMjcuNjhjMS4wNS0uOTQsMi4wOC0xLjg1LDMuMTMtMi43OS02MC4wNCw1My4xNSw1NC4wMywxNDcuNDgsODMuMDEsMTA5Ljk1aDBjLTIyLDI2LjQ5LTI1LjQyLDQ4LjM3LDQuNjQsNzAuODUsMy43NSwyLjgsNi45NCw1LjI2LDkuNzIsNy40Ni4yMSwzLjQzLjM1LDYuODYuNDEsMTAuMjgtMzUuNDItMTQuNzgtMTMwLjI5LTY4LjA4LTEzMC4yOS02OC4wOFoiLz48cGF0aCBjbGFzcz0iY2xzLTIiIGQ9Im0yMjAuMDYsMzYzLjE3QzEwMy4wNCwyODguOTgtMTIuNywyMTMuNzQsNjQuMDYsMTQyLjgxYy00NC43NywzNy41OS00Ni4yOCw3OS41Mi01My40MiwxMjAuMTEtMTQuNjUsODMuMjMtMjcuMSwxMjUuMzksNTUuOTQsMTg3LjI2LDY5LjgyLDUyLjAyLDY5Ljc3LDQxLjk5LDExOS4yMi0yLjAxLDQ4LjQyLTQzLjA4LDY1LjU1LTY1LjE1LDM0LjI2LTg1WiIvPjxwYXRoIGNsYXNzPSJjbHMtMiIgZD0ibTE4NS44LDQ0OC4xN2MxLjc1LTEuNTYsMy40NS0zLjA4LDUuMTItNC41OEM5OC41Myw0MDcuNTMsMTguMjcsMzMwLjE5LDguMDUsMjc3LjRjLTEzLjIxLDczLjg1LTE5LjU2LDExNC42LDU4LjUyLDE3Mi43OCw2OS44Miw1Mi4wMiw2OS43Nyw0MS45OSwxMTkuMjItMi4wMVoiLz48cGF0aCBjbGFzcz0iY2xzLTIiIGQ9Im0yMjAuMDYsMzYzLjE3QzEwMy4wNCwyODguOTgtMTIuNywyMTMuNzQsNjQuMDYsMTQyLjgxYy0xMS43Myw5Ljg1LTIwLjQ4LDE5Ljk5LTI3LjE1LDMwLjMzLTI3LjYxLDYyLjkyLDczLjc4LDEyOC42MywxNzYuMTUsMTkzLjUzLDMxLjMsMTkuODQsMTQuMTcsNDEuOTEtMzQuMjYsODUtMTYuNTUsMTQuNzItMjcuNTUsMjUuNjMtMzcuNDksMzEuNywxMS45OS00LjU2LDIzLjk5LTE2Ljk2LDQ0LjQ5LTM1LjIsNDguNDItNDMuMDgsNjUuNTUtNjUuMTUsMzQuMjYtODVaIi8+PHBhdGggY2xhc3M9ImNscy0yIiBkPSJtMzU0Ljc5LDUyNC43N2MtOTkuNDgsODguOS0xNjQuODEsMTQyLjgxLTE2NC44MSwxNDIuODEsMCwwLTExMi41Ni03My40OC0yOS40Ni0xNTAuMzgsODkuMTYtODIuNTIsMTYzLjktMTI1LjI4LDEwMy41LTE3MC40NC05Mi4zOS02OS4wOSwxMjAuMTYsNTAuMzMsMTIwLjE2LDUwLjMzLDAsMCwyNC43LDc5Ljc4LTI5LjM5LDEyNy42OFoiLz48cGF0aCBjbGFzcz0iY2xzLTIiIGQ9Im0xNjAuNTIsNTE3LjIxYzg5LjE2LTgyLjUyLDE2My45LTEyNS4yOCwxMDMuNS0xNzAuNDQtNDguODctMzYuNTQtMTIuNDItMjAuMzQsMzIuNzcsMy4wMyw5LjM5LDExLjI5LDE3LjkzLDIyLjAyLDI1LjA3LDMwLjI4LDI5LjQxLDM0LjA1LDE1LjA1LDgxLjM0LTU3Ljc4LDEzMS40Ni03Mi44Miw1MC4xMy0xMzMuMzUsMTE1LjM4LTc0LjA5LDE1Ni4wNSwwLDAtMTEyLjU2LTczLjQ4LTI5LjQ2LTE1MC4zOFoiLz48cGF0aCBjbGFzcz0iY2xzLTMiIGQ9Im0zODQuMTgsMzk3LjA5czI0LjcsNzkuNzgtMjkuMzksMTI3LjY4Yy0xLjA1Ljk0LTIuMDgsMS44NS0zLjEyLDIuNzksNjAuMDQtNTMuMTUtNTQuMDMtMTQ3LjQ4LTgzLjAxLTEwOS45NWgwYzIyLTI2LjQ5LDI1LjQyLTQ4LjM3LTQuNjQtNzAuODUtMy43NS0yLjgtNi45NC01LjI2LTkuNzItNy40Ni0uMjEtMy40My0uMzUtNi44Ni0uNDEtMTAuMjgsMzUuNDIsMTQuNzgsMTMwLjI5LDY4LjA4LDEzMC4yOSw2OC4wOFoiLz48cGF0aCBjbGFzcz0iY2xzLTIiIGQ9Im0xOTguNzgsMzA0LjQxYzExNy4wMiw3NC4xOSwyMzIuNzUsMTQ5LjQzLDE1NiwyMjAuMzYsNDQuNzctMzcuNTksNDYuMjgtNzkuNTIsNTMuNDItMTIwLjExLDE0LjY1LTgzLjIzLDI3LjEtMTI1LjM5LTU1Ljk0LTE4Ny4yNi02OS44Mi01Mi4wMi02OS43Ny00MS45OS0xMTkuMjIsMi4wMS00OC40Miw0My4wOC02NS41NSw2NS4xNS0zNC4yNiw4NVoiLz48cGF0aCBjbGFzcz0iY2xzLTIiIGQ9Im0yMzMuMDQsMjE5LjQxYy0xLjc1LDEuNTYtMy40NSwzLjA4LTUuMTIsNC41OCw5Mi4zOSwzNi4wNiwxNzIuNjYsMTEzLjM5LDE4Mi44NywxNjYuMTgsMTMuMjEtNzMuODUsMTkuNTYtMTE0LjYtNTguNTItMTcyLjc4LTY5LjgyLTUyLjAyLTY5Ljc3LTQxLjk5LTExOS4yMiwyLjAxWiIvPjxwYXRoIGNsYXNzPSJjbHMtMiIgZD0ibTE5OC43OCwzMDQuNDFjMTE3LjAyLDc0LjE5LDIzMi43NSwxNDkuNDMsMTU2LDIyMC4zNiwxMS43Mi05Ljg1LDIwLjQ4LTE5Ljk5LDI3LjE1LTMwLjMzLDI3LjYxLTYyLjkyLTczLjc4LTEyOC42My0xNzYuMTUtMTkzLjUzLTMxLjMtMTkuODQtMTQuMTctNDEuOTEsMzQuMjYtODUsMTYuNTUtMTQuNzIsMjcuNTUtMjUuNjMsMzcuNDktMzEuNy0xMS45OSw0LjU2LTIzLjk5LDE2Ljk2LTQ0LjQ5LDM1LjItNDguNDIsNDMuMDgtNjUuNTUsNjUuMTUtMzQuMjYsODVaIi8+PHBhdGggY2xhc3M9ImNscy0yIiBkPSJtMzU0Ljc5LDUyNC43N2MtOTkuNDgsODguOS0xNjQuODEsMTQyLjgxLTE2NC44MSwxNDIuODEsMCwwLTExMi41Ni03My40OC0yOS40Ni0xNTAuMzgsODkuMTYtODIuNTIsMTYzLjktMTI1LjI4LDEwMy41LTE3MC40NC05Mi4zOS02OS4wOSwxMjAuMTYsNTAuMzMsMTIwLjE2LDUwLjMzLDAsMCwyNC43LDc5Ljc4LTI5LjM5LDEyNy42OFoiLz48cGF0aCBjbGFzcz0iY2xzLTIiIGQ9Im0xNjAuNTIsNTE3LjIxYzg5LjE2LTgyLjUyLDE2My45LTEyNS4yOCwxMDMuNS0xNzAuNDQtNDguODctMzYuNTQtMTIuNDItMjAuMzQsMzIuNzYsMy4wMyw5LjM5LDExLjI5LDE3LjkzLDIyLjAyLDI1LjA3LDMwLjI4LDI5LjQxLDM0LjA1LDE1LjA1LDgxLjM0LTU3Ljc4LDEzMS40Ni03Mi44Miw1MC4xMy0xMzMuMzUsMTE1LjM4LTc0LjA5LDE1Ni4wNSwwLDAtMTEyLjU2LTczLjQ4LTI5LjQ2LTE1MC4zOFoiLz48cGF0aCBjbGFzcz0iY2xzLTMiIGQ9Im0zODQuMTgsMzk3LjA5czI0LjcsNzkuNzgtMjkuMzksMTI3LjY4Yy0xLjA1Ljk0LTIuMDgsMS44NS0zLjEzLDIuNzksNjAuMDQtNTMuMTUtNTQuMDMtMTQ3LjQ4LTgzLjAxLTEwOS45NWgwYzIyLTI2LjQ5LDI1LjQyLTQ4LjM3LTQuNjQtNzAuODUtMy43NS0yLjgtNi45NC01LjI2LTkuNzItNy40Ni0uMjEtMy40My0uMzUtNi44Ni0uNDEtMTAuMjgsMzUuNDIsMTQuNzgsMTMwLjI5LDY4LjA4LDEzMC4yOSw2OC4wOFoiLz48cGF0aCBjbGFzcz0iY2xzLTIiIGQ9Im0xOTguNzgsMzA0LjQxYzExNy4wMiw3NC4xOSwyMzIuNzUsMTQ5LjQzLDE1NiwyMjAuMzYsNDQuNzctMzcuNTksNDYuMjgtNzkuNTIsNTMuNDItMTIwLjExLDE0LjY1LTgzLjIzLDI3LjEtMTI1LjM5LTU1Ljk0LTE4Ny4yNi02OS44Mi01Mi4wMi02OS43Ny00MS45OS0xMTkuMjIsMi4wMS00OC40Miw0My4wOC02NS41NSw2NS4xNS0zNC4yNiw4NVoiLz48cGF0aCBjbGFzcz0iY2xzLTIiIGQ9Im0yMzMuMDQsMjE5LjQxYy0xLjc1LDEuNTYtMy40NSwzLjA4LTUuMTIsNC41OCw5Mi4zOSwzNi4wNiwxNzIuNjUsMTEzLjM5LDE4Mi44NywxNjYuMTgsMTMuMjEtNzMuODUsMTkuNTYtMTE0LjYtNTguNTItMTcyLjc4LTY5LjgyLTUyLjAyLTY5Ljc3LTQxLjk5LTExOS4yMiwyLjAxWiIvPjxwYXRoIGNsYXNzPSJjbHMtMiIgZD0ibTE5OC43OCwzMDQuNDFjMTE3LjAyLDc0LjE5LDIzMi43NSwxNDkuNDMsMTU2LDIyMC4zNiwxMS43My05Ljg1LDIwLjQ4LTE5Ljk5LDI3LjE1LTMwLjMzLDI3LjYxLTYyLjkyLTczLjc4LTEyOC42My0xNzYuMTUtMTkzLjUzLTMxLjMtMTkuODQtMTQuMTctNDEuOTEsMzQuMjYtODUsMTYuNTUtMTQuNzIsMjcuNTUtMjUuNjMsMzcuNDktMzEuNy0xMS45OSw0LjU2LTIzLjk5LDE2Ljk2LTQ0LjQ5LDM1LjItNDguNDIsNDMuMDgtNjUuNTUsNjUuMTUtMzQuMjYsODVaIi8+PC9nPjwvZz48L2c+PC9zdmc+' ); $hook = add_submenu_page( 'seo-automated-link-building-all-links', __('All Links', 'seo-automated-link-building'), __('All Links', 'seo-automated-link-building'), $this->getUserCapability(), 'seo-automated-link-building-all-links', [$this, 'renderList'] ); add_action( "load-$hook", [$this, 'addCMILinks'] ); add_submenu_page( 'seo-automated-link-building-all-links', __('Add New Link', 'seo-automated-link-building'), __('Add New Link', 'seo-automated-link-building'), $this->getUserCapability(), 'seo-automated-link-building-add-link', [$this, 'renderAddItem'] ); add_submenu_page( 'seo-automated-link-building-all-links', __('Statistic', 'seo-automated-link-building'), __('Statistic', 'seo-automated-link-building'), $this->getUserCapability(), 'seo-automated-link-building-statistic', [$this, 'renderStatistic'] ); add_submenu_page( 'seo-automated-link-building-all-links', __('Import + Export', 'seo-automated-link-building'), __('Import + Export', 'seo-automated-link-building'), $this->getUserCapability(), 'seo-automated-link-building-import-links', [$this, 'renderImport'] ); add_submenu_page( 'seo-automated-link-building-all-links', __('Settings'), __('Settings'), 'manage_options', // only admins 'seo-automated-link-building-settings', [$this, 'renderSettings'] ); } /** * @param string $message * @param string $type * * @return void */ public function addAdminMessage($message, $type = 'info') { update_option( 'ilm_admin_message', [ 'message' => $message, 'type' => $type, ] ); } public function setCMIOptions($status, $option, $value) { if ( $option === 'cmi_links_per_page' ) { return $value; } return $status; } public function renderList() { $editData = $this->getEditData(); $link = $editData->link; if($link) { $page = $editData->page; $title = __('Edit Link', 'seo-automated-link-building'); $this->renderEdit($link, $page, $title); return; } $user = get_current_user_id(); $screen = get_current_screen(); $option = $screen->get_option('per_page', 'option'); $linksPerPage = get_user_meta($user, $option, true); if ( empty($linksPerPage) || $linksPerPage < 1 ) { $linksPerPage = $screen->get_option('per_page', 'default'); } $list = new Links_List('seo-automated-link-building'); $list->setLimit($linksPerPage); // logic $hasActiveFlag = isset($_REQUEST['active']); $onlyActive = $hasActiveFlag && $_REQUEST['active'] === '1'; $onlyInactive = $hasActiveFlag && $_REQUEST['active'] === '0'; // translations $linksHeadline = __('All Links', 'seo-automated-link-building'); $addNewHeadline = __('Add New', 'seo-automated-link-building'); $allTitle = __('All'); $activeTitle = __('Active', 'seo-automated-link-building'); $inactiveTitle = __('Deactivated', 'seo-automated-link-building'); // data $linksCount = Link::query()->select("count(*)")->get_var(); $activeLinksCount = Link::query()->select("count(*)")->where('active', true)->get_var(); $inactiveLinksCount = Link::query()->select("count(*)")->where('active', false)->get_var(); include __DIR__ . '/templates/list.php'; } public function addCMILinks() { $option = 'per_page'; $args = array( 'label' => __('Links per page', 'seo-automated-link-building'), 'default' => 50, 'option' => 'cmi_links_per_page', ); add_screen_option( $option, $args ); } public function renderAddItem() { $link = new Link(); $link->nofollow = false; $link->notitle = false; $link->partly_match = false; $link->num = 1; $link->priority = 0; $link->target = '_self'; $link->keywords = '[]'; $title = __('Add New Link', 'seo-automated-link-building'); $page = null; $this->renderEdit($link, $page, $title); } protected function renderEdit(Link $link, $page, $title) { $adminPostUrl = admin_url( 'admin-post.php' ); // logic $shouldDisplayPageInput = !empty((int)$link->page_id) || empty((string)$link->url); // translations $internalTitleHeadline = __('Internal title', 'seo-automated-link-building'); $internalTitleDescription = __('The title for your internal structure', 'seo-automated-link-building'); $pageHeadline = __('Page', 'seo-automated-link-building'); $pageDescription = __('Which page would you like to link to?', 'seo-automated-link-building'); $urlSwitch = __('Use custom url', 'seo-automated-link-building'); $urlHeadline = __('URL', 'seo-automated-link-building'); $urlDescription = __('Which page would you like to link to?', 'seo-automated-link-building'); $pageSwitch = __('Use website page', 'seo-automated-link-building'); $keywordsHeadline = __('Keywords', 'seo-automated-link-building'); $keywordsDescription = __('What terms should be replaced? Use enter or tab to finish one term.', 'seo-automated-link-building'); $settingsHeadline = __('Settings (optional)', 'seo-automated-link-building'); $titleattrHeadline = __('Link title', 'seo-automated-link-building'); $titleattrDescription = __('Which title should be set for the title HTML Attribute? If no title is set, internal title is set.', 'seo-automated-link-building'); $notitleDescription = __("Don't use a link-title (not recommended)", 'seo-automated-link-building'); $priorityHeadline = __('Priority', 'seo-automated-link-building'); $priorityDescription = __('With which priority should the entry handled? The higher the value, the ealier the keywords of the entry will be replaced. If the priority of two entries is equal, the longer one wins.', 'seo-automated-link-building'); $numberOfLinksHeadline = __('Number of links', 'seo-automated-link-building'); $unlimitiedHint = __('Unlimited', 'seo-automated-link-building'); $numberOfLinksDescription = __('How often should the link appear on a page? Choose -1 for unlimited links.', 'seo-automated-link-building'); $followHeadline = __('Let searchengines follow this link', 'seo-automated-link-building'); $followDescription = __('Should searchengines follow this link? If no, rel="nofollow" will be set.', 'seo-automated-link-building'); $targetHeadline = __('Link target', 'seo-automated-link-building'); $targetSameTabDescription = __('Open in same tab', 'seo-automated-link-building'); $targetNewTabDescription = __('Open in new tab', 'seo-automated-link-building'); $partialReplacementHeadline = __('Partial replacement', 'seo-automated-link-building'); $partialReplacementDescription = __('Allow partial replacement of words. (e.g. success in successful)', 'seo-automated-link-building'); $caseSensitiveHeadline = __('Case sensitive', 'seo-automated-link-building'); $caseSensitiveDescription = __('Should the keywords be case sensitive?', 'seo-automated-link-building'); $saveTitle = __('Save'); // data $pageTitle = $link->title; $id = esc_attr($link->id); $title = esc_attr($link->title); $url = esc_attr($link->url); $pageId = esc_attr($link->page_id ? $link->page_id : ''); $titleattr = esc_attr($link->titleattr ? $link->titleattr : ''); $num = esc_attr($link->num); $priority = esc_attr($link->priority); $notitle = $link->notitle; $follow = !$link->nofollow; $partlyMatch = $link->partly_match; $target = $link->target; $caseSensitive = $link->case_sensitive; include __DIR__ . '/templates/edit.php'; } public function renderSettings() { $adminPostUrl = admin_url( 'admin-post.php' ); extract(Settings::getFormValues()); include __DIR__ . '/templates/settings.php';; } public function renderImport() { $adminPostUrl = admin_url( 'admin-post.php' ); // translations $importHeadline = __('Import', 'seo-automated-link-building'); $exportHeadline = __('Export', 'seo-automated-link-building'); $addMissingDescription = __('Only add missing items (compared by ID)', 'seo-automated-link-building'); $addMissingAndUpdateDescription = __('Add missing items (compared by ID) and update, if already available', 'seo-automated-link-building'); $addAlwaysDescription = __('Add all items (new ID will be generated)', 'seo-automated-link-building'); $separatorLabel = __('Separator', 'seo-automated-link-building'); $exportDescription = __('Export all links', 'seo-automated-link-building'); include __DIR__ . '/templates/import.php'; } public function renderStatistic() { $list = $this->getStatisticData()->list; $counts = $this->getStatisticData()->counts; // logic $hasEntries = count($counts) > 0; include __DIR__ . '/templates/statistic.php'; } public function addLink() { if ( ! isset( $_POST['nonce'] ) || ! wp_verify_nonce( $_POST['nonce'], 'seo_automated_link_building_add_link' ) ) { wp_nonce_ays('not allowed'); } $data = $this->getPostData(array('title', 'titleattr', 'keywords')); $id = isset($data['id']) && ctype_digit($data['id']) ? (int)$data['id'] : null; if($id) { $link = Link::get($id); } else { $link = new Link(); } $link->title = sanitize_text_field($data['title']); $link->keywords = json_encode(array_map(function($item) { return sanitize_text_field($item); }, $data['keywords']), JSON_UNESCAPED_UNICODE); $link->url = esc_url_raw($data['url']); $link->page_id = isset($data['page']) && !empty($data['page']) ? (int)$data['page'] : null; $link->titleattr = isset($data['titleattr']) && !empty($data['titleattr']) ? sanitize_text_field($data['titleattr']) : null; $link->num = ctype_digit($data['num']) ? (int)$data['num'] : -1; $link->priority = isset($data['priority']) ? (int)$data['priority'] : 0; $link->nofollow = array_key_exists('follow', $data) && $data['follow'] === 'on' ? 0 : 1; $link->case_sensitive = array_key_exists('case_sensitive', $data) && $data['case_sensitive'] === 'on' ? 1 : 0; $link->notitle = array_key_exists('notitle', $data) && $data['notitle'] === 'on' ? 1 : 0; $link->partly_match = array_key_exists('partly_match', $data) && $data['partly_match'] === 'on' ? 1 : 0; $link->target = $data['target'] === '_self' ? '_self' : '_blank'; $link->save(); do_action('seo_automated_link_added', $link); wp_redirect( admin_url( "admin.php?page=seo-automated-link-building-all-links" ) ); exit; } public function importLinks() { if ( ! isset( $_POST['nonce'] ) || ! wp_verify_nonce( $_POST['nonce'], 'seo_automated_link_building_import_links' ) ) { wp_nonce_ays('not allowed'); } $filePath = $_FILES['file']['tmp_name']; if(!current_user_can('upload_files')) { return; } $pieces = explode('.', basename($_FILES['file']['name'])); $ext = array_pop($pieces); $isCsv = $ext === 'csv'; $isJson = $ext === 'json'; if (!$isCsv && !$isJson) { return; } $data = $this->getPostData(); $fileContent = file_get_contents($filePath); $mode = sanitize_text_field($data['mode']); if($isCsv) { ImportExport::importCsv($fileContent, $mode); } elseif($isJson) { ImportExport::importJson($fileContent, $mode); } if(ImportExport::hasErrors()) { wp_die( ImportExport::getErrors(), 400); } } public function exportLinks() { if(!current_user_can('upload_files')) { return; } $data = $this->getPostData(); $ext = sanitize_text_field($data['ext']); if($ext === 'csv') { header('Content-Disposition: attachment; filename=internal-link-manager.csv'); header('Content-Type: text/csv; charset=utf-8'); print ImportExport::exportAllLinksAsCsv($data['separator']); } elseif($ext === 'json') { header('Content-Disposition: attachment; filename=internal-link-manager.json'); header('Content-Type: text/csv; charset=utf-8'); print ImportExport::exportAllLinksAsJson(); } die(); } public function updateSettings() { if ( ! isset( $_POST['nonce'] ) || ! wp_verify_nonce( $_POST['nonce'], 'seo_automated_link_building_settings' ) ) { wp_nonce_ays( 'not allowed' ); } $data = $this->getPostData( array( 'whitelist', 'blacklist', 'posttypes', 'exclude', 'disableStatistics', 'disableAdminTracking' ) ); $disableStatistics = $data['disableStatistics'] ?? false; $disableAdminTracking = $data['disableAdminTracking'] ?? false; $vars = []; if ( isset( $data['whitelist'] ) ) { $vars = array( 'whitelist' => implode( "\n", array_map( function ( $text ) { return esc_url_raw( $text ); }, explode( "\n", $data['whitelist'] ) ) ), 'blacklist' => implode( "\n", array_map( function ( $text ) { return esc_url_raw( $text ); }, explode( "\n", $data['blacklist'] ) ) ), 'exclude' => sanitize_textarea_field( $data['exclude'] ), 'disableStatistics' => (bool) $disableStatistics, 'disableAdminTracking' => (bool) $disableAdminTracking, ); } if ( isset( $data['posttypes'] ) ) { $vars['posttypes'] = sanitize_textarea_field( $data['posttypes'] ); } $vars = apply_filters( 'seo_automated_link_settings_before_update', $vars ); Settings::save( $vars ); if ( strpos( $data['_wp_http_referer'], 'tab=content' ) !== false ) { wp_redirect( admin_url( "admin.php?page=seo-automated-link-building-settings&tab=content" ) ); } else { wp_redirect( admin_url( "admin.php?page=seo-automated-link-building-settings" ) ); } exit; } public function trackLink() { ignore_user_abort(true); $data = $this->getPostData(array('title', 'source_url', 'destination_url')); // get id and validate it $id = $data['link_id']; $id = is_int($id) || ctype_digit($id) ? (int)$id : null; if(!$id) { // if not valid, return wp_die(); return; } Statistic::create([ 'link_id' => $id, 'title' => sanitize_text_field($data['title']), 'source_url' => esc_url_raw($data['source_url']), 'destination_url' => esc_url_raw($data['destination_url']), ]); wp_die(); } private function normalizeUrl($url) { return strtolower(trailingslashit($url)); } private function areUrlsIdentical($required, $actual) { $regex = str_replace('**', '@@', $required); $regex = str_replace('*', '@', $regex); $regex = preg_quote($regex); $regex = str_replace('@@', '.*', $regex); $regex = str_replace('@', '[^/]*', $regex); $pattern = '#^' . $this->normalizeUrl($regex) . '$#'; return preg_match($pattern, $this->normalizeUrl($actual)) === 1; } public function findPages() { $data = $this->getPostData(array('search')); $posts = Post::query() ->select('ID as id, post_title as title, post_type as type') ->where('post_type', 'in', [array_values(get_post_types(['public' => true]))]) ->where('post_title', 'like', '%' . Post::wpdb()->esc_like($data['search']) . '%') ->where('post_status', 'publish') ->order_by('post_modified', 'desc') ->limit(25) ->get_results(); wp_die(json_encode($posts, JSON_UNESCAPED_UNICODE)); } private function getUrlPath($url) { if($url) { $parsedUrl = parse_url($url); if($parsedUrl && array_key_exists('path', $parsedUrl)) { $path = $parsedUrl['path']; $query = array_key_exists('query', $parsedUrl) ? '?' . $parsedUrl['query'] : ''; return $path . $query; } } return null; } public function changeContent($content, $type = 'post') { $requestedUrl = $_SERVER['REQUEST_URI']; $hostname = $_SERVER['SERVER_NAME']; $settings = Settings::get(); global $wp; $globalUrl = $this->getUrlPath(home_url( add_query_arg( [], $wp->request))); $postUrl = $this->getUrlPath(get_permalink(get_queried_object_id())); $possibleUrls = array_filter([$globalUrl, $postUrl, $requestedUrl], function($item) { return !empty($item); }); // check whitelist if(!empty($settings['whitelist'])) { $matched = false; foreach($settings['whitelist'] as $whitelistUrl) { $path = $this->getUrlPath($whitelistUrl); if(!$path) { continue; } foreach($possibleUrls as $url) { if($this->areUrlsIdentical($path, $url)) { $matched = true; break; } } } if(!$matched) { // not in whitelist => return content without modification return $content; } } // check blacklist foreach ($settings['blacklist'] as $blacklistUrl) { $path = $this->getUrlPath($blacklistUrl); if(!$path) { continue; } foreach($possibleUrls as $url) { if($this->areUrlsIdentical($path, $url)) { return $content; } } } // check posttypes if($type === 'post' && !empty($settings['posttypes']) && !in_array(get_post_type(), $settings['posttypes'])) { return $content; } $links = Link::query()->where('active', true)->order_by('priority', 'desc')->get(); global $post; $links = array_filter($links, function(Link $link) use($possibleUrls, $hostname, $post) { if($link->page_id) { // link uses post id return !$post || $post->ID != $link->page_id; } $parsedUrl = parse_url($link->url); if(!$parsedUrl || !array_key_exists('path', $parsedUrl)) { return true; } $path = $parsedUrl['path']; $host = array_key_exists('host', $parsedUrl) ? $parsedUrl['host'] : $hostname; if(strtolower($host) !== strtolower($hostname)) { return true; } foreach($possibleUrls as $url) { if($this->areUrlsIdentical($path, $url)) { return false; } } return true; }); return (new TextConverter($content)) ->addLinks($links) ->getText(); } }