CMS Made Simple Forums

Code: Select all

{* sitemap template *}
<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.google.com/schemas/sitemap/0.84
	http://www.google.com/schemas/sitemap/0.84/sitemap.xsd">

{foreach from=$output item='page'}
<url>
  <loc>{$page->url}</loc>
  <lastmod>{$page->date|date_format:"%Y-%m-%d"}</lastmod>
  <priority>{$page->priority}</priority>
  <changefreq>{$page->frequency}</changefreq>
</url>
{/foreach}

{googlexml}

</urlset>

Code: Select all

global $gCms;

$db = &$gCms->db;

function make_alias($string, $isForm=false)
  {
	$string = trim($string);
	$string = preg_replace("/[_-\W]+/", "_", $string);
	$string = trim($string, '_');
	return strtolower($string);
  }



$query = 'SELECT * FROM cms_module_products WHERE status="Published" ';

$result= $db->Execute($query);

while ($row= $result->FetchRow())
{

echo "<url>\r\n";
 echo " <loc>http://www.domainname.org.uk/products/".$row['id']."/49/".make_alias($row['product_name'])."</loc>\r\n";
 echo " <lastmod></lastmod>\r\n";
 echo "<priority>0.7</priority>\r\n";
 echo " <changefreq>weekly</changefreq>\r\n";
echo "</url>\r\n";

}