Function Reference: geodir_changes_in_custom_fields_table
Summary
Geodirectory updated custom field table(add field and change show in sidebar value in db).
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_changes_in_custom_fields_table() is located in geodirectory_hooks_actions.php [Line: 1612]
Source Code
function geodir_changes_in_custom_fields_table() { global $wpdb, $plugin_prefix; // Remove unused virtual page $listings_page_id = (int)get_option('geodir_listing_page'); if ($listings_page_id) { $wpdb->query($wpdb->prepare("DELETE FROM " . $wpdb->posts . " WHERE ID=%d AND post_name = %s AND post_type=%s", array($listings_page_id, 'listings', 'page'))); delete_option('geodir_listing_page'); } if (!get_option('geodir_changes_in_custom_fields_table')) { $wpdb->query( $wpdb->prepare( "UPDATE " . GEODIR_CUSTOM_FIELDS_TABLE . " SET is_default=%s, is_admin=%s WHERE is_default=%s", array('1', '1', 'admin') ) ); /* --- terms meta value set --- */ update_option('geodir_default_marker_icon', geodir_plugin_url() . '/geodirectory-functions/map-functions/icons/pin.png'); $options_data = $wpdb->get_results($wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "options WHERE option_name LIKE %s", array('%tax_meta_%'))); if (!empty($options_data)) { foreach ($options_data as $optobj) { $option_val = str_replace('tax_meta_', '', $optobj->option_name); $taxonomies_data = $wpdb->get_results($wpdb->prepare("SELECT taxonomy FROM " . $wpdb->prefix . "term_taxonomy WHERE taxonomy LIKE %s AND term_id=%d", array('%category%', $option_val))); if (!empty($taxonomies_data)) { foreach ($taxonomies_data as $taxobj) { $taxObject = get_taxonomy($taxobj->taxonomy); $post_type = $taxObject->object_type[0]; $opt_value = 'tax_meta_' . $post_type . '_' . $option_val; $duplicate_data = $wpdb->get_var($wpdb->prepare("SELECT option_id FROM " . $wpdb->prefix . "options WHERE option_name=%s", array('tax_meta_' . $option_val))); if ($duplicate_data) { $wpdb->query($wpdb->prepare("UPDATE " . $wpdb->prefix . "options SET option_name=%s WHERE option_id=%d", array($opt_value, $optobj->option_id))); } else { $wpdb->query($wpdb->prepare("INSERT INTO " . $wpdb->prefix . "options (option_name,option_value,autoload) VALUES (%s, %s, %s)", array($opt_value, $optobj->option_value, $optobj->autoload))); } } } } } update_option('geodir_changes_in_custom_fields_table', '1'); } }