T
TheGroove
Guest
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:
HTML:
This is the query I'm attempting to use
SQL:
...
Read more
Continue reading...
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:
Code:
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...