wp-data-access / WPDataAccess / Settings / WPDA_Settings_SystemInfo.php

WPDA_Settings_SystemInfo.php in WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards 5.5.84, at WPDataAccess/Settings/WPDA_Settings_SystemInfo.php

558 lines 25.0 KB

Raw Download Zip

1	<?php
2
3	namespace WPDataAccess\Settings {
4
5	use WPDataAccess\Plugin_Table_Models\WPDA_Design_Table_Model;
6	use WPDataAccess\Plugin_Table_Models\WPDA_Logging_Model;
7	use WPDataAccess\Plugin_Table_Models\WPDA_Media_Model;
8	use WPDataAccess\Plugin_Table_Models\WPDA_Publisher_Model;
9	use WPDataAccess\Plugin_Table_Models\WPDA_Table_Settings_Model;
10	use WPDataAccess\Plugin_Table_Models\WPDA_User_Menus_Model;
11	use WPDataAccess\Plugin_Table_Models\WPDP_Page_Model;
12	use WPDataAccess\Plugin_Table_Models\WPDP_Project_Design_Table_Model;
13	use WPDataAccess\Plugin_Table_Models\WPDP_Project_Model;
14	use WPDataAccess\WPDA;
15
16	class WPDA_Settings_SystemInfo extends WPDA_Settings {
17
18	/**
19	* Add system info tab content
20	*
21	* See class documentation for flow explanation.
22	*
23	* @since 2.0.13
24	*/
25	protected function add_content() {
26	global $wpdb;
27	global $wp_version;
28
29	$uploads = wp_get_upload_dir();
30
31	$menus_table_name = WPDA_User_Menus_Model::get_base_table_name();
32	$menus_table_name_exists = WPDA_User_Menus_Model::table_exists();
33
34	$design_table_name = WPDA_Design_Table_Model::get_base_table_name();
35	$design_table_name_exists = WPDA_Design_Table_Model::table_exists();
36
37	$logging_table_name = WPDA_Logging_Model::get_base_table_name();
38	$logging_table_exists = WPDA_Logging_Model::table_exists();
39
40	$data_projects_project_name = WPDP_Project_Model::get_base_table_name();
41	$data_projects_project_name_exists = WPDP_Project_Model::table_exists();
42
43	$data_projects_page_name = WPDP_Page_Model::get_base_table_name();
44	$data_projects_page_name_exists = WPDP_Page_Model::table_exists();
45
46	$data_projects_table_name = WPDP_Project_Design_Table_Model::get_base_table_name();
47	$data_projects_table_name_exists = WPDP_Project_Design_Table_Model::table_exists();
48
49	$media_table_name = WPDA_Media_Model::get_base_table_name();
50	$media_table_exists = WPDA_Media_Model::table_exists();
51
52	$data_publication_table_name = WPDA_Publisher_Model::get_base_table_name();
53	$data_publication_table_name_exists = WPDA_Publisher_Model::table_exists();
54
55	$table_settings_table_name = WPDA_Table_Settings_Model::get_base_table_name();
56	$table_settings_table_exists = WPDA_Table_Settings_Model::table_exists();
57
58	// Check table characteristics.
59	$table_chararteristics_results = $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin tables
60	$wpdb->prepare(
61	'
62	select table_name AS table_name, engine AS engine, table_collation AS table_collation
63	from information_schema.tables
64	where table_schema = %s
65	and table_name in (%s, %s, %s, %s, %s, %s, %s, %s, %s)',
66	array(
67	$wpdb->dbname,
68	$menus_table_name,
69	$design_table_name,
70	$logging_table_name,
71	$data_projects_project_name,
72	$data_projects_page_name,
73	$data_projects_table_name,
74	$media_table_name,
75	$data_publication_table_name,
76	$table_settings_table_name,
77	)
78	),
79	'ARRAY_A'
80	);
81	$table_chararteristics_engine = array();
82	$table_chararteristics_collation = array();
83	if ( false !== $table_chararteristics_results ) {
84	foreach ( $table_chararteristics_results as $table_chararteristics_result ) {
85	$table_chararteristics_engine[ $table_chararteristics_result['table_name'] ] = $table_chararteristics_result['engine'];
86	$table_chararteristics_collation[ $table_chararteristics_result['table_name'] ] = $table_chararteristics_result['table_collation'];
87	}
88	}
89	?>
90	<style>
91	.wpda-table-system-info th {
92	font-style: italic;
93	font-weight: normal;
94	padding: 0;
95	}
96
97	.wpda-table-system-info td {
98	padding: 0;
99	overflow-wrap: anywhere;
100	}
101
102	.wpda-table-settings tr:nth-child(even) {
103	background: unset;
104	}
105	</style>
106	<script type='text/javascript'>
107	jQuery(function () {
108	var text_to_clipboard = new ClipboardJS("#button-copy-to-clipboard", {
109	text: function () {
110	clipboard_text = "";
111	jQuery("#wpda_table_info tr .wpda_system_info_title").each(function () {
112	clipboard_text += jQuery(this).text().trim() + "\n";
113	jQuery(this).parent().find("th.wpda_system_info_subtitle").each(function () {
114	clipboard_text += jQuery(this).text().trim();
115	clipboard_text += "=";
116	clipboard_text += jQuery(this).parent().find("td.wpda_system_info_value").text().trim() + "\n";
117	});
118	});
119	return clipboard_text;
120	}
121	});
122	text_to_clipboard.on('success', function (e) {
123	jQuery.notify('<?php esc_html_e( 'System info successfully copied to clipboard!', 'wp-data-access' ); ?>','info');
124	});
125	text_to_clipboard.on('error', function (e) {
126	jQuery.notify('<?php esc_html_e( 'Could not copy system info to clipboard!', 'wp-data-access' ); ?>','error');
127	});
128	});
129	</script>
130	<table class="wpda-table-settings" id="wpda_table_info">
131	<tr>
132	<th class="wpda_system_info_title"><?php esc_html_e( 'Operating System', 'wp-data-access' ); ?></th>
133	<td>
134	<table class="wpda-table-system-info" style="width:100%">
135	<tr>
136	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Type', 'wp-data-access' ); ?></th>
137	<td class="wpda_system_info_value">
138	<?php echo esc_attr( php_uname( 's' ) ); ?>
139	</td>
140	<td style="float:right">
141	<a id="button-copy-to-clipboard" href="javascript:void(0)"
142	class="button button-primary">
143	<i class="fas fa-clipboard wpda_icon_on_button"></i>
144	<?php esc_html_e( 'Copy to clipboard', 'wp-data-access' ); ?>
145	</a>
146	</td>
147	</tr>
148	<tr>
149	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Release', 'wp-data-access' ); ?></th>
150	<td class="wpda_system_info_value" colspan="2">
151	<?php echo esc_attr( php_uname( 'r' ) ); ?>
152	</td>
153	</tr>
154	<tr>
155	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Version', 'wp-data-access' ); ?></th>
156	<td class="wpda_system_info_value" colspan="2">
157	<?php echo esc_attr( php_uname( 'v' ) ); ?>
158	</td>
159	</tr>
160	<tr>
161	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Machine Type', 'wp-data-access' ); ?></th>
162	<td class="wpda_system_info_value" colspan="2">
163	<?php echo esc_attr( php_uname( 'm' ) ); ?>
164	</td>
165	</tr>
166	<tr>
167	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Host Name', 'wp-data-access' ); ?></th>
168	<td class="wpda_system_info_value" colspan="2">
169	<?php echo esc_attr( php_uname( 'n' ) ); ?>
170	</td>
171	</tr>
172	</table>
173	</td>
174	</tr>
175	<tr>
176	<th class="wpda_system_info_title"><?php esc_html_e( 'Database Management System', 'wp-data-access' ); ?></th>
177	<td>
178	<table class="wpda-table-system-info" style="width:100%">
179	<tr>
180	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Version', 'wp-data-access' ); ?></th>
181	<td class="wpda_system_info_value" colspan="2">
182	<?php
183	$db_version = $wpdb->get_results( "SHOW VARIABLES LIKE 'version'", 'ARRAY_N' ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
184	if ( is_array( $db_version ) && isset( $db_version[0][1] ) ) {
185	echo esc_attr( $db_version[0][1] );
186	} else {
187	echo esc_attr( $wpdb->db_version );
188	}
189	?>
190	</td>
191	</tr>
192	<tr>
193	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Pivileges', 'wp-data-access' ); ?></th>
194	<td class="wpda_system_info_value" colspan="2">
195	<?php
196	$db_privileges = $wpdb->get_results( 'SHOW PRIVILEGES', 'ARRAY_N' ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
197	if ( is_array( $db_privileges ) ) {
198	$db_privileges_output = '';
199	foreach ( $db_privileges as $db_privilege ) {
200	$db_privileges_output .= "$db_privilege[0], ";
201	}
202	echo esc_attr( substr( $db_privileges_output, 0, strlen( $db_privileges_output ) - 2 ) );
203	}
204	?>
205	</td>
206	</tr>
207	<tr>
208	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Grants', 'wp-data-access' ); ?></th>
209	<td class="wpda_system_info_value" colspan="2">
210	<?php
211	$db_grants = $wpdb->get_results( 'SHOW GRANTS', 'ARRAY_N' ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
212	if ( is_array( $db_grants ) ) {
213	$db_grants_output = '';
214	foreach ( $db_grants as $db_grant ) {
215	$strpos = stripos( $db_grant[0], 'IDENTIFIED BY PASSWORD ' );
216	if ( false !== $strpos ) {
217	$db_grants_output .= substr( $db_grant[0], 0, $strpos ) . 'IDENTIFIED BY PASSWORD \'*****\'<br/>';
218	} else {
219	$db_grants_output .= "$db_grant[0]<br/>";
220	}
221	}
222	echo esc_attr( $db_grants_output );
223	}
224	?>
225	</td>
226	</tr>
227	<tr>
228	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'SQL Mode', 'wp-data-access' ); ?></th>
229	<td class="wpda_system_info_value" colspan="2">
230	<?php
231	$db_sql_mode = $wpdb->get_results( 'SHOW VARIABLES LIKE \'sql_mode\'', 'ARRAY_N' ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
232	if ( isset( $db_sql_mode[0][1] ) ) {
233	echo esc_attr( $db_sql_mode[0][1] );
234	}
235	?>
236	</td>
237	</tr>
238	</table>
239	</td>
240	</tr>
241	<tr>
242	<th class="wpda_system_info_title"><?php esc_html_e( 'Web Server', 'wp-data-access' ); ?></th>
243	<td>
244	<table class="wpda-table-system-info" style="width:100%">
245	<tr>
246	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Software', 'wp-data-access' ); ?></th>
247	<td class="wpda_system_info_value" colspan="2">
248	<?php echo esc_attr( sanitize_text_field( wp_unslash( $_SERVER['SERVER_SOFTWARE'] ) ) ); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotValidated ?>
249	</td>
250	</tr>
251	<tr>
252	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'PHP Version', 'wp-data-access' ); ?></th>
253	<td class="wpda_system_info_value" colspan="2">
254	<?php echo esc_attr( phpversion() ); ?>
255	</td>
256	</tr>
257	<tr>
258	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Protocol', 'wp-data-access' ); ?></th>
259	<td class="wpda_system_info_value" colspan="2">
260	<?php echo esc_attr( sanitize_text_field( wp_unslash( $_SERVER['SERVER_PROTOCOL'] ) ) ); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotValidated ?>
261	</td>
262	</tr>
263	<tr>
264	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Name', 'wp-data-access' ); ?></th>
265	<td class="wpda_system_info_value" colspan="2">
266	<?php echo esc_attr( sanitize_text_field( wp_unslash( $_SERVER['SERVER_NAME'] ) ) ); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotValidated ?>
267	</td>
268	</tr>
269	<tr>
270	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Address', 'wp-data-access' ); ?></th>
271	<td class="wpda_system_info_value" colspan="2">
272	<?php echo esc_attr( sanitize_text_field( wp_unslash( WPDA::get_server_address() ) ) ); ?>
273	</td>
274	</tr>
275	<tr>
276	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Root DIR', 'wp-data-access' ); ?></th>
277	<td class="wpda_system_info_value" colspan="2">
278	<?php echo esc_attr( sanitize_text_field( wp_unslash( $_SERVER['DOCUMENT_ROOT'] ) ) ); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotValidated ?>
279	</td>
280	</tr>
281	<tr>
282	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Temp DIR', 'wp-data-access' ); ?></th>
283	<td class="wpda_system_info_value" colspan="2">
284	<?php echo esc_attr( sys_get_temp_dir() ); ?>
285	</td>
286	</tr>
287	<tr>
288	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'HTTP Upload', 'wp-data-access' ); ?></th>
289	<td class="wpda_system_info_value" colspan="2">
290	<?php echo @ini_get( 'file_uploads' ) ? 'Enabled' : 'Disabled'; ?>
291	</td>
292	</tr>
293	<tr>
294	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Max Upload File Size', 'wp-data-access' ); ?></th>
295	<td class="wpda_system_info_value" colspan="2">
296	<?php echo esc_attr( @ini_get( 'upload_max_filesize' ) ); ?>
297	</td>
298	</tr>
299	<tr>
300	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Post Max Size', 'wp-data-access' ); ?></th>
301	<td class="wpda_system_info_value" colspan="2">
302	<?php echo esc_attr( @ini_get( 'post_max_size' ) ); ?>
303	</td>
304	</tr>
305	<tr>
306	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Max Execution Time', 'wp-data-access' ); ?></th>
307	<td class="wpda_system_info_value" colspan="2">
308	<?php echo esc_attr( @ini_get( 'max_execution_time' ) ); ?>
309	</td>
310	</tr>
311	<tr>
312	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Max Input Time', 'wp-data-access' ); ?></th>
313	<td class="wpda_system_info_value" colspan="2">
314	<?php echo esc_attr( @ini_get( 'max_input_time' ) ); ?>
315	</td>
316	</tr>
317	<tr>
318	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Memory Limit', 'wp-data-access' ); ?></th>
319	<td class="wpda_system_info_value" colspan="2">
320	<?php echo esc_attr( @ini_get( 'memory_limit' ) ); ?>
321	</td>
322	</tr>
323	<tr>
324	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Output Buffering', 'wp-data-access' ); ?></th>
325	<td class="wpda_system_info_value" colspan="2">
326	<?php echo esc_attr( @ini_get( 'output_buffering' ) ); ?>
327	</td>
328	</tr>
329	</table>
330	</td>
331	</tr>
332	<tr>
333	<th class="wpda_system_info_title"><?php esc_html_e( 'WordPress', 'wp-data-access' ); ?></th>
334	<td>
335	<table class="wpda-table-system-info" style="width:100%">
336	<tr>
337	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Version', 'wp-data-access' ); ?></th>
338	<td class="wpda_system_info_value" colspan="2">
339	<?php echo esc_attr( $wp_version ); ?>
340	</td>
341	</tr>
342	<tr>
343	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Home DIR', 'wp-data-access' ); ?></th>
344	<td class="wpda_system_info_value" colspan="2">
345	<?php
346	echo esc_attr( get_home_path() );
347
348	$error_level = error_reporting(); // phpcs:ignore
349	error_reporting( E_ALL ^ E_WARNING ); // phpcs:ignore
350	$file_permission = fileperms( get_home_path() );
351	error_reporting( $error_level ); // phpcs:ignore
352	echo '   >   ' . esc_attr( decoct( $file_permission & 0777 ) );
353	?>
354	</td>
355	</tr>
356	<tr>
357	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Uploads DIR', 'wp-data-access' ); ?></th>
358	<td class="wpda_system_info_value" colspan="2">
359	<?php
360	echo esc_attr( $uploads['basedir'] );
361
362	$error_level = error_reporting(); // phpcs:ignore
363	error_reporting( E_ALL ^ E_WARNING ); // phpcs:ignore
364	$file_permission = fileperms( $uploads['basedir'] );
365	error_reporting( $error_level ); // phpcs:ignore
366	echo '   >   ' . esc_attr( decoct( $file_permission & 0777 ) );
367	?>
368	</td>
369	</tr>
370	<tr>
371	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Home URL', 'wp-data-access' ); ?></th>
372	<td class="wpda_system_info_value" colspan="2">
373	<?php echo esc_attr( home_url() ); ?>
374	</td>
375	</tr>
376	<tr>
377	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Site URL', 'wp-data-access' ); ?></th>
378	<td class="wpda_system_info_value" colspan="2">
379	<?php echo esc_attr( site_url() ); ?>
380	</td>
381	</tr>
382	<tr>
383	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Upload URL', 'wp-data-access' ); ?></th>
384	<td class="wpda_system_info_value" colspan="2">
385	<?php echo esc_attr( $uploads['baseurl'] ); ?>
386	</td>
387	</tr>
388	<tr>
389	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Use MySQLi', 'wp-data-access' ); ?></th>
390	<td class="wpda_system_info_value" colspan="2">
391	<?php
392	// Taken from wp-db class
393	if ( function_exists( 'mysqli_connect' ) ) {
394	$use_mysqli = true;
395	if ( defined( 'WP_USE_EXT_MYSQL' ) ) {
396	$use_mysqli = ! WP_USE_EXT_MYSQL;
397	}
398	echo $use_mysqli ? 'true' : 'false';
399	}
400	?>
401	</td>
402	</tr>
403	<tr>
404	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Database Host', 'wp-data-access' ); ?></th>
405	<td class="wpda_system_info_value" colspan="2">
406	<?php echo esc_attr( DB_HOST ); ?>
407	</td>
408	</tr>
409	<tr>
410	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Database Name', 'wp-data-access' ); ?></th>
411	<td class="wpda_system_info_value" colspan="2">
412	<?php echo esc_attr( DB_NAME ); ?>
413	</td>
414	</tr>
415	<tr>
416	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Database User', 'wp-data-access' ); ?></th>
417	<td class="wpda_system_info_value" colspan="2">
418	<?php echo esc_attr( DB_USER ); ?>
419	</td>
420	</tr>
421	<tr>
422	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Database Character Set', 'wp-data-access' ); ?></th>
423	<td class="wpda_system_info_value" colspan="2">
424	<?php echo esc_attr( DB_CHARSET ); ?>
425	</td>
426	</tr>
427	<tr>
428	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Database Collate', 'wp-data-access' ); ?></th>
429	<td class="wpda_system_info_value" colspan="2">
430	<?php echo esc_attr( DB_COLLATE ); ?>
431	</td>
432	</tr>
433	<tr>
434	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'WP Debugging Mode', 'wp-data-access' ); ?></th>
435	<td class="wpda_system_info_value" colspan="2">
436	<?php echo ! defined( 'WP_DEBUG' ) ? 'undefined' : ( true === WP_DEBUG ? 'true' : 'false' ); ?>
437	</td>
438	</tr>
439	</table>
440	</td>
441	</tr>
442	<tr>
443	<th class="wpda_system_info_title">WP Data Access</th>
444	<td>
445	<table class="wpda-table-system-info" style="width:100%">
446	<tr>
447	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Version', 'wp-data-access' ); ?></th>
448	<td class="wpda_system_info_value" colspan="2">
449	<?php echo esc_attr( WPDA::get_option( WPDA::OPTION_WPDA_VERSION ) ); ?>
450	</td>
451	</tr>
452	<tr>
453	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Repository', 'wp-data-access' ); ?></th>
454	<td class="wpda_system_info_value" colspan="2">
455	<?php
456	echo $menus_table_name_exists ? '+' : '-';
457	echo esc_attr( $menus_table_name );
458	echo ' (';
459	echo isset( $table_chararteristics_engine[ $menus_table_name ] ) ? $table_chararteristics_engine[ $menus_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
460	echo ' \| ';
461	echo isset( $table_chararteristics_collation[ $menus_table_name ] ) ? $table_chararteristics_collation[ $menus_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
462	echo ')';
463	echo ' <br/>';
464	echo $design_table_name_exists ? '+' : '-';
465	echo esc_attr( $design_table_name );
466	echo ' (';
467	echo isset( $table_chararteristics_engine[ $design_table_name ] ) ? $table_chararteristics_engine[ $design_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
468	echo ' \| ';
469	echo isset( $table_chararteristics_collation[ $design_table_name ] ) ? $table_chararteristics_collation[ $design_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
470	echo ')';
471	echo ' <br/>';
472	echo $logging_table_exists ? '+' : '-';
473	echo esc_attr( $logging_table_name );
474	echo ' (';
475	echo isset( $table_chararteristics_engine[ $logging_table_name ] ) ? $table_chararteristics_engine[ $logging_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
476	echo ' \| ';
477	echo isset( $table_chararteristics_collation[ $logging_table_name ] ) ? $table_chararteristics_collation[ $logging_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
478	echo ')';
479	echo ' <br/>';
480	echo $data_projects_project_name_exists ? '+' : '-';
481	echo esc_attr( $data_projects_project_name );
482	echo ' (';
483	echo isset( $table_chararteristics_engine[ $data_projects_project_name ] ) ? $table_chararteristics_engine[ $data_projects_project_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
484	echo ' \| ';
485	echo isset( $table_chararteristics_collation[ $data_projects_project_name ] ) ? $table_chararteristics_collation[ $data_projects_project_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
486	echo ')';
487	echo ' <br/>';
488	echo $data_projects_page_name_exists ? '+' : '-';
489	echo esc_attr( $data_projects_page_name );
490	echo ' (';
491	echo isset( $table_chararteristics_engine[ $data_projects_page_name ] ) ? $table_chararteristics_engine[ $data_projects_page_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
492	echo ' \| ';
493	echo isset( $table_chararteristics_collation[ $data_projects_page_name ] ) ? $table_chararteristics_collation[ $data_projects_page_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
494	echo ')';
495	echo ' <br/>';
496	echo $data_projects_table_name_exists ? '+' : '-';
497	echo esc_attr( $data_projects_table_name );
498	echo ' (';
499	echo isset( $table_chararteristics_engine[ $data_projects_table_name ] ) ? $table_chararteristics_engine[ $data_projects_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
500	echo ' \| ';
501	echo isset( $table_chararteristics_collation[ $data_projects_table_name ] ) ? $table_chararteristics_collation[ $data_projects_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
502	echo ')';
503	echo ' <br/>';
504	echo $media_table_exists ? '+' : '-';
505	echo esc_attr( $media_table_name );
506	echo ' (';
507	echo isset( $table_chararteristics_engine[ $media_table_name ] ) ? $table_chararteristics_engine[ $media_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
508	echo ' \| ';
509	echo isset( $table_chararteristics_collation[ $media_table_name ] ) ? $table_chararteristics_collation[ $media_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
510	echo ')';
511	echo ' <br/>';
512	echo $data_publication_table_name_exists ? '+' : '-';
513	echo esc_attr( $data_publication_table_name );
514	echo ' (';
515	echo isset( $table_chararteristics_engine[ $data_publication_table_name ] ) ? $table_chararteristics_engine[ $data_publication_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
516	echo ' \| ';
517	echo isset( $table_chararteristics_collation[ $data_publication_table_name ] ) ? $table_chararteristics_collation[ $data_publication_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
518	echo ')';
519	echo ' <br/>';
520	echo $table_settings_table_exists ? '+' : '-';
521	echo esc_attr( $table_settings_table_name );
522	echo ' (';
523	echo isset( $table_chararteristics_engine[ $table_settings_table_name ] ) ? $table_chararteristics_engine[ $table_settings_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
524	echo ' \| ';
525	echo isset( $table_chararteristics_collation[ $table_settings_table_name ] ) ? $table_chararteristics_collation[ $table_settings_table_name ] : ''; // phpcs:ignore WordPress.Security.EscapeOutput
526	echo ')';
527	?>
528	</td>
529	</tr>
530	</table>
531	</td>
532	</tr>
533	<tr>
534	<th class="wpda_system_info_title"><?php esc_html_e( 'Browser', 'wp-data-access' ); ?></th>
535	<td>
536	<table id="wpda_system_info_browser" class="wpda-table-system-info" style="width:100%">
537	<tr>
538	<th class="wpda_system_info_subtitle"><?php esc_html_e( 'Agent', 'wp-data-access' ); ?></th>
539	<td class="wpda_system_info_value" colspan="2">
540	<?php echo esc_attr( sanitize_text_field( wp_unslash( $_SERVER['HTTP_USER_AGENT'] ) ) ); // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotValidated ?>
541	</td>
542	</tr>
543	<script type='text/javascript'>
544	jQuery.each(jQuery.browser, function (i, val) {
545	jQuery("#wpda_system_info_browser").append("<tr><th class=\"wpda_system_info_subtitle\">" + i[0].toUpperCase() + i.substring(1).toLowerCase() + "</th><td class=\"wpda_system_info_value\" colspan=\"2\">" + val + "</td></tr>");
546	});
547	</script>
548	</table>
549	</td>
550	</tr>
551	</table>
552	<?php
553	}
554
555	}
556
557	}
558