sitemap_tpl.php

<?php
/**
*
* @package Icy Phoenix
* @version $Id$
* @copyright (c) 2008 Icy Phoenix
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/

define('IN_ICYPHOENIX', true);
if (!defined('IP_ROOT_PATH')) define('IP_ROOT_PATH', './');
if (!defined('PHP_EXT')) define('PHP_EXT', substr(strrchr(__FILE__, '.'), 1));
include(IP_ROOT_PATH . 'common.' . PHP_EXT);

// Start session management
$user->session_begin();
$auth->acl($user->data);
$user->setup();
// End session management

$server_url = create_server_url();

$template->set_filenames(array('body' => 'sitemap_body.tpl'));
$template->assign_vars(array(
	'BOARD_URL' => $server_url
	)
);

//Get a list of publicly viewable forums
//Thanks to Kieran007 for supplying the sql for this
$sql = "SELECT forum_id FROM " . FORUMS_TABLE . " WHERE auth_read = " . AUTH_ALL . " AND forum_type = " . FORUM_POST;
$result = $db->sql_query($sql);
$ids = $db->sql_fetchrowset($result);
$row = 0;
while($row <= sizeof($ids) -1)
{
	$forumids .= $ids[$row]['forum_id'] . ",";
	$row++;
}
$forumids = substr($forumids, 0, strlen($forumids)-1);

if($config['sitemap_sort'] == "ASC")
{
	$order = "DESC";
}
else
{
	$order = "ASC";
}
$sql = "SELECT topic_id FROM " . TOPICS_TABLE . " WHERE forum_id IN (" . $forumids . ") ORDER BY topic_id $order LIMIT 1";
$result = $db->sql_query($sql);
$result = $db->sql_fetchrow($result);
$lastid = $result['topic_id'];

//only get a limited number of topics per query (default 250) to keep server load down in case of large boards
while($lasttopic != $lastid)
{
	$result = "";
	//Newest topics first
	if(is_numeric($lasttopic) && $config['sitemap_sort'] == "ASC")
	{
		$lasttopic++;
		$wheresql = "AND t.topic_id >= $lasttopic";
	}
	//Oldest topics first
	elseif(is_numeric($lasttopic))
	{
		$lasttopic--;
		$wheresql = "AND t.topic_id <= $lasttopic";
	}
	else
	{
		$wheresql = "";
	}
	$sql = "SELECT t.topic_id, t.topic_title, t.topic_type, t.topic_status, p.post_time FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p WHERE t.topic_last_post_id=p.post_id AND t.forum_id IN (" . $forumids . ") $wheresql ORDER BY t.topic_id " . $config['sitemap_sort'] . " LIMIT " . $config['sitemap_topic_limit'];
	$result = $db->sql_query($sql);
	$topics = $db->sql_fetchrowset($result);
	$db->sql_freeresult();
	foreach ($topics as $topic)
	{
		switch ($topic['topic_type'])
		{
			case 2:
				$topic_priority = $config['sitemap_announce_priority'];
			break;
			case 1:
				$topic_priority = $config['sitemap_sticky_priority'];
			break;
			default:
				$topic_priority = $config['sitemap_default_priority'];
		}
		if ($topic['topic_status'] == 1)
		{
			$topic_change = 'never';
		}
		else
		{
			$topic_change = 'always';
		}
		if ( ($config['url_rw'] == '1') || ( ($config['url_rw_guests'] == '1') && ($user->data['user_id'] == ANONYMOUS) ) )
		{
			$url = $server_url. str_replace ('--', '-', make_url_friendly($topic['topic_title']) . '-vt' . $topic['topic_id'] . '.html');
		}
		else
		{
			$url = $server_url . CMS_PAGE_VIEWTOPIC . '?' . POST_TOPIC_URL . '=' . $topic['topic_id'];
		}

		$template->assign_block_vars('topics', array(
			'TOPIC_URL' => $url,
			'TOPIC_TIME' => gmdate('Y-m-d\TH:i:s'.'+00:00', $topic['post_time']),
			'TOPIC_PRIORITY' => $topic_priority,
			'TOPIC_CHANGE' => $topic_change
			)
		);
		$lasttopic = $topic['topic_id'];
	}
}

//Compresss the sitemap with gzip
//this isn't as pretty as the code in page_header.php, but it's simple & it works :)
if(function_exists(ob_gzhandler) && ($config['gzip_compress'] == 1))
{
	ob_start(ob_gzhandler);
}
header("Content-type: text/xml");
$template->pparse('body');

?>