Show or list posts with (external) links

[nealtz]

I'm looking for a way to search for / list all posts with external links.

We realized that most posts that Admins / Mods have to edit, are posts with external links. It is not so bad that we want to put all posts with an external link into a moderation queue, but it would be very helpful, if we could have an option for the Mods to show / list all posts with external links. Even better if we could search for special domains.

Actually we manually search for the term "http" and sort by date. But it would be handy, if we could use this as a saved search.

Also we didn't check if we also get the post if the user entered only "www..." without the "http".

Any hints for a solution?

[Daddy]

If you're trying to hide all links then it would be smart to add http, https and so forth under banned words.

[nealtz]

Thanks for your reply, but no, we don't want to hide or disallow external links.

We want to check posts with external links, because often (or better: sometimes) users set links to sites, that aren't allowed in our forum or they try to post affiliate links etc. It is not so problematic that we want to set all new posts with a external link in a moderation queue, but moderation would be easier, with an option to show all (new) posts with an external link.

[Daddy]

47 minutes ago, nealtz said:

Thanks for your reply, but no, we don't want to hide or disallow external links.

We want to check posts with external links, because often (or better: sometimes) users set links to sites, that aren't allowed in our forum or they try to post affiliate links etc. It is not so problematic that we want to set all new posts with a external link in a moderation queue, but moderation would be easier, with an option to show all (new) posts with an external link.

If I were in your shoes I'd resort to raw data instead. I'm referring to the database of course. You can easily search, replace and monitor naughty links.