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

Lile

New member
#1
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?
 

Brogan

XenForo moderator
Staff member
#2
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.

Code:
UPDATE xf_post
SET last_edit_date = 0
Always take a backup before doing any alterations to the database.
 

PASS

Active member
#4
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.

Code:
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

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

This worked!
Code:
UPDATE xf_post SET last_edit_date = '0' WHERE last_edit_user_id = '1';
Then I ran this to clear the edit history.

Code:
UPDATE xf_post SET edit_count = '0' WHERE last_edit_date = '0';
Then this to clear the last id with no edit history

Code:
UPDATE xf_post SET last_edit_user_id =  '0' WHERE edit_count =  '0';
 
Last edited:
Top