wp-data-access / wp-data-access.php

wp-data-access.php in WP Data Access – App Builder for Tables, Forms, Dashboards, Charts & Maps 5.5.87, at wp-data-access.php

350 lines 13.6 KB

Raw Download Zip

1	<?php
2
3	/**
4	* Plugin Name: WP Data Access
5	* Plugin URI: https://wpdataaccess.com/
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.87
8	* Author: Passionate Programmers B.V.
9	* Author URI: https://wpdataaccess.com/
10	* Text Domain: wp-data-access
11	* License: GPL-2.0+
12	* License URI: http://www.gnu.org/licenses/gpl-2.0.txt
13	* Domain Path: /languages
14	*
15	*
16	* @package plugin
17	* @author Peter Schulz
18	* @since 1.0.0
19	*/
20	use WPDataAccess\WPDA;
21	if ( !defined( 'WPINC' ) ) {
22	die;
23	}
24	if ( !defined( 'ABSPATH' ) ) {
25	exit;
26	}
27	// Add freemius to WP Data Access.
28	if ( !function_exists( 'wpda_freemius' ) ) {
29	// Load WPDataAccess namespace.
30	require_once plugin_dir_path( __FILE__ ) . 'vendor/autoload.php';
31	/**
32	* Create a helper function for easy SDK access
33	*
34	* @return Freemius
35	*/
36	function wpda_freemius() {
37	global $wpda_freemius;
38	if ( !isset( $wpda_freemius ) ) {
39	// Create a helper function for easy SDK access.
40	require_once dirname( __FILE__ ) . '/vendor/freemius/start.php';
41	$wpda_freemius = fs_dynamic_init( array(
42	'id' => '6189',
43	'slug' => 'wp-data-access',
44	'type' => 'plugin',
45	'public_key' => 'pk_fc2d1714ca61c930152f6e326b575',
46	'is_premium' => false,
47	'premium_suffix' => 'Premium',
48	'has_addons' => false,
49	'has_paid_plans' => true,
50	'trial' => array(
51	'days' => 14,
52	'is_require_payment' => false,
53	),
54	'menu' => array(
55	'slug' => 'wpda_navi',
56	'contact' => false,
57	'network' => true,
58	),
59	'has_affiliation' => 'all',
60	'is_live' => true,
61	'is_org_compliant' => true,
62	) );
63	}
64	return $wpda_freemius;
65	}
66
67	// Init Freemius.
68	wpda_freemius();
69	// Signal that SDK was initiated.
70	do_action( 'wpda_freemius_loaded' );
71	/**
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.
91	* @param mixed $links Links.
92	* @param mixed $file File.
93	* @param mixed $data Data.
94	* @return mixed
95	*/
96	function wpda_row_meta( $links, $file, $data ) {
97	if ( plugin_basename( __FILE__ ) == $file ) {
98	// Add settings link.
99	$settings_url = admin_url( 'options-general.php' ) . '?page=wpdataaccess';
100	$settings_link = '<a href="' . esc_url( $settings_url ) . '">Settings</a>';
101	array_push( $links, $settings_link );
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	}
131	}
132	return $links;
133	}
134
135	add_filter(
136	'plugin_row_meta',
137	'wpda_row_meta',
138	10,
139	3
140	);
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	/**
194	* Activate plugin
195	*
196	* @author Peter Schulz
197	* @since 1.0.0
198	*/
199	function wpda_activate() {
200	// phpcs:ignore WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedFunctionFound
201	require_once plugin_dir_path( __FILE__ ) . 'includes/class-wp-data-access-switch.php';
202	WP_Data_Access_Switch::activate();
203	}
204
205	register_activation_hook( __FILE__, 'wpda_activate' );
206	/**
207	* Deactivate plugin
208	*
209	* @author Peter Schulz
210	* @since 1.0.0
211	*/
212	function wpda_deactivate() {
213	// phpcs:ignore WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedFunctionFound
214	require_once plugin_dir_path( __FILE__ ) . 'includes/class-wp-data-access-switch.php';
215	WP_Data_Access_Switch::deactivate();
216	}
217
218	register_deactivation_hook( __FILE__, 'wpda_deactivate' );
219	/**
220	* Check if database needs to be updated
221	*
222	* @author Peter Schulz
223	* @since 1.5.2
224	*/
225	function wpda_update_db_check() {
226	if ( get_option( WPDataAccess\WPDA::OPTION_WPDA_VERSION[0] ) !== WPDataAccess\WPDA::OPTION_WPDA_VERSION[1] ) {
227	wpda_activate();
228	}
229	}
230
231	add_action( 'plugins_loaded', 'wpda_update_db_check' );
232	/**
233	* Uninstall blog
234	*
235	* This functions is called when the plugin is uninstalled. The following actions are performed:
236	* + Drop plugin tables (unless settings indicate not to)
237	* + Delete plugin options from $wpdb->options (unless settings indicate not to)
238	* + Unscheduled all WP Data Access events
239	*
240	* Actions are processed on the current blog and are repeated for every blog on a multisite installation. Must be
241	* called from the dashboard (WP_UNINSTALL_PLUGIN defined). User must have the proper privileges (activate_plugins).
242	*
243	* @author Peter Schulz
244	* @since 1.0.0
245	*/
246	function wpda_uninstall_blog() {
247	global $wpdb;
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
250	if ( 'on' === $drop_tables ) {
251	// Get all plugin table names (without WP prefix).
252	$plugin_tables = WPDataAccess\WPDA::get_wpda_tables();
253	foreach ( $plugin_tables as $plugin_table ) {
254	// Loop through plugin tables.
255	// Drop plugin table.
256	$wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS `%1s`', WPDataAccess\WPDA::remove_backticks( $plugin_table ) ) );
257	// db call ok; no-cache ok.
258	// Get plugin backup tables (if applicable).
259	$backup_tables = $wpdb->get_results( $wpdb->prepare( '
260	select table_name as table_name from information_schema.tables
261	where table_schema = %s
262	and table_name like %s
263	', array($wpdb->dbname, "{$plugin_table}_BACKUP_%") ), 'ARRAY_A' );
264	// db call ok; no-cache ok.
265	foreach ( $backup_tables as $backup_table ) {
266	// Drop plugin backup table.
267	$wpdb->query( $wpdb->prepare( 'DROP TABLE IF EXISTS `%1s`', WPDataAccess\WPDA::remove_backticks( $backup_table['table_name'] ) ) );
268	// db call ok; no-cache ok.
269	}
270	}
271	}
272	$delete_options = get_option( 'wpda_uninstall_options' );
273	if ( 'on' === $delete_options ) {
274	// Delete all options from wp_options.
275	$wpdb->query( "\n\t\t\t\t\tDELETE FROM {$wpdb->options}\n\t\t\t\t\tWHERE option_name LIKE 'wpda%'\n\t\t\t\t" );
276	// db call ok; no-cache ok.
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" );
278	// db call ok; no-cache ok.
279	}
280	// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders, WordPress.DB.DirectDatabaseQuery.SchemaChange
281	}
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
296	/**
297	* Uninstall WP Data Access tables, options and meta keys
298	*
299	* @return void
300	*/
301	function wpda_uninstall() {
302	if ( is_multisite() ) {
303	global $wpdb;
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
306	$blogids = $wpdb->get_col( "select blog_id from {$wpdb->blogs}" );
307	// phpcs:enable WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQLPlaceholders, WordPress.DB.DirectDatabaseQuery.SchemaChange
308	foreach ( $blogids as $blog_id ) {
309	// Uninstall blog.
310	switch_to_blog( $blog_id );
311	wpda_uninstall_blog();
312	restore_current_blog();
313	}
314	} else {
315	// Uninstall on single site installation.
316	wpda_uninstall_blog();
317	}
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 );
323	}
324
325	wpda_freemius()->add_action( 'after_uninstall', 'wpda_uninstall' );
326	/**
327	* Add WP Data Access icon to freemius
328	*
329	* @return string
330	*/
331	function wpda_freemius_icon() {
332	return dirname( __FILE__ ) . '/vendor/freemius/assets/img/wpda.png';
333	}
334
335	wpda_freemius()->add_filter( 'plugin_icon', 'wpda_freemius_icon' );
336	/**
337	* Start plugin
338	*
339	* @author Peter Schulz
340	* @since 1.0.0
341	*/
342	function wpda_run() {
343	// phpcs:ignore WordPress.NamingConventions.PrefixAllGlobals.NonPrefixedFunctionFound
344	require_once plugin_dir_path( __FILE__ ) . 'includes/class-wp-data-access.php';
345	$wpdataaccess = new WP_Data_Access();
346	$wpdataaccess->run();
347	}
348
349	wpda_run();
350	}