Mass remove external links

[Xtrigit]

Is there a way I could mass delete external hyperlinks from posts?

Thanks

[Danielgsc]

Anybody? I'm interesting too. Mass delete or delete the links from a subforum...

[gobears20]

Anybody know of a way to do this?

[kh99]

I think you'd have to write php to do that. Someone more clever than I am might figure out how to do it with an sql statement, but I couldn't.

If you wanted to make certain forums so that urls couldn't be displayed, you might be able to do that by changing how the [url] bbcode is processed, and that owuld hide the existing ones as well as future ones. But that requires some programming as well.

[Dave]

Originally Posted by kh99

I think you'd have to write php to do that. Someone more clever than I am might figure out how to do it with an sql statement, but I couldn't.

If you wanted to make certain forums so that urls couldn't be displayed, you might be able to do that by changing how the [url] bbcode is processed, and that owuld hide the existing ones as well as future ones. But that requires some programming as well.

It may be possible in a complicated SQL query which makes use of a regex, but even that exceeds my skills. I indeed think it's easier to do this in a PHP script which just iterates through all posts which contains the URL tag or links, then check on the domain and ignore whitelisted ones and finally remove the links.

[gobears20]

Yeah apparently I have some bad links in posts but I have so many there is no way to track all posts down. I would probably either need to remove the links or rename the links to something else.

[ozzy47]

Yeah it is not something that can easily be done. If you really want this, you should hire someone. But make sure you do a full backup before anyone starts working on this.

[gobears20]

I hear that ozzy47, don't want to crash and burn like that

Do you know of anybody that does work like that company or a well known person?

[ozzy47]

Best bet would be to post in the paid request forum, https://vborg.vbsupport.ru/forumdisplay.php?f=30

Make sure you read the sticky threads in there before hiring anyone.

[gobears20]

Thanks

Hire at your own risk

Here is what happen to me. I have a forum with over 4 million posts and AdSense says that some of my links are going to inappropriate sites. I have three days to get it corrected. Well I have no idea what links are good and what are bad because I have links to all kinds of sites from my posters. So I am stuck with either removing the adsense ads or creating a query that will either rename any links or delete the links. Not really the way to start off your morning seeing that at 6am this morning Its hard to watch every single posts on my site and to where its linking to.