-1, 'category__in' => array(794,817,812,806), 'orderby' => 'post_date', 'post_type' => array('post'), 'order' => 'DESC', 'post_status' => 'publish' )); $sitemap = ''."\n"; $sitemap .= ''."\n"; global $wpdb, $post; foreach($postsForSitemap as $post) { setup_postdata($post); $post_id = $post->ID; $postDate = $post->post_date; $postContent = htmlspecialchars($post->post_excerpt); $postName = htmlspecialchars($post->post_name); $posttitle = htmlspecialchars($post->post_title); $postURL = get_permalink( $post->ID ); $postAuthor = get_the_author(); $postCategories = get_the_category($post_id); $reviewScore = $wpdb->query( $wpdb->prepare( "SELECT review FROM tableName_gdsr_data_article WHERE post_id = '$post_id'" ) ); $reviewMaxScore = 5; $omdomePros = get_post_meta($post->ID, 'omdome_pros', true); $omdomePros = str_replace('
', ',', $omdomePros); $omdomePros = str_replace(' ', '', $omdomePros); $omdomePros = strip_tags($omdomePros); $omdomeProsArray = explode(',', $omdomePros); $omdomeCons = get_post_meta($post->ID, 'omdome_cons', true); $omdomeCons = str_replace('
', ',', $omdomeCons); $omdomeCons = str_replace(' ', '', $omdomeCons); $omdomeCons = strip_tags($omdomeCons); $omdomeConsArray = explode(',', $omdomeCons); $productName = get_post_meta($post->ID, 'pricerunner_productName', true); $productCat = get_post_meta($post->ID, 'pricerunner_productCatID', true); $gameFormat = get_post_meta($post->ID, 'gameDetails_format', true); $gameGenre = get_post_meta($post->ID, 'gameDetails_genre', true); $gameDeveloper = get_post_meta($post->ID, 'gameDetails_utvecklare', true); $gameDistributor = get_post_meta($post->ID, 'gameDetails_utgivare', true); $gamePlayers = get_post_meta($post->ID, 'gameDetails_antalSpelare', true); $sitemap .= ''."\n". "\t".''. $postURL .''."\n". "\t".''."\n". "\t".''. $postDate .''."\n". "\t".''. $postAuthor .''."\n". "\t".'

'. $postContent .'

'."\n". "\t".''. $reviewScore .''."\n". "\t".''. $reviewMaxScore .''."\n"; if ($postCategories) { foreach($postCategories as $postCategory) { $catcat = $postCategory->cat_name; // If the parent category is Teknik if($catcat == "Teknik") { $sitemap .= "\t".''. $productName .''."\n"; $sitemap .= "\t".''. $productCat .''."\n"; if($omdomeProsArray) { foreach($omdomeProsArray as $prosArray) { $sitemap .= "\t".''.$prosArray.''."\n"; } } if($omdomeConsArray) { foreach($omdomeConsArray as $consArray) { $sitemap .= "\t".''.$consArray.''."\n"; } } } // If the parent category is Spel if($catcat == "Spel") { if($omdomeProsArray) { foreach($omdomeProsArray as $prosArray) { $sitemap .= "\t".''.$prosArray.''."\n"; } } if($omdomeConsArray) { foreach($omdomeConsArray as $consArray) { $sitemap .= "\t".''.$consArray.''."\n"; } } $sitemap .= "\t".''. $gameFormat .''."\n"; $sitemap .= "\t".''. $gameGenre .''."\n"; $sitemap .= "\t".''. $gameDeveloper .''."\n"; $sitemap .= "\t".''. $gameDistributor .''."\n"; $sitemap .= "\t".''. $gamePlayers .''."\n"; } } } if ($postCategories) { foreach($postCategories as $postCategory) { $sitemap .= "\t".''.$postCategory->cat_name.''."\n"; } } $sitemap .=''."\n"; } $sitemap .= ''; $fp = fopen(ABSPATH . "reviews.xml", 'w'); fwrite($fp, $sitemap); fclose($fp); } ?>