[cfaussie] Re: Trying to create a threading system
To me, Basic threading is a single post system where you have one topic, and users can post responses to that one topic. As soon as you have multiple threads from the one topic, it goes beyond Basic. What I did was something like: TOPIC_TABLE TopicID Topic WhateverElse POST_TABLE PostID TopicID ParentPostID Post WhateverElse For the given Topic, you get all recursive-like with your posts. There's a few open source php boards that are pretty easy to customize and hack into. I just got through the learning curve with osCommerce, a php shopping cart system. It's not too painful, I've had broken bones that were worse. Chad who randomly adjusts his definition of painful On 2/13/06, Seona Bellamy [EMAIL PROTECTED] wrote: Hi guys, I'm trying to create a VERY basic message-board-type system (I've had a look around and I can't seem to find a CF one that's as basic as we want it). I'm having some throuble figuring out how to properly thread the messages. I started with the idea of two tables: * thread assigns each new thread an ID, and records some basic information about when it was created and by whom. * post stores the details of each individual post, including a threadID column to record what thread it belongs to and a replyTo column to record what previous post it is in reply to. First question: is this the best way to go about it? It made sense to me when I created it, but now that I'm trying to output the data I'm having trouble figuring out how to work it. I'm pretty sure that grouping and/or ordering needs to come into this somewhere, but I'm having trouble working out how and where each of these bits fits in. So far I've managed a lot of different permutations, but none that are really workable. Has anyone done something like this before? Any suggestions about how I could make it work? Ideally, I'd like to end up with a simple bulleted list so that this sort of thing can happen: * Thread 1, post 1 * Thread 1, post 2 * Thread 1, post 3 * Thread 1, post 5 * Thread 1, post 4 * Thread 2, post 1 * Thread 2, post 2 * Thread 2, post 3 * Thread 2, post 6 * Thread 2, post 4 * Thread 2, post 5 Any suggestions are greatly appreciated. Cheers, Seona.
[cfaussie] Re: Trying to create a threading system
On 13/02/06, Chad Renando [EMAIL PROTECTED] wrote: To me, Basic threading is a single post system where you have onetopic, and users can post responses to that one topic.As soon as youhave multiple threads from the one topic, it goes beyond Basic. Fair call. It's all a matter of definition, I guess. :) Compared to most of the message boards I'm used to, this counts as basic. What I did was something like:TOPIC_TABLETopicIDTopicWhateverElse POST_TABLEPostIDTopicIDParentPostIDPostWhateverElse Yep, this is pretty much what I have, save some minor name changes (use of thread instead of topic, and replyTo instead of parentPostID). Good to know I'm on the right track with this much, at least. *grin* For the given Topic, you get all recursive-like with your posts. Yeah, and that's where I'm coming unstuck, I think. I'm having trouble getting appropriately recursive-like with my posts. There's a few open source php boards that are pretty easy to customizeand hack into.I just got through the learning curve with osCommerce, a php shopping cart system.It's not too painful, I've had brokenbones that were worse. I'll have another look, but I hadn't had much luck with this option. Cheers, Seona. who can't currently think of anything witty to say after her name...
[cfaussie] Re: Trying to create a threading system
Seona, you may want to check out Ray Camden's forum software (to either use or look at to get the ideas)http://ray.camdenfamily.com/projects/galleon/ :)On 2/13/06, Seona Bellamy [EMAIL PROTECTED] wrote: Hi guys, I'm trying to create a VERY basic message-board-type system (I've had a look around and I can't seem to find a CF one that's as basic as we want it). I'm having some throuble figuring out how to properly thread the messages. I started with the idea of two tables: * thread assigns each new thread an ID, and records some basic information about when it was created and by whom. * post stores the details of each individual post, including a threadID column to record what thread it belongs to and a replyTo column to record what previous post it is in reply to. First question: is this the best way to go about it? It made sense to me when I created it, but now that I'm trying to output the data I'm having trouble figuring out how to work it. I'm pretty sure that grouping and/or ordering needs to come into this somewhere, but I'm having trouble working out how and where each of these bits fits in. So far I've managed a lot of different permutations, but none that are really workable. Has anyone done something like this before? Any suggestions about how I could make it work? Ideally, I'd like to end up with a simple bulleted list so that this sort of thing can happen: * Thread 1, post 1 * Thread 1, post 2 * Thread 1, post 3 * Thread 1, post 5 * Thread 1, post 4 * Thread 2, post 1 * Thread 2, post 2 * Thread 2, post 3 * Thread 2, post 6 * Thread 2, post 4 * Thread 2, post 5 Any suggestions are greatly appreciated. Cheers, Seona. -- Postal: Po Box 3462 Dural, NSW 2158Email: mailto:[EMAIL PROTECTED] FireFly Internet Phone: 80011777
[cfaussie] Re: Trying to create a threading system
On 13/02/06, Carl Vanderpal [EMAIL PROTECTED] wrote: Seona, you may want to check out Ray Camden's forum software (to either use or look at to get the ideas) http://ray.camdenfamily.com/projects/galleon/ :) Thanks for that, Carl. The whole 'having a forum' thing is a little experimental at the moment, so I might stick with what I have, but I like the look of this one. I've bookmarked it in case the thing takes off and we need something more sophisticated. :) Cheers, Seona.