Support

November 6, 2014 at 2:50 pm

Then I found this thread, and this might be the most elegant solution. Would this kind of thing still work?

https://eventespresso.com/topic/additional-attendees-different-pricing/

November 6, 2014 at 3:24 pm

I haven’t but I thought you could have a negative value as long as the total did end up in the negative. I could be wrong on that, but I’ll check it out. And I’m going to try Sidney’s solution too.

November 10, 2014 at 2:41 pm

Thanks, Dean. So, I think I’m doing what Sidney suggested, but I’m getting an error that suggests the registration ID is being misinterpreted because of the “-” between the event ID and the rest of the number. Is there a way to get around that? I assume it comes up elsewhere.

[Mon Nov 10 19:42:28 2014] [error] [client 68.50.209.40] WordPress database error Unknown column ‘54611524c81a1’ in ‘where clause’ for query SELECT * FROM wp_17_events_attendee WHERE registration_id=50-54611524c81a1 /* From [ulmanfund-trispies-com.trispies.staging.wpengine.com/event-registration/] in [/nas/wp/www/staging/trispies/wp-content/uploads/espresso/custom_functions.php:367] */ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, event_espresso_run, event_espresso_add_attendees_to_db, do_action(‘action_hook_espresso_save_attendee_data’), call_user_func_array, espresso_make_additional_relay_teammates_free, referer: http://ulmanfund-trispies-com.trispies.staging.wpengine.com/events/2014-columbia-triathlon-relay/

function espresso_make_additional_relay_teammates_free ($ext_att_data_source) {
    global $wpdb;
    $attendee = $wpdb->get_row('SELECT * FROM ' . EVENTS_ATTENDEE_TABLE . ' WHERE id=' . $ext_att_data_source['attendee_id'], ARRAY_A);
    $teammate = $wpdb->get_row('SELECT * FROM ' . EVENTS_ATTENDEE_TABLE . ' WHERE registration_id=' . $attendee['registration_id'], ARRAY_A);

    
    if ($teammate['is_primary'] != 1) {
        $wpdb->update(EVENTS_ATTENDEE_TABLE,
                array('final_price'=>'0.00'),
                array('id'=>$attendee['id']),
                array('%s'),
                array('%d'));
    }
}
 
add_action('action_hook_espresso_save_attendee_data', 'espresso_make_additional_relay_teammates_free');

$ext_att_data_source['attendee_id'] = $ext_attendee_id;

November 11, 2014 at 12:09 pm

That stopped the MySQL errors, but isn’t changing the price to $0. I’m putting the code in the custom_functions.php file, should I put it someplace else?

November 12, 2014 at 9:24 am

It was the hook. In Sidney’s notes it said the bug was 3.1.36.1.P and while I was on a later version, its not yet 3.1.37.

Thanks, Josh! You guys are awesome. Its really comforting to know that you all are here and have our backs!

Have a great day!