function event_espresso_get_event_details($sql) { //print_r( $_SESSION['event_espresso_sessionid']); //See if the session already exists 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; $member_only = $event->member_only; $externalURL = $event->externalURL; $allow_overflow = $event->allow_overflow; $overflow_event_id = $event->overflow_event_id; $registration_url = $externalURL != '' ? $externalURL : get_option('siteurl') . '/?page_id=' . $event_page_id . '®event_action=register&event_id=' . $event_id . '&name_of_event=' . stripslashes_deep($event_name); 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 { ?> <div id="event_data-<?php echo $event_id; ?> " class="event_data"> <h3 id="event_title-<?php echo $event_id; ?> " class="event_title"><a title="<?php echo stripslashes_deep($event_name); ?> " class="a_event_title" id="a_event_title-<?php echo $event_id; ?> " href="<?php echo get_option('siteurl'); ?> /?page_id=<?php echo $event_page_id; ?> ®event_action=register&event_id=<?php echo $event_id; ?> &name_of_event=<?php echo stripslashes_deep($event_name); ?> "><?php echo stripslashes_deep($event_name); ?> </a></h3> <p id="p_event_price-<?php echo $event_id; ?> "> <?php echo __('Price: ', 'event_espresso') . event_espresso_get_price($event_id); ?> </p> <p id="event_date-<?php echo $event_id; ?> "><?php _e('Start Date:', 'event_espresso'); ?> <?php echo event_date_display($start_date); ?> <br /> <?php _e('End Date:', 'event_espresso'); ?> <?php echo event_date_display($end_date); ?> </p> <p id="event_address-<?php echo $event_id; ?> "><?php _e('Address:', 'event_espresso'); ?> <?php echo $event_address; ?> </p> <?php /* * Display the amount of attendees and/or registration limit Available parameters for the get_number_of_attendees_reg_limit() function * @ $event_id - required * @ $type - * available_spaces = returns the number of available spaces * num_attendees = returns the number of attendees * reg_limit = returns the total number of spaces * num_incomplete = returns the number of incomplete (non paid) registrations * num_completed = returns the number of completed (paid) registrations * num_completed_slash_incomplete = returns the number of completed and incomplete registrations separated by a slash (eg. 3/1) * num_attendees_slash_reg_limit = returns the number of attendees and the registration limit separated by a slash (eg. 4/30) */ $num_attendees = get_number_of_attendees_reg_limit($event_id, 'num_attendees'); //Get the number of attendees if ($num_attendees >= $reg_limit) { ?> <p id="available_spaces-<?php echo $event_id; ?> "><?php _e('Available Spaces:', 'event_espresso'); ?> <?php echo get_number_of_attendees_reg_limit($event_id, 'available_spaces'); ?> </p> <p id="register_link-<?php echo $overflow_event_id; ?> "><a class="a_register_link" id="a_register_link-<?php echo $overflow_event_id; ?> " href="<?php echo get_option('siteurl'); ?> /?page_id=<?php echo $event_page_id; ?> ®event_action=register&event_id=<?php echo $overflow_event_id; ?> &name_of_event=<?php echo stripslashes_deep($event_name); ?> " title="<?php echo stripslashes_deep($event_name); ?> "><?php _e('Join Waiting List', 'event_espresso'); ?> </a></p> </div> <?php } else { ?> <p id="available_spaces-<?php echo $event_id; ?> "><?php _e('Available Spaces:', 'event_espresso'); ?> <?php echo get_number_of_attendees_reg_limit($event_id, 'available_spaces'); ?> </p> <p id="register_link-<?php echo $event_id; ?> "><a class="a_register_link" id="a_register_link-<?php echo $event_id; ?> " href="<?php echo get_option('siteurl'); ?> /?page_id=<?php echo $event_page_id; ?> ®event_action=register&event_id=<?php echo $event_id; ?> &name_of_event=<?php echo stripslashes_deep($event_name); ?> " title="<?php echo stripslashes_deep($event_name); ?> "><?php _e('Register Online', 'event_espresso'); ?> </a></p> <p><?php echo espresso_show_social_media($event_id, 'twitter'); ?> <?php echo espresso_show_social_media($event_id, 'facebook'); ?> </p> </div> <?php } } } //Check to see how many database queries were performed //echo '<p>Database Queries: ' . get_num_queries() .'</p>'; }
function event_espresso_get_event_details($sql) { event_espresso_session_start(); if (!isset($_SESSION['event_espresso_sessionid'])) { $sessionid = mt_rand(100, 999) . time(); $_SESSION['event_espresso_sessionid'] = $sessionid; } 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_name = $wpdb->last_result[0]->category_name; $category_desc = $wpdb->last_result[0]->category_desc; $display_desc = $wpdb->last_result[0]->display_desc; if ($display_desc == 'Y') { echo '<p>' . stripslashes_deep($category_name) . '</p>'; echo '<p>' . wpautop($category_desc) . '</p>'; } 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; $reg_limit = $event->reg_limit; $event_address = $event->address; $member_only = $event->member_only; $externalURL = $event->externalURL; $registration_url = $externalURL != '' ? $externalURL : get_option('siteurl') . '/?page_id=' . $event_page_id . '®event_action=register&event_id=' . $event_id . '&name_of_event=' . stripslashes_deep($event_name); 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 { if ($start_date >= date('Y-m-d') && $registration_start <= date('Y-m-d') && $registration_end >= date('Y-m-d') || $event->event_status == 'O' && $registration_start <= date('Y-m-d')) { ?> <div id="div_event_data-<?php echo $event_id; ?> " class="event_data"> <h3 id="h3_event_title-<?php echo $event_id; ?> " class="event_title"><a id="a_event_title-<?php echo $event_id; ?> " class="a_event_title" href="<?php echo get_option('siteurl'); ?> /?page_id=<?php echo $event_page_id; ?> ®event_action=register&event_id=<?php echo $event_id; ?> &name_of_event=<?php echo stripslashes_deep($event_name); ?> "><?php echo stripslashes_deep($event_name); ?> </a></h3> <p id="p_event_price-<?php echo $event_id; ?> " class="event_price"> <?php echo __('Price: ', 'event_espresso') . event_espresso_get_price($event_id); ?> </p> <p id="p_event_date-<?php echo $event_id; ?> " class="event_date"><?php _e('Date:', 'event_espresso'); ?> <?php echo event_date_display($start_date); ?> </p> <p id="p_event_address-<?php echo $event_id; ?> " class="event_address"><?php _e('Address:', 'event_espresso'); ?> <?php echo $event_address; ?> </p> <p id="p_available_spaces-<?php echo $event_id; ?> " class="available_spaces"><?php _e('Available Spaces:', 'event_espresso'); ?> <?php echo get_number_of_attendees_reg_limit($event_id, 'available_spaces'); ?> </p> <p id="p_register_link-<?php echo $event_id; ?> " class="register_link"> <a id="a_register_link-<?php echo $event_id; ?> " class="a_register_link" href="<?php echo get_option('siteurl'); ?> /?page_id=<?php echo $event_page_id; ?> ®event_action=register&event_id=<?php echo $event_id; ?> &name_of_event=<?php echo stripslashes_deep($event_name); ?> "><?php _e('Register Online', 'event_espresso'); ?> </a> </p> </div> <?php } } } //Check to see how many database queries were performed //echo '<p>Database Queries: ' . get_num_queries() .'</p>'; }