Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
SQL select posts from forum
#204119 12/30/2007 9:13 PM
Joined: Dec 2005
Posts: 122
Jakarta, Indonesia
KuKuKaChu
Offline
member
KuKuKaChu
member
Offline
Joined: Dec 2005
Posts: 122
Jakarta, Indonesia
I need to use MySQL select all messages from a specific forum on a periodic basis for export to another application. However, forum information is not stored with the POSTS table.

Which table stores the forum information for posts?

And can anyone help me with with a MySQL command that can select all posts from a specific forum?

Thanks.

JakChat.com -- Forums for Indonesia's English-speaking community
Ubuntu-Indonesia.com -- Forums for Indonesia's Ubuntu Users
Re: SQL select posts from forum
KuKuKaChu #204121 12/30/2007 9:23 PM
Joined: Jun 2006
Posts: 16,532
Likes: 150
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo
UBB.threads Developer
Offline
Joined: Jun 2006
Posts: 16,532
Likes: 150
Portland, OR; USA
the topics table stores the forum that owns the post.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: SQL select posts from forum
Gizmo #204227 01/02/2008 4:12 AM
Joined: Aug 2006
Posts: 1,360
Likes: 2
Utrecht, NL
Y
Yarp Offline
Veteran
Yarp
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,360
Likes: 2
Utrecht, NL
Code
SELECT t1.POST_ID FROM 
ubbt_POSTS as t1,
ubbt_TOPICS as t2
where t1.TOPIC_ID=t2.TOPIC_ID
and t2.FORUM_ID=4

This will give you all the post_id's that are in forum 4.

[Linked Image from siemons.org]
Re: SQL select posts from forum
Yarp #204394 01/07/2008 8:37 PM
Joined: Dec 2005
Posts: 122
Jakarta, Indonesia
KuKuKaChu
Offline
member
KuKuKaChu
member
Offline
Joined: Dec 2005
Posts: 122
Jakarta, Indonesia
thanks a lot for that!

i'm now off and running!

i'm actually exporting messages from one of my threads forums to an other website. ( www.jakchat.com indonesian business news digest forum --> www.jawawa.net )

it's working just great!

now all i have to do is work out a way to automagically import anonymous messages posted on jawawa.net back into the threads business forum ... though this could be just a little too ambitious!


JakChat.com -- Forums for Indonesia's English-speaking community
Ubuntu-Indonesia.com -- Forums for Indonesia's Ubuntu Users

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
PHP 8 bug in membermanage.tmpl
by phoenix011235 - 09/08/2026 7:47 PM
Are any of these legitmate?
by Baldeagle - 09/06/2026 1:37 PM
8.0.1 Patch Changelog Discussion
by isaac - 11/26/2025 1:34 PM
Upgraded to ver8 - now can't login
by phoenix011235 - 10/24/2024 8:50 AM
Who's Online Now
2 members (SteveS, vscope), 455 guests, and 117 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Ride safe!
Ride safe!
by Morgan, December 7
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.1.0
(Snapshot build 20260527)