ForestForTrees
Well-known member
Recently, I've been noticing people who sign up for an account and set their "Home Page" and "About You" settings to spammy links. I was able to find a bunch through the following SQL because the vast majority of our users don't set "Home Page"s:
Any thoughts on how to handle this? Most of the IP numbers creating the accounts come from India or the Phillipines.
Code:
SELECT user_id, homepage FROM `xf_user_profile`
ORDER BY `xf_user_profile`.`homepage` DESC