php forum
php mysql forum
php mysql smarty
 
Page 1 of 2 1 2 >
Topic Options
#314323 - 06/05/07 02:07 PM UBB.News
Ian Spence Offline
Master Hacker

Registered: 01/25/03
Posts: 3765
Loc: Saint Johns, PA
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 (44 downloads)

_________________________
Code monkey like Fritos

Top
#314336 - 06/05/07 08:25 PM Re: UBB.News [Re: Ian Spence]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
<snicker> 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 - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#314356 - 06/07/07 01:22 AM Re: UBB.News [Re: Gizmo]
GEN Offline
Power User

Registered: 01/01/07
Posts: 52
Loc: UK
Total `noob` question.

Any instructions?
_________________________
GEN
Give Yourself to the Dark Side @ http://www.galacticempire.net
Give Yourself to the Geek Side @ http://www.movingimagetoys.com
"Anakin, duck!"
"What's a duck?"

Top
#314357 - 06/07/07 02:36 AM Re: UBB.News [Re: GEN]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
he gave usage indications... That's about all there is to it...
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#314358 - 06/07/07 03:25 AM Re: UBB.News [Re: Gizmo]
GEN Offline
Power User

Registered: 01/01/07
Posts: 52
Loc: UK
Not for a thicko like me!

laugh
_________________________
GEN
Give Yourself to the Dark Side @ http://www.galacticempire.net
Give Yourself to the Geek Side @ http://www.movingimagetoys.com
"Anakin, duck!"
"What's a duck?"

Top
#314362 - 06/07/07 04:49 AM Re: UBB.News [Re: Ian Spence]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
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 - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#314515 - 06/21/07 04:49 AM Re: UBB.News [Re: Gizmo]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
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 - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#314520 - 06/21/07 10:51 AM Re: UBB.News [Re: Gizmo]
Rick Offline
Guru

Registered: 05/11/99
Posts: 8372
Loc: Olympia, WA
The limit clause shouldn't have quotes around it.
_________________________
StogieSmokers.com

Top
#314528 - 06/21/07 05:05 PM Re: UBB.News [Re: Rick]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
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 - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#314529 - 06/22/07 12:00 AM Re: UBB.News [Re: Gizmo]
drkknght Offline
Kahuna

Registered: 11/09/00
Posts: 1249
Loc: rob's pad -- where it takes sk...
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?
_________________________
professional discussion killer
due to intelligence limitations, i do not offer support.
my site ~ my boards

Top
#314530 - 06/22/07 01:19 AM Re: UBB.News [Re: drkknght]
Ian Spence Offline
Master Hacker

Registered: 01/25/03
Posts: 3765
Loc: Saint Johns, PA
just use type=html in the url
_________________________
Code monkey like Fritos

Top
#314531 - 06/22/07 01:34 AM Re: UBB.News [Re: Ian Spence]
drkknght Offline
Kahuna

Registered: 11/09/00
Posts: 1249
Loc: rob's pad -- where it takes sk...
excellent, thanks ian! smile

tho, unfortunately, while testing, i got the same error gizmo quoted above. and i am running 7.1.1
_________________________
professional discussion killer
due to intelligence limitations, i do not offer support.
my site ~ my boards

Top
#314532 - 06/22/07 03:19 AM Re: UBB.News [Re: Gizmo]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
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 - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#314541 - 06/22/07 01:32 PM Re: UBB.News [Re: Gizmo]
Ian Spence Offline
Master Hacker

Registered: 01/25/03
Posts: 3765
Loc: Saint Johns, PA
The file is updated, although Rick did give you the correct answer
_________________________
Code monkey like Fritos

Top
#314550 - 06/22/07 07:28 PM Re: UBB.News [Re: Ian Spence]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
odd, because I looked at the queries and i didn't see any "'s...
_________________________
UBB.Dev - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#314560 - 06/23/07 01:52 AM Re: UBB.News [Re: Gizmo]
drkknght Offline
Kahuna

Registered: 11/09/00
Posts: 1249
Loc: rob's pad -- where it takes sk...
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?
_________________________
professional discussion killer
due to intelligence limitations, i do not offer support.
my site ~ my boards

Top
#314561 - 06/23/07 02:21 AM Re: UBB.News [Re: drkknght]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
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 - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#314565 - 06/23/07 03:22 AM Re: UBB.News [Re: Gizmo]
drkknght Offline
Kahuna

Registered: 11/09/00
Posts: 1249
Loc: rob's pad -- where it takes sk...
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?
_________________________
professional discussion killer
due to intelligence limitations, i do not offer support.
my site ~ my boards

Top
#314566 - 06/23/07 05:03 AM Re: UBB.News [Re: drkknght]
Gizmo Administrator Online   shocked
Wizard

Registered: 01/10/00
Posts: 5134
Loc: Portland, OR, USA
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 - Where you too can render your UBB install completely useless...
UGN Security, Elite Web Gamers & VNC Web Design Owner

Top
#314568 - 06/23/07 12:24 PM Re: UBB.News [Re: Gizmo]
drkknght Offline
Kahuna

Registered: 11/09/00
Posts: 1249
Loc: rob's pad -- where it takes sk...
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.
_________________________
professional discussion killer
due to intelligence limitations, i do not offer support.
my site ~ my boards

Top
Page 1 of 2 1 2 >


Moderator:  sirdude 
Who's Online
0 registered (), 20 Guests and 12 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Wisdom needed
by Gizmo
Yesterday at 10:54 AM
How to hide sub forums from summary page
by blaaskaak
12/03/08 09:54 AM
Spell Check [beta]
by Bill B
12/01/08 09:16 PM
PhotoPost BB Code Popup
by AllenAyres
12/01/08 09:41 AM
Problems reading a lot of old posts here
by AllenAyres
12/01/08 09:35 AM
Forum 'Trader Ratings'.
by AllenAyres
12/01/08 09:33 AM
Customization needed
by Gizmo
11/12/08 12:28 PM
New Mods
User Authentication Class
by
01/19/07 02:59 PM
Multiple Identity Detector
by
12/30/06 06:39 PM
PhotoPost BB Code Popup
by
11/06/06 05:43 PM
Spell Check [beta]
by
10/17/06 09:24 PM
Newest Members
Truth, David DelMonte, nick1, Begbie, cenk
13364 Registered Users
Top Posters
AllenAyres 25452
JoshPet 11330
Rick 8372
LK 7396
Lord Dexter 6503
Greg Hard 5533
Charles Capps 5438

 

 

 
fusionbb message board php hacks