1, 'post_type' => array('post'), 'order' => 'DESC', 'category' => '34' )); $sitemap = ''."\n"; $sitemap .= ''."\n"; $sitemap .= "\t".''."\n"; $ins_con = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD,DB_NAME); foreach($postsForSitemap as $post) { // on applique des traitements spécifiques à la salle de presse setup_postdata($post); $postdate = explode(" ", $post->post_date); $rfcdate = new DateTime($postdate[0]); $post_date = $rfcdate->format(DateTime::RFC822); $post_date = str_replace('21 00:00:00 +0000','2021 13:00:00 GMT',$post_date); // TRAITEMENT TITRE $sql_post = "SELECT * FROM `wp_ins_posts` WHERE `ID` = ".$post->ID; $query_post = mysqli_query($ins_con,$sql_post); while($data = mysqli_fetch_assoc($query_post)){ $post_title = $data['post_title']; } $post_title = $post_title[0]; $link_post = get_bloginfo('wpurl').'/'.$metaArray['_qts_slug_fr'].'/'.$post->ID; $thumb = get_post_thumbnail_id($post->ID); $img_url = wp_get_attachment_url( $thumb,'full'); // Get img URL $image = aq_resize( $img_url, 820, 432, true ); $image_url_820 = esc_url( $image ); if(empty($image_url_820)){ $image_url_820 = $img_url; } $excerpt = get_the_excerpt($post->ID); $sitemap .= "\t\t\t"."fr-fr". "\n\t\t\t"." ".$post_date." ". "\n\t\t\t"."". "\n\t\t\t"."Salle de presse INSERM". "\n\t\t\t"."https://presse.inserm.fr/". "\n\t\t\t\t"."". "\n\t\t\t\t\t"."". "\n\t\t\t\t\t"."".$excerpt."". "\n\t\t\t\t\t"."".$link_post."". "\n\t\t\t\t\t"."".$link_post."". "\n\t\t\t\t"."". "\n\t\t\t\t"."". "\n\t\t\t\t\t"."". "\n\t\t\t\t\t"."".$image_url_820."". "\n\t\t\t\t\t"."".$image_url_820."". "\n\t\t\t\t"."". "\n\t".""; } $sitemap .= "\n".''; //echo ABSPATH; $fp = fopen(ABSPATH . "rss_actus_last_fr.xml", 'w'); fwrite($fp, $sitemap); fclose($fp); } ?>