XF 1.1 Converting Media Tags from vb3

[Kintaro]

In vb3 I use AME Automatic Media Embeding.

The problem is that AME have the possibility to restore link removing [AME] tags but it will restore it with [url] tags... plus some tags are like [AME=youtube]9MkB6NkQscI[/AME] and it will restore it like

[url]9MkB6NkQscI[/url]


do you suggest to maintain AME tags and replace them in a second moment?

 

[Paul B]

You can try doing a simple SQL query to replace identical strings in the post table.

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

So in your case it would be:

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

Take a backup of the post table first though before you try that.

 

[Kintaro]

oh ok, I was editing asking the "replace thing"

thank you

 

[Kintaro]

Here I am again

I was wrong with the tags, they are not simple like [ame=youtube]

I played a little with regex into mysql replace query for extract and replace from vb3_post.pagetext something like this:

[ame="http://www.youtube.com/watch?v=rH9w5M1afc&feature=g-all-u&context=G240730aFAAAAAAAADAA"]title      - YouTube[/ame]

into this:

http://www.youtube.com/watch?v=rH9w5M1afc

But I fail!
I need to study more regex!!
Can you help me with this?

p.s. In this way when I'll import in xenforo it will embed right?

 

[Jake Bunce]

For a replacement like that you can use this addon:

http://xenforo.com/community/threads/post-content-find-replace.6548/

Here are settings for your replacement. I tested this using the example in your post:

Quick Find: [ame

Regular expression: #\[ame="http:.+youtube.+v=(\w+)(&.+)?"\].+\[/ame\]#siU

Replacement String: [media=youtube]\1[/media]

 

[Kintaro]

Wow I totally missed it! ...and is a Kier addon!
I need to work on my search skill.

p.s. Thank you for the regex Jake.

 

[Rob]

how would i match these:-
[ url = "http://www.youtube.com/blah"]link text [/ url] and turn them into regular media tags?

Either that, or I need to re-enable AME and convert those tags instead. I need to do this also for amazon links and god knows what else.

I'm thinking it should be easier to work with regular [u rl] tags do you think?

 

[Jake Bunce]

how would i match these:-
[ url = "http://www.youtube.com/blah"]link text [/ url] and turn them into regular media tags?

Either that, or I need to re-enable AME and convert those tags instead. I need to do this also for amazon links and god knows what else.

I'm thinking it should be easier to work with regular [u rl] tags do you think?

Try this:

Quick Find: [url

Regular expression: #\[url="http:.+youtube.+v=(\w+)(&.+)?"\].+\[/url\]#siU

Replacement String: [media=youtube]\1[/media]

 

[Jake Bunce]

What if the tags are [ame]http://www.youtube.com/fffdgfgfs[/ame]?

This should do it:

Quick Find: [ame

Regular expression: #\[ame\]http:.+youtube\.com/(\w+)\[/ame\]#siU

Replacement String: [media=youtube]\1[/media]

 

[JABRONI]

This should do it:

Quick Find: [ame

Regular expression: #\[ame\]http:.+youtube\.com/(\w+)\[/ame\]#siU

Replacement String: [media=youtube]\1[/media]

hmm, it didn't find anything when i searched but im in a thread its on right now lol

 

[Jake Bunce]

hmm, it didn't find anything when i searched but im in a thread its on right now lol

Quick Find: [ame

Regular expression: #\[ame\]http:.+youtube\.com/watch\?v=(\w+)(&.+)?\[/ame\]#siU

Replacement String: [media=youtube]\1[/media]

 

[JABRONI]

Quick Find: [ame

Regular expression: #\[ame\]http:.+youtube\.com/watch\?v=(\w+)(&.+)?\[/ame\]#siU

Replacement String: [media=youtube]\1[/media]

I know im being a nuisance but now i get this error lol

 

[Jake Bunce]

I know im being a nuisance but now i get this error lol

Admin CP -> Home -> Options -> Messages -> Maximum Media Embeds per Message

 

[JABRONI]

Admin CP -> Home -> Options -> Messages -> Maximum Media Embeds per Message

thank you so much, it really means a lot

 

[hathway]

I tried the regex to replace the ame ones, and it found a bunch, but afterwards I'm still seeing the [ame tags and no videos in the posts.

 

[Jake Bunce]

I tried the regex to replace the ame ones, and it found a bunch, but afterwards I'm still seeing the [ame tags and no videos in the posts.

Make sure you checked Save Changes, otherwise it will list the matching posts but not make any changes:

 

[hathway]

Make sure you checked Save Changes, otherwise it will list the matching posts but not make any changes:

View attachment 29699

I modified the regex slightly and was able to find the rest:

#\[ame="?http:.+youtube.+v=(\w+)(&.+)?"?\].+\[/ame\]#siU

 

[JulianD]

I'm sorry to bring this thread up after so many months but I have recently imported my 5M forum and I'm having some trouble converting all these AME links.

I can't get to match this one with the expressions above.

[ame]http://www.youtube.com/watch?v=mJb_I0y-Da8[/ame]
[ame="http://www.youtube.com/watch?v=KbWgUO-Rqcw"]http://www.youtube.com/watch?v=KbWgUO-Rqcw[/ame]
[ame="http://www.youtube.com/watch?v=-3X00EPzphA"]http://www.youtube.com/watch?v=-3X00EPzphA[/ame]
[ame]http://www.youtube.com/watch?v=QfOmCmc-syc[/ame]

[ame]http://www.youtube.com/watch?v=WUE7nGPfaa4#[/ame]
[ame]http://www.youtube.com/watch?v=gPjkUXXH5V4#[/ame]

Any help would be appreciated @hathway @Jake Bunce =)

 

[Jake Bunce]

@JulianD

Quick Find: [ame

Regular expression: #\[ame(=".+")?\]http://www\.youtube\.com/watch\?v=([a-zA-Z0-9_\-]+?).*\[/ame\]#siU

Replacement String: [media=youtube]\2[/media]

 

[JulianD]

@JulianD

Quick Find: [ame

Regular expression: #\[ame(=".+")?\]http://www\.youtube\.com/watch\?v=([a-zA-Z0-9_\-]+?).*\[/ame\]#siU

Replacement String: [media=youtube]\2[/media]

Thank you very much Jake! It worked!