'; //TODO: Migration $table_name = $wpdb->prefix . 'posts'; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- Migration tool, table name from $wpdb->prefix. $products = $wpdb->get_results( "SELECT ID FROM $table_name WHERE (post_type='atkp_product') ", OBJECT ); echo 'products: ' . esc_html( count( $products ) ) . '
'; foreach ( $products as $row ) { $post_id = $row->ID; echo 'updating ' . esc_html( $post_id ) . '
'; $isv3 = ATKPTools::get_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_v3_plus' ); if ( $isv3 ) { continue; } ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_title', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_mpn', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_productgroup', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_manufacturer', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_author', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_numberofpages', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_brand', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_releasedate', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_description', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_features', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_v3_plus', true ); } ATKPTools::set_setting( 'atkp_migration_done', 1 ); echo esc_html( 'migration plus finished ' ); //header( 'Location: ' . $_SERVER['HTTP_REFERER'] ); exit; } else { // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- Static HTML with escaped dynamic values. echo '' . esc_html__( 'If you didnt modified product data (title, brand, manufacturer, make, description, features,..) you should use this upgrade function:', 'affiliate-toolkit-starter' ) . '

'; echo '' . esc_html__( 'Migrate my products (including productdata) to V3', 'affiliate-toolkit-starter' ) . ''; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>

'; //TODO: Migration $table_name = $wpdb->prefix . 'posts'; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.InterpolatedNotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter -- Migration tool, table name from $wpdb->prefix. $products = $wpdb->get_results( "SELECT ID FROM $table_name WHERE (post_type='atkp_product') ", OBJECT ); echo 'products: ' . esc_html( count( $products ) ) . '
'; foreach ( $products as $row ) { $post_id = $row->ID; echo 'updating ' . esc_html( $post_id ) . '
'; $isv3 = ATKPTools::get_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_v3' ); if ( $isv3 ) { continue; } $refreshreviewinfo = ATKPTools::get_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_refreshreviewinforegulary' ); $refreshpriceinfo = ATKPTools::get_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_refreshpriceinforegulary' ); $refreshproducturl = ATKPTools::get_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_refreshproducturlregulary' ); $refreshimages = ATKPTools::get_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_refreshimagesregulary' ); //$refreshmoreoffers = ATKPTools::get_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_refreshmoreoffersregulary' ); if ( $refreshimages == true ) { ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_smallimageurl', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_mediumimageurl', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_largeimageurl', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_images', null ); } if ( $refreshproducturl == true ) { ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_producturl', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_addtocarturl', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_customerreviewsurl', null ); } if ( $refreshreviewinfo == true ) { //ratings werden nur überschrieben wenn welche vorhanden sind ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_rating', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_reviewcount', null ); } ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_parentasin', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_variationname', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_variations', null ); if ( $refreshpriceinfo == true ) { ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_listpricefloat', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_salepricefloat', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_shippingfloat', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_listprice', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_saleprice', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_availability', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_shipping', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_isprime', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_iswarehouse', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_amountsaved', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_amountsavedfloat', null ); ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_percentagesaved', null ); } ATKPTools::set_post_setting( $post_id, ATKP_PRODUCT_POSTTYPE . '_v3', true ); } ATKPTools::set_setting( 'atkp_migration_done', 1 ); echo esc_html( 'migration finished ' ); //header( 'Location: ' . $_SERVER['HTTP_REFERER'] ); exit; } else { // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped -- Static HTML with escaped dynamic values. echo '' . esc_html__( 'If you modified product data (title, brand, manufacturer, make, description, features,..) you should use this upgrade function:', 'affiliate-toolkit-starter' ) . '

'; echo '' . esc_html__( 'Migrate my products to V3', 'affiliate-toolkit-starter' ) . ''; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>

exists_table(); $tablename2 = $tbl->exists_detailtable(); // phpcs:ignore WordPress.Security.NonceVerification.Recommended -- Admin debug page, access controlled by capability check. if ( isset( $_GET['atkp_action'] ) && sanitize_text_field( wp_unslash( $_GET['atkp_action'] ) ) == 'recreate_queuetable' ) { /* translators: %s: table name */ echo esc_html( sprintf( __( 'generating table structure for %s', 'affiliate-toolkit-starter' ), $tablename[1] ) ); //drop table if ( $tablename[0] ) { $wpdb->query( 'DROP TABLE ' . $tablename[1] ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter } if ( $tablename2[0] ) { $wpdb->query( 'DROP TABLE ' . $tablename2[1] ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter } //create table $tbl->check_table_structure( true ); header( 'Location: ' . ( isset( $_SERVER['HTTP_REFERER'] ) ? sanitize_text_field( wp_unslash( $_SERVER['HTTP_REFERER'] ) ) : '' ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended exit; } else { /* translators: %s: SQL table name */ // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped, WordPress.WP.I18n.MissingTranslatorsComment -- HTML tags are static, dynamic values are escaped with esc_html__() and esc_html(). echo( $tablename[0] ? '' . sprintf( esc_html__( 'SQL table "%s" exists', 'affiliate-toolkit-starter' ), esc_html( $tablename[1] ) ) . '' : '' . sprintf( esc_html__( 'SQL table "%s" does not exist', 'affiliate-toolkit-starter' ), esc_html( $tablename[1] ) ) . '' ) ?>
' . sprintf( esc_html__( 'SQL table "%s" exists', 'affiliate-toolkit-starter' ), esc_html( $tablename2[1] ) ) . '' : '' . sprintf( esc_html__( 'SQL table "%s" does not exist', 'affiliate-toolkit-starter' ), esc_html( $tablename2[1] ) ) . '' ) ?>
' . esc_html__( 'Drop & create queue table (data will be deleted)', 'affiliate-toolkit-starter' ) . ''; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>

exists_table(); // phpcs:ignore WordPress.Security.NonceVerification.Recommended -- Admin debug page, access controlled by capability check. if ( isset( $_GET['atkp_action'] ) && sanitize_text_field( wp_unslash( $_GET['atkp_action'] ) ) == 'recreate_producttable' ) { /* translators: %s: table name */ echo esc_html( sprintf( __( 'generating table structure for %s', 'affiliate-toolkit-starter' ), $tablename[1] ) ); //drop table if ( $tablename[0] ) { $wpdb->query( 'DROP TABLE ' . $tablename[1] ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter } //create table $tbl->check_table_structure( true ); header( 'Location: ' . ( isset( $_SERVER['HTTP_REFERER'] ) ? sanitize_text_field( wp_unslash( $_SERVER['HTTP_REFERER'] ) ) : '' ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended exit; } else { /* translators: %s: SQL table name */ // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped, WordPress.WP.I18n.MissingTranslatorsComment -- HTML tags are static, dynamic values are escaped. echo( $tablename[0] ? '' . sprintf( esc_html__( 'SQL table "%s" exists', 'affiliate-toolkit-starter' ), esc_html( $tablename[1] ) ) . '' : '' . sprintf( esc_html__( 'SQL table "%s" does not exist', 'affiliate-toolkit-starter' ), esc_html( $tablename[1] ) ) . '' ) ?>
' . esc_html__( 'Drop & create product table (data will be deleted)', 'affiliate-toolkit-starter' ) . ''; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>

exists_table(); // phpcs:ignore WordPress.Security.NonceVerification.Recommended -- Admin debug page, access controlled by capability check. if ( isset( $_GET['atkp_action'] ) && sanitize_text_field( wp_unslash( $_GET['atkp_action'] ) ) == 'recreate_listtable' ) { /* translators: %s: table name */ echo esc_html( sprintf( __( 'generating table structure for %s', 'affiliate-toolkit-starter' ), $tablename[1] ) ); //drop table if ( $tablename[0] ) { $wpdb->query( 'DROP TABLE ' . $tablename[1] ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.DirectDatabaseQuery.SchemaChange, WordPress.DB.PreparedSQL.NotPrepared, PluginCheck.Security.DirectDB.UnescapedDBParameter } //create table $tbl->check_table_structure( true ); header( 'Location: ' . ( isset( $_SERVER['HTTP_REFERER'] ) ? sanitize_text_field( wp_unslash( $_SERVER['HTTP_REFERER'] ) ) : '' ) ); // phpcs:ignore WordPress.Security.NonceVerification.Recommended exit; } else { $tbl = new atkp_listtable_helper(); $tablename = $tbl->exists_table(); /* translators: %s: SQL table name */ // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped, WordPress.WP.I18n.MissingTranslatorsComment -- HTML tags are static, dynamic values are escaped. echo( $tablename[0] ? '' . sprintf( esc_html__( 'SQL table "%s" exists', 'affiliate-toolkit-starter' ), esc_html( $tablename[1] ) ) . '' : '' . sprintf( esc_html__( 'SQL table "%s" does not exist', 'affiliate-toolkit-starter' ), esc_html( $tablename[1] ) ) . '' ) ?>
' . esc_html__( 'Drop & create list table (data will be deleted)', 'affiliate-toolkit-starter' ) . ''; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>


' . esc_html__( 'Download Logfile', 'affiliate-toolkit-starter' ) . ''; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>   ' . esc_html__( 'Clear Logfile', 'affiliate-toolkit-starter' ) . ''; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>
' . esc_html__( 'Mark all products for update', 'affiliate-toolkit-starter' ) . ''; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>

' . esc_html__( 'Mark all lists for update', 'affiliate-toolkit-starter' ) . ''; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>

' . esc_html__( 'Remove all settings and products (clean install)', 'affiliate-toolkit-starter' ) . ''; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>
WP-Info
PHP-Info
parse_phpinfo(), true ); // phpcs:ignore WordPress.PHP.DevelopmentFunctions.error_log_print_r -- Debug info page. } function parse_phpinfo() { //retrieve php info for current server if ( ! function_exists( 'ob_start' ) || ! function_exists( 'phpinfo' ) || ! function_exists( 'ob_get_contents' ) || ! function_exists( 'ob_end_clean' ) || ! function_exists( 'preg_replace' ) ) { return 'This information is not available.'; } else { ob_start(); phpinfo(); // phpcs:ignore WordPress.PHP.DevelopmentFunctions.prevent_path_disclosure_phpinfo -- Admin debug info page, access controlled by capability. $s = ob_get_contents(); ob_end_clean(); //$s = preg_replace( '%^.*(.*).*$%ms','$1',$pinfo); } $s = strip_tags( $s, '

' ); $s = preg_replace( '/]*>([^<]+)<\/th>/', '\1', $s ); $s = preg_replace( '/]*>([^<]+)<\/td>/', '\1', $s ); $t = preg_split( '/(]*>[^<]+<\/h2>)/', $s, - 1, PREG_SPLIT_DELIM_CAPTURE ); $r = array(); $count = count( $t ); $p1 = '([^<]+)<\/info>'; $p2 = '/' . $p1 . '\s*' . $p1 . '\s*' . $p1 . '/'; $p3 = '/' . $p1 . '\s*' . $p1 . '/'; for ( $i = 1; $i < $count; $i ++ ) { if ( preg_match( '/]*>([^<]+)<\/h2>/', $t[ $i ], $matchs ) ) { $name = trim( $matchs[1] ); $vals = explode( "\n", $t[ $i + 1 ] ); foreach ( $vals AS $val ) { if ( preg_match( $p2, $val, $matchs ) ) { // 3cols $r[ $name ][ trim( $matchs[1] ) ] = array( trim( $matchs[2] ), trim( $matchs[3] ) ); } elseif ( preg_match( $p3, $val, $matchs ) ) { // 2cols $r[ $name ][ trim( $matchs[1] ) ] = trim( $matchs[2] ); } } } } return $r; } public function isMinimumVersion( $version ) { return version_compare( get_bloginfo( 'version' ), $version ) >= 0; } private function getThemeData() { $themeData = wp_get_theme(); return $themeData; } private function getPlugins() { $array = get_plugins(); return $array; } private function get_wpinfo() { $context = array( 'plugin_name' => esc_html__( 'affiliate-toolkit', 'affiliate-toolkit-starter' ), 'plugin_version' => ATKPSettings::plugin_get_version(), 'OS' => PHP_OS, 'uname' => php_uname(), 'wp_version' => get_bloginfo( 'version' ), 'wp_charset' => get_bloginfo( 'charset' ), 'wp_count_users' => count_users()['total_users'], 'wp_debug' => WP_DEBUG == true ? 'true' : 'false', 'wp_debug_log' => WP_DEBUG_LOG == true ? 'true' : 'false', 'wp_debug_display' => WP_DEBUG_DISPLAY == true ? 'true' : 'false', 'plugins' => $this->getPlugins(), 'theme' => $this->getThemeData(), 'php_version' => phpversion(), 'php_memory_limit' => ini_get( 'memory_limit' ), 'php_include_path' => get_include_path(), 'php_open_basedir' => ini_get( 'open_basedir' ), 'php_ipv6' => defined( 'AF_INET6' ) ? "PHP was compiled without --disable-ipv6 option" : "PHP was compiled with --disable-ipv6 option", 'mysql_version' => ! empty( $mysql_server_info ) ? $mysql_server_info : '', 'mysql_client' => ! empty( $mysql_client_info ) ? $mysql_client_info : '', 'server_software' => isset( $_SERVER['SERVER_SOFTWARE'] ) ? sanitize_text_field( wp_unslash( $_SERVER['SERVER_SOFTWARE'] ) ) : '', ); if ( function_exists( 'mysql_get_server_info' ) ) { $mysql_server_info = @mysql_get_server_info(); // phpcs:ignore PHPCompatibility.Extensions.RemovedExtensions.mysql_DeprecatedRemoved, WordPress.PHP.NoSilencedErrors.Discouraged, WordPress.DB.RestrictedFunctions.mysql_mysql_get_server_info -- Fallback for legacy environments. } else { $mysql_server_info = ''; } if ( function_exists( 'mysql_get_client_info' ) ) { $mysql_client_info = @mysql_get_client_info(); // phpcs:ignore PHPCompatibility.Extensions.RemovedExtensions.mysql_DeprecatedRemoved, WordPress.PHP.NoSilencedErrors.Discouraged, WordPress.DB.RestrictedFunctions.mysql_mysql_get_client_info -- Fallback for legacy environments. } else { $mysql_client_info = ''; } $context['mysql_version'] = ! empty( $mysql_server_info ) ? $mysql_server_info : ''; $context['mysql_client'] = ! empty( $mysql_client_info ) ? $mysql_client_info : ''; $context['server_software'] = isset( $_SERVER['SERVER_SOFTWARE'] ) ? sanitize_text_field( wp_unslash( $_SERVER['SERVER_SOFTWARE'] ) ) : ''; if ( function_exists( 'apache_get_version' ) ) { $context['apache_version'] = apache_get_version(); } if ( function_exists( 'apache_get_modules' ) ) { $context['apache_modules'] = apache_get_modules(); } return print_r( $context, true ); // phpcs:ignore WordPress.PHP.DevelopmentFunctions.error_log_print_r -- Debug info page. } private function get_logfile() { if ( file_exists( ATKP_PLUGIN_DIR . '/log/log.txt' ) ) { return file_get_contents( ATKP_PLUGIN_DIR . '/log/log.txt' ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_get_contents_file_get_contents -- Reading local log file. } else { return 'file not found'; } } } ?>