[2.0.6] RSS Content Syndicator

benchfrooser · Post by **benchfrooser** » Fri Jan 05, 2007 3:17 pm

@tals:

Then I get this code? right?

$forum_id = ( isset($_GET['f']) ) ? htmlspecialchars($_GET['f']) : '';
$sql_forum_where = ( !empty($forum_id) ) ? ' AND f.forum_id IN (' .  forum_id . ')': ' ';

But i get this error.

Code: Select all

Could not query list of active posts

DEBUG MODE

SQL Error : 1052 Column: 'forum_id' in where clause is ambiguous

SELECT f.forum_name, t.topic_title, u.user_id, u.username, u.user_sig, u.user_sig_bbcode_uid, p.post_id, pt.post_text, pt.post_subject, pt.bbcode_uid, p.post_time, t.topic_replies, t.topic_first_post_id FROM phpbb_rdv_forums AS f, phpbb_rdv_topics AS t, phpbb_rdv_users AS u, phpbb_rdv_posts AS p, phpbb_rdv_posts_text as pt WHERE t.forum_id = f.forum_id AND f.auth_view = 0 AND p.poster_id = u.user_id AND pt.post_id = p.post_id AND p.topic_id = t.topic_id AND p.post_id = t.topic_first_post_id AND f.forum_id IN (forum_id) ORDER BY p.post_time DESC LIMIT 15

Line : 164
File : rss.php

green ticks · Post by **green ticks** » Sun Jan 07, 2007 8:45 pm

So wat this mod does, is looks at the last post made in each category..? Cuz thats wat it seems like.. or does it look at my last topics... i havea mod that shows the 10 last topics... but I dont think its showing those..more liek the last post made in each category right?

adrien · Post by **adrien** » Thu Jan 11, 2007 9:50 am

hi,
i would really like to install this mod, but as phpbb 3.0 is almost out i would not like to be caught with my pants down: are there plans to port this mod to olympus in a way that the release of the two is coordinated?

adrien

N!cklas · Post by **N!cklas** » Mon Jan 15, 2007 9:30 am

Regarding security issue mentioned here. I've tried the new code and it seems to work.

The issue is that without changing the code, posts in private forums can be read via RSS but not on the forum.

Dello · Post by **Dello** » Thu Jan 18, 2007 2:12 am

I use the the RSS Content Syndicator to put the most recent posts of the forum onto the homepage of my website and like it very much.

I also use Spamwords ( http://www.phpbb.com/phpBB/viewtopic.php?t=354376 ) which hides posts until they are approved.

I have noticed that even when Spamwords is hiding a post, that post will still be syndicated onto the homepage with the RSS Content Syndicator.

Is there a fix for this in RSS Content Syndicator?

Thanks!

Cardcaptor Stacey · Post by **Cardcaptor Stacey** » Sat Jan 20, 2007 7:16 pm

Love the mod... but what do I need to change to just have one forum (3) to show with only the original post?

Cardcaptor Stacey · Post by **Cardcaptor Stacey** » Sat Jan 20, 2007 7:16 pm

Self moderated

danx · Post by **danx** » Mon Jan 22, 2007 11:49 pm

RSS icon mod addition

Alluded to above, but not stated, is how to add a RSS (or XML) icon so people know you have this feature. You can COPY (but NOT link

) my rss.png icon file for this (and see a demo of it in action) at
http://www.yosemite.ca.us/forum/

Here's the mod revison:

Code: Select all

#
#-----[ COPY ]------------------------------------------
#
copy rss.png to templates/subSilver/images/rss.png
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/overall_header.tpl
#
#-----[ FIND ]------------------------------------------
#
# NOTE - This is a partial match, the whole line on a fresh phpBB installation looks like this:
#
# <a href="{U_FAQ}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_faq.png" width="12" height="13" border="0" alt="{L_FAQ}" hspace="3" />{L_FAQ}</a>&nbsp; &nbsp;<a href="{U_SEARCH}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_search.png" width="12" height="13" border="0" alt="{L_SEARCH}" hspace="3" />{L_SEARCH}</a>&nbsp; &nbsp;<a href="{U_MEMBERLIST}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_members.png" width="12" height="13" border="0" alt="{L_MEMBERLIST}" hspace="3" />{L_MEMBERLIST}</a>&nbsp; &nbsp;<a href="{U_GROUP_CP}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_groups.png" width="12" height="13" border="0" alt="{L_USERGROUPS}" hspace="3" />{L_USERGROUPS}</a>&nbsp;
#
#
{L_FAQ}
#
#-----[ IN-LINE FIND ]------------------------------------------ #
&nbsp;
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------
#
 <a href="rss.php" type="application/rss+xml"><img src="templates/subSilver/images/rss.png" alt="RSS feed for phpBB" width="36" height="14" border="0" /></a> &nbsp;
#

RSS icon fix
If you want one of those nifty RSS icons in the address bar, add this to files templates/subSilver/overall_header.tpl and simple_header.tpl, after the <title> tag:
<link rel="alternate" type="application/rss+xml"
title="RSS" href="http://www.foobar.com/phpBB/rss.php" />

Change www.foobar.com/phpBB to your website and phpBB installation directory.

Security Fix

Security fix mentioned above is real simple. Just edit file rss.php and change the only occurrence of f.auth_view to f.auth_read. It's around line 145

benchfrooser · Post by **benchfrooser** » Tue Jan 23, 2007 5:50 pm

Cardcaptor Stacey wrote: Love the mod... but what do I need to change to just have one forum (3) to show with only the original post?

http://benchfrooser.de/forum/rss.php?t=1&f=46 when the forum id is 46

Code: Select all

t=1

shows only the the first post

Dierk · Post by **Dierk** » Wed Jan 24, 2007 8:08 am

Does this MOD version 2.0.2 work with phpbb 2.0.22?
Any problems?

kroog · Post by **kroog** » Wed Jan 31, 2007 5:09 pm

Dierk wrote: Does this MOD version 2.0.2 work with phpbb 2.0.22?
Any problems?

i installed this mod in my phpbb 2.0.22 and i don't have problems

jaiak · Post by **jaiak** » Wed Jan 31, 2007 6:52 pm

But nschindler say:

Code: Select all

Please note that I no longer maintain a phpBB installation, and hence no longer maintain this MOD. If anyone is willing to take over its development, PM me. There have been a lot of changes suggested that I haven't incorporated.
That said, I was recently made aware of a security issue. If anyone's willing to test it, please provide me with your results.

Somebody has used the "smartfeed" rss?

I want create my customised URLs to my forum, my forum is installed with the ABLE2KNOW modrewrite, can this mod create urls type: /foro/tema45.html instead /foro/viewtopic?p=45 ?

Regards from spain

PaulC2K · Post by **PaulC2K** » Tue Feb 06, 2007 2:30 am

Hi,

Just installed this and works a treat however rather than having it pluck threads from all public areas is there a simple way of having it take them from forum IDs of my choosing?

Im just playing with the rss reader included with Vista and the only way i can have it read from the 3 id's i want to access is by creating 3 seperate rss.php files (then delete all others and have the reader get news from all sources, which would be my 3 feeds).

Is it possible to specify source forum_id's as being 1,2&3 ?
Ideally i'd be able to create a public rss and a private one linking to private forum_ids, with the private css.php url kept secret.

Thanks

jaiak · Post by **jaiak** » Fri Feb 09, 2007 1:39 am

Hello!!

I have installed the this mods in my phpbb 2.0.22 vainilla, however I have instaled the Able2know MOD for indexation and SEO.

My urls are: /foro/tema45.html and not /foro/viewtopic?p=45

Can I modify the rss file for that create this URLs ?? I want that in my rss file apear /foro/tema45,html and not /foro/viewtopic?p=45

Regards from spain!

amsnet · Post by **amsnet** » Mon Feb 12, 2007 12:00 am

Feedburner validator gives me this message... The error is marked under the '>' How can I fix?
Thanks
Nev

Sorry
This feed does not validate.

line 1, column 62: XML parsing error: <unknown>:1:62: syntax error [help]

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> ^

Rating:

advertisements