php - How to check if users are spamming other users with similar messages? -
one of php/mysql sites administer social network , i've noticed spammers send lot of similarly-looking messages several other users.
due number of messages sent same user account , similarities in messages sent, seems should relatively easy identify users spamming other users in way, don't know how in php/mysql. messages stored in db type text
.
how can identify these spammers can rid of them automatically when start sending many similarly-looking messages?
edit:
the spam messages @ least paragraph of text, safely ignore messages less 100 characters , automatically let through.
spam messages have link inside, can filter out without link.
and should try prevent first, if 1 user starts sending many messages in short time many users spam.
you can having kind of counter in session, increment each message send new user , if on 20 per hour (i made number make efficient need tests) may spamming , start asking him captcha or block chat 15 minutes, report him admin check manually