The Quill and Tankard

>50% of First Posts being No Action Needed. Do they even know what they're supposed to be doing in that queue?! You're the first person to review a users post, give it a proper bloody review and teach the person how to use the site.

Any user who presses no action needed just because they're lazy should get a 7 day ban from reviews

TheLethalCarrot

Harsh but could help I suppose

Edlothiad

Not harsh at all. If you're unable to leave a useful comment for a new user to teach them about the site you shouldn't be given the ability to.

They should be banned for 7 days. and forced to recite this answer: scifi.meta.stackexchange.com/a/10607/68872

TheLethalCarrot

8:35 AM

No I agree with that part

Edlothiad

TheLethalCarrot

Hahaha

Edlothiad

absolute crackers today

TheLethalCarrot

Yup

Edlothiad

gfycat.com/gifs/detail/preciousdisfiguredgoitered

Cannae onebox

TheLethalCarrot

8:44 AM

Odd

Edlothiad

damn you

odds on you get the star?

TheLethalCarrot

Haha gotta know which one to copy :P

Edlothiad

> GIF URL

Fam I didn't even see that

TheLethalCarrot

That's your problem haha

Rand al'Thor

9:35 AM

@Möoz Harrumph: scifi.stackexchange.com/review/first-posts/115270 scifi.stackexchange.com/review/late-answers/115272

Aegon

@Skooba Huh I just saw that. Don't know How I missed it

Edlothiad

10:23 AM

@Randal'Thor This room is for ASOIAF/GoT chat please keep the chatter on-topic and not just to call out other users and their ABSOLUTELY TERRIBLE reviews. Please take that to TREU

Rand al'Thor

@Edlothiad You're joking, right? After you were ranting about reviewers in here just a couple of hours ago.

Edlothiad

@Randal'Thor Could you not tell ;-P

Rand al'Thor

(I would've pinged in the Restaurant, but couldn't be bothered to superping since Mooz is pingable here.)

Edlothiad

Superping sounds like a super hero that uses ping pong balls to capture is enemies

TheLethalCarrot

11:20 AM

Hello @fez, what brings you in here?

TheLethalCarrot

11:36 AM

@Edlothiad Ignore that multiple checkboxes can be expanded at once at the moment I'm just trying to fix that but what do you think so far?

Obviously it's only frontend at the moment

Edlothiad

@TheLethalCarrot I thought you said I should do my back end first (no dirty jokes intended)

@TheLethalCarrot This is the third time we've greeted someone and not gotten an answer

@TheLethalCarrot ARGH!

fez

Hello @TheLethalCarrot, and @Edlothiad

I am always watching 0_0

Edlothiad

Are you?

Then you would know the things you're doing that you should stop because I should do them all

fez

Well not always

Most of the time

Edlothiad

Well even if you lurk in here most of the time you should know

fez

11:42 AM

What are the things I should stop? I mean I know, I'm just wondering if you know what I know

Hahaha, surprising to see code being talked about in a GoT room

TheLethalCarrot

@Edlothiad Don't think I said either way, but you need some front end to test the back end haha, I'm just trying to get something usable front end that looks quite nice before moving to doing the backend and haha you said it would happen.

@fez We're all devs to a certain extent in here and GoT is in the winter at the moment

Plus I'm designing asearchoficeandfire but for the show

fez

Oh very nice

Edlothiad

We're doing got related things but without got

TheLethalCarrot

Something to do in my spare time at least

Edlothiad

and me and TLC need to use up our time somehow, speaking of which, are you not at work @TheLethalCarrot

@TheLethalCarrot I don't know which message this is in reference to

@fez Oh I know. Everyone knows that I know

TheLethalCarrot

11:53 AM

@Edlothiad Most first after the last and last message

Edlothiad

@TheLethalCarrot Hmm inspect element, copy paste, change titles, shaboop

TheLethalCarrot

And yeah I'm at work but lunch now plus it's a slow day haha

Edlothiad

@TheLethalCarrot En Anglais, s'il vous plait!

TheLethalCarrot

@Edlothiad That's what I did from asearchof then removed pretty much everything and wrote it from scratch anyway haha

Edlothiad

Ah I understood, the backend thingy

@TheLethalCarrot Lol I did the same

TheLethalCarrot

11:55 AM

Yeah you need some frontend so you can test the backend haha

Edlothiad

I could get started between loads tonight (not a dirty joke either, I'm talking about laundry)

@TheLethalCarrot I didn't know lol

TheLethalCarrot

Hahaha

Plus a good front end motivates you to do the backend

Edlothiad

Ok, I'm going to log the policies I have open now, and then figure out this OCR work-around, it's a bloody faff that this OCR is only a portion of Tessarect's options

I think I'm going to have about 4-5 meta posts to write on sunday clarifying policies that are scattered between 4-5 meta posts EACH

TheLethalCarrot

That sounds normal haha

Always awkward to sort them out

Especially older ones

fez

I did not realise you could scroll up to go back to the search, that's pretty snazzy

Edlothiad

11:58 AM

One guy has basically asked three different questions about duplicated being marked based on answers

@fez On which site? SearchOIAF?

TheLethalCarrot

@fez On asearchof? Yeah it's well designed

fez

Yes

TheLethalCarrot

Sadly I'm no web dev so my version won't be haha

fez

Ah I see why there was the inspect element, copy paste, change titles

TheLethalCarrot

Yeah haha, though I've re-written all the HTML and css anyway now

fez

12:00 PM

That's how the majority of web dev is done in my experience

Back to work, cheers all!

TheLethalCarrot

Ciao

Edlothiad

you forgot the shaboop

never forget the shaboop

Aegon

I forgot why I came in here

Bael the Bard

0

Q: Does ASOIAF feature a 'war against one man'?

I heard of a war/battle in the series which ends very suddenly. This is because the winning side considers the war to be a personal vendetta against the leader of the losing side's country, rather than against the country itself. They have no interest in conquering the losing country. Once the le...

a-song-of-ice-and-fire

Edlothiad

12:24 PM

@Skooba enough edits, calm down please

Aegon

12:40 PM

Hah found the answer

TheLethalCarrot

Any chance Princess Lelia Lannister is inspired by Princess Leia

Edlothiad

@Aegon you may be interested in this one: scifi.stackexchange.com/review/close/115293

@Aegon Agh I should've known that, I just finished The Westerlands

Although after reading your answer, I'm not convinced that's it

Aegon

@Edlothiad War between two countries checked, Personal Vendetta checked, Winning side withdrawing after victory checked

Edlothiad

@Aegon Once the leader man has been killed they immediately retreat and return to a state of peace with the losing side. cross

Aegon

@Edlothiad The Lannisters went back to Peace

Crakehall did not

Lannisters did not aid or endorse Crakehall

Nor did they intervene in the ensuing Uprising

Hence, they were at peace with the Ironborn

Edlothiad

12:56 PM

Ye but they never left after the leader being killed

Aegon

@Edlothiad The Killed leader is Hagon

The Winning side left

If the Lannister King does not approve acts of a Vassal

His bannermen would do the same

Its implied

Lets say you are Lord Crakehall

I am Lord Reyne

Edlothiad

No you're just telling me things I know and not listening

Lets not play this silly game

> defeated the Ironborn and hanged Hagon

Is what you said

Aegon

Okay explain your point

I'll go back to editing in the meanwhile

Edlothiad

> Once the leader man has been killed they immediately retreat and return to a state of peace with the losing side.

Hmm wait

You were correct

Updoot for you, I misread the "Once the leader man has been killed" cuz of it's awkward wording ending with "with the losing side"

Aegon

2

TheLethalCarrot

1:03 PM

Haha

Edlothiad

Why is there a WWE logo in the back?

Aegon

No idea but the smug son of a goat looked good in glasses

TheLethalCarrot

@Aegon Hows your DB knowledge/

Aegon

@TheLethalCarrot I'd say decent albeit not extensive as my area of work doesn't require me to interact with DB in a query-esque manner.

TheLethalCarrot

Fair enough

I was going to mock up a design for my tables, see what you thought if you had experience

Aegon

1:14 PM

ERD?

TheLethalCarrot

Well my quick mockup was going to be something like:

Edlothiad

Are you not going to work today TLC?

TheLethalCarrot

Quote
    Id
    EpisodeId
    CharacterId
    Quote

Episode
    Id
    SeasonId
    Name

Season
     Id
     Name

Character
     Id
     Name

@Edlothiad I've done some work today haha

@Edlothiad Slow day though so filling the gaps

Aegon

@TheLethalCarrot Looks sound enough to me. Are there any other variables that might be needed?

Edlothiad

Ok hack was SOLVED

Time to time this doodoo

TheLethalCarrot

1:21 PM

@Aegon Not that I can think of, unless either of you two can think of anything?

Aegon

@Möoz Would be able to give Free consultation on handling Normalization and optimization

Edlothiad

@TheLethalCarrot I was going to do something similar, although I don't know what all those sub ting are :/

Is the main ting a Class and the subting it's variables or whatever they're called

Aegon

How are you going to enter each line manually tho?

You are recording each quote separately

TheLethalCarrot

Quote would be a table and Id, EpisodeId etc are columns

Edlothiad

Ah ok

So mine is going to be something like:

Aegon

1:23 PM

Wouldn't it be better just to annotate the dialogues with Character Id? And then save the entire dialogue against an Episode?

TheLethalCarrot

@Aegon I'm not sure, whichever would be quickest to be honest

Aegon

Unless you are adding some Filter by POV like functionality as in ASearch

TheLethalCarrot

@Aegon Nahhh, it doesn't seem that useful to me

Edlothiad

Canon
J.R.R.
Christopher
Others

Book
Name

Chapter
ChapterNum
ChapterName
BookName

Quote
ChapterName
ChapterID
BookName
BookID

Aegon

@TheLethalCarrot Yeah so I don't see any benefit in going through all the effort of actually inserting each line

Just shove it all down an episode table which should take the entire script and search from that

**Episode**
Id
SeasonId
Name
Dialgoue

**Season**
Id
Name

Edlothiad

1:26 PM

Oh the indents didn't work

TheLethalCarrot

With dialogue containing the full transcript?

Edlothiad

@Aegon MLF doens't work

Aegon

@Edlothiad Yeah they really aren't working haha

@TheLethalCarrot Yup

Makes the insertion easier, and searching too

TheLethalCarrot

@Aegon Would that be quicker then you think?

Aegon

Instead of going through hundreds of Thousands of rows, just get the 70 rows and be done with it

Assuming there are 10 episodes per season

The Episode Id and Season Id can help you limit the search to an episode or season

TheLethalCarrot

1:28 PM

Yeah suppose that makes sense

It would have been helpful if asearchof guy got back to Ed so we could see how he did it though haha

Aegon

But still, Ask Mooz if it would be faster. I mean logically, it looks like this should be faster and easier to maintain than the previous design

Can't be emphasized enough, DB isn't my core area of expertise

TheLethalCarrot

Yeah and quicker to upload too

Not mine either

I just want to get something working now, I mean the front end, at least the search/home screen isn't too bad :)

Edlothiad

Wait but it doesn't matter how many rows you have, you're searching each piece of text regardless

Aegon

@TheLethalCarrot That looks good

TheLethalCarrot

It all depends on if searching for the text in the DB would be quicker than searching for it in the PHP I suppose but my plan was to get the full transcript back each time so Aegon's suggestion makes sense

Thanks :)

Although the checkboxes are bugged at the moment haha

Aegon

1:34 PM

2

A: Does the speed of the query depend on the number of rows in the table?

Yes, and it can be very significant. If there's 100 million rows, SQL server has to go through each of them and see if it matches. That takes a lot more time compared to there being 10 rows. You probably want an index on the 'x' column, in which case the sql server might check the index rather ...

Edlothiad

@TheLethalCarrot piff haze fam

TheLethalCarrot

Eh? haha

Aegon

CAN WE PUT A PHOTO OF TYWIN ON BACKGROUND?

Pretty Please?

Edlothiad

@Aegon That dirty dirty second naswer!

Just cuz it pushes your point ;P

Aegon

@Edlothiad Well the first answer is pretty much about how you can minimize the negative impact

TheLethalCarrot

1:35 PM

The first answer says the same then expands onto other reasons

@Aegon That can come later :P

Aegon

Oh and I was reading on biological plausibility of Tywin's eyes

Guess Green eyes specked with Gold are possible

Heterochromia

Edlothiad

You guys are assuming I read them, I didn't even read the answer Aegon linked. But since you make those points, I will

Aegon

Man I can't wait to get off work

Edlothiad

Me neither

TheLethalCarrot

@Aegon This one?

Edlothiad

1:41 PM

Rush home, put all my laundry and stuff into a bag, pack some extras race to home home, 2 loads of laundry, unpack, sleep, wake up at 6, fold laundry, pack it up, shoot back to home 1 (not home home) in time for a game of rugby, where I'll probably tear my subscapular tendon and then off to drinks before waking up on sunday morning realising I've lost the use of my shoulder

TheLethalCarrot

Doesn't look as good

Edlothiad

@TheLethalCarrot Agreed

Aegon

@TheLethalCarrot I am down with anything as long as it has Tywin on it

TheLethalCarrot

@Edlothiad One way to spend a weekend, my most exciting plan is going to Ikea :P

Hahaha

I'm keeping the original for the moment

Aegon

@Edlothiad Still far more exciting than the way I am planning my weekend

Actually no

I'll read the Alexiad so It will be nice

TheLethalCarrot

1:43 PM

@amflare Mornin'

Edlothiad

Well that's all in the next 24 hours (besides the sunday morning bit)

amflare

@TheLethalCarrot Hey hey

TheLethalCarrot

How's it going?

amflare

Not bad. Just got to work.

TGIF

TheLethalCarrot

Haha only 2.25 hours left for me

amflare

1:44 PM

damn brit

smh

Aegon

1h 15m for me

TheLethalCarrot

Hahaha

@amflare You're a web guy, what do you think so far? gameofsearches.x10host.com

amflare

Why is the search text white?

in the white input

TheLethalCarrot

Cos I liked it being white haha

There's still problems with that at the moment but I'm going to start looking at the backend now

amflare

Gotcha

What are you building the backend on?

TheLethalCarrot

1:49 PM

What do you mean? What host?

Edlothiad

2m23s! That was well rapido innit famboozles!

@Aegon Wait I thought You were in Pakistan? Isn't it like 7pm there?

I only have 30 more minutes

> smaller units = smaller tables = smaller indexes = better performance.

@Aegon isn't that saying that more pieces = better?

amflare

@TheLethalCarrot what language

you are a C# guy, yeah?

Aegon

@Edlothiad Yup. But I work 11-8. Cus to get in at 9 AM requires me to wake up at 7 AM. Which I can't do

TheLethalCarrot

@amflare PHP and it's MySQL I believe

But yeah C#

I've done some PHP in the past though

amflare

ah

Aegon

1:52 PM

@Edlothiad With proper and advanced techniques such as indexing

Edlothiad

@Aegon My god, those are beautiful times. It also means I start working before you do even though I'm 3 timezones behind :D

amflare

@Aegon I want to be able to work those sorts of times, but I need my evenings to start by 6pm, which means thats untenable.

Aegon

One of the reasons why I am not changing firms rn. Not every company is so chill about flexible working hours.

Edlothiad

Nah i prefer being at work early, means I can do evening things

I have flexible working hours, I can start any time between 6am and 8am, be off any time from 11am to 2pm and leave any time after 4pm and before 8pm

I just love leaving work at 4:40 everyday, so I do xD

and today I need to catch the train home, so it's 4:20

Aegon

6 am?

Have you ever checked in at 6am?

amflare

1:57 PM

@Aegon Thats just way too early

Edlothiad

Nah man, 7:30's been my earliest

I probably will at some point, inevitably

amflare

I'm pretty sure even God Himself isn't up at 6am...

Aegon

I can't remember the last time I was up at anywhere before 9:30

Edlothiad

I could get up at 5:20 and be in by 6pm

I could then just wait an hour grab breakfast, and keep working

would need to get my hand on the coffee capsules here first, haven't figured out how to do that one yet

20 more minutes

i think I have time for some more policies

Lord have mercy Aegon, there was no need for all of that...

Aegon

All of what?

Edlothiad

2:01 PM

scifi.stackexchange.com/posts/172774/revisions

10 revisions...

Aegon

I edit a lot

Edlothiad

The length of it as well, unnecessary information ;)

Aegon

Re-Reading it, noticed a period that should have been a comma and the ambiguity caused by the name Harmund and irrelevance of the Mother's name, so yeah...

Heh, The guy asked for details

When someone asks me for details, I give him details

2

Edlothiad

1000 characters of pre-war history before the 1000 characters of war details

Aegon

When someone doesn't ask me for details, I give them details anyways

It never ceases to amaze me how stupid the Ironborn are, on an irrelevant note

Edlothiad

2:04 PM

@Aegon You realise that error was in there from revision 1 right

I didn't change it because I was worried I'd ruin one of your edits

Or how weird their traditions are. I mean like the whole salt wife rock wife salt king rock king thing, bruh

Aegon

@Edlothiad Oh it was? Could be since the original answer doesn't exist now

@Edlothiad Oh yeah I was editing continuously so that would have been disruptive

Edlothiad

I normally reject suggested edits when I'm in my editing phase

Although nowadays I've stopped doing the stub answer and fill in later thing

Also, I don't think I have enough brain space for all these policies :(

TheLethalCarrot

I thought that was why you was writing them down?

Edlothiad

Yeah buy I'm still trying to memorise them all

It's the chinese kid in me

TheLethalCarrot

Ah fair enough

Edlothiad

2:14 PM

I can share it with you when I've written it up onto my ed google drive

29

Q: Will we ever clean up those ridiculous spoiler-free “The Force Awakens” question titles?

On one hand[1], I appreciate the intent behind trying to de-spoiler TFA questions. However, we don't have THIS deep and wide a level of hiding data for any of the older works, like the other 3 Star Wars films (Episodes 4-6) or Harry Potter. Does it mean that at some point we will have an offic...

discussion spoilers

Guess we can get round to the S7 stuff at some point.

Had to become usain bolt for a second there

amflare

@Edlothiad do tell

Edlothiad

3 minutes for the 5 minutes it takes me to pack up and get to the bus, otherwise i’d Have to stay in temp home tonight *shudders* so had to walk at lighting pace, scan out, across the building, detour for construction work and out to the bus

Heart rate was high

Aegon

2:50 PM

King and the Queen Regent must renounce all claims to dominion over the north. Henceforth we are no part of their realm, but a free and independent kingdom, as of old.-ACOK Catelyn I

amflare

Popcorn worthy?

Aegon

@amflare Assuming they don't take their declaration back before you make the popcorn

Edlothiad

3:06 PM

The only support they’ll get is “Taiwan”

Nice quote though

TheLethalCarrot

3:29 PM

This is going to take a while sorting all the transcripts properly

amflare

??

TheLethalCarrot

For gameofsearches

I'm putting all the transcripts into a common format so it will take a while

Then some are missing who's actually saying what so I'll need to do that at some point

amflare

3:50 PM

Oh fun

data formating is the best

are you doing it all by hand?

Edlothiad

4:09 PM

Of course he is

I still have to send that email about the books shucks

Edlothiad

9:22 PM

@TheLethalCarrot when you come back Monday you're not going to believe this.

19 silvers below bronze

amflare

@Edlothiad how is that even possible. Bronze is so easy to get that its basically impossible to catch up.

Edlothiad

Not if you're god level

Ah you're 35 Silver to 71 bronze, not a chance there matey

I've always been within 30

(The trick is to be the first answer and hit the HNQ)

amflare

I guess the trick is to make sure every "level up" is gotten, then get as few bronze with no level ups, and as many silver with no bronze pre-req

Edlothiad

que?

Nah you just need to hit the HNQ as often as possible

It's basically 3 silver to a bronze if you get 40 upvotes and an accept

which isn't too hard

amflare

brb, gonna go answer some HP

Edlothiad

9:27 PM

After a while you need to either be really quick with answers OR just get NEcromancer

Answer 60 days after with score of 5 or more

get score of 5 but < 10 and you're set

amflare

what happens at 10?

Edlothiad

You get a bronze :(

amflare

you get a silver at 5 and a bronze at 10?

Edlothiad

If it's older thn 60 days, you get a silver at 5

amflare

oooo

necro

Edlothiad

9:30 PM

scifi.stackexchange.com/help/badges/44/necromancer

amflare

but not "nice answer"

Edlothiad

No

That's still 25

if you hit Nice answer 60 days post. DAMN SON

although it is possible

(The greatest answer of all times)

amflare

lol that answer

if you email the author then you deserve the rep

or rather

get the author to write back

Edlothiad

Hmm email the author you say

6

A: Why does Kullervo have this name?

Who better to quote than Julia Golding herself. In short, it was from the Kalevala but "set loose to take new form". For her characters she borrowed creatures from all mythologies and has tried to re-envision them into her universe. Golding's Kullervo was originally a creature who could speak o...

15

A: The Martian – what happened to all the video log recordings?

Actually, as I found in this answer here, and from Valorum's answer to this question. People surrounding this book and film can be pretty responsive to emails. So I emailed Andy Weir (I hope you don't mind me blacking out my name), but this was his reply: So according to him, Mark uploads the l...

I'll be waiting for your upvotes :)

amflare

10:02 PM

You are shameless @Edlothiad. Absolutely shameless... :D

Edlothiad

Makes life easy

Transcript for

The Quill and Tankard