[geeklog-devel] comment moderation queue and hierarchical data

[Jared Wenerd]

Hello,

In my summer of code project, there is the feature to send an already
published comment to a submission queue. All replies to this comment (and
their replies.. and so on..) are sent back into this as well.

The ID of the parent comment is stored in the submission table. When
resubmitting these queued comments back into the comment table there can be
many different scenarios of some comments being approved, deleted, or no
action (just remain in the queue).

 The problem I've been stuck on the past few days is how to deal with all
these different cases of saving data back into the comments table and still
preserve the correct tree structure if a comment's parent is deleted.

Does anybody know of any resources for problem like this?

-Jared
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://pairlist8.pair.net/pipermail/geeklog-devel/attachments/20080710/746bae19/attachment.html>