sitemap.php

См. документацию.

<?php
 
class CSiteMap extends CAllSiteMap
{
    function GetURLs($site_id, $ID, $limit = 0)
    {
        $DB = CDatabase::GetModuleConnection('search');
        $strSql = '
        SELECT
            sc.ID
            ,sc.MODULE_ID
            ,sc.ITEM_ID
            ,sc.TITLE
            ,sc.PARAM1
            ,sc.PARAM2
            ,sc.UPD
            ,sc.DATE_FROM
            ,sc.DATE_TO
            ,L.DIR
            ,L.SERVER_NAME
            ,sc.URL as URL
            ,scsite.URL as SITE_URL
            ,scsite.SITE_ID
            ,' . $DB->DateToCharFunction('sc.DATE_CHANGE') . ' as FULL_DATE_CHANGE
            ,' . $DB->DateToCharFunction('sc.DATE_CHANGE', 'SHORT') . " as DATE_CHANGE
        FROM    b_search_content sc
            INNER JOIN b_search_content_site scsite ON sc.ID=scsite.SEARCH_CONTENT_ID
            INNER JOIN b_lang L ON scsite.SITE_ID=L.LID
            INNER JOIN b_search_content_right scg ON sc.ID=scg.SEARCH_CONTENT_ID
        WHERE
            scg.GROUP_CODE='G2'
            AND scsite.SITE_ID='" . $DB->ForSQL($site_id, 2) . "'
            AND (sc.DATE_FROM is null OR sc.DATE_FROM <= " . $DB->CurrentTimeFunction() . ')
            AND (sc.DATE_TO is null OR sc.DATE_TO >= ' . $DB->CurrentTimeFunction() . ')
            AND sc.ID > ' . intval($ID) . '
        ORDER BY
            sc.ID
        ';
        if (intval($limit) > 0)
        {
            $strSql .= 'LIMIT ' . intval($limit);
        }
        $r = $DB->Query($strSql);
        parent::__construct($r->result);
    }
}