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 (47 downloads)


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

Wizard

Registered: 01/10/00
Posts: 5354
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 & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

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

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

Any instructions?
_________________________
Stephen G
Give Yourself to the Geek Side @
http://cinemageek.co.uk

Top
#314357 - 06/07/07 02:36 AM Re: UBB.News [Re: SGHB1138]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
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 & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

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

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

laugh
_________________________
Stephen G
Give Yourself to the Geek Side @
http://cinemageek.co.uk

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

Wizard

Registered: 01/10/00
Posts: 5354
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 & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

Top
#314515 - 06/21/07 04:49 AM Re: UBB.News [Re: Gizmo]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
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 & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

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

Registered: 05/11/99
Posts: 8373
Loc: Olympia, WA
The limit clause shouldn't have quotes around it.
_________________________
UBB.threads Developer

Top
#314528 - 06/21/07 05:05 PM Re: UBB.News [Re: Rick]
Gizmo Offline

Wizard

Registered: 01/10/00
Posts: 5354
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 & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

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

Registered: 11/09/00
Posts: 1251
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

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

Registered: 11/09/00
Posts: 1251
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 Offline

Wizard

Registered: 01/10/00
Posts: 5354
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 & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

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

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

Wizard

Registered: 01/10/00
Posts: 5354
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 & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

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

Registered: 11/09/00
Posts: 1251
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 Offline

Wizard

Registered: 01/10/00
Posts: 5354
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 & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

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

Registered: 11/09/00
Posts: 1251
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 Offline

Wizard

Registered: 01/10/00
Posts: 5354
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 & Development President
UBB.Threads: My UBBSkins, UBB.Sitemaps

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

Registered: 11/09/00
Posts: 1251
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 
Latest Posts
[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM
[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM
Shout Box

(Views)Popular Topics
Known public proxy servers 1689885
Integrated Index Page (IIP) 5.3.1 555705
Finished-[6.5.2] Games Arcade Deluxe v1.9 501236
Integrated Index Page (IIP) 5.1.1 415112
TLD Bv2.1 Released - Threads Links Directory 396822
[6.0x] Who's Online 4.0.0 [Finished] 389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 330423
Q & A 298663
Slash UBB 266936
[6.3.x] [beta] Hit Hack 2.0 227970
Forum Stats
13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM

 

 

 
fusionbb message board php hacks