Post Content Find / Replace 1.0.0

[Burp]

I supose it should but you ca try to just use [url=

I have some trouble myself to find postings which I know they exist but the tool doesn't seem to find them. Regex is fine but I suspect the Quick Find

 

[viper357]

Hi, would anybody be able to help me with the regular expression to remove this from my posts?

Why web when you can app... Tapatalk from SM-910c

Thank you.

 

[Burp]

Quick Find:
Why web when you can app... Tapatalk from SM-910c

Regex:

#Why web when you can app\.\.\. Tapatalk from SM-910c#siu

replacement: Leave empty

Try testing first (leave check box save changes empty)

 

[Varma]

@Burp can you please help me with a regular expression

I'm looking to convert all imgur image links from http to https

example -
I want the image tags from

[IMG]http://i.imgur.com/xxxxx.jpg[/IMG]
to
[IMG]https://i.imgur.com/xxxxx.jpg[/IMG]

 

[Chromaniac]

UPDATE xf_post SET message = REPLACE(message, 'http://i.imgur', 'https://i.imgur');

if you are comfy with phpmyadmin. i run this query once every few months on domains that i find do not force https.
there is also the proxy image option that should negate the need for running this command at all.

 

[Varma]

UPDATE xf_post SET message = REPLACE(message, 'http://i.imgur', 'https://i.imgur');

if you are comfy with phpmyadmin. i run this query once every few months on domains that i find do not force https.
there is also the proxy image option that should negate the need for running this command at all.

Superb that will work.. i will give it a try now..

On the way by enabling the proxy image my server load gone up and cloudflare is not caching those images resulting in slow site . So was thinking to disbale image proxy and use instead the https image tag. Imgur actually offers that.

 

[Chromaniac]

Yup. It's sad that they are not forcing HTTPS by default. Almost all major sites that offer embedded codes are HTTPS these days.

 

[Sakata Gintoki]

UPDATE xf_post SET message = REPLACE(message, 'http://i.imgur', 'https://i.imgur');

if you are comfy with phpmyadmin. i run this query once every few months on domains that i find do not force https.
there is also the proxy image option that should negate the need for running this command at all.

Also taigachat in message will works http to https?

 

[Burp]

@Burp can you please help me with a regular expression

I'm looking to convert all imgur image links from http to https

example -
I want the image tags from

[IMG]http://i.imgur.com/xxxxx.jpg[/IMG]
to
[IMG]https://i.imgur.com/xxxxx.jpg[/IMG]

If you want to use this tool then:

Quick Find:

[IMG]http://i.imgur

Regex:

#\[IMG]http://(i\.imgur\.com/[^[]+)\[/IMG]#siu

Replace:

[IMG]https://\1[/IMG]

Always try first without saving.

If you get server errors, read this:
https://xenforo.com/community/threads/import-from-ipb-3-2-posts-not-parsed-at-all.39577/#post-435226

 

[Mr Lucky]

can someone please help me with this, should be simple.

I want to replace http with https in the following URLs:

[IMG]http://cafesaxophone.com/.......

So I put in quick search:

http://cafesaxophone.com

then

Find http

Replace https

But this gives me an error.

 

[Floyd R Turbo]

you need to use regex, it's not a plain text replacer

 

[Mr Lucky]

you need to use regex, it's not a plain text replacer

OK, but what do I put in then? How do I use regex for this? Thanks

 

[Chris D]

You can use the following post as an example (posted above your first post):

Quick Find:

[IMG]http://i.imgur

Regex:

#\[IMG]http://(i\.imgur\.com/[^[]+)\[/IMG]#siu

Replace:

[IMG]https://\1[/IMG]

Always try first without saving.

Just replace i.imgur with your own domain.

 

[Burp]

Yes, I was just looking for that one

I knew that I made one recently, very recently

 

[Mr Lucky]

You can use the following post as an example (posted above your first post):



Just replace i.imgur with your own domain.

I tried that previously and nothing happened.

[IMG]http://cafesaxophone

#\[IMG]http://(cafesaxophone\.com/[^[]+)\[/IMG]#siu

[IMG]https://\1[/IMG]

 

[Chris D]

Something would always happen, be an error or a confirmation page or similar.

Can you describe the specific steps you took?

 

[Mr Lucky]

Something would always happen, be an error or a confirmation page or similar.

Can you describe the specific steps you took?

Yes, out of those three lines, the first went into Quick Find, the second into Regular Expression and the third into replacement String

I then click on Proceed (without save changes)


Absolutely nothing happens exceept URL changes:

From

http://test.cafesaxophone.com/admin.php?post-replace/

to:

http://test.cafesaxophone.com/admin.php?post-replace/replace

 

[Chris D]

I was perhaps mistaken, I thought an error would be displayed if no results are found but I just tested this and if it doesn't find any content matching what you search for then it does effectively reload the page. If it does find something, what you should see is a list of posts that contain what you searched for, what the old text is and what the new text will be, like this:



This is using one of your actual images in one of my posts and it seems to work.

At this point if I click Save Changes and Proceed, it will go ahead and make the changes:

 

[Mr Lucky]

Thanks Chris, it seems it does work on my live forum though.

(My previous attempt was my test forum with recent import so URLs would be the same, odd)

Anyway all working now. Thanks.

 

[Burp]

Always best to place an actual working link (with domain name changed if you please) so we can test it before give you the correct search and replace strings.