More PS clean-up [#1478056]

Here are 111 more profile spammers. Some of them are very extreme, some are less so. This list is in numeric order.

Only one of them (1817078), has created any posts (and that one post should probably be considered spam, as it is off topic and snarky). If you want to double check my manual process (buy linking to whatever table contains posts), I won't be offended.

The CSV below will hopefully ease clean-up (a'la http://drupal.org/node/1477344#comment-5717764).

77211,228461,267003,280563,287302,342634,352856,356181,364372,375792,377655,411724,417715,425340,451682,614116,644090,671214,674822,790622,812174,816478,846918,861752,874402,926816,941210,955044,963972,979618,990470,992194,1011820,1019578,1023672,1031044,1049314,1056812,1090248,1096324,1123988,1141988,1181312,1212012,1233056,1271676,1276772,1311808,1346612,1352718,1373370,1373754,1388898,1392508,1400026,1422106,1430544,1449386,1457490,1553724,1574084,1582212,1587012,1592112,1592138,1609750,1615980,1616008,1616472,1616514,1616536,1616576,1618646,1621026,1621226,1624384,1625892,1658388,1658466,1675690,1680710,1680882,1681622,1681670,1681712,1681716,1681718,1681810,1681826,1720936,1720938,1720940,1720946,1720954,1720956,1720960,1720966,1720968,1720970,1721190,1721200,1726372,1726378,1755846,1757548,1766884,1776078,1784724,1809188,1817078,1828000

I tried to attach a pdf or xls to allow easy review (or sampling) of the users. However, I kept getting "An HTTP error 0 occurred. /upload/js". Not sure why, as I have previously attached pdfs; this was not big, or opened by some other process. If somebody wants a pdf, message me an email address, or different approach, etc.

Comment	File	Size	Author
	DO Profile Spammers Batch2 without CSV.xls	20.5 KB	dougsap

Comments

Comment #1

dougsap commented 12 March 2012 at 16:55

Here are the same profiles in a different format to facilitate review.

Comment #2

cweagans

He/Him

English

Boise, ID, USA

commented 13 March 2012 at 22:49

Verified that these are all spammers.

Comment #3

dww

we/he/they

commented 13 March 2012 at 22:49

Assigned:	Unassigned	» dww
Status:	Active	» Fixed

mysql> UPDATE users SET status = 0 WHERE uid IN (77211,228461,267003,280563,287302,342634,352856,356181,364372,375792,377655,411724,417715,425340,451682,614116,644090,671214,674822,790622,812174,816478,846918,861752,874402,926816,941210,955044,963972,979618,990470,992194,1011820,1019578,1023672,1031044,1049314,1056812,1090248,1096324,1123988,1141988,1181312,1212012,1233056,1271676,1276772,1311808,1346612,1352718,1373370,1373754,1388898,1392508,1400026,1422106,1430544,1449386,1457490,1553724,1574084,1582212,1587012,1592112,1592138,1609750,1615980,1616008,1616472,1616514,1616536,1616576,1618646,1621026,1621226,1624384,1625892,1658388,1658466,1675690,1680710,1680882,1681622,1681670,1681712,1681716,1681718,1681810,1681826,1720936,1720938,1720940,1720946,1720954,1720956,1720960,1720966,1720968,1720970,1721190,1721200,1726372,1726378,1755846,1757548,1766884,1776078,1784724,1809188,1817078,1828000);
Query OK, 111 rows affected (0.01 sec)
Rows matched: 111  Changed: 111  Warnings: 0

Comment #4

dww

we/he/they

commented 13 March 2012 at 22:50

p.s. Feel free to just reopen one of these if there's another big block. We don't need separate issues for each one of these IMHO...

Comment #5

dougsap commented 14 March 2012 at 03:42

Thanks Derek and Cameron!

I appreciate being able to reopen this issue for some more clean-up (rather that cluttering up my post history). I will be posting three smaller, more digestible, batches (3 x 46 = 138), a bit later. Don't worry, I won't constantly be doing this.

Comment #6

dougsap commented 14 March 2012 at 03:49

Batch #1 - 46 Profile Spammers

142162,145421,157136,178350,263267,295506,375282,403972,421136,633474,696122,753862,759628,763390,786700,838932,902732,926798,928480,935544,956860,956864,966144,1028938,1031556,1087150,1105618,1152330,1230992,1251396,1264660,1286920,1292226,1294708,1309490,1314168,1332510,1339384,1351412,1358242,1368038,1394970,1399762,1403626,1412186,1412762

URLs to facilitate review:

Comment #7

dougsap commented 14 March 2012 at 03:52

Batch #2 - Another 46 Profile Spammers

1424494,1432062,1436814,1448680,1452768,1458788,1490156,1499968,1500612,1521914,1532230,1534314,1537766,1547114,1573138,1574450,1574970,1577810,1580036,1580784,1581560,1585704,1592306,1599722,1605940,1607620,1610850,1615708,1616648,1618162,1618504,1618626,1618700,1618834,1619010,1621100,1627410,1637256,1643084,1658430,1666206,1670228,1673434,1680760,1680780,1680782

URLs to facilitate review:

Comment #8

dougsap commented 14 March 2012 at 03:59

Batch #3 - Yet another 46 Profile Spammers

1681532,1681546,1681876,1706418,1721048,1726072,1734926,1737964,1740754,1752702,1759054,1765230,1772016,1776016,1782994,1783892,1795470,1797914,1799118,1803176,1803520,1807964,1811168,1812732,1814320,1814586,1815842,1817890,1818152,1819738,1819882,1822542,1822610,1824716,1824732,1826752,1827118,1829940,1830506,1831954,1832148,1842148,1850386,1853264,1858644,1859386

URLs to facilitate review:

Ah... the economies of scale.

Comment #9

dougsap commented 14 March 2012 at 04:03

Assigned:

dww

» Unassigned

Reopening this with more similar, but different users, clean-up.

Comment #10

dougsap commented 14 March 2012 at 04:57

Status:

Fixed

» Active

Back to active status.

Comment #11

silverwing commented 14 March 2012 at 05:10

@dougsap Thank you!

Comment #12

cweagans

He/Him

English

Boise, ID, USA

commented 14 March 2012 at 11:39

Title:

111 More Profile Spammers (with CSV included)

» Insane number of profile spammers

Comment #13

cweagans

He/Him

English

Boise, ID, USA

commented 14 March 2012 at 11:41

dougsap, man, how are you finding all of these? Are you just going through all of the user accounts? Thanks for finding these - don't let anyone tell you that it's annoying. Getting this kind of thing cleaned up is really a good thing.

Comment #14

dww

we/he/they

commented 14 March 2012 at 17:52

Status:

Active

» Fixed

Re: #6:

mysql> UPDATE users SET status = 0 WHERE uid IN (142162,145421,157136,178350,263267,295506,375282,403972,421136,633474,696122,753862,759628,763390,786700,838932,902732,926798,928480,935544,956860,956864,966144,1028938,1031556,1087150,1105618,1152330,1230992,1251396,1264660,1286920,1292226,1294708,1309490,1314168,1332510,1339384,1351412,1358242,1368038,1394970,1399762,1403626,1412186,1412762);
Query OK, 46 rows affected (0.18 sec)
Rows matched: 46  Changed: 46  Warnings: 0

Re: #7:

mysql> UPDATE users SET status = 0 WHERE uid IN (1424494,1432062,1436814,1448680,1452768,1458788,1490156,1499968,1500612,1521914,1532230,1534314,1537766,1547114,1573138,1574450,1574970,1577810,1580036,1580784,1581560,1585704,1592306,1599722,1605940,1607620,1610850,1615708,1616648,1618162,1618504,1618626,1618700,1618834,1619010,1621100,1627410,1637256,1643084,1658430,1666206,1670228,1673434,1680760,1680780,1680782);
Query OK, 46 rows affected (0.03 sec)
Rows matched: 46  Changed: 46  Warnings: 0

Re: #8:

mysql> UPDATE users SET status = 0 WHERE uid IN (1681532,1681546,1681876,1706418,1721048,1726072,1734926,1737964,1740754,1752702,1759054,1765230,1772016,1776016,1782994,1783892,1795470,1797914,1799118,1803176,1803520,1807964,1811168,1812732,1814320,1814586,1815842,1817890,1818152,1819738,1819882,1822542,1822610,1824716,1824732,1826752,1827118,1829940,1830506,1831954,1832148,1842148,1850386,1853264,1858644,1859386);
Query OK, 46 rows affected (0.02 sec)
Rows matched: 46  Changed: 46  Warnings: 0

dougsap: Thanks for all your work hunting these down!

Cheers,
-Derek

Comment #15

dougsap commented 15 March 2012 at 05:38

Title:	Insane number of profile spammers	» More PS clean-up
Status:	Fixed	» Active

This batch is slightly different in that all of them were identified from Groups.d.o. This is a sample ~Proof of Concept Batch~ of 14 users, where I am including data from d.o & g.d.o. In retrospect, some subset of the profiles which were previously cleaned up probably had related g.d.o profiles that I did not identify - and honestly, I don't know how to easily do that.

I am hoping for further clean-up I can just identify one of the profiles, as it is sort of painful to capture both of them and keep them in synch. In my dream world, we would just clean-up the primary d.o. profile and the g.d.o. profile would automatically disappear. I am guessing that there are many hundreds of similar entries to clean-up.

Groups URL.......................................... User Profile...............................
http://groups.drupal.org/user/1004484 http://drupal.org/user/1449720
http://groups.drupal.org/user/1093874 http://drupal.org/user/1506134
http://groups.drupal.org/user/1115304 http://drupal.org/user/1520140
http://groups.drupal.org/user/1128809 http://drupal.org/user/1529350
http://groups.drupal.org/user/1139329 http://drupal.org/user/1537330
http://groups.drupal.org/user/1173749 http://drupal.org/user/1558326
http://groups.drupal.org/user/1460438 http://drupal.org/user/1725978
http://groups.drupal.org/user/1526708 http://drupal.org/user/1772312
http://groups.drupal.org/user/254034 http://drupal.org/user/966842
http://groups.drupal.org/user/258244 http://drupal.org/user/975456
http://groups.drupal.org/user/569989 http://drupal.org/user/1186508
http://groups.drupal.org/user/618754 http://drupal.org/user/1215034 (Look at this one in g.d.o!)
http://groups.drupal.org/user/858364 http://drupal.org/user/1360866
http://groups.drupal.org/user/968264 http://drupal.org/user/1426534

Hear are the primary d.o. user profile numbers :

1449720,1506134,1520140,1529350,1537330,1558326,1725978,1772312,966842,975456,1186508,1215034,1360866,1426534

Another reason that I hope to just give you one or the other profile, is that if the g.d.o. CSV file were erroneously applied to d.o., it might be pretty painful. Note: I intentionally obscured the title of this issue a bit, because soon a bunch of link builders are going to be wondering what's going on. Thanks!

Comment #16

cweagans

He/Him

English

Boise, ID, USA

commented 15 March 2012 at 06:21

I blocked http://drupal.org/user/1215034 on Drupal.org through the web interface, and it appears that it will go through and block them on the other sites. Maybe we need to build out a tool that will take a list of uids and block them on all of the Drupal.org sites - all of the users that have previously been blocked may need the same treatment on the subsites :/

Comment #17

dougsap commented 15 March 2012 at 09:25

Here is a batch of 34 mostly created by the same person. They have GDO profiles related to them, too.

913130,953842,966652,976874,987864,998382,1067460,1257704,1260672,1350134,1354268,1361476,1364526,1380204,1385536,1395642,1397790,1415954,1467556,1468046,1471804,1481558,1489772,1492764,1501124,1502156,1503402,1509010,1510412,1511010,1511536,1513454,1790626,1802688

Thanks!

Comment #18

greggles

he/him

English

Denver, Colorado, USA

commented 15 March 2012 at 16:59

Blocking on d.o will automatically block on g.d.o IF it is done via a user_save and not the DB. So, we need to actually do these with "drush user-block" instead of the DB query.

Users previous blocked via db had to be unblocked, so I did:


drush @do user-unblock Kitzabu --uid=77211,228461,267003,280563,287302,342634,352856,356181,364372,375792,377655,411724,417715,425340,451682,614116,644090,671214,674822,790622,812174,816478,846918,861752,874402,926816,941210,955044,963972,979618,990470,992194,1011820,1019578,1023672,1031044,1049314,1056812,1090248,1096324,1123988,1141988,1181312,1212012,1233056,1271676,1276772,1311808,1346612,1352718,1373370,1373754,1388898,1392508,1400026,1422106,1430544,1449386,1457490,1553724,1574084,1582212,1587012,1592112,1592138,1609750,1615980,1616008,1616472,1616514,1616536,1616576,1618646,1621026,1621226,1624384,1625892,1658388,1658466,1675690,1680710,1680882,1681622,1681670,1681712,1681716,1681718,1681810,1681826,1720936,1720938,1720940,1720946,1720954,1720956,1720960,1720966,1720968,1720970,1721190,1721200,1726372,1726378,1755846,1757548,1766884,1776078,1784724,1809188,1817078,1828000,142162,145421,157136,178350,263267,295506,375282,403972,421136,633474,696122,753862,759628,763390,786700,838932,902732,926798,928480,935544,956860,956864,966144,1028938,1031556,1087150,1105618,1152330,1230992,1251396,1264660,1286920,1292226,1294708,1309490,1314168,1332510,1339384,1351412,1358242,1368038,1394970,1399762,1403626,1412186,1412762,1424494,1432062,1436814,1448680,1452768,1458788,1490156,1499968,1500612,1521914,1532230,1534314,1537766,1547114,1573138,1574450,1574970,1577810,1580036,1580784,1581560,1585704,1592306,1599722,1605940,1607620,1610850,1615708,1616648,1618162,1618504,1618626,1618700,1618834,1619010,1621100,1627410,1637256,1643084,1658430,1666206,1670228,1673434,1680760,1680780,1680782,1681532,1681546,1681876,1706418,1721048,1726072,1734926,1737964,1740754,1752702,1759054,1765230,1772016,1776016,1782994,1783892,1795470,1797914,1799118,1803176,1803520,1807964,1811168,1812732,1814320,1814586,1815842,1817890,1818152,1819738,1819882,1822542,1822610,1824716,1824732,1826752,1827118,1829940,1830506,1831954,1832148,1842148,1850386,1853264,1858644,1859386,1449720,1506134,1520140,1529350,1537330,1558326,1725978,1772312,966842,975456,1186508,1215034,1360866,1426534,913130,953842,966652,976874,987864,998382,1067460,1257704,1260672,1350134,1354268,1361476,1364526,1380204,1385536,1395642,1397790,1415954,1467556,1468046,1471804,1481558,1489772,1492764,1501124,1502156,1503402,1509010,1510412,1511010,1511536,1513454,1790626,1802688

drush @do user-block Kitzabu --uid=77211,228461,267003,280563,287302,342634,352856,356181,364372,375792,377655,411724,417715,425340,451682,614116,644090,671214,674822,790622,812174,816478,846918,861752,874402,926816,941210,955044,963972,979618,990470,992194,1011820,1019578,1023672,1031044,1049314,1056812,1090248,1096324,1123988,1141988,1181312,1212012,1233056,1271676,1276772,1311808,1346612,1352718,1373370,1373754,1388898,1392508,1400026,1422106,1430544,1449386,1457490,1553724,1574084,1582212,1587012,1592112,1592138,1609750,1615980,1616008,1616472,1616514,1616536,1616576,1618646,1621026,1621226,1624384,1625892,1658388,1658466,1675690,1680710,1680882,1681622,1681670,1681712,1681716,1681718,1681810,1681826,1720936,1720938,1720940,1720946,1720954,1720956,1720960,1720966,1720968,1720970,1721190,1721200,1726372,1726378,1755846,1757548,1766884,1776078,1784724,1809188,1817078,1828000,142162,145421,157136,178350,263267,295506,375282,403972,421136,633474,696122,753862,759628,763390,786700,838932,902732,926798,928480,935544,956860,956864,966144,1028938,1031556,1087150,1105618,1152330,1230992,1251396,1264660,1286920,1292226,1294708,1309490,1314168,1332510,1339384,1351412,1358242,1368038,1394970,1399762,1403626,1412186,1412762,1424494,1432062,1436814,1448680,1452768,1458788,1490156,1499968,1500612,1521914,1532230,1534314,1537766,1547114,1573138,1574450,1574970,1577810,1580036,1580784,1581560,1585704,1592306,1599722,1605940,1607620,1610850,1615708,1616648,1618162,1618504,1618626,1618700,1618834,1619010,1621100,1627410,1637256,1643084,1658430,1666206,1670228,1673434,1680760,1680780,1680782,1681532,1681546,1681876,1706418,1721048,1726072,1734926,1737964,1740754,1752702,1759054,1765230,1772016,1776016,1782994,1783892,1795470,1797914,1799118,1803176,1803520,1807964,1811168,1812732,1814320,1814586,1815842,1817890,1818152,1819738,1819882,1822542,1822610,1824716,1824732,1826752,1827118,1829940,1830506,1831954,1832148,1842148,1850386,1853264,1858644,1859386,1449720,1506134,1520140,1529350,1537330,1558326,1725978,1772312,966842,975456,1186508,1215034,1360866,1426534,913130,953842,966652,976874,987864,998382,1067460,1257704,1260672,1350134,1354268,1361476,1364526,1380204,1385536,1395642,1397790,1415954,1467556,1468046,1471804,1481558,1489772,1492764,1501124,1502156,1503402,1509010,1510412,1511010,1511536,1513454,1790626,1802688

It takes a few minutes to do that, but it seems to work.

Future editions should be easier. Note that for drush user-block you have to give it a username of a user even if you are specifying all users via a --uid= string.

Comment #19

dougsap commented 15 March 2012 at 18:52

Future editions should be easier. Note that for drush user-block you have to give it a username of a user even if you are specifying all users via a --uid= string.

For future clean-up, which of the following do you want (and is format as desired)?
All are doable, but it is part of only a semi automated process, so I don't want to supply something unneeded; also if we don't include the usernames some of the link builders will have less insight to why things are disappearing. (This is sample data only, no need to block these now. Will be in a future request.)

a) Profile for review

http://drupal.org/user/1641642
http://drupal.org/user/1641764
http://drupal.org/user/1341424
http://drupal.org/user/1644182
http://drupal.org/user/1641618

b) uids
1641642,1641764,1341424,1644182,1641618

c) usernames
isisexicng,joioacarho,sillmaxwelton478,ehdzulqqcs,nmijutvxsw

Thanks!

Comment #20

greggles

he/him

English

Denver, Colorado, USA

commented 15 March 2012 at 19:39

Well, if I have a choice I think comma separated usernames seem great!

Comment #21

dougsap commented 15 March 2012 at 20:08

Here are 53 blatant profile spammers. Most were created by the same person. When not clearly the same pattern, I checked that referenced sites were not Drupal (and there were no posts in d.o.).

Just for background, here is an example of a related g.d.o. profile:
http://groups.drupal.org/user/1329418

billmiller1202,paullou,mariesoria2086,penterxz,calendar21,mrdongvaporsh,Mark03Potter,electcigarette7,k2smokejvfkf,myrder54,jackiegibbonsk,electriccigala,fontmyr254,Eugene19Hughes,carmon543,edwin7alinastuk,merrwi87,edwins9alinaszn,billcar43,fonmar54,sillmaxwelton478,brocha543,mibrand432,marefr419,electricigaret,lazbru87,cigrtonic,eciprw8garettef,michael23447,eci8tgstdfa,ecieygcb6tsbuy,grelo3encigaret,dianneshin123,nmijutvxsw,isisexicng,vfpsrutmni,joioacarho,ehdzulqqcs,smssufarxy,ncqheudtzj,jbypdgclgt,agcnkuarvw,bgcgbvvvht,vbswkcndln,xcsgdfbbvz,ygbfihnuyt,zqguuqcacp,isykpkfxsp,xqophoangk,zowrsxxiwz,deivertjrp,gsgclflwad,mankashz

Let me know if a different format is better. Many more will be coming - I might start naming the batches so they are easier to identify, stage, and track. I realize that this clean-up may not be as time critical as some other activities (especially during Drupalcon). Thanks!

Comment #22

killes@www.drop.org commented 15 March 2012 at 20:29

Status:

Active

» Fixed

all blocked, thanks!

Comment #23

dougsap commented 15 March 2012 at 22:09

Status:

Fixed

» Active

Here is a batch identified as Caamerafans. 108 profiles bigger than typical batch because they are mostly similar and quite well screened (when in doubt, I left a couple out). Actually, I am probably going to increase the batch size when contents similar and straightforward - let me know if that causes any problems.

jjbaulikki,phiparr9,boydwebb,dcamwilson1,maryheubel1229,mdodd,marty22,janetgomez1975,ahmadtoyyib,Ashton23,Molly741,lurtemielby,cuddeback,melody05,Vinchellete0818,eellis2927,mddiamond2953,Xenith03,Yukiameracfoqy,Kindratamerazs,outdoorwirelow,Vickieebelamer,Jockebleamerac,Gerardamerasboh,Janelamerauonyu,Sherry72,ctvsystemskqcu,nikondigitalca,Conraylmerasyw,calumameraakfj,Mcclurecaelame,Ralphbelmeratt,Helenonbelsaxts,Brianbelmeratbu,lilianbagchusa,Annaleosojbrqb,Halvormerabzsr,Itzikmerandspnq,Edwineleospjjh,Fullermeraexlx,Karenleosfsfi,digitalsurvepe,duanemaldonado8,hdfootagewafy,gordonizenberg,Jeffreymeraseu,StansN01,wirelessip525,chopd2eosezxrac,Chanmerawkn,brezel89,warrenpiette00,chatsero8b,misaailen,chotk9osemkt67a,anniebaker24,spygadgetsclewj,nikonp100price,menswatchesimm,elizabethtaylo,spygadgetsonli,Edna72,besdf8tcnj7came,nig9bhtvisioca5,bes5ptdigigbe52,allenasqw,billdsfs,zeilamccormick,bes5mfxtc4oiedr,diggaitalcame8a,secrmuritycamsh,simpdoy25,carrieCamcorder,dig8mwitalcayqr,nigbehtvisiocpd,vidcw8qeo7ekdca,hom5bccesurveil,the7xffl7pc,wirbgq2elesshil,digcx2xitalcaaf,bes3lftchrx8ame,besmbr8tdigiwy5,enikfond7,JedidiahLehmann,dig4jtitalca4zn,fakmwbesecurngq,mot3afiondete6g,miconder99,calvinsimpson23,CarterShaw,raye2011,louismat360,ipigxunjgk,zwurdukgnc,zynlzwibps,travisbakre6,vioyejvtox,gqrdsqylcr,czzpkvapyb,tnlqkjwimy,eikomssgrr,xlbrowxoad,iaahtzyooo,szhrnshrya,jeanenebal42,ximea,0a23fadn26hn

For background, here are a sample of related GDO profiles:
http://groups.drupal.org/user/1105504
http://groups.drupal.org/user/1429308
http://groups.drupal.org/user/1455198
Thanks!

Comment #24

killes@www.drop.org commented 16 March 2012 at 00:45

Status:

Active

» Fixed

Thanks again!

Comment #25

dougsap commented 16 March 2012 at 02:02

Status:

Fixed

» Active

Here is a batch identified as Recipefoo. 97 profiles well screened (when in doubt, I left a couple out).

smoothies4all,Grilled Food Man,juibene56,edionnet,moncada11jessie,bryansalompas,bill3667,recipesywayio,recipesudofnp,Joseph Collins,easyrecipesygj,phoenixfmh,chocolateandco,phoenixchsttb,durhammexxdrr,recipeswnilto,gbmediterranea,easyrecipesbyk,ccpstorneyfwj,nnkbbkisllcez,jesusshearergyd,judahblandnjdq,shrimprecipecw,tamppfeqsrcar,darle4necocker,anitacurrielxzj,solarovenstom,recipesnbncqm,punchrecipesgc,souprecipeswegh,lehidentistwq,mvappetizerrec,souprecipesuyw,recipeswithchi,ndhcgdietrevie,applebreadretnu,petflowfood,dannylerouxpm,shrikantohanay,healthmasterre,menselectricra,jutsdllddzhvd,renaldietqvsf,jackcappsrhnq,easyrecipesccoi,coloncleansitdk,plupcssizewo5de,yohannesturo-s,pamdevissersc,easyrecipesuip,flooringuiasw,easyrecipesejy,easyrecipesnwe,odfry03hb15,claudiastankev,bestfoodprocew,diettips87,alisonreesevpdr,easyrecipesynml,chojoxcolatecnz,bes3gdstdinnafk,howahtogetek2c,17dag2aydi3qoet,suzlbanneswp2p9,dogmg2wfoodmln5,saf4tmehcgdxa7g,emetzxrse4qb,easbz8oyrza2nec,torabfaceynr6h,res4dsptauranyp,hom2ydeb9ytem2r,foo9zddproces2w,foo4dccdprocese,jeanguillgxj8,foobzo5dproces7,cooyckingqat7z8,eranscullyyo6,dog9pfoodeebrec,dog5ccfoodsrore,dogsdy5foodxt2r,appxtpetkk9bp6i,dogccy3foodqw2w,bes5cttdinnpp4d,dog9yfoodla2nre,tef5kpal4zseact,foo5ndproceszxi,dogohzfoodxb2gr,inf2ohj5tfood,inf6pean6egmtfo,dogxnefoodkatre,christinedelcam,cakamelpops,dogwithlove01,howfx5longtoik8,Thorne2345,a11rhrxdnkb7,brentspiner9

An example of a related GDO profile:
http://groups.drupal.org/user/1128594
Thanks!

Comment #26

killes@www.drop.org commented 16 March 2012 at 02:23

Status:

Active

» Fixed

and again

Comment #27

dougsap commented 16 March 2012 at 04:16

Status:

Fixed

» Active

Comment #28

cweagans

He/Him

English

Boise, ID, USA

commented 16 March 2012 at 04:26

Holy cow, man...you have the win. All of it.

Feel free to continue, if you feel like it. Nobody is going to complain about "excessive spammer clean up"! There's no such thing!

Comment #29

dougsap commented 18 March 2012 at 00:26

Status:

Fixed

» Active

Here is the first of 3 Lawyerzanddui. Sorted alphabetically by user name
Lawyerzanddui - A thru D = 117 users,
Lawyerzanddui - E thru M = 92 users,
Lawyerzanddui - N thru Z = 86 users, Total = 295

I was somewhat shocked that there are many in this category. There were several of these professionals that had more than 20 profiles basically pointing at the same site(s).

On with the show....

abderazx,abi9fwlenechild,abihi9ylened4gb,abitq5zlenefapc,akr8sonchilds8z,akronchildsupp,akronwrongfuld,akrta5onchildsx,albciuquerquech,albdmuquerquech,alcbbhgwcx,Aliiyah MIlchelle,allkc7jentownfe,allrx9entownftb,ana5zheimchildi,anitafaverjd,ann6bynarborwro,Annatalie6,antaqiochdpb4lw,antoliochfa4jsp,antzj5iochchild,Ardybrew01,arl7jingtonchil,ath9oenswrongfu,att6dnornecjyyl,att9igorne3zsnx,AttorneyLaw29,attorneyvictgks,attorneyvictmr,attrny888,attrnybank1,attrnypro1,auglq6fustawron,autoaccidentvmd,AynGobbel,barjyristews5rd,bbbvghflji,berniegreendal,bestmexicanatt,Beth44,bethanyoldham52,Billy_Skinner,bnkattrny1,bosie5ltonpate3,bosqdtonpatebx4,bracketz38,brannonfprs,britany101,buyewsitetji4i9,calkciforniames,calvinmassey7gr,cancunlawyercm,candace101,capdqecoralfaqx,capnpe7ecoralch,capplqecoralf7m,CarrieChu,cd29faa23,cellcontractos,ceurtemielby,chanecx,charlakouleshov,chrisburnzzz,christerreyerh,chriszang03,cleaneyumaxyj,clearwaterbbk,clearwaterdqd,clearwaterjux,clezop2arrbank,closingattoramx,codyhowell,coloraefenw41,corporatevidau,cos5znftames5de,cre8txdstviewpe,criminalattorn,daisy101,dallasspa,DamarisGraham,DaneEd,danlaw99,Danski123,davewade2307,davewade2337,davewade2338,davewade2339,dawnritsonellio,Defense01,den8wbverbankru,denswaverbankru,denveru4hzorney,div5corceattorn,divorceattorcd,divorceattorcf,divorceattorch,divorceattorib,divorceattornf,divorceattornly,divorceattornv,divorceattoroan,divorceattorom,divorceattorqy,divorceattorsbw,divorceattorvf,divorceattorwuw,divorceattorxbs,divorcedfr82ila,divorcelawyerm,divwze6orceatto,donaldsessions,dui lawyer,duiattorneyvbgy,duiattorneyvld,duiattorneyvpa,duilawyerfortm,dumitrutijerina

Don't be too worried if the block for any of these batches finds one or two less than indicated. There is a small chance that something in the cigsandstuff batch was picked up again here (since that blocking had not occurred when I was extracting this data) - those items, if any, might disappear before this clean-up. There is little risk from things not being blocked/deleted since there will be some subsequent extracts using the same selection criteria.

Comment #30

dougsap commented 16 March 2012 at 08:55

This is Lawyerzanddui - E thru M = 92 users

eattorneyckvv,EdwardWilliam,elizabethfritt,ErscyllC58,eurozxc,familylawattorn,finance101,fiorelawfiryat,FreezaC280,gayleluebesmie,grajqendrapid5z,grazelle101,gterry693hrjf,haifanreen,Hankok26,harold2807,helenetianoskld,helenguthriesee,hemorrhoidtrwr,HerdonHVR,hjonas2379,hollie07,Houston01,inj7joyuryattoy,innasehysm,jacobalex220,jas4tonoj9tnwgu,jas6fnponlb5zgu,jas6gcoonwmngua,jas9nqsonwzwjgu,jasbdgonsen9tjg,jasbmcon2kcjgua,jasckonak9z8pgu,jasonguaricnat,jasonguarifpcc,jasonguarijizr,jasonguarimayj,jasonguarinqvk,jasonjguarigdql,jasonjguarihld,jasonjguaripms,jasonjguarithy,jasonjguarixzib,jasrekon5waguar,jaszaonsxr4jgua,jaszcn9on4rrafe,jeanninehackedx,jhndrson3395,johnhenlar08,johnsKelly,jwash4302,kayen22,kentmccoy051,kerryhicksif,KhennyJ,kimberlycraigs,lawforvets88,lawsuitsez,lawvet45,lawxq5xyere4hed,lawyerd52,lawyerd59,lawyerinpenang,lawyerpf8,lawyertf1,legalconslt1,leocila101,leslieadela,lharrison2389,LilAva66,lionelgroulx2,lizanmari,looifarleyvhdk,lorenzo2802,lyka22,mac1,MacMD100,MaineHazen,manTha36,Margaux Williams,martinreeves,MathewDesroches,mathisky8,melissabooysena,mesotheliomase,micbehigantruck,millardf44,mindb4neapolisz,minfra9neapolis,Muckez_29,munwaistchastrj,myiernlqjf

Comment #31

dougsap commented 16 March 2012 at 09:16

Lawyerzanddui - N thru Z = 86 users

naoie02,neal09mike,Nika_09,nofyjkault6ctem,normangershona,oddvarpengabp2,olusholawingal,orahcpngecou4bp,Pax127,paynestew48,pen2qczsacolaac,pen6gxasacoladi,penifsacolafldi,pensacoladenqqr,pensacoladivkkb,pensacolafamil,pensacolafamma,pensacolapercr,pensacolaperecp,per4wsonalinjur,persdsonalinjur,personalinjurqp,perst2sonalinju,Power of Attorney,probateattorne,probateattorvri,pwphnssesi,RaizelNewtown,rea7dqtlestatel,rea8nylestatelj,realestateny,renatowaserot,riverael160,Robert378,russelljonsson,samuelargyriou,san8qcjosebusi6,sananton6h,sananton8d,Sandhi0108,sebclearylrey,seotpi4brpmd96s,sexcrimesrnp,shanealter123,sharulizamsmar,shreefindlayue,speedket3309,sridavidson,st56fpete7y5g,stan161,sterlingeagarp,Steve Aycock,sticket3309,Swanks60,tamzf7paflchild,taneyabllookj,tanya170,teisha469,tempebankruptc,tennesseeautxsl,terryromero8,tex5msrastrucka,tex8hpasinjuryj,tlawyer2943,traflawyr3407,trubsckaccidem7,TSG1Art408,uxmwlyypid,uzausqrcir,v431nnerc_018,vaclaimz1,vadisabatt69,Veronica Parker,vetatt55,vetattrny1,vetattrny44,veterenlaw25,victoriacurrief,W3ndyiserqf,wallyjuwaramp,waxman247,wendylindsay1968,wimundswet60,winattrny11,yumiko89,zandijonz

URLs to facilitate review:

Thanks to everybody in the clean-up of at least 1,129 profiles! I'll be doing some other things until Monday afternoon, but plan to proceed on a time available basis after that. As the water level is lowered, more rocks are exposed. Happy St Patrick's Day!

Comment #32

killes@www.drop.org commented 16 March 2012 at 11:07

Status:

Active

» Fixed

Thanks again, I blocked all of them!

As this issue is getting lengthy, please open new issues for any new lists of profile spammers.

Comment #33

greggles

he/him

English

Denver, Colorado, USA

commented 16 March 2012 at 14:18

@dougsap,

for ($i = 1; $i <= 1129; $i++) {
    echo "dougsap is the best!";
}

Comment #34

dww

we/he/they

commented 16 March 2012 at 17:42

Agreed with #33 -- holy crap! ;) I got busy with other things for a couple days and huzzah! Nice work, dougsap!!!

And thanks greggles for working out the bakery stuff, I somehow assumed bakery Just Knew(tm) but that was obviously false. ;) And thanks to killes for stepping in and clearing out these batches.

Praise all around!

Cheers,
-Derek

Comment #35

1 April 2012 at 00:33

Status:

Active

» Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.