Author Topic: Search for spammers who have first name = last name? (Read 1750 times)

Tiffani Chin · January 10, 2013, 10:45:15 am

My first CiviCRM enabled site was password protected and works brilliantly-- and then I naively left my second, public, site very vulnerable to spammers.

I have gone through and manually deleted thousands of fake Drupal Users and their comments.

But of course, these "people" all have CiviCRM records too.

The vast majority of them have the same first name and last name. So I'd love to do a search of first name=last name and bulk delete but can't find a good way in the UI to do so.

I can do this in the database, but I wonder if deleting users in that way will mess up others things.

Does anyone have any advice?

BTW -- we're using Drupal's Mollom module now and it has made a tremendous difference in keeping out the spammers. Fingers crossed that it keeps up.

Thanks in advance!
-tiffani

Hershel · January 10, 2013, 11:07:16 am

Hi. It is definitely not recommended to just delete contact records via SQL. Perhaps you could write a custom search to find these records. If not, you could write a bit of custom PHP code to find the records and then delete them via the API. That would be the correct way.

Jason W · January 10, 2013, 11:52:45 am

Hello tiffani,

My suggestion would be to Use the advanced search's ability to search for contacts that were added during a certain time period. Go to advanced search and expand the change log accordion. Now set the range to the period starting with the added date of the first 'spammer', to today's date. you still have to weed through a few contacts, but at least you can select them, then delete the selected from the actions menu.

Cheers,
Jason

Tiffani Chin · January 10, 2013, 03:55:22 pm

Thanks to you both.

Hershel -- No matter how many online PHP tutorials I do, my skills do not keep pace with my desire to program! But, this gives me further motivation to be able to do it "the right way." Thanks for confirming that I should not delete from the database. I was so tempted.

Jason W -- thanks for the newbie friendly suggestion. I guess I have some searching and clicking to do!

Thanks.

robinhood · January 15, 2013, 04:09:34 am

Tiffani had a good idea here, so I posted a custom search for individuals with first_name = last_name here. Hope others find it to be useful.

Tiffani Chin · January 18, 2013, 02:17:10 pm

Wow -- robinhood, you're amazing!
Haven't tried it yet but excited to!

Also going to scope your code. Would love to be able to write a custom search.

Thanks!

robinhood · January 18, 2013, 08:41:27 pm

Nothing amazing about it. I found that writing a custom search is really quite easy and useful. If I can figure out how to turn it into an extension, that would be better.

Laryn · April 17, 2014, 09:23:54 am

@robinhood, do you have this code working for 4.4? I just tried to install it but get this:

Code: [Select]

Fatal error: Declaration of CRM_Contact_Form_Search_Custom_SpamNames::all() must be compatible with that of CRM_Contact_Form_Search_Interface::all()...

I'm not sure if it's due to changes from 4.2 to 4.4?

robinhood · April 17, 2014, 07:08:30 pm

The version for Civi 4.4 is here.

CiviCRM Community Forums (archive)

News:

Author Topic: Search for spammers who have first name = last name? (Read 1750 times)

Tiffani Chin

Search for spammers who have first name = last name?

Hershel

Re: Search for spammers who have first name = last name?

Jason W

Re: Search for spammers who have first name = last name?

Tiffani Chin

Re: Search for spammers who have first name = last name?

robinhood

Re: Search for spammers who have first name = last name?

Tiffani Chin

Re: Search for spammers who have first name = last name?

robinhood

Re: Search for spammers who have first name = last name?

Laryn

Re: Search for spammers who have first name = last name?

robinhood

Re: Search for spammers who have first name = last name?