function dpProEventcalendar_column_for_events_list($column_id, $post_id) { global $typenow, $current_user, $wpdb, $dpProEventCalendar, $table_prefix; if ($typenow == 'pec-events') { switch ($column_id) { case 'calendar': $id_calendar = get_post_meta($post_id, 'pec_id_calendar', true); if (isset($id_calendar)) { $cal_list = explode(",", $id_calendar); require_once dirname(__FILE__) . '/../classes/base.class.php'; $calendar = ""; $count = 0; foreach ($cal_list as $key) { $dpProEventCalendar_class = new DpProEventCalendar(true, $key); if ($count > 0) { $calendar .= ' - '; } $calendar .= '<a href="' . admin_url('admin.php?page=dpProEventCalendar-admin&edit=' . $key) . '">' . $dpProEventCalendar_class->getCalendarName() . '</a>'; $count++; } echo $calendar; } break; case 'start_date': $pec_date = get_post_meta($post_id, 'pec_date', true); echo '<abbr title="' . date_i18n(get_option('date_format'), strtotime($pec_date)) . ' ' . date_i18n(get_option('time_format'), strtotime($pec_date)) . '">' . date_i18n(get_option('date_format'), strtotime($pec_date)) . ' ' . date_i18n(get_option('time_format'), strtotime($pec_date)) . '</abbr><br>' . ucfirst(get_post_status($post_id)); break; case 'end_date': $end_time_hh = get_post_meta($post_id, 'pec_end_time_hh', true); $end_time_mm = get_post_meta($post_id, 'pec_end_time_mm', true); if (empty($end_time_hh)) { $end_time_hh = '00'; } if (empty($end_time_mm)) { $end_time_mm = '00'; } $pec_end_date = get_post_meta($post_id, 'pec_end_date', true); $pec_date = $pec_end_date . ' ' . $end_time_hh . ':' . $end_time_mm . ':00'; if ($pec_end_date != "" && $pec_end_date != "0000-00-00") { echo '<abbr title="' . date_i18n(get_option('date_format'), strtotime($pec_date)) . ' ' . ($end_time_hh != "" ? date_i18n(get_option('time_format'), strtotime($pec_date)) : '') . '">' . date_i18n(get_option('date_format'), strtotime($pec_date)) . ' ' . ($end_time_hh != "" ? date_i18n(get_option('time_format'), strtotime($pec_date)) : '') . '</abbr>'; } break; case 'frequency': $frequency = get_post_meta($post_id, 'pec_recurring_frecuency', true); if ($frequency != "" && $frequency > 0) { switch ($frequency) { case 1: echo __('Daily', 'dpProEventCalendar'); break; case 2: echo __('Weekly', 'dpProEventCalendar'); break; case 3: echo __('Monthly', 'dpProEventCalendar'); break; case 4: echo __('Yearly', 'dpProEventCalendar'); break; } } break; case 'bookings': $table_name_booking = $table_prefix . DP_PRO_EVENT_CALENDAR_TABLE_BOOKING; $querystr = "\n\t\t\t\t\tSELECT count(*) as counter\n\t\t\t\t\tFROM " . $table_name_booking . "\n\t\t\t\t\tWHERE id_event = " . $post_id . " AND status <> 'pending'\n\t\t\t\t\t"; $bookings_obj = $wpdb->get_row($querystr, OBJECT); echo '<abbr>' . $bookings_obj->counter . '</abbr>'; break; } } }