Resource icon

Post Content Find / Replace 1.0.0

No permission to download
Overview Reviews (25) History Discussion
rhs said:
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.
Click to expand...
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.





markku said:
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...

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

thanks so much!
Click to expand...

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
 
Last edited:
EQnoble said:
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
Click to expand...
Thanks, that was exactly what I was looking for.
 
EQnoble said:
No, this tool is specifically to match and replace strings within post content only and does not effect titles.
Click to expand...

No titles ... the links above are in the posts. I can replace it with an UPDATE SQL but i can't control that before ...
 
rhs said:
No titles ... the links above are in the posts. I can replace it with an UPDATE SQL but i can't control that before ...
Click to expand...
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:
Code: 
%28

Regular expression:
Code: 
#%28#su

Replacement String:
Code: 
(
_______________
Quick Find:
Code: 
%29

Regular expression:
Code: 
#%29#su

Replacement String:
Code: 
)

_______________
Quick Find:
Code: 
%FC

Regular expression:
Code: 
#%FC#su

Replacement String:
Code: 
ü
 
  • Like
Reactions: rhs
@EQnoble:

I have here a nut to crack ...

This table definitions ...

Code: 
[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 ...

Code: 
[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 ...
 
rhs said:
Do you have any idea how to do that with Post Content Replace? I have many table definitions in my posts ...
Click to expand...
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.
 
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:

Code: 
[youtube]videoID[/youtube]
[youtube480]videoID[/youtube480]
[youtube720]videoID[/youtube720]

Thanks
 
You can do that with simple queries:
Code: 
UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

Take a backup first.
 
Brogan said:
You can do that with simple queries:
Code: 
UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

Take a backup first.
Click to expand...

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.
 
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 :oops: )

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.
 
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:
help_bb_code.webp
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:
help_bb_code2.webp
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!!
 
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?
 
tcmw said:
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?
Click to expand...
Just move the entire /PostReplace into /library like this: library/PostReplace
 
These should work for you.

mcgra said:
View attachment 67683
Click to expand...

Quick Find:
Code: 
media=youtube

Regular expression:
Code: 
#(\[media=youtube])?([a-z0-9_-]{11})(")(\[/media])(?:\[/url])?#siu

Replacement String:
Code: 
\1\2\4


_______________________________________


mcgra said:
View attachment 67684
Click to expand...

Quick Find:
Code: 
video=youtube

Regular expression:
Code: 
#(?:\[video=youtube_share;([a-z0-9_-]{11})])(?:[^\[]+)(\[/media])#siu

Replacement String:
Code: 
[media=youtube]\1\2


Congrats on your conversion.
 
Hi, is there a way to reverse my edits, I have messed up with my "replace in a post" and I need to fix it now, I dont have a backup :( but I see in Admin Log the "post replace" commands is there a way I can reverse these?

Thanks
 
You must log in or register to reply here.

Similar threads

MapleOne
  • Question Question
XF 2.3 Post Content find and replace - how do you replace a bracket?
Replies
7
Views
66
MapleOne
MapleOne
xlegends
  • Question Question
XF 2.1 Find/Replace Links in Post Table
Replies
0
Views
588
xlegends
xlegends
Chris D
Post Content Find / Replace
13 14 15
Replies
289
Views
30K
twollert
twollert
invictus
  • Question Question
XF 2.0 Find/Replace Video vBulletin Video Embeds
Replies
6
Views
862
Anomandaris
Anomandaris
vFranky
  • Question Question
XF 1.5 Post Content Find / Replace - Error "Please enter a valid message"
Replies
2
Views
832
vFranky
vFranky
Back
Top Bottom