Gregory Janssens

thanks @tribalmike i can, but it was only a stupid thing, the admin has deleted woocommerce pages like “cart”, so it was going back home.

ok, i think i point the problem !

as said in my last comment, if i deactive this function,
the preview url is ?elementor_library=preview

so i suppose that’s where the bug come from.

now need to figure how to fix it !

• This reply was modified 7 years ago by Gregory Janssens.

@anevins that’s how i identify this function to be in case.
but all lines is variables, so if i deactive them, got php error.

If i go to “debug” or “preview” this page, i got a 404. Maybe this info can help ?

• This reply was modified 7 years ago by Gregory Janssens.

Hello @anevins , thank you to take a look to my problem.

the error is the classic Elementor Error, ” Preview Could Not Be Loaded “.

article & pages works well. it’s only on creating/editing templates.

Ok finded !

i give the code for other users ( it use WPML, so if you don’t, juste take of the “AND wp_icl_translations.language_code=’$lang’ ” from the query.

    $startday = date("Y-m-d");
    if ( defined( 'ICL_LANGUAGE_CODE' ) ) {
      $lang = ICL_LANGUAGE_CODE;
    }           
    $results = $wpdb->get_results( "SELECT * FROM wp_posts, <code>wp_mec_dates</code> AS mecd, wp_icl_translations WHERE wp_posts.ID = mecd.post_id and post_status='publish' AND wp_icl_translations.language_code='$lang' AND dstart>'$startday' and  wp_posts.ID = wp_icl_translations.element_id ORDER BY dstart" );
    foreach ($results as $event) {
        echo $event->post_title .'<br />';
    }

and you can display all the infos you need.

Please stop set my thread as resolved anytime you add an answear…

I don’t need to add code to your plugin… and it will be stupid, because anytime you update the plugin, my code will be scratch…. o_O !

also, you don’t seem to understand my question…

i just need to know what is the meta key used to DISPLAY NEXT UPCOMING EVENTS…

i just want a list of next events on my homepage, without any widget.

i already got all info, just need to order them!

my code

<?php
	$args = array(
		'post_type'=> 'mec-events',
		'orderby' => 'start_date',
		'order'    => 'ASC',
	);              

	$the_query = new WP_Query( $args );
	if($the_query->have_posts() ) {
		while ( $the_query->have_posts() ) {
			$the_query->the_post();
?>
	<li>
	<?php
		$image_url = get_the_post_thumbnail_url('','liste-etablissements'); 
		$event_cities = get_field('contact_city',$post->ID);
	?>
	<div class="presta-img-home-events">
		<?php if($image_url[0]) { ?>
			<img src="<?php echo esc_url( $image_url ); ?>" alt="<?php the_title_attribute(); ?>">
		<?php } else { ?>
			<img src="<?php echo get_template_directory_uri() . '/images/placeholder-blog.jpg'; ?>" alt="<?php the_title_attribute(); ?>">
		<?php } ?>
		<div class="presta-img-home-events-overlay"><?php echo $event_date; ?> - <?php if($event_cities) { $cities = 0; $max_cities = 1; foreach($event_cities as $event_city) { $cities++; if($cities > $max_cities) { break; } echo ''. get_the_title( $event_city->ID ) .''; } } ?></div>
	</div>
	<div class="featured-content-wrapper">
		<h3 class="featured-title"> <a title="<?php the_title_attribute(); ?>" href="<?php the_permalink(); ?>"><?php the_title(); ?></a></h3>
		<!--<a href="<?php the_permalink(); ?>" class="single_add_to_wishlist" ><?php esc_html_e('Découvrir','BeProvence'); ?><i class="fa fa-heart"></i></a>-->
	</div><!-- featured content wrapper -->
	</li>
<?php
		}
	}
?>

• This reply was modified 7 years ago by Gregory Janssens.

Hello,

excuse me but this is not CSS or customisation…

this is PHP/MYSQL. I don’t need you to code in my place. Just to share info that will help me develop my tool.

i just need to know ( i have found nothing in documentation ) how i can list upcoming events in a mysql/wp_query.

i tryed with meta_key start_date

but events are not showing by upcoming.

• This reply was modified 7 years ago by Gregory Janssens.