ich habe mit begeisterung diesen Artikel gelesen:
https://www.abakus-internet-marketing.d ... phpbb.html
Natürlich will ich mir auch nicht diese art der Optimierung entgehen lassen. Daher möchte auch ich mich einmal an den den Sitemaps versuchen.
Code: Alles auswählen
<html>
<head></head>
<body>
<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
$sql = "SELECT count(t.topic_id) as total_spider_topics
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f
WHERE f.forum_id = t.forum_id
AND f.auth_view=0";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query count info', '', __LINE__, __FILE__, $sql);
}
if ($countrow = $db->sql_fetchrow($result))
{
$total_spider_topics = $countrow['total_spider_topics'];
}
if( isset($HTTP_GET_VARS['offset']) || isset($HTTP_POST_VARS['offset']) )
{
$offset = ( isset($HTTP_POST_VARS['offset']) ) ? intval($HTTP_POST_VARS['offset']) : intval($HTTP_GET_VARS['offset']);
}
else
{
$offset = 0;
}
$sql = "SELECT t.topic_id, t.topic_title
FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f
WHERE f.forum_id = t.forum_id
AND f.auth_view=0
ORDER BY t.topic_last_post_id DESC
LIMIT $offset, 200";
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query topic info', '', __LINE__, __FILE__, $sql);
}
while( $topicrow = $db->sql_fetchrow($result))
{
echo '<a href="viewtopic.' . $phpEx . '?' . POST_TOPIC_URL . '=' . $topicrow['topic_id'] . '">' . $topicrow['topic_title'] . '</a><br>';
}
$offset = $offset + 200;
if ( ($total_spider_topics - $offset) > 0 )
{
$new_url = '<a href="' . $_SCRIPT_NAME . '?offset=' . $offset . '">Next</a>';
echo $new_url;
}
?>
</body>
</html>
