Where is the [mod]bad speaking removed[/mod] Mod?

Please behave, phpBB SEO is addressed to a general audience and we, the people who spend so much of their free time to provide with all these mods, deserve more respect than that.
You may did not noticed that yesterday two mods where released, and today, two others, how do you expect us to go faster than that ?
Beside, I just checked my bank account, and I could not find you million dollar transfer so ...

Hello dcz, this one is going one of the most used mods, I believe. Do you have any updates on when this is going to be released please?

dcz, please tell as when you will release this mod

You can already use this one : [SEO URL] Similar topic

++

but this isn't your (phpbb-seo crew) mod ?

Noe, but there is a patch to make it work with our Ultimate SEO URL mod in that thread.

So if I have Advanced Seo urls i must uinstall it and install Ultimate ?

or update to Ultimate ?

Goroman wrote:So if I have Advanced Seo urls i must uinstall it and install Ultimate ?

or update to Ultimate ?

Update.

You will find instructions in the contrib folder for updating. If you had the latest release of Advanced than you will need to follow the instructions in "/contrib/0.4.8_0.6.0_Ultimate_Update.txt" and if you were using an older version, the update instructions will be in "/contrib/old/".

Typo

Hello,
I have question about this modification.

I added this on my forum, but without forum link: I added topic and last post link so it looks like:

Code: Select all

<?php
// Begin similar topics
$sql_array = array(
   'SELECT'   => 'forum_id, topic_id, topic_title, topic_type ' . (!empty($phpbb_seo->seo_opt['sql_rewrite']) ? ', topic_url' : '') . ', topic_views, topic_replies, topic_last_post_id, topic_last_post_time',

   'FROM'      => array(
      TOPICS_TABLE   => '',
   ),

   'WHERE'      => "MATCH (topic_title) AGAINST ('" . $db->sql_escape($topic_data['topic_title']) . "' ) >= 0.5
      AND topic_status <> " . ITEM_MOVED . '
      AND topic_id <> ' . (int) $topic_data['topic_id'] . '
    AND forum_id <> 16 AND forum_id <> 47 ',

   'GROUP_BY'   => 'topic_id',
   'ORDER_BY'   => 'topic_last_post_time DESC',
);

$sql = $db->sql_build_query('SELECT', $sql_array);
if ($result = $db->sql_query_limit($sql, 5))
{
   while($similar = $db->sql_fetchrow($result))
   {
    $similar['topic_title'] = censor_text($similar['topic_title']);
    $phpbb_seo->prepare_iurl($similar, 'topic', $similar['topic_type'] == POST_GLOBAL ? $phpbb_seo->seo_static['global_announce'] : $phpbb_seo->seo_url['forum'][$similar['forum_id']]);
   
      $similar_topic_url   = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $similar['topic_id'] . '&amp;f=' . $similar['forum_id']);
      $similar_last_url = $similar_topic_url . '#p' . $similar['topic_last_post_id'];
      $similar_topic_time = $user->format_date($similar['topic_last_post_time']);
      
      $template->assign_block_vars('similar', array(
         'TOPIC_TITLE'      => $similar['topic_title'],
         'U_TOPIC'            => $similar_topic_url,
         'U_LAST'        => $similar_last_url,
         'REPLIES'            => $similar['topic_replies'],
         'VIEWS'               => $similar['topic_views'],
         'POST_DATE'         => $similar_topic_time,
      ));
   }
}
// End Similar Topics
?>

Unfortunately, I have problem: how can I add pagination on last post link?
This code doesn't add pagination information in link:

Code: Select all

      $similar_topic_url   = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $similar['topic_id'] . '&f=' . $similar['forum_id']);

So, links are like:

TOPIC: site_url.com/my-category/my-topic-t500.html
LAST: site_url.com/my-category/my-topic-t500.html#p5123

And should look:

TOPIC: site_url.com/my-category/my-topic-t500.html
LAST: site_url.com/my-category/my-topic-t500-15.html.html#p5123


How can I add pagination with seo class's methods?

To start with, have you had a look at this thread : [SEO URL] Similar topic

?

Then, about changing the last post link to a topic one with pagination, if you know a bit how to code, you could inspire from the way the no dupe mod handle these in viewforum.php.

++

Thank you very much, I copy last post link with pagination from viewforum.php.
I use zero dupe, so I delete unnecessary elements, and it looks like:

Code: Select all

   while($similar = $db->sql_fetchrow($result))
   {
   
    $phpbb_seo->set_url('', $similar['forum_id'], $phpbb_seo->seo_static['forum']);
    $phpbb_seo->prepare_iurl($similar, 'topic', $similar['topic_type'] == POST_GLOBAL ? $phpbb_seo->seo_static['global_announce'] : $phpbb_seo->seo_url['forum'][$similar['forum_id']]);
      $similar_topic_url   = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 't=' . $similar['topic_id'] . '&f=' . $similar['forum_id']);
      $similar_topic_time = $user->format_date($similar['topic_last_post_time']);
      $topic_id = $similar['topic_id'];
      $phpbb_seo->seo_opt['topic_last_page'][$topic_id] = floor($similar['topic_replies'] / $phpbb_seo->seo_opt['topic_per_page']) * $phpbb_seo->seo_opt['topic_per_page'];
      
      $template->assign_block_vars('similar', array(
         'TOPIC_TITLE'      => $similar['topic_title'],
         'U_TOPIC'            => $similar_topic_url,
         'U_LAST'         => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $similar['forum_id']. '&t=' . $similar['topic_id'] . '&start=' . @intval($phpbb_seo->seo_opt['topic_last_page'][$topic_id])) . '#p' . $similar['topic_last_post_id'],
         'REPLIES'            => $similar['topic_replies'],
         'VIEWS'               => $similar['topic_views'],
         'POST_DATE'         => $similar_topic_time,
      ));
   }

phpBB SEO Related Topics has been released, you may want to use it in favor to this mod since it has many more options and abilities than this one.