Threaded style discussions?

[Enigma]

Hello,

I really like s9y quite a bit for it's ease of use, etc. I have to admit that I prefer a more threaded style discussion (like Slashdot and many others) when there are alot of postings, or an ongoing discussion to follow. That is a pretty major difference in code between those two styles of blogs thought...has anyone considered adding the ability? (Even if it were an option, to post any item as a threaded discussion, or in the current ordered fashion.)

Thanks in advance.

[garvinhicking]

Hi Enigma!

The possibility is considered, yes. However it's difficult to implement and takes a major change in the database structure and interface. Though we will try to implement it (as an option) as soon there's time.

Any help, BTW, is appreciated.

Evan Nemerson is currently working on a patch for nested subcategories; when that is done it will help in creating "subcomments".

Regards,
Garvin.

[Enigma]

Actually, I might be able to help on that one. I've done some similar things in the past, but that was in Java running against an Oracle database. Oracle has a really nice "Connect By" statement for bringing back a hierachy like what we'd need here. There is a really good explanation of it at the following URL for anyone who isn't familiar with it:

http://philip.greenspun.com/sql/trees.html

I wish mysql had that functionality...though I am sure there is a workaround to get the same result. I found some discussions on google about it...I'd just have a little reading to do.

I am hoping that I will get some free time soon...I might take a shot at it and see what I can come up with.

Thanks for the fast response,

Jeremy

[garvinhicking]

Hi Enigma!

Thanks for your URL; we have a similar tutorial available on http://www.sitepoint.com/article/hierar ... database/1 which replicates this functionality in MySQL.

We also have a patch for recursive trees available: http://garv.info/files/s9y_subcat_multicat2.diff - that needs to be patched to include the new nested-set functionality.

And then the same way like modifying subcategories can be applied to the serendipity_comments table. We'd then only need to modify the output routines (the most easy thing) and how to link to new comments (either by including text like [parent-id] or with a new form-field where you can enter a reference).

If you happen to want to work on it, you're most welcome

Regards,
Garvin.

[Enigma]

I'll take a look at it as soon as sourceforge gets the CVS system fixed. I just enlisted myself on the dev mailing list, so I can get an idea of what is going on. I'll see what I can do with it as I can make time for it.

Thanks for the information...it gives me a good start.

Jeremy