/* add a client id box to an event */
function my_em_client_id_metabox(){
	global $EM_Event;
	$my_em_client_id = get_option('my-em-client-id');
	?>
	<div id="event-styles" class="stuffbox">
		<h3>Client ID</h3>
		<div class="inside" style="padding:10px;">

			<label><input type="text" name="client_id" value="<?php echo $EM_Event->client_id; ?>" /></label><br />

		</div>
	</div>
	<?php
}

add_action('em_admin_event_form_side_footer','my_em_client_id_metabox');
add_action('em_front_event_form_footer','my_em_client_id_metabox');

/* save the client id */
add_filter('em_event_save','my_em_client_id_event_save',1,2);
function my_em_client_id_event_save($result,$EM_Event){
	global $wpdb;
	$my_em_client_id = get_option('my-em-client-id') ;
	if( $result && !empty($_POST['client_id']) ){
		$EM_Event->client_id = $_POST['client_id'];

		//First delete any old saves
		$wpdb->query("DELETE FROM ".EM_META_TABLE." WHERE object_id='{$EM_Event->id}' AND meta_key='my-em-client-id'");
		if( trim($EM_Event->client_id) != '' ){
			$wpdb->query("INSERT INTO ".EM_META_TABLE." (object_id, meta_key, meta_value) VALUES (" .$EM_Event->id .",'my-em-client-id',".$EM_Event->client_id .")");
		}
	}
	return $result;
}