Previous Thread
Next Thread
Print Thread
Rate Thread
UBB.News #314323 06/05/2007 2:07 PM
Joined: Jan 2003
Posts: 3,457
Ian Spence Offline OP
Master Hacker
OP Offline
Master Hacker
Joined: Jan 2003
Posts: 3,457
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.

Attached Files
2401-NewsFeed.zip (47 downloads)
Sponsored Links
Re: UBB.News [Re: Ian Spence] #314336 06/05/2007 8:25 PM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314356 06/07/2007 1:22 AM
Joined: Jan 2007
Posts: 70
Stephen G Offline
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
Total `noob` question.

Any instructions?

Re: UBB.News [Re: Stephen G] #314357 06/07/2007 2:36 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314358 06/07/2007 3:25 AM
Joined: Jan 2007
Posts: 70
Stephen G Offline
Power User
Offline
Power User
Joined: Jan 2007
Posts: 70
Not for a thicko like me!

laugh

Sponsored Links
Re: UBB.News [Re: Ian Spence] #314362 06/07/2007 4:49 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314515 06/21/2007 4:49 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314520 06/21/2007 10:51 AM
Joined: May 1999
Posts: 3,039
Rick Offline
Guru
Offline
Guru
Joined: May 1999
Posts: 3,039
The limit clause shouldn't have quotes around it.


UBB.threads Developer
Re: UBB.News [Re: Rick] #314528 06/21/2007 5:05 PM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314529 06/22/2007 12:00 AM
Joined: Nov 2000
Posts: 1,271
drkknght Offline
Kahuna
Offline
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
Re: UBB.News [Re: drkknght] #314530 06/22/2007 1:19 AM
Joined: Jan 2003
Posts: 3,457
Ian Spence Offline OP
Master Hacker
OP Offline
Master Hacker
Joined: Jan 2003
Posts: 3,457
just use type=html in the url

Re: UBB.News [Re: Ian Spence] #314531 06/22/2007 1:34 AM
Joined: Nov 2000
Posts: 1,271
drkknght Offline
Kahuna
Offline
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

Re: UBB.News [Re: Gizmo] #314532 06/22/2007 3:19 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314541 06/22/2007 1:32 PM
Joined: Jan 2003
Posts: 3,457
Ian Spence Offline OP
Master Hacker
OP Offline
Master Hacker
Joined: Jan 2003
Posts: 3,457
The file is updated, although Rick did give you the correct answer

Re: UBB.News [Re: Ian Spence] #314550 06/22/2007 7:28 PM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314560 06/23/2007 1:52 AM
Joined: Nov 2000
Posts: 1,271
drkknght Offline
Kahuna
Offline
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?

Re: UBB.News [Re: drkknght] #314561 06/23/2007 2:21 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314565 06/23/2007 3:22 AM
Joined: Nov 2000
Posts: 1,271
drkknght Offline
Kahuna
Offline
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?

Re: UBB.News [Re: drkknght] #314566 06/23/2007 5:03 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314568 06/23/2007 12:24 PM
Joined: Nov 2000
Posts: 1,271
drkknght Offline
Kahuna
Offline
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.

Re: UBB.News [Re: drkknght] #314573 06/23/2007 5:59 PM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314587 06/24/2007 8:32 PM
Joined: Nov 2000
Posts: 1,271
drkknght Offline
Kahuna
Offline
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.

Re: UBB.News [Re: drkknght] #314588 06/24/2007 9:09 PM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #314591 06/24/2007 9:45 PM
Joined: Nov 2000
Posts: 1,271
drkknght Offline
Kahuna
Offline
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

Re: UBB.News [Re: Ian Spence] #316848 04/08/2008 9:17 AM
Joined: Mar 2000
Posts: 21,084
AllenAyres Offline
I type Like navaho
Offline
I type Like navaho
Joined: Mar 2000
Posts: 21,084
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?
Re: UBB.News [Re: AllenAyres] #316856 04/08/2008 7:15 PM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps
Re: UBB.News [Re: Gizmo] #317195 06/11/2008 12:04 AM
Joined: Jan 2000
Posts: 5,786
Gizmo Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Offline
UBB.Dev / UBB.Wiki Owner
Time Lord
Joined: Jan 2000
Posts: 5,786
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, UBB.Sitemaps

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
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
drkknght
drkknght
rob's pad -- where it takes skin, to win!
Posts: 1,271
Joined: November 2000
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,499
Posts293,666
Members13,824
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 21,084
JoshPet 10,370
LK 7,395
Lord Dexter 6,709
Gizmo 5,786
Greg Hard 4,625
Top Posters(30 Days)
isaac 26
driv 16
Gizmo 5
Morgan 2
Today's Statistics
Currently Online 928
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 16
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2019 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.3
(Snapshot build 20190709.dev)
PHP: 5.4.45 Page Time: 0.049s Queries: 16 (0.010s) Memory: 3.4410 MB (Peak: 3.7764 MB) Data Comp: Zlib Server Time: 2019-07-16 10:05:56 UTC
Valid HTML 5 and Valid CSS