checked both of them

seem SFW

(the sacrifices I make as a mod ;p)

> The complete X.509 path validation algorithm is a work of the Devil to confuse and corrupt good men's minds.

well, that was the most syntactically complex SQL query I've ever written, if not the longest

gist.github.com/allquixotic/fe79a7d9da56c6623e2f

Hai!

@allquixotic That's not too bad :P

Should see some of the crap I had to come up with for a database course :\

When your proc exceeds 100 lines, well... good luck.

CREATE OR REPLACE TEMPORARY VIEW cs AS (
    SELECT report.snum, student.lastname, section.secnum, course.cnum,
           course.name, course.level, section.term, report.grade
    FROM report, student, section, course
    WHERE report.snum = student.snum AND report.secnum = section.secnum
      AND report.term = section.term AND section.cnum = course.cnum
      AND course.dept = 'CS'
);
CREATE OR REPLACE TEMPORARY VIEW math AS (
    SELECT report.snum, student.lastname, section.secnum, course.cnum,

@Bob ^

> Find students who took at least one course in the MATH department and at least one higher level course in the CS department and got a better grade in the CS course. Retrieve the snum and last names of the student(s), the courses they took, which department the course is given by, the level of each course, and the secnums, terms and grades of the courses satisfying this query.

o.O

@JourneymanGeek massdrop.com/buy/smsl-m8

Hm, more weird cheapies massdrop.com/buy/ttpod-t1e

I have too many already though

ahh

tho, for around that amount of money, I'd look at a schitt modi (cheapish) or an odac

massdrop.com/buy/pelikan-souveran-m800-805

Says a lot about their profit margins :S

(actually, an odac's in my future XD)

@Bob If you're allowed to disclose it: What is the specified price? I cannot access the page without logging in.

This pen is about US$550–600 here.

@DragonLord 50% off RRP for about $360

I happen to own an M600, which currently costs around $400.

Was $299 when I got mine

o.O

The prices of Pelikan fountain pens have skyrocketed over the last several years.

When I got my first serious pen a few years back, the entry-level Pelikan M200, it was $84.

It's now $100–120.

Quick programming question: Is this legal C++?

int foo(), bar(), quux();

Multiple prototypes for functions with the same return type.

Seems to work in VC++, but not sure if this is okay for any compiler

@DragonLord I'd read the C++ standard, but that way lies madness

And the madness starts with an agonisingly slow download.

I'm checking right now

I have a copy of N3337 on hand right now

Looks like it constitutes a declaration (just like declaring variables on the same line) and is therefore legal C++

Okay, 8.0/1 of the C++ standard says:

> A declarator declares a single variable, function, or type, within a declaration. The init-declarator-list appearing in a declaration is a comma-separated sequence of declarators, each of which can have an initializer.

The function prototype is a declarator and this is simply a list of declarators in a declaration.

This is legal C++.

Legal doesn't mean good practice, though.

In my case, they're closely-related member functions of a class (all getters).

See ya.

My mousewheel at work squeaks :(

oh wait it stopped

o.O

lol

that drives me nuts about my work mouse

Have any of you ever set up Google OAuth? I'm a bit confused by the consent screen I'm seeing

When I set it up at home yesterday, it told me "application wants your email address"

Today I try it from work and the consent screen says "application wants offline access"

But the requested scopes haven't changed

Morning

I'm trying to log onto ServerFault but when I do it says there is no login page (Chrome shows "page not available")

Sorry, not used any of the OAuth tools :(

it is my PC

ignore that request :)

theverge.com/2015/2/19/8068465/…

0_0

> The VAIO PC division was sold last year

O_O

I... haven't been keeping up

> Sold to investment fund Japan Industrial Partners

@allquixotic Note to self: avoid anything Lenovo-related like the plague (not that I wasn't doing that already, after those issues with this tablet...)

arstechnica.com/security/2015/02/…

blog.erratasec.com/2015/02/some-notes-on-superfish.html

@allquixotic Also, apparently it's been confirmed to be on the Yoga 2 Pro... might want to check yours.

These kinds of software, sadly, are what keep the profit margins up

My tablet is somehow "clean", but the whole thing leaves a bad taste. And now I can't even trust the damn thing.

Ultimately, every last dollar counts, and consumers won't tolerate paying $50 more for a clean PC, a difference they might not notice if the hardware is up to snuff

@DragonLord No, they're what make your company fail when they're inevitably discovered.

It's a terrible decision, business or otherwise.

@Bob I have a lenovo laptop :(

I'd be surprised if Lenovo is getting more than $5 per device for this.

But then, it didn't come with an OS installed

@Bob yeah, that has me annoyed

@DragonLord: there's installing stuff, and there's actively sabotaging security

o.O

@JourneymanGeek catchoftheday.com.au/event/45591/product/…

$300 keyboard...

not mech, either

lol

Has a screen

actually has a screen and many small screens

$400 RRP

@JourneymanGeek Still ridiculous -_-

Who looks at their keyboard?

lol

> Load up music videos or watch game guides directly on the YouTube app, with fully integrated YouTube controls

wtf

lots of people?

They're passing it off as a gaming keyboard with a touchscreen.

Actually?

If you need to look at your keyboard while playing a game, you're gonna do badly at both

I think it was the prototype for the switchblade

(bigger razer blade, same setup)

@Bob Thanks! I'll do that.

*proceeds to nuke disk from orbit*

@allquixotic canibesuperphished.com

Try in IE or Chrome.

You should get a cert error.

(FF isn't affected, so it'll show a cert error regardless)

o0

I'll do that at home, thanks

uhhhhh........

I got a cert error at work O_O

is that normal?

Oh

> If you can access this site without any warnings, then YES, you are vulnerable.

gotcha

@allquixotic The whole point is Lenovo/Superfish installs a root CA on all their machines with the (same!) private key

gotcha

So people can extract said private key and perform a MitM on any other Lenovo machine

That site uses a cert signed with this key. A cert error is a good thing, in this case - it should not be trusted at all.

right

sorry, I was up until 4:25 AM (again) tonight handling a griefer/cheater on my Life Is Feudal instance :/

ow

did some IP sleuthing, firewalled a bunch of subnets, banned his steam account by ID, then banned the steam accounts of all his friends that own Life Is Feudal

Hm. Early access?

Huh. Pretty pricey for pre-release.

yeah; the game itself really sucks, but it has just enough interesting core game mechanics to be worth playing... I help run a roleplaying server that's usually pretty full, around 50 - 60 out of 64 players

Wow.

there's something odd about the way they do development, though

the things that are working in the game are actually working very well and almost bug-free

the things that don't work, aren't implemented at all, and get held back a looooooong time until they're ready

so the devs would rather have a half-finished game, with things in the game that work, than to ship broken shit

That's actually pretty refreshing.

it has interesting implications for balance, though, when entire aspects of the game (like mounted combat, mounts at all, unarmed combat, etc.) are totally missing... but on the other hand, if horses were horribly broken, I'd rather not have them :P

the worst sin of the game is that the server process is 32-bit Windows only (for now....... apparently 64-bit and Linux are planned, but low priority compared to client bugfixes and memory leak fixes)

depending on settings and server load, this causes it to crash out / restart somewhere between once a week and every 6 hours, the exact duration, again, based on how much the server's being used

@allquixotic Surprised that it's so platform-dependent. Servers tend to be relatively easy to keep independent, at least across bit-ness if not OSes.

@Bob maybe they don't have the energy to change the build in VS to 64-bit? nah, I doubt it's that simple -- I bet they're using proprietary third-party middleware that only ships a 32-bit version

that's why so many games in the past have been stuck at 32-bit despite their devs REALLY wanting to release a 64-bit version, or even to go 64-bit only

@allquixotic Rarer for servers, though. They don't usually have too many third-party dependencies.

Or the ones they do have tend to be fairly generic and already available cross-platform.

Are they developing a custom physics engine?

@Bob I don't know about physics, but they have a concept of terrain layers, where the ground is divided up into tiles, and each tile has one or more layers of different types of material, like rock, forest soil, fertile soil, granite, iron ore, etc. The amount of each resource determines the appearance of a tile. So putting 1 unit of forest soil (which is really not a lot; a decent amount of soil would be at least 100) on top of granite would cause it to visually blend a slight

appearance of forest soil being on top of the granite, but not a lot of it - the granite would still be visible

o.O

so if you have a tall mountain, there could be hundreds of layers from the top (snow) to the bottom (water, eventually).

I've actually been looking for a good (MMO)RPG recently.

Haven't really found anything :\

snow, dirt, iron ore, more dirt, copper vein, more dirt, etc

the game's rendering engine is decently well optimized if you turn off shadows (let's face it, it's not surprising that yet another game can't do shadows efficiently), and the client is stable if you have a good computer and a decent connection to the server... the main problem is that it takes a ridiculous amount of CPU for the client to actually load all the terrain layers

on my beastly rig, it takes about 6 to 8 minutes to load into the game on our server that's around a month old. a brand new server (one that just got wiped) will load in within 30 seconds.

the more changes people make to the terrain (terraforming, mining, etc), the longer the load times

and they're horrific for people with low-end CPUs... I've heard of 45 minutes for someone on a Nehalem i3 with a Radeon HD6850 or so

their roadmap suggests they are working to optimize the terrain loading process by April-May timeframe, but this developer has a history of running over their schedule

> decent connection to the server

nope

@Bob ping game.silverrush.net

Pinging game.silverrush.net [167.114.119.137] with 32 bytes of data:
Request timed out.
Request timed out.
Request timed out.
Request timed out.

Ping statistics for 167.114.119.137:
    Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),

@allquixotic Nope.

@allquixotic I don't think there are servers at my work that won't give a cert error.

@Bob oh, must be ICMP filtering

@allquixotic If it's US-hosted, there will be a minimum of 200ms RTT. Usually 300+

@Bob OVH in eastern Canada

Yea, probably 300+

I need to run convert videos via command lines sometimes on my webserver

I use ffmpeg but CPU spikes

what can I do to avoid that

I mean can I do it in the background or something

@AhmedDaou Video conversion takes a lot of CPU. You can trade CPu for video quality or file size, but you can't have the highest quality video and the smallest file sizes and the lowest CPU usage. You could, in theory, achieve something better if you had hardware-accelerated encoding on a GPU, but almost all servers don't have a GPU, so that probably doesn't apply.

If you're running on a modern Linux distro, you probably already have ffmpeg cgrouped automatically, which should prevent its CPU usage from interfering with other processes. The IO bus could be saturated though. Hard to say.

@allquixotic thanks for replying. I m running windows server 2008. I dont mind loosing some quality, I just dont like it to spike to 100% CPU.

is there a command for quality, I saw one for threads

@AhmedDaou What is the symptom of your problem? Are you seeing any specific behavior from any program that would indicate that 100% CPU might be the problem?

100% CPU, by itself, is a non-problem. If anything, it's good, because it means the video is being encoded as fast as your CPU is capable of doing it.

@AhmedDaou That depends on the exact codec(s) you are using. Reducing the quality will still result in the CPU reaching 100%, but it will just be at 100% for less time. So if it takes 10 minutes to encode at quality 9, it might take 3 minutes to encode at quality 6.

@allquixotic I think you have a valid point, maybe its my paranoia that something will blow up lol I just have illusion that the server could hang or something

Reducing the number of threads will cause any remaining CPU cores to be idle. The cores that are occupied will still "spike" to 100%, though.

@allquixotic so I should not worry about the spike right? it does drop after conversion

If you have a quad-core processor with hyperthreading (total 8 hardware threads), setting it to use 1 thread would cause ffmpeg to use no more than "12.5%" of your total CPU resources. That would leave the other eight hardware threads idle.

@AhmedDaou I wouldn't worry about it. If you need to, you can reduce the process priority of ffmpeg, or raise the process priority of some other latency-sensitive process.

@allquixotic exactly

and how is that done

For example, if you were running the Apache web server and you wanted it to get priority over ffmpeg for CPU resources (to make your webpages load as fast under load as they do during idle), you can set Apache's process priority to "Above Normal" in Task Manager.

in my case it would be IIS

ok I will look into that

Since ffmpeg's default process priority will be "Normal" always, the "Above Normal" process will get precedence.

thanks for your advice

@Bob is this you, Bob? superuser.com/questions/880062/…

pentaxforums.com/forums/38-photographic-technique/…

Am I out of my mind?

@BenRichards ...no?

@bob it is disturbing enough to me that after buying any piece of computer hardware that i have to remove some addware (even) of any sort. minus the privacy/security.

We are your trusted computer seller, who has already sold you out! thank you for your patronage.

The eventuality will probably be "securing" the addware onto the hardware or you cant even boot anymore. then people will begin to be upset :-)

quick question would you know how to publish virtual directories trhough visual studio