Content moderation in CakePHP

Hello all,

I'm just wondering how best to approach content moderation and wondered whether anyone that has done something similar could offer any advice?

For example, I have Users that have many Posts.  Whenever a Post is added it needs to be approved before being published (easy), but also when a Post is edited the changes will need to be held in moderation before being published.  Whilst awaiting moderation, the previous version of the Post should stay live on the site until the new version is published.

Also if a User edits a Post that is currently awaiting moderation, they should be presented with the latest (unmoderated) version to edit instead of the current live version.

For this scenario Posts do not HABTM Tags, which keeps it simpler.

So far I have thought of two approaches:

1) Have two tables for Posts and ModeratedPosts and a ModeratedPost belongsTo a Post.  A Post only becomes a ModeratedPost when it has been approved.

2) Store both Posts and ModeratedPosts in the same table with a 'moderated' boolean.  I would still need some way of linking records together so that a Post belongsTo a ModeratedPost.

Any thoughts welcome!

Thanks in advance,

Alex

--

Alex Bovey

Web Developer | Alex Bovey Consultancy Ltd

Registered in England & Wales no. 6471391 | VAT no. 934 8959 65

alex@bovey.co.uk | t 0844 567 8995 | m 07828 649386 | f 0870 288 9533

PHP | CakePHP | MySQL | jQuery | HTML5 | CSS3 | Drupal | Wordpress | Hosting

--
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.