Removal of certain links from throughout site

[ChemicalKicks]

In light of recent in the events in the states it's become apparently obvious that I need to get rid of a lot of links on my site. Sharing is no longer caring

So can anyone suggest a way to rid myself of these caring links?

 

[Paul B]

What kind of links are they?

You can use the post find replace tool or just enter simple SQL queries, depending on the content.

http://xenforo.com/community/threads/post-content-find-replace.6548/

 

[ChemicalKicks]

What kind of links are they?

You can use the post find replace tool or just enter simple SQL queries, depending on the content.

http://xenforo.com/community/threads/post-content-find-replace.6548/

Um just standard links that would go like http://wellknownshare.org/

I'll have a look at the find replace tool and get back to you.

 

[ChemicalKicks]

Quick Find: http://wellknownshare.org/​

​

Regular expression:​

​

Regular expression: LinkRemoved​

​

Would that be okay?​

​

​

EDIT: That didn't work, not did moving the link down to the regular expression box. I have to admit I'm not confident using this tool at all.​

 

[Paul B]

It requires some knowledge of regular expressions.

Check out some of the examples and it may help: http://xenforo.com/community/threads/post-content-find-replace.6548/page-9#post-306329

 

[ChemicalKicks]

Wow that's complex.

 

[Jake Bunce]

Are you wanting to remove all links for a certain domain name?

 

[ChemicalKicks]

Are you wanting to remove all links for a certain domain name?

Hi Jake, yes.

In my example above I have http://wellknownshare.org/ but obviously every link has more unique content after the last "/" I don't mind if the unique part of the link remains.

 

[Paul B]

A simple SQL query would do that.

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

 

[Mike]

You can always just add it to your word censor.

 

[ChemicalKicks]

You can always just add it to your word censor.

I already have, didn't do anything with the existing links.

 

[ChemicalKicks]

A simple SQL query would do that.

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

Thank you.

 

[Paul B]

I already have, didn't do anything with the existing links.

It should do as the post content is dynamically filtered - the post table isn't altered by the censor.

 

[ChemicalKicks]

It should do as the post content is dynamically filtered - the post table isn't altered by the censor.

aha

Went back and unticked the "match exact word" box.

All is working.

 

[ChemicalKicks]

However this means that anyone who legitimately needs to talk about the site will be caught by the filter.

 

[Digital Doctor]

However this means that anyone who legitimately needs to talk about the site will be caught by the filter.

That's b***s**t. people find ways ! m3gaupload rocks ! fil3share was fun.
Xenforo's super fast editing makes it even more likely people will find ways .
I just used ******** to show how easily people get around filters I didnt even want to swear, but what the ****.

 

[ChemicalKicks]

haha