<?php

// standard hack prevent
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

// standard session management
$userdata = session_pagestart($user_ip, PAGE_SITEMAP);
init_userprefs($userdata);

// set page title
$page_title = 'Sitemap PlatinumW';

// standard page header
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

// assign template
$template->set_filenames(array(
        'body' => 'sitemap.tpl')
);


$template->pparse('body');
?>

<?php
echo "
";
echo "<h2>phpBB Categories</h2>";

$result = mysql_query("SELECT cat_title, cat_id FROM phpbb_categories WHERE cat_id=3 ORDER BY cat_title");
while($row=  mysql_fetch_assoc($result))
{
      echo "<a href='index.php?c=".$row["cat_id"]."'>".$row["cat_title"]."</a><br>";

}

echo "<h2>phpBB Forums</h2>";

$result = mysql_query("SELECT forum_id, forum_name, forum_desc FROM phpbb_forums WHERE `forum_id` = 69 OR `forum_id` = 2 OR `forum_id` = 4 OR `forum_id` = 57 OR `forum_id` = 30 OR `forum_id` = 6 OR `forum_id` = 8 OR `forum_id` = 27 OR `forum_id` = 7 OR `forum_id` = 5 OR `forum_id` = 70 OR `forum_id` = 29 OR `forum_id` = 75  OR `forum_id` = 3  OR `forum_id` = 34 OR `forum_id` = 32 OR `forum_id` = 48 ");
while($row=  mysql_fetch_assoc($result))
{
      echo "<a href='viewforum.php?f=".$row["forum_id"]."'>".$row["forum_name"]."</a><br>";

}
echo "<h2>phpBB Topics</h2>";

$topics_per_page = 500;
$page = (is_numeric($_GET['page']) ? $_GET['page'] : '1');
if(!$page)
    $page = '1';
$end = $page * $topics_per_page;

var_dump($end);
exit;

$res = mysql_query('SELECT `topic_id` FROM `phpbb_topics`');
$no_topics = mysql_num_rows($res);
$max_page = ceil($no_topics/$topics_per_page);
    if($no_topics == 0){
        echo 'No topics!';
        exit;
    }
echo '<br />';
echo ($page > 1 ? '<a href="?page='.($page - 1).'">Back</a> ' : 'Back ') .' '. $page.'/'.$max_page. ($page < $max_page ? ' <a href="?page='.($page+1).'">Next</a>' : ' Next');
echo '<br />';

$result = mysql_query('SELECT `topic_title`, `topic_id` FROM `phpbb_topics` ORDER BY `topic_title` LIMIT '.($end-$topics_per_page).','.$topics_per_page.';') or die(mysql_error());

while($row=mysql_fetch_assoc($result))
{
      echo "<a href='viewtopic.php?t=".$row["topic_id"]."'>".$row["topic_title"]."</a><br>";
}
?>

<?php



include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>