" . esc_html__( 'Database Tools', 'newstatpress' ) . '
';
// phpcs:ignore WordPress.Security.NonceVerification.Recommended -- Only reading 'tab' to determine active admin subpage.
if ( isset( $_GET['tab'] ) ) {
// phpcs:ignore WordPress.Security.NonceVerification.Recommended
$tab = sanitize_text_field( wp_unslash( $_GET['tab'] ) );
newstatpress_display_tabs_navbar_for_menu_page( $tools_page_tabs, $tab, $page );
} else {
newstatpress_display_tabs_navbar_for_menu_page( $tools_page_tabs, $default_tab, $page );
}
// phpcs:ignore WordPress.Security.NonceVerification.Recommended -- Reading navigation parameters, not processing form data.
if ( 'admin.php' === $pagenow && isset( $_GET['page'] ) && $page === sanitize_text_field( wp_unslash( $_GET['page'] ) ) ) {
// phpcs:ignore WordPress.Security.NonceVerification.Recommended -- Reading navigation parameter.
if ( isset( $_GET['tab'] ) ) {
// phpcs:ignore WordPress.Security.NonceVerification.Recommended
$tab = sanitize_text_field( wp_unslash( $_GET['tab'] ) );
} else {
$tab = $default_tab;
}
switch ( $tab ) {
case 'IP2nation':
newstatpress_ip2nation();
break;
case 'export':
newstatpress_export();
break;
case 'update':
newstatpress_update();
break;
case 'optimize':
newstatpress_optimize();
break;
case 'repair':
newstatpress_repair();
break;
case 'remove':
newstatpress_remove_plugin_database();
break;
case 'info':
newstatpress_display_database_info();
break;
}
}
}
/**
* Get table size of index
*
* @param string $table table to search.
*/
function newstatpress_index_table_size( $table ) {
global $wpdb;
// no needs prepare.
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$res = $wpdb->get_results( $wpdb->prepare( 'SHOW TABLE STATUS LIKE %s', $table ) ); // db call ok; no-cache ok.
foreach ( $res as $fstatus ) {
$index_lenght = $fstatus->Index_length; // phpcs:ignore -- not in valid snake_case format: it is a DB field!
}
return number_format( ( $index_lenght / 1024 / 1024 ), 2, ',', ' ' ) . ' Mb';
}
/**
* IP2nation form function
*************************/
function newstatpress_ip2nation() {
// Install or Remove if requested by user.
if ( isset( $_POST['installation'] ) && 'install' === $_POST['installation'] ) {
check_admin_referer( 'nsp_tool', 'nsp_tool_post' );
if ( ! current_user_can( 'administrator' ) ) {
die( 'NO permission' );
}
if ( ! ( isset( $_REQUEST['nsp_tool_post'] ) && wp_verify_nonce( sanitize_text_field( wp_unslash( $_REQUEST['nsp_tool_post'] ) ), 'nsp_tool' ) ) ) {
die( 'Failed security check' );
}
$install_result = newstatpress_ip2nation_install();
} elseif ( isset( $_POST['installation'] ) && 'remove' === $_POST['installation'] ) {
check_admin_referer( 'nsp_tool', 'nsp_tool_post' );
if ( ! current_user_can( 'administrator' ) ) {
die( 'NO permission' );
}
if ( ! ( isset( $_REQUEST['nsp_tool_post'] ) && wp_verify_nonce( sanitize_text_field( wp_unslash( $_REQUEST['nsp_tool_post'] ) ), 'nsp_tool' ) ) ) {
die( 'Failed security check' );
}
$install_result = newstatpress_ip2nation_remove();
}
// Display message if present.
if ( isset( $install_result ) && '' !== $install_result ) {
print "
" . esc_html( $install_result ) . '
';
}
global $newstatpress_option_vars;
global $wpdb;
// Create IP2nation variable if not exists: value 'none' by default or date when installed.
$installed = get_option( $newstatpress_option_vars['ip2nation']['name'] );
if ( '' === $installed ) {
add_option( $newstatpress_option_vars['ip2nation']['name'], $newstatpress_option_vars['ip2nation']['value'], '', 'yes' );
}
echo '
';
$file_ip2nation = plugin_dir_path( __FILE__ ) . '/includes/ip2nation.sql';
$date = gmdate( 'd/m/Y', filemtime( $file_ip2nation ) );
$table_name = 'ip2nation';
// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
$val = $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $table_name ) ); // db call ok; no-cache ok.
if ( $val !== $table_name ) {
$value_remove = 'none';
$class_inst = 'desactivated';
$installed = $newstatpress_option_vars['ip2nation']['value'];
} else {
$value_remove = 'remove';
$class_inst = '';
$installed = get_option( $newstatpress_option_vars['ip2nation']['name'] );
if ( 'none' === $installed ) {
$installed = esc_html__( 'unknow', 'newstatpress' );
}
}
// Display status.
// translators: placeholder for number of version.
$i = sprintf( __( 'Last version available: %s', 'newstatpress' ), $date );
echo esc_html( $i ) . '
';
if ( 'none' !== $installed ) {
// translators: placeholder for number of version.
$i = sprintf( __( 'Last version installed: %s', 'newstatpress' ), $installed );
echo esc_html( $i ) . '
';
esc_html_e( 'To update the IP2nation database, just click on the button bellow.', 'newstatpress' );
if ( $installed === $date ) {
$button_name = __( 'Update', 'newstatpress' );
$value_install = 'none';
$class_install = 'desactivated';
} else {
$button_name = __( 'Install', 'newstatpress' );
}
} else {
esc_html_e( 'Last version installed: none ', 'newstatpress' );
echo '
';
esc_html_e( 'To download and to install the IP2nation database, just click on the button bellow.', 'newstatpress' );
$button_name = __( 'Install', 'newstatpress' );
}
?>
';
echo wp_kses(
_e( 'ip2nation is a free MySQL database that offers a quick way to map an IP to a country. The database is optimized to ensure fast lookups and is based on information from ARIN, APNIC, RIPE etc. You may install the database using the link to the left. (see:
http://www.ip2nation.com)', 'newstatpress' ),
array(
'a' => array(
'href' => array(),
),
)
);
echo "
"
. esc_html__( 'Note: The installation may take some times to complete.', 'newstatpress' ) .
'';
?>