Previous Thread
Next Thread
Print Thread
Rate Thread
#314323 06/05/2007 2:07 PM
Joined: Jan 2003
Posts: 3,456
Likes: 2
Master Hacker
Master Hacker
Offline
Joined: Jan 2003
Posts: 3,456
Likes: 2
Allows you to easily create and customize newsfeeds for your forums. Want an RSS feed that only shows forums 3 and 9?

ubbthreads.php?ubb=news&forums=3,9

Instead of an RSS feed, do you want it to be styled like the center column on the portal page?

ubbthreads.php?ubb=news&forums=3,9&view=html

Checks permissions so no one see a forum they weren't meant to.
Attachments
2401-NewsFeed.zip (4.75 KB, 47 downloads)

Sponsored Links
Ian Spence #314336 06/05/2007 8:25 PM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
good job Ian wink... I've been using something similar forever now; though been using yours for about the last 6 months or so :X


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314356 06/07/2007 1:22 AM
Joined: Jan 2007
Posts: 70
Power User
Power User
Joined: Jan 2007
Posts: 70
Total `noob` question.

Any instructions?

Stephen G #314357 06/07/2007 2:36 AM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
he gave usage indications... That's about all there is to it...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314358 06/07/2007 3:25 AM
Joined: Jan 2007
Posts: 70
Power User
Power User
Joined: Jan 2007
Posts: 70
Not for a thicko like me!

laugh

Sponsored Links
Ian Spence #314362 06/07/2007 4:49 AM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
Originally Posted by Ian Spence
Allows you to easily create and customize newsfeeds for your forums. Want an RSS feed that only shows forums 3 and 9?

ubbthreads.php?ubb=news&forums=3,9

http://www.yoursite.tld/forums/ubbthreads.php?ubb=news&forums=3,9


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314515 06/21/2007 4:49 AM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
I'm getting this on UBB.T7 B2:
Script: /home/undergroundnews/public_html/forum/scripts/news.inc.php
Line#: 163
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''15'' at line 16
SQL Error #: 1064
Query: SELECT t1.TOPIC_REPLIES, t1.TOPIC_SUBJECT, t1.TOPIC_CREATED_TIME, t1.TOPIC_VIEWS, t1.TOPIC_REPLIES, t1.TOPIC_ID, t2.POST_BODY, t2.POST_ID, t2.POST_DEFAULT_BODY, t3.USER_ID, t3.USER_DISPLAY_NAME, t4.FORUM_DESCRIPTION, t4.FORUM_TITLE, t4.FORUM_ID FROM forums_TOPICS as t1, forums_POSTS as t2, forums_USERS as t3, forums_FORUMS as t4 WHERE t1.FORUM_ID in ( '3', '9' ) AND t2.USER_ID = t3.USER_ID AND t2.POST_ID = t1.POST_ID AND t1.TOPIC_IS_APPROVED = '1' AND t4.FORUM_ID = t1.FORUM_ID AND t4.FORUM_IS_ACTIVE = '1' ORDER BY t1.TOPIC_CREATED_TIME DESC LIMIT '15'

Please use your back button to return to the previous page.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314520 06/21/2007 10:51 AM
Joined: May 1999
Posts: 3,039
Guru
Guru
Offline
Joined: May 1999
Posts: 3,039
The limit clause shouldn't have quotes around it.


UBB.threads Developer
Rick #314528 06/21/2007 5:05 PM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
Originally Posted by Rick
The limit clause shouldn't have quotes around it.
Sadly, I don't see what to update in the script file... I can see where 15 is mentioned, and I see the query, and I see referances to "NEWS_MAX_POSTS"; however the only thing with a ' is the "NEWS_MAX_POSTS" and it has to be there since it's defining the section...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314529 06/22/2007 12:00 AM
Joined: Nov 2000
Posts: 1,271
Kahuna
Kahuna
Joined: Nov 2000
Posts: 1,271
i think this is what i want, i just wanna make sure i understand what it is, first.

basically, i'm looking for a way to display something similar to how the portal page displays news. i have 20 new topics being displayed on my portal page regular news style -- the full post, not just the linked thread subject

i would like to include the one, latest news post on the top of my forums (cfm) page.

is that what this would allow me to do? ...sorta like the old "addon" news files?

Sponsored Links
drkknght #314530 06/22/2007 1:19 AM
Joined: Jan 2003
Posts: 3,456
Likes: 2
Master Hacker
Master Hacker
Offline
Joined: Jan 2003
Posts: 3,456
Likes: 2
just use type=html in the url

Ian Spence #314531 06/22/2007 1:34 AM
Joined: Nov 2000
Posts: 1,271
Kahuna
Kahuna
Joined: Nov 2000
Posts: 1,271
excellent, thanks ian! smile

tho, unfortunately, while testing, i got the same error gizmo quoted above. and i am running 7.1.1

Gizmo #314532 06/22/2007 3:19 AM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
Ian, any ideas for my error?
Originally Posted by Gizmo
I'm getting this on UBB.T7 B2:
Script: /home/undergroundnews/public_html/forum/scripts/news.inc.php
Line#: 163
SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''15'' at line 16
SQL Error #: 1064
Query: SELECT t1.TOPIC_REPLIES, t1.TOPIC_SUBJECT, t1.TOPIC_CREATED_TIME, t1.TOPIC_VIEWS, t1.TOPIC_REPLIES, t1.TOPIC_ID, t2.POST_BODY, t2.POST_ID, t2.POST_DEFAULT_BODY, t3.USER_ID, t3.USER_DISPLAY_NAME, t4.FORUM_DESCRIPTION, t4.FORUM_TITLE, t4.FORUM_ID FROM forums_TOPICS as t1, forums_POSTS as t2, forums_USERS as t3, forums_FORUMS as t4 WHERE t1.FORUM_ID in ( '3', '9' ) AND t2.USER_ID = t3.USER_ID AND t2.POST_ID = t1.POST_ID AND t1.TOPIC_IS_APPROVED = '1' AND t4.FORUM_ID = t1.FORUM_ID AND t4.FORUM_IS_ACTIVE = '1' ORDER BY t1.TOPIC_CREATED_TIME DESC LIMIT '15'

Please use your back button to return to the previous page.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314541 06/22/2007 1:32 PM
Joined: Jan 2003
Posts: 3,456
Likes: 2
Master Hacker
Master Hacker
Offline
Joined: Jan 2003
Posts: 3,456
Likes: 2
The file is updated, although Rick did give you the correct answer

Ian Spence #314550 06/22/2007 7:28 PM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
odd, because I looked at the queries and i didn't see any "'s...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314560 06/23/2007 1:52 AM
Joined: Nov 2000
Posts: 1,271
Kahuna
Kahuna
Joined: Nov 2000
Posts: 1,271
wuhoo, no more errors! however, there appears to be no difference between the two link types. for example, these two URLs produce identical pages:

http://www.robkamphausen.com/ubbthreads/ubbthreads.php?ubb=news&forums=3,9&view=html

http://www.robkamphausen.com/ubbthreads/ubbthreads.php?ubb=news&forums=3,9

is there specific formatting of an include script (or something?) to get the results to appear like the portal page's center news?

drkknght #314561 06/23/2007 2:21 AM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
The HTML view is supposed to show a HTML based content island for inclusion (you can see mine at ugn in my signature)


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314565 06/23/2007 3:22 AM
Joined: Nov 2000
Posts: 1,271
Kahuna
Kahuna
Joined: Nov 2000
Posts: 1,271
ah, ok.

so if i wanted that island to, say, take the place of the "community introduction" (blurb right atop the forums on cfrm), what should i do?

drkknght #314566 06/23/2007 5:03 AM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
I'm not sure I know what you're intending to do...

This script takes your forum data and presents it as news (as shown on my homepage); I'm unsure as to what you're asking...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314568 06/23/2007 12:24 PM
Joined: Nov 2000
Posts: 1,271
Kahuna
Kahuna
Joined: Nov 2000
Posts: 1,271
on the portal page, i have the 20 latest news blurbs being displayed. on my boards, these "blurbs" are actually graphics instead of text -- splash images that link to articles elsewhere on the boards.

i would like a way to display the most recent of those 20 images/news blurbs on the top of my cfrm page, over the first category.

in 6.5 world, i could do this by modding the IIP feature. i had my portal page news.php file display the 20 recent posts. then, i created another php file that called in just 1 post from the news forum, and included that on top of the message boards homepage.

drkknght #314573 06/23/2007 5:59 PM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
What I'm failing to see here is how this mod would effect your CFRM page... This mod doens't touch any threads templates; it's meant as a need for "off forum" syndication...

So what I'm failing to see is what you're trying to do with the portal with this mod...



UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314587 06/24/2007 8:32 PM
Joined: Nov 2000
Posts: 1,271
Kahuna
Kahuna
Joined: Nov 2000
Posts: 1,271
thats what i'm looking for -- to implement this additional news feed on my cfrm.

i see that you made it a post island-like thing in the right column of your UGN site. instead of putting it there, i would like it featured on the top of my cfrm page.

its sorta like what you did with the who's online mod, taking a post island and featuring it above (or below) your forum listing.

drkknght #314588 06/24/2007 9:09 PM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
My portal on UGN is entirely stock code, the "news" island I have is simply a post content island named "latest news"; you could put a custom island into the portal template file by following the "content islands 101" guide i have in the templates directory.

Again, this isn't related to this addon which we've officially hijacked...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #314591 06/24/2007 9:45 PM
Joined: Nov 2000
Posts: 1,271
Kahuna
Kahuna
Joined: Nov 2000
Posts: 1,271
haha

well, all of the post island things that i've done just display a list of linked subject lines. this feed from this ubb.news hack actually shows the post content, i.e; the news images, which is what i want.

so, that much of what i'm seeking is related to the thread and wonderful mod. smile

the only other part i was looking for was a way to position that display on the top of my CFRM page. i'll check out yer content islands 101 guide for that

Ian Spence #316848 04/08/2008 9:17 AM
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
Anyone using this with 7.3?

Does it now use the SEO URL's now? (thread title in link)

I need a CMS backend for my site and I'd like to be able to use something I'm familiar with than learning the behemoth that is joomla or similar.


- Allen wavey
- What Drives You?
AllenAyres #316856 04/08/2008 7:15 PM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
I don't see why it wouldn't work with 7.3, however the SEO URLs may need to be updated...


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts
Gizmo #317195 06/11/2008 12:04 AM
Joined: Jan 2000
Posts: 5,833
Likes: 20
UBBDev / UBBWiki Owner
Time Lord
UBBDev / UBBWiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,833
Likes: 20
Just a followup for you allen, the version of this i'm running does NOT work with 7.3; likely due to the new permissions... I haven't been able to figure out (offhand) why it isn't working.


UBB.Dev - Putting Dev into UBB.threads
Company: VNC Web Services - UBB.threads Scripts and Scripting, Install and Upgrade Services, Site and Server Maintenance.
Forums: A Gardeners Forum, Scouters World, and UGN Security
UBB.Threads: My UBB Themes, My UBB Scripts

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)