posts} DROP INDEX crp_related;";
$sql .= '
';
$sql .= "ALTER TABLE {$wpdb->posts} DROP INDEX crp_related_title;";
$sql .= '
';
$sql .= "ALTER TABLE {$wpdb->posts} ADD FULLTEXT crp_related (post_title, post_content);";
$sql .= '
';
$sql .= "ALTER TABLE {$wpdb->posts} ADD FULLTEXT crp_related_title (post_title);";
/**
* Filters the SQL code to recreate the PRIMARY KEY.
*
* @since 2.6.0
* @param string $sql SQL code to recreate PRIMARY KEY.
*/
return apply_filters( 'crp_recreate_indices_sql', $sql );
}
/**
* Process a settings export that generates a .json file of the shop settings
*
* @since 2.9.0
*/
function crp_process_settings_export() {
if ( empty( $_POST['crp_action'] ) || 'export_settings' !== $_POST['crp_action'] ) {
return;
}
if ( ! isset( $_POST['crp_export_settings_nonce'] ) || ! wp_verify_nonce( sanitize_key( $_POST['crp_export_settings_nonce'] ), 'crp_export_settings_nonce' ) ) {
return;
}
if ( ! current_user_can( 'manage_options' ) ) {
return;
}
$settings = get_option( 'crp_settings' );
ignore_user_abort( true );
nocache_headers();
header( 'Content-Type: application/json; charset=utf-8' );
header( 'Content-Disposition: attachment; filename=crp-settings-export-' . gmdate( 'm-d-Y' ) . '.json' );
header( 'Expires: 0' );
echo wp_json_encode( $settings );
exit;
}
add_action( 'admin_init', 'crp_process_settings_export' );
/**
* Process a settings import from a json file
*
* @since 2.9.0
*/
function crp_process_settings_import() {
if ( empty( $_POST['crp_action'] ) || 'import_settings' !== $_POST['crp_action'] ) {
return;
}
if ( ! isset( $_POST['crp_import_settings_nonce'] ) || ! wp_verify_nonce( sanitize_key( $_POST['crp_import_settings_nonce'] ), 'crp_import_settings_nonce' ) ) {
return;
}
if ( ! current_user_can( 'manage_options' ) ) {
return;
}
$filename = 'import_settings_file';
$extension = isset( $_FILES[ $filename ]['name'] ) ? end( explode( '.', sanitize_file_name( wp_unslash( $_FILES[ $filename ]['name'] ) ) ) ) : '';
if ( 'json' !== $extension ) {
wp_die( esc_html__( 'Please upload a valid .json file', 'contextual-related-posts' ) );
}
$import_file = isset( $_FILES[ $filename ]['tmp_name'] ) ? ( wp_unslash( $_FILES[ $filename ]['tmp_name'] ) ) : ''; // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
if ( empty( $import_file ) ) {
wp_die( esc_html__( 'Please upload a file to import', 'contextual-related-posts' ) );
}
// Retrieve the settings from the file and convert the json object to an array.
$settings = (array) json_decode( file_get_contents( $import_file ), true ); // phpcs:ignore WordPress.WP.AlternativeFunctions.file_get_contents_file_get_contents
update_option( 'crp_settings', $settings );
wp_safe_redirect(
add_query_arg(
array(
'page' => 'crp_tools_page',
'settings_import' => 'success',
),
admin_url( 'admin.php' )
)
);
exit;
}
add_action( 'admin_init', 'crp_process_settings_import', 9 );