10:17 AM
alastairp
but if you are only interested in the mood, you could just download the highlevel json archive (which is much smaller)
2016-03-10 07018, 2016
10:17 AM
alastairp
because the mood information is encoded in these files
2016-03-10 07052, 2016
10:18 AM
harshul1610 has quit
2016-03-10 07013, 2016
10:47 AM
armalcolite has quit
2016-03-10 07025, 2016
10:52 AM
rahulr has quit
2016-03-10 07049, 2016
11:34 AM
for15pounds has quit
2016-03-10 07016, 2016
11:46 AM
D4RK-PH0ENiX has quit
2016-03-10 07058, 2016
12:00 PM
CJ_
Freso, I was just giving alastairp a hard time. :)
2016-03-10 07021, 2016
12:01 PM
alastairp
wait. why did everyone take that discussion so seriously?
2016-03-10 07026, 2016
12:02 PM
CJ_
alastairp, I have no idea.
2016-03-10 07023, 2016
12:07 PM
D4RK-PH0ENiX joined the channel
2016-03-10 07052, 2016
12:22 PM
Skeebadoo joined the channel
2016-03-10 07057, 2016
12:22 PM
Skeebadoo
haha oh wow
2016-03-10 07009, 2016
12:23 PM
Skeebadoo
I wanted to check how many people actually filled out my city
2016-03-10 07010, 2016
12:23 PM
Skeebadoo
2016-03-10 07019, 2016
12:23 PM
Skeebadoo
most of these are some ad spam bots
2016-03-10 07020, 2016
12:24 PM
Skeebadoo
2016-03-10 07022, 2016
12:24 PM
Skeebadoo
some clinic
2016-03-10 07050, 2016
12:24 PM
Skeebadoo
2016-03-10 07051, 2016
12:24 PM
alastairp
2016-03-10 07052, 2016
12:24 PM
Skeebadoo
party arranging
2016-03-10 07057, 2016
12:24 PM
alastairp
reosarevok: ^^
2016-03-10 07058, 2016
12:24 PM
Skeebadoo
2016-03-10 07004, 2016
12:25 PM
Skeebadoo
jesus christ
2016-03-10 07005, 2016
12:25 PM
alastairp
Skeebadoo: thanks. reosarevok can delete them
2016-03-10 07008, 2016
12:25 PM
Freso
Skeebadoo: Please report spam accounts using the "Report editor" link.
2016-03-10 07011, 2016
12:25 PM
Freso can too
2016-03-10 07014, 2016
12:25 PM
reosarevok
Sigh
2016-03-10 07017, 2016
12:25 PM
Skeebadoo
yeah but there's so many!
2016-03-10 07021, 2016
12:25 PM
Skeebadoo
it looks automated
2016-03-10 07037, 2016
12:25 PM
Freso
chirlu: Had a proposal up not long ago.
2016-03-10 07039, 2016
12:25 PM
Freso checks mail
2016-03-10 07049, 2016
12:25 PM
Freso
*chirlu had
2016-03-10 07058, 2016
12:25 PM
reosarevok
I guess it was useful after all to show the nearby users :p
2016-03-10 07012, 2016
12:26 PM
Freso
2016-03-10 07021, 2016
12:26 PM
Freso
Skeebadoo: ^ feel free to comment. :)
2016-03-10 07045, 2016
12:26 PM
Freso
reosarevok: ^ perhaps post to Discourse about it?
2016-03-10 07009, 2016
12:27 PM
reosarevok
"Any ideas what to do with spam?" or "Please report spam users!" or both?
2016-03-10 07009, 2016
12:27 PM
Skeebadoo
I'll read up the ticket comments
2016-03-10 07041, 2016
12:27 PM
Skeebadoo
And I'll report the ones from my city, but this looks like a flood, not anything to handle manually
2016-03-10 07045, 2016
12:27 PM
Freso
reosarevok: Both. :)
2016-03-10 07024, 2016
12:28 PM
outsidecontext has quit
2016-03-10 07025, 2016
12:28 PM
chirlu
I’ve been hesitant myself to use the report feature for profile-only spammers, but if you (account admins) like to be spammed (with reports), I can do that …
2016-03-10 07006, 2016
12:29 PM
chirlu
Oh … search server restart, it seems.
2016-03-10 07041, 2016
12:29 PM
Freso
2016-03-10 07043, 2016
12:29 PM
Freso sighs
2016-03-10 07008, 2016
12:30 PM
Freso
reosarevok: Do you have a template I can copy for writing to them and tell them that user profile != artist entry?
2016-03-10 07018, 2016
12:30 PM
reosarevok
Not really
2016-03-10 07057, 2016
12:30 PM
Freso will look at old support@ answers
2016-03-10 07008, 2016
12:31 PM
Freso
!!
2016-03-10 07014, 2016
12:31 PM
reosarevok
chirlu: if you're going to specifically go around looking for spammers it might make sense to just give you the permission to remove them. But if you just stumble upon some, reporting seems fine
2016-03-10 07018, 2016
12:31 PM
Freso
There *was* one spam profile "in" Copenhagen!
2016-03-10 07037, 2016
12:31 PM
chirlu
Well, it’s very easy to stumble over dozens of them.
2016-03-10 07040, 2016
12:31 PM
Freso
2016-03-10 07006, 2016
12:32 PM
reosarevok
Basically, if you see them it's reasonably likely others might, so they look bad, so we should remove them :p
2016-03-10 07018, 2016
12:32 PM
chirlu
If I happen to see blatantspammer17, often there are blatantspammer01, blatantspammer02, … also nearby.
2016-03-10 07021, 2016
12:32 PM
Freso
Huh.
2016-03-10 07053, 2016
12:32 PM
Skeebadoo
It's easier to pick out the real accounts in Wrocław area
2016-03-10 07056, 2016
12:32 PM
Skeebadoo
than spam ones :P
2016-03-10 07016, 2016
12:33 PM
Skeebadoo
Basically every account w/o any edits and with a link and short bio is a spam account
2016-03-10 07021, 2016
12:33 PM
Freso
I just went through all the Copenhagen users, and it seems only one was a spam profile.
2016-03-10 07019, 2016
12:34 PM
Hobbyboy has quit
2016-03-10 07004, 2016
12:36 PM
Sebastinas has quit
2016-03-10 07017, 2016
12:38 PM
Sebastinas joined the channel
2016-03-10 07059, 2016
12:38 PM
chirlu
2016-03-10 07043, 2016
12:39 PM
chirlu
2016-03-10 07048, 2016
12:39 PM
Freso
Heh.
2016-03-10 07009, 2016
12:41 PM
jaron joined the channel
2016-03-10 07010, 2016
12:41 PM
Jormangeud has quit
2016-03-10 07010, 2016
12:42 PM
Jormangeud joined the channel
2016-03-10 07059, 2016
12:44 PM
Hobbyboy joined the channel
2016-03-10 07036, 2016
12:51 PM
Freso
reosarevok: Are you on a spammer deletion spree incl. the ones having been reported now?
2016-03-10 07050, 2016
12:51 PM
Freso
Or should I do the reported ones if you're doing chirlu's searches? :)
2016-03-10 07003, 2016
12:54 PM
reosarevok
Freso: I'm killing draconians in Dungeon Crawl #workinghard
2016-03-10 07040, 2016
12:54 PM
reosarevok
For stuff where we have over a hundred easily findable spammers, we should probably write some botty thing
2016-03-10 07051, 2016
12:54 PM
reosarevok
Or a script for the DB, anyway
2016-03-10 07030, 2016
12:55 PM
Skeebadoo
I spammed you with ~40 spam account reports from Wrocław area
2016-03-10 07049, 2016
12:55 PM
Skeebadoo
other big cities in Poland don't seem to be affected fortunately :P
2016-03-10 07016, 2016
12:56 PM
chirlu
2016-03-10 07022, 2016
12:58 PM
Freso
Skeebadoo: Yep. Going through them now.
2016-03-10 07040, 2016
12:59 PM
Freso
I really wish there was a way to see if people had used the accounts for AcoustID or CB review submissions.
2016-03-10 07000, 2016
13:00 PM
Freso
Or anything else which needs an MB login.
2016-03-10 07026, 2016
13:01 PM
chirlu
Well, we know it unless they have later revoked the access.
2016-03-10 07041, 2016
13:01 PM
chirlu
2016-03-10 07005, 2016
13:02 PM
Skeebadoo
lol
2016-03-10 07030, 2016
13:04 PM
Freso
chirlu: Well, it isn't exposed anywhere. :)
2016-03-10 07002, 2016
13:05 PM
ariscop has quit
2016-03-10 07019, 2016
13:06 PM
Freso
Oops.
2016-03-10 07021, 2016
13:08 PM
chirlu
Right, but that could be changed.
2016-03-10 07022, 2016
13:10 PM
Freso
Yep.
2016-03-10 07030, 2016
13:10 PM
Freso
Writing up a ticket right now. :)
2016-03-10 07013, 2016
13:11 PM
ariscop joined the channel
2016-03-10 07033, 2016
13:13 PM
reosarevok
Would you automatically show links (or icons that link) to their profiles elsewhere that use oauth?
2016-03-10 07048, 2016
13:13 PM
Freso
2016-03-10 07051, 2016
13:13 PM
Freso
reosarevok: ^
2016-03-10 07044, 2016
13:15 PM
reosarevok
Hmm, ok
2016-03-10 07006, 2016
13:16 PM
reosarevok
I'd probably also generate icons for other profiles that are shown to every user
2016-03-10 07010, 2016
13:16 PM
reosarevok
Or at least logged in user
2016-03-10 07012, 2016
13:16 PM
reosarevok
But dunno
2016-03-10 07019, 2016
13:18 PM
armalcolite joined the channel
2016-03-10 07006, 2016
13:19 PM
armalcolite_ joined the channel
2016-03-10 07033, 2016
13:19 PM
armalcolite_ has left the channel
2016-03-10 07019, 2016
13:26 PM
jesus2099 joined the channel
2016-03-10 07050, 2016
13:27 PM
Freso
chirlu: Ah, sorry I missed that mention in your proposal. :)
2016-03-10 07038, 2016
13:28 PM
chirlu
Well, it wasn’t very detailed.
2016-03-10 07044, 2016
13:28 PM
ariscop has quit
2016-03-10 07029, 2016
13:34 PM
Freso
I do like the idea though.
2016-03-10 07046, 2016
13:36 PM
reosarevok
Freso: did you remove all the Skeebadoo reports now or should I take over?
2016-03-10 07040, 2016
13:41 PM
ruaok returns from an outing to the bank
2016-03-10 07029, 2016
13:42 PM
jaron has quit
2016-03-10 07059, 2016
13:42 PM
jaron joined the channel
2016-03-10 07004, 2016
13:43 PM
Freso
reosarevok: I did them all.
2016-03-10 07017, 2016
13:43 PM
reosarevok
:)
2016-03-10 07017, 2016
13:43 PM
Freso
Leaving now though, so feel free to take any further ones. :)
2016-03-10 07031, 2016
13:43 PM
Freso
2016-03-10 07058, 2016
13:43 PM
Freso
(I did a quick search and didn't find it to have been previously reported.)
2016-03-10 07011, 2016
13:44 PM
Freso
(I may well have been wrong though. Oh well.
2016-03-10 07013, 2016
13:44 PM
Freso
Out.)
2016-03-10 07015, 2016
13:44 PM
armalcolite
2016-03-10 07020, 2016
13:44 PM
Freso
armalcolite: Yes.
2016-03-10 07030, 2016
13:44 PM
Freso outz f'realz
2016-03-10 07058, 2016
13:44 PM
armalcolite
ok
2016-03-10 07059, 2016
13:54 PM
rahulr joined the channel
2016-03-10 07047, 2016
13:55 PM
yeeeargh has quit
2016-03-10 07039, 2016
14:09 PM
gcilou
alastairp: do you want the title of each table capitalized, or just keep how it is?
2016-03-10 07020, 2016
14:15 PM
ruaok
alastairp: Jen from BigQuery responded and they are only currently setup for batch imports.
2016-03-10 07035, 2016
14:15 PM
ruaok
she is, however, open for working out a streaming system, but it will take more "time".
2016-03-10 07042, 2016
14:15 PM
ruaok
trying to get "time" quantified.
2016-03-10 07024, 2016
14:19 PM
CatQuest is glad we're finally removing the spam accounts
2016-03-10 07046, 2016
14:23 PM
chirlu
Well, it’s a lot of work to identify and remove 800000 to 900000 spam accounts.
2016-03-10 07021, 2016
14:25 PM
jesus2099
wow, that many… (°_° )
2016-03-10 07002, 2016
14:27 PM
chirlu
Well, have a look at the number-of-editors timeline – the two steep slopes are >90% spammers.
2016-03-10 07042, 2016
14:28 PM
gcilou
2016-03-10 07027, 2016
14:40 PM
ruaok
clearly our sign-up captcha is doing shit all. can we upgrade to the latest and greatest and see if that improves things?
2016-03-10 07048, 2016
14:46 PM
zas
ruaok: couldn't we ask for revalidation of the account if a certain time of inactivity ?
2016-03-10 07058, 2016
14:46 PM
zas
2016-03-10 07036, 2016
14:47 PM
ruaok
works for me.
2016-03-10 07005, 2016
14:48 PM
CatQuest
that's no a dumb idea actually
2016-03-10 07017, 2016
14:48 PM
ruaok
or even deleting accounts that have been in active for 1 year and have had no activity.
2016-03-10 07044, 2016
14:48 PM
CatQuest
maybe more thna a year
2016-03-10 07059, 2016
14:48 PM
CatQuest would say something like 3-5 years
2016-03-10 07009, 2016
14:49 PM
CatQuest
there are procastinators
2016-03-10 07012, 2016
14:49 PM
CatQuest
i would know :D
2016-03-10 07019, 2016
14:49 PM
zas
yes, this is what i was thinking, after 3 months of inactivity, ask for revalidation, and if not done, ask each 3 months until one year, then delete
2016-03-10 07035, 2016
14:49 PM
ruaok
yeah
2016-03-10 07037, 2016
14:49 PM
CatQuest
oh yea
2016-03-10 07037, 2016
14:50 PM
ruaok
oh, so we've paid for the office space and we're going to sign the lease on monday. exciting!
2016-03-10 07042, 2016
14:50 PM
CatQuest
oh yea with "no activity at all" that's not bad. would get rid of "name squatters" too
2016-03-10 07005, 2016
14:51 PM
zas
ruaok: i will come for a visit at some point ;)
2016-03-10 07019, 2016
14:51 PM
CatQuest
I want to see more pictures!