1
I recently converted a php library from a chinese developer called PNEWS over to XOOPS for a NNTP reader.
I have been making a Free Usenet site with posting capabilities..
And using xpnews..
a module i wrote..
You can trial
1.2 if you want.. But this is a sitemap you can see and example at
http://www.unseen.org.au/sitemap.php?server_id=1
<?php
require('mainfile.php');
global $xoopsDB;
error_reporting(0);
header('Content-type: text/xml');
$query[0] = "SELECT server_id, name from ".$xoopsDB->prefix('xpnews_servers')." WHERE server_id = '%s' limit 100";
$query[1] = "SELECT id, server_id, newsgroup, posts from ".$xoopsDB->prefix('xpnews_newsgroups')." where server_id = '%s' order by posts limit 4000 ";
?>
<?php
echo "<?xml version="1.0" encoding="UTF-8"?>n"; ?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84">
<url>
<loc>http://<? echo $_SERVER['HTTP_HOST'];?>/</loc>
<lastmod><? echo date('Y-m-d',time());?></lastmod>
<changefreq>daily</changefreq>
<priority>1</priority>
</url>
<?php
$rsTitle = $xoopsDB->query(sprintf($query[0],intval($_GET['server_id']))) or die(mysql_error());
$totalRows_rsTitle = mysql_num_rows($rsTitle);
while ($row = mysql_fetch_assoc($rsTitle)){
?>
<url>
<loc>http://<? echo $_SERVER['HTTP_HOST'];?>/list,<? echo $row['server_id']; ?>,<? echo urlencode($row['name']); ?>.html</loc>
<lastmod><? echo date('Y-m-d',time());?></lastmod>
<changefreq>weekly</changefreq>
<priority>0.9</priority>
</url>
<?php
$rsTitleb = $xoopsDB->query(sprintf($query[1], $row['server_id'])) or die(mysql_error());
$totalRows_rsTitle = mysql_num_rows($rsTitleb);
while ($rowb = mysql_fetch_assoc($rsTitleb)){
for($r=20;$r<($rowb['posts']/20)+20;$r=$r+20){
?>
<url>
<loc>http://<? echo $_SERVER['HTTP_HOST'];?>/indexing,paginated,<? echo $row['server_id']; ?>,<? echo $rowb['newsgroup']; ?>,<? echo $r/20; ?></loc>
<lastmod><? echo date('Y-m-d');?></lastmod>
<changefreq>weekly</changefreq>
<priority>0.7</priority>
</url>
<?php
}
}
}
?>
</urlset>