Charcoal HQ

« first day (32 days earlier) ← previous day next day → last day (4003 days later) »

Undo the Snowman

00:03

Oy @hichris123

hichris123

Wow, you honestly created this?

Undo the Snowman

@hichris123 Created what?

hichris123

Do you spend like your whole life on obsolete comments?

Undo the Snowman

@hichris123 No, just the past month or so.

hichris123

@Undo You honestly created a chat room to talk about your tool to remove obsolete comments

Undo the Snowman

00:04

@hichris123 Technically speaking, Manish made it.

hichris123

Oh, well that makes the difference.

Undo the Snowman

Heh

hichris123

Why is this on chemistry beta?

Undo the Snowman

@hichris123 Because Manish mods Chem and likes to have power over my rooms.

hichris123

Ah...

So back to plotting.

Undo the Snowman

00:07

@hichris123 Yes.

We need a troop of flaggers

Ten would be about right.

hichris123

But how are we going to get them?

Undo the Snowman

But I've got to go now, be back soon.

hichris123

Okay, see you later.

Undo the Snowman

00:21

I return.

Let the plotting commence.

hichris123

Okay.

Undo the Snowman

The first step of good plotting is to figure out what our goal is.

I think we have an invader.

hichris123

Yes...

Undo the Snowman

@RobertHarvey What doth bring thee to this neck of the woods?

Yeesh, we can't even start to plot without being spied on.

hichris123

Are you a room-owner?

Undo the Snowman

00:23

@hichris123 Yes, but room owners can't do anything to mods.

hichris123

Well, I assume you can't kick mods out.

Undo the Snowman

No.

hichris123

Too slow (me).

Undo the Snowman

If we had Manish here he could kick Robert out.

hichris123

Mods can kick other mods out?

Undo the Snowman

00:24

@hichris123 Manish knows some sekrits.

Stack Exchange

Undo the Snowman has added hichris123 to the list of this room's owners.

Undo the Snowman

(because I felt like it)

hichris123

Okay, I wondered why my window randomly refreshed.

Undo the Snowman

Heh

hichris123

Thanks for telling me, @StackExchange

Undo the Snowman

00:27

@RobertHarvey If we were to create a flagging club that met once a week and flagged 1000 comments, would there be any grumbling mods?

The mod is gone.

hichris123

Yay!

I'll be back in a few minutes.

Undo the Snowman

@hichris123 Tell me when you're back.

We can do a flag strike while animuson is eating his lasagna.

hichris123

Sure, right now?

Undo the Snowman

Yes

Using the tool

1...2...3... GO!

hichris123

00:47

I hate the rate limits.

Undo the Snowman

I do too.

@hichris123 Are you using the webapp?

hichris123

No, I'm doing the mark my answer as accepted from my query one.

I probably should, but don't feel like opening up chrome.

Undo the Snowman

@hichris123 Oh. Okay, good.

I still need to make it multi-user friendly.

I should pull in some new comments.

@hichris123 Any ideas for a good search?

(to find bad comments)

hichris123

The one I did yesterday.

Please accept.

Variations.

Hm..

Someone got to most of my flags.

hichris123

01:08

@Undo You finish all of your flags, too?

And you just helped me earn my first gold badge

hichris123

1.3k 1 5 20

3 hours later…

Undo the Snowman

04:38

17 hours later…

hichris123

21:20

@Undo What queries do you run to get the comments?

Undo the Snowman

@hichris123 A simple SELECT * FROM Comments WHERE Text LIKE '%edit%' works quite nicely for me.

hichris123

@Undo I mean specifically, what words do you look for? It looks like edit, accept answer, and some others.

Are "Please help me" comments too chatty?

Undo the Snowman

21:35

@hichris123 Yeah, they are.

I might put those in.

@hichris123 I look for edit, please accept, added, fix

hichris123

I'll have to think if there's any more you could use.

Undo the Snowman

I really need to get a local copy of the comments DB

I might have a machine that's up to the task.

A dual-core iMac w/ 1T drive.

@hichris123 How big did you say the comments table was?

(space-wise)

hichris123

Comments is like 5 GB in MySQL.

Undo the Snowman

Ok, not bad.

hichris123

A little lower, around 4.5 ish.

Undo the Snowman

21:42

Thanks

hichris123

Welcome.

« first day (32 days earlier) ← previous day next day → last day (4003 days later) »

all rooms

Transcript for

Dec18

Dec '1319

Dec20

Where smoke is detected, diamonds are made, and we break thing...

dev-on-prod flag-based-fraternity programmatic-crowbars

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC