SQL replace - Help

[Fuhrmann]

Hello. Recently i just used IMPEX to import all my phpbb forumto vbulletin forum.

But, a error ocurred. All my topics that have bbcodes [spoiler], [imgsize], doesnt work. They all are like this:

[spoiler:127u0gij]
[imgsize:12dd354]

All that i want to know, is that if i can make a SQL replace in my phpadmin panel, to replace all this information to the correct:

[spoiler:127u0gij] ---> [spoiler]
[imgsize:12dd354] ---> [img]

There is a way? I will be glad if someone help me. Thanks!

[borbole]

Originally Posted by Fuhrmann

Hello. Recently i just used IMPEX to import all my phpbb forumto vbulletin forum.

But, a error ocurred. All my topics that have bbcodes [spoiler], [imgsize], doesnt work. They all are like this:

[spoiler:127u0gij]
[imgsize:12dd354]

All that i want to know, is that if i can make a SQL replace in my phpadmin panel, to replace all this information to the correct:

[spoiler:127u0gij] ---> [spoiler]
[imgsize:12dd354] ---> [img]

There is a way? I will be glad if someone help me. Thanks!

Can you try my mod here. It does just that.

https://vborg.vbsupport.ru/showthread.php?t=239234

But if you would rather do that without a plugin but with a sql query, let me know and I will post the query here.

[Fuhrmann]

Originally Posted by borbole

Can you try my mod here. It does just that.

https://vborg.vbsupport.ru/showthread.php?t=239234

But if you would rather do that without a plugin but with a sql query, let me know and I will post the query here.

Weel, first, thanks for the help. I cant use this mod because the "weird caracteres" are not the same. Look, every post have diferents caracters, just like this:

Post1 - > [spoiler:dasda]
Post2 -> [spoiler:12344]
Post3 -> [spoiler:11111]

I will thank you if you post the query to do this. Oh, thanks again.

[borbole]

Originally Posted by Fuhrmann

Weel, first, thanks for the help. I cant use this mod because the "weird caracteres" are not the same. Look, every post have diferents caracters, just like this:

Post1 - > [spoiler:dasda]
Post2 -> [spoiler:12344]
Post3 -> [spoiler:11111]

I will thank you if you post the query to do this. Oh, thanks again.

You can use whatever words you want and not only weired characters and symbols.

Anyway, use this query

UPDATE post SET pagetext = replace(pagetext, ?text you want to replace?, ?replacament text?);

And replace text you want to replace?, ?replacament text? accordingly.

If your db tables use a prefix, then you should include it in the query by appending it to the table name.

[Fuhrmann]

Originally Posted by borbole

You can use whatever words you want and not only weired characters and symbols.

Anyway, use this query

UPDATE post SET pagetext = replace(pagetext, ‘text you want to replace’, ‘replacament text’);

And replace text you want to replace’, ‘replacament text’ accordingly.

If your db tables use a prefix, then you should include it in the query by appending it to the table name.

As you see, my problem is that the weird caracteres are not the same in all posts. I dont want to view the thread, copy the "[spoiler:dasda]" and then make a query.

I have 200.000 posts in my forum, for at least 100.000 have the spoiler tag, for example, and, every post have the "[spoiler:something here]", but never repeat. It is always diferente.

The query i was looking for are some "regex" replace. This is possible? Look for some word that is not always the same throug a replace query in SQL...

Sorry about my english!

[borbole]

I think we have a misunderstanding in communication. The query I posted above does exactly what you asked about in the very first post. It replaces [spoiler:127u0gij] with [spoiler] or [imgsize:12dd354] with [img]. It works like a charm. I hve used that many times for similiar purposes when converting the forums of some of my clients.

[Fuhrmann]

Yes, i know that works, i already make some query like this. But our "misunderstanding" is i will have to do 100.000 querys to clear ALL this "spoilers" and "imgsizes" tags wrongs.