dbTableExist('TABLE_TESTIMONIALS_MANAGER')) { echo '

' . TEXT_HEAD_TESTIMONIALS . '

'; $last_date = $db->Execute("SELECT MAX(GREATEST(t.date_added, IFNULL(t.last_update, '0001-01-01 00:00:00'))) AS last_date FROM " . TABLE_TESTIMONIALS_MANAGER . " t WHERE t.status = '1'"); if ($sitemapXML->SitemapOpen('testimonials', $last_date->fields['last_date'])) { $testimonials = $db->Execute("SELECT t.testimonials_id, GREATEST(t.date_added, IFNULL(t.last_update, '0001-01-01 00:00:00')) AS last_date, t.language_id FROM " . TABLE_TESTIMONIALS_MANAGER . " t WHERE t.status = '1' AND t.language_id IN (" . $sitemapXML->getLanguagesIDs() . ") " . (SITEMAPXML_TESTIMONIALS_ORDERBY != '' ? "ORDER BY " . SITEMAPXML_TESTIMONIALS_ORDERBY : '')); $sitemapXML->SitemapSetMaxItems($testimonials->RecordCount()); while (!$testimonials->EOF) { $sitemapXML->writeItem(FILENAME_TESTIMONIALS_MANAGER, 'testimonials_id=' . $testimonials->fields['testimonials_id'], $testimonials->fields['language_id'], $testimonials->fields['last_date'], SITEMAPXML_TESTIMONIALS_CHANGEFREQ); $testimonials->MoveNext(); } $sitemapXML->SitemapClose(); } } unset($testimonials); // EOF