require_once('Include/system.inc');
$strTitle = "$cfgCompany Sitemap";
?>
ob_start();
$xml = new DOMDocument("1.0", "UTF-8");
$urlset = $xml->appendChild($xml->createElementNS("http://www.sitemaps.org/schemas/sitemap/0.9", "urlset"));
?>
=$strTitle?> | XML
$parent_articles = mysql_query("select * from articles where strArticleUrl regexp '^[^\/]+(\/|\.html)?\$' and find_in_set('horizontal', setIncludeInMenu) order by strArticleName");
while($parent_article = mysql_fetch_assoc($parent_articles))
{
echo "
";
$url = $urlset->appendChild($xml->createElement("url"));
$url->appendChild($xml->createElement("loc", PATH_CLIENT_MAIN . "/{$parent_article[strArticleUrl]}"));
$child_articles = mysql_query("select * from articles where strArticleUrl regexp '{$parent_article[strArticleUrl]}.+' and find_in_set('horizontal', setIncludeInMenu) order by strArticleName");
if(mysql_num_rows($child_articles))
{
echo "
";
while($child_article = mysql_fetch_assoc($child_articles))
{
echo "- ";
echo "{$child_article[strArticleName]}";
$url = $urlset->appendChild($xml->createElement("url"));
$url->appendChild($xml->createElement("loc", PATH_CLIENT_MAIN . "/{$child_article[strArticleUrl]}"));
echo "
";
}
echo "
";
}
}
?>
$pages = array(
"about.html" => "About",
"contact.html" => "Contact",
"privacy.html" => "Privacy Policy"
);
foreach($pages as $path=>$name)
{
?>
- =$name?>
$url = $urlset->appendChild($xml->createElement("url"));
$url->appendChild($xml->createElement("loc", PATH_CLIENT_MAIN . "/$path"));
}
?>
$stories = mysql_query("select * from news where datePublished < now() order by datePublished desc");
if(mysql_num_rows($stories)) {
?>
$url = $urlset->appendChild($xml->createElement("url"));
$url->appendChild($xml->createElement("loc", PATH_CLIENT_MAIN . "/news/"));
while($story = mysql_fetch_assoc($stories))
{
?>
- =$story[strArticleTitle]?>
}
?>
}
?>
$url = $urlset->appendChild($xml->createElement("url"));
$url->appendChild($xml->createElement("loc", PATH_CLIENT_MAIN . "/calculators/"));
$pages = array(
"affordability.html" => "Mortgage Calculator",
"comprehensivemortgage.html" => "Comprehensive Mortgage Calculator",
"carbuyorlease.html" => "Car: Buy vs Lease",
"mortgage.html" => "Mortgage Affordability Calculator",
"rentorbuy.html" => "Rent vs Buy Calculator"
);
foreach($pages as $path=>$name)
{
?>
- =$name?>
$url = $urlset->appendChild($xml->createElement("url"));
$url->appendChild($xml->createElement("loc", PATH_CLIENT_MAIN . "/calculators/$path"));
}
?>
$url = $urlset->appendChild($xml->createElement("url"));
$url->appendChild($xml->createElement("loc", PATH_CLIENT_MAIN . "/guide/"));
$guides = mysql_query("select * from articles where find_in_set('guide', setIncludeInMenu) order by strArticleName");
while($guide = mysql_fetch_assoc($guides))
{
?>
- =$guide[strArticleName]?>
}
?>
$url = $urlset->appendChild($xml->createElement("url"));
$url->appendChild($xml->createElement("loc", PATH_CLIENT_MAIN . "/poll.html"));
$pages = array(
"poll.html" => "Weekly Poll",
"pollarchive.html" => "Poll Archive"
);
foreach($pages as $path=>$name)
{
?>
- =$name?>
$url = $urlset->appendChild($xml->createElement("url"));
$url->appendChild($xml->createElement("loc", PATH_CLIENT_MAIN . "/$path"));
}
?>
if($_REQUEST[o] == 'xml')
{
ob_end_clean();
header("Content-type: text/xml", true);
echo $xml->saveXML();
exit;
}
else
{
$content = ob_get_clean();
include('Include/header.inc');
echo $content;
include('Include/footer.inc');
}
?>