Post Content Find / Replace 1.0.0

[maxicep]

I responded to your ticket on Sunday night with regards to removing font tags.

Quick Find: [font

Regular Expression: #\[font=([^\]]+)\](.*)\[/font\]#siU

Replacement String: \2

Yes thank you for help i know but i dont want to backup old posts as post history. Plugin does backup the old posts as post history but i dont need it

 

[maxicep]

I responded to your ticket on Sunday night with regards to removing font tags.

Quick Find: [font

Regular Expression: #\[font=([^\]]+)\](.*)\[/font\]#siU

Replacement String: \2

However, what is the code for clear all old COLOR tags too.

Actually, i m trying to clear like these posts

Spoiler: Image Screen Shot

 

[Jake Bunce]

I want prevent to save old posts as history. Any way ? I didnt see any option about that. But i can comment some lines in script if possible.

I just backed up mysql database and i want to run just like sql replace command. I dont want any history record because i have about 7million post and i dont want to save old changed posts on database also this process will take a long . I will remove all font styling customizations

Edit history?

Admin CP -> Home -> Options -> Logging Options -> Enable edit history tracking and prune after X days

 

[Jake Bunce]

However, what is the code for clear all old COLOR tags too.

Actually, i m trying to clear like these posts

Spoiler: Image Screen Shot

View attachment 68591

Quick Find: [color=

Regular Expression: #\[color=[^\]]+\](.+)\[/color\]#siU

Replacement String: \1

You may find that you have to run this replacement multiple times to handle nested tags. Just keep running it until it doesn't match anymore.

 

[audiokid]

I've read through a lot here, you guys are brilliant. What I priceless script. I cannot wait to use this. But, to sound like a bimbo, there isn't any info where this uploads. Where do I install this?

Thanks!

 

[EQnoble]

I've read through a lot here, you guys are brilliant. What I priceless script. I cannot wait to use this. But, to sound like a bimbo, there isn't any info where this uploads. Where do I install this?

Thanks!

Is it my fault or did you mean to make me laugh so hard (@ sound like a ..) ?


After downloading the archive extract it and upload the PostReplace folder to your 'site/library' and then install as normal.

Make sure to have backups taken first and also when running replacements, test it without the save box checked to make things easier for yourself.

 

[audiokid]

Thanks!

 

[maxicep]

@Brogan @Jake Bunce

I run this script today and i fallow the process via post edit history table in sql
It edited the about 4million post and write post edit history but now I m getting following errors:

When i check the checkbox and click to continue, it waiting a little then says "Please enter a valid message" error and process broken.

I tried about 4-5 times but same error .

I think, if any post include only like this [/ font] so replacement value will be = '' (empty) then it may says "Please enter a valid message " or may be different reason ...

Can you fix this error ? @Kier

 

[Jake Bunce]

"Please enter a valid message" error and process broken.

That means the post was empty after the replacement. The system doesn't allow empty posts.

 

[Sentenza]

Hello,

I would like to change this URL.

current:

[media=amazon]B00EIDO5K6[/media]

new:

http://www.amazon.de/dp/B00EIDO5K6/?tag=AMAZON-ID

Can someone help me please?

thx!

 

[audiokid]

This is what mine looks like and nothing is rewriting.

 

[EQnoble]

This is what mine looks like and nothing is rewriting.

I don't believe that has anything to do with this addon.

 

[maxicep]

That means the post was empty after the replacement. The system doesn't allow empty posts.

Yes but if post will be empty, May plugin no change the post? (Mean skip this post)
Or change with a constant word like dot, comma etc.
Or skip this post

Script stopped at about 4.1million th of 7million post. There are too many post in database which should be replaced.

If need the any file (line) of script, i can do it too for this fail.

However can i find this post in mysql which return the empty after replacement ? I can delete it manually too

 

[audiokid]

wrong

This is what mine looks like and nothing is rewriting.

my bad

 

[cmeinck]

I have a different (but related to migration to subdomain) image issue. It appears that attachments from my conversion from vB years ago show when logged into the site. Guests see what appears to be a broken image.

Logged in:


If I'm logged out:


This is the thread. If you click to open the image, it redirects, but you get this message:




This is the underlying code:

<img src="http://www.everythingicafe.com/forum/attachment.php?attachmentid=4400&amp;stc=1&amp;d=1233449449" class="bbCodeImage LbImage" alt="[IMG]" style="">

I'd consider doing a mySQL query, which fixed my last issue, but not sure if it'll correct my problem.

UPDATE xf_post SET message = REPLACE(message, 'www.everythingicafe.com/forum/attachment','forums.everythingicafe.com/attachment');

Any recommendations are greatly appreciated.

 

[EQnoble]

Hello,

I would like to change this URL.

current:

[media=amazon]B00EIDO5K6[/media]

new:

http://www.amazon.de/dp/B00EIDO5K6/?tag=AMAZON-ID

Can someone help me please?

thx!

Quick Find:

amazon]

Regular expression:

#(?:\[media=(amazon)])([^\[]+)(?:\[/media])#siu

Replacement String:

http://www.\1.de/dp/\2/?tag=AMAZON-ID

 

[Sentenza]

@EQnoble
Many thanks!

 

[Sentenza]

Quick Find:

amazon]

Regular expression:

#(?:\[media=(amazon)])([^\[]+)(?:\[/media])#siu

Replacement String:

http://www.\1.de/dp/\2/?tag=AMAZON-ID

OMG, I forget the string to make it clickable

Now, I have this code

http://www.amazon.de/dp/B00EIDO5K6/?tag=AMAZON-ID

and need this

[URL]http://www.amazon.de/dp/B00EIDO5K6/?tag=AMAZON-ID[/URL]

 

[EQnoble]

OMG, I forget the string to make it clickable

Now, I have this code

http://www.amazon.de/dp/B00EIDO5K6/?tag=AMAZON-ID

and need this

[URL]http://www.amazon.de/dp/B00EIDO5K6/?tag=AMAZON-ID[/URL]

Quick Find:

amazon

Regular expression:

#http://www\.amazon\.de/dp/[^/]+/\?tag=AMAZON-ID#siu

Replacement String:

[URL]\0[/URL]

 

[jo8jo]

I need some help with old (imported vb4) BBCodes in the posts.
There are many posts including the following bbcodes:

[SIZE=1]
[SIZE=2]
[/SIZE]
[FONT=tahoma] etc.

I want to remove these BBCodes from all posts. Is this possible?

Thanks in advance