Charcoal HQ

hichris123

17:00

@Manish Perfecto.

ManishEarth

the magic of JOINs

hichris123

I'm thinking of adding some user based stats of how many handles total, do you think it should be in?

ManishEarth

sure

IMO the /cm tab is too much effort for not much gain (remember, this is a comment flagging app), but have fun

hichris123

@Manish True, but what can we add to the actual app? I'm not too sure what else in terms of the user-experience we can add.

ManishEarth

Who said we need to add something?

However, a similar app for flagging posts and finding broken links and all would be nice @Undo

hichris123

17:04

@Manish Ping Undo on that.

Me likes the idea.

ManishEarth

Basically, what we have here can be extended to more than one type of content

hichris123

True, posts, answers, anything.

Next thing is machine learning - having it recognize the bad comments/posts.

Undo

17:17

@ManishEarth Tell me more about this.

I like the idea.

The problem I can see is that there are fewer posts and people do a better job keeping them cleaned up anyway.

hichris123

@Undo You'd be suprised.

The problem is a lot of them are old questions, and Shog doesn't really want them to be deleted.

Many however, are totally unclear, show no minimum understanding, or are find a tool ones.

ManishEarth

@Undo speling mistakes, link only answers, low quality answers in general, broken links (the last one is hard to SEDEify), etc

Undo

@ManishEarth So for the broken links one we would make a cronjob-ish thingy that would just run through links in posts and check for 404's and 403's and 500's and things?

ManishEarth

yeah

Undo

Sounds network intensive.

But getting spelling mistakes and LLA's would be pretty easy.

I wish there was a way for people to OAuth with the app without me being able to do evil things with their tokens.

Then we could do things like use that edit API and the flag API.

ManishEarth

17:31

@Undo feature request for the write API: allow finer grained permissions, like instead of write_access you just put a list of all of the endpoints allowed

Undo

@ManishEarth We probably should wait until they release it :P

ManishEarth

heh

Undo

@Manish But would you trust me with the ability to flag stuff as you even?

Still seems risky.

ManishEarth

@Undo good point

Undo

Mod flags can be... destructive :P

hichris123

17:38

@Undo Is the id of a user the same as the id recorded when a comment is valid/invalid?

Undo

@hichris123 Yes.

ManishEarth

@Undo That's why we have the flag-js though. I made it for precisely that reason; it's a less drastic way out than the API or iframing with the fkey

Undo

true...

but it's not as smooth. If we could have a quick flag link below the link-only answers, that would be a dream.

@ManishEarth I think I found some LLA's:

data.stackexchange.com/stackoverflow/query/edit/157101#

ManishEarth

time for food, and then to spend some time off comp :p

Undo

:p

hichris123

17:42

@Undo You can only flag VLQ if Score <= 0

Undo

@hichris123 Ah, true.

@hichris123 My goal: have create user thing done by tomorrow.

hichris123

18:03

@Undo I'm working on comments handled per user.

Undo

@hichris123 Yay!

hichris123

18:28

@Undo Can you get the number to display?

Undo

@hichris123 Sure, just a minute.

Undo

18:40

Hmm.

Not sure.

hichris123

Weird.

Undo

Lemme pull it down to local and try some things.

hichris123

Okay.

@Undo I found some recommend me a tool to do this posts: data.stackexchange.com/stackoverflow/revision/157104/197551

Undo

19:13

@hichris123 Are you asking for some close votes? ;)

hichris123

@Undo Kind of, I just flag them since I'm not 3K. :P

Undo

Ok

hichris123

@Undo Find anything?

Undo

@hichris123 For what? The closing? Yes.

hichris123

The users.php and the numbers, @Undo.

Undo

19:16

Oh, no.

ManishEarth

@Undo you guys need to get something better to do on New Year's Eve :P

2

Undo

I'm working on another project at the same time, too.

hichris123

@Manish Do we? Then you need something better to do then to chat with us in this chatroom on NYE. :P

Undo

Ha!

ManishEarth

@hichris123 new year's eve over :p

I had my fun :)

Undo

19:19

Manish is in the future.

hichris123

Meh, NYD is the same.

ManishEarth

@Undo I'm always in the future

hichris123

12:49 AM

ManishEarth

yep

Undo

Out of close votes.

hichris123

19:21

@Undo People use all of their CV?

gasp

ManishEarth

I need close vote privs on SO

Undo

@ManishEarth You don't have them?

ManishEarth

nah

Undo

We need YOU to help in the close vote queue!

ManishEarth

I get too easily annoyed on SO

And I usually end up flagging to close when I look for qs to answer

Undo

19:22

Hehe

hichris123

19:40

@Undo I got the formatting a little better, still no number.

Undo

Hmm

hichris123

Idea.

Undo

Yay!

hichris123

Got it, but now it's 0...

Undo

D:

hichris123

19:43

Meh, good for now.

Undo

Hehe

hichris123

@Undo Any way I can query the database without putting it in the code?

ManishEarth

@hichris123 ?

Undo

@hichris123 ?

ManishEarth

Ask him for a smaller dump

Undo

19:53

Oh, as in a test?

hichris123

@Undo Yeah.

ManishEarth

with the passwords blehblahblublerized

hichris123

Or you could do it for me.

Undo

@ManishEarth They're MD5's anyway.

ManishEarth

If you want stuff added, then just ping le Undo

Undo

19:54

@hichris123 Give me a query.

hichris123

Select handledBy From stackoverflow Where handled = 1

Nope, nevermind @Undo.

I figured it out.

Undo

Oh, ok.

(FWIW, Select COUNT(*), handledBy From stackoverflow Where handled = 1 group by handledBy produces:)

hichris123

@Undo Why 65 NULL?

@Undo Any thoughts as to why this outputs 2093 for all?

          $query = mysql_query("SELECT * FROM users ORDER BY id asc");
          $sites = mysql_query("SELECT * FROM sites");

          while ($row = mysql_fetch_array($query))
          {
            while ($row1 = mysql_fetch_array($sites))
             {
                $aQuery = mysql_query("SELECT COUNT(*) AS number FROM " . $row1["siteTableName"] . " WHERE handled=1
                 AND handledBy = " . $row["id"] . "");
                 $handled = mysql_fetch_assoc($aQuery);
                 $numhandled = $handled["number"];

Undo

@hichris123 Because... I dunno.

hichris123

Whatever, hey, it makes it look like I flag a lot of comments. :P

Undo

20:03

:P

ManishEarth

@Undo found the last secret hat

unix.stackexchange.com/users/10762/chris-down / winterbash2013.stackexchange.com/don-draper

Well, Gilles found it

Not sure how to get it. It may be 5x repcap but skeet doesn't have it

Undo

@ManishEarth Neato!

hichris123

20:17

@Undo Sometime we do need to figure out how to do machine learning with comments and posts.

I don't know how, but it is a good idea.

Undo

We do.

It scares me, though.

hichris123

What, the leaving it up to a computer to decide what to flag and such?

Or just AI in general?

Undo

Just AI in general.

And the thought of having to build machine learning :P

hichris123

@Undo Coding would be immense on it...

ThiefMaster

SE once had a big ($10k and a possible job offer for the winner) contest about exactly that

hichris123

20:25

@ThiefMaster They did.

Undo

@ThiefMaster Probably pre-Undo, right?

hichris123

It was a thingy from the data dump, you had to build a tool to identify bad posts.

ThiefMaster

about a year ago

Undo

I didn't join til January of 2013 for all intents and purposes..

hichris123

So.... bother them enough to get us a contract to make it better? :P

Undo

20:26

Hah!

Good idea.

hichris123

20:43

@Undo It only displays the number for you. Look at users.php.

Undo

Huh

hichris123

Anything different for the userid's besides yours?

Undo

Nope

I must be specialler.

or something

Not sure.

hichris123

21:05

Hmm... @Undo

Hunch.

Run this on the database for dev.charcoal.

Select COUNT(*), handledBy From stackoverflow Where handled = 1 group by handledBy

Undo

ok

@hichris123 ^

hichris123

Hmm...

No clue.

Can you just do Select id from Users? @Undo

Undo

Ok

@hichris123 It's lowercase users, if it makes any difference.

hichris123

Those both on dev?

Undo

Yes

hichris123

21:16

@Undo Could you do this: SELECT COUNT(*) AS number FROM stackoverflow WHERE handled=1 AND handledBy = 11, then the same on SF and Physics?

Undo

SO: 334

SF: 0

Phys: 49

hichris123

Huh.

I'll have to look at the code more, but no clue right now.

Undo

same here

hichris123

I thought programming was supposed to be logical! :P

Undo

:P

hichris123

21:55

@Undo Is there any way you can do a master select of the SELECT COUNT(*) AS number FROM stackoverflow WHERE handled=1 AND handledBy = 1 for all sites?

Undo

22:47

@hichris123 Not sure. Maybe @ManishEarth or @ThiefMaster would know.

hichris123

Well, for right now could you do it for your id 1 on your dev database (all sites)?

Undo

I dunno how :P

hichris123

Just do like SELECT COUNT(*) AS number FROM stackoverflow WHERE handled=1 AND handledBy = 1, then SELECT COUNT(*) AS number FROM superuser WHERE handled=1 AND handledBy = 1, etc.

Undo

Ick. Sounds like work.

What exactly do you need to know?

hichris123

I'm wondering if that'll add up to your supposed 2093 handled (on dev).

Undo

22:50

It will.

It sounds just about right.

(dev is just a recent copy of the main DB)

hichris123

I just don't get why it would show up for you and not anyone else.

Undo

Oh

hichris123

Well, let me do some. We'll see if it changes.

Nope.

Undo

found it.

hichris123

Sites not looping?

Undo

22:53

wait, maybe not.

hichris123

@Undo What's the easiest way for something to get output to the Chrome console in PHP?

Undo

@hichris123 I don't think you can.

You can just print_r(), though.

hichris123

Where's that go?

Undo

Right onto the page

makes it ugly, but it works.

hichris123

Figured it out.

Undo

22:57

what was it?

hichris123

I'm not sure how to fix it, though.

Undo

what's the problem?

hichris123

I was doing a query, and I had a while loop on the query.

I guess the results can't be looped around?

Or something.

Undo

Huh?

hichris123

Like this:

$query = mysql_query("SELECT * FROM users ORDER BY id asc");
          $sites = mysql_query("SELECT * FROM sites");
          while ($row = mysql_fetch_array($query))
          {
            $totalhandled = 0;
            while ($row1 = mysql_fetch_array($sites))
             {

Then I did print_r(testing)

Undo

22:59

There shouldn't be anything wrong with that.

hichris123

I only got 6 testings, where there's 6 sites.

Undo

Ahhh

hichris123

Shouldn't it be 14*6?

Undo

Should be.

I think I found it.

hichris123

What?

Undo

23:02

ergh, maybe not.

hichris123

@Undo Fixed it!

Undo

@hichris123 How how how!!!

hichris123

Put 2nd query inside of the 1st while loop, @Undo.

Undo

But... it shouldn't matter!

hichris123

But it did. Who knows?

Undo

23:06

?!?

hichris123

Look at the page!

Undo

I know!

I won't be able to sleep tonight :P

hichris123

I'm removing the logging.

Undo

Good

hichris123

@Undo Apparently mods don't feel like using your system. :P

Undo

23:08

:P

hichris123

Pull to master?

Undo

done

@hichris123 Manish counts!

And WendiKidd's a mod.

hichris123

Yeah, but besides Manish, it's x< 10

Undo

Hehe

We shall teach the mods to love the system!

hichris123

Does your add user thingy work?

Undo

23:10

Not sure how.

hichris123

Me sees a new user...

Undo

@hichris123 No.

@hichris123 Where?

hichris123

Charcoal - user15

Main.

Undo

@hichris123 My version of Community

hichris123

@Undo "Hi, I'm not a real person! I just randomly flag stuff and break things!"

Undo

23:11

Used for when I write that cronjob to automagically dismiss flags on deleted comments.

hichris123

Ah.

Undo

We have to make a mirror of SE.

hichris123

Well...

Undo

Except the actual QA part.

hichris123

Charcoal Overflow is a new Question and Answer site.

I feel like I accomplished something today.

I'm not sure why it worked, though...

Undo

23:13

You have!

hichris123

I wonder what's going to be next for Charcoal...

Undo

Hmm

hichris123

Oh, and can you make a JS thingy for post flagging @Manish

Undo

Maybe SE will buy it and you and me will get rich!

hichris123

Ask someone on the dev team.

Undo

23:16

Or maybe they'll just steal the idea and make it better.

hichris123

@Undo I have an idea for sometime, since I'm not sure how to implement it:

Get the text of all of the valid flags, find matches of words and such

Then get the text of all of the invalid flags, see why they were invalid

Then somehow make an algorithm from that.

Undo

Sounds hard.

But rewarding if done right.

hichris123

I don't know how you would do it.

Undo

I don't either.

hichris123

But somehow it should be able to be done.

Undo

23:18

I think we should do link-only answers at some point.

(also, at some point this thing is going to outgrow my hosting :P)

hichris123

There we go on another hidden tab. :P

Undo

Hehe

hichris123

Self-hosted?

Undo

@hichris123 EC2

hichris123

Free version?

Undo

23:19

@hichris123 Well, not free but still a t1.micro

We need to find a way to get SE to host it.

hichris123

@Undo That's where your chat with Oded comes in. :P

Undo

:P

Transcript for