| |
| |
|
|
|
|
| |
|
| |
|
| :: |
| Author |
Message |
PDD_20
Joined: 23 May 2008
Posts: 27
Location: Spain
|
 Posted: Sat May 31, 2008 3:12 pm Post subject: URL SEO in RSS |
|
|
Hi, I have a RSS mod for phpbb3, I would like get URL SEO en the RSS.
Can you help me?
Thanks |
|
|
| Back to top |
|
 |
|
|
dcz
Administrateur - Site Admin
Joined: 28 Apr 2006
Posts: 14131
|
|
| Back to top |
|
|
PDD_20
Joined: 23 May 2008
Posts: 27
Location: Spain
|
|
| Back to top |
|
|
dcz
Administrateur - Site Admin
Joined: 28 Apr 2006
Posts: 14131
|
| Posted: Mon Jun 02, 2008 4:03 pm Post subject: Re: URL SEO in RSS |
|
|
Try replacing :
| Code: | | $sql_from = 'FROM ' . POSTS_TABLE . ' as p, ' . FORUMS_TABLE . ' as f, ' . USERS_TABLE . ' as u'; |
with :
| Code: | //$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: | | $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: | | $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: | // 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: | | ($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: | // 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: | | ($type != 'atom') ? rss_prepare_message($row['post_text']) : ''; |
Should be enough.
++ |
_________________
Useful links :
SEO Forum || SEO Directory || SEO phpBB || SEO phpBB3 || Search
____________________
Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Référencement phpBB3 || Recherche |
|
| Back to top |
|
|
PDD_20
Joined: 23 May 2008
Posts: 27
Location: Spain
|
| Posted: Mon Jun 02, 2008 4:10 pm Post subject: Re: URL SEO in RSS |
|
|
Thanks!!!!!!!!!!!!!
I have the advanced mod and it is correct.
Bye |
|
|
| Back to top |
|
|
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
