Search into bbcode

[jesusmp]

Hi,

(Sorry, i dont speak english)

Is possible to search within (into) bbcode? For example: [img]

i'd like to search the messages with this urls:

(img)http://www.mysite.com/fotos/*.*.jpg(/img)

I need edit those urls to other server.

[Jose Amaral Rego]

I tried and it does work, I guess another option would do the same like a query.
Admin CP => Styles & Templates => Replacement Variable Manager => Add New Replacement Variable

Search for Text -> mysite.com
Replace with Text -> newsite.com

Click save - done.

[jesusmp]

Hola, José M., creo que hablas español.

El tema es que un usuario tiene unas 1.000 fotografías en sus mensajes con [img] alojadas en urls de este tipo:

http://personal.wanadoo.es/documentos/fotos/*.*

Pero ese proveedor lo ha dejado y ha subido las mismas fotos a otro hosting tal que así tiene las urls ahora esas fotos:

http://personales.ya.com/animales/fotos/*.*

¿Funcionará lo que dices ahora que lo he explicado con más detalle? El inglés no se me da bien, la verdad. Esta persona no tiene acceso ya al servidor antiguo por lo que soluciones con htaccess no es posible.

[bmc]

This is an English-speaking forum. If you expect to receive support from other customers, you should post your query in English so we may assist you.

[Jose Amaral Rego]

It is my name that made him think I was spainish...I am not, but I am Portugese and it is close enough for me to understand even if I can not read spainish/portugese. I just speak out the word and it it sounds the same I could figure out what he is saying. He just asking if I spoke spainish and will repond in both languages to help him and english members.


-----------------------------
Use this to translate to english

http://translate.google.com/translate_t

[calorie]

Untested, backup first...

# replaces http://personal.wanadoo.es/documentos/fotos/ with http://personales.ya.com/animales/fotos/ in the post and postparsed tables
# use UPDATE TABLE_PREFIXpost ... and UPDATE TABLE_PREFIXpostparsed ...  if you set a vB TABLE_PREFIX
# consider rebuilding post, thread, and forum info when done with the queries

UPDATE post SET pagetext = REPLACE(pagetext, 'http://personal.wanadoo.es/documentos/fotos/', 'http://personales.ya.com/animales/fotos/');

UPDATE postparsed SET pagetext_html = REPLACE(pagetext_html, 'http://personal.wanadoo.es/documentos/fotos/', 'http://personales.ya.com/animales/fotos/');

[jesusmp]

Sorry, bmc, my english is very bad

Thank you very much José M. and calorie. I am going to study this solution although it is a little dangerous for me.

[jesusmp]

I have other question:

I'll to replace each URL editing each message one by one.

Is possible to search all the messages of a user that contain [img]? This user have 3.000-3.500 messages.