The Nineteenth Byte

Downgoat

2:00 AM

I promise I read the docs this time

Quill

2 mins ago, by Quill

48 secs ago, by Quill

@Downgoat Because that's not really how you do joins

Downgoat

:|

Geobits

That's a comprehensive code review there, Quill.

Doorknob

I have a feeling you're using the "throw random keywords at the computer until something works" approach

anyway...

40 mins ago, by Doorknob

15 mins ago, by Doorknob

what's the point?

Downgoat

@Doorknob isn't that how everyone codes?

2

Cᴏɴᴏʀ O'Bʀɪᴇɴ

2:01 AM

^ :P

Vogel612

whatever you're doing there... it probably doesn't even need a join

Geobits

@Downgoat Doorknob uses vim, so it's more like throw random keypresses at the computer...

Vogel612

@Geobits I think you're mixing that up with emacs

Geobits

Oh both are just fine at that :P

Doorknob

@Geobits i:(<esc>I><esc>0ysW*.

Geobits

2:04 AM

I'm going to assume a cat jumped on your keyboard until informed otherwise.

:O It worked!

nevermind

@Geobits ^^

@Downgoat I'm not really sure I want to see the end result of this

Downgoat

2:05 AM

@Vogel612 It's okay. I'll post it on Code Review and have them fix my messed up code

Quill

@Downgoat wait. What the fuck is that? Are you trying to find users with the same amount of votes as a post?

Doorknob

hahaha

Geobits

@Doorknob Alternatively... **>:(** works for that too in normal-people-land ;)

Downgoat

@Quill no I'm trying to sum the amount of Votes and Questions a user has

Doorknob

@Geobits yes, but it does not achieve the primary goal of confusing you

Vogel612

2:06 AM

@Downgoat funny how you check the Post Id against a User Id...

Doorknob

@Downgoat what in the world do you need a join for then? O_o

Geobits

@Doorknob Exactly my point too :P

Doorknob

also, number

Vogel612

@Downgoat umm.... check their profile?

Downgoat

@Doorknob well I want the seperate values in seperate columns

Doorknob

2:06 AM

28 secs ago, by Doorknob

@Downgoat what in the world do you need a join for then? O_o

Downgoat

@Doorknob how else do I combine 2 selects

Vogel612

@Downgoat since you want two different columns, that are completely unrelated, a join is unnecessary

just select two things into two columns and be done with it

Downgoat

@Vogel612 then how do I do it?

@Vogel612 but they are in different tables

Vogel612

@Downgoat so what? they still have no relation whatsoever

Downgoat

OOOHHHHHHHHHHHHHH

Vogel612

2:08 AM

since you clean em down with a param anyways it's not like those result sets are related

Downgoat

I feel like an idiot now ._.

Quill

SELECT TOP 10
  UpVotes + DownVotes as [Total Votes],
  (SELECT COUNT(*) FROM Posts WHERE OwnerUserId = Users.Id) as [Post Count]
FROM USERS

data.stackexchange.com/codegolf/query/441805

mınxomaτ

> Please confirm whether or not you don't want to accept this special offer.

11

Junkware installers are getting really creative.

RikerW

lol

Geobits

I love that :)

RikerW

2:11 AM

@mınxomaτ I DO GIMME SPECIAL DISCOUNT

Hey, whats this? click

computer bursts into flames

PhiNotPi

@mınxomaτ But, would that actually change what the buttons are wired up to do?

Vogel612

I'm still wondering why you write a damn SEDE query in the first place?

PhiNotPi

As in, the text could say whatever, but the "yes" button always means "install it"?

Downgoat

@Vogel612 so I can use the SEDE api

Vogel612

with what benefit exactly?

ehhh... I don't care

don't tell me it's probably something like the latest xkcd :D

RikerW

2:14 AM

Why do you want to use an API? BE FREE! DON"T CONSTRAIN YOURSELF TO OTHER's RULES!

Cᴏɴᴏʀ O'Bʀɪᴇɴ

^ :P

Geobits

@Vogel612 I assumed it was because he wanted a table with all the people, not just looking at them one at a time :/

Quill

I forget the directory for the latest -_-

Vogel612

but then why ... oh nevermind :/

@Quill it wasn't the latest anyways

RikerW

@Quill you is no mod now>

Quill

2:16 AM

@RikerW wat

Vogel612

@Quill omg onebox...

RikerW

@Quill you was mod?

Quill

@RikerW No. I've never been a mod.

Vogel612

never ask digital morons for the solutions and never ask digital pros for the problems. It's just not ever going to give you any joy

RikerW

@Quill huh

I though you were, whatever.

You would be a good mod.

Quill

2:18 AM

Thanks :)

Vogel612

anyways I'm back to a place where I have more powers than here

RikerW

bai

Geobits

@Vogel612 I like how you use that xkcd to not-so-subtly call him a moron, then leave. Classy ;)

Vogel612

@Geobits what did you expect me to do?

Quill

@Downgoat data.stackexchange.com/codegolf/query/441807

that's similar to what you wanted, I suppose

Downgoat

2:23 AM

data.stackexchange.com/codegolf/query/441791/…

I think I got it

Quill

If you want to learn more about SEDE and T-SQL specifically, working code is always good on CR and we have some fantastic SQL reviewers

RikerW

I literally just found my journal on my computer from 4 years ago. lol

> CR

Not doing that. :P

Downgoat

@Quill yeah, I'll post it on CR and have them fix it up

Quill

@RikerW :(

Zizouz212

Help.

El'endia Starman

2:24 AM

in Pytek, 15 secs ago, by El'endia Starman

@Doorknob HALP

Zizouz212

-- Let's see if I can make something work!

-- This will make an activity score for a given user.

-- For each upvote given:                   +1 points
-- For each downvote given:                 +2 points
-- For each helpful flag (nevermind):       +2 points

-- For each badge (bronze, silver, gold):   +3/6/9 points

-- For each comment posted:                 +1 points

-- For each question posted:                +25 points
-- For each answer posted:                  +40 points

-- For every 500 reputation points:         +10 points

This is hard.

Quill

No. Stop using Variables. Use columns

Downgoat

@Zizouz212 :|

Zizouz212

What the heck is that?

Geobits

@Zizouz212 A comment is worth as much as an upvote? My score will be higher than I expected >_>

Zizouz212

2:26 AM

Eh, it's the lowest I could do :)

So far I get this:

Incorrect syntax near '='.
 Incorrect syntax near 'Upvotes'.
 Incorrect syntax near the keyword 'where'.

El'endia Starman

Considering it's an activity score, you should probably weight downvotes and comments higher... :P

Zizouz212

Clearly vary helpful.

@El'endiaStarman Eh, I can always adjust the scores. I wanted to see if I could get something to work.

Mind you, nothing I make ever works.

El'endia Starman

true

Zizouz212

@Quill So what's a column? That table thing you linked to earlier was scary

El'endia Starman

@Doorknob: How do I tell bash that an exclamation point in a string is supposed to be part of the string?

Vogel612

2:31 AM

@Zizouz212 and consider going for CTEs

please...

Cᴏɴᴏʀ O'Bʀɪᴇɴ

ugh bai

gotta study for bio test

Adnan

@CᴏɴᴏʀO'Bʀɪᴇɴ Good luck :)

Cᴏɴᴏʀ O'Bʀɪᴇɴ

thanks ^_^

Geobits

@El'endiaStarman Can you use single quotes?

El'endia Starman

in Pytek, 8 mins ago, by El'endia Starman

elendiastarman:~/workspace/src $ python3 pytek_main.py -c "\print('Hello world!')"
bash: !': event not found

Zizouz212

2:33 AM

@Vogel612 CTEs?

El'endia Starman

Using a backslash doesn't work either because apparently bash leaves it in...

Quill

@Zizouz212 imagine tables like objects, and columns are the keys, the values are effectively arrays (called rows) where they contain one object with all the keys and values

Vogel612

@Zizouz212 I think it's common table expressions..

El'endia Starman

(A \ must be followed by a function name, and ! is not a valid function name, so...)

Zizouz212

Somehow I call myself a programmer...

Quill

2:35 AM

Everyone has to learn at some point, don't beat yourself up about it

Vogel612

@Zizouz212 Programmer != DBA

Geobits

@El'endiaStarman You could turn off expansion I think.

Vogel612

anyways... bedtime

Zizouz212

@Vogel612 Thank god :)

Downgoat

PPCG Activity Score SEDE

El'endia Starman

2:36 AM

@Geobits How so?

Zizouz212

@Quill It's throwing me a SyntaxError around here:

Geobits

Umm, lemme see...

Zizouz212

Set @Up u.Upvotes from Users u
Set @Down u.Downvotes * 2 from Users u

Quill

you need = in there

Geobits

@El'endiaStarman Try this: superuser.com/a/133782

Zizouz212

2:36 AM

Of course, I've never seen this language, or programmed it before seriously

Vogel612

@Downgoat @Downgoat rewrite that to actually use joins and give the User Link to each record, then we can talk about activity score

then again rolfl probably did it already

El'endia Starman

@Geobits That worked! Thanks!

Zizouz212

@Downgoat Quick hint: You may want to right the first line as DECLARE @UID int = ##UserId:int##

Downgoat

@Vogel612 rolfl? Rolling on laughing floors laughing?

Zizouz212

Also, it may be helpful to just make that a list, and then make a row for each person on the list.

Quill

2:38 AM

@Downgoat rolfl is a former CR mod, he's done a lot of community stuff before

Geobits

Aww, that only shows one user at a time. How am I supposed to easily figure out where I stand? :(

Downgoat

@Quill oh okay

Zizouz212

@Geobits I'm working on that :)

Geobits

While you're at it, weight downvotes to 30 instead of 2 >_>

Vogel612

@Downgoat site activity query and participation / value

Zizouz212

2:40 AM

How can I represent a list in sql?

Downgoat

@Vogel612 well this one is a little different as it's geared towards ppcg

Vogel612

@Zizouz212 you probably don't want to... sounds XY to me

Zizouz212

Eh, whatever.

Doorknob

@El'endiaStarman well there's always "\print('Hello world"'!'"')" but that's super ugly

Zizouz212

This is hard

Doorknob

2:44 AM

@El'endiaStarman try heredocs

El'endia Starman

@Doorknob The link Geobits provided had solutions. Thanks, though.

Doorknob

it's not a fully general solution though

El'endia Starman

I just turned off history expansion because I never use it. :P

Geobits

:o No... you're supposed to turn it back on after :P

Zizouz212

Ugh... @Downgoat @Geobits Use this query to help you as it allows multiple user ids - I'm trying to model it off of that but I'm failing miserably.

Either that, or just put a where u.Reputation > 1000 somewhere.

VoteToClose

2:49 AM

Seems legit. o-o

Downgoat

0

Q: StackExchange™ User Activity Score

I'm from PPCG, so I wanted to make a score which measures a user's participation on the site. So I decided to use the SEDE to do this! Unfortunately, I don't know any SQL besides really basic select.. from.. stuff. So I did what all programs do and I looked up how to most of this stuff on Sta...

Doorknob

56 mins ago, by Doorknob

40 mins ago, by Doorknob

15 mins ago, by Doorknob

what's the point?

ahhh, so that's the point: to get CR rep :P

Zizouz212

lol

Quill

2 hours ago, by Quill

Side note: Can some more of you post stackexchange on Code Review so I can get the bronze badge

mwahaha

Downgoat

@Quill you're welcome?

Zizouz212

2:58 AM

lol

Geobits

I knew Quill had an ulterior motive for hanging out in here.

Downgoat

@Doorknob github.com/vihanb/PPCG-Design/issues/59

Doorknob

still, what's the point?

Geobits

It does appear that the entire point is "it would be cool". Does it need a better one?

Quill

@Geobits because you guys are cool

Geobits

3:00 AM

uh huh

Downgoat

@Doorknob I wanted to try to make something with SEDE

Doorknob

no, of the Github issue

El'endia Starman

> So I did what all programmers do

Geobits

+m

Doorknob

Geobits has muted the channel

3

Cᴏɴᴏʀ O'Bʀɪᴇɴ

3:02 AM

1

A: Sandbox for Proposed Challenges

Orthogonal Quine Task: Given an input consisting of exactly one of the characters <>^v, output your program's source code oriented with the arrow. Let's assume our program source is ABC. This is what it should do to qualify as a orthogonal quine: Input >: print ABC. Input <: print CBA. Input ...

Any suggestions?

Doorknob

@Downgoat "StackExchange" is incorrect. The proper use of the name is "Stack Exchange."

Downgoat

@Doorknob With a period?

Doorknob

what?

Geobits

My mute doesn't appear to last as long as expected.

Doorknob

No, we're just all voiced :P

Quill

3:04 AM

1 min ago, by Downgoat

@Doorknob With a period?

Geobits

How do you resist the temptation to just freeze the room at random times each day?

Quill

With a space

@Geobits Ctrl+W

Doorknob

@Geobits the fact that that would probably get my diamond taken away :P

Geobits

Oh, well I can respect that as a reason. If it was just "I have awesome willpower" or something, I'd be skeptical.

El'endia Starman

Dropping a Can of Liquid Oxygen Into Burning Oil

►

Fun to watch.

Geobits

3:10 AM

@Quill Is this for anything specific, or just brainstorming at the moment? I don't mean to snoop (that's a lie), but I like rhythm games and was thinking about redoing my old one from scratch, so it interested me.

Anonymous

@Eridan It would be much better if you allowed any reasonable form of output (string, list, etc.), so long as there was a clear definition of where there was an empty column (such as an empty string, an empty list, a 0, etc)

Quill

@Geobits Oh, that. Yeah... I've been really addicted to Rhythm games lately, I wanted to use Rhythm games as a reason to learn JavaScript animations, so I wrote the spec for the song formats, but never got around to finishing the game itself

Downgoat

Chatgoat for President!

56 secs ago, 3 seconds total – 2 messages, 2 users, 0 stars

Bookmarked 7 secs ago by Downgoat

Anonymous

@El'endiaStarman -1 not shot on a phantom and no slo-mo sound effects

Anonymous

This is how it's done:

Anonymous

3:19 AM

Explosive Oil Fire at 2500fps - The Slow Mo Guys

►

Anonymous

Also youtube.com/watch?v=hMjL76obRLI and youtube.com/watch?v=bTUu4ZLtDSs

Quill

【スクフェス】soldier game[EXPERT]FULLCOMBO

►

Cᴏɴᴏʀ O'Bʀɪᴇɴ

10 Amazing Fire Tricks!

►

#8 will blow your mind

:3

El'endia Starman

@Mego I love this.

Geobits

@CᴏɴᴏʀO'Bʀɪᴇɴ Clickbaity description is clickbaity :P

Cᴏɴᴏʀ O'Bʀɪᴇɴ

3:30 AM

@Geobits :P

Geobits

I like sugar+saltpeter better anyway.

9cHeruinr96a

def how_much_i_care():
. return 0;

Cᴏɴᴏʀ O'Bʀɪᴇɴ

._.

(defunc how_much_i_care():)
    return inf;
}

A little bit of everything.

Zach Gates

> I'm not crazy, I'm just not user-friendly

El'endia Starman

That is an abominable mash-up of JavaScript and Python.

Quill

3:40 AM

commitstrip.com/en/2015/09/16/…

2

Cᴏɴᴏʀ O'Bʀɪᴇɴ

Does pseudocode count as a language? — Chase Roberts Nov 13 '14 at 18:11

Geobits

I'm not sure we have any of our resident composers in the room now, but does anyone happen to know what the rarest interval is? As in, if I play a given note, what is the least likely next (and previous) note?

Cᴏɴᴏʀ O'Bʀɪᴇɴ

@El'endiaStarman A little bit of Lisp, too.

Quill

vanilla-js.com

Geobits

Note: the more I think about this, the less it makes sense, and the more sure I am that it doesn't have a good answer :/

El'endia Starman

3:43 AM

Uhhh.....Music.SE?

Geobits

Yea, I wasn't sure it was worth a full question there.

El'endia Starman

Ah. Well, considering I know almost 0 music theory... :P

Quill

Maybe try their chatroom?

Cᴏɴᴏʀ O'Bʀɪᴇɴ

Geobits

Do people use their chatroom,or is it like most? checking....

Quill

3:44 AM

@Geobits probably the latter :(

Cᴏɴᴏʀ O'Bʀɪᴇɴ

this guys rep is perfect:

Ben Alpert, Mountain View, CA

2k 3 17 25

theory learning notation piano scales tempo absolute-pitch

Geobits

Well there's a person in the room :/

9cHeruinr96a

I can never remember latter vs former. Any mnmnmnmnemnonics

Geobits

The latter comes later?

Quill

^^ first last

Anonymous

3:47 AM

@CᴏɴᴏʀO'Bʀɪᴇɴ Is mayonnaise an instrument?

Cᴏɴᴏʀ O'Bʀɪᴇɴ

@Mego If you throw it on the ground right.

Anonymous

@Geobits aug4/dim5

Quill

@Mego no, but it's a fruit

Geobits

@Mego It causes a wretching sound to be produced, but it's hard to control pitch.

Anonymous

@Geobits Also the volume is always fffffffffffffffffffffffffffffffffuck I made a bad choice

Cᴏɴᴏʀ O'Bʀɪᴇɴ

3:49 AM

How do I find all of my answers on a certain question?

Anonymous

@Quill +1 no node

Geobits

@CᴏɴᴏʀO'Bʀɪᴇɴ inquestion:<id> user:me

Quill

7 mins ago, by Quill

http://vanilla-js.com/

Cᴏɴᴏʀ O'Bʀɪᴇɴ

Thanks :D

Anonymous

@CᴏɴᴏʀO'Bʀɪᴇɴ if only we had an explanation on how to do such a thing on a popular question where it's very useful...

Cᴏɴᴏʀ O'Bʀɪᴇɴ

3:50 AM

@Mego yeah, too bad we don't ;)

codegolf.stackexchange.com/…

\o/

9cHeruinr96a

ferrum

Geobits

@Mego Thanks for this btw. That was my first gut call, but I had my doubts, so I wanted at least one other person to say that ;)

Anonymous

Disclaimer: my music theory knowledge is from a class I took in high school (5 years ago) and so my memory may not be so good

El'endia Starman

♪ Ferrum fum fum Ferrum fum fum Ferrum Ferrum Ferrum fum fum... ♫

Geobits

@Mego Doesn't matter. The first answer I got agreed with my own, so it's the answer now :P

9cHeruinr96a

3:54 AM

It amazes my how much the 12 days of christmas my true love gave to me

Geobits

I need to map 12 tones to six keys, so was wondering which to pair to reduce doubles on the same key producing different notes.

9cHeruinr96a

Days 1-4=N birds + day n-1
Day 5=5 Golden Rings + day 4

Days 6-7= N birds + day n-1

days 8-12 N humans + day n-1

Geobits

Day 5 also gets 1-4, and all after also get the rings.

Anonymous

@Geobits You should look at Ocarina of Time as an example/for inspiration. All of the songs in it are played using just 6 buttons.

Anonymous

(well, the beginnings of all the playable songs, which are very memorable)

Anonymous

3:57 AM

It's not exactly what you're doing, but it will help you pick appropriate notes :P

Quill

0

A: Stack Exchange User Activity Score

TOP 1 When selecting values that correspond to Unique fields referenced by constants (OwnerUserId), you're only really selecting one field, meaning this is redundant. UVN Unexplained Variable Names Don't use names like Q and A, they're confusing at best and unreadable at worst. DECLARE @Q...

9cHeruinr96a

I love how there are 3 different conversations

in this room

Quill

@9cHeruinr96a you just made it four

Geobits

@Mego Hmm... yea, not exactly the same. I'm looking to play other music given six keys (for a game), not compose it myself. It's player-choice music, so I don't really have control of what song is playing.

Chatgoat for President!

Transcript for