XenForo Query to replace Twitter bbcode

[TheGroove]

I'm trying to convert all Twitter bbcode posts into simple links before disabling it.

This is how it parses out by default the code after the full link is added
HTML:

https://twitter.com/i/web/status/1597713774244306944
HTML:

[MEDIA=twitter]1597713774244306944[/MEDIA]

This is the query I'm attempting to use
SQL:

UPDATE xf_post SET message = REPLACE(message, '[MEDIA=twitter]', 'https://twitter.com/i/web/status/[URL]');
                                    
UPDATE xf_post SET message = REPLACE(message, '[/MEDIA]', '[/URL]');

...

Read more

Continue reading...