still more comment spam
this is getting annoying now. so much spam. i already have the google recapture, but spam is still getting through.
who runs this stuff, bots i guess. annoying.
update: 10 August 2021
Still getting random spam here, i guess i need to add more spam checks, how does it bypass the google recapture. Unless its posting it without the form.
find the ip address, it seems they are adding the "code" to the user or nick name field, so i need to limit the characters on that one, its all sql safe and escaped anyway so it cant harm anything, its just annoying to delete 2500 rows of spam every day.
SELECT * FROM "comments" WHERE "user_ip" LIKE '%220.127.116.11%'
now delete all this spam and move to the next ip, also add the ip to the block list.
DELETE FROM "comments" WHERE "user_ip" LIKE '%18.104.22.168%'
I think the issue or one of the issues is that there is no limit or filter on the nickname field, so need to add a filter and limit here.
Update: 14 Sep 2021
It seems i have still not solved this particular issue and have to keep going into the database and clearing out all the spam.
Here is an example: