1:  2:  3:  4:  5:  6:  7:  8:  9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 

<?php

namespace WPGMZA\Integration;

if(!class_exists('WPGMZA\\Integration\\WPMigrateDB'))
{
    /**
     * Integrates with WP Migrate DB (by Deliciousbrains). Please note our plugin must be selected by default in their plugins compatibilty settings in order for this integration module to be called.
     */
    class WPMigrateDB
    {
        /**
         * Constructor
         */
        public function __construct()
        {
            add_filter('wpmdb_compatibility_plugin_whitelist', array($this, 'onCompatibilityPluginWhitelist'));
            add_filter('wpmdb_process_column_as_binary', array($this, 'onProcessColumnAsBinary'), 10, 2);
        }
        
        public function onCompatibilityPluginWhitelist($plugins)
        {
            $plugins[] = 'wp-google-maps';
            $plugins[] = 'wp-google-maps-pro';
            return $plugins;
        }
        
        /**
         * Called by WP Migrate DBs wpmdb_process_column_as_binary filter. If the specified column is a spatial column, indicate that this is binary data. WP Migrate DB will convert it to hex and wrap it with an UNHEX call in their exported data.
         * @return bool TRUE for binary data, FALSE for everything else.
         */
        public function onProcessColumnAsBinary($processAsBinary, $struct)
        {
            if(preg_match('/^GEOMETRY|POINT|POLYGON|LINESTRING|MULTIPOINT|MULTILINESTRING|MULTIPOLYGON|GEOMETRYCOLLECTION$/i', $struct->Type))
                return true;
            
            return $processAsBinary;
        }
    }
}

$wpgmza_wp_migration_db_module = new WPMigrateDB();