| Author |
 Topic  |
|
pitstraight
New Member
Australia
82 Posts |
 Posted - 31 January 2008 : 15:24:14
|
Is there such a thing as an audit log for editing ? I have stopped people deleting posts but they sometimes edit (up to weeks later) and remove good content.
What I would like to see is that when an edit happens, the original post gets sent to another table or something with a date/time and a link to the original post. This should happen for EVERY edit, so if a user changes a post 3 times, there is 3 records created with the before & after post, the link and the time it happened.< |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 31 January 2008 : 16:11:59
|
To the best of my knowledge, there is no existing MOD to do this. While it is technically possible, and I agree that it would be a good thing from a conceptual standpoint, I'm not sure I would actually implement something like this unless I've got a lot of data storage to burn.  < |
 |
|
|
Mr Pink
Junior Member
United Kingdom
387 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 31 January 2008 : 16:50:41
|
| Good idea - I forgot about that one.< |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 31 January 2008 : 16:53:44
|
| I've used that mod myself, and it is quite useful. Should do what you need.< |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 31 January 2008 : 20:46:32
|
| But I don't want to stop them, I just want an audit trail. The data storage would be a lot less than the normal posts because not every post is editted and usually not editted multiple times. I don't allow deletes at all, but I just want to track the changes that are made ... there's not a lot of changes made, but I need to see what has changed when it does occur.< |
|
|
|
phy1729
Average Member
USA
589 Posts |
Posted - 31 January 2008 : 22:31:53
|
| I don't know how you would implement this but could you track all changes on the reply table and use the db to track and not the forum code?< |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 01 February 2008 : 14:55:47
|
Would it work that way ?
I just don't know how to code it which is why I posted here.< |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 01 February 2008 : 15:13:46
|
| I'm confused now... in your original post it sounds like you don't want to loose the information that they posted, and that you are somewhat unnerved by them editing/removing the information weeks after it was posted; but now you don't want to stop them, just have a record of it happening, which would imply that you aren't bothered by them editing/removing the information... which is it?< |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 01 February 2008 : 15:25:54
|
I don't want them to loose the edit facility altogether, I just want an audit trail of all edits made. I didn't think it would be this hard.
Other forum software I've heard can track the edits so I thought it would be good for Snitz to have this feature and I use Snitz as well.< |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 01 February 2008 : 17:29:00
|
Are you wanting to keep track of the actual data changed or simply the date/time changes were made? The second would be less overhead on the database, but the first is what it sounds like you're wanting.
I can see both sides of this. It sounds like it could be highly useful, but very space-hogging at the same time.< |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 01 February 2008 : 21:06:32
|
Yes, the first, well the first and the second - I would like the data and the date/time that it happened.
I can't understand why it would be a space hog though. even this thread has had 12 posts and only 1 edit. Surely the thread would be using more room than the edits that I want to keep ?< |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 03 February 2008 : 19:06:36
|
| Anyone ?< |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 04 February 2008 : 01:37:54
|
It's possible to do, but I don't think there's a MOD out there to do it. Essentially, you'd need a check somewhere in post_info.asp that checks that the post method is Edit_Topic, then copies the current contents of the topic field over to a TOPICS_HISTORY table (or whatever you chose to name your table). You'd then be able to query the table as you wanted in order to view past versions of posts.
As for the idea that it would be a space hog, the reason I say that is because there are often times where someone may edit the same post several times (due to typos, updated content, etc). So while I agree that not every post will be edited, you could see as much as 10% of your posts being copied into the history table due to edits. In larger databases, that is a significant amount.< |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
pitstraight
New Member
Australia
82 Posts |
Posted - 05 February 2008 : 22:43:07
|
| That all sounds great, but I don't even know how to start doing it. That's why I posted here, hoping that someone would do it for me, or give me some really basic pointers on how to start.< |
|
|
|
muzishun
Senior Member
United States
1079 Posts |
Posted - 06 February 2008 : 02:05:34
|
| Well, there's a small chance my office (a state university) will be closed tomorrow due to inclement weather. If that's the case, I will try to write something up for you. No promises, though, since I won't know till morning.< |
Bill Parrott
Senior Web Programmer, University of Kansas
Co-Owner and Code Monkey, Eternal Second Designs (www.eternalsecond.com)
Personal Website (www.chimericdream.com) |
|
|
|
Topic |
|
MOD request : Edit auditing
