Charcoal HQ

hichris123

00:12

@ThiefMaster If we're going to give you a list of comments that have been reviewed and should be deleted, would you prefer they're the ones that don't need any context (I edited) or can we give you ones that are like: the bar doesn't foo :check my edit : thanks, the bar now foos!?

ThiefMaster

the ones without context are better

hichris123

@ThiefMaster Better = have to be that? Or can they be the second type?

ThiefMaster

they are better to bulk-delete since the chances of removing useful context is much lower with them

hichris123

Okay.

hichris123

01:56

I'm like always in here.

Undo

Hehe

hichris123

I just have it open in a tab.

Undo

I'm thinking something kinda like SE's page.

But without the about me and stuff.

hichris123

So like what?

Undo

We can start basic - just stuff like username and handled flags.

And add stuff as we find need for it

hichris123

01:57

Okay.

I feel like this can be useful in one way: to get people to Charcoal more

Undo

As in how?

hichris123

Charcoal just became a verb. Wow.

Undo

Hehe

hichris123

@Undo Heck if I know. But it gives us data.

Undo

True

We can have flag handling stats there.

hichris123

01:58

Like what?

Per day/week/month

Undo

Yeah

Like on cm/users

hichris123

I was thinking of adding that to the user page, but it would seem too cluttered.

Undo

Exactly.

We might even be able to make pretty graphs.

hichris123

So would it be the clickable thing of the user name on cm/users?

@Undo Yes!

Undo

Make it clickable everywhere.

So that all the blue goes somewhere.

hichris123

02:00

That was going to be one of my UX problems.

That they weren't clickable.

Undo

Yes

hichris123

Hmm, so how would we do it?

Undo

I'll start it here pretty soon, give us something to work off of.

hichris123

@Undo I mean like how would the page work? We can't create 15 or so individual php's.

Undo

@hichris123 Just have it take a user id in the address bar, then $_REQUEST it.

(btw, it's a good idea to lock down the submission scripts - see here)

hichris123

02:02

Hmm... you'd have to implement it. I'm not sure how to.

Undo

Ok, just a minute.

I need my diamond back ;(

There

hichris123

@Undo Make something clickable to go to it, so we can test with new features.

Undo

Yep, doing.

works now, except it doesn't.

404's ;(

@hichris123 Ok, cm/users.php has working links now

hichris123

You got it.

Undo

02:18

can someone please tell me how I managed to get only the first letter of the username to show up?

:P

hichris123

@Undo I don't know, but I fixed it.

Undo

Odd

hichris123

$result[1] maybe?

Undo

Nope

Looks like mySQL returns just the row instead of one row in an array.

Let's put gravatars in there.

Just for the fun of it.

hichris123

How?

Undo

02:23

(identicons, I don't have the email addresses in the DB)

@hichris123 en.gravatar.com/site/implement/images/php

hichris123

And new ones or one from SE?

Undo

Identicons. Using the hash of the username.

hichris123

Okay.

Undo

When we put the emails in the users table then we can grab the ones from SE

hichris123

Oh, did you ever figure out how to do the Add User?

Undo

02:25

I will eventually... it just seems hard. I know it isn't, but it sure seems that way :P

Working on easier things is more fun.

hichris123

@Undo How do you do it normally?

Undo

@hichris123 Open up the db in Sequel Pro :P

And manually MD5 the password and everything.

hichris123

What query, though?

Undo

No idea. I just add the row.

Should just be an insert.

CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` text,
  `password` text,
  `isDev` int(11) DEFAULT NULL,
  `isVerified` int(11) DEFAULT '1',
  `link` text,
  `ischarcoalmod` int(11) DEFAULT NULL,
  `isnetworkmod` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

^ table syntax

hichris123

Oh, I assume Sequel Pro is like PHPMyAdmin?

Undo

02:26

@hichris123 Kinda, but native.

sequelpro.com

hichris123

11

Q: Sequel Pro Alternative for Windows

Well my macbook pro is kind of not cutting it for me anymore and I have a perfectly good Windows Laptop I would actually rather use but I cannot find a reliable replacement for my SQL client. So I am looking for a replacement for SequelPro for Windows.. Ones I have Tried and Either Didn't like ...

Undo

Sequel Pro is a dream.

fast, connects to just about anything, etc.

hichris123

Me doesn't have a Mac, though.

Undo

I know.

Pooor hichris

;)

hichris123

Yep.

I like my Windows 7 better.

Undo

02:30

My '09 MBP is still going strong.

And has never ever crashed.

hichris123

I'm using a HP dv6-1253cl.

Hasn't really crashed.

Undo

Looks shiny

But why can't HP get their product names all straightened out?

hichris123

It's nice, but only a dual core.

Undo

My machine is dual core.

hichris123

@Undo Cause it's not Apple? I don't know.

Undo

02:32

I guess.

hichris123

Me wants a quad-core.

Undo

You have to manually manage all four cores.

hichris123

A desktop I use is a quad-core, though.

@Undo Why?

Undo

(not really. that would be kinda fun though)

for the first three minutes, then it would get old fast.

hichris123

Kind of like manual shifting in a car, I would assume.

I don't know though.

Can't drive.

Undo

02:33

Nah, I'm kidding.

(I can't legally drive on roads either, but for farm use and stuff manual is the way to go)

(until you get your hands on an automatic :P)

Whoops, have to go now.

hichris123

Cya.

Undo

We're making amazing progress on Charcoal, TBH

hichris123

Yeah, me likes it.

Undo

We will change Stack Exchange, hopefully for the better :P

Cya

hichris123

@Undo We will be Stack Exchange by the time it is all over. We will prevail!

Doorknob of Snow

03:39

so how does this work

is there a bot user that searches for obsolete comments or something?

I'm not even sure what this is :P

hichris123

@Doorknob Do you want a picture?

Doorknob of Snow

ok...

why is this on Chemistry XD

hichris123

Because Manish mods Chem.

I don't know the specific reason, but Manish wants to have control.

Doorknob of Snow

ok :P

hichris123

That's what Charcoal is.

Doorknob of Snow

03:43

wow

that seems very very useful

hichris123

When you flood the mods with obsolete comments, it is. :P

Actually, we got ThiefMaster to bulk delete obviously obsolete/not needed comments.

Doorknob of Snow

I'm going to keep this tab open, because it seems interesting, but I'm going to sleep now. this is a great idea! :D

hichris123

Sleep? What is this sleep you speak of?

Doorknob of Snow

it's some weird thing where you stop seeing bright screens and start seeing darkness. I just discovered it. very neat.

somehow the operating system on your body sets all the pixels to black.

hichris123

Huh. Weird.

I'll have to try it sometime.

Doorknob of Snow

03:46

speaking of which, I've been meaning to write my own body OS. I can't figure out where all the hardware is :(

anyway, I'm going to go do that now. bye ;)

hichris123

Bye.

hichris123

04:16

@Undo Bounty?

What the...?

Undo

Yes bounty.

hichris123

Me randomly browsing featured android questions.

Undo

hehe

hichris123

Makes connection between random upvote on answer and bounty.

Then sees Undo.

Undo

Hehehe

hichris123

04:18

@Undo You're awesome.

Undo

I don't need all this rep, and you deserve at least edit privs. Connection? :D

hichris123

Hey, you could get closer to 10K tools on SO.

Undo

Meh.

one more person in the review queues is more valuable :P

hichris123

Actually without this it would take me like a few days/weeks more to get to 2K.

But thank you!

:D

Undo

No problem.

hichris123

04:19

@Undo Me wants to reject/improve bad edits.

Undo

Saw your post in the Tavern with your goal to hit 2k by end of week - figured I might help a little.

@hichris123 it's fun.

hichris123

@Undo At least we can't get suspended for voting irregularities. It's not voting, is it? :P

But thank you so much!

Did I say that already? :P

Undo

Not an irregularity either.

just one isolated bounty on one answer between users on different IP's...

hichris123

How many bountied questions have there been of all time?

Undo

room topic changed to Charcoal HQ: Where comments are flagged and SE is hacked. Handy links: main & dev (no tags)

hichris123

04:26

Um... it didn't get your linky markdown.

Undo

Aww, markup no worky in room description.

room topic changed to Charcoal HQ: Where comments are flagged and SE is hacked. Handy links: erwaysoftware.com/charcoal & erwaysoftware.com/charcoaldev (no tags)

There, better.

hichris123

@Undo You're a pretty amazing kid.

In terms of everything, like Stack Board and Charcoal, and all the stuff you've done.

Undo

It's not like Charcoal would have happened without you and @Manish :P

But SE is an amazing place for kids, TBH

hichris123

Meh, I didn't come along until practically everything was done.

It is.

Programming, also.

Undo

Yeah.

hichris123

04:30

You don't need a job, a house, a car to code. All you need is a cheap 2 cent computer.

Undo

Well... 2 cents...

hichris123

It's a figure of speach.

Undo

but $200 would probably do it.

hehe

hichris123

How much is a Pi?

Undo

I think $50

but not sure.

You can hook up a monitor and a keyboard to a Pi, right?

hichris123

04:31

I don't know.

Undo

because vim and ssh are all you need...

hichris123

Linux stuff?

Undo

Yep

hichris123

Me uses Ubuntu sometimes.

Virtual Machine, of course.

Undo

vim = command line text editor thingy! SSH = secure shell or something

so you can connect to remote boxes like you're sitting in front of them.

hichris123

04:33

Huh.

Undo

@hichris123 Ubuntu fun.

me likes ubuntu

ooboontoo

^ how it's supposed to be pronounced.

hichris123

Not when you run a VM of a beta Ubuntu, you upgrade, and all it gets to is GRUB. :(

@Undo Never knew.

Undo

I didn't either till some guy at a code camp heard me say youbuntoo and set me straight :P

hichris123

You have code camp? me wants.

Undo

So do we have Doorknob on board?

hichris123

04:35

@Undo I don't know.

I got to go.

See ya' later.

Undo

Cya

i'm going to try that sleep thing.

becausei've stopped capitalizing my i's and am relying on autocorrect :P

therefore I need to sleep.

adios, folks

hichris123

Sleep is weird.

ManishEarth

05:02

@Undo Yesterday I got a free Pi, with Mathematica installed. From Stephen Wolfram. :D

Undo

15:21

@ManishEarth That's awesome.

hichris123

15:55

@ManishEarth Wolfram of Wolfram Alpha?

Undo

Stephen Wolfram

Stephen Wolfram (born 29 August 1959) is a British scientist, known for his work in theoretical physics, as the chief designer of the Mathematica software application and the Wolfram Alpha answer engine, as well as the CEO of Wolfram Research, and the author of A New Kind of Science. Background Wolfram's parents were Jewish refugees who emigrated from Germany to England in the 1930s. Wolfram's father Hugo was a textile manufacturer and novelist (Into a Neutral Country) and his mother Sybil was a professor of philosophy at the University of Oxford. He has a younger brother, Conrad Wolfram...

hichris123

@Undo Thanks.

Undo

no problem

hichris123

@ManishEarth Wow. Did you actually get to meet him?

@Undo You can't imagine how much it's snowing right now.

Undo

Probably not :P

@hichris123 Moved the username and stuff into the navbar, finally :D

hichris123

16:01

Yay!

Undo

That was really bugging me :P

hichris123

@Undo One other thing that was bothering me: it logs you out if you keep the page up after some time of inactivity.

Undo

@hichris123 I have no idea why - but it bugs me too.

I think it's a cookie thing.

hichris123

@Undo ^

hichris123

17:31

Hey, @Doorknob

Doorknob of Snow

hello

hichris123

@Undo Added some stuff to the per-user page.

@Doorknob You want to be able to use Charcoal?

Doorknob of Snow

I guess. I really don't even know how it works yet :P

hichris123

Just ping @Undo with your email. He'll grumble about not having a good add-user function (right now it's in Charcoal, UI without functionality so he has to manually do it).

Doorknob of Snow

@Undo I can haz Charcoal access? :D my email is in my profile, oddllamaprod [a with a circle] [google's mail service] .com

hichris123

17:34

Trying to keep bots from getting your email, I see.

:P

Doorknob of Snow

:P

hichris123

18:08

@Undo Do you keep track of the CreationDate for a user?

ManishEarth

19:42

@hichris123 Meet, and have a long chat. He had taken a guest lecture here, after which he wanted to hold an interactive session. Those in charge of the event were having trouble arranging a venue so I managed it and took him there with a small crowd (most of which thinned out on the way). Finally there were 20 or so people sitting in the room asking questions -- he was very patient with questions and very elaborate with answers. This went on for two hours; could have gone on for more.

Later on, he was hungry so I and a friend took him nearby for a snack and we got to talk a lot :)

@hichris123 I have tons of Wolfram Alpha stickers now :p He handed out some swag to the ones who had stayed back for the session -- those foldable paper models of the wolfram logo, pens, and stickers (and Pis to a couple of the really enthusiastic ones; he had 3)

There was some left over so he just told us to distribute 'em to friends. I am part of the web/coding club of the institute, got the bulk because we can hand them out at events.

hichris123

@Manish Wow, very cool!

So where do you go to college, @Manish?

ManishEarth

I'm basically overloaded with past swag, present swag, and future swag now. The Stack Overflow swag is also coming :o, there's tons of stuff I got at our technology festival, and in the recent past I got a Google Mapmaker t shirt

@hichris123 Indian Institute of Technology, Bombay

hichris123

@ManishEarth You have a really fun college to attend. :P

ManishEarth

yeah

We have a cultural and technical fest (two fests, not one) near the end of dec/beginning of jan and a lot of awesome things happen

We got all [these guys](www.techfest.org/home/event/lectures) for guest lectures

I missed the Mozilla one though :(

hichris123

Me wants to be there!

ManishEarth

19:52

You could have, but it's over. Classes start tomorrow

I might try to get them to get Jeff or Joel next year, as a technology fest Stackoverflow-y stuff is very important

...though the ones who organize the event may not know that.

hichris123

@ManishEarth You're lucky you aren't here. I would take anywhere over here right now. Snowing like crazy right now.

ManishEarth

Ick. Snow=no school though

hichris123

So it looks like IIT Bombay is a very prestigious school in India.

ManishEarth

Yeah

hichris123

@ManishEarth It's also going to be -20 F and 10-12 total inches of snow.

ManishEarth

19:55

heh

Haven't seen snow for three years now. I don't mind the cold much (I am known for going out in shorts when it is below freezing and not noticing) though snow can be a pain. In my current state I miss it :p

hichris123

It is a pain right now.

I was just out for 2 hours shoveling snow.

Everytime the driveway got cleared it already had a dusting on it again/

ManishEarth

@hichris123 ah. We used to live in an apartment building. Large apartment. No shoveling.

hichris123

@ManishEarth You had it lucky then. :P

ManishEarth

There's a trick to that, while it is still snowing spread a tarp over it and just move the snow wholesale every hour

(If you wait too long the tarp becomes immovable)

hichris123

Huh. That's a good idea.

It's snowing 1 inch an hour ish right now.

ManishEarth

19:59

ah, then two hours ought to be fine for a normal sized driveway. I think

I and a friend used this when I stayed at his place for a week

Worked wonders

Also was fun

hichris123

235 power outages in my county right now.

I'm just hoping the power doesn't go out.

Undo

21:31

@hichris123 Wow. Just wow.

@hichris123 No ;(

We can start now, though, and I can populate it with what info I have.

grumbles about not having a decent user-adding thingy

hichris123

@Undo Called it!

Undo

Lol

hichris123

4 hours ago, by hichris123

Just ping @Undo with your email. He'll grumble about not having a good add-user function (right now it's in Charcoal, UI without functionality so he has to manually do it).

Undo

rofl

I'm becoming too predictable :P

hichris123

Yep.

Undo

21:33

I like your user page additions.

hichris123

It's okay, but me no likey having a blank creation date.

I'll probably just remove it.

Undo

No, I can add the creation dates.

I still have a kinda-record in my sent email

hichris123

How?

Oh.

Undo

Ok, I must now make @DoorknobofSnow a login.

opens sql db

hichris123

Up to 277 power outages in my county.

Undo

21:37

I hope you're not next :P

Then I wouldn't have anyone to work on Charcoal with me ;(

hichris123

Meh, I'm more worried about my heat.

Not having heat in -10 to -20 F isn't fun.

Undo

Ouch, no space heaters or anything?

hichris123

We do, but no generator.

Undo

Propane heaters?

hichris123

No.

Blankets.

And fire.

Undo

21:39

You could rub two sticks together really fast and make fire.

hichris123

I've done that. :P

Undo

But you would have to find somewhere to put your fire, and carpet doesn't work well

hichris123

Takes forever, and a lot of work.

@Undo Fireplace?

Undo

Oh, yeah!

Lighers?

Matches?

hichris123

Yep, yep.

Undo

21:40

Wood?

hichris123

Single digits by 11pm with 30 mph gusts

@Undo Yep.

Undo

Single digits? Whazzat?

hichris123

Temperature.

Undo

Ah

very cold

hichris123

I'm supposed to go back to school on Tuesday.

I don't think that's going to happen. :P

Undo

21:41

Probably not.

You should homeschool!

Then school follows you around and you can't get away from it.

hichris123

No!!!

:P

Undo

Hehe

hichris123

I can't take school every single second of every single day.

Undo

12

Q: R: counting column data in a matrix with resets

I'm gathering data on how much my cats poop into a matrix: m <- cbind(fluffy=c(1.1,1.2,1.3,1.4),misterCuddles=c(0.9,NA,1.1,1.0)) row.names(m) <- c("2013-01-01", "2013-01-02", "2013-01-03","2013-01-04") Which gives me this: fluffy misterCuddles 2013-01-01 1.1 0.9 2013-0...

r

^ rofl

hichris123

+1 for training your cats to poop into a matrix. — gung Dec 10 '13 at 14:27

@gung thank you for taking the time to fully understand the problem. those are the weights in deca-pennies. so 1.1 means it weighed the same as 11 pennies. — davez0r Dec 10 '13 at 14:32

Undo

21:48

sigh One close vote

hichris123

I don't know if it should be closed. I saw the CV by Lance, but it seems to be on-topic, just made to make people laugh.

Undo

I'm not going to CV it.

If anything, it should be on CR

hichris123

Me thinks Lance undid his CV.

Am I right?

Undo

The vote is still there.

hichris123

The comment's gone.

Undo

21:51

The comment was deleted, the vote stayed.

hichris123

Huh.

Undo

@DoorknobofSnow sent you an email.

hichris123

@Undo What else should we have on the users page?

Transcript for