get_results($wpdb->prepare("SELECT e.*, ev.id as venue_id
FROM " . EVENTS_DETAIL_TABLE . " e
LEFT JOIN " . EVENTS_VENUE_REL_TABLE . " vr ON e.id = vr.event_id
LEFT JOIN " . EVENTS_VENUE_TABLE . " ev ON vr.venue_id = ev.id
WHERE e.id = %d", $event_id));
if (!is_array($events) || count($events) <= 0) {
event_espresso_edit_list();
#echo "
";
#_e("Event is not available any more!","eventespresso");
#echo "
";
return 1;
}
foreach ($events as $event) {
$event_id = $event->id;
$event_name = stripslashes_deep($event->event_name);
$event_desc = stripslashes_deep($event->event_desc);
$display_desc = $event->display_desc;
$display_reg_form = $event->display_reg_form;
$member_only = $event->member_only;
$phone = stripslashes_deep($event->phone);
$externalURL = stripslashes_deep($event->externalURL);
//Early discounts
$early_disc = stripslashes_deep($event->early_disc);
$early_disc_date = stripslashes_deep($event->early_disc_date);
$early_disc_percentage = stripslashes_deep($event->early_disc_percentage);
$post_id = $event->post_id;
$post_type = $event->post_type;
$event_identifier = stripslashes_deep($event->event_identifier);
$registration_start = $event->registration_start;
$registration_end = $event->registration_end;
$registration_startT = $event->registration_startT;
$resitration_endT = $event->registration_endT;
$timezone_string = $event->timezone_string;
$start_date = $event->start_date;
$end_date = $event->end_date;
$tax_percentage = $event->tax_percentage;
$tax_mode = $event->tax_mode;
$start_time = isset($event->start_time) ? $event->start_time : '';
$end_time = isset($event->end_time) ? $event->end_time : '';
$reg_limit = $event->reg_limit;
$additional_limit = $event->additional_limit;
$allow_overflow = $event->allow_overflow;
$overflow_event_id = $event->overflow_event_id;
$allow_multiple = $event->allow_multiple;
$event_cost = unserialize(isset($event->event_cost) ? $event->event_cost : '');
$is_active = $event->is_active;
$status = array();
$status = event_espresso_get_is_active($event_id);
$event_status = $event->event_status;
$conf_mail = stripslashes_deep($event->conf_mail);
$send_mail = stripslashes_deep($event->send_mail);
$use_coupon_code = $event->use_coupon_code;
if (function_exists('event_espresso_edit_event_groupon')) {
$use_groupon_code = $event->use_groupon_code;
}
$alt_email = $event->alt_email;
$address = stripslashes_deep($event->address);
$address2 = stripslashes_deep($event->address2);
$city = stripslashes_deep($event->city);
$state = stripslashes_deep($event->state);
$zip = stripslashes_deep($event->zip);
$country = stripslashes_deep($event->country);
$venue_id = stripslashes_deep($event->venue_id);
$venue_title = stripslashes_deep($event->venue_title);
$venue_url = stripslashes_deep($event->venue_url);
$venue_phone = stripslashes_deep($event->venue_phone);
$venue_image = stripslashes_deep($event->venue_image);
$email_id = $event->email_id;
$ticket_id = $event->ticket_id;
$wp_user = $event->wp_user;
//echo 'date_submitted = '.$event->submitted;
$date_submitted = $event->submitted != '0000-00-00 00:00:00' ? (empty($event->submitted) ? '' : event_date_display($event->submitted, get_option('date_format')) ) : 'N/A';
$google_map_link = espresso_google_map_link(array('address' => $address, 'city' => $city, 'state' => $state, 'zip' => $zip, 'country' => $country));
//Virtual location
$virtual_url = stripslashes_deep($event->virtual_url);
$virtual_phone = stripslashes_deep($event->virtual_phone);
$question_groups = unserialize($event->question_groups);
$event_meta = unserialize($event->event_meta);
$recurrence_id = $event->recurrence_id;
$visible_on = $event->visible_on;
$require_pre_approval = $event->require_pre_approval;
}
$values = array(
array('id' => 'Y', 'text' => __('Yes', 'event_espresso')),
array('id' => 'N', 'text' => __('No', 'event_espresso')));
//If user is an event manager, then show only their events
if (function_exists('espresso_is_my_event') && espresso_is_my_event($event_id) != true) {
echo '' . __('Sorry, you do not have permission to edit this event.', 'event_espresso') . ' ';
return;
}
?>
' . __('Attendees', 'event_espresso') . ''; ?>:
' . espresso_user_meta($wp_user, 'user_nicename') . ')' : espresso_user_meta($wp_user, 'display_name') . ' (
' . espresso_user_meta($wp_user, 'user_nicename') . ' )';
$user_company = espresso_user_meta($wp_user, 'company') != '' ? espresso_user_meta($wp_user, 'company') : '';
$user_organization = espresso_user_meta($wp_user, 'organization') != '' ? espresso_user_meta($wp_user, 'organization') : '';
$user_co_org = $user_company != '' ? $user_company : $user_organization;
echo '
';
echo '
';
echo '' . __('Submitted By:', 'event_espresso') . ' ' . $user_name . ' ';
echo '' . __('Email:', 'event_espresso') . ' ' . espresso_user_meta($wp_user, 'user_email') . ' ';
echo $user_co_org != '' ? '' . __('Organization:', 'event_espresso') . ' ' . espresso_user_meta($wp_user, 'company') . ' ' : '';
echo '' . __('Date Submitted:', 'event_espresso') . ' ' . $date_submitted . ' ';
echo ' ';
echo '
';
}
?>
'A', 'text' => __('Active', 'event_espresso')), array('id' => 'D', 'text' => __('Deleted', 'event_espresso')));
$advanced_options = '' . __('Advanced Options:', 'event_espresso') . '
'
. '' . __('Is this an active event? ', 'event_espresso') . ' ' . __(select_input('is_active', $values, $is_active)) . '
'
. '' . __('Display description? ', 'event_espresso') . ' ' . select_input('display_desc', $values, $display_desc) . '
'
. '' . __('Display registration form? ', 'event_espresso') . ' ' . select_input('display_reg_form', $values, $display_reg_form) . '
';
}//Display Lite version options - End
postbox('event-status', 'Event Options', '' . __('Attendee Limit', 'event_espresso') . ': ' .
'(' . __('leave blank for unlimited', 'event_espresso') . ')
' .
'' . __('Allow group registrations?', 'event_espresso') . ' ' . select_input('allow_multiple', $values, $allow_multiple) . '
' .
'' . __('Max Group Registrants', 'event_espresso') . ': ' . '
' .
$advanced_options
);
if (function_exists('espresso_ticket_dd') && $espresso_premium == true) {
?>
get_row("select * from " . EVENTS_SEATING_CHART_EVENT_TABLE . " where event_id = $event_id");
if ($seating_chart_event !== NULL) {
$seating_chart_id = $seating_chart_event->seating_chart_id;
}
?>
>None
get_results("select * from " . EVENTS_SEATING_CHART_TABLE . " order by name");
foreach ($seating_charts as $seating_chart) {
?>
id) {
echo 'selected="selected"';
} ?> >name; ?>
'1', 'text' => __('Yes', 'event_espresso')), array('id' => '0', 'text' => __('No', 'event_espresso')));
echo select_input("require_pre_approval", $pre_approval_values, $require_pre_approval);
?>
5, "textarea_name" => "event_desc", "editor_class" => "my_editor_custom");
wp_editor(espresso_admin_format_content($event_desc), "event_desc", $args);
} else {
/*
This is the editor used by WordPress. It is very very hard to find documentation for this thing, so I pasted everything I could find below.
param: string $content Textarea content.
param: string $id Optional, default is 'content'. HTML ID attribute value.
param: string $prev_id Optional, default is 'title'. HTML ID name for switching back and forth between visual editors.
param: bool $media_buttons Optional, default is true. Whether to display media buttons.
param: int $tab_index Optional, default is 2. Tabindex for textarea element.
*/
//the_editor($content, $id = 'content', $prev_id = 'title', $media_buttons = true, $tab_index = 2)
//the_editor(espresso_admin_format_content($event_desc), $id = 'event_desc'/* , $prev_id = 'title', $media_buttons = true, $tab_index = 3 */);
the_editor(espresso_admin_format_content($event_desc), $id = 'event_desc'/* , $prev_id = 'title', $media_buttons = true, $tab_index = 3 */);
}
?>