with new version I don't have any error log, but sitemaps still not working, it's work on a small forum but not on my huge one!
this one work for me although
<?php require 'compress_output.php'; ?>
<?php
require_once('SSI.php');
header('Content-Type: text/plain');
echo '<?xml version="1.0" encoding="UTF-8"?' . '>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">';
echo '
<url>
<loc>', $scripturl, '</loc>
<lastmod>', iso_8601_date(time()), '</lastmod>
<changefreq>always</changefreq>
<priority>1.0</priority>
</url>';
$request = db_query("
SELECT b.ID_BOARD, posterTime
FROM {$db_prefix}boards AS b, {$db_prefix}messages
WHERE memberGroups LIKE '%-1%' AND b.ID_LAST_MSG = ID_MSG
ORDER BY posterTime DESC", __FILE__, __LINE__);
while ($row = mysql_fetch_array($request)){
$board_id = $row['ID_BOARD'];
$time = $row['posterTime'];
echo '
<url>
<loc>', $scripturl, '/board,', $board_id, '.0.html</loc>
<lastmod>', iso_8601_date($time), '</lastmod>
<changefreq>always</changefreq>
<priority>1.0</priority>
</url>';
}
mysql_free_result($request);
$request = db_query("
SELECT t.ID_TOPIC, posterTime
FROM {$db_prefix}boards AS b, {$db_prefix}messages, {$db_prefix}topics AS t
WHERE memberGroups LIKE '%-1%' AND t.ID_LAST_MSG = ID_MSG AND b.ID_BOARD = t.ID_BOARD
ORDER BY posterTime DESC
LIMIT 49000", __FILE__, __LINE__);
while ($row = mysql_fetch_array($request)){
$topic_id = $row['ID_TOPIC'];
$time = $row['posterTime'];
echo '
<url>
<loc>', $scripturl, '/topic,', $topic_id, '.0.html</loc>
<lastmod>', iso_8601_date($time), '</lastmod>
</url>';
}
echo '
</urlset>';
function iso_8601_date($int_date) {
$date_mod = date('Y-m-d\TH:i:s', $int_date);
$pre_timezone = date('O', $int_date);
$time_zone = substr($pre_timezone, 0, 3).":".substr($pre_timezone, 3, 2);
$date_mod .= $time_zone;
return $date_mod;
}
?>
News
