Function Reference: geodir_advance_search_field

Summary

This function has not been documented yet.

Source File

geodir_advance_search_field() is located in geodir_advance_search_filters/geodirectory_advance_search_function.php [Line: 685]

Source Code

function geodir_advance_search_field(){
	global $plugin_prefix, $wpdb;
	
	/**
	 * Include any functions needed for upgrades.
	 *
	 * @since 1.2.5
	 */
	require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
	
	
	// rename tables if we need to
	if($wpdb->query("SHOW TABLES LIKE 'geodir_custom_advance_search_fields'")>0 && $wpdb->query("SHOW TABLES LIKE '".$wpdb->prefix."geodir_custom_advance_search_fields'")==0){$wpdb->query("RENAME TABLE geodir_custom_advance_search_fields TO ".$wpdb->prefix."geodir_custom_advance_search_fields");}
	
	$collate = '';
	if($wpdb->has_cap( 'collation' )) {
		if(!empty($wpdb->charset)) $collate = "DEFAULT CHARACTER SET $wpdb->charset";
		if(!empty($wpdb->collate)) $collate .= " COLLATE $wpdb->collate";
	}
	$advance_search_table = "CREATE TABLE ".GEODIR_ADVANCE_SEARCH_TABLE." (
									  `id` int(11) NOT NULL AUTO_INCREMENT,
									  `post_type` varchar(255) NOT NULL,
									  `field_site_name` varchar(255) NOT NULL,
									  `field_site_type` varchar(255) NOT NULL,
									  `site_htmlvar_name` varchar(255) NOT NULL,
									  `expand_custom_value` int(11) NOT NULL,
									  `searching_range_mode` int(11) NOT NULL,
									  `expand_search` int(11) NOT NULL,
									  `front_search_title` varchar(255) CHARACTER SET utf8 NOT NULL,
									  `first_search_value` int(11) NOT NULL,
									  `first_search_text` varchar(255) CHARACTER SET utf8 NOT NULL,
									  `last_search_text` varchar(255) CHARACTER SET utf8 NOT NULL,
									  `search_min_value` int(11) NOT NULL,
									  `search_max_value` int(11) NOT NULL,
									  `search_diff_value` int(11) NOT NULL DEFAULT '0',
									  `search_condition` varchar(100) NOT NULL,
									  `field_input_type` varchar(255) NOT NULL,
									  `field_data_type` varchar(255) NOT NULL,
									  `sort_order` int(11) NOT NULL,
									  `field_desc` varchar(255) NOT NULL,
										`extra_fields` TEXT NOT NULL,
									  PRIMARY KEY  (id)
									) $collate AUTO_INCREMENT=1 ;";
						
	dbDelta($advance_search_table);
}