EE custom_functions.php w/added code

<?php
/*
Function Name: Maximum Date Display
Author: Seth Shoultes
Contact: seth@smartwebutah.com
Website: http://shoultes.net
Description: This function is used in the Events Table Display template file to show events for a maximum number of days in the future
Usage Example:
Requirements: Events Table Display template file
Notes:
*/
function display_event_espresso_date_max($max_days="null"){
    global $wpdb;
    //$org_options = get_option('events_organization_settings');
    //$event_page_id =$org_options['event_page_id'];
    if ($max_days != "null"){
        if ($_REQUEST['show_date_max'] == '1'){
            foreach ($_REQUEST as $k=>$v) $$k=$v;
        }
        $max_days = $max_days;
        $sql  = "SELECT * FROM " . EVENTS_DETAIL_TABLE . " WHERE ADDDATE('".date ( 'Y-m-d' )."', INTERVAL ".$max_days." DAY) >= start_date AND start_date >= '".date ( 'Y-m-d' )."' AND is_active = 'Y' ORDER BY date(start_date)";
        event_espresso_get_event_details($sql);//This function is called from the event_list.php file which should be located in your templates directory.

    }
}

/*
Function Name: Event Status
Author: Seth Shoultes
Contact: seth@eventespresso.com
Website: http://eventespresso.com
Description: This function is used to display the status of an event.
Usage Example: Can be used to display custom status messages in your events.
Requirements:
Notes:
*/
if (!function_exists('espresso_event_status')) {
    function espresso_event_status($event_id){
        $event_status = event_espresso_get_is_active($event_id);

        //These messages can be uesd to display the status of the an event.
        switch ($event_status['status']){
            case 'EXPIRED':
                $event_status_text = __('This event is expired.','event_espresso');
            break;

            case 'ACTIVE':
                $event_status_text = __('This event is active.','event_espresso');
            break;

            case 'NOT_ACTIVE':
                $event_status_text = __('This event is not active.','event_espresso');
            break;

            case 'ONGOING':
                $event_status_text = __('This is an ongoing event.','event_espresso');
            break;

            case 'SECONDARY':
                $event_status_text = __('This is a secondary/waiting list event.','event_espresso');
            break;

        }
        return $event_status_text;
    }
}

/*
Function Name: Custom Event List Builder
Author: Seth Shoultes
Contact: seth@eventespresso.com
Website: http://eventespresso.com
Description: This function creates lists of events using custom templates.
Usage Example: Create a page or widget template to show events.
Requirements: Template files must be stored in your wp-content/uploads/espresso/templates directory
Notes:
*/
if (!function_exists('espresso_list_builder')) {
    function espresso_list_builder($sql, $template_file, $before, $after){

        global $wpdb, $org_options;
        //echo 'This page is located in ' . get_option( 'upload_path' );
        $event_page_id = $org_options['event_page_id'];
        $currency_symbol = $org_options['currency_symbol'];
        $events = $wpdb->get_results($sql);
        $category_id = $wpdb->last_result[0]->id;
        $category_name = $wpdb->last_result[0]->category_name;
        $category_desc = html_entity_decode( wpautop($wpdb->last_result[0]->category_desc) );
        $display_desc = $wpdb->last_result[0]->display_desc;

        if ($display_desc == 'Y'){
            echo '<p id="events_category_name-'. $category_id . '" class="events_category_name">' . stripslashes_deep($category_name) . '</p>';
            echo wpautop($category_desc);
        }

        foreach ($events as $event){
            $event_id = $event->id;
            $event_name = $event->event_name;
            $event_identifier = $event->event_identifier;
            $active = $event->is_active;
            $registration_start = $event->registration_start;
            $registration_end = $event->registration_end;
            $start_date = $event->start_date;
            $end_date = $event->end_date;
            $reg_limit = $event->reg_limit;
            $event_address = $event->address;
            $event_address2 = $event->address2;
            $event_city = $event->city;
            $event_state = $event->state;
            $event_zip = $event->zip;
            $event_country = $event->country;
            $member_only = $event->member_only;
            $externalURL = $event->externalURL;
            $recurrence_id = $event->recurrence_id;

            $allow_overflow = $event->allow_overflow;
            $overflow_event_id = $event->overflow_event_id;

            //Address formatting
            $location = ($event_address != '' ? $event_address :'') . ($event_address2 != '' ? '<br />' . $event_address2 :'') . ($event_city != '' ? '<br />' . $event_city :'') . ($event_state != '' ? ', ' . $event_state :'') . ($event_zip != '' ? '<br />' . $event_zip :'') . ($event_country != '' ? '<br />' . $event_country :'');

            //Google map link creation
            $google_map_link = espresso_google_map_link(array( 'address'=>$event_address, 'city'=>$event_city, 'state'=>$event_state, 'zip'=>$event_zip, 'country'=>$event_country, 'text'=> 'Map and Directions', 'type'=> 'text') );

            //These variables can be used with other the espresso_countdown, espresso_countup, and espresso_duration functions and/or any javascript based functions.
            $start_timestamp = espresso_event_time($event_id, 'start_timestamp', get_option('time_format'));
            $end_timestamp = espresso_event_time($event_id, 'end_timestamp', get_option('time_format'));

            //This can be used in place of the registration link if you are usign the external URL feature
            $registration_url = $externalURL != '' ? $externalURL : get_option('siteurl') . '/?page_id='.$event_page_id.'&regevent_action=register&event_id='. $event_id;

            if (!is_user_logged_in() && get_option('events_members_active') == 'true' && $member_only == 'Y') {
                //Display a message if the user is not logged in.
                 //_e('Member Only Event. Please ','event_espresso') . event_espresso_user_login_link() . '.';
            }else{
    //Serve up the event list
    //As of version 3.0.17 the event lsit details have been moved to event_list_display.php
                echo $before = $before == ''? '' : $before;
                include('templates/'. $template_file);
                echo $after = $after == ''? '' : $after;
            }
        }
    //Check to see how many database queries were performed
    //echo '<p>Database Queries: ' . get_num_queries() .'</p>';
    }
}

//Code to make the link in the confirmation email (paymetn overview) link to the alt. url link instead of the EE event url

function espresso_prepare_event_link_fixed ($payment_data) {
    global $wpdb;
    remove_filter('filter_hook_espresso_prepare_event_link', 'espresso_prepare_event_link');
    $sql = "SELECT  ea.event_id, ed.event_name, ed.externalURL FROM " . EVENTS_ATTENDEE_TABLE . " ea";
    $sql .= " JOIN " . EVENTS_DETAIL_TABLE . " ed ON ed.id=ea.event_id";
    $sql .= " WHERE ea.attendee_session='" . $payment_data['attendee_session'] . "'";
    $events = $wpdb->get_results($sql, OBJECT_K);
    $payment_data['event_link'] = '';
    foreach ($events as $event) {
        if (empty($event->externalURL)) {
            $event_url = espresso_reg_url($event->event_id);
        } else {
            $event_url = $event->externalURL;
        }
        $payment_data['event_link'] .= '<a href="' . $event_url . '">' . $event->event_name . '</a><br />';
    }
    return $payment_data;
}
add_filter('filter_hook_espresso_prepare_event_link', 'espresso_prepare_event_link_fixed', 5);