Post Content Find / Replace 1.0.0

[EQnoble]

mhm. I keep getting time outs as there are 13k results. So I will need to split it up. Attached are the font codes I have.

With the previous replacement I got the error that I needed to fill in a replacement text. But I just want to remove it. Is there anything I can fill in the replacement field to avoid that?

You can break the job up using more precise matching.

In some cases sure but not all. Jake Bunce posted a fix for this a long time ago which allows you to batch things without accounting for more unique signatures with your regex.

If you are comfortable making a few edits you can follow this post and set your offsets in the script,
https://xenforo.com/community/threads/import-from-ipb-3-2-posts-not-parsed-at-all.39577/#post-435226

If you would like to play with those offsets and not keep editing the script every time you would like to change offsets you can follow this edit which is the same thing except once done the options will be added to the addon ending the need for further edits,
https://xenforo.com/community/threads/post-content-find-replace.6548/page-53#post-1019961

 

[Alpha1]

The addon patch work great. It does not remember the Find Limits.

 

[Alpha1]

Thanks @EQnoble & @Nerbert I was able to remove font bbcode in 13k posts.

Does anyone know how to replace this one?
https://xenforo.com/community/threads/post-content-find-replace.6548/page-63#post-1160610
I have tested the replacement in that post and it doesn't work. No results. There should be tens of thousands or even hundreds of thousands results.

 

[Nerbert]

#(\[img]https://www\.my\-forum\.com)/forum/attachment\.php\?attachmentid=([0-9]+)&d=([0-9]+)(\[/i m g])#siu

looks like it wants to match something like

[IMG]https://www.my-forum.com/forum/attachment.php?attachmentid=123&d=222[/img]

What's that "d=(some number)" do? Do you need it for anything? Find an oldvB link and see if attachmentid and d are the same number

 

[Alpha1]

Its the date number in vbulletin I think. There is no need for it in XF.

 

[Nerbert]

I tried

\[img\](https:\/\/www\.my-forum\.com)\/forum\/attachment\.php\?attachmentid=([0-9]+).*\[\/img]

for

[IMG]https://www.my-forum.com/forum/attachment.php?attachmentid=123&d=222[/IMG]

Try it out in http://regexr.com with your actual forum url. Remember to set all flags


The replacement would be

[img]\1/attachments/\2[/img]

This is a case where you can do some real damage if you don't have the replace done right. Please take precautions!

 

[Alpha1]

This results in a server error:
Server Error

preg_match_all(): Delimiter must not be alphanumeric or backslash

 

[Nerbert]

Whenever you are writing a regex you need to backslash the following / \ . [ ] ? . ^ * and some others (look up regex escaping specail characters)

In PHP you can use other delimiter characters besides / and /, such as # and #. I always use slashes so I can test it in a JavaScript driven regex tester

 

[Nerbert]

This results in a server error:
Server Error

preg_match_all(): Delimiter must not be alphanumeric or backslash

Oh, when I copied the regex from the tester it left out the delimiters (/ and /)

/\[img\](https:\/\/www\.my-forum\.com)\/forum\/attachment\.php\?attachmentid=([0-9]+).*\[\/img]/i

 

[Nerbert]

Hold on a little. I'm worried about that regex. Let me do some testing

 

[Alpha1]

Try it out in http://regexr.com with your actual forum url. Remember to set all flags

My url has this exact format.

 

[Nerbert]

/\[img\](https:\/\/www\.my-forum\.com)\/forum\/attachment\.php\?attachmentid=([0-9]+).*?\[\/img\]/i

This is a little safer. The "?" near the end makes sure it finds the shortest possible match. Sometimes regexes overmatch and grab more than you want.

 

[Alpha1]

That matches correctly.

 

[Alpha1]

I have just completed the replacement of 26k posts with attachment links! Thanks for your help @Nerbert & @EQnoble !

 

[Triops]

I've read a lot but did not find a solution for this, although I would expect it as very common.

How do I find and replace such media includes with title or URL, please?
This may occour for YouTube and Vimeo and with mixed character cases:

[YOUTUBE="This is the title of the video"]on8EBjTftcg[/YOUTUBE]
[YOUTUBE="https://www.youtube.com/watch?v=on8EBjTftcg"]on8EBjTftcg[/YOUTUBE]

[VIMEO="This is the title of the video"]236410761[/VIMEO]
[VIMEO="https://vimeo.com/236410761"]236410761[/VIMEO]

Thank you for any help.

 

[Nerbert]

Find: /\[youtube=[^\]]+\]([\S\s]+?)\[\/youtube\]/i
Replace: [MEDIA=YOUTUBE]\1[/MEDIA]


Find: /\[vimeo=[^\]]+\]([\S\s]+?)\[\/vimeo\]/i
Replace: [MEDIA=VIMEO]\1[/VIMEO]

 

[Nerbert]

I think this will get them all in one fell swoop

Find: /\[(YOUTUBE|VIMEO)=[^\]]+?\]([^\[]+?)\[\/(YOUTUBE|VIMEO)\]/i

Replace: [MEDIA=\1]\2[/MEDIA]

 

[Triops]

Thank you so much, @Nerbert. Will try in the next hour. Is this case sensitive? Anyway, I'll try and can run it with lower cases a second time!

 

[EQnoble]

You won't need to do that.

At the end of the expression right after the delimiter you can see "i" which is the modifier flag for case-insensitive.

http://php.net/manual/en/reference.pcre.pattern.modifiers.php

 

[Triops]

I did something slightly wrong with an SQL-query and now transfered the end of the youtube embeded already.

So, the query (forget to simulate before ******, yes I have an update but want to avoid that) was:

UPDATE xf_post SET message = REPLACE(message, '[/youtube]', '[/MEDIA]');

Will this work (I really have no clue from regex)?

Find: /\[youtube=[^\]]+\]([\S\s]+?)/i
Replace: [MEDIA=YOUTUBE]\1

edit: I probably just could revert it

UPDATE xf_post SET message = REPLACE(message, '[/MEDIA]', '[/youtube]');

But, the addon gave me an error 500 with this one, just simualting (not saving):

Find: /\[youtube=[^\]]+\]([\S\s]+?)/i
Replace: [MEDIA=YOUTUBE]\1

Is this faulty or does my AWS instance does not manage to replace that?

And: does you full query work for titles with and without quote marks ""?