define("OTHER_CHANGEFREQ", "weekly");
define("SITEMAP_CHANGEFREQ", "daily");
# ADD THE HOMEPAGE WITH A SLASH "/"
$s->addItem(SITE_URL, '', HOMEPAGE_CHANGEFREQ, HOMEPAGE_PRIORITY);
#======================== PRODUCTS LINKS=====================
# GETTING PRODUCTS FROM DATABASE
$obDatabase->query = " SELECT distinct vTitle,vSeoTitle,iProdid_PK,tmBuildDate,tmEditDate FROM " . PRODUCTS . " P, " . FUSIONS . " F " . " WHERE (P.iProdid_PK=F.iSubId_FK " . " AND vtype='product' " . " AND iState=1) ORDER BY tmBuildDate";
$prodRows = $obDatabase->fetchQuery();
$prodRowsRecord = $obDatabase->record_count;
#CHECK IF PRODUCT EXISTS
if ($prodRowsRecord > 0) {
#LOOP THROUGH ALL RECORDS
for ($i = 0; $i < $prodRowsRecord; $i++) {
$lastmod = "";
if ($prodRows[$i]->tmEditDate > 0) {
$lastmod = $s->searchEngineDateFormat($prodRows[$i]->tmEditDate);
} else {
$lastmod = $s->searchEngineDateFormat($prodRows[$i]->tmBuildDate);
}
$loc = $libFunc->m_safeUrl(SITE_URL . "ecom/index.php?action=ecom.pdetails&mode=" . $prodRows[$i]->vSeoTitle);
#ADDING DEPARTMENT LINK INTO XML SITEMAP
$s->addItem($loc, $lastmod, PRODUCT_CHANGEFREQ, PRODUCT_PRIORITY);
}
}
#======================== CONTENTS LINKS=====================
# GETTING CONTENTS FROM DATABASE
$obDatabase->query = " SELECT distinct vTitle,vSeoTitle,iContentid_PK,tmBuildDate,tmEditDate FROM " . CONTENTS . " C, " . FUSIONS . " F " . " WHERE (C.iContentid_PK=F.iSubId_FK " . " AND vtype='content' " . " AND iState=1) ORDER BY tmBuildDate";
$contentRows = $obDatabase->fetchQuery();
$contentRowsRecord = $obDatabase->record_count;
#CHECK IF PRODUCT EXISTS
if ($prodRowsRecord > 0) {