All-in-One Event Calendar
How do we grab events from the database manually? (2 posts)

  1. thatstevensguy
    Posted 3 years ago #

    I love this plugin - but to add to its usefulness on our site, we really need to grab the data for todays events from the database and display them in a ticker along with blog posts. Like the widget achieves, but simpler and to bring the events to attention.

    The idea being that the ticker feed moves along under the banner showing recent blogs and todays/upcoming events in one thing.

    I tried looking into the code and database but couldn't get my head around it... with regular posts you can use the get_posts() argument. If I can do something like that it would be fantastic.


  2. thatstevensguy
    Posted 3 years ago #

    lol, this isn't great but does the trick for the moment until I have time to optimise it. It needs optimisation as it loops through the entire events db multiple times. I need sleep before I improve it.

    ` $wp_events = $wpdb->get_results("SELECT * FROM wp_ai1ec_events");
    $wp_events_instance = $wpdb->get_results("SELECT * FROM wp_ai1ec_event_instances");

    foreach($wp_events as $wp_event) {
    if(date('Ymd') == date('Ymd', strtotime($wp_event->start))) {
    foreach($wp_events_instance as $wp_event_instance) {
    if(date('Ymd') == date('Ymd', strtotime($wp_event_instance->start)) && $wp_event_instance->post_id == $wp_event->post_id) {
    $wp_event_instance_id = $wp_event_instance->id;

    if($wp_event->allday == 1) {
    $wp_event_time_format = '';
    } else {
    $wp_event_time_format = date('@ g:ia', strtotime($wp_event->start));
    $wp_event_time = 'Today ' . $wp_event_time_format;
    $wp_event_link = get_permalink($wp_event->post_id) . $wp_event_instance_id;
    $wp_event_title = get_post_field('post_title', $wp_event->post_id);
    $wp_event_content = wp_news_excerpt(get_post_field('post_content', $wp_event->post_id), 35, "...");
    echo "<li>{$wp_event_time} - <a href=\"{$wp_event_link}\">{$wp_event_title}</a> {$wp_event_content}</li>";

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • All-in-One Event Calendar
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic