XF 1.2 Update Quote info?

[Valter]

Hi,

is there a way to update quote info in XF? I would like to have actual usernames shown in quote blocks.

 

[Amaury]

Quote blocks already show actual usernames, so I'm not sure what you're asking.

 

[Valter]

Not if username is changed in the meantime.

 

[Martok]

Not if username is changed in the meantime.

You'll have to use something like Post Content Find / Replace to find all instances of the old username and change them with the new one.

 

[Paul B]

It can also be done with a simple query:

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

 

[Valter]

I know it can be done by running that query but it must be done one by one. Some script which would read post_id from the quote block then check for current user_id and update username in quote block would be nice. But it's OK, I can live with this...