Ubuntu

query( "INSERT INTO {$wpdb->prefix}secupress_geoips (begin_ip, country_code) VALUES ($query)" ); // WPCS: unprepared SQL ok. } } /** * Update the file + database * * @return (bool) Bool if ok * @since 1.4.6 * @author Julio Potier **/ function secupress_geoips_update_datas() { global $wpdb; $wpdb->query( "TRUNCATE TABLE {$wpdb->prefix}secupress_geoips" ); $result = secupress_geoips_update_data( 'v4' ); $result = $result && secupress_geoips_update_data( 'v6' ); secupress_set_option( 'geoips_last_update', date_i18n( get_option( 'date_format', time() ) ) ); return $result; } /** * Update the file + database * * @return (bool) Bool if ok * @since 1.4.6 * @author Julio Potier **/ function secupress_geoips_update_data( $type ) { $downloads = secupress_geoips_get_downloads(); if ( ! isset( $downloads[ $type ] ) ) { return false; } secupress_geoips_update_datafile( $type ); $filename = SECUPRESS_PRO_INC_PATH . 'data/geoips' . $type . '.data'; $queries = file_exists( $filename ) ? file_get_contents( $filename ) : false; @unlink( $filename ); if ( $queries ) { secupress_geoips_update_database( $queries ); return true; } return false; } /** * Declare the ID and filename from software77.net * * @since 1.4.9 * @author Julio Potier * * @return (array) The files needed to get the ipv4 and ipv6 content **/ function secupress_geoips_get_downloads() { return [ 'v4' => [ 'id' => 2, 'file' => '/IpToCountry.csv' ], 'v6' => [ 'id' => 7, 'file' => '/IpToCountry.6R.csv' ] ]; }