Re: Content moderation in CakePHP

On Wed, Apr 10, 2013 at 6:15 PM, Vinicius Dusso <vinidusso@gmail.com> wrote:

I guess you can create a schema similar which Drupal uses. 

It would be something like this:

1. Create two tables: posts and post_revisions.

2. Posts table would store all new data. When a new post is created, it would be stored there. 

3. To edit a lastest post's version, you could simply edit the Post entry.

4. When a moderator approves a Post, you would create a entry in Post Revisions table. You can do this simply using the beforeSave model callback.

This way you can handle separated the moderated and unmoderated entries, without checkin any boolean field.

Hi Vinícius,

Thanks very much for your reply and advice - sounds pretty sensible, and actually sounds pretty similar to the revision behavior that Christian suggested.

Thanks for the advice,

Alex

 

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.