Charcoal HQ

Undo

00:00

Hm

@hichris123 dev.mysql.com/doc/mysql-windows-excerpt/5.0/en/…

hichris123

Just hung at Starting...

Undo

huh

no idea

hichris123

00:21

I really should backup my.ini. :P

Reinstalling now.

Oh, yeah! @Undo Do you use bootstrap on your website?

Undo

@hichris123 The main website is WordPress.

But Charcoal and various other projects are Bootstrap

hichris123

@Undo Huh. Okay.

Undo

@hichris123 Want to put NAAs in Charcoal?

hichris123

Yep, you have a good query?

Undo

I have a few. Let's start out with Super User; it's smaller.

So I'm going to make a new table called postflags

CREATE TABLE `postflags` (
  `dbid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `Id` int(11) DEFAULT NULL,
  `PostTypeId` int(11) DEFAULT NULL,
  `CreationDate` timestamp NULL DEFAULT NULL,
  `Score` int(11) DEFAULT NULL,
  `Body` text,
  `OwnerUserId` int(11) DEFAULT NULL,
  `LastActivityDate` timestamp NULL DEFAULT NULL,
  `AcceptedAnswerId` int(11) DEFAULT NULL,
  `ParentId` int(11) DEFAULT NULL,
  `ViewCount` int(11) DEFAULT NULL,
  `OwnerDisplayName` text,
  `LastEditorUserId` int(11) DEFAULT NULL,

^ postflags table format

hichris123

00:29

Pin it?

Undo

Ehrm, maybe.

There

Now, let's make a thing so that Charcoal can show the posts.

First we shall update submit(In)Valid.php

hichris123

@Undo New thingy? Like new view?

Undo

@hichris123 I think so.

Simplify things a little.

hichris123

I can adapt the JS flagger thingy.

Undo

Let's leave that for later.

@hichris123 Have any idea what a simple URL scheme given the post ID is?

hichris123

00:43

@Undo www.stackoverflow.com/posts/postid?

Undo

I've tried that. It doesn't seem to work for answers, methinks

Lemme check again

Wait, /a/# works for answers and /q/# for questions.

ManishEarth

@Undo ?

@Undo q works for both

Undo

@ManishEarth I want a good way to quickly test userscripts without dragging them into Chrome://extensions every time I make a change.

ManishEarth

copy paste to console

OR:

create an unbundled extension with only one content script (all you have to do is create a manifest file). Load it into Chrome as an unbundled extension. Refresh from the extensions page

Undo

Ok, thanks

Undo

01:40

@hichris123 @ManishEarth How's it look so far?

erwaysoftware.com/charcoaldev/posts.php?site=superuser

hichris123

Ooh, shiney. :P

ManishEarth

@Undo NAAs?

Undo

@ManishEarth Soon, yes

And whatever else we want :D

ManishEarth

@Undo add a "link" to it

doesn't use the collect magic, right?

Undo

@ManishEarth No.

ManishEarth

01:49

make it! :p

I probably can help with that

Undo

@ManishEarth Dumb question: how can I make those action buttons show up below the body text?

ManishEarth

use a second row?

THey're in col tags

Undo

@ManishEarth Hmm... lemme try that

@ManishEarth col tags?

ManishEarth

bootstrap columns

@Undo or change their class to col-xs

Undo

Ok, lemme try some stuff.

@ManishEarth Does that look better?

ManishEarth

01:53

I liked it when they were on the same line

Undo

@ManishEarth really?

I though they were too far spread out

ManishEarth

yeah

Undo

huh

ManishEarth

my screen is smaller :p

Undo

Well lemme try some things.

hichris123

01:59

@Undo I did like what it was before better...

Undo

@hichris123 Then I'll change it back (cc @ManishEarth) :P

@ManishEarth SQL question

How can I get the titles of the questions the answers belong to from SEDE?

ManishEarth

Title

oh

Undo

Works for answers?

ManishEarth

Gimme the query for the answers

hichris123

JOIN?

ManishEarth

02:10

yes, but I need the query

Undo

@ManishEarth data.stackexchange.com/superuser/query/163237

ManishEarth

@Undo done

threw in a free aliased [Post Link] too

Undo

@ManishEarth Neat, thanks!

ManishEarth

Ugh, 8am, not slept yet, got classes and a bunch of stuff to be done for the whole day

stupid mosquitoes

Undo

Ugh, mosquitoes

hichris123

02:15

@ManishEarth Today's going to be a fun day! :D

ManishEarth

heh

time to go to class, where ironically i have a better chance of sleeping

OK, I am two hours early for class, but I can go and sleep there

Undo

Cya

hichris123

02:33

@Undo Could you do something for me?

Undo

@hichris123 Like what?

hichris123

Find a question that needs closing as a recommend a tool/off-site resource, and then put the id into here and run it in the console.

var taskList=[];
var originallength=taskList.length;
POSTFlag=function (){
if(taskList.length>0){
	console.log("Flagging question #"+(originallength - taskList.length+1) +" of "+  originallength)
	$.post("/flags/questions/"+taskList.shift()+"/close/add/",
		{"fkey":StackExchange.options.user.fkey,"closeReasonId":"OffTopic", "closeAsOffTopicReasonId":"8"},
		function(){console.log('(done)');setTimeout(POSTFlag,5100);}
	);
}else{
	console.log("Finished");
}
}
POSTFlag()

(I'm curious if that will be interpreted as a VTC.)

Undo

@hichris123 Hmm... good idea

Ryan Carlson

Some very efficient mod just handled 31 of my comment flags in less than 4 minutes.

hichris123

@RyanCarlson The flag queue is... let's say pretty empty.

Undo

02:36

@hichris123 It was :D

hichris123

in Tavern on the Meta on Meta Stack Overflow Chat, 17 hours ago, by animuson

@Undo Yay! Now we can do our own CV queue. :P

Like that would do any good...

Undo

@hichris123 rofl

@hichris123 Feedback on the /posts.php page?

hichris123

First off, what kind of title is this?

> What is a tool that is Swiss army knife of audio as ffmpeg is Swiss army knife of video?

Undo

@hichris123 I have no idea :P

hichris123

Me thinks it's good, just we need to do the collector & JS flaggy thingy now.

Undo

02:39

Yup. And we need to make the (in)valid buttons work

hichris123

They don't work?

Didn't even notice. :P

Select Id, Body, Id AS [Post Link]
From Posts
Where PostTypeId = 1 AND LEN(BODY) < 250
AND Body NOT LIKE '%what book%' AND ClosedDate IS NULL
AND Body LIKE '%what tutorial%' OR Body LIKE '%what website%'

@Undo ^ What do you think?

hichris123

04:13

@Undo Add AskUbuntu to Charcoal.

hichris123

04:42

Nevermind, I guess AU is in.

No, that's AD. :P

Undo

14:37

@ManishEarth awake?

ManishEarth

yes

Undo

@Manish Should we make a new script.js for the posts part, or should we adapt the current script.js to tell whether it's on posts or comments?

ManishEarth

adapt

a lot of the current scripts.js magic can work for posts as well

Use big if blocks

Undo

@ManishEarth Big if blocks - what's the condition? URL check?

ManishEarth

I guess

See, the comment collecting JS can be reused in a simpler form, for example

Braiam

15:29

@Undo ?

Undo

@Braiam Yes.

@Braiam So... I don't have a decent signup system, so I need an email address.

Braiam

is that php script public?

Undo

@Braiam It's on GitHub. github.com/Charcoal-SE/Charcoal

Braiam

@Undo mine? err "my nick + p @" the mail service of google aka gmail.com

Undo

@Braiam Ok, thanks ;)

@Braiam And you should get an email with creds right about now.

Braiam

15:36

@Undo got em, ty :)

Undo

@Braiam np. have fun!

I've got to go, cya

Sathya

16:33

@Undo sup?

allquixotic

@Sathya you may want to check out erwaysoftware.com/charcoal -- @hichris123 and @Undo are working on code that automatically finds low-quality or spammy comments or answers and flags them, but apparently on StackOverflow it generated up to 200 flags per hour

one of the questions would become, can the SU moderators handle this influx or would it be unwelcome (although he did mention that it's unlikely it would find this many flags on a smaller site than SO)

I think they've been coordinating with SO mods by sending them lists of comments/posts to delete or something, and having them taken care of expediently somehow... I don't know the details, but it still puts the mods in control in the end

Sathya

oops

so I read

you could start with Web Applications

I'm one of the mods there

and the queue is usually empty my time ( GMT+5.5)

DragonLord

Disregard. I haven't reached 10k yet :p

rene

18:29

In the dropdown on charcoal what does stackoverflow (0) mean?

Undo

19:30

@DragonLord You don't need 10k ;)

@Sathya So it's not an automatic flagger, there's still a human doing the actual flagging. We get comments from SEDE and the data dumps, apply some algorithm magic, and show it in a big list. There are some tools we have to speed up the flag speed, but ultimately a human is somewhere in the process.

@allquixotic It's actually obsolete comments right now mainly, with VLQ posts in the near future. We can do 200/hr, but only for about an hour :P

@rene Which dropdown? The site chooser gizmo?

rene

19:47

@Undo yes, I assumed it showed how much comments were left but once it reached zero I thankfully got another 25 to flags. That made me wonder what that number actually meant. I'm happy with 'it's random' :-)

Undo

@rene Oh, I'm doing some crazy stuff with that number. Lemme go fix it.

@rene Number fixed ;)

rene

Checked, QA approved, you can promote that fix to production... ;-)

hichris123

20:34

Wow, a lot happened while I was gone. :P

@Undo New users?

Undo

@hichris123 Yes.

hichris123

How many/who?

Undo

@hichris123 Just Braiam IIRC

in Tavern on the Meta on Meta Stack Overflow Chat, 10 mins ago, by jadarnel27

Why do you guys (Undo and hichris) frequently, but not consistently, start sentences with "me is"? Either you're trying to use "/me"-style syntax (incorrectly), or your grammar is terrible and inconsistent.

hichris123

Okay. :P

@Undo I'm already responding to it.

Undo

hehe

hichris123

20:37

The first two things I do is open here, the Tavern, and then SO (three then).

Undo

Same here

Oh @hichris123 I got confirmation that the SU posts we have on the posts page are VLQ-worthy.

hichris123

Really? Hmm, okay.

Did you make a JS auto flagger?

Undo

Not yet.

hichris123

I'll flag one and get the magic for it.

Undo

ok

I'll work on making the valid/invalid buttons work.

hichris123

20:42

@Undo So VLQ and not NAA? You may want to change that in the database.

Undo

oh.

yeah

hichris123

http://superuser.com/flags/posts/168307/add/PostLowQuality is the URL

Undo

Huh?

Oh, yeah

hichris123

fkey:thefkeyforuser
otherText:

No other stuff needed. Pretty simple.

Undo

Yup

Let's make the (in)valid buttons work first, though.

hichris123

20:46

@Undo superuser.com/flags/posts/168307/popup?_=1390855439053!

Undo

@hichris123 Yup. That's the dialog sans-css

hichris123

Which means we could even launch it from something (if we didn't use a auto-flagger, I don't know why we would though).

Undo

I think CORS might get us

you got beat. delete your answer out of respect. — geowa4 Jul 16 '09 at 14:37

^ ROFL!

@ManishEarth How can we distinguish between the comments list and the posts list in script.js?

hichris123

How do I do that? — joshski Jul 17 '09 at 16:21

The response to it. :P

Undo

hehe

ManishEarth

20:52

@Undo have a hardcoded variable on the page?

Undo

@ManishEarth Oooh, yeah! Thanks!

hichris123

@Undo So what do you want me to work on?

Undo

@hichris123 Whatever you so desire. Making the (in)valid buttons would be really nice.

hichris123

Hmm, so could we pass a variable to it, like telling it what query to run?

Undo

7 mins ago, by ManishEarth

@Undo have a hardcoded variable on the page?

I think manish did that somewhere with the root URL

hichris123

21:01

@Undo Hmm?

Undo

Lemme look

<script type="text/javascript">var baseURL="<?php echo baseURL();?>"</script>

@hichris123 I think you can do something kinda like that, but a thing saying whether it's the post page or the comment page.

hichris123

@Undo So then would I pass that to the POST or to the JS?

@Bob You come in here to flag stuff on SU? :P

Undo

@hichris123 Just throw it onto the page itself like here

i.e. <script type="text/javascript">var page="posts"</script>

Then reference it with a if (page=='posts'){...} or something

hichris123

I mean though how would I pass that to the JS/submitvalid.php?

Undo

@hichris123 Oh, with an if in the JS

hichris123

21:05

@Undo Hmm, so then pass that to the PHP file? Having another file seems like a bit much.

Undo

@hichris123 No, lemme do it for one and you can see.

hichris123

Okay.

Undo

So I added a thing here to hardcode that var in.

and the same thing almost on the posts page

hichris123

I get that, but then how do I tell submitvalid.php that this is a post, so update it in the database as a post?

Undo

@hichris123 the submit(In)Valid.php's already have a check for that, you just need to tell them it's a post in the request.

with an isPost param

hichris123

21:09

Oh, you already did that. Thanks. :P

Undo

And if I did it right, this should do it for the valid button.

hichris123

@Undo You want me to check? Oh, and we don't have the posts in the flag history page now.

Undo

I somehow managed to break both post and comment marking :P

hichris123

@Undo Um... how?

Undo

Not sure :P

hichris123

21:12

Wait, marking as in what?

Undo

marking as valid

Aha!

github.com/Charcoal-SE/Charcoal/commit/…

hichris123

Still no worky. :(

Undo

;(

hichris123

Hmm, can we log it?

Undo

comments work now

hichris123

21:17

Yep. :)

Undo

posts no worky ;(

hichris123

Hiya @DarthAndroid!

Undo

I have found it

hichris123

Aha!

Undo

So we shall add it.

Done. erwaysoftware.com/charcoaldev/posts.php?site=superuser

@hichris123 Want to do the invalid button?

hichris123

21:22

@Undo Sure.

Should work now... want me to try it?

Undo

Sure

hichris123

Check the database.

Undo

Yup, works!

hichris123

So just the collector thingy now?

Undo

Yup

hichris123

21:30

@Undo docs.google.com/forms/d/…

Undo

@hichris123 Signed up an hour ago ;)

hichris123

@Undo Darn, I was too late. :P

hichris123

22:23

@Undo Please pull to main. Valid button's messed up. :D

Undo

22:54

@hichris123 Done.

Man of Snow

23:22

Hi

I want a charcoal account :P

Don't know how to get one

hichris123

@ManofSnow Okay, need an email.

You can go to my website if you don't want to share it here... gimme a sec.

Man of Snow

@hichris123 Look at my profile, please

It has my email

Encoded with X's

hichris123

SO MANY X'S!

Anyway, you'll get an email in a few minutes.

Man of Snow

yes :P My way of preventing spam

ok

hichris123

1194	comments flagged
1189	deemed helpful
5	declined

If you were wondering. :P

@ManofSnow Get it yet?

Oh, this is how to use it:

Jan 19 at 18:13, by hichris123

@MikePennington You actually have to click the generate button at the top thingy, which gives you some JS to put in your browser console on the site.

Man of Snow

23:34

Yes, logged in

hichris123

@ManofSnow Your user profile: erwaysoftware.com/charcoal/viewuser.php?id=22

Man of Snow

:D it says I'm not logged in

Ok I got it :P

hichris123

Wow:

Stack Overflow
2982 total flags handled
180 flags handled today

> 8 flags handled total

Yay!

Man of Snow

@hichris123 Why not just give them a 'javascript:codewhatever' for them to paste in their URL bar?

hichris123

@ManofSnow What do you mean?

And another thing, only do the number of flags that you can flag per day.

@Undo I'm laughing right now because you and I both have more helpful flags than almost all of last year's mod candidates. :P

Man of Snow

23:46

@hichris123 There's an empty line when you press 'generate' and like you can put javascript in your browser's url bar by typing 'javascript:' and some code

hichris123

@ManofSnow Hmm, I don't know.

Transcript for