Code: Select all
SQL ERROR [ mssql_odbc ] [Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified.  SQL SELECT distinct(p.topic_id) , p.forum_id, p.post_time, p.post_subject, p.post_text, p.bbcode_bitfield, p.bbcode_uid, u.user_id, u.user_email, u.username, u.user_posts, u.user_rank, u.user_colour, u.user_allow_viewonline, u.user_allow_viewemail, t.topic_title, f.left_id, f.right_id, t.topic_replies as aantal_posts FROM phpbb_posts p JOIN phpbb_users u on p.poster_id = u.user_id JOIN phpbb_topics t on p.topic_id = t.topic_id JOIN phpbb_forums f on p.forum_id = f.forum_id ORDER BY t.topic_last_post_time DESC BACKTRACE
this mod works in conjunction with the forum it has to be in the root directory of the forum. The same holds true to the showing new topics if your not logged in to your forum the topics well not show as new and in some readers it depends on what browser they are based on as to showing new topics and what browser you use by default. (Point Feedreeder uses IE for its browser base and I use Firefox so in my reeder post dont show as new.) If I follow you right. same holds true for private topics and posts if you have to login to see them then you well not see them in the same case with me I would have to login with IE for my reeder to show me new private posts.Jarode wrote:This MOD only works if you are conected to the forum, if it isn't the case RSS feed doesn't display new topics or new posts.
How can I show more than 11 items?joeroberts wrote:
proterra wrote:Thank you for this tool.
It´s wonderful without core-code editing. I integrate it over "fee2js" in my board footer, because I use it only to link the last topic without description.
One question: How can I show more than 10 items? Now the feed shows 11, I don´t know where I can change this. Thanks
it works by how many topic posts are shown on your forum you can always change this by changing you board preferences with out changing the coding
I didn´t understand it.
In my board there are shown 15 threads before going to next site. In my feed I see 11 topics.