XF 2.0 Converting Twitter links from old forum into proper format

[orthopug]

I just moved over to Xenforo from Mybb. Right now my forum has a lot of Twitter links in this format:

https://twitter.com/capitalweather/status/1255596050162860037

It only displays a clickable link. If I click Edit on a post with such a link and then hit save, Xenforo adds the media tags to the Twitter link:

[MEDIA=twitter]1255596050162860037[/MEDIA]

The tweet then shows correctly. Is it possible to convert all existing Twitter links on my forum into the proper media format? I tried to Rebuild Threads but that didn't do it.

 

[arn]

How big is your database?

You're probably going to have to use a regex replacement to rewrite them.

Unmaintained - Post Content Find / Replace

This is a very simple add-on I put together in order to allow an administrator to do a regular expression find and replace in the content of all posts. It was written in order to find all instances of a custom BB code tag for embedding YouTube...

xenforo.com

2.1 version: https://xenforo.com/community/resources/post-content-find-replace.5748/

 

[orthopug]

Database is big: 1.5 gig for the posts table alone.

 

[Mr Lucky]

How big is your database?

You're probably going to have to use a regex replacement to rewrite them.

Unmaintained - Post Content Find / Replace

This is a very simple add-on I put together in order to allow an administrator to do a regular expression find and replace in the content of all posts. It was written in order to find all instances of a custom BB code tag for embedding YouTube...

xenforo.com

2.1 version: https://xenforo.com/community/resources/post-content-find-replace.5748/

Agreed, it’s easy enough to search and replace the Twitter url with opening media tag, but adding the closing tag not so straightforward.

 

[arn]

You also need to handle the URL bbcodes too I think. Those pasted twitter links have a URL bbcode around them? If so, you need to match those too.

This is a first draft. Untested.

It only looks for twitter links wrapped in URL bbcode.

regex:

/\[url\]https?:\/\/twitter\.com\/(?:\#!\/)?(\w+)\/status(es)?\/(\d+)(\?s=\d+)?\[\/url\]/mi

replace

[MEDIA=twitter]\3[/MEDIA]

Use at your own risk!

Here's what it matches: https://regex101.com/r/Bk0yLv/1

arn

 

[orthopug]

You also need to handle the URL bbcodes too I think. Those pasted twitter links have a URL bbcode around them? If so, you need to match those too.

This is a first draft. Untested.

It only looks for twitter links wrapped in URL bbcode.

regex:

/\[url\]https?:\/\/twitter\.com\/(?:\#!\/)?(\w+)\/status(es)?\/(\d+)(\?s=\d+)?\[\/url\]/mi

replace

[MEDIA=twitter]\3[/MEDIA]

Use at your own risk!

Here's what it matches: https://regex101.com/r/Bk0yLv/1

arn

Is there a way to do this find/replace in command line? My database is too big so the Find/Replace add-on crashes.

I tried dumping my xf_post.sql table and running this:

cat xf_post.sql | sed -e "s/\[url\]/\[MEDIA=twitter\]/" -e "s/\[\/url\]/\[\/MEDIA\]/" | sed -E "s/(\[MEDIA=twitter\]).*status.(.+\[\/MEDIA\])/\1\2/" | sed -E "s/(\[MEDIA=twitter\])*[[:space:]|\/]*(\[\/MEDIA\])/\1\2/" > new_xf_post.sql

But it didn't work and ended up deleting about 10% of the database.

 

[arn]

You can use mysql directly

MySQL :: MySQL 8.0 Reference Manual :: 14.8.2 Regular Expressions

dev.mysql.com

not sure how quickly that will work though

arn