Include collection homepage url in sitemap

yurabakhtin · yurabakhtin · commit 5452ab2293ba · 2019-07-04T19:32:30.000+03:00
diff --git a/inc/collections/model/_blog.class.php b/inc/collections/model/_blog.class.php
@@ -5898,6 +5898,47 @@ function get_item_denomination( $position = 'evobar_new' )
 
 		return isset( $denominations[ $position ] ) ? $denominations[ $position ] : '';
 	}
+
+
+	/**
+	 * Get last touched date of content in this collection
+	 *
+	 * @param string Date/Time format: leave empty to use locale default date format, use FALSE to don't format
+	 * @param boolean TRUE if you want GMT
+	 * @return string Last touched date
+	 */
+	function get_last_touched_date( $format = false, $useGM = false )
+	{
+		if( empty( $this->ID ) )
+		{	// Collection must be saved in DB:
+			return false;
+		}
+
+		if( ! isset( $this->last_touched_date ) )
+		{	// Load last touched date from DB:
+			global $DB;
+			$SQL = new SQL( 'Get last touched date for collection #'.$this->ID );
+			$SQL->SELECT( 'cat_last_touched_ts' );
+			$SQL->FROM( 'T_categories' );
+			$SQL->WHERE( 'cat_blog_ID = '.$this->ID );
+			$SQL->ORDER_BY( 'cat_last_touched_ts DESC' );
+			$SQL->LIMIT( '1' );
+			// Store date in cache:
+			$this->last_touched_date = $DB->get_var( $SQL );
+		}
+
+		if( $format === false )
+		{	// Don't format:
+			return $this->last_touched_date;
+		}
+
+		if( empty( $format ) )
+		{	// Use format of current locale:
+			$format = locale_datefmt();
+		}
+
+		return mysql2date( $format, $this->last_touched_date, $useGM );
+	}
 }
 
 ?>
diff --git a/skins/_sitemap/index.main.php b/skins/_sitemap/index.main.php
@@ -25,7 +25,7 @@
 // Filter list:
 $MainList->set_filters( array(
 		'visibility_array' => array( 'published' ),  // We only want to advertised published items
-		'itemtype_usage'   => 'post,page', // keep normal posts & pages BUT STILL EXCLUDE intros and sidebar links
+		'itemtype_usage'   => 'post,page,intro-front,intro-main,intro-cat,intro-tag,intro-sub,intro-all', // keep normal posts, pages and intro-* BUT STILL EXCLUDE all others special(sidebar link, advertisement), content blocks
 	  'unit' => 'all',						// We want to advertise all items (not just a page or a day)
 	  'cat_focus' => $cat_focus,
 	) );
@@ -56,6 +56,12 @@
 ?>
 
 <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
+	<url>
+		<loc><?php echo $Blog->get( 'url' ); ?></loc>
+		<lastmod><?php echo $Blog->get_last_touched_date( 'isoZ', true ); ?></lastmod>
+		<priority>1</priority>
+		<changefreq>daily</changefreq>
+	</url>
 <?php
 while( $Item = & mainlist_get_item() )
 {	// For each blog post, do everything below up to the closing curly brace "}"
