Hello everyone!
\nSo our company is currently use Events Calendar pro. Right now for the custom fields section, I have an option to display the event on the homepage or not. If yes is selected, it gets generated\/added to the plugin we use to display an event carousel called bxSlider. <\/p>\n
Currently, whenever an event ends, I have to manually go in and select no for “Display on homepage”. I was wondering if anyone knew of a way to make it so that it would automatically fall off once the event date & time passes?<\/p>\n
This is the query that we currently have. I was thinking that I would have to add in the “if(strtolower($linkr)==’yes’)” something along the lines of “and if the tribe_get_end_date > today” but I don’t know how to write that part.<\/p>\n
<?php $query_str = “SELECT distinct wposts.ID FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta WHERE wposts.ID = wpostmeta.post_id AND wpostmeta.meta_key = ‘_EventStartDate’ AND wposts.post_type = ‘tribe_events’ ORDER BY wpostmeta.meta_value ASC “;<\/p>\n
$posts = $wpdb->get_results( $query_str );
\n foreach($posts as $post){
\n setup_postdata($post);
\n $id=get_the_ID();
\n $linkr=get_post_meta($id,’_ecp_custom_3′,true);
\n if (strtolower($linkr)==’yes’) {
\n $link=get_permalink($id);
\n echo “”;
\n}
\n}
\n?><\/p>\n
Website: http:\/\/www.lightgroup.com<\/p>\n","protected":false},"template":"","class_list":["post-396438","topic","type-topic","status-closed","hentry"],"yoast_head":"\n