MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > How to list user posts that have an external link and user have lesser than X amount
Full Version: How to list user posts that have an external link and user have lesser than X amount
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

MonsterMMORPG

2021-08-25, 10:31 AM
How to list user posts that have an external link and user have lesser than X amount total posts

Is this possible?

So that I can make a quick spam check

Crazycat

2021-08-25, 01:57 PM
You can search for users with less of X posts from the ACP: Home » Users » Find Users

To list user posts with external link, it's impossible. You can list posts with an url from your DB (SELECT * FROM mybb_posts WHERE message LIKE '%http%://%' but you cannot exclude your own url
MyBB Community Forums > 1.8 Support > General Support > How to list user posts that have an external link and user have lesser than X amount