Charcoal HQ

1:25 AM

@Undo I have a query for posts that need editing...

Select *
From soposts
Where PostTypeId = 1 AND ClosedDate IS NULL AND Body LIKE '%teh%' AND Body LIKE '%dont%'
    AND Body LIKE BINARY '%i%'
Limit 100

Undo

eeek

oh, ok

Looks good.

hichris123

Lemme see how many I get row wise...

ManishEarth

2:20 AM

[ SmokeDetector ] Possible spam: Has a prototype been built to demonstrate the claims made by WO 2001053721 A1?

[ SmokeDetector ] All caps title: COERCIVITY OF BILINEAR FORM

hichris123

3:00 AM

@Undo 537 posts returned...

Undo

Sounds about right.

ManishEarth

3:15 AM

@3ventic I've seen some of the flags, the comment threads it's been attached to and I can say that this is a rather generous approximation of what actually happened. — badp 14 hours ago

...but the software does expose all that; with easy tools to flag the context. Looks like it's not being used fully either

hichris123

@ManishEarth You talking about the flag queue?

ManishEarth

Charcoal

hichris123

Lemme read...

He hasn't even seen Charcoal...

ManishEarth

@hichris123 No, but he's saying that the flag-spam was very low-effort; just flag a bunch of keywords

If you recall, correct usage of the tool leads to much more than that

hichris123

@Manish Maybe we should auto make every comment load the show context thingy?

Undo

3:34 AM

Maybe...

hichris123

Hi again @Undo.

Undo

Hi

hichris123

Me loves snow days. :P

Undo

Me does too.

hichris123

Ooh, 6 inches of snow so far! :P

Undo

3:36 AM

@hichris So do you know this Compukid guy? I find it somewhat odd that he nominates me right off the bat.

hichris123

@Undo No...

If you're asking if he's me, no. :P

Undo

ok

I was suspicious :P

hichris123

He has an AD profile:

Compukid

88 9

@Undo I don't do Apple products. :P

Undo

Ah. So not you :P

I now must figure out what caused him to pick me of all people.

hichris123

Yeah. You really thought that? :P

I didn't even think of nominating anyone...

Undo

3:38 AM

Yeah, I wondered...

hichris123

@Undo Do we really have to have Cinder on A51?

Undo

Hah

no.

We have some domain work to do :P

hichris123

I keep refreshing A51 Arduino... and it makes me mad.

The Cinder part.

ManishEarth

8:44 AM

[ SmokeDetector ] Possible spam: iOS device log crashed EXC_CRASH 0x0000000000000000

3ventic

@ManishEarth fail

ManishEarth

Note to self: tune the number thingy so that it doesn't catch infinite numbers

3ventic

...and probably make it catch phone numbers only

ManishEarth

@3ventic feel free to improve the regexes, it's on GitHub under findspam.py

Jan Dvorak

@ManishEarth what should be the max. length?

ManishEarth

8:47 AM

10 or 11?

Baba spam has indian phone numbers

3ventic

Github... I guess I gotta go there sooner or later..

Most phone numbers I see start with a 0 and are 10 digits long

but sometimes the 0 is replaced with country code

Jan Dvorak

+ is a replacement for 00

ManishEarth

yeah

3ventic

I didn't know that

so +3584565.... would be 003584565....?

ManishEarth

yeah

Jan Dvorak

8:50 AM

yep

3ventic

Interesting

Jan Dvorak

where +35 (or some similar part) is the country code

ManishEarth

@3ventic Basically, we need to exclude loooong numbers and only have short ones

Jan Dvorak

Czech Republic is +420

3ventic

+358 is Finland and that example of mine was the start of my number

don't feel like posting full phone numbers on public pages

kalina

8:52 AM

morning!

3ventic

Morning

kalina

somebody will need to paste this to manish since he has me on ignore

but the ITU specs state phone numbers can only be a maximum of 15 chars

Jan Dvorak

1 min ago, by kalina

but the ITU specs state phone numbers can only be a maximum of 15 chars

kalina

so with the international dialing code and prefix, phone numbers can't be longer than 19 chars

and in the instance of a 19 digit phone number, the first two characters will be 00

Jan Dvorak

38 secs ago, by kalina

so with the international dialing code and prefix, phone numbers can't be longer than 19 chars

ManishEarth

8:55 AM

19 chars is a lot

Jan Dvorak

31 secs ago, by kalina

and in the instance of a 19 digit phone number, the first two characters will be 00

kalina

and after the 00, the next few numbers will be the international dialing code, for which there are plenty of references

ManishEarth

@kalina yeah, but 19 chars is a lot

Matching 8-19 chars, even with caveats, will match like every number people post

kalina

@ManishEarth yeah but it's only really 15 - you know what the first 4 numbers will be since they'll be 00 + a dialing code + a number

3ventic

It's going to be one hell of a regex to match properly..

kalina

8:57 AM

I know it's a bit of work, but that's how you'd do it if you wanted to reduce false positives

00 + number from countrycode.org + phone number, anything that doesn't match the first few characters is not a phone number and/or a local number that isn't taking into consideration international dialing

ManishEarth

@kalina 15 is also a lot. The Apple post would still have been flagged :p

Remember that it's not just 15, it can be less too

kalina

but then if you don't match 00 + countrycode.org then you know it isn't an international number

3ventic

List of international call prefixes

An international call prefix or dial out code is a trunk prefix used to select an international telephone circuit for placing an international call. The prefix must be dialed before the country calling code and the destination telephone number. It is synonymous with international access code or exit code. The International Telecommunications Union (ITU) recommends the sequence 00 as a standard for an international call prefix, and this has been implemented by many countries, but not all of them. When phone numbers are published for use abroad they typically include the country calling co...

Actually...

kalina

oh yeah of course, but if you fail the first check you could just look for numbers that are ~10 digits or something

it means you'd perhaps miss some, but it would reduce on false positives

ManishEarth

What we can do is just put 3-5 regexes, each of a fixed length

@JanDvorak btw, I'm just about to update the code to use your dict magic

kalina

9:00 AM

well you know how much code confuses me, otherwise I'd take a look

Jan Dvorak

@ManishEarth If you want to add regexes for product recommendations, be sure to exclude the Software Recommendations site.

ManishEarth

yep

Jan Dvorak

AKA "the spam hole of 2014"

3ventic

Yay for legitimized spam

((00|+|99)\d{1,3}(\-|\s)?|0)((\d{3,5}(\-|\s)?){1,5}|\d{9,15}) this should catch most, no?

ManishEarth

[ SmokeDetector ] SmokeDetector started

@3ventic wut

Jan Dvorak

9:06 AM

@3ventic debuggex link?

3ventic

hah

kalina

I don't see that software rec site lasting too long

3ventic

googles debuggex

kalina

@3ventic I see you're using regex to solve a problem. Now you have two problems.

Jan Dvorak

@kalina Animuson just gave them a stern warning..

3ventic

9:07 AM

I need some valid phone numbers

ManishEarth

[ SmokeDetector ] SmokeDetector started

kalina

SE should repurpose me for the specific use of dramatising software-recs until everybody gives up on it.

ManishEarth

@3ventic note that the babaji guy puts spaces in the phone numbers at times

3ventic

That'll still match a whole bunch of 0

Jan Dvorak

@3ventic uhh.. the + needs escaping

3ventic

9:08 AM

@ManishEarth That's in the regex I made

ManishEarth

yay

3ventic

@JanDvorak noticed

Jan Dvorak

here we go: debuggex.com/r/Fazxmg67BJSxSoc9

3ventic

it'll match partial phone numbers too, tho

Jan Dvorak

shouldn't group 3 be -?\s?

3ventic

9:10 AM

- or space, no?

Jan Dvorak

can't there be both?

3ventic

I've never seen people use +358- 4565...

but I guess so

kalina

people are random

Jan Dvorak

also, can't there be slashes?

3ventic

feel free to tweak it, it's just a 3-minute pattern I rushed

slashes?!

Oh my...

Jan Dvorak

9:12 AM

+420/123 456 789

kalina

I can't say I've ever seen slashes in a phone number

your example does look like something that might happen though

3ventic

Phone numbers are soon worse than timezones

Jan Dvorak

@3ventic there are libraries for timezones

3ventic

Which is great

kalina

@3ventic the requirements for timezones don't change over time, they're barely annoying at all

3ventic

9:14 AM

@kalina You didn't watch the video

kalina

I can't via chrome rdp :(

uh

3ventic

:(

kalina

sec, let me just mash my face on the keyboard to wake up

there we go

ManishEarth

10:33 AM

[ SmokeDetector ] All caps title: MINECRAFT LAUNCHER 1.3.9 WONT LAUNCH! PLZ HELP

3ventic

11:04 AM

Maybe you should add some common blog urls to the spam detection?

those that advertise through spam, I mean

ManishEarth

@3ventic like?

Remember, it currently tests the titles. The body is only partially recieved

3ventic

puttingout

ManishEarth

If you want, you can add a "spammy blog" ruleset entry via pull req

3ventic

I don't know python tho

yet

ManishEarth

12:07 PM

[ SmokeDetector ] Possible spam: asp.net mvc 4.0 linq query with datetime field returns something like this /Date(1391600738810)/

3ventic

That's a horrible title.

ManishEarth

2:31 PM

@hichris123 Um, please don't gain rep on a site just so that you can vote in an election. Not disallowed, but not really good either.

Undo

@ManishEarth Whatcha think of SR so far?

ManishEarth

meh

iffy

Undo

Same here.

ManishEarth

good meta activity though

Undo

They need to crack down on one-liner answers.

ManishEarth

2:34 PM

people are trying to fixify

Undo

@ManishEarth I think we have like half of the mSO regulars there :P

hichris123

3:23 PM

@Undo I'll help out with SR in terms of editing & organizing & (the dreaded word) moderating. But probably not too many answers/questions...

Hiya @tschoppi!

ManishEarth

4:33 PM

[ SmokeDetector ] SmokeDetector started

→ 5 messages moved to Trashcan

hichris123

@ManishEarth What just happened?

ManishEarth

@hichris123 Restarted the bot twice.

hichris123

in Tavern on the Meta on Meta Stack Overflow Chat, 27 secs ago, by Manishearth

added timestamps to SmokeDetector so that I can just grep the logfile next time

Oh, okay.

ManishEarth

Also added an abort notification

It's a separate program called with a semicolon, so it will always be called regardless of the exit status

[ SmokeDetector ] All caps title: HOW CAN I MAKE AN UBUNTU BOOTABLE ISO?

Undo

uh-oh

hichris123

4:38 PM

@Undo huh?

Undo

Manish's bot is once again a drug abuse detector.

ManishEarth

yay?

Undo

I suppose :P

I can't stand my pitiful lack of edit privs on m.SR

Crap

Once again, I make a suggested edit two seconds after the OP edits and I overwrite their change -_-

hichris123

I got repz on SO! Yayz!

Undo

yay!

hichris123

4:46 PM

I think your caps lock key was on while writing this post. — Avinash Raj 3 mins ago

Heh.

Undo

@hichris123 Now go get rep on SR so I can nominate you.

hichris123

@Undo No thanks. You're the nominated one, the chosen one.

1 hour ago, by hichris123

@Undo I'll help out with SR in terms of editing & organizing & (the dreaded word) moderating. But probably not too many answers/questions...

Undo

:P

hichris123

Well, I'm 13 rep away from 1/3 of the way to 3k from 2k. :P

Undo

yay!

hichris123

4:49 PM

Hmm... I wonder if this is an audit. :P stackoverflow.com/review/suggested-edits/3985023

Jan Dvorak

@hichris123 Make your guess :-D

hichris123

@JanDvorak Someone else just got my audit. :P

> Review audit passed 19 secs ago:

Yayz! 2335 repz.

Undo

yay!

Undo

5:32 PM

Snowing here

hichris123

Heh, we already got our snow. :P

I think around 8-10 inches on the ground right now.

Undo

wow

3ventic

We got our snow very late this winter..

hichris123

Yep. I love snow days!

3ventic

And there's unusually little snow

hichris123

5:33 PM

@Undo A spam button comes up in the post revisions...

Undo

@hichris123 Ha!

I think my autoflag button does too.

hichris123

Let's see what it does...

It makes a null entry @Undo...

Undo

yup

not surprised.

Undo

5:54 PM

0

Q: Is there a faster Android emulator?

I'm playing with Android development, but the emulator is sooo... slow... It takes upwards of five minutes just to start up! I'm not interested enough in Android development to continue pursuing it with such a slow virtual device (and I don't really want to go buy a real device). Is there a fas...

osx software-development

@hichris123 ^

Ah good. A downvote.

Now we try to figure out why...

hichris123

@Undo People don't like android apparently. You got a downvote. :P

Undo

I'm actually kinda happy when someone actually downvotes something. We need that.

hichris123

Maybe quantify faster @Undo?

Undo

Ah yes.

types

hichris123

I'd be interested to know why this has been downvoted. — dotVezz 1 min ago

No, that's not my sock. :P

Undo

5:57 PM

hehe

ManishEarth

7:21 PM

[ SmokeDetector ] All caps title: NEED HELP IN EXCEL FORMULA LIKE COUNTIFS

ManishEarth

8:19 PM

[ SmokeDetector ] test

hichris123

@Manish Whatcha doing?

testing :p

Testing what?

nothing

Sure. :P

9:11 PM

[ SmokeDetector ] abc

Seth

@ManishEarth What is going on..?

No link there..

ManishEarth

[ SmokeDetector ] abc@Seth testing what I can feed into the chat api

Cool, got some control characters through there

Seth

Oh cool. If I had any time I'd try to help you guys. Little enough that would be though :-/

ManishEarth

[ SmokeDetector ] #echo haha

@Seth copy the above into a terminal, see what happens

The commented line

Seth

done

why?

ManishEarth

9:18 PM

Hmm

@Seth because malice

Seth

@ManishEarth I see.

ManishEarth

Note that the comment didn't get copied

Seth

I know enough bash to not copy the comment :P

ManishEarth

@Seth copy the comment. See what happens

Or, try this one

[ SmokeDetector ] charming people

Seth

@ManishEarth well nothing ofc.

ManishEarth

9:21 PM

@Seth try this one. Do not press enter.

Seth

Too late.

No dir called people in my home though :P

ManishEarth

@Seth haha

Seth

So how does that work? I get the char part, but what happens to the ing?

ManishEarth

@Seth huehuehuehue

Seth

wait no.. I don't get any of it.

ManishEarth

9:23 PM

I am very evil^H^H^H^Hnice

got it now?

Let me see if I can make something truly malicious

Seth

@ManishEarth nope...

ManishEarth

@Seth look at the next one. Do not press enter

Seth

huh. That wouldn't work on Ubuntu anyway though.

ManishEarth

wait messed up

Seth

Need one more space too

ManishEarth

9:30 PM

[ SmokeDetector ] I like Undo's charm -- he's really one of the nicest people I've met /

there

Seth

better

ManishEarth

@Seth Control characters

^H is a backspace, and bash interprets it that way

@Seth so when you type it into the terminal, it thinks you pressed backspace

Seth

ahhh

ManishEarth

try ctrl-H in cmd

Basically I passed literal ^Hs to the script from the command line arguments. It worked

Seth

I see.

ManishEarth

9:35 PM

58

Q: How can I protect myself from this kind of clipboard abuse?

Clipboard abuse from websites Many websites use JavaScript or CSS to stealthily insert or replace text in the user's clipboard whenever they copy information from the page. As far as I know this is mostly used for advertising purposes, but PoC for exploits have been demonstrated. However I disc...

exploit unix web-browser clipboard

I like Undo's charm -- he's really one of the nicest people I've met /

Seth

now I really get it.

ManishEarth

9:51 PM

0

Q: Stack Exchange (main+chat) should block or render unprintable characters

Given that people share code on the main site and chat, it might be a good idea to either block or explicitly render control-characters and the like. For example, if you copy the following code block into the nano editor (please DO NOT copy paste directly to the prompt, or if you do, please do n...

feature-request security

Seth

Can I ask how you add those characters?

ManishEarth

10:03 PM

[ SmokeDetector ] #Creative Commons Attribution-ShareAlike / Author Manishearth

ManishEarth

10:41 PM

[ SmokeDetector ] Possible spam: why my ICT teacher is so fukking idiot?

[ SmokeDetector ] SmokeDetector started

kalina

0

Q: Charcoal - free bad post finder and flagger

It's now in the Google Play Store (Android), available here. Coming soon to iOS! (about 1-4 weeks) Please note that mass flagging is not helpful to moderators, so please watch how much posts you flag. So far it only finds comments to flag, questions and answers coming soon! In the current v...

app android ios free

^ is that you guys?

Seth

@ManishEarth Well that was good.

ManishEarth

@kalina Tavern regular. Liked the idea of Charcoal, made it into an app.

kalina

so not you guys

ManishEarth

I think I pinged him and just notified him of recent events. Not sure

kalina

10:55 PM

I won't go sticking my password into it then

Undo

11:42 PM

@hichris123 As soon as the mod nomination thread happens on AI, I want you to tell me. Understand? ;)

hichris123

@Undo Um... okay?

;)

Undo

;)

hichris123

Uh.. uh.. someone accepted my meta answer?

1

Q: Questions about book references

Book requests for different fields of A.I on this site are unavoidable. I am thinking about asking a question similar to the this one as a community post to collect recommendations about books as a reference for future questions once and for all. the nature of this question is much wider than ...