SQL query in OJS 3.3.x to identify spam registrants

Hi,
Has anyone written SQL query in OJS 3.3.x to identify users that can be suspected to be spam registrants?

Cheers
Obi

Hi @obi

I don’t know if there’d be a generic SQL query for this, but you could probably look at the email address field, or the “disabled” field in the users table, if you have account validation turned on in your config.inc.php file. If a spammer uses a fake email address to create an account, they won’t be able to validate it if you’ve enabled validation. A value of “1” in the disabled column indicates the account is not activated.

Once you’ve identified the users you want to remove you’ll need to use the merge users functionality in the Users and Roles area, or the command line tool that comes with OJS.

Best,
Jason

1 Like

Thanks Jason.

Cheers,
Obi

Hi Obi,

Not exactly what you are looking for, but this list include queries to find spam patterns:

Cheers,
m.

Thanks Marc. It is a very good start and I am going through them right now.

Cheers
Obi

1 Like