Keeping track of CMS updates

[tyutghf]

We have a CMS that certain people in our organisation can go in and update their pages on the website, how would I go about logging all changes so that we can say that for example on 1st May 2007 the content on that page was this.

Also, some pages need to be approved before it goes live to prevent people from uploading any old rubbish. So ideally it would also need to show which bit of the text (some pages are very text heavy) has changed to prevent t5he approver from having to read the whole thing.

I guess I am going to need to create some more tables to monitor updates and another for the approval process? I used to be a programmer many years ago so could know something up if someone could help with the logic on how to achieve this.

Thanks

 

[johnwm]

Make every post and edit as a single record. Add a field for current/expired, and a field for approved/pending. The system will only display current content, and the approval process will only display pending items.

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints