Example #1
0
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) {