Post Content Find / Replace 1.0.0

[Floyd R Turbo]

I have a couple of easy ones. These are "hanging chads" from a conversion that I never caught and never got back to.

I have the following instances of code related to old animated smilies

This one is a broken path (not a full URL)

/DesktopModules/ActiveForums/themes/_default/emoticons/biggrin.gif

This one is the full IMG code link

[IMG]http://www.myforum.org/DesktopModules/ActiveForums/themes/_default/emoticons/whistling.gif[/IMG]

and I need to change these to

[IMG]http://www.myforum.org/data/emoticons/whistling.gif[/IMG]

The filename is not relevant, it's only this

/DesktopModules/ActiveForums/themes/_default/emoticons

that needs to change to this

/data/emoticons

It's easy to fix with
Quick

emoticons

Reg

/\/DesktopModules\/ActiveForums\/themes\/_default\/emoticons/i

repl

/data/emoticons

But that also catches the "broken" ones in a way that makes them difficult to then pinpoint - i.e. I have to look for /data/emoticons that is not part of a larger URL.

So I figure if I first fix the full URLs, all that will be left will be the broken ones.

I need the regex then for matching this

[IMG]http://www.myforum.org/DesktopModules/ActiveForums/themes/_default/emoticons/ABCDEFG.gif[/IMG]

and changing it to this

[IMG]http://www.myforum.org/data/emoticons/ABCDEFG.gif[/IMG]

where ABCDEFG is one of many .gif filenames like sad, biggrin, wink, angry, cry, blink, rolleyes, etc.

Which I THINK is this

(\[IMG\]http:\/\/www\.myforum\.org)\/DesktopModules\/ActiveForums\/themes\/_default\/emoticons(\/[\w\-]+\.gif\[\/IMG\])

and sub this

\1/data/emoticons\2

 

[Floyd R Turbo]

Follow-up...worked like a charm. I've ferreted out about 20 different iterations of how the old software linked to old smilies, getting good at the regex again....made over 6000 corrections on my test site

 

[Floyd R Turbo]

So I have a tricky one I can't quite figure out.

I have several hangers that didn't get the leading URL tacked on, like this

/Portals/0/activeforums_Attach/IMG_0171.JPG

That directory exists, so I want to just change the above to this

https://www.mysite.org/Portals/0/activeforums_Attach/IMG_0171.JPG

The problem is, there are also links that exist properly, so if I try this REGEX

/(\/Portals\/0\/activeforums_Attach\/[0-9a-zA-Z_]+\.[a-z]+)/i

and this replacement

https://www.mysite.org\1

I'll double-up all of the leading URLs on the ones that are already correct. I can fix that with a secondary find/replace for the double URL, but is there a way to exclude the already correct URLs from the regex?

 

[lulung]

I need help to replace imagehosting.org to imagehosting.cc to fix image problem on my forum which posted by members.
any help would be appreciated. thank you in advance.

 

[imno007]

I need help to replace imagehosting.org to imagehosting.cc to fix image problem on my forum which posted by members.
any help would be appreciated. thank you in advance.

Have you tried using the image in the Overview as a template, replacing "org" with "cc"? If I remember right, there's a "s20" in the links that needs to be kept as part of the address for it to work right.

 

[lulung]

Have you tried using the image in the Overview as a template, replacing "org" with "cc"? If I remember right, there's a "s20" in the links that needs to be kept as part of the address for it to work right.

so, my users usually post image from postimage.org .
it can be manually changed to postimage.cc and image will be shown.
as for example:

[IMG]https://s26.postimg.org/fuc11mjih/A18907-2869867727.1493311674.jpg[/IMG]

to

[IMG]https://s26.postimg.cc/fuc11mjih/A18907-2869867727.1493311674.jpg[/IMG]

but it would take a long time to change them one by one.
can anyone help me how?
TIA

 

[imno007]

so, my users usually post image from postimage.org .
it can be manually changed to postimage.cc and image will be shown.
as for example:

[IMG]https://s26.postimg.org/fuc11mjih/A18907-2869867727.1493311674.jpg[/IMG]

to

[IMG]https://s26.postimg.cc/fuc11mjih/A18907-2869867727.1493311674.jpg[/IMG]

but it would take a long time to change them one by one.
can anyone help me how?
TIA

 

[Cyb3r]

You need to escape the dot character, also I think he wants to change the TLD only so removing the sub-domain would be ideal.

 

[imno007]

You need to escape the dot character, also I think he wants to change the TLD only so removing the sub-domain would be ideal.

I'm almost positive I did exactly the above to correct all the postimg links on my own site, which are all working fine now, but by all means feel free to give him all the info you think he needs to do it a better way. In either case, here's my obligatory disclaimer that I take no responsibility for anything that might go wrong.

 

[djbaxter]

nice one, a good php regex tester to try if a given regex rule will work is http://www.spaweditor.com/scripts/regex/index.php (might be confusing at first but you'll love it once you learn it)

Dead link 404.

Try this: https://www.regextester.com/

 

[dknife]

I'm almost positive I did exactly the above to correct all the postimg links on my own site, which are all working fine now, but by all means feel free to give him all the info you think he needs to do it a better way. In either case, here's my obligatory disclaimer that I take no responsibility for anything that might go wrong.

It works because the period is equivalent to any character but it's not correct regex as you may have unintended consequences. You must always escape periods (and a bunch of other characters).

 

[imno007]

It works because the period is equivalent to any character but it's not correct regex as you may have unintended consequences. You must always escape periods (and a bunch of other characters).

Well, I confess to having no idea what the unintended consequences of changing the image links might have aside from them maybe no longer working (and they don't already), but maybe someone should tell him in plain English exactly what syntax he needs to do it correctly then, because I suspect that he might not find anything you're saying right now very clear.

 

[dknife]

Well, I confess to having no idea what the unintended consequences of changing the image links might have aside from them maybe no longer working (and they don't already), but maybe someone should tell him in plain English exactly what syntax he needs to do it correctly then, because I suspect that he might not find anything you're saying right now very clear.

I'm just referring to unintended consequences in using unescaped periods in general, not in particular to this request.

Escaping a character in regex means adding a backslash in front of it. s26\.postimg\.org

In using this tool and searching for the text it's irrelevant, just thought I'd explain what it means.

 

[imno007]

I'm just referring to unintended consequences in using unescaped periods in general, not in particular to this request.

Escaping a character in regex means adding a backslash in front of it. s26\.postimg\.org

In using this tool and searching for the text it's irrelevant, just thought I'd explain what it means.

That's cool. I don't claim to be a whiz when it comes to all this, but I actually do at least know what escaping a character means. I just had no idea why it was so important in this case. And the first guy was also recommending dropping part of the domain when I'd already said that, based on my own experience, keeping it as is was necessary for the links to work. So I just decided to leave it up to him to give the guy better help, but he didn't, and then you responded with more of the same talk about regex and escaping dots. Not that I'm upset with you or anyone else, I just wanted one of you to spell it out for the guy like you just did in this latest comment: helping him instead of correcting me. Hopefully he'll have figured it out by this point.

 

[lulung]

@imno007 thank you for helping me to solve my problem.
I think I know your point why you include s26; to make it specific and reduce load time.
but unfortunatelly, it always give me gateway time out. my forum has 25,529,990 messages btw.
time to make backup and do mysql query I guess.
thank you imno007!

 

[Cyb3r]

@lulung Try this after backing up your database UPDATE xf_post SET message = REPLACE(message, 'postimage.org', 'postimage.cc');

 

[Allyra]

Hi - Can someone please guide me to finding the correct inputs for Find & Replace to convert this.

old vb imported bbcode
[gpx]45212;10[/gpx]

XF2 required version of the same
[GPX=45212;10]Gpx Viewer[/GPX]

Thank you

 

[Cyb3r]

@Allyra Assuming the content of your bbcode is always digits separated by a semicolon, use this:

Find: #\[gpx\](\d+;\d+)\[/gpx\]#siU
Replace: [GPX=\1]Gpx Viewer[/GPX]

If you're not sure then use this:

Find: #\[gpx\]([^\[]+ )\[/gpx\]#siU
Replace: [GPX=\1]Gpx Viewer[/GPX]

Please make sure to backup your database before executing the code.

 

[Allyra]

Thanks @Cyb3r

 

[Allyra]

Hello friends I feel like a real numpty and need help again.

I have posts from vB4.2 imported into XF2 and all instances of single speech or double speech marks have failed to parse.

Can I use Post content find / replace to find all instances of “ ” ‘ ’ and replace appropriately.

Thank you in advance.