Hi, I have a RSS mod for phpbb3, I would like get URL SEO en the RSS.

Can you help me?

Thanks

It depends on the mod you're using to generate the feed, could you post a link to the release thread ?

I use this: http://www.phpbb.com/community/viewtopi ... 0&t=552465

Thanks

Try replacing :

Code: Select all

   $sql_from = 'FROM ' . POSTS_TABLE . ' as p, ' . FORUMS_TABLE . ' as f, ' . USERS_TABLE . ' as u';

with :

Code: Select all

   //$sql_from = 'FROM ' . POSTS_TABLE . ' as p, ' . FORUMS_TABLE . ' as f, ' . USERS_TABLE . ' as u';
   $sql_where = 'AND p.post_id = t.topic_first_post_id';
   $sql_from = 'FROM ' . POSTS_TABLE . ' as p, ' . FORUMS_TABLE . ' as f, ' . USERS_TABLE . ' as u, ' . TOPICS_TABLE . ' as t';

Then :

Code: Select all

$sql = 'SELECT p.poster_id, p.post_subject, p.post_text, p.bbcode_uid, p.bbcode_bitfield, p.topic_id, p.forum_id, p.post_time, f.forum_name, f.forum_desc_options, u.username

with :

Code: Select all

$sql = 'SELECT t.topic_title, t.topic_type, p.poster_id, p.post_subject, p.post_text, p.bbcode_uid, p.bbcode_bitfield, p.topic_id, p.forum_id, p.post_time, f.forum_name, f.forum_desc_options, u.username

And then add :

Code: Select all

   // www.phpBB-SEO.com SEO TOOLKIT BEGIN
   if ( empty($phpbb_seo->seo_url['topic'][$row['topic_id']]) ) {
      if ($row['topic_type'] == POST_GLOBAL) {
         $phpbb_seo->seo_opt['topic_type'][$row['topic_id']] = POST_GLOBAL;
      }
      $phpbb_seo->seo_url['topic'][$row['topic_id']] = $phpbb_seo->format_url(censor_text($row['topic_title']));
   }
   if ( empty($phpbb_seo->seo_url['forum'][$row['forum_id']]) ) {
      $phpbb_seo->seo_url['forum'][$row['forum_id']] = $phpbb_seo->set_url($row['forum_name'],$topic_data['forum_id'], $phpbb_seo->seo_static['forum']);
   }
   // www.phpBB-SEO.com SEO TOOLKIT END

after :

Code: Select all

   ($type != 'atom') ? rss_prepare_message($row['post_text']) : '';

all this in syndication.php, should do the trick for the advanced mod rewrite. It should work right away with the simple mod.

For the mixed mod, adding :

Code: Select all

   // www.phpBB-SEO.com SEO TOOLKIT BEGIN
   if ( empty($phpbb_seo->seo_url['forum'][$row['forum_id']]) ) {
      $phpbb_seo->seo_url['forum'][$row['forum_id']] = $phpbb_seo->set_url($row['forum_name'],$topic_data['forum_id'], $phpbb_seo->seo_static['forum']);
   }
   // www.phpBB-SEO.com SEO TOOLKIT END

after :

Code: Select all

   ($type != 'atom') ? rss_prepare_message($row['post_text']) : '';

Should be enough.

++

Thanks!!!!!!!!!!!!!

I have the advanced mod and it is correct.

Bye

I have updated to phpbb 3.0.3 and now I havent got URL SEO in this RSS :S

Could be because the append_sid calls are made without $phpbb_root_path with 0.4.6 SEO mod rewrites.

Could be time to start using GYM sitemaps, RC2 is about to be released

I use GYM for sitemaps but not for RSS, I havent some problems with RSS. If you can help me with this error in that mod, pleaseee!!!

I have problem with my RSS for some days yet.

Thanks!!

Try this, every time you find :

Code: Select all

append_sid("$board_url

replace it with :

Code: Select all

append_sid("$phpbb_root_path

in syndication.php.

Now I'm curious about the problem you've had with GYM RSS Feeds.

not work :S The title dont show URLs, it havent urls in the RSS :S Ony titles and content :S

PD: Then, I explain the problems what I have with the RSS in GYM

PDD_20 wrote:I use this: http://www.phpbb.com/community/viewtopi ... 0&t=552465

Thanks

Well, have you made sure to do the edit properly, just a matter of replacing $board_url with $phpbb_rot_path in append_sid calls, should do it with the first suggested code.

Yes, I did. I only replace it two times.

Code: Select all

if (!$auth->acl_get('f_list', $row['forum_id']))
   {
      // if the user does not have permissions to list this forum, skip everything until next branch
      continue;
   }

   ($type != 'atom') ? rss_prepare_message($row['post_text']) : '';
    // www.phpBB-SEO.com SEO TOOLKIT BEGIN
   if ( empty($phpbb_seo->seo_url['topic'][$row['topic_id']]) ) {
      if ($row['topic_type'] == POST_GLOBAL) {
         $phpbb_seo->seo_opt['topic_type'][$row['topic_id']] = POST_GLOBAL;
      }
      $phpbb_seo->seo_url['topic'][$row['topic_id']] = $phpbb_seo->format_url(censor_text($row['topic_title']));
   }
   if ( empty($phpbb_seo->seo_url['forum'][$row['forum_id']]) ) {
      $phpbb_seo->seo_url['forum'][$row['forum_id']] = $phpbb_seo->set_url($row['forum_name'],$topic_data['forum_id'], $phpbb_seo->seo_static['forum']);
   }
   // www.phpBB-SEO.com SEO TOOLKIT END

   $template->assign_block_vars('item', array(
      'AUTHOR'      => $row['username'],
      'TIME'         => format_date($row['post_time']),
      'LINK'         => append_sid("$phpbb_root_path/viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&t=' . $row['topic_id']),
      'IDENTIFIER'   => append_sid("$phpbb_root_path/viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&t=' . $row['topic_id']),
      'TITLE'         => $row['post_subject'],
      'TEXT'         => parse_message($row['post_text'], $row['forum_desc_options'], $row['bbcode_uid'], $row['bbcode_bitfield']),      
      )
   );   
}

if ($type == 'atom')

Thanks

The RSS show this:

Code: Select all

<guid>.//viewtopic.php?f=4&amp;t=4458</guid>
         <link>.//viewtopic.php?f=4&amp;t=4458</link>

:S

ho, ok, this must be because your phpBB config is not up to date, make sure you properly filled server domain, script path and cookie domain (while you're at it) in acp.

I saw it but I dont saw strange configuration :S It is correct and all mods work perfect :S