Delete spammers by partial IP address?
 

I am helping someone with their long neglected board that's got alot of spam accounts with IP address starting with 121 in the profile.

They are all in the registered users group, and I want to know what a query would be to delete them all. Anyone with a idea? Can a partial IP be entered in a query, with a asterisk as wildcard? Like 121* ??

If all ips were the same yes you could be as more than one table holds user info it would not be a good way to go

I'm asking specifically about the profile field, "IP Address" the admin can see in profiles when looking them up in AdminCP. This as a identifier similar to the user profile fields used to mass move spam accounts to a custom usergroup as in this article: https://vborg.vbsupport.ru/showthread.php?t=276547

If we know the profile field number and the first three digits of the offending IP address, can we craft a query to delete all such accounts? Would such a query accept the asterisk as a wildcard, as in 121.* ??

As I said in my first post you need the full ip if all spammers IPs were the same then you could but if doing it from a query it will cause problems

UPDATE `user` SET `usergroupid`='8', `ipaddress`='FULL IP HERE' WHERE (`userid`='2')
this will move them from group 2 to 8 with x ip
then you could use the prune option to delete all in that group

is only the first 3 numbers of the ip the same and how many spammers and do they have posts. If the forum you are helping I can give you a plugin that will delete all there posts and delete the accounts

Need the FULL Ip address, wildcards won't work? That's what I am asking. Never been tried? How do we know?



I missed this before....

Yes there's a couple thousand or so with first three numbers of the IP the same. Some of those accounts have 1 or 2 posts, most have zero. Some of them have exact IP address (all numbers) the same, vast majority, not.

Only common denominator is first three digits of the registration IP.

UPDATE `user` SET `usergroupid`='8' WHERE ipaddress LIKE '121%';

change group if you need then you can use the prune options in vb but before you do make sure all spammers posts are deleted first

Always backup first

PM sent I gave you a custom plugin that will help

Thanks Force! Does that query scare anyone besides me? Part of me wants to run it part of me wants to run from it!

I appreciate your time and help.

That query will move users to usergroup 8 if their ip address is:
121.123.00....etc
1212.....etc

so any ip address that starts with 121 will get the user moved, the wildcard operator (%)will account for anything at all after 121.

I'm not as skeered of it now, as I was. Thanks Simon!

Dont be scared lol when it comes to things like this I know what I am doing been at it for over 20 years