Post Content Find / Replace 1.0.0

[EQnoble]

Is that hyperlinked in the post (clickable) or plain text (as you have posted)?

AKA

this: https://www.youtube.com/watch?v=mG92yuovD6g
or this: https://www.youtube.com/watch?v=mG92yuovD6g

 

[rveram]

Is that hyperlinked in the post (clickable) or plain text (as you have posted)?

AKA

this: https://www.youtube.com/watch?v=mG92yuovD6g
or this: https://www.youtube.com/watch?v=mG92yuovD6g

Hello, plain text.

 

[EQnoble]

Try this one:

https://xenforo.com/community/threads/post-content-find-replace.6548/page-20#post-657084

 

[rveram]

Try this one:

https://xenforo.com/community/threads/post-content-find-replace.6548/page-20#post-657084

Worked, thank you sir!

 

[Neutral Singh]

Hi @Jake Bunce,

What would be the regular expression to find and remove:

[SIZE=+1] and [/SIZE]

For example here...
http://www.sikhphilosophy.net/threads/milni-at-sikh-weddings.22246/#post-82466

I have tried:

Quick find: [SIZE=+1]

Regular expression: "[SIZE=+1]" or "/[SIZE=+1]/"

Its not finding the exact search string: [SIZE=+1] or [/SIZE]

Please advice.

 

[Jake Bunce]

Hi @Jake Bunce,

What would be the regular expression to find and remove:

[SIZE=+1] and [/SIZE]

For example here...
http://www.sikhphilosophy.net/threads/milni-at-sikh-weddings.22246/#post-82466

I have tried:

Quick find: [SIZE=+1]

Regular expression: "[SIZE=+1]" or "/[SIZE=+1]/"

Its not finding the exact search string: [SIZE=+1] or [/SIZE]

Please advice.

Quick Find: [SIZE=+1]

Regular Expression: #\[SIZE=\+1\]#siU

Replacement String: [SIZE=1]

That should do it.

In the regex you have to escape (backslash) certain characters like brackets and plus symbols.

 

[Neutral Singh]

Awesome, Thanks!

 

[ForumFlex]

Hi, I migrated the forum from mybb to xenforo.. then the site is already live, hoever there are bbcode and images issues on the post. I will use this mod to replace the text, My questions is do I need to 'TURN OFF' my forum? or its okay to run this without turning off the forum?

 

[Jake Bunce]

Hi, I migrated the forum from mybb to xenforo.. then the site is already live, hoever there are bbcode and images issues on the post. I will use this mod to replace the text, My questions is do I need to 'TURN OFF' my forum? or its okay to run this without turning off the forum?

You can run it while live.

 

[ForumFlex]

Thanks

 

[ForumFlex]

It is nice if there will be an option for 'signatures' too and not only in the post

 

[Fred.]

I would like to replace all my internal links to my old domain with the new one.
I have links pointing to http and https versions of the old domain and I would like to point all my internal links to my new domain (https)

Is that possible? How can I do that?

Thanks!

Edit : found it! (after trial and error)

This is what I used

QF
example.net

RE
#((http(?:s)?://)(?:www\.)?)(example\.net)([^\[\s']+)?#siu

RS
https://example.com\4

The next thing I'm trying is to change

https://example.com/register.php to https://example.com/login

I appreciate your help.

Thanks!

 

[Jake Bunce]

@Fred.

For simple replacements you can use a direct query on the database:

UPDATE xf_post
SET message = REPLACE(message, 'http://example.net', 'http://example.com');

You don't need Kier's addon for this simple replacement.

 

[Fred.]

Thanks @Jake Bunce but I already done it with the add-on. I have done some more stuff with it. (removed font and size tags)

The only thing I'm still trying to find out is how I can change

https://example.com/register.php to https://example.com/login

 

[rdn]

Can someone advice a regex to delete all empty IMG bbcode?
Like this:

[img][/img]

Thanks!


Edit:
I think this direct query will do:

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

466 rows affected. (Query took 2.0769 seconds.)

 

[rdn]

So another regex I'm searching for.
Regex to remove all [ img ] bbcode not enclosing a valid url?

Sample:

this is random post ..
and [img] random appear without an image.
random message then..
[/img] close tag appear

 

[Cyb3r]

So another regex I'm searching for.
Regex to remove all [ img ] bbcode not enclosing a valid url?

Sample:

this is random post ..
and [img] random appear without an image.
random message then..
[/img] close tag appear

Try this for open tag:

/\[img\](?!((([A-Za-z]{3,9}:(?:\/\/)?)(?:[-;:&=\+\$,\w]+@)?[A-Za-z0-9.-]+|(?:www.|[-;:&=\+\$,\w]+@)[A-Za-z0-9.-]+)((?:\/[\+~%\/.\w-_]*)?\??(?:[-\+=&;%@.\w_]*)#?(?:[\w]*))?))/i

And this for closing tag:

/(?!((([A-Za-z]{3,9}:(?:\/\/)?)(?:[-;:&=\+\$,\w]+@)?[A-Za-z0-9.-]+|(?:www.|[-;:&=\+\$,\w]+@)[A-Za-z0-9.-]+)((?:\/[\+~%\/.\w-_]*)?\??(?:[-\+=&;%@.\w_]*)#?(?:[\w]*))?))\[\/img\]/i

don't check "Save Changes" until you make sure all results are valid. It hasn't been tested.

 

[rdn]

Try this for open tag:

And this for closing tag:

Both regex also triggers on valid IMG bbcode with valid image url inside it.

 

[Travis-Mc]

Can someone help me change this:

[IMG]http://www.example.com/forum/attachment.php?attachmentid=49056&d=1416873612[/IMG]

To this:

[IMG]http://www.example.com/xendev/attachments/ol41-jpg.49056/[/IMG]

Or this

 [IMG]http://www.example.com/xendev/attachments/49056/[/IMG]

Either seem to work fine in xenforo

I'm not sure what d=1416873612 in the first link is, but I don't think I need it.

Thanks!

 

[Burp]

Hello, Try this one:

Quick Find:

[IMG]http://www.example.com/forum/attachment.php?attachmentid

Regex:

#(\[img]http://www\.example\.com)/forum/attachment\.php\?attachmentid=([0-9]+)&d=([0-9]+)(\[/img])#siu

Replace:

\1/xendev/attachments/\2/\4

Always try first without saving.