[2.0.6] RSS Content Syndicator

The cleanup is complete. This forum is now read only.

Rating:

Excellent!
119
64%
Very Good
41
22%
Good
13
7%
Fair
5
3%
Poor
7
4%
 
Total votes: 185

benchfrooser
Registered User
Posts: 14
Joined: Wed Jan 04, 2006 10:53 pm
Contact:

Post by benchfrooser »

@tals:

Then I get this code? right?

Code: Select all

$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
Image

green ticks
Registered User
Posts: 426
Joined: Sun Apr 02, 2006 12:56 am

Post by green ticks »

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
Registered User
Posts: 77
Joined: Sun Oct 21, 2001 4:59 pm
Contact:

Post by adrien »

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
Registered User
Posts: 26
Joined: Wed Feb 23, 2005 9:39 am

Post by N!cklas »

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.
//N!cklas

Dello
Registered User
Posts: 11
Joined: Mon Jul 24, 2006 1:16 pm

RSS Content Syndicator and Spamwords

Post by Dello »

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!

User avatar
Cardcaptor Stacey
Registered User
Posts: 89
Joined: Thu Jan 12, 2006 12:04 pm
Location: England
Name: Stacey
Contact:

Post by Cardcaptor Stacey »

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

User avatar
Cardcaptor Stacey
Registered User
Posts: 89
Joined: Thu Jan 12, 2006 12:04 pm
Location: England
Name: Stacey
Contact:

Post by Cardcaptor Stacey »

Self moderated
Call me Stacey.

danx
Registered User
Posts: 1
Joined: Mon Jan 22, 2007 11:19 pm
Location: San Diego, California
Contact:

Additional mod for rss icon; security fix simplified

Post by danx »

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
Last edited by danx on Wed Jan 24, 2007 7:00 am, edited 1 time in total.

benchfrooser
Registered User
Posts: 14
Joined: Wed Jan 04, 2006 10:53 pm
Contact:

Post by benchfrooser »

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
Image

Dierk
Registered User
Posts: 17
Joined: Thu Oct 05, 2006 8:33 am

Post by Dierk »

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

kroog
Registered User
Posts: 1
Joined: Wed Jan 31, 2007 5:04 pm

Post by kroog »

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
Registered User
Posts: 43
Joined: Wed Oct 25, 2006 10:46 pm

Post by jaiak »

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
Registered User
Posts: 41
Joined: Tue Jan 21, 2003 6:53 pm
Location: Manchester, England
Contact:

Post by PaulC2K »

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
Registered User
Posts: 43
Joined: Wed Oct 25, 2006 10:46 pm

Post by jaiak »

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
Registered User
Posts: 103
Joined: Sun Jun 18, 2006 8:42 pm

Feedburner validator error message

Post by amsnet »

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"> ^

Post Reply

Return to “[2.0.x] MOD Database Cleanup”