function display_event_espresso_categories($event_category_id = "null", $css_class = NULL)
{
global $wpdb;
if ($event_category_id != "null") {
$display_recurrence_event = true;
//If set to true, the event page will display recurring events.
$sql = "SELECT e.*, c.category_name, c.category_desc, c.display_desc FROM " . EVENTS_DETAIL_TABLE . " e ";
$sql .= " JOIN " . EVENTS_CATEGORY_REL_TABLE . " r ON r.event_id = e.id ";
$sql .= " JOIN " . EVENTS_CATEGORY_TABLE . " c ON c.id = r.cat_id ";
$sql .= " WHERE c.category_identifier = '" . $event_category_id . "' ";
$sql .= $display_recurrence_event == false ? " AND e.recurrence_id = '0' " : '';
$sql .= " ORDER BY date(start_date), id ASC";
event_espresso_get_event_details($sql, $css_class);
//This function is located below
}
}
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 display_event_espresso_categories($event_category_id = "null")
{
global $wpdb;
if ($event_category_id != "null") {
$sql = "SELECT e.*, c.category_name, c.category_desc, c.display_desc FROM " . EVENTS_DETAIL_TABLE . " e ";
$sql .= " JOIN " . EVENTS_CATEGORY_REL_TABLE . " r ON r.event_id = e.id ";
$sql .= " JOIN " . EVENTS_CATEGORY_TABLE . " c ON c.id = r.cat_id ";
$sql .= " WHERE c.category_identifier = '" . $event_category_id . "' ";
$sql .= " AND is_active = 'Y' ";
$sql .= " AND event_status != 'D' ";
$sql .= " AND event_status != 'S' ";
$sql .= " AND start_date >= '" . date('Y-m-d') . "' ";
$sql .= " AND e.registration_start <= '" . date('Y-m-d') . "' ";
$sql .= " AND e.registration_end >= '" . date('Y-m-d') . "' ";
$sql .= " ORDER BY date(start_date), id ASC";
event_espresso_get_event_details($sql);
}
}
function display_event_espresso_categories($event_category_id = "null")
{
global $wpdb;
if ($event_category_id != "null") {
$sql = "SELECT e.*, c.category_name, c.category_desc, c.display_desc FROM " . EVENTS_DETAIL_TABLE . " e ";
$sql .= " JOIN " . EVENTS_CATEGORY_REL_TABLE . " r ON r.event_id = e.id ";
$sql .= " JOIN " . EVENTS_CATEGORY_TABLE . " c ON c.id = r.cat_id ";
$sql .= " WHERE c.category_identifier = '" . $event_category_id . "' ";
$sql .= " AND is_active = 'Y' ";
$sql .= " AND event_status != 'D' ";
//Removing this line allows you to show events that may have expired
//$sql .= " AND start_date >= '".date ( 'Y-m-d' )."' ";
//These lines are used to show events within a registration start and end period
$sql .= " AND e.registration_start <= '" . date('Y-m-d') . "' ";
$sql .= " AND e.registration_end >= '" . date('Y-m-d') . "' ";
//This line orders the events by date
$sql .= " ORDER BY date(start_date), id ASC";
//This function outputs the event listings
event_espresso_get_event_details($sql);
}
}
function display_event_espresso_categories($event_category_id = "null", $css_class = NULL)
{
global $wpdb;
if ($event_category_id != "null") {
$display_recurrence_event = true;
//If set to true, the event page will display recurring events.
$sql = "SELECT e.*, c.category_name, c.category_desc, c.display_desc, c.category_identifier, ese.start_time, ese.end_time, p.event_cost ";
isset($org_options['use_venue_manager']) && $org_options['use_venue_manager'] == 'Y' ? $sql .= ", v.name venue_name, v.address venue_address, v.city venue_city, v.state venue_state, v.zip venue_zip, v.country venue_country, v.meta venue_meta " : '';
$sql .= " FROM " . EVENTS_DETAIL_TABLE . " e ";
$sql .= " JOIN " . EVENTS_CATEGORY_REL_TABLE . " r ON r.event_id = e.id ";
$sql .= " JOIN " . EVENTS_CATEGORY_TABLE . " c ON c.id = r.cat_id ";
$sql .= " JOIN " . EVENTS_START_END_TABLE . " ese ON ese.event_id= e.id ";
$sql .= " JOIN " . EVENTS_PRICES_TABLE . " p ON p.event_id=e.id ";
isset($org_options['use_venue_manager']) && $org_options['use_venue_manager'] == 'Y' ? $sql .= " LEFT JOIN " . EVENTS_VENUE_REL_TABLE . " r ON r.event_id = e.id LEFT JOIN " . EVENTS_VENUE_TABLE . " v ON v.id = r.venue_id " : '';
$sql .= " WHERE c.category_identifier = '" . $event_category_id . "' ";
$sql .= $display_recurrence_event == false ? " AND e.recurrence_id = '0' " : '';
$sql .= " AND e.event_status != 'D' ";
$sql .= " GROUP BY e.id ORDER BY date(start_date), id ASC";
event_espresso_get_event_details($sql, $css_class);
//This function is located below
}
}
function event_espresso_pagination()
{
do_action('action_hook_espresso_log', __FILE__, __FUNCTION__, '');
event_espresso_require_template('event_list.php');
$_REQUEST['use_wrapper'] = false;
event_espresso_get_event_details($_REQUEST);
die;
}
function display_event_espresso_categories($event_category_id = NULL, $css_class = NULL)
{
event_espresso_get_event_details(array('category_identifier' => $event_category_id, 'css_class' => $css_class));
}
function espresso_venue_event_list_sc($atts)
{
global $wpdb;
global $load_espresso_scripts;
$load_espresso_scripts = true;
//This tells the plugin to load the required scripts
if (empty($atts)) {
return 'No venue id supplied!';
}
extract($atts);
if (isset($id) && $id > 0) {
$atts = array_merge($atts, array('venue_id' => $id, 'use_venue_id' => true));
}
// $order_by = (isset($order_by) && $order_by != '') ? " ORDER BY " . $order_by . " ASC " : " ORDER BY name, id ASC ";
// $limit = $limit > 0 ? " LIMIT 0," . $limit . " " : '';
//
// if (isset($id) && $id > 0) {
// $sql = "SELECT e.*, ev.name venue_name, ese.start_time, ese.end_time, p.event_cost ";
// $sql .= " FROM " . EVENTS_DETAIL_TABLE . " e ";
// $sql .= " LEFT JOIN " . EVENTS_VENUE_REL_TABLE . " vr ON e.id = vr.event_id ";
// $sql .= " LEFT JOIN " . EVENTS_VENUE_TABLE . " ev ON vr.venue_id = ev.id ";
// $sql .= " LEFT JOIN " . EVENTS_START_END_TABLE . " ese ON ese.event_id= e.id ";
// $sql .= " LEFT JOIN " . EVENTS_PRICES_TABLE . " p ON p.event_id=e.id ";
// $sql .= " WHERE e.event_status != 'D' AND e.is_active = 'Y' AND ev.id = '" . $id . "' ";
//
// $sql .= $order_by;
// $sql .= $limit;
// //echo $sql;
//
// $wpdb->get_results($sql);
// $num_rows = $wpdb->num_rows;
// if ($num_rows > 0) {
//
// $name_before = isset($name_before) ? $name_before : '<p class="venue_name">';
// $name_after = isset($name_after) ? $name_after : '</p>';
//
// $venue_name = $wpdb->last_result[0]->venue_name;
//template located in event_list_dsiplay.php
ob_start();
//echo $sql;
//echo $name_before . $venue_name . $name_after;
event_espresso_get_event_details($atts);
$buffer = ob_get_contents();
ob_end_clean();
return $buffer;
//} else {
// return 'No events in this venue';
// }
// }
}
