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.
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...
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?
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.
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.
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...
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.
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...
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.
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
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.
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.