Function Reference: geodir_remove_unnecessary_fields

Summary

Removes unnecessary table columns from the database.

Global Values

$wpdb

(object) (required) WordPress Database object.

Default: None

$plugin_prefix

(string) (required) Geodirectory plugin table prefix.

Default: None

Package

GeoDirectory

Change Log

Since: 1.0.0

Source File

geodir_remove_unnecessary_fields() is located in geodirectory-admin/admin_hooks_actions.php [Line: 957]

Source Code

function geodir_remove_unnecessary_fields()
{
    global $wpdb, $plugin_prefix;

    if (!get_option('geodir_remove_unnecessary_fields')) {

        if ($wpdb->get_var("SHOW COLUMNS FROM " . $plugin_prefix . "gd_place_detail WHERE field = 'categories'"))
            $wpdb->query("ALTER TABLE `" . $plugin_prefix . "gd_place_detail` DROP `categories`");

        update_option('geodir_remove_unnecessary_fields', '1');

    }

}