List upcoming events until the event end time

[Jonah]

Hi Kelly, it’s displaying everything for that day because those are the next upcoming events… Are you trying to get it so it only shows one upcoming event per day or something like that?

[Kelly]

I’d like the events to roll off the upcoming list once the end time passes. Right now, for example, there is an event today that started at 8:35 and ended at 9:35 that is still on the list and it’s after noon. Had it working before the upgrade with this bit of code…

=&meta_value='. date('Y-m-d G:i:s', current_time('timestamp')));
foreach($myposts as $post) :
setup_postdata($post);
date_default_timezone_set('America/Anchorage');
$event_date_raw = sp_get_end_date( $post->ID, false, "Y-m-d G:i:s" );
$event_date = strtotime($event_date_raw);
$now_raw = date("Y-m-d G:i:s");
$now = strtotime($now_raw);
if ($event_date >= $now) { ?>
<a href="ID) ?>">post_title ?>
ID, false, "F j, g:i a" ); } ?>

[Kelly]

The code bit did not work so well, the entire code can be viewed here…

git://gist.github.com/2771031.git

Initially tried to modify this code to work, but did not see a _EventEndDate entry in the database when the events are recurring.

[Jonah]

Hey Kelly, ok in that query you’re using some old code and I think it just needs to be updated to the following to get it to work: https://gist.github.com/2771150

Does that help/work?

[Kelly]

Here are the results with the code from 2771150…
Brother Francis Pick-up May 27, 12:30 pm
Ladies Group June 9, 10:30 am
Ladies Group July 14, 10:30 am
Ladies Group August 11, 10:30 am
Ladies Group September 8, 10:30 am
—-
Here are the results of the previous code showing all the events for the day…
Eucharistic Exposition T May 22, 12:00 am
Rosary Prayer T May 22, 8:35 am
Tues Mass May 22, 9:00 am
Light Weigh May 22, 9:45 am
—-
Here is what I’m looking for…
Eucharistic Exposition T May 22, 12:00 am
Eucharistic Exposition W May 23, 12:00 am
Rosary Prayer W May 23, 8:35 am
Wed Mass May 23, 9:00 am
Bible Study May 23, 10:00 am

[Kelly]

I really appreciate you hanging in there with me trying to figure this out.

[Jonah]

I’m sorry Kelly but that’s more customization that I can help you with. I’ve already spent a lot of time on this issue and cannot spend more time try to figure out how to get the specific events you want in the widget. You’re going to have to figure it out on your own or hire someone to help you.

Sorry I can’t offer more.

Good luck,
Jonah

[Kelly]

Okay, thanks!

[Rob]

Sorry we couldn’t offer up more here, Kelly. If you need us to refer you a freelancer we’d be happy to do so…and it’s possible someone else on the forum may have a suggestion as well.

Thanks for your patience and best of luck figuring this out. I’ll leave the thread open for now in case any other users want to jump in with their experience.

[Author]

Posts