<?php

// PHPBB 4.0 Sitemap Modification
// Greensboring.com
// Version 4.0 - January 11, 2009


// Enter The Path to Your PHPBB Forum if different then root.
// Example: $path='/forum/';

$path='/';

// Change Nothing Below Here:
// ********************************************************************

$domainpath='http://'.$_SERVER['HTTP_HOST'].$path;

// Connect

define('IN_PHPBB', true);
$phpbb_root_path = './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);

include($phpbb_root_path . 'config.' . $phpEx);
include($phpbb_root_path . 'includes/db/' . $dbms . '.' . $phpEx);

$db = new $sql_db();

$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, false);

// Send initial Data

echo '<?xml version="1.0" encoding="UTF-8"?>'."\n";
echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">'."\n";

// Send Index

echo '<url>
<loc>'.$domainpath.'</loc>
</url>';


// Send Topics

$sql = 'SELECT * FROM '.$table_prefix.'topics WHERE topic_approved=1 ORDER BY topic_id DESC';
$result = $db->sql_query($sql);
while ($data=mysql_fetch_array($result)) {

echo '<url>
<loc>'.$domainpath.'viewtopic.php?f='.$data['forum_id'].'&amp;t='.$data['topic_id'].'</loc>
</url>';

}

// Send Forums

$sql = 'SELECT * FROM '.$table_prefix.'forums WHERE parent_id!=0';
$result = $db->sql_query($sql);
while ($data=mysql_fetch_array($result)) {

echo '<url>
<loc>'.$domainpath.'viewforum.php?f='.$data['forum_id'].'</loc>
</url>';

}


// Send Closing Tags

echo ' </urlset>';


?>