Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/66440?pagenum=1
04 November 2025, 22:10
Topic
muzishun
Post History MOD
07 February 2008, 15:12
By request, this MOD gives admins and moderators the ability to see past versions of an edited post. This has been tested with an Access database, but it is still a beta release. I can't guarantee that it is bug free (though I wish I could). Please post bug reports in the Mod Implementation forum and general comments here.
From the readme:
This MOD gives an admin the ability to view past versions of a post. Often times, users edit their responses, but there are times when being able to view the original post may be necessary. With this add-on, administrators can view all past versions of edited posts.
Download from SnitzBitz. Update (2/10/08): Version 0.6b is ready. Fixed a bug in post_info.asp. I was forgetting to re-sanitize data coming from the database before it was reinserted into the POST_HISTORY table.<
Replies ...
thelodger
08 February 2008, 14:42
Is there something missing? I have installed, and changed code checked and all seems fine, but nothing has changed on the forum<
texanman
08 February 2008, 15:21
I haven't installed this myself. But, do you see the "icon_post_history" in the topic? May be you click on that or something ;-)<
muzishun
08 February 2008, 17:01
You will only be able to view the history of edits made since the MOD was installed. Any posts that are edited will have an icon next to the "Edit" icon. This will take you to the page displaying the history of the post.
If you have edited posts since installing the MOD but still do not see the icon above, can you give me a link to your site for testing?<
thelodger
09 February 2008, 02:15
Ah, ok I will wait or ask someone to edit a post, I dont have the clock icon anywhere, does it not even appear till someone has made an edit? I will report back tonight after I return from work
my forum is www.forumsuperstars.com with a test account, username: poker, password: test
Cheers<
thelodger
09 February 2008, 13:55
Sorted thanks very much all working fine with Mysql so far.<
muzishun
09 February 2008, 20:54
Glad it's working for you. To answer your question, you are correct in that the icon will not show up for a post unless there are available history entries to view. That way you don't have to worry about which posts do or don't have saved edits. The forum takes care of that for you.<
phy1729
10 February 2008, 11:50
In post_info.asp in the first mod block you need to sanitize all user input you should go through the rest of the mod just in case. I can't read the JS box I'm a plain text fan.
Error first reported by thelodger at 66450<
thelodger
10 February 2008, 14:34
yeah I have reverted back to my back up files and the problem has gone away, so it does appear that its this mod that created the problem.<
muzishun
10 February 2008, 17:07
Nice catches. There isn't actually any user input on post_info.asp, as the inserted text is retrieved via another recordset. However, that is likely still what's causing the error. I have updated the zip file at SnitzBitz. There are changes in two places of post_info.asp. The data coming from the first SELECT statement are sanitized before they are INSERTed back into the POST_HISTORY table. I don't have a forum running on a MySQL database, so please let me know if this fixes the error.<
thelodger
10 February 2008, 18:13
Which file have you changed? or is it all of them? just saves me searching.<
bobby131313
10 February 2008, 19:21
I've been considering this mod for a few days now, but I have a concern. Sometimes members post when they're angry and post things they may not mean, then they edit them to make the post more civil. I know I've done it.
With the icon there, I would be tempted to always look, and I'm not sure that I really want to read something that they thought better of and changed. I'm sure this is a great mod, I'm just having a little personal dilemma involving pros and cons of it.
Does any of this make sense or am I nuts?<
muzishun
10 February 2008, 19:50
thelodger. The only change is in post_info.asp. As I mentioned above, the only change is in the INSERT statements, where I put the data retrieved from the DB through the ChkString function to sent it to the POST_HISTORY table.
bobby, I can understand your dilemma. However, I see your example as being a reason to install this, rather than something that would prevent me from doing so. With this MOD installed, there can be no question about what someone says, even if they change it later. That being said, each person should decide what MODs and add-ons are most appropriate to their forum.
Hope that helps.<
bobby131313
10 February 2008, 20:31
Yeah, there's certainly more than one way to look at it. I would just hate to read something nasty written by a great member in a bad moment, then not be able to forget it. <
muzishun
11 February 2008, 00:10
I definitely understand that. My general thought is that unless I have a specific need to view a post's history, I won't bother. Will that always be the case? Probably not; I am sure that I'll occasionally succumb to curiosity. However, I think once the "newness" of the feature wears off, it probably won't even come into play until it's needed.<
pitstraight
11 February 2008, 07:47
That's amazing muzishun, it works great but there's one thing:
The first entry in the history had the wrong time for me. Any idea why ?<
muzishun
11 February 2008, 10:30
I have noticed some issues with the times as well. When an admin edits a post, no update to the actual last edit time is made in the REPLY or TOPICS table. Because of that, the POST_HISTORY table uses either the current date (from the now() function) or the entry in the LAST_EDIT field of the REPLY or TOPICS table. I am working on a way to make this a little more reliable, but it will remain as-is for now. Since the primary focus of the MOD is retaining the history of the post, I am slightly less concerned with a timestamp bug that is relatively benign.<
pitstraight
11 February 2008, 14:24
Well, the primary focus is to record the time and contents when someone edits a post but if it's only an admin then that's cool.<
thelodger
13 February 2008, 15:29
Cheers muzishun, everything seems to be working fine, sorry its been a while reporting back, been kinda busy.<
muzishun
13 February 2008, 18:51
Thanks. Glad it is working for you. <
Carefree
14 April 2008, 07:51
Not sure whether this is a bug in the mod, but when you view history of a post with a |list|, the current version is properly parsed, but the old version is not. You get |ul| for the |list| entry, and |li| for the |*| entries.<
muzishun
14 April 2008, 15:20
Thanks for pointing that out. I will add it to my list of things to check for. Right now I am fairly bogged down, and the Password Salting MOD really needs my attention first, but I will keep this in mind next.<
Lon
16 April 2008, 11:06
This MOD works great. Thanks.<
muzishun
17 April 2008, 12:35
Glad you like it.<
bobby131313
22 March 2009, 20:56
Got around my moral dilemma and installed it. Works awesome. Thanks!
I am gonna see if I can tweak it though so that it doesn't record mod and admin edits.
I'm sure this is a great mod, I'm just having a little personal dilemma involving pros and cons of it.
<
<