The Bridge

@badp I'm crying

Ellesedil

@Dragonrage Wish I had enough Vulpix to do that :p

@Ellesedil im 14 candy short

Dropbox might be hacked in mid 2012

@arda 2012?

12:08 AM

@GnomeSlice mail says so

They might be hacked in 2012?

either that or they are trying to stop people from reusing password from hacked websites

Isn't it a bit late for such a warning

oh wait

@GnomeSlice myspace was hacked in 2008 and was revealed in 2016

I hope whoever hacked My Space deleted my account for me. I've long sinced forgotten any login info, including what email address was used to sign up for it.

12:12 AM

@Fluttershy for the latter, you can use HIBP to check

@arda Not if I don't know the email address associated with the account!

well yeah, I was just saying that you can test a bunch of mails without also trying to remember the password

two bugs

I am finishing my dinner and will stream in a few minutes

@arda Yes. That's very old news.

@PrivatePansy I don't remember reading that, is there any blog post etc about it with details? (for ex. troy hunt)

12:17 AM

@arda blogs.dropbox.com/dropbox/2012/07/security-update-new-features

@PrivatePansy ah

mashable.com/2016/08/12/olympics-green-water-chemistry-lol/…

hahahahahaha

I missed this before

two bugs

twitch.tv/twobugs Live!

rip. no one box

put http:// before it

12:22 AM

that's what i get from grabbing the link from the page source

cc @badp for adequate hacking

KutuluMike

@twobugs this does not look like realm grinder

@KutuluMike realm grinder 3d

KutuluMike

for a second i wanted to play deus ex again.

then i remembered I own it for xbox 360

then i remembered my xbox 360 sounds like a rusty lawnmower

then i remembered why i stopped playing anything on my xbox 360

12:57 AM

@Wipqozn Saved my game on an elevator. Came back to play and now whenever I load I fall through the floor of the elevator. Previous save is like 2 hours ago. :(

@Sterno cc @badp for @Sterno's adequate saving

@Sterno What about an autosave? D:

two bugs

1:18 AM

twitch.tv/twobugs STILL STREAMING

@twobugs You're streaming a narrative-heavy game I'm currently playing, so I can't watch. ;-; I'm sorry!

user15026

@twobugs sweet, my dinner just finished cooking

user15026

(I got a toaster oven for my birthday and like I know that's not revolutionary or anything but holy crap how have I lived so long without one. SO much nicer than using my oven for like one meat pie)

ludum dare 36 just started...

Well, the top frame is me, at least. :P

user15026

1:39 AM

@Fluttershy Yeah, I was gonna say, I identify with the top bit

user15026

the bottom not so much

with this post, I am now both

Q: What happens if you give Miller Rucker's evidence?

0

At the end of the mission where you're supposed to capture Rucker, assuming you got the evidence from his side room, you have the option of giving it to Miller or waiting and giving it to Vega. I've browsed around the web and seen how it plays out if you give it to Vega, but I haven't see any wo...

deus-ex-mankind-divided

Son of a Sailor

2:03 AM

I'm hoping by next year I'll have the skills for something like Ludum Dare or other software jam. Currently all my programming is too slow and text based for something like LD

Q: How do I fix this line of code for Windows Command Prompt (Paragon)

2:16 AM

0

I want to make a .bat file to open Paragon or the "Epic Games Launcher" (I don't play any other games in this launcher). I think I need to begin the line with start insert/File/Directory/Here... This code is where I have the Launcher saved. "C:\Program Files (x86)\Epic Games\Launcher\Portal\...

paragon

@SonofaSailor tbh I suck on coming up with game ideas or developing them, but game jams force me to learn a lot in a short amount of time, which IMO helps

2:32 AM

@Lazers2.0 I was not able to find his keycard

@Sterno that's terrible

Son of a Sailor

@Arda yeah I learned the most while I was interning because instead of learning in tiny pieces at school I had to pick stuff up quickly. At school they wouldn't dream of teaching us GUI programming until late in the curriculum but at my internship I had to learn Python GUIs in a few weeks.

Q: Help please! (Minecraft command blocks)

0

I'm trying to set up a contrption that will scan for a ghast tear called "essence of chuck norris" but i can't seem to get the commands right, how can i do this?

minecraft

user15026

2:53 AM

Mario and Luigi Paper Jam has so many annoying boss fights. Most of the reason I haven't beat the game even though I have been playing it for what seems like forever is that I keep rage quitting and not playing for weeks because I hit another stupid fight.

Q: Any good gaming tournaments out there

0

I'm just wondering what the best gaming tournament is for minecraft? I can't ever find good PvP anymore, and I'm a console gamer. Thanks!

minecraft

0

Q: Cannot reconnect controller when it shuts off automatically - Payday 2 Crimewave Edition

Sometimes, I'll pause my game to go do something and occasionally I'm away for so long that my controller turns off to save battery power. Like most games, a message pops up asking for you to reconnect your controller. However, no matter how many times I press the A button to make the message go...

xbox-one payday-2

Newly Opened Proposals for Entertainment

3:11 AM

1

Battle Simulation

Proposed Q&A site for those who are interested in battle simulation involving NERF, Airsoft, and other battle simulation activities.

Currently in definition.

Q: Game capture in OBS causes game to crash directly after enabling

0

Whenever I try to enable Game Capture on OBS for "Geometry Dash" (I know, not everyone's favorite game...) the game crashes on the spot. Here are my specs: http://speccy.piriform.com/results/qoGkeCcL3z3HVEqNQrdeXck

geometry-dash obs

Q: How can I use my controller to play Borderlands 2?

3:43 AM

0

The controller I'm using is Universal USB 2.0 Wireless Vibration Controller Gamepad Joypad for PC, EW800. I plugged in the usb and the computer is detecting the controller. However, I'm unable to use it to play Borderlands 2. Help?

borderlands-2

0

Q: Are there any PokeStops or Gyms in Antarctica?

It's expected that Antarctica should simply be a blank map in Pokemon GO with no Stops, Gyms or Pokemon spawns, right?

pokemon-go

AHAHAHAHA, apparently NMS wipes your discoveries after two weeks.

cc @Sterno

@Yuuki niiice

so we will only see planets with names of fresh memes

4:08 AM

Mmm, indeed

4:20 AM

is drunk

user15026

is sober, awake, and watching Glee

is trying to sort through a mountain of schoolwork while staying sane

is sleepdrunk, otherwise sober, semi-awake, and working on GameNameGoesHere

5:05 AM

bad news: I'm developing a cookie clicker

or cookie typer, if you will

Heh, my roommate just donated a pizza to a group of kids on the struggle train hard

They were very grateful

It was awesome

#makeudgreatagain

:)

"where do you live?" "freshman dorm" "go home, drink water, eat pizza"

Kids these days

Kids all the time

The least we can do is provide cheap pizza for the struggle train

Also we set off our fire alarm earlier for closing the door too hard

It was great

5:47 AM

(they replaced it though it's ok)

It was great since the police also accidentally set it off

@SonofaSailor exact reason why I'm not a fan of CS/CE corpuses in most Universities (coop helps a lot). So much good information, but it is distributed rather randomly over 2/3/4/5 years.

@arda university CS teaches you the fundamentals so that later learning is easier

@GodEmperorDune exactly and I agree - that is why I want to go to uni

6:44 AM

> literally endless (not literally, that'd be tough).

Q: Do I need Internet to download dlc's from a disc?

7:34 AM

0

So I recently got skyrim legendary edition for the Xbox 360, but I don't have any internet on my Xbox but I was wondering if I could still download the dlcs from the disc, or do I need Internet connection?

skyrim xbox-360

@Unionhawk what's a struggle train

why do you have a struggle train

@Unionhawk is that a struggle train because the door was struggling

what were you doing on the struggle train

is it the struggle train because it was going to Struggle, TX

why were you going to Struggle, TX

I'm trying to write a SQL query that's analogous to finding out if any question on this site has both the [bioshock] and [pc] tags

I can't really think of any good way to do it other than something like this

SELECT COUNT(*) as c FROM Posts q
JOIN PostTags pt ON pt.PostId = q.Id
JOIN Tags t ON pt.TagId = t.Id
WHERE t.TagName = 'bioshock'
OR t.TagName = 'pc'
GROUP BY q.Id
ORDER BY c DESC

and checking if the first row has a count of 2

@PrivatePansy might be easier to join the tags table twice with different aliases

7:49 AM

@GodEmperorDune Right, but in the actual case I'm working with here I'm looking at three 'tags'

Which is not impossible to write, of course, but messier than I'd like

join tags t1 ON (real equalkity thing) AND t1.tagname = 'bioshock'
join tags t2 ON (real equality thing) AND t2.tagname = 'pc'

@PrivatePansy and you need all 3 to match or 2 out of 3?

All three to match three out of three. Just have to check if there is a 'question' that has that

It's not really question and tags, but they are a good stand in for most many to many relations

then add one more JOIN tags t3 ON (tag matches question thing) and t3.tagname = 'yolo'

the more restrictive the query, the better it will perform, in general

SELECT q.Title FROM Posts q
JOIN PostTags pt ON pt.PostId = q.Id
JOIN Tags t1 ON pt.TagId = t1.Id AND t1.TagName = 'bioshock'
JOIN Tags t2 ON pt.TagId = t2.Id AND t2.TagName = 'pc'

Tried this on the data explorer

Doesn't seem to work.

There are questions with both tags. I can verify that using the site itself

SELECT q.Title FROM Posts q
JOIN PostTags pt ON pt.PostId = q.Id
where q.id in (168555,102746,101821,3658)

gives 0 results

but those are the four question IDs that the site returns

...because I'm searching on stack overflow

are you searching on stack overflow?

8:02 AM

Erm, no

Gaming.SE

YOU HAVE BEEN SEARCHING ON STACK OVERFLOW ALL ALONG AREN'T YOU

No

YOU SILLY PERSON

I KNEW IT

The first query returns results while the second doesn't

aha!

SELECT q.Title, t2.Id FROM Posts q
JOIN PostTags pt1 ON pt1.PostId = q.Id
JOIN Tags t1 ON pt1.TagId = t1.Id AND t1.TagName = 'bioshock'
JOIN PostTags pt2 ON pt2.PostId = q.Id
JOIN Tags t2 ON pt2.TagId = t2.Id AND t2.TagName = 'pc'

8:07 AM

Ah, okay

Wow that's a lot of joins

you do need two different rows of PostTags to make your joins to Tags

Yeah, I can see why now

8:23 AM

I mean in retrospective what you OBVIOUSLY want to do is have a TwoTaggedQuestions cronjob that materializes a table that looks like Tag1,Tag2,CommaSeparatedQuestionIds

Uh...

in order to make things FASTER, you see.

oh right you need three tags

that's probably not a problem!!

Actually denormalizing here might be a good idea

see

select T1.Id, T2.Id, T3.Id, PT1.PostId from
  Tags T1
  join PostTags PT1 on T1.Id = PT1.TagId
  join Tags T2 on T1.Id < T2.Id
  join PostTags PT2 on T2.Id = PT2.TagId
  join Tags T3 on T2.Id < T3.Id
  join PostTags PT3 on T3.Id = PT3.TagId
  where PT1.PostId = PT2.PostId and PT2.PostId = PT3.PostId

this only takes about 26 seconds and 2 years of life off @TimStone

I think I'm just going to partially denormalize instead

Save the tag IDs as a field on the question then query that instead

8:34 AM

I hope you have some group_concat thing to maintain that column then

The tag and question are just examples. In actual fact the table is used to track games between players and stop the same players from playing against each other again

So this should be fine

I think

8:58 AM

→ 1 message moved to Android Hell

9:16 AM

soundcloud.com/noisia/voodoo

crazy drop. cc @GnomeSlice

Q: Does the position of module upgrades affect their effect in No Man's Sky

9:26 AM

0

All upgrades in NMS say that they get activated as soon as they are available inside the inventory/suit/cartridge. Though, I have noticed that, suppose, if I put all mining tool upgrades close to each other, they all get a green coloured aura around them. Does positioning of these upgrade module...

no-mans-sky

Q: How can I register player breaking blocks? 1.7.10

10:57 AM

0

Hello I am in a city on a server and I want to make a computercraft program that would register griefing or/and breaking block and it is not posible in vanilla computercraft as far as I am awware. Can you please point me to some peripherals?

minecraft minecraft-mods minecraft-direwolf20 minecraft-computercraft

Q: How to control computers using rednet? 1.7.10

12:04 PM

0

I would like to set up a big computercraft network with one main computer using wireless modems and rednet api. Though I was not able to find any tutorials - all of the tutorials I found were using Craft os 1.6 or lower (I am using 1.7). The wiki was not much help either. Thank you in advance.

minecraft minecraft-mods minecraft-direwolf20 minecraft-computercraft

Q: we are unable to connect to the store

12:15 PM

0

I Have this Error When I try Realms in MCPE: we are unable to connect to the store. maybe check your connection? I Have good Internet Connection... What is the problem?

minecraft-pocket-edition

Newly Opened Proposals for Entertainment

12:49 PM

1

Science Educators

Proposed Q&A site for anyone teaching a science (e.g. physics, chemistry, astronomy, biology, earth science) at any level and anyone interested in improving the Science Education process

Currently in definition.

Q: What are easy sources of auram? 1.7.10 (thaumcraft 4.2)

1:13 PM

0

I am playing direwolf 20 1.7.10 and I got to the point where I can get silverwood wand and I want to have it with thaumium wand caps because why not but I need auram to activate the wand caps and you get auram from beacons and nether stars just really end game stuff. Is there a way to get auram w...

minecraft minecraft-mods minecraft-thaumcraft minecraft-direwolf20

1

Q: Are unlocked basic cards automatically added to class' default deck?

Every class starts with 10 cards. As I unlock more are the new cards added to default decks or do I have to create a custom deck to use new basic cards?

hearthstone

1:31 PM

WHY

@Yuuki halloween is coming

@badp yeah, seriously, come on @Yuuki.

Where's your Halloween Spirit?

you know the jingle

♫ HALLOWEEN IS COMING ♫
♫ HALLOWEEN IS COMING ♫
♫ HALLOWEEN IS COMING ♫
♫ ALWAYS COCA-COLAAAAAA ♫

@Wipqozn Well, my ancestors are all back in China.

@Yuuki So people from China don't like candy? Wow, @Yuuki, that's a horrible thing to say.

1:36 PM

Etsy shopping experience: "Oooh, this looks cool" > clicks on item > "Great price too!" > clicks on shipping > sees shipping is twice as expensive as the item itself > Goes back to list of items > "Ooh, this looks cool"...

EVERYONE LIKES CANDY @Yuuki

@PrivatePansy I didn't know Etsy had non-ironic buyers

@badp Some of the things there aren't too bad

But because it's all individual sellers the shipping is all over the place

user15026

@Yuuki considering that's not listed on their site anywhere, and googling gives you the same image over and over I assume fake

user15026

@PrivatePansy this happens to me all the time

1:39 PM

I've seen $2 pins with $20 shipping fees

user15026

@PrivatePansy I wanted to buy a SU patch for a jacket I am constructing and they wanted $6 for the patch and $13 for shipping

user15026

Its kinda like eBay in that sense where the cheap stuff gets insane shipping tacked on so they can claim it's not expensive, it's just shipping lol

@Yuuki considering clorox is usually associated with self harm, I can see why.

My SQL sense is tingling, what has @badp done?

2

@TimStone you have subconsciously removed all details about it.

I wonder sometimes if MySQL isn't kind of the Visual Basic of databases

user15026

1:55 PM

"You know, DNA was only invented like 15 years ago and I don't believe in it. How can you know we're made up of that stuff" oh people on the bus never change

@arda I thought it was usually associated with a bright white clean

@GnomeSlice I'm, as always, in the worst part of twitter

knowyourmeme.com/memes/bleach-drinking

I blame stomedy

Q: Finding the name of an old game - windows / single player / puzzle / ball game

2:24 PM

0

I remember playing this game some years back, but not able to remember the name of the game now. Description - Puzzle game with a ball. Black background. White balls and white walls/obstacles. We move the ball with the arrow keys. Pressing left key would make the ball move to the left continuo...

game-identification

@Ash well, he's doing well to be suspicious, since we aren't actually MADE of DNA ;P

2:43 PM

Do people really have issues with WinRAR and popups? I've never gotten those and given that WinRAR is pretty much free, I don't really think you have room to complain.

Yeah, I use 7zip now, but I'm not gonna give WinRAR grief when it's essentially freeware.

7zip is pretty great

New Year's Resolution: pay for WinRAR.

user15026

@badp true, I suppose :p

user15026

@Yuuki I have never had an issue with winRAR

@Ash I just walked into a Reddit thread about WinRAR and the top comments are people complaining about its popup notifications and how 7zip is so much better.

And I'll concede on the fact that I'm using 7zip right now instead of WinRAR, but goddamn the WinRAR people are great people.

They don't deserve that.

2:48 PM

rarlab should make itself not work after 40 days

that'll show the haters :P

user15026

@Yuuki yeah, unless they mean the easily skippable "please pay for this" at the beginning, but even that is, well, easily skippsd

> You know, I bought a license for WinRAR in 2002. Here it is, 14 years later, and they're still working on the program and giving me updates. I totally got my $30 worth. They absolutely earned it. They've given me a 64-bit, fully multithreaded edition, when what I really paid for was a single-threaded, 32-bit program, back when Windows XP was new.
Precisely because of relative freeloaders like me (14 years of update service for $30?!) modern licenses expire, so it's not the outrageously good deal that it was. That's really a bummer, because I'd otherwise still recommend paying for it, even…

reddit.com/r/PaidForWinRAR

Swimming next to the edge of a waterfall.

NO!!

@Sterno @TimStone I like how so long as a persons house isn't considered restrited terrority you can just stroll on in and take all their stuff and they won't care

one fo them was like "damn augs, stop bothering me on the street!"

2:56 PM

@GraceNote is the tradition of explaining what a reverse wall jump is in the most awkward and incomprehensible ways one I should pay forward

took me 30 hours to understand

and now I can't believe that it's just... that

Okay, you know how I mentioned yesterday night that NMS is deleting your discoveries after two weeks? Apparently they actually just take super-long to load.

@Yuuki pretty sure that article was proven wrong

@Yuuki well of course information only travels at the speed of light when it is inconvenient for it to do so

Smash Glow Crystals in a Blender

@Wipqozn I have to visit the in-laws this weekend so no Deus Ex for me :(

3:00 PM

@Sterno On the bright, I don't need to visit the in-laws

Someone is saying that Steam's extended the maximum playtime duration on refunds for NMS, but I've refunded a game that Steam says I've played 3 hours so I don't know how accurate that is.

triphenylphosphinebis(pyridine)thiocyanato copper(I)

> The crystals possess the property of triboluminescence, they glow when crushed, blended, smashed or otherwise broken.

@Wipqozn but on the downside you're going to die sad and alone. I'll only die sad!

@badp the struggle train coincides service with the struggle bus.

@Sterno :(

3:02 PM

And probably alone, because who goes to visit old people who are about to die? Eew

I cry every tim

@Unionhawk but is the struggle real

Tim is the tear collector

@Sterno That reminds me, my grandmother called me the other day since she hadn't seen or heard from me in a while.... I should probably go visit her. My defense is she's been partying it up in her new trailer all summer.

It was for these kids

That's why we decided to donate food and advice to go the fuck home

3:04 PM

Don't Google "lemon party"

I SAID DON'T

Dwayne Wade's cousin was just shot and killed walking her baby in Chicago. Just what I have been saying. African-Americans will VOTE TRUMP!

Tweeted by realDonaldTrump on August 27, 2016 at 1:24 PM

@Yuuki I mean if that earlier thing was correct after two weeks it's almost like you never played at all, so

WHY WOULD YOU EVER THINK THAT'S A GOOD THING TO SAY

@Wipqozn Although one of the apartment vendors got mad at me for taking a credit chip off a counter and then I accidentally had to blow them up with a frag grenade

Who is Dwayne Wade? Also, you walk dogs, not babies

3:08 PM

@Sterno IIRC, he's a relatively famous basketball player.

KutuluMike

I think, of all the things wrong with that entire message, the fact that he spelled Dwyane Wade's name wrong should not bother me as much as it does

@Yuuki oh. Sportsball. That makes sense

Google Camel View

@KutuluMike Nah, it highlights how disingenuous his concern is on top of everything else

Q: Does it matter what order i play the assassins creed games?

3:10 PM

-1

I know there's an order to the games, but are their stories built off of each other or are they separate?

assassins-creed-series

To be fair, "Dwyane" is a weird spelling

Sir David Attenborough narrates Adele's Hello

3

> Lesser spotted Adele

Oh, he's narrating the music video. I thought he was going to dictate the lyrics.

user15026

@Yuuki Not only that but like...what does the first sentence have to do with the last sentence

#flipphone

On the one hand, Forbidden Kingdom is leaving Netflix. On the other hand, I can just Youtube "jet li vs jackie chan" for the only scene anyone ever watches for that movie.

3:17 PM

@Ash clearly Trump had literally been saying Wade's cousin would be shot and we should vote for Trump because of his precognition powers

user15026

That's definitely it.

He will get 95% of the black vote you guys

(for reference: President Obama got 93% in 2008)

(or 2012 idk)

@Sterno Why not both?

Sorry, Gandalf Doesn't Do Weddings

user15026

Dear Weight Watchers, hollowing out a cucumber, shoving meat inside and calling it a "sub" does not make it appealing.

user15026

3:25 PM

(Seriously who comes up with some of this stuff)

That actually doesn't sound terrible

user15026

@Sterno Aww, the link stripped the picture. :( That's really what makes it

My wife is doing Atkins so I've seen weirder bread substitutes

user15026

3:45 PM

I'm scared to ask.

user15026

I mean WW has been going well for me, it just makes me laugh sometimes what they substitute.

user15026

(I really don't get the zucchini noodles trend)

Frank

Spam

I've had them. They're not awful (if you can't eat real noodles)

> Serving size: 1 sub half

user15026

3:51 PM

@Sterno I have tried them but I think I cook them wrong, they get so mushy

I think the Italian part of this recipe is that, if you're going to throw some of it away, you might as well just discard the whole thing and put some water to boil

for some proper food

user15026

I suspect part of my issue with the sub is that I don't like cucumbers that much

Is "sub" suppposed to stand in for "subway"?

the depression chain of, uh, depressing, um, what's the word?

user15026

sub like submarine sandwich

user15026

aka the type of sandwiches subway sells