CMS Made Simple Forums

Code: Select all

<?php
require_once(dirname(__FILE__)."/include.php");
global $gCms;
$db =$gCms->GetDb();
$dbresult = $db->Execute("SELECT  c.content_id,c.type,c.modified_date,c.show_in_menu FROM ".cms_db_prefix()."content c INNER JOIN ".cms_db_prefix()."content_props p ON p.content_id = c.content_id WHERE (c.content_id = p.content_id AND c.active = 1 AND c.type='content' AND c.show_in_menu =1)");
$out='<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">'."\n";
if ($dbresult)
{
  while ($dbr = $dbresult->FetchRow())
  {
    $d = explode(" ", $dbr['modified_date']);
    $date = $d[0];
    $time = $d[1];
    $datetime = implode("T",$d);
    $out .="<url><loc>".$config['root_url']."/index.php?".$config["query_var"]."=".$dbr['content_id']."</loc><lastmod>".$datetime."+00:00</lastmod><priority>0.5</priority></url>"."\n";
  }
}
$out .="</urlset>";
header("Content-Type: application/xml");
echo $out;
?>