setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e)
{
header("HTTP/1.1 500 Internal Server Error");
echo("");
exit(1);
}
/*
|| Fixed, so that the URLs listed here are byte for byte the ones the pages
|| declare as canonical. Keep in step with siteOrigin() in index.php.
*/
function origin()
{
return "https://cooldisplays.net";
}
/*
|| ldate is stored as a unix timestamp; sitemaps want W3C datetime.
*/
function sitemapDate($ldate)
{
if (!isset($ldate) or $ldate == 0)
return "";
return gmdate("Y-m-d", (int) $ldate);
}
function urlEntry($loc, $lastmod = "", $changefreq = "", $priority = "")
{
echo(" \n");
echo(" " . htmlspecialchars($loc, ENT_XML1, "UTF-8") . "\n");
if (strcmp($lastmod, "") != 0)
echo(" $lastmod\n");
if (strcmp($changefreq, "") != 0)
echo(" $changefreq\n");
if (strcmp($priority, "") != 0)
echo(" $priority\n");
echo(" \n");
}
$base = origin();
echo("\n");
echo("\n");
/*
|| Home and the evergreen content pages.
*/
urlEntry($base . "/", "", "daily", "1.0");
foreach (array("displays", "map", "faq", "about", "terms", "tools") as $page)
urlEntry($base . "/index.php?page=" . $page, "", "monthly", "0.5");
/*
|| One landing page per state. These are the pages that rank for
|| "christmas lights in ", so they get a high priority.
*/
try {
$sql = "select initials from tag where type = 'STATE' order by name";
foreach ($db->query($sql) as $row)
urlEntry($base . "/index.php?page=state&state=" . $row['initials'],
"", "weekly", "0.8");
} catch (PDOException $e)
{
echo(" \n");
}
/*
|| One page per holiday tag.
*/
try {
$sql = "select id from tag where type = 'HOLIDAY' order by name";
foreach ($db->query($sql) as $row)
urlEntry($base . "/index.php?page=displays&tag=" . $row['id'],
"", "weekly", "0.6");
} catch (PDOException $e)
{
echo(" \n");
}
/*
|| Every active display. Inactive displays are deliberately left out: they
|| carry noindex (see SinglePage::robotsMeta), so listing them here would only
|| ask Google to crawl pages we have told it not to index.
*/
try {
$sql = "select displayid, ldate from display "
. "where active = 'Y' order by ldate desc";
foreach ($db->query($sql) as $row)
{
urlEntry($base . "/index.php?page=single&id=" . $row['displayid'],
sitemapDate($row['ldate']), "monthly", "0.7");
}
} catch (PDOException $e)
{
echo(" \n");
}
echo("\n");
?>