Editpost.php addon

[MischiefThought]

I think this would be a great addition to editpost.php:

When a user edits a post, it shows Last edited by user on 11-30-2003 at 08:02 PM

What would be cool, is if it looked like this

Last edited by Tikal on 11-30-2003 at 08:02 PM (Click here to see what the user edited)

If they click the link, a window pops up showing the message BEFORE the user edited the post, and shows what he/she edited it to.

This would be GREAT for my site, because people have a bad habbit of editing posts.

[MindTrix]

Could be a nice idea mate, wouldnt mind seeing it myself

[assassingod]

This would be impossible. Editing a post updates the previoud text, erasing the previous data. You would have to have 2 seperate columns for this but it would involve alot of hacking and too many queries to think off.

[sabret00the]

actually you could probably do it in 2 queries with one additional table set up

$DB_site->query("SELECT text FROM proper table WHERE postid = $postid");
then just another to find if theirs already data in there? if not then do another to edit the results of the first query. not to hard but meh, i could be wrong.

[assassingod]

Well, what I can think of, is when UPDATE'ing the post, you would use some seperate queries to insert old data into another column, then SELECT the old data. BUT, you can't pinpoint what was changed.

But I can't think how would you insert the old data without editing newreply/newthread to insert pagetext into the seperate column. All too query-intense IMO