Function Reference: geodir_event_delete_unnecessary_fields

Summary

This function has not been documented yet.

Source File

geodir_event_delete_unnecessary_fields() is located in geodir_event_manager/gdevents-admin/admin_functions.php [Line: 572]

Source Code

function geodir_event_delete_unnecessary_fields(){
	global $wpdb;
	
	if(!get_option('geodir_event_delete_unnecessary_fields')){
		
		if($wpdb->get_var("SHOW COLUMNS FROM ".EVENT_DETAIL_TABLE." WHERE field = 'categories'"))
			$wpdb->query("ALTER TABLE `".EVENT_DETAIL_TABLE."` DROP `categories`");
		
		if($wpdb->get_var("SHOW COLUMNS FROM ".EVENT_DETAIL_TABLE." WHERE field = 'Recurring'"))
			$wpdb->query("ALTER TABLE `".EVENT_DETAIL_TABLE."` DROP `Recurring`");
			
		if($wpdb->get_var("SHOW COLUMNS FROM ".EVENT_DETAIL_TABLE." WHERE field = 'event_start'"))
			$wpdb->query("ALTER TABLE `".EVENT_DETAIL_TABLE."` DROP `event_start`");
		
		if($wpdb->get_var("SHOW COLUMNS FROM ".EVENT_DETAIL_TABLE." WHERE field = 'event_end'"))
			$wpdb->query("ALTER TABLE `".EVENT_DETAIL_TABLE."` DROP `event_end`");
			
		if($wpdb->get_var("SHOW COLUMNS FROM ".EVENT_DETAIL_TABLE." WHERE field = 'event_start_time'"))
			$wpdb->query("ALTER TABLE `".EVENT_DETAIL_TABLE."` DROP `event_start_time`");
		
		if($wpdb->get_var("SHOW COLUMNS FROM ".EVENT_DETAIL_TABLE." WHERE field = 'event_end_time'"))
			$wpdb->query("ALTER TABLE `".EVENT_DETAIL_TABLE."` DROP `event_end_time`");
		
		update_option('geodir_event_delete_unnecessary_fields', '1');
		
	}
}