Converting youtube clips embedded with BB-code to xF

[DoctorWatsOn]

Before vB introduced youtube embedding, I was using BB-code and when I imported my vb4 data into xF it didn’t convert these, so posts just show:

[youtube]xp9Gm-aRe5A&hl[/youtube]
OR
[YOUTUBE]it-gPAhFq1c[/YOUTUBE]

Is there anyway these can be converted to make them display?

 

[Paul B]

You can run some SQL queries to update the post table.

UPDATE xf_post SET message = REPLACE(message, '[youtube]', '[media=youtube]');
UPDATE xf_post SET message = REPLACE(message, '[/youtube]', '[/media]');

Make sure you take a backup first....just in case.

 

[bambua]

Before vB introduced youtube embedding, I was using BB-code and when I imported my vb4 data into xF it didn’t convert these, so posts just show:

[youtube]xp9Gm-aRe5A&hl[/youtube]
OR
[YOUTUBE]it-gPAhFq1c[/YOUTUBE]

Is there anyway these can be converted to make them display?

You've got to use regular expressions to do it, but Kier released an addon to do this: http://xenforo.com/community/threads/post-content-find-replace.6548/#post-96086

 

[DoctorWatsOn]

WOW that was quick.

Thanks guys, I'll go take a look.

 

[steven s]

I'm going to need this too.
If only there was a way to bookmark these posts for future use. (Other than saving bookmarks with your browser.)

 

[Elizabeth]

I'm going to need this too.
If only there was a way to bookmark these posts for future use. (Other than saving bookmarks with your browser.)

Just click "Watch Thread" without email notification.

 

[DoctorWatsOn]

You can run some SQL queries to update the post table.

UPDATE xf_post SET message = REPLACE(message, '[youtube]', '[media=youtube]');
UPDATE xf_post SET message = REPLACE(message, '[/youtube]', '[/media]');

Make sure you take a backup first....just in case.

Will that work, because the [youtube] tags only include the video ID, whereas xF's [ media=youtube] tags use the whole URL?

 

[Paul B]

I'm going to need this too.
If only there was a way to bookmark these posts for future use. (Other than saving bookmarks with your browser.)

Why not update the BB Code and the post table on your forum now?

That's what I've done so when it comes to switching I won't need to update anything.

 

[Paul B]

whereas xF's [ media=youtube] tags use the whole URL?

Once you add the URL, the software strips out everything except the video ID.

For example, I just added this using the media button on the editor and this is the result:
[media=youtube]8gFgs_To9GY[/media]

 

[DoctorWatsOn]

Why not update the BB Code and the post table on your forum now?

That's what I've done so when it comes to switching I won't need to update anything.

Is this easier than running the SQL queries?

Not that I know how to do either.

 

[Paul B]

Is this easier than running the SQL queries?

Not that I know how to do either.

Well you will have to run the queries whether you do it on your current database or after you convert as all of the historic post content will have to be updated.

I just prefer to get as much done beforehand so there is less to do after I switch.

 

[steven s]

Just click "Watch Thread" without email notification.

I guess by default, every thread I posted in is watched.

 

[Ray]

You can run some SQL queries to update the post table.

UPDATE xf_post SET message = REPLACE(message, '[youtube]', '[media=youtube]');
UPDATE xf_post SET message = REPLACE(message, '[/youtube]', '[/media]');

Make sure you take a backup first....just in case.

That works the best.
Make sure you run both for youtube and YOUTUBE

 

[DoctorWatsOn]

Well you will have to run the queries whether you do it on your current database or after you convert as all of the historic post content will have to be updated.

Oh right, I'll put that on the 'to do list' for my techie before we do the live site upgrade, thanks again.