Ich nutze folgendes Skript (angepasst für Larsneo URL Rewriting)
Es ist noch ein kleiner Bug in Verbindung mit der Session-ID. Da aber Gästee keine Session-ID bekommen, ist das unkritisch. War bisher zu faul, das auszumerzen.
Mit dem unten stehenden Skript kommt genau das raus, was Du haben möchtest.
Code: Alles auswählen
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
/***************************************************************************
* Save this file as: sitemap.php (or anything you like)
* Version: Friday, Oct 4, 2002
* Email: angus@phphacks.com
* Purpose of hack: Basically generates a list of topics and
* displays them with link to the topic. Goal
* is to provide search engines like Google
* with a static page of links to dynamic pages
* You should link to this page from your sites
* home page somewhere.
* Demo: http://www.aussiecelebs.com/forums/site_map.php
* Tested on: phpBB 2.01, 2.02
*
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/
?>
<?php
echo "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">
<!-- Start Header -->
<html>
<head>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=ISO-8859-1\">
<title>Sitemap for domain.tld</title>
<meta name=\"robots\" content=\"index,follow\">
<META NAME=\"robots\" CONTENT=\"NOARCHIVE\">
<meta name=\"description\" content=\"This is the sitemap for the domain.tld\">
<base target=\"_top\">
<link rel=stylesheet type=\"text/css\" href=\"http://www.domain.tld/forum/sitemap.css\">
</head>
<!-- End Header -->
<!-- Start Body -->
<body>
<h1>Site Map for <a href=\"http://www.domain.tld/forum/index.html\">yourforum</a></h1>
";
$sql = "SELECT t.topic_id FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p, " . FORUMS_TABLE . " AS f
WHERE
t.forum_id = f.forum_id AND f.auth_view = " . AUTH_ALL . " AND p.topic_id = t.topic_id AND p.post_id = t.topic_last_post_id ORDER BY p.post_time DESC";
$topicscount_query = $db->sql_query($sql);
$row_count = $db->sql_numrows($topicscount_query);
$max_count = $row_count/50;
if($HTTP_GET_VARS[next]>0 && $HTTP_GET_VARS[next]<=$max_count) {
$next = $HTTP_GET_VARS[next];
}else {
$next=0;
}
// SQL statement to fetch active topics of public forums
$sql = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id
FROM " . TOPICS_TABLE . " AS t, " . POSTS_TABLE . " AS p, " . FORUMS_TABLE . " AS f
WHERE
t.forum_id = f.forum_id
AND f.auth_view = " . AUTH_ALL . "
AND p.topic_id = t.topic_id
AND p.post_id = t.topic_last_post_id
ORDER BY p.post_time DESC LIMIT ".($next*50).",50";
$topics_query = $db->sql_query($sql);
if ( !$topics_query )
{
message_die(GENERAL_ERROR, "Could not query list of active topics", "", __LINE__, __FILE__, $sql);
}
else if ( !$db->sql_numrows($topics_query) )
{
message_die(GENERAL_MESSAGE, $lang['No_match']);
}
else
{
while ($topic = $db->sql_fetchrow($topics_query))
{
echo "<a href=\""."http://www.domain.tld/forum/ftopic".$topic['topic_id'].".html"."\">".$topic["topic_title"]."</a><br>\n";
}
}
echo "
<BR><BR>
[
";
for($ii=0; $ii<$max_count; $ii++) {
if($ii+1<$max_count) {
if($ii==$next) {
echo("<A> ".($ii+1)." |</A>");
}else{
echo("<A HREF=\""."sitemap".($ii).".html\"> ".($ii+1)." |</A>");
}
}else{
if($ii==$next) {
echo("<A> ".($ii+1)." </A>");
}else{
echo("<A HREF='" . append_sid("sitemap".($ii)).".html'> ".($ii+1)." </A>");
}
}
}
echo "
]
<!-- Start footer here. -->
<p>
<span style=\"font-size:small\">back to <a href=\"http://www.domain.tld\">domain.tld</a></span>
</body>
</html>
<!-- End footer -->
";
?>
Code: Alles auswählen
# Forum Sitemap
RewriteRule ^forum/sitemap([0-9][0-9]*).html forum/sitemap.php?next=$1 [L]
, "string emil", "nu pagadi forum" und eine ganze menge (ca. 1500) andere unrelevante besucher pro tag.
