Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Saving an unedited version of T_MESSAGE
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 20 December 2002 :  07:31:20  Show Profile  Visit MarcelG's Homepage
Hi there,

I am currently rebuilding the Snitz forum version 3.3.05 to let it function as a rather simplified CMS system. The reason for me to do that, instead of building it from scratch, is that I am not very known to ASP.
However, I think that with a few modifications I can let the collegues at my department work with the Snitz forum, without them realizing that it is in fact a forum engine, instead of a CMS engine.

Therefore I have created some new display asps, named content.asp and content-short.asp.
content.asp shows the T_MESSAGE, with an applied stylesheet, and in a standard format.
Next to that it shows a table at the top with the author (T_AUTHOR), creation date and time (T_DATE), category (the forum it's in), the document number (the topic ID), and since this morning (see the other topics by me) the date/time of the last edit action (T_LAST_POST) and the name of the person that has done that (T_LAST_POST_AUTHOR).

ALl in all, we now have a very simple and fast way for the authors at my department, who don't know scratch of ASP/HTML etc, to create, update and remove webdocuments.
I use the RTE mod, so they can use a WYSYWYG style of editing, and I've included the Upload mod, so they can upload pictures and attachments to go along with their documents.

But, - yes, this was bound to happen ; a but! - now I am looking for a way of actual version control.
In my opinion version control should

  • Register who edited (done)

  • Register when it was edited (done)

  • Preserve a copy of the unedited text for backup purposes (the challenge)


As we don't use the snitz forum as a forum in this case (replies are renamed to remarks for instance), I thought it might be an idea to use the T_REPLY field in the database for that purpose.
So when a author edits a message, the old message (T_MESSAGE prior to updating) should be entered in the database as a reply to the topic, prefixed with something like "This version, created by the old T_AUTHOR at old T_DATE, as replaced by T_LAST_POST_AUTHOR at T_LAST_POST" in the top of the message.
After that, the edited message is entered in the databse as the T_MESSAGE.

In that way, you can see a chronological order of changes, with the name of the changer etc.

I think that the idea can work, but I have no clue on how to do it...
Maybe someone has a suggestion ?

BTW, we use NT authentication and an access database. The access database is the original version, with no renamed of added fields.

Thanks in advance,

portfolio - linkshrinker - oxle - twitter

Edited by - MarcelG on 20 December 2002 07:33:32

GauravBhabu
Advanced Member

4288 Posts

Posted - 20 December 2002 :  07:37:41  Show Profile
I will suggest you to use the current version. It is better performance wise as well as feature wise and you will have better support for the current version.
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 20 December 2002 :  10:13:31  Show Profile  Visit MarcelG's Homepage
GauravBhabu, I know.....but the new version doesn't have the RTE

portfolio - linkshrinker - oxle - twitter
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 20 December 2002 :  17:01:49  Show Profile  Visit MarcelG's Homepage
BTW, is there an updated version of the RTE mod for 3.4 or even 4.0?

portfolio - linkshrinker - oxle - twitter
Go to Top of Page

GauravBhabu
Advanced Member

4288 Posts

Posted - 20 December 2002 :  17:05:57  Show Profile
I don't think so.
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 24 December 2002 :  07:42:36  Show Profile  Visit MarcelG's Homepage
quote:
Originally posted by GauravBhabu

I will suggest you to use the current version. It is better performance wise as well as feature wise and you will have better support for the current version.



GauravBhabu, I think that my question than is more a ASP general question...I simply don't know enough of ASP to create a function which moves the content of one database entry to another database entry...any suggestions on where I can find the basics on that area ?
(Something like www.asp-and-databases-for-beginners.com ?)

portfolio - linkshrinker - oxle - twitter
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 27 December 2002 :  14:50:21  Show Profile  Visit MarcelG's Homepage
Anyone ? I'd really appreciate a hint of some sort, to get me going in the right direction.

portfolio - linkshrinker - oxle - twitter
Go to Top of Page

Nikkol
Forum Moderator

USA
6907 Posts

Posted - 27 December 2002 :  15:20:49  Show Profile
www.4guysfromrolla.com

Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~
Go to Top of Page

@tomic
Senior Member

USA
1790 Posts

Posted - 27 December 2002 :  15:32:35  Show Profile  Visit @tomic's Homepage  Send @tomic an ICQ Message
RTE is asking for trouble. It's probably why no one is rushing out a version for 3.4. I made a CMS for 3.4 and I have no intention of adding RTE. There's just no point really and the security risks far outweigh any benefit.

@tomic

SportsBettingAcumen.com
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts

Posted - 28 December 2002 :  13:04:02  Show Profile  Visit MarcelG's Homepage
Is it really so dangerous to use the RTE ? I didn't know that it was thát dangerous...
We use it in an intranet environment, with a selected group of users (125), who all are authorized on the intranet site by their NT domain accounts, which are also used within the Snitz environment.
Does that limit the risk ?

BTW: Nikkol, thanks for the link...I see I have some homework

portfolio - linkshrinker - oxle - twitter

Edited by - MarcelG on 28 December 2002 13:04:40
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.45 seconds. Powered By: Snitz Forums 2000 Version 3.4.07