Post Content Find / Replace 1.0.0

[rveram]

I did a vbulletin to xenforo import, and i want to replace this bbcode:

From:
[GR]f03ff81[/GR]

To:
http://www.goear.com/listen/f03ff81

I was wondering if its possible to do this with this addon and any help will be greatly appreciated.

Thanks.

 

[Burp]

That's an easy one.

Quick Find:
[GR]f03ff81[/GR]

Regular Expression:
#\[gr]f03ff81\[\/gr\]#siu

Replacement String:
http://www.goear.com/listen/f03ff81

 

[Burp]

If you want to make it universal for more of that sort of codes u can use

Quick Find:
[GR]

Regular Expression:
#\[gr]([0-9a-z]+)\[\/gr\]#siu

Replacement String:
http://www.goear.com/listen/\1

 

[rveram]

If you want to make it universal for more of that sort of codes u can use

Quick Find:
[GR]

Regular Expression:
#\[gr]([0-9a-z]+)\[\/gr\]#siu

Replacement String:
http://www.goear.com/listen/\1

Thank you!!! I'll give it a try

 

[Burp]

As I was told, the regex could be a bit better:

#\[gr]([0-9a-z]+)\[/gr]#siu

but the original also works fine.

 

[rveram]

As I was told, the regex could be a bit better:

#\[gr]([0-9a-z]+)\[/gr]#siu

but the original also works fine.

The following worked for me:


7800 posts edited and working

Thanks a lot for your help!! I appreciate it.

 

[Burp]

Glad I could help

I see that you have put it between media tags, nice job.

 

[rveram]

Glad I could help

I see that you have put it between media tags, nice job.

Yes I figured that out, in my vbulletin site I had a custom bbcode for goear, and this bbcode was activated with the [GR] [/GR] tags.

I created a new bb code media site for goear

Site URL: http://www.goear.com
Match URLS: http://www.goear.com/listen/{$id}
Embed HTML : <iframe width="580" height="115" src="http://www.goear.com/embed/sound/{$id}" marginheight="0" align="top" scrolling="no" frameborder="0" hspace="0" vspace="0" allowfullscreen></iframe>

And with the code you shared with me I edited around 7800 posts

Thanks again.

 

[cdub]

The first row has to be replaced by the second?

Sorry no...

[IMG]http://forums.studentfilms.com/groupee_common/emoticons/icon_razz.gif[/IMG]

Is one of the examples of code throughout my forum from the old posts from groupee... using the information below the above below would be replaced by the "" emoticon.

/groupee_common/emoticons/icon_smile.gif = : )
/groupee_common/emoticons/icon_frown.gif = : (
/groupee_common/emoticons/icon_redface.gif = : o (lowercase "O")
/groupee_common/emoticons/icon_biggrin.gif = : D
/groupee_common/emoticons/icon_wink.gif = ; )
/groupee_common/emoticons/icon_razz.gif = : p
/groupee_common/emoticons/icon_cool.gif = : cool :
/groupee_common/emoticons/icon_rolleyes.gif = : rolleyes :
/groupee_common/emoticons/icon_mad.gif = : mad :
/groupee_common/emoticons/icon_eek.gif = : eek :
/groupee_common/emoticons/icon_confused.gif = : confused :

 

[cdub]

And replace "’" to '

 

[Burp]

Oke, let's make things clear.

[IMG]http://forums.studentfilms.com/groupee_common/emoticons/icon_razz.gif[/IMG]

Needs to be replaced by:
:p

If that's the case then:

Quick Find:

[img]http://forums.studentfilms.com/groupee_common/emoticons

Regular Expression:

#\[IMG]http://forums\.studentfilms\.com/groupee_common/emoticons/icon_razz\.gif\[/IMG]#siu

Replacement String:

:p

You can figure those other smileys out yourself now I supose?

Always test first before saving.

 

[cdub]

What is the Regular Expression stuff?

 

[cdub]

Oke, let's make things clear.

[IMG]http://forums.studentfilms.com/groupee_common/emoticons/icon_razz.gif[/IMG]

Needs to be replaced by:
:p

If that's the case then:

Quick Find:

[img]http://forumsstudentfilms.com/groupee_common/emoticons

Regular Expression:

#\[IMG]http://forums\.studentfilms\.com/groupee_common/emoticons/icon_razz\.gif\[/IMG]#siu

Replacement String:

:p

You can figure those other smileys out yourself now I supose?

Always test first before saving.

I presume it needs to be "forums.studentfilms" in the first one?

 

[Burp]

Yes, sorry. I forgot the .

Updated my post

 

[Burp]

And replace "’" to '

This has to do with the import as I read here. Don't know if it is the smart way to replace with this tool but should be possible I supose

 

[cdub]

And replace "’" to '

Awesome the emoticon swap worked great. How do I do the above? The regular expression thing makes no sense to me but it must be a mysql thing that I don't know about.

 

[maxicep]

Is possible replace all old vbulletin-vbeo URL's to new xenforo url structure in the old posts ?

For example, i see

http://www.domain.com/category-name/thread-title-12345.html
to =>
http://www.domain.com/forum/threads/thread-title.12345/

From first url, "category-name" string is a variable and will be removed so replaced with constant "/forum/threads/" string. Also, thread id mean "-12345.html" will be replaced with ".12345/"

Thanks

 

[Burp]

Yes, that is possible. I converted al the different link is our forum to the new structure.

Are there any "strange" characters in the category names or thread titles? If you provide a link (can change domain name) then I can test this for you.

Before you try this, read this post first. If you have a large forum then you would run in to some errors due to memory. If you change this according the link below then you can start

https://xenforo.com/community/threads/import-from-ipb-3-2-posts-not-parsed-at-all.39577/#post-435226

 

[maxicep]

Yes, that is possible. I converted al the different link is our forum to the new structure.

Are there any "strange" characters in the category names or thread titles? If you provide a link (can change domain name) then I can test this for you.

Before you try this, read this post first. If you have a large forum then you would run in to some errors due to memory. If you change this according the link below then you can start

https://xenforo.com/community/threads/import-from-ipb-3-2-posts-not-parsed-at-all.39577/#post-435226

I'm not sure but i have about 800K threads and 8m posts and switched from vbulletin.
I think, high possibility to have some strange characters on thread-title URL's. Forum category url's can't.

I read the small code modify for big-boards and i hope it may work. But before, i need to help for apply correct regular expression for change them. Can you please help about this ? Thanks.

For example URL:
ww w.domain.com/cep-telefonlari-genel/avea-41-mp-kamerali-nokia-808-pureviewai-satisa-sunuyor-670541.html
=>
ww w.domain.com/forum/konu/avea-41-mp-kamerali-nokia-808-pureviewi-satisa-sunuyor.670541/

 

[Burp]

I supose the complete url looks like this?

[url]http://www.domain.com/cep-telefonlari-genel/avea-41-mp-kamerali-nokia-808-pureviewai-satisa-sunuyor-670541.html[/url]

You have to provide me with the complete line that needs to be replaced