Resource icon

Post Content Find / Replace 1.0.0

No permission to download
Overview Reviews (25) History Discussion
Imported from VB4 and lots of old smilies now show as plain text

Like,

Code: 
:cry:

How would I properly find/replace this with no text, so essentially just remove them? I'm sorry but I don't know regular expression stuff.
 
Chad said:
Imported from VB4 and lots of old smilies now show as plain text

Like,

Code: 
:cry:

How would I properly find/replace this with no text, so essentially just remove them? I'm sorry but I don't know regular expression stuff.
Click to expand...

Note that first back up.

Code: 
UPDATE xf_post SET message = REPLACE(message, 'OLDTEXT', 'NEWTEXT');

So... If you want to remove it;

Code: 
UPDATE xf_post SET message = REPLACE(message, ':cry:', '');

It's possible to remove or replace all that smilie text via SQL Query.
 
Chad said:
Imported from VB4 and lots of old smilies now show as plain text

Like,

Code: 
:cry:

How would I properly find/replace this with no text, so essentially just remove them? I'm sorry but I don't know regular expression stuff.
Click to expand...

Eagle said:
Note that first back up.

Code: 
UPDATE xf_post SET message = REPLACE(message, 'OLDTEXT', 'NEWTEXT');

So... If you want to remove it;

Code: 
UPDATE xf_post SET message = REPLACE(message, ':cry:', '');

It's possible to remove or replace all that smilie text via SQL Query.
Click to expand...


It's not necessarily the best solution simply because the only reason to get rid of it is that you say it doesn't work but :cry: is a valid smiley if you want it to be and the default sprite includes it. The only thing you need to do is create a new smiley setup like the following below.

createNewSmiley.webp
 
EQnoble said:
It's not necessarily the best solution simply because the only reason to get rid of it is that you say it doesn't work but :cry: is a valid smiley if you want it to be and the default sprite includes it. The only thing you need to do is create a new smiley setup like the following below.

View attachment 93900
Click to expand...

Yes that is correct.

I forget it, sorry for that.
 
Eagle said:
Yes that is correct.

I forget it, sorry for that.
Click to expand...
Don't be sorry, two nuts on one screw is not exactly a disaster, but if replacements are made like this where stuff is removed and there is no index stored of the changes it could be anywhere from slight to quite impossible to reverse. (this is more of a note to people seeking the replacements, but we all take and keep db backups anyways, right?).

In this case it was a crying smiley, not exactly the hugest deal.
 
Hi there!

For some reason, I've got un-bbcoded URLs and I also have properly bbcode enclosed URLs.

A sample xf_posts record may look like this:

Code: 
Hello. Here are some links.

First link http://www.somesite.com
Second link: [URL]http://www.somesite.com[/URL]
Third link: [URL=http://www.somesite.com]Hello XF[/URL]


Goodbye.

I would need to enclose the first link in the example above within BBCODE as well.

I've been trying to construct an expression this morning using Positive and Negative Lookbehinds and all kind of stuff but I've failed. Can You guys help me?
 
farang said:
Hi there!

For some reason, I've got un-bbcoded URLs and I also have properly bbcode enclosed URLs.

A sample xf_posts record may look like this:

Code: 
Hello. Here are some links.

First link http://www.somesite.com
Second link: [URL]http://www.somesite.com[/URL]
Third link: [URL=http://www.somesite.com]Hello XF[/URL]


Goodbye.

I would need to enclose the first link in the example above within BBCODE as well.

I've been trying to construct an expression this morning using Positive and Negative Lookbehinds and all kind of stuff but I've failed. Can You guys help me?
Click to expand...

I have a script for this, but I would insist on running it myself since it requires working with the code a bit. Send me a PM with FTP access and I can fix those links for you.
 
Jake Bunce said:
I have a script for this, but I would insist on running it myself since it requires working with the code a bit. Send me a PM with FTP access and I can fix those links for you.
Click to expand...

Thanks @Jake Bunce .

I did check how severe the problem was by running the following sql statement
Code: 
SELECT message FROM `xf_post` where message like "%http://%" and message not like "%]http://%" and message not like "%=http://%" and message not like "%='http://%"

It turned out I have only 64 matching records with malformed URLs so I might as well edit them manually in phpMyAdmin. However I like to thank You for your kind offer to help me.
 
Chad said:
I got this working on a couple of mods but need help with reg expressions to replace these bbcodes

Code: 
[box-left]
<o:p>
(this one is actually a smiley from VB4, need it removed not replaced).

also need to replace this:

[SUP]12 [/SUP]
Click to expand...


The following expression did the trick for me... (y)

string.webp
 
No, the site you are linking to has no pattern associate with that link, that is a unique item number from their product offerings.

While there are some things you can do with regex which are not standard things people normally do (changing case and such is possible in some flavors of regex) for this particular example no there is no better way really as replacing a single link with regex is kinda already overkill unless you can read and write regex like it was English though if you are using this addon to find the post in the first place it's perfectly understandable to just go ahead and replace it right there.
 
Thanks EQnoble,

In this case, I have products that were linked over the years , members know of them or I actually created them through autolinks, then the manufacturer hires a new webmaster who feels changing the urls is a good idea. I had a few dozen links that regex found and got them all in one shot. Love this add-on.
 
Hello.
I was using addon TagMe on my former XF 1.1.3
with my new setup all taggued name in thread are displayed like this format : [member=15614]user[/member]
do you think it would be possible to replace this with @User ?
Thanks for your support.
 
kankan said:
Hello.
I was using addon TagMe on my former XF 1.1.3
with my new setup all taggued name in thread are displayed like this format : [member=15614]user[/member]
do you think it would be possible to replace this with @User ?
Thanks for your support.
Click to expand...
I haven't tested this as I just wrote it here in this post so try without saving first.

Quick Find:
Code: 
member

Regular expression:
Code: 
#\[(member)(=[0-9]+])(.*?(?!\[/\1]?).)(\[/\1])#siu

Replacement String:
Code: 
[user\2@\3[/user]

Thanks for your patronage.
 
Last edited:
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
67
MapleOne
MapleOne
xlegends
  • Question Question
XF 2.1 Find/Replace Links in Post Table
Replies
0
Views
589
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