IRC log for #wowace on 20170929

00:18.58znfso Fisker http://store.steampowered.com/app/683900/RollerCoaster_Tycoon_Classic/
00:19.00znfhow is it?
00:23.22pompyyeah I saw that too
00:23.28pompyI still have all the discs
00:23.32pompyevery base and exp
00:29.27znfthere's an OpenRCTC2
00:36.07GnarfozI should get that
00:36.14Gnarfozalso, yeah, enclosed fixture
00:36.32Gnarfozbe ready to replace those bulbs sooner than you think, possibly
00:37.25Gnarfozaww, OpenRCT2 requires rct2 (which I don't have here...)
00:38.40znfI just downloaded :D
00:38.52znfand I'm lazy to move off my couch
00:38.59znfso I installed wine on macos
00:48.18znfOpenRCT2 works on macos
01:17.26*** join/#wowace Myrroddin (~psvan@S010600fc8df0e0b3.ed.shawcable.net)
01:22.29*** join/#wowace Bluspacecow (~Bluspacec@121.99.98.200)
01:25.19Myrroddinmoo
01:31.44quiescensmoo
01:35.49Torhalcombines Myrroddin and quiescens to form Moo Moo.
01:36.30Myrroddin:eek
01:49.18znfany mac terminal geek knows how can I make locale output all UTF-8 everywhere?
01:49.29znflooks at Torhal
01:50.13Torhalo.O
01:51.04znfweren't you a macos user?
01:57.44znfconfiguring vim to work properly on macos is harder than it seems :-/
02:00.23TorhalI use a Mac, yes, but I don't use vim nor know about what you're wanting.
02:04.43sylvanaarTorhal is an emacs guy anyways, right?
02:07.53znfTorhal: https://hastebin.com/luwuzizite.makefile
02:08.23znfwithout manually editing my ~/.profile, is there no mac wizardry that sets the top shit to the bottom shit?
02:10.52Torhalsylvanaar: Haven't used Emacs in years, but yeah - I was.
02:11.08Torhalznf: No idea. :/
02:11.38znfnormally I have vim's lightline installed and working under my linux box
02:11.48znflightline is a clone of powerline
02:11.57znfpowerline uses some fonts with some extra glyphs
02:12.30sylvanaarsounds fancy
02:12.31znfif the terminal doesn't support it, it normally defaults to simpler display
02:15.46znfyes, it makes stuff look like this on my windows box when connecting via putty/kitty https://i.imgur.com/NcrIGOA.png
02:16.55Torhalznf: Did you ⌘-, and check Encodings?
02:17.31Myrroddinsics Achmed the dead terrorist on Torhal
02:18.02znfhow do I take a screenshot on this thing?
02:18.14Torhalznf: Command-Shift-4
02:18.49quiescenso.o
02:18.54*** join/#wowace Seerah (~umsin@2601:3c2:101:320:c0b9:229c:e7ed:560d)
02:18.56TorhalThough that isn't going to help me figure out what your problem is.
02:18.59quiescensdon't be evil
02:19.00Torhal¯\_(ツ)_/¯
02:19.20Torhalsuper-glues quiescens' cookies to Myrroddin's forehead.
02:19.42znfhttps://www.dropbox.com/s/05ej31xx1kwttck/Screenshot%202017-09-29%2005.19.05.png?dl=0 - so when I connect with iTerm to the same box I was on earlier, you can see that it put itself into "reduced" functionality mode
02:19.53znfno pretty gradients and other shit
02:19.56znfthat's fine, works for me
02:20.34znfhttps://www.dropbox.com/s/tumrd5mjdbc52of/Screenshot%202017-09-29%2005.20.20.png?dl=0
02:20.46TorhalYou're fucked, znf. https://www.dropbox.com/s/x6brpd747gu4wma/Screenshot%202017-09-28%2021.20.32.png?dl=0
02:20.47znfbut when using vim locally... you can see there's an issue :D
02:20.56TorhalI also don't use iTerm.
02:21.11znfah, god damn piece of shit dropbox son of a bitch cocksucker shit service
02:21.36TorhalI've actually never seen that message before, so I have no idea WTF you're using DropBox to do but it's apparently bad. :D
02:21.46sylvanaarlol
02:22.11znfI've no idea either, it's been that way for over a year
02:22.32sylvanaarmake a new account
02:22.34znfand yes, I removed all my public files
02:22.38znfnot worth the trouble
02:22.55znfgod, nobody fucking made a ShareX alternative on this OS
02:22.59znfnothing so versatile
02:24.05znfhttps://i.imgur.com/qNzDOap.png
02:24.11znfhttps://i.imgur.com/iT3wE53.png
02:29.23znf...now I'm actually wondering why I don't get the fancy font-stuff via ssh, either
02:49.57znf<PROTECTED>
02:50.01znftesting, don't mind me
03:04.00quiescenso.o
03:18.18*** part/#wowace Seerah (~umsin@2601:3c2:101:320:c0b9:229c:e7ed:560d)
03:27.25znfoh... ok, I fixed my font issue
03:27.33znfapparently the font I was trying to use wasn't patched properly
04:34.58*** join/#wowace ShadniX (dagger@p4FF9F430.dip0.t-ipconnect.de)
04:58.28*** join/#wowace bluspacecow (ca312209@gateway/web/cgi-irc/kiwiirc.com/ip.202.49.34.9)
06:15.58*** join/#wowace Myrroddin (~psvan@S010600fc8df0e0b3.ed.shawcable.net)
06:20.10*** join/#wowace mitch0 (~mitch@84-236-72-110.pool.digikabel.hu)
07:05.23*** join/#wowace pompy (~Mike@c-73-194-183-217.hsd1.nj.comcast.net)
07:23.30*** join/#wowace Semlar (~chatzilla@50-89-60-19.res.bhn.net)
09:38.04*** join/#wowace stolenlegacy (~stolenleg@213-47-49-27.cable.dynamic.surfer.at)
09:38.08*** join/#wowace stolenlegacy (~stolenleg@unaffiliated/stolenlegacy)
09:45.10*** join/#wowace [1]Archarodim (~Archarodi@lev92-3-78-203-110-56.fbx.proxad.net)
09:46.33FiskerWtf Stanzilla got dog food play music
09:53.14Fiskerhttps://photos.app.goo.gl/3yaaoYNCPH581NU92
10:04.47*** join/#wowace Ackis (~Ackis@WoWUIDev/WoWAce/ARL/Troll/Ackis)
10:04.47*** mode/#wowace [+o Ackis] by ChanServ
10:06.19Gnarfozno, that's music for pets, clearly
10:08.54Phixionyo dawg, we heard you like music
10:16.51Gnarfozruff
11:33.55*** join/#wowace Bluspacecow (~Bluspacec@121.99.98.200)
11:48.43GnarfozHmm, did work Internet start dying, or did wow
11:49.08GnarfozWorld shards don't like me anymore
11:51.29Bluspacecowno they hate you now
11:51.37nebulaGnarfoz: the casing is definitely different, no idea about the internals
11:51.41Bluspacecownot enough swedish fish sacafices
11:52.34quiescensgives blu a cookie
11:54.28Bluspacecow*noms*
12:07.18Gnarfoznebula: A119S on the way now, anyway B-)
12:14.06*** join/#wowace Megalon (~wig0r@212-60-172-46.adsl.highway.telekom.at)
12:18.12Fiskerholy shit
12:18.13Fiskerhttps://www.youtube.com/watch?v=Ksegw928gUM&feature=youtu.be&t=21m07s
12:27.53*** join/#wowace Bluspacecow (~Bluspacec@121.99.98.200)
14:09.02Gnarfoz6 years of LTS? neat
14:09.16Gnarfozhow long until first phone with Project Treble, tho?
14:09.30Gnarfozwasn't that supposed to be part of every phone launched with 8.0?
14:46.31Gnarfozlol at the beginning "we weren't collecting kernel stats before now... that's pretty sad" ^^
16:33.42*** join/#wowace Justwait (~Justwait@546B1128.cm-12-4a.dynamic.ziggo.nl)
16:35.01FiskerPixel is already the first phone Gnarfoz
16:35.25FiskerAnd also I guess all 835 snapdragons
16:35.36FiskerIn theory
16:36.18FiskerPixel doesn't run 4.4 though
16:36.58*** join/#wowace Justwait_ (~Justwait@546B1128.cm-12-4a.dynamic.ziggo.nl)
16:44.18*** join/#wowace Justwait (~Justwait@546B1128.cm-12-4a.dynamic.ziggo.nl)
17:20.24StanzillaI managed to drop my 10kg laptop on my back
17:20.27Stanzillathat's a first
17:22.10*** join/#wowace EthanCentaurai (~EthanCent@79-76-214-227.dynamic.dsl.as9105.com)
17:29.01quiescenshow do you drop something onto your own back?
17:29.13quiescens/pat Stanzilla
17:30.01StanzillaI have a drawer and put the notebook on the top shelf, then I bowed down to get somethign from the bottom shelf and it slid out of top shelf and landed on my back
17:31.19quiescens):
17:41.38*** join/#wowace Seerah (~umsin@2601:3c2:101:320:64f9:56d6:4219:6d7f)
17:48.09GnarfozFisker: Pixel 1?
17:48.39Gnarfozpixel 2 isn't out yet, is it
17:48.53Gnarfozso... the Xperia XZ1 is the first one to ship Treble, then? oO
17:49.15StanzillaPixel 1 is treble but not 4.4
17:49.24Stanzillaall new treble devices have 4.4 as mandatory though
17:49.25Fisker^^
17:49.32GnarfozI'm confused
17:49.36Gnarfoz4.4 is very old
17:49.36FiskerAnd note 8 is 4.4 but not Treble yet
17:49.40FiskerBut probably will be
17:50.03Gnarfozoh, Linux 4.4
17:50.05GnarfozI see
17:50.08Stanzillayes
17:50.37Funkeh`I wonder why they didn't update pixel/nexus
17:50.38Stanzillavendors CAN port their existing devices to treble if they want
17:50.39Gnarfozpretty sure you can still build a non-treble device with that, so I don't have hopes for devices not advertising this
17:50.48Stanzillabut every device that  wants to ship with 8.0 has to be treble
17:51.02Gnarfozat least they enforced that
17:51.05Stanzillayes
17:51.34Gnarfozshame the current Xperia design is fugly, but they promised a new design for the next iteration
17:51.36Gnarfozyay? ;p
17:51.54Stanzillawhy do you want to change from samsung?
17:52.01FiskerDepends on the device Stanzilla
17:52.03GnarfozI don't?
17:52.04Gnarfoz:D
17:52.07Stanzillaok
17:52.07Gnarfozjust observing
17:52.20StanzillaFisker: ok, every phone
17:52.28Gnarfozit's not like I buy a Samsung because I want a Samsung
17:52.34FiskerNo Stanzilla
17:52.38FiskerDepends on the phone
17:52.41GnarfozI buy whatever fulfills my spec wishlist
17:52.48Stanzillayou cannot ship a 8.0 phone without treble
17:52.54Gnarfoznot without Google hating you
17:52.55Gnarfoz:D
17:53.02Stanzillayou dont get certified then
17:53.20FiskerI am talking about porting treble
17:53.23GnarfozI don't think Chongweng Technology Corp, HK cares
17:53.28Gnarfoz:D
17:53.31Stanzillawhat do you mean
17:53.41StanzillaGnarfoz: sure but if you want play services you need the cert
17:53.52Gnarfozwell, many 3rd world Android phones ship without them
17:53.57FiskerTreble requires soc support
17:53.57Stanzillaporting a phone to treble can be done if the vendor wants to
17:54.05FiskerQualcomm only did it for like 820
17:54.10Stanzillashrug
17:54.17Stanzillanot like any vendor is going to do it for older phones anyway
17:54.18GnarfozI doubt there's hardware requirements
17:54.20Stanzillatoo much effort
17:54.30Stanzillathere is, drivers/firmware
17:54.31FiskerI am so happy to be without internet
17:54.32Gnarfozthey'd just need to fix up all the middleware for each soc
17:54.41Gnarfoz"drivers/firmware" is both not hardware?
17:54.42Gnarfoz:p
17:54.48Stanzillaok fuck you
17:55.00Gnarfozjust questioning "hardware support required"
17:55.05Gnarfozthat doesn't seem to make much sense
17:55.21Fisker?
17:55.23Stanzillahardware vendor support
17:55.25Stanzillabetter?
17:55.29Gnarfozthat works, I guess
17:55.34Gnarfozthey're not going to do that, of course, because $$$
17:55.36Gnarfozor rather, lack of $$$
17:55.50Stanzillayea
17:56.08FiskerTreble reduces costs
17:56.16Gnarfozwatch phone maker profits crumble when people can update their device that shipped with 8.0 to 12.0
17:56.45Gnarfozmaybe they'll find things to innovate again?
17:56.50Gnarfoz:O
17:57.03FiskerI'm not sure that people who update every year because new Android versions
17:57.11Gnarfozof course not
17:57.21Gnarfozjust saying, it'll cut into their baseline for sure
17:57.41Gnarfozprobably not bankrupcty levels
17:57.50FiskerI'm thinking the savings will be more than the loss
17:58.39Gnarfozwhat savings would that be? firing all the superfluous devs who cobble together their oh so awesome Android UIs/forks?
17:59.19Stanzillayes
17:59.25Gnarfozprobably unrealistic, but maybe they'll stop releasing a new phone every 10-14 months because they can just update the software on existing ones for longer...
17:59.26Stanzillakeeping their forks up to date is pretty tedious
17:59.32Gnarfozthat'd save on development time for sure
17:59.37Gnarfozwell, but they don't
17:59.45Gnarfozisn't that the whole issue?
17:59.50Gnarfozthey barely keep shit up to date as it is
18:00.04Stanzillanot releasing it does not mean the dont keep it up to date
18:00.05Gnarfozif there's still much room left for savings there... I guess they're just making too much money :D
18:00.12Stanzillathey still have to rebase everythign for every new phone they make
18:00.18Stanzillaso it is an ongoing effort
18:00.27Stanzillathey just dont ship updated builds for older phones
18:00.31Gnarfozthey can also just cut shit not relevant for $newphone
18:00.38Gnarfozwhich should balance that
18:00.43StanzillaI dont think so
18:00.50GnarfozI doubt Samsung has a 7.0 that works on the S4, for example
18:00.58Gnarfozand by works I mean 100% features
18:01.08Gnarfoz(or even a 6.0)
18:01.23Stanzillathat does not matter, they core fork is the same for every phone
18:01.27Gnarfozmaybe they get a 90% version incidentally
18:01.29Stanzillaphones are just branches
18:01.29nevcairielI would think that if some (major) vendors start doing proper update cycles based on this, while others dont, those that don't may see a dip in sales as people may choose one that has it
18:01.51Gnarfozif it was that clean, they wouldn't be so slow, would they
18:01.54FiskerYeah definitely
18:02.05Stanzillanothing I said says clean
18:02.11nevcairieland yeah i think Stanzilla has a too simple image of  this in his head =p
18:02.12Stanzillathey just have their modications they do on every phone
18:02.14Gnarfozanyway, Treble best thing to happen to Android since Android
18:02.15Stanzillaso that is the same always
18:02.19Stanzillano i dont, nevcairiel
18:02.27FiskerIt's slow because every time there's a new version of android they can't just merge from upstream
18:02.29nevcairielexcept it isnt, their "forks" vary quite a lot between phones
18:02.35Stanzillayes
18:02.39nevcairielie. samsung has been revamping their ui for the last couple phones entirely
18:02.41FiskerI doubt their internal source tree is that messy
18:02.47Stanzillaand they still have their base modifications that they ALWAYS have to merge stuff into
18:02.50Stanzillaand that takes time and work
18:03.17Gnarfozif they have a base set, wouldn't that mean they only have to do that once per Android release
18:03.23Gnarfozthey can't be that incompetent
18:03.27Gnarfozwell... they can
18:03.30Gnarfoznever mind
18:03.30Stanzillaand now with treble they cant do that anymore, either they get their improvements/modifications into AOSP proper or they cant ship it
18:03.31Gnarfoz:D
18:03.33FiskerBasically before Treble there weren't clear lines where stuff began and ended
18:03.45Stanzilla^
18:03.48FiskerSo you usually had OEMs with code all over the place
18:03.53FiskerAnd this was necessary
18:03.53GnarfozI liked the FUFUFUFUFUFUF rage graphic in that russian's talk
18:04.15Gnarfozeven AOSP's own code was like this (and maybe worse than some OEMs' code)
18:04.23Stanzillawith treble, updating android is really just git pull
18:04.52Fisker^^
18:04.58Gnarfozunless, of course, that updates the version of the interface/abi/api your custom stuff uses and it's now incompatible!
18:04.59Gnarfoz:P
18:05.15Stanzillayeah well you are guaranteed abi compatability for a bigger range of versions
18:05.17Gnarfozbut at least it'll be structured
18:05.26Stanzillaalso cant spell for shit on this keyboard
18:05.29Gnarfozgotta start somewhere
18:05.33Stanzillayes
18:06.02Gnarfozaaanyway
18:06.05Stanzillado Dell XPS13 and Asus Zenbooks have Coffee Lake versions yet? i didnt pay attention
18:06.07GnarfozXZ1 compact
18:06.13Gnarfozwhy must it be ugly
18:06.15Gnarfoz:D
18:06.24Stanzillawhy do you want one, specs?
18:06.27Gnarfozhoping they keep doing compact versions in their next gen
18:06.31Gnarfozwidth
18:06.45Stanzillahow much of a difference is it compared to other phones
18:06.46Gnarfozwell, maybe not necessarily me, I can deal with the 5" Samsung does, ~70mm width
18:06.55Gnarfozbut my mom certainly doesn't want a 5" phone
18:07.00nevcairieltechnically, there are no coffee lake laptop chips
18:07.08Gnarfozand there's literally nothing below 5" otherwise that's not old
18:07.09Stanzillaok what are they technically called
18:07.14nevcairielkaby lake refresh
18:07.28Stanzillado Dell XPS13 and Asus Zenbooks have kaby Lake refresh versions yet? i didnt pay attention
18:07.47FiskerFucking hate that I have to wait 14 hours to call someone telling them my modem probably fried again
18:07.49nevcairielnot sure if they are out yet, but they were announced for this month or so
18:08.39Stanzillaok
18:08.42nevcairieldell.com lists them at least
18:08.45Stanzillathx
18:08.52nevcairiellook for 8000-series cpus obviously
18:09.14Gnarfozhmm... XZ1 compact is actually just 5mm less wide than my S7, but 12mm shorter... well it's 4.6" compared to 5.1"
18:09.14Stanzillayeah
18:09.21StanzillaI really like the design of the zenbooks :E
18:09.30GnarfozS7 was already one of the smallest (ex-)flagships anyway
18:09.39nevcairieli got a kaby zenbook last year, pretty happy with it
18:09.54Stanzillawhich one exactly
18:10.04Gnarfozif Sony's next design maybe has better screen/body ratio and keeps the screen size, the resulting device might be noticeably smaller
18:10.31Gnarfozjust rambling, tho. stop feeding Fruchtzwerge to phones!
18:11.03nevcairielAsus Zenbook UX510UW, its the 15.6" model, not the 13.3
18:12.11Gnarfozhnnng
18:12.22GnarfozOrville E04 only 720p HDTV
18:13.00nevcairieli see web-dls
18:13.17FiskerI once killed a webdl
18:13.22FiskerI guess I could watch TV
18:13.53FiskerOoooh
18:13.57FiskerDesignated survivor
18:14.10Gnarfozah, did that return? good
18:14.27Gnarfoznevcairiel: :| guess I'll just wait, then
18:15.26Stanzillahrm 15.6
18:15.52quiescensmoo?
18:15.54nevcairielI needed it mostly when working on business trips to america, so i wanted the bigger one
18:16.03nevcairielthe 13.3 is just fine otherwise
18:16.43FiskerPixelbook
18:16.48quiescens15 too big for laptops
18:16.51quiescensnodnod
18:17.46Stanzillawhy the fuck is the non touchscreen xps not available with 4k
18:17.56quiescenso.o
18:18.23Gnarfozbecause they must somehow communicate to you that your choices are wrong
18:18.30Gnarfozhow dare you not want touch
18:19.01nevcairielits an entirely different display unit for the non-touch, so differences there are expected
18:19.13nevcairielalso 4k on a 13.3" is really quite over the top
18:19.33FiskerI think it's okay
18:19.35Gnarfozgotta get rid of that retina kool-aid somehow
18:19.41Stanzillaim scared that the pixel density would be shit
18:19.46Stanzillawith 1080p
18:19.57nevcairiel1080p on 13.3" is plenty
18:20.05nevcairieldont get fooled by phone marketing
18:20.16Gnarfoz1080p at 100% is almost too tiny for 14" imo
18:20.19Stanzillaalso I cant select more than 8gb of ram
18:20.21StanzillaB Y  E
18:20.28Gnarfozinb4 ram soldered onto board
18:20.30Gnarfoz:D
18:20.48nevcairielunfortunately thats actually a thing
18:21.00nevcairielespecially in those ultrabooks, which do everything to save height
18:21.59Stanzillaand the xps 15s are not out yet with 8th gen
18:22.01Stanzillaok dell
18:22.03Stanzillayou lost me
18:22.31Stanzillanow I'll probably see that zenbooks dont ship with 8gen either and just not buy a notebook again
18:23.24Gnarfozwhat's your address? I'll order you a https://www.amazon.de/dp/B01AY2YTKA/ ;p
18:24.16nevcairielhttps://www.asus.com/Laptops/ASUS-ZenBook-13-UX331UN/
18:24.18nevcairielnot sure if ships
18:24.31StanzillaI am still waiting for the amazon link to load
18:24.44Stanzillaok nice Gnarfoz
18:24.49Stanzillabut I already have one from that generation
18:24.52Stanzillano upgrade needed
18:25.08nevcairielthe UX331 doesnt appear to ship yet, not in germany anyway
18:25.15Stanzilla:(
18:25.24Stanzillazenbook vs zb pro is just graphics unit, yeah?
18:28.13Stanzillaok I got disconnected, if you answerd I didnt get it
18:28.17Stanzillaalso the deluxe looks hot
18:29.28Gnarfoznice, 2 weeks until Mr. Robot
18:30.10Stanzillaew, deluxe has glare panel
18:34.09Stanzillaok, keeping the 9year old notebook it is then
18:34.23Stanzillaheaven forbid I buy somethign that has not the latest gen of something!
18:41.16znfbuy a macbook :D
18:42.12StanzillaI would but also not 8th gen and also not worth 2,8k
18:44.18znfStanzilla, get a 2nd hand one *shrug*
18:44.28znfI'm actually impressed how good this 2011 one works
18:44.37znfsure, I'm not gonna play any games on it any time soon
18:52.49Gnarfozget the anniversary edition thinkpad
18:53.10Gnarfozactually has a real keyboard again, even including the blue enter key
18:53.26Gnarfoz(no idea about actual specs.)
19:08.17Funkeh`wtf is this, discord-in-battle.net
19:08.45znfERR_NAME_NOT_RESOLVED
19:08.46znf?
19:09.11GnarfozI think he meant the clubs feature
19:09.14Gnarfozor whatever it's name is
19:09.42znfis there an update I haven't received?
19:09.51Gnarfoznot sure if it's out
19:10.15Gnarfozaww nice, a new Blu-Ray of eXistenZ
19:10.21Gnarfozwith actual image in it!
19:10.35Gnarfoznot just mushy pixel soup
19:10.49znfhow's your sql-fu, Gnarfoz?
19:10.55Gnarfozterrible, mostly
19:11.00Megalonomg, he broke something
19:11.04Megalonand needs someone else to fix it
19:11.12MegalonDROP TABLE *;
19:11.13Megalonand run
19:11.17znfnah, I need help with some sql stuff, I'm failing to grasp the logic
19:11.33Megalondo as everyone does, just ask and hope for the best :p
19:11.34Gnarfozpaste it somewhere and let us enjoy the ride
19:11.35Gnarfoz;D
19:11.39znfI'm trying to:
19:12.47znfupdate zs_comments set comment_approved='trash' where comment_approved='0' and [...count everyone's comments on the website based on comment_author_email, if they have less than 20 with comment_approved='1']
19:13.27znfprobably going around it the wrong way
19:13.48Megalonso you just do a select count blub thing
19:13.53Megalonor am i missing something here :D
19:14.00znfkind of, yes
19:14.12Gnarfozsounds about right
19:15.27Megalonwell you could do a left join with the select count from blub group gy comment_author_email
19:15.29znfI'm faling on comparing the values :P
19:15.35znfI never understood how joins work
19:15.52znfhttp://sqlfiddle.com/#!9/233673/3
19:15.54Megalonthey are quite easy ones you get them :P
19:16.46znfso far I have
19:16.46znfselect comment_author_email, count(*) from (select * from zs_comments where comment_approved='1') as zs_comments group by comment_author_email;
19:16.47Megalonleft join is the thing on the left get values from the thing on the right
19:16.55znfand select comment_ID, comment_author_email from zs_comments where comment_approved='0' and comment_post_ID='73294';
19:16.55znf:D
19:17.08Megalonso you ever line of the left table/statement shows up once, basically
19:19.10Megalonyou can combine group by and where things in a single statement
19:19.40MegalonSELECT comment_author_email, COUNT(*) FROM as zs_comments WHERE comment_approved='1' GROUP BY comment_author_email;
19:19.51Megalonshould give you the number of approved accounts for everyone
19:20.19znfI figured that part out
19:20.55Megalonand now you need to find everyone that posted on a comment that hast > 20 approved ones?
19:21.03Megalonor article or whatever
19:21.19znfless than 20
19:21.37znfputing those things together is the hard part for me
19:22.14Megalonselect comment_ID, comment_author_email from zs_comments where comment_approved='0' and comment_post_ID='73294';
19:22.28Gnarfozupdate Table1 set comment_approved='trash' where comment_approved='0' and comment_author_email in (select comment_author_email, count(1) from Table1 where comment_approved='1' group by comment_author_email having count(1) < 20);
19:22.30Megalonyou want the count of commant_approved attached to here?
19:22.31Gnarfozmaybe?
19:22.45Gnarfozsqlfiddle won't let me even try DML here
19:23.05Gnarfozand if it's mysql, I have no idea if this works at all. :P
19:23.16znfmariadb, basically same thing
19:23.20Gnarfozsame thing, yeah
19:23.32GnarfozI'm used to Oracle dialect
19:23.50Gnarfozahh
19:24.07GnarfozI have that weird "move a divider up/down" cursor in Quassel again
19:24.10Gnarfozhow do I get rid of that >_>
19:24.55*** join/#wowace stolenlegacy (~stolenleg@213-47-49-27.cable.dynamic.surfer.at)
19:24.55*** join/#wowace stolenlegacy (~stolenleg@unaffiliated/stolenlegacy)
19:25.02Megalonwhat *foz posted seems about right
19:25.13Megalonjust run the statements are selects and see what it would update
19:25.22Gnarfoz^
19:25.30Megalonor just run them, like real men do h3h3
19:25.43Megalon(real men who don't need no job that is)
19:25.48znfGnarfoz's gives me:
19:25.48znfERROR 1241 (21000): Operand should contain 1 column(s)
19:25.56Megalonoh
19:26.01GnarfozI guess that's a valid complaint
19:26.13Gnarfozyou'd have to nest it once more to remove the count(1) column
19:27.54Gnarfoz(so, add a "select comment_author_email from (subquery goes here)")
19:30.14*** join/#wowace Semlar (~chatzilla@50-89-60-19.res.bhn.net)
19:30.17znfMariaDB [zoso]> select * from zs_comments where comment_approved='0' and comment_author_email in (select comment_author_email from (select comment_author_email, count(*) from zs_comments where comment_approved='
19:30.17znf1' group by comment_author_email having count(*) > 20));                                                                                                                                                          
19:30.18znfERROR 1248 (42000): Every derived table must have its own alias                                                                                                                                                    
19:30.19znfwat
19:30.30GnarfozoO
19:30.35Megalontable xxxxxxxxx as y
19:30.36Gnarfozwell, give names to them, I guess
19:31.25Megalonbecaouse you acting on the same table twice
19:31.28Gnarfoztrue dat
19:31.44Megalonso it doesn't know when to use the column of which instance
19:32.53znfselect comment_ID from zs_comments where comment_approved='0' and comment_author_email in (select comment_author_email from (select comment_author_email, count(*) from zs_comments where comment_approved='1' group by comment_author_email having count(*) > 20) as zs_comments);
19:33.23GnarfozI'd be surprised if that worked
19:33.28Gnarfozthey need to be unique names
19:33.29znf135 rows in set (0.00 sec)
19:33.39Gnarfozreally? what. ok
19:34.09Gnarfoz(I'd just have used a, b, c, d etc)
19:36.15Megalondoes the thing in brackets return a list of emails?
19:36.33Megalonoh it worked anyway
19:39.43Megalondo you really need to do in ( select from (select ...) )?
19:40.15Megaloncan't you just use COUNT only in the having clause and only select emails in the first palce?
19:41.10Megalonwasn't that was HAVING is for, because it's a SELECT * WHERE x wrapped around a aggregate SELECT?
19:41.41Gnarfozhaving is only for use with group by
19:41.57Megaloni know
19:42.04Kalrothmultiple subselects, way to trash the poor sequel server
19:42.17Gnarfozactually? no.
19:42.30Gnarfozmaybe the one where that is the product name ;-)
19:42.42Megalonbut znf has SELECT email from (SELECT email, count(*) ... having count < 20)
19:42.45Gnarfozand I don't think group by works when you do select just-one-column from blah group by just-one-column
19:42.54Megalonisn't just "SELECT email, count(*) ... having count < 20" enough anyway?
19:43.05Gnarfozsee above
19:43.20Gnarfozwhere column in (list) requires that (list) be single column
19:43.50znfdoesn't matter, shit worked
19:43.55Gnarfozno idea if my terrible solution is possible with just one subselect level :D
19:43.55Megalonyou can just as fine do SELECT email from x group by email
19:44.03Megalonjust gives you a list of all the emails :P
19:44.30Gnarfozyeah, but can you do having field-you-didnt-select < 20, then?
19:44.53GnarfozI hate even thinking about aggregate functions in sql :P
19:45.35Gnarfozseeing Business Objects' SQL generator's output daily has scarred me
19:46.12Megalonselect emails from histable group by email where count(*) < 20
19:46.23Gnarfozthat doesn't work for sure
19:46.26Megalonyou don't actually need the count
19:46.33Megaloncount(email)
19:46.41znfOfc I could have done this manually by the time it took me to figure out the SQL way
19:46.46Gnarfoz?
19:46.49znfBut where's the fun in that?
19:46.53Gnarfozcan you make that a working statement Megalon, I don't follow
19:47.12Gnarfozgroup by X where Y is invalid syntax
19:47.29Megalonhaving
19:47.30Megaloni meant
19:47.37Gnarfozwell, does that work?
19:47.44Megalonwhy shouldn't it
19:47.59Megalonhaving is made for exactly that, so you don't have to select the count and wrap another select around it
19:48.38Gnarfozlike I said, I'm not sure, and I seem to recall always having to make sure I mention all non-aggregate columns in the group by clause... maybe that doesn't mean there's a vice-versa requirement
19:49.47GnarfozI realize why that sqlfiddle doesn't work btw
19:49.54Gnarfozthat's not actual DDL on the left xD
19:50.06Gnarfozit's... stuff that inserts DDL into a table
19:50.09Gnarfozfor no reason I can think of
19:51.06Megalonno reason is often the best reason
19:51.46Gnarfozit is known.
20:09.22znfHoly shit
20:09.33znfMy "REST" button works in the car
20:09.35znfWTF :o
20:10.12Megalonwtf is a rest button in a car
20:21.31*** join/#wowace jlam (~jlam@pool-96-240-20-100.nwrknj.fios.verizon.net)
20:40.59znfMegalon, uses residual heat from the engine to warm up the cabin when the engine is not in use
20:41.12znfturn engine off, press REST button, enjoy head
20:41.14znfheat*
20:48.55znfoh, I failed to account something in the query
21:12.45*** join/#wowace Pernille__ (~Pernille@55.92-220-69.customer.lyse.net)
21:45.18Megalonoh
21:45.23Megalonrestwärmeheizung
21:49.50EthanCentaurai>canihaveahug
21:50.15*** join/#wowace Seerah (~umsin@2601:3c2:101:320:64f9:56d6:4219:6d7f)
21:54.12*** join/#wowace starfox (~wig0r@193-81-183-4.adsl.highway.telekom.at)
22:13.06EthanCentauraiznf your bot needs a hugme command
22:27.20znfWrite it :P
22:27.25znfIt's Python
22:39.46Megalonon hugmey say gofuckyourself
22:39.47Megalondone
22:40.15EthanCentauraiwow
22:40.28EthanCentaurairude
22:55.06pompy~rude
22:55.06purlrumour has it, rude is making me tell people things that they dont want to be told
23:55.28*** join/#wowace Ressy (~Ressy@CPEa84e3f42f293-CMa84e3f42f290.cpe.net.cable.rogers.com)
23:55.29*** join/#wowace Ressy (~Ressy@WoWUIDev/WoWAce/ARL/Ressy)

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.