Completely remove geodir wp_options + installed tables

Further, it seems the plugin modifies core WP tables (adds icon column to wp_terms)

Hi Jamie,

Thanks for reporting this. Most of our uninstall functionality is in our addons, some things in core have been over looked. I’ll write a code snippet for this and post it here for you later.

Thanks,

Stiofan

Thanks!

Hi Jamie,

Please run the below function (as with everything WP i advise you to make a backup first)

If you have any issues just let me know.

function geodir_uninstall(){
    global $wpdb;

    // Pages.
    wp_delete_post( get_option('geodir_location_page'), true );
    wp_delete_post( get_option('geodir_success_page'), true );
    wp_delete_post( get_option('geodir_preview_page'), true );
    wp_delete_post( get_option('geodir_add_listing_page'), true );
    wp_delete_post( get_option('geodir_home_page'), true );
    wp_delete_post( get_option('geodir_info_page'), true );
    wp_delete_post( get_option('geodir_login_page'), true );

    // Delete usermeta.
    $wpdb->query( "DELETE FROM $wpdb->usermeta WHERE meta_key LIKE 'gd\_user\_favourite\_post%';" );

    // remove post types
    $post_types = get_option('geodir_post_types');

    // Delete posts.
    if ( ! empty( $post_types ) ) {
        foreach ( $post_types as $post_type => $data ) {
            $wpdb->query( "DELETE FROM {$wpdb->posts} WHERE post_type LIKE '{$post_type}';" );

            // Delete post menu
            $wpdb->query( "DELETE posts FROM {$wpdb->posts} posts LEFT JOIN {$wpdb->postmeta} meta ON posts.ID = meta.post_id WHERE posts.post_type= 'nav_menu_item' AND meta.meta_key = '_menu_item_object' AND meta.meta_value = '{$post_type}';" );
            $wpdb->query( "DELETE posts FROM {$wpdb->posts} posts LEFT JOIN {$wpdb->postmeta} meta ON posts.ID = meta.post_id WHERE posts.post_type= 'nav_menu_item' AND meta.meta_key = '_menu_item_url' AND meta.meta_value LIKE '%listing_type={$post_type}%';" );
        }
    }

    // Delete post meta.
    $wpdb->query( "DELETE meta FROM {$wpdb->postmeta} meta LEFT JOIN {$wpdb->posts} posts ON posts.ID = meta.post_id WHERE posts.ID IS NULL;" );

    // Delete orphan attachment.
    $wpdb->query( "DELETE post1 FROM {$wpdb->posts} post1 LEFT JOIN {$wpdb->posts} post2 ON post1.post_parent = post2.ID WHERE post1.post_parent > 0 AND post1.post_type = 'attachment' AND post2.ID IS NULL;" );

    // Delete term taxonomies.
    if ( ! empty( $post_types ) ) {
        foreach ( $post_types as $post_type => $data  ) {
            $wpdb->query( "DELETE FROM {$wpdb->term_taxonomy} WHERE taxonomy LIKE '{$post_type}category' OR taxonomy LIKE '{$post_type}_tags';" );
        }
    }

    // Delete orphan relationships.
    $wpdb->query( "DELETE tr FROM {$wpdb->term_relationships} tr LEFT JOIN {$wpdb->posts} posts ON posts.ID = tr.object_id WHERE posts.ID IS NULL;" );

    // Delete orphan terms.
    $wpdb->query( "DELETE t FROM {$wpdb->terms} t LEFT JOIN {$wpdb->term_taxonomy} tt ON t.term_id = tt.term_id WHERE tt.term_id IS NULL;" );

    // Delete orphan term meta.
    $wpdb->query( "DELETE tm FROM {$wpdb->termmeta} tm LEFT JOIN {$wpdb->term_taxonomy} tt ON tm.term_id = tt.term_id WHERE tt.term_id IS NULL;" );

    // Comments
    $wpdb->query( "DELETE comments FROM {$wpdb->comments} AS comments LEFT JOIN {$wpdb->posts} AS posts ON posts.ID = comments.comment_post_ID WHERE posts.ID IS NULL;" );
    $wpdb->query( "DELETE meta FROM {$wpdb->commentmeta} meta LEFT JOIN {$wpdb->comments} comments ON comments.comment_ID = meta.comment_id WHERE comments.comment_ID IS NULL;" );

    // Options
    // Delete settings
    $wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE 'geodir_settings' OR option_name LIKE 'geodirectory\_%' OR option_name LIKE 'geodir\_%' OR option_name LIKE 'tax_meta_gd\_%' OR  option_name LIKE 'gd\_%' AND option_name LIKE '%category\_installed' ;" );

    // Extra options
    $extra_options = array(
        "widget_popular_post_category",
        "widget_popular_post_view",
        "gd_theme_compats",
        "gd_theme_compats",
        "theme_compatibility_setting",
        "skip_install_geodir_pages",
        "widget_social_like_widget",
        "widget_widget_subscribewidget",
        "widget_advtwidget",
        "widget_widget_flickrwidget",
        "widget_widget_twidget",
        "widget_listing_slider_view",
        "widget_geodir_recent_reviews",
        "widget_post_related_listing",
        "widget_bestof_widget",
        "gd_place_dummy_data_type",
        "gd_theme_compat",
        "gd_term_icons",
    );

    foreach( $extra_options as $option){
        $wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name= '$option';" );
    }

    $wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE 'widget\_gd\_%' OR option_name LIKE 'widget\_geodir\_%' ;" );

    // Delete transients
    $wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient__gd_activation_redirect' OR option_name LIKE '\_transient\_geodir\_%' OR option_name LIKE '\_transient\_gd_addons_section\_%' OR option_name LIKE '\_transient\_gd_avg\_%'" );
    $wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_timeout__gd_activation_redirect' OR option_name LIKE '\_timeout\_transient\_geodir\_%' OR option_name LIKE '\_timeout\_transient\_gd_addons_section\_%' OR option_name LIKE '\_timeout\_transient\_gd_avg\_%'" );
    $wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '_site_transient__gd_activation_redirect' OR option_name LIKE '\_site\_transient\_geodir\_%' OR option_name LIKE '\_site\_transient\_gd_addons_section\_%' OR option_name LIKE '\_site\_transient\_gd_avg\_%'" );
    $wpdb->query( "DELETE FROM {$wpdb->options} WHERE option_name LIKE '_site_transient_timeout__gd_activation_redirect' OR option_name LIKE '\_site\_transient\_timeout\_geodir\_%' OR option_name LIKE '\_site\_transient\_timeout\_gd_addons_section\_%' OR option_name LIKE '\_site\_transient\_timeout\_gd_avg\_%'" );

    // Drop tables
    $plugin_prefix = $wpdb->prefix . 'geodir_';
    $wpdb->query( "DROP TABLE IF EXISTS ". $plugin_prefix . 'countries' );
    $wpdb->query( "DROP TABLE IF EXISTS ". $plugin_prefix . 'custom_fields' );
    $wpdb->query( "DROP TABLE IF EXISTS ". $plugin_prefix . 'post_icon' );
    $wpdb->query( "DROP TABLE IF EXISTS ". $plugin_prefix . 'attachments' );
    $wpdb->query( "DROP TABLE IF EXISTS ". $plugin_prefix . 'post_review' );
    $wpdb->query( "DROP TABLE IF EXISTS ". $plugin_prefix . 'custom_sort_fields' );

    // Delete term taxonomies.
    if ( ! empty( $post_types ) ) {
        foreach ( $post_types as $post_type => $data  ) {
            $wpdb->query( "DROP TABLE IF EXISTS ". $plugin_prefix . $post_type . '_detail' );

        }
    }

    // Clear any cached data that has been removed.
    wp_cache_flush();

}

Thanks,

Stiofan

Thank you very much for coming back to me so quickly and providing this code. I really appreciate your help and it was just what I needed to clean up a WP install.

It worked perfectly. The only extra thing I did was to remove the icon column on the wp_terms table, as the plugin seemed to have added that.

Thanks again.

Thanks for letting me know it worked, glad i could help ??

Stiofan