MySQL Request - changing BBCODE in Messages

[kankan]

Hello,

I have just migrated my PunBB messages to a fresh Xenforo set up.
I got some tweaked BBCode in my PunBB forum like : [imgz]picture.jp[/imgz] (to make a thumbnail of the picture) and (to center the image)
Of course those BBcodes are not understood by Xenforo and asking myself if i could run a MySQL request to parse the message database and automatically change those BBCodes from [imgz] to

As i am not very involved into MySQL, how do i have to write the command ?

Kindest regards,

Nicolas

 

[cclaerhout]

yes sorry, mixed up during the edition of my post
please read:

[media=youtube]m6XEB9Aj9KA[/media]

That's XenForo output isn't it? But what is your source?

 

[kankan]

sorry again :
original input :

[video]http://www.youtube.com/watch?v=m6XEB9Aj9KA&feature=related[/video]

 

[cclaerhout]

I think this regex will work in most of the case:

#\[video\](?:http://)?(?:www\.)?(youtube)\.\w{2,3}.+?v=(.+?)(?:&.+?)?\[/video\]#ui

Replacement:

[media=\1]\2[/media]

 

[cclaerhout]

Updated sorry I forgot a capturing bracket

 

[kankan]

Seems good while previewing
While saving the request the system returns this error (sorry might be not the right term in English as i am translating)

"The message should not contain more than 5 pieces of media"

 

[cclaerhout]

Go here:

{yourboard}/admin.php?options/list/messageOptions

And change this option : "Maximum Media Embeds per Message"

 

[kankan]

Hey thanks Cedric, it went allright

 

[kankan]

On another hand, when i receive an alert here, there is a popup displayed at the bottom of the screen, is that a default option ?
Regards

 

[cclaerhout]

On another hand, when i receive an alert here, there is a popup displayed at the bottom of the screen, is that a default option ?
Regards

Can you take a screenshot?