XF 1.4 Remove "Edited by moderator" from all posts?

[Lile]

I ran Post Content Find / Replace on some smilies, and after that all the posts that were edited using that addon now include the bit about being last edited by a moderator.

Is there a simple (or slightly complex, whatever) way to clear out all the last edited by a moderator texts from the forum posts?

Some kind of a MySQL query?

 

[Paul B]

It is stored in the post table: xf_post.last_edit_date, xf_post.last_edit_user_id, xf_post.edit_count

Setting last_edit_date to 0 will remove the text.

UPDATE xf_post
SET last_edit_date = 0

Always take a backup before doing any alterations to the database.

 

[AndyB]

This add-on will remove the Last Edited functions:

https://xenforo.com/community/resources/remove-last-edited.2558/

 

[PASS]

It is stored in the post table: xf_post.last_edit_date, xf_post.last_edit_user_id, xf_post.edit_count

Setting last_edit_date to 0 will remove the text.

UPDATE xf_post
SET last_edit_date = 0

Always take a backup before doing any alterations to the database.

So I run the query on all three tables? Will it remove just the one that say last edited by a moderator or all of them?

 

[PASS]

I tired running that query on the database and it didn't do anything.

 

[PASS]

I got it working. I only wanted to remove messages that were last edited by myself after I ran the post replace.

This worked!

UPDATE xf_post SET last_edit_date = '0' WHERE last_edit_user_id = '1';

Then I ran this to clear the edit history.

UPDATE xf_post SET edit_count = '0' WHERE last_edit_date = '0';

Then this to clear the last id with no edit history

UPDATE xf_post SET last_edit_user_id =  '0' WHERE edit_count =  '0';