Event Calender のイベントの日時を表示

functions.php に以下を追加。

<?php
if( function_exists( 'ec3_check_installed' ) ) :
  function my_ec3_get_events( $limit = 0 ) {
    if( ! ec3_check_installed( __( 'Upcoming Events', 'ec3' ) ) )
      return;

    global $ec3,$wpdb,$wp_version;

    if ( intval($limit) > 1 )
	  $limit_numposts = 'LIMIT '.intval( $limit );

    $calendar_entries = $wpdb->get_results(
      "SELECT DISTINCT
         p.id AS id,
         post_title,
         start,
         u.$ec3->wp_user_nicename AS author,
         allday
       FROM $ec3->schedule s
       LEFT JOIN $wpdb->posts p ON s.post_id=p.id
       LEFT JOIN $wpdb->users u ON p.post_author = u.id
       WHERE p.post_status='publish'
         AND end>='$ec3->today' $and_before
       ORDER BY start $limit_numposts"
    );

    echo "<ul class=\"ec3_events\">\n";
    if ( $calendar_entries ) {
      $data = array();

      foreach ( $calendar_entries as $entry ) {
        if( $entry->allday )
          $data['TIME'] = __( 'all day', 'ec3' );
        else
          $data['TIME'] = mysql2date( 'Y/m/d(D) H:i〜', $entry->start );

        $data['TITLE'] =
          htmlentities(
            stripslashes( strip_tags( $entry->post_title ) ),
            ENT_QUOTES, get_option( 'blog_charset' )
          );
        $data['LINK']  = get_permalink( $entry->id );
        echo ' <li><span class="start">'.$data['TIME']
        .    '</span><br /><a href="'.$data['LINK'].'">'.$data['TITLE']
        .    "</a></li>\n";
      }
    }
    else {
      echo "<li>".__('No events.','ec3')."</li>\n";
    }
    echo "</ul>\n";
  }
endif;
?>

カレンダーを表示させたいところで
<?php if ( function_exists( 'my_ec3_get_events' ) ) my_ec3_get_events(); ?>

マークアップはお好みで。