Post Content Find / Replace 1.0.0

[EQnoble]

This one:

Any link with forum.emobucket.com in it ?

This should work out for that...


Quick Find:

emobucket

Regular expression:

#(\[url])(http://forum\.emobucket\.com)((?:[^\[]+)?\[/url])#siu

Replacement String:

\1http://www.yabucket.com\3

 

[AWS]

This one:

Any link with forum.emobucket.com in it ?

I used a query courtesy of Jake to do simple replacements like this one. You could run this query to change the links.

UPDATE xf_post SET message = REPLACE(message, 'forum.emobucket.com','www.yabucket.com');

 

[markku]

How can I find all posts that start with the quote tag and end with closing quote tag?

Some of my members continually click the Reply button below a message and then they go to the quick editor and click Post Reply before writing their reply.

So I'd like to find all posts with the following content... So I guess a RegExp for [quote and the ending /quote] and what's important: only find posts that have nothing after the closing /quote] tag...

[quote="MemberName, post: 20734, member: 2014"]Content...[/quote]

thanks so much!

 

[rhs]

Hi,

i have moved from vB4 to XF and problems with links with german umlauts / percents:

old: http://de.wikipedia.org/wiki/Brevet_(Fahrrad)
new: http://de.wikipedia.org/wiki/Brevet_%28Fahrrad%29

old: http://www.pedelecforum.de/forum/showthread.php?1560-Chat-auch-für-Pedelec
new: http://www.pedelecforum.de/forum/showthread.php?1560-Chat-auch-f%FCr-Pedelec

old: http://www.novosport.de/?Produkte:Sitze_und_Polster:-_für_Kurzliegeräder
new: http://www.novosport.de/?Produkte:Sitze_%26amp%3B_Polster:Sitze_f%FCr_Kurzlieger%E4der

Can i correct this with that tool?

Thanks.

 

[EQnoble]

Hi,

i have moved from vB4 to XF and problems with links with german umlauts / percents:

old: http://de.wikipedia.org/wiki/Brevet_(Fahrrad)
new: http://de.wikipedia.org/wiki/Brevet_%28Fahrrad%29

old: http://www.pedelecforum.de/forum/showthread.php?1560-Chat-auch-für-Pedelec
new: http://www.pedelecforum.de/forum/showthread.php?1560-Chat-auch-f%FCr-Pedelec

old: http://www.novosport.de/?Produkte:Sitze_und_Polster:-_für_Kurzliegeräder
new: http://www.novosport.de/?Produkte:Sitze_%26amp%3B_Polster:Sitze_f%FCr_Kurzlieger%E4der

Can i correct this with that tool?

Thanks.

No, this tool is specifically to match and replace strings within post content only and does not effect titles. You would more than likely need to run queryies against the xf_thread table for the titles.

How can I find all posts that start with the quote tag and end with closing quote tag?

Some of my members continually click the Reply button below a message and then they go to the quick editor and click Post Reply before writing their reply.

So I'd like to find all posts with the following content... So I guess a RegExp for [quote and the ending /quote] and what's important: only find posts that have nothing after the closing /quote] tag...

[quote="MemberName, post: 20734, member: 2014"]Content...[/quote]

thanks so much!

Having no clue what you want to do with it I will just provide you an expression to play with and figure out what you would like to do with it, untested so use in a test environment and preview before saving things.

This should match posts with only quotes that are not preceded or followed by anything.

#(?<![^.])\[quote="[^"]+"][^\[]+\[/quote](?![^.])#siu

 

[markku]

Having no clue what you want to do with it I will just provide you an expression to play with and figure out what you would like to do with it, untested so use in a test environment and preview before saving things.

This should match posts with only quotes that are not preceded or followed by anything.

#(?<![^.])\[quote="[^"]+"][^\[]+\[/quote](?![^.])#siu

Thanks, that was exactly what I was looking for.

 

[rhs]

No, this tool is specifically to match and replace strings within post content only and does not effect titles.

No titles ... the links above are in the posts. I can replace it with an UPDATE SQL but i can't control that before ...

 

[EQnoble]

No titles ... the links above are in the posts. I can replace it with an UPDATE SQL but i can't control that before ...

You know what I am sorry, I had just woken up and when I saw the second example in your post my brain automatically made me think you were having problems with thread titles.

Yes you should be able to replace those with things like this as you find the % encoded characters that you want changed...
just follow this example

Quick Find:

%28

Regular expression:

#%28#su

Replacement String:

(

_______________
Quick Find:

%29

Regular expression:

#%29#su

Replacement String:

)

_______________
Quick Find:

%FC

Regular expression:

#%FC#su

Replacement String:

ü

 

[rhs]

@EQnoble: perfect, thank you!

 

[rhs]

@EQnoble:

I have here a nut to crack ...

This table definitions ...

[TABLE="class: prettytable"]
[TR="class: hintergrundfarbe6, bgcolor: #B3B7FF"]
[TH="align: center"]Abkürzung[/TH]
[TH="align: center"]Name[/TH]
[TH="align: center"]Verfahren[/TH]
[TH="align: center"]Lagegenauigkeit[/TH]
[TH="align: center"]Höhengenauigkeit[/TH]
[/TR]
[TR]
[TD]EPS[/TD]
[TD]Echtzeit-Positionierungs-Service[/TD]
[TD]DGPS[/TD]
[TD]0,5 bis 3 m[/TD]
[TD]1 bis 5 m[/TD]
[/TR]
[TR]
[TD]HEPS[/TD]
[TD]Hochpräziser Echtzeit-Positionierungs-Service[/TD]
[TD]RTK[/TD]
[TD]1 bis 2 cm[/TD]
[TD]2 bis 4 cm[/TD]
[/TR]
[TR]
[TD]GPPS[/TD]
[TD]Geodätischer Postprocessing-Positionierungs-Service[/TD]
[TD]Postprocessing[/TD]
[TD]unter 1 cm[/TD]
[TD]1 bis 2 cm[/TD]
[/TR]
[/TABLE]

... should lock at this ...

[TABLE=head]
Abkürzung | Name | Verfahren |Lagegenauigkeit |Höhengenauigkeit
EPS | Echtzeit-Positionierungs-Service | DGPS | 0,5 bis 3 m | 1 bis 5 m
HEPS | Hochpräziser Echtzeit-Positionierungs-Service | RTK |1 bis 2 cm | 2 bis 4 cm
GPPS | Geodätischer Postprocessing-Positionierungs-Service | Postprocessing | unter 1 cm |1 bis 2 cm
[/TABLE]

Do you have any idea how to do that with Post Content Replace? I have many table definitions in my posts ...

 

[EQnoble]

Do you have any idea how to do that with Post Content Replace? I have many table definitions in my posts ...

I do but it will take a little time, and I need more info and examples to make sure all things desired are matched while not matching the undesired.

Feel free to start a convo with me to sort out any details and I will check it out tomorrow, at the moment I am going to sleep because I forgot to do that the other day.

 

[Brent W]

Just corrected over 14,000 video embeds on a forum we converted. So, yea, thanks for this @Kier

 

[ithinkitsnice]

Can someone tell me how to fix my old phpbb youtube bbcode? I've got three slightly different tags that need replaced to the xenforo standard:

[youtube]videoID[/youtube]
[youtube480]videoID[/youtube480]
[youtube720]videoID[/youtube720]

Thanks

 

[Paul B]

You can do that with simple queries:

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

Take a backup first.

 

[ithinkitsnice]

You can do that with simple queries:

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

Take a backup first.

Sorry, I don't follow. By 'queries' I take it you mean run a query on the db, not using this add-on?

I'm not very familiar with sql and I've no idea how to adapt that to my bbcodes.

 

[ithinkitsnice]

@Brogan Thanks, got it to work by running it in phpmyadmin.

 

[msolano]

Hello: I used this plugin to replace my youtube links and it worked very well. Thanks a lot for that.

Now the next problem I have are the links broken of my own site. I had VbSeo in my old site, then they had the structure:
<domain>/<foro>/<sub-forum>/<thread-id>-<thread-title><.html>

Example: http://acuarios.desdecostarica.com/foro/ovoviv-paros/13969-quiero-reproducir-guppys-ayuda.html

Actually in Xenforo this same link is:

http://acuarios.desdecostarica.com/foro/threads/quiero-reproducir-guppys-ayuda.13969/

As you can see http://acuarios.desdecostarica.com/foro/ovoviv-paros/ can be easily replaced by http://acuarios.desdecostarica.com/foro/threads/ using an update statement (I should have to do it with every subforum, and I have a lot of them )

But I don't get how to change 13969-quiero-reproducir-guppys-ayuda.html into quiero-reproducir-guppys-ayuda.13969/.

Can I change the whole URL links using this? Do you know how to do it?

(I searched for this kind of request into this thread and I didn't find it, and I searched into resources for a vbseo replace plugin but it doesn't exist)

Any help will be very very appreciated.

 

[mcgra]

Hi, thanks for this amazing tool, I've converted thousands and thousands of vids for my fresh conversion from vB4 > xf I've just got a portion of the tags that are problematic:

Unfortunately I have no idea how to fix it, could anyone help?

One more smaller problem is these share tags, I can't seem to pick them up with any of the solutions posted so far:

Any help would be hugely appreciated from anyone. Massive thanks to EQnoble for the solutions so far, they have converted a huge amount of vids, hero!!

 

[tcmw]

What did I do wrong here? I uploaded the folder /PostReplace into the forum home, and installed, addon_postreplace.xml via the install add-on link in the CP.

When I click on the Replace in Posts link in the tools section I get an error saying The requested page could not be found.

Where did I goof up?

 

[EQnoble]

What did I do wrong here? I uploaded the folder /PostReplace into the forum home, and installed, addon_postreplace.xml via the install add-on link in the CP.

When I click on the Replace in Posts link in the tools section I get an error saying The requested page could not be found.

Where did I goof up?

Just move the entire /PostReplace into /library like this: library/PostReplace