writegnj

I got custom front-end form and trying to save event data from it in functions.php with action hook.

global $wpdb;
    $wpdb->insert( $wpdb->prefix . 'em_locations',
		array(
				'post_id'			=> $post_id,
				'blog_id'			=> $blog_id,
				'location_slug'		=> $location_slug,
				'location_name'		=> $_POST['cf_location_name'],
				'location_owner'	=> $current_user->ID,
				'location_address' 	=> $fullstreet,
				'location_town'		=> $_POST['cf_location_city'],
				'location_state'	=> $_POST['cf_location_state'],
				'location_postcode'	=> $_POST['cf_location_zipcode'],
				//'location_country'	=> $_POST['cf_location_country'],
				'location_country'	=> 'US',
				'location_latitude'	=> $_POST['cf_location_lat'],
				'location_longitude'=> $_POST['cf_location_lng'],
				'location_status'	=> '1'
			)
		);

    $wpdb->insert( $wpdb->prefix . 'em_events',
		array(
				'post_id'				=> $post_id,
				'blog_id'				=> $blog_id,
				'event_slug'			=> $event_slug,
				'event_owner'			=> $current_user->ID,
				'event_status'			=> '0',
				'event_name'			=>	$_POST['wpuf_post_title'],
				'event_start_time'		=> $event_st,
				'event_end_time'		=> $event_et,
				'event_all_day'			=> '0',
				'event_start_date'		=> $_POST['cf_date_start'],
				'event_end_date'		=> $_POST['cf_date_to'],
				'post_content'			=> $_POST['wpuf_post_content'],
				'location_id'			=> $EM_Location->id,
				'event_category_id'		=> $_POST['cf_event_category'],
				'event_date_created'	=> $post_date,
				'event_date_modified'	=> $post_modified
			)
		);
}

After submitting the form I saw data stored in Database but it goes to 404 page on front-end.

would u mind giving me some tips to make that happen? I have been trying
overwriting event_status to “0” and post_status to “pending” when front-end form submitted at first time. Then display “pay now” button on dashboard.

then attach post_id to pay now button that connects to Paypal, so if payments made, update event_status to “1” and post_status to “publish”.

I have been spending quite amount of time trying this but could not even solve the first thing yet.

Hi Angelo, no I’m a not pro user. However, if events manager integrate pay per post function on front-end form with transaction history for both back-end(for admin) and front-end(by each user), I would love to purchase pro version.

I’m trying to make this happen by my own now and having lot of trouble due to lack of my programing knowledge.

Thanks for the response angelo!

I’m not very comfortable with PHP but I think this should work.

I want to overwrite event_statue to “0” on em_events table(on database) when the Front-end event form submitted.
I believe I can do this on my Theme’s functions.php file by adding the hook in there(below code; if it make sense).
Can u tell me what hook that will be? if that exist.

function update_event_statue($event_id){
$thisposteventid = $EM_Event->event_id;
    global $wpdb;
    $wpdb->update( $wpdb->prefix . 'em_events',
		array( 'event_status' => '0' ),
		array( 'event_id' => $thisposteventid )
		);
add_action( 'EVENTS_MANAGER_HOOK', "update_event_statue" );

So I messed around with s2member but it did not work out for me. I need other solution any suggestions?