← All changes | wp-data-access.php +140 -26 5.5.75 → 5.5.87 View file →

		@@ -3,9 +3,9 @@
3	3	/**
4	4	* Plugin Name: WP Data Access
5	5	* Plugin URI: https://wpdataaccess.com/
6	6	* Description: A powerful data-driven App Builder with an intuitive Table Builder, a highly customizable Form Builder and interactive Chart support in 35 languages
7		- * Version: 5.5.75
	7	+ * Version: 5.5.87
8	8	* Author: Passionate Programmers B.V.
9	9	* Author URI: https://wpdataaccess.com/
10	10	* Text Domain: wp-data-access
11	11	* License: GPL-2.0+
		@@ -55,8 +55,9 @@
55	55	'slug' => 'wpda_navi',
56	56	'contact' => false,
57	57	'network' => true,
58	58	),
	59	+ 'has_affiliation' => 'all',
59	60	'is_live' => true,
60	61	'is_org_compliant' => true,
61	62	) );
62	63	}
		@@ -67,21 +68,67 @@
67	68	wpda_freemius();
68	69	// Signal that SDK was initiated.
69	70	do_action( 'wpda_freemius_loaded' );
70	71	/**
71		- * Change plugin settings info
72		- *
	72	+ * Check if legacy tools are currently used on this server.
	73	+ * @return bool
	74	+ */
	75	+ function wpda_has_legacy_tools_inuse() {
	76	+ $option_legacy_tools = WPDA::get_option( WPDA::OPTION_PLUGIN_LEGACY_TOOLS );
	77	+ $has_legacy_tools = false;
	78	+ if ( !empty( $option_legacy_tools ) && is_array( $option_legacy_tools ) ) {
	79	+ foreach ( $option_legacy_tools as $tool ) {
	80	+ if ( isset( $tool[0] ) && $tool[0] === true && isset( $tool[1] ) && $tool[1] > 0 ) {
	81	+ $has_legacy_tools = true;
	82	+ break;
	83	+ }
	84	+ }
	85	+ }
	86	+ return $has_legacy_tools;
	87	+ }
	88	+
	89	+ /**
	90	+ * Hook into the plugin_row_meta filter.
73	91	* @param mixed $links Links.
74	92	* @param mixed $file File.
	93	+ * @param mixed $data Data.
75	94	* @return mixed
76	95	*/
77		- function wpda_row_meta( $links, $file ) {
78		- if ( strpos( $file, plugin_basename( __FILE__ ) ) !== false ) {
	96	+ function wpda_row_meta( $links, $file, $data ) {
	97	+ if ( plugin_basename( __FILE__ ) == $file ) {
79	98	// Add settings link.
80	99	$settings_url = admin_url( 'options-general.php' ) . '?page=wpdataaccess';
81		- $settings_link = "<a href='{$settings_url}'>Settings</a>";
	100	+ $settings_link = '<a href="' . esc_url( $settings_url ) . '">Settings</a>';
82	101	array_push( $links, $settings_link );
83		- //phpcs:ignore - 8.1 proof
	102	+ // phpcs:ignore -- 8.1 proof
	103	+ // Add comment for legacy users only
	104	+ if ( wpda_has_legacy_tools_inuse() ) {
	105	+ if ( isset( $data['new_version'] ) ) {
	106	+ $new_version = $data['new_version'];
	107	+ if ( version_compare( $new_version, '6.0', '>=' ) ) {
	108	+ $notice = '
	109	+ <p style="margin-top: 10px; margin-bottom: 0; padding: 6px 10px; border-radius: 2px;"
	110	+ class="update-message notice inline notice-warning notice-alt"
	111	+ >
	112	+ <span class="dashicons dashicons-warning" style="color: #f0b849;"></span>
	113	+ <strong>Warning for legacy users:</strong> Version ' . esc_html( $new_version ) . ' (available now) removes legacy tools.
	114	+ <strong style="color: #cc1818;">Stay on Version 5.x</strong> to keep using them.
	115	+ <a href="https://docs.legacy.wpdataaccess.com/docs/deprecating/" target="_blank">Read more →</a>
	116	+ </p>';
	117	+ } else {
	118	+ $notice = '
	119	+ <p style="margin-top: 10px; margin-bottom: 0; padding: 6px 10px; border-radius: 2px;"
	120	+ class="update-message notice inline notice-info notice-alt"
	121	+ >
	122	+ <span class="dashicons dashicons-info" style="color: #3858e9;"></span>
	123	+ <strong>Info for legacy users:</strong> Version 6 is coming soon and removes legacy tools.
	124	+ <strong>Stay on Version 5.x</strong> to keep using them.
	125	+ <a href="https://docs.legacy.wpdataaccess.com/docs/deprecating/" target="_blank">Read more →</a>
	126	+ </p>';
	127	+ }
	128	+ $links[] = $notice;
	129	+ }
	130	+ }
84	131	}
85	132	return $links;
86	133	}
87	134
		@@ -88,22 +135,75 @@
88	135	add_filter(
89	136	'plugin_row_meta',
90	137	'wpda_row_meta',
91	138	10,
92		- 2
	139	+ 3
93	140	);
94	141	/**
	142	+ * Remove last | character from plugin links.
	143	+ * @return void
	144	+ */
	145	+ function wpda_clean_plugin_row_script() {
	146	+ if ( !wpda_has_legacy_tools_inuse() ) {
	147	+ return;
	148	+ }
	149	+ ?>
	150	+ <script type="text/javascript">
	151	+ jQuery(document).ready(function($) {
	152	+ var $row = $('tr[data-slug="wp-data-access"] .plugin-version-author-uri');
	153	+ if ($row.length) {
	154	+ $row.contents().each(function(index) {
	155	+ if (this.nodeType === 3 && index === 6) {
	156	+ this.nodeValue = this.nodeValue.replace(/\|/g, '');
	157	+ }
	158	+ });
	159	+ }
	160	+ });
	161	+ </script>
	162	+ <?php
	163	+ }
	164	+
	165	+ add_action( 'admin_footer-plugins.php', 'wpda_clean_plugin_row_script' );
	166	+ /**
	167	+ * Show legacy tools info widget.
	168	+ * @return void
	169	+ */
	170	+ function wpda_legacy_tools_notice_widget() {
	171	+ // Add widget for legacy users only
	172	+ if ( wpda_has_legacy_tools_inuse() ) {
	173	+ wp_add_dashboard_widget( 'wporg_dashboard_widget', 'WP Data Access - Info for legacy tools users', function () {
	174	+ ?>
	175	+ <p>
	176	+ Version 6 is coming soon and removes legacy tools.
	177	+ </p>
	178	+ <p>
	179	+ <strong>To keep using the legacy tools:</strong><br>
	180	+ ✓ Stay on the latest Version 5.x<br>
	181	+ ✓ Disable auto-updates<br>
	182	+ ✓ Do not update manually to Version 6
	183	+ </p>
	184	+ <p>
	185	+ <a href="https://docs.legacy.wpdataaccess.com/docs/deprecating/" target="_blank">Read more →</a>
	186	+ </p>
	187	+ <?php
	188	+ } );
	189	+ }
	190	+ }
	191	+
	192	+ add_action( 'wp_dashboard_setup', 'wpda_legacy_tools_notice_widget' );
	193	+ /**
95	194	* Activate plugin
96	195	*
97	196	* @author Peter Schulz
98	197	* @since 1.0.0
99	198	*/
100		- function activate_wp_data_access() {
	199	+ function wpda_activate() {
	200	+ // phpcs:ignore WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedFunctionFound
101	201	require_once plugin_dir_path( __FILE__ ) . 'includes/class-wp-data-access-switch.php';
102	202	WP_Data_Access_Switch::activate();
103	203	}
104	204
105		- register_activation_hook( __FILE__, 'activate_wp_data_access' );
	205	+ register_activation_hook( __FILE__, 'wpda_activate' );
106	206	/**
107	207	* Deactivate plugin
108	208	*
109	209	* @author Peter Schulz
		@@ -108,14 +208,15 @@
108	208	*
109	209	* @author Peter Schulz
110	210	* @since 1.0.0
111	211	*/
112		- function deactivate_wp_data_access() {
	212	+ function wpda_deactivate() {
	213	+ // phpcs:ignore WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedFunctionFound
113	214	require_once plugin_dir_path( __FILE__ ) . 'includes/class-wp-data-access-switch.php';
114	215	WP_Data_Access_Switch::deactivate();
115	216	}
116	217
117		- register_deactivation_hook( __FILE__, 'deactivate_wp_data_access' );
	218	+ register_deactivation_hook( __FILE__, 'wpda_deactivate' );
118	219	/**
119	220	* Check if database needs to be updated
120	221	*
121	222	* @author Peter Schulz
		@@ -122,9 +223,9 @@
122	223	* @since 1.5.2
123	224	*/
124	225	function wpda_update_db_check() {
125	226	if ( get_option( WPDataAccess\WPDA::OPTION_WPDA_VERSION[0] ) !== WPDataAccess\WPDA::OPTION_WPDA_VERSION[1] ) {
126		- activate_wp_data_access();
	227	+ wpda_activate();
127	228	}
128	229	}
129	230
130	231	add_action( 'plugins_loaded', 'wpda_update_db_check' );
		@@ -144,8 +245,9 @@
144	245	*/
145	246	function wpda_uninstall_blog() {
146	247	global $wpdb;
147	248	$drop_tables = get_option( 'wpda_uninstall_tables' );
	249	+ // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders, WordPress.DB.DirectDatabaseQuery.SchemaChange
148	250	if ( 'on' === $drop_tables ) {
149	251	// Get all plugin table names (without WP prefix).
150	252	$plugin_tables = WPDataAccess\WPDA::get_wpda_tables();
151	253	foreach ( $plugin_tables as $plugin_table ) {
		@@ -150,13 +252,9 @@
150	252	$plugin_tables = WPDataAccess\WPDA::get_wpda_tables();
151	253	foreach ( $plugin_tables as $plugin_table ) {
152	254	// Loop through plugin tables.
153	255	// Drop plugin table.
154		- $wpdb->query( $wpdb->prepare(
155		- 'DROP TABLE IF EXISTS `%1s`',
156		- // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders, WordPress.DB.DirectDatabaseQuery.SchemaChange
157		- WPDataAccess\WPDA::remove_backticks( $plugin_table )
158		- ) );
	256	+ $wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS `%1s`', WPDataAccess\WPDA::remove_backticks( $plugin_table ) ) );
159	257	// db call ok; no-cache ok.
160	258	// Get plugin backup tables (if applicable).
161	259	$backup_tables = $wpdb->get_results( $wpdb->prepare( '
162	260	select table_name as table_name from information_schema.tables
		@@ -165,13 +263,9 @@
165	263	', array($wpdb->dbname, "{$plugin_table}_BACKUP_%") ), 'ARRAY_A' );
166	264	// db call ok; no-cache ok.
167	265	foreach ( $backup_tables as $backup_table ) {
168	266	// Drop plugin backup table.
169		- $wpdb->query( $wpdb->prepare(
170		- 'DROP TABLE IF EXISTS `%1s`',
171		- // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders, WordPress.DB.DirectDatabaseQuery.SchemaChange
172		- WPDataAccess\WPDA::remove_backticks( $backup_table['table_name'] )
173		- ) );
	267	+ $wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS `%1s`', WPDataAccess\WPDA::remove_backticks( $backup_table['table_name'] ) ) );
174	268	// db call ok; no-cache ok.
175	269	}
176	270	}
177	271	}
		@@ -182,10 +276,24 @@
182	276	// db call ok; no-cache ok.
183	277	$wpdb->query( "\n\t\t\t\t\tDELETE FROM {$wpdb->usermeta}\n\t\t\t\t\tWHERE meta_key LIKE 'wpda%'\n\t\t\t\t\t OR meta_key LIKE '%wp-data-access%'\n\t\t\t\t" );
184	278	// db call ok; no-cache ok.
185	279	}
	280	+ // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders, WordPress.DB.DirectDatabaseQuery.SchemaChange
186	281	}
187	282
	283	+ function wpda_unschedule_event( $hook ) {
	284	+ $crons = _get_cron_array();
	285	+ foreach ( $crons as $timestamp => $cron ) {
	286	+ if ( isset( $cron[$hook] ) ) {
	287	+ foreach ( $cron[$hook] as $event ) {
	288	+ if ( isset( $event['args'] ) ) {
	289	+ wp_unschedule_event( $timestamp, $hook, $event['args'] );
	290	+ }
	291	+ }
	292	+ }
	293	+ }
	294	+ }
	295	+
188	296	/**
189	297	* Uninstall WP Data Access tables, options and meta keys
190	298	*
191	299	* @return void
		@@ -193,10 +301,11 @@
193	301	function wpda_uninstall() {
194	302	if ( is_multisite() ) {
195	303	global $wpdb;
196	304	// Uninstall plugin for all blogs one by one (will fail silently for blogs having no plugin tables/options).
	305	+ // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders, WordPress.DB.DirectDatabaseQuery.SchemaChange
197	306	$blogids = $wpdb->get_col( "select blog_id from {$wpdb->blogs}" );
198		- // db call ok; no-cache ok.
	307	+ // phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders, WordPress.DB.DirectDatabaseQuery.SchemaChange
199	308	foreach ( $blogids as $blog_id ) {
200	309	// Uninstall blog.
201	310	switch_to_blog( $blog_id );
202	311	wpda_uninstall_blog();
		@@ -206,8 +315,12 @@
206	315	// Uninstall on single site installation.
207	316	wpda_uninstall_blog();
208	317	}
209	318	WPDA::wpda_delete_content_folder();
	319	+ // Unscheduled all WP Data Access events
	320	+ wpda_unschedule_event( 'wpda_data_backup' );
	321	+ wpda_unschedule_event( \WPDataAccess\Query_Builder\WPDA_Query_Builder_Scheduler::SCHEDULER_HOOK_NAME );
	322	+ wpda_unschedule_event( \WPDataAccess\Utilities\WPDA_Export_Scheduler::SCHEDULER_HOOK_NAME );
210	323	}
211	324
212	325	wpda_freemius()->add_action( 'after_uninstall', 'wpda_uninstall' );
213	326	/**
		@@ -225,12 +338,13 @@
225	338	*
226	339	* @author Peter Schulz
227	340	* @since 1.0.0
228	341	*/
229		- function run_wp_data_access() {
	342	+ function wpda_run() {
	343	+ // phpcs:ignore WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedFunctionFound
230	344	require_once plugin_dir_path( __FILE__ ) . 'includes/class-wp-data-access.php';
231	345	$wpdataaccess = new WP_Data_Access();
232	346	$wpdataaccess->run();
233	347	}
234	348
235		- run_wp_data_access();
	349	+ wpda_run();
236	350	}