IRC log for #uphpu on 20100702

00:00.15beandoghttp://www.dvdactive.com/editorial/articles/star-wars-the-changes-part-two.html
00:00.17beandogthat's a bit intense'
00:01.04beandog^^
00:01.05beandoglinkie
00:01.19DexterTheDragonlooking
00:03.49beandoghttp://www.designsdelight.com/wp-content/uploads/2008/11/posters-loaded-women.jpg
00:04.27beandoghttp://www.designsdelight.com/wp-content/uploads/2008/11/poster-car-shating.jpg
00:04.30beandoglol, oh *wow*
00:07.32DexterTheDragonbeandog: the things that drive me nuts are the audio changes
00:07.43beandogDexterTheDragon, what audio changes
00:07.56beandoghttp://www.threewordphrase.com/manywonders01.htm
00:07.58beandogLOL awesome!
00:07.59DexterTheDragonin empire strikes back
00:08.26mindjuju_han shot first!
00:08.34mindjuju_just sayin'
00:08.39DexterTheDragonthats right
00:08.43beandogoh boy
00:08.47beandogweirdos :)
00:08.55mindjuju_he did!
00:08.55beandogDexterTheDragon, I dont like the new CGI replacement backgrounds
00:08.57beandogthose are distracting
00:09.11DexterTheDragonbeandog: I love propaganda posters
00:09.22mindjuju_he wasn't no wimpy wuss going to let that guido jaba guy get him
00:09.29mindjuju_he put him down first and quicly
00:10.14*** join/#uphpu blendmaster1024 (~blendmast@unaffiliated/blendmaster1024)
00:10.50DexterTheDragonI also really hate that they put Hayden Christensen at the end of Return of the Jedi
00:10.55*** join/#uphpu ender|h (~ender@c-98-202-87-28.hsd1.ut.comcast.net)
00:10.59beandogYah, lame.
00:11.24mindjuju_especially since they didn't change obi won and yoda to go with it
00:11.39mindjuju_i guess only anakin knew how to give himself a force face lift
00:11.53*** join/#uphpu jamund (~jamund@173-8-91-177-Utah.hfc.comcastbusiness.net)
00:11.53*** join/#uphpu cedwards (~christer@unaffiliated/zelut)
00:11.53*** join/#uphpu cycokilr (~cycokilr@216.112.116.6)
00:12.06mindjuju_the one good thing about the new ones is that they got rid of that jub jub song
00:12.06mindjuju_i cringe just thinking about that darn song
00:12.18mindjuju_jub jub song = mindjujuBane
00:12.30beandoglol
00:12.39beandogyou guys are crazy
00:12.45beandogalthough
00:12.49DexterTheDragonwell they're justification for it is the force ghosts are when they were light sided
00:12.49mindjuju_did you like the jub jub ?
00:12.56beandogNow that I think about it, if someone re-edited TRON, Id probably be pretty pissed.
00:13.39DexterTheDragonbeandog: and I hate the crap laserdisc transfer they did for the "original release" dvds
00:13.51beandogDexterTheDragon, They are letterbox!
00:13.53beandogaaaaaaaaaaaaaaaaaaaaaaaaaaaagh
00:13.55beandogTHAT SUCKS
00:14.14beandog:)
00:14.18beandogI'm a bit bothered by that.
00:15.21beandogI wonder what quality they are
00:15.25beandogI know they are analog transfers
00:15.31beandogSo it should be pretty spanky
00:16.22beandogactually what I really want is a 35mm film projetor.
00:16.27beandog*that* would be awesome.
00:16.34beandogMan
00:16.40beandogI wish I would have kept all those 35mm trailers I had
00:16.43beandogFreak.
00:16.45beandogI had a TON of them
00:16.53beandogI think I sold em all on ebay.
00:17.17beandogSee, back in the day, the studios didn't care what happened to them
00:17.21beandogneither did the theaters
00:17.32beandogSo we would have these cabinets that were just FILLED with trailers that were years old.
00:17.44beandogIts pretty much the same thing with movie posters.
00:17.45mindjuju_wow
00:17.49mindjuju_wthat would be awesome
00:17.50beandogThe employees get to keep em if they want.
00:18.07beandogThats how I got a lot of my original posters
00:18.20beandogwell, back then.  I dont really have too many now.
00:18.33beandoglots of t-shirts, too
00:18.41beandogI remember I had something like 3 Small Soldiers t-shirts.
00:18.48beandogFrom the studio. :)
00:18.57beandogGood times.
00:19.49beandogalright
00:19.51beandogIm going home.
00:19.57mindjuju_cya
00:20.04DexterTheDragonmindjuju_: for the record I liked the YubNub song at the end of RotJ
00:20.16mindjuju_no way
00:20.24mindjuju_more than the one they replaced it with?
00:20.50DexterTheDragonI'm fine with the new ending
00:20.56DexterTheDragonbut I liked the old one too
00:21.38mindjuju_this one, right?  http://www.youtube.com/watch?v=np6vAuS0KNs
00:21.53DexterTheDragonyeah
00:59.36*** join/#uphpu mgeary (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net)
00:59.36*** mode/#UPHPU [+v mgeary] by ChanServ
01:03.20*** join/#uphpu cro (~cro@166-70-222-105.ip.xmission.com)
01:22.49*** join/#uphpu jamund (~jamund@173-8-91-177-Utah.hfc.comcastbusiness.net)
01:22.49*** join/#uphpu cedwards (~christer@unaffiliated/zelut)
01:22.49*** join/#uphpu cycokilr (~cycokilr@216.112.116.6)
03:11.26*** join/#uphpu josephscott (~josephsco@74.200.246.169)
03:11.26*** mode/#UPHPU [+v josephscott] by ChanServ
04:29.38influxoi
04:49.08*** join/#uphpu redroy (~Adium@c-174-52-217-149.hsd1.ut.comcast.net)
13:44.38*** join/#uphpu Utah_Dave (~boucha@72-166-51-162.dia.static.qwest.net)
13:44.38*** mode/#UPHPU [+o Utah_Dave] by ChanServ
13:51.44Utah_DaveOur building power is out for 2 days. Luckily our good old diesel generator is running like a champ
14:43.12*** join/#uphpu SunSparc (~sparky@173-8-91-177-Utah.hfc.comcastbusiness.net)
14:43.12*** mode/#UPHPU [+v SunSparc] by ChanServ
14:44.33*** join/#uphpu beandog (~sdibb@gentoo/developer/beandog)
14:44.33*** mode/#UPHPU [+v beandog] by ChanServ
14:48.55beandogbuenos tacos
14:51.24*** join/#uphpu cro (~cro@166-70-222-105.ip.xmission.com)
14:55.54SunSparcbien burritos
14:58.27*** join/#uphpu ninnypants (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net)
14:58.43ninnypantsmorning all
14:59.33beandogyo
14:59.35beandogoh crap
14:59.38Utah_Davemorning.
14:59.41beandogI forgot to og yesterday ninnypants
14:59.57Utah_Dave:(  AC units aren't on the diesel generator power. It's starting to get warm in here.
15:01.23*** join/#uphpu fungus (~olsonl@bromine.sosstaffing.com)
15:01.23*** mode/#UPHPU [+o fungus] by ChanServ
15:06.57SunSparcUtah_Dave: Turn off the monitors.  That will help.  ;)
15:09.01Utah_DaveSunSparc: Turn off all 5 of my 21" monitors????  Never!   :)
15:09.23SunSparc:)
15:11.13*** join/#uphpu jtsnow_ (~chatzilla@VDSL-151-118-130-166.DNVR.QWEST.NET)
15:22.14influxweeee
15:22.19influxphp script is almost done
15:26.26*** join/#uphpu mindjuju (~mindjuju@mail.billgood.us)
15:27.50beandogbah
15:27.53beandogany bash gurus
15:27.56beandoggetopt is going over my head.
15:28.18beandogspecifically, how do you access the arguments actually passed?
15:36.28mindjujusorry, i just know a handle full of bash commands
15:37.32SunSparcbeandog: $1 $2 $3 etc
15:39.26SunSparcActually, I think it starts with $0
15:41.33SunSparcNo, it is 1.
15:42.19SunSparcbeandog: Check out this page: http://www.linuxconfig.org/Bash_scripting_Tutorial
15:44.53DexterTheDragonbeandog: http://github.com/DexterTheDragon/Link-Dot-Files/blob/master/ldf#L111-121
15:47.08fungusbeandog, getopt and getopts are very different.  IMO getopts is easier to deal with
15:52.57*** join/#uphpu josephscott (~josephsco@74.200.246.169)
15:52.58*** mode/#UPHPU [+v josephscott] by ChanServ
16:09.09influxmy
16:09.12influxs/my/pie/
16:19.19mindjujuhowdy guys, reminder :  geek lunch today : http://blog.utos.org/2010/06/29/june-2010-geek-lunch-philadelphia-here-we-come/
16:20.04mindjujuas i'm going to be working down int he UC in a couple weeks, this will prolly be my last one up here as i'll host them down there
16:20.05influxI keep thinking  you guys are flying to Philadelphia.
16:20.16mindjujuunless those guys don't show, then maybe i'll drive up
16:20.42mindjujufungus, i thin they have veggie stuff
16:20.58mindjujubutg i don't remember for sure
16:24.58herlow00t! geek lunch!
16:25.13mindjujuhi herlo, how is Jenn?
16:25.48herlomindjuju: she's doing really well.  We have a new little boy (AJ) weighing in at a whopping 3lbs 1oz and 17" long...
16:26.01mindjujuWOW!
16:26.06mindjujuwhen did that happen?
16:26.14mindjujuno FB!!
16:26.18mindjujufail herlo
16:26.20mindjujuno pics!
16:26.20herlomindjuju: AJ is also doing really well, he's in the nicu, but all is going well, he's breathing on his own which is the biggest concern
16:26.26herlomindjuju: was getting there
16:26.30herloFB was next
16:26.33herlohad to tell family first
16:26.41mindjujui'm just so happy for you
16:26.44herlomindjuju: he was born at 2:16 am
16:26.50mindjujuwow!
16:26.52herloc-section
16:27.08eggyknapherlo: congrats
16:27.12herlotx
16:27.25eggyknapwhat are you doing on IRC already? :)
16:27.29mindjujuyeah!
16:27.45mindjujusurely not at work
16:27.49mindjujuyes?
16:27.49herlolol
16:27.52herlonot at work
16:27.56mindjujuawesome
16:27.57herloin the hospital room right now
16:28.14herloJennifer is dozing next to me
16:28.24mindjujuyou should bring Jenn a sammich from geek lunch
16:28.31herloI've been on IRC most of the time actually
16:28.42eggyknap<PROTECTED>
16:28.50herloyeah, I don't think I'm going to Geek Lunch
16:28.58mindjujuyup, understandable
16:28.59herloi'm excited it's happening
16:29.13influxha
16:29.19mindjujuyou know what's funny though, when Tiff was having gall bladder surgery, i was sitting there remoted into work comps using hospital wifi
16:29.23mindjujugot tons of stuff done
16:29.26influxmy friend skrike tweeted through his girlfriend's delivery a couple days ago.
16:29.38influxShe was cool with it too.
16:29.40mindjujuand yelling at adobe support for something that foobed
16:29.41mindjujuit was fun
16:30.00mindjujuwell, not yell, but you know
16:30.02mindjujunot talky nice
16:30.02herlomindjuju: check fb now you punk :)
16:30.24herlomindjuju: yeah, I've been hacking to kind of keep myself busy
16:30.35herlolearning css and html layouts a bit better
16:30.36mindjujuherlo, i promise this is true, first thing i did when I woke up was check FB to see about jenn
16:30.43herlomindjuju: you rock
16:30.43mindjuju:)
16:32.35mindjujusee that, you posted less than 5 minutes ago, and already you have like 6 comments
16:32.39mindjujuwe's all excited for ya
16:34.08herloyep
16:34.12herlome too :)
17:05.06*** join/#uphpu mindjuju_ (~mindjuju@mail.billgood.us)
17:21.52influxmindjuju's evil twin is a mail server?
17:22.01influx:<
17:22.31mindjuju_long funny story
17:22.42mindjuju_v funny
17:22.48mindjuju_you going to geek lunch?
17:23.05influxI wish.
17:23.09influxNo car.
17:23.19mindjuju_oh bummer!
17:23.26influxIt's ok. One of these days.
17:23.46influxI really want to expand my local circle of nerd comrades.
17:59.35*** join/#uphpu shofetim (~user@97-121-236-189.blng.qwest.net)
18:00.08Utah_Davenerd comrades
19:20.29*** join/#uphpu ninnypants (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net)
19:51.49*** join/#uphpu fungus-mobile (~fungus@166.205.9.230)
20:03.33fungus-mobile<PROTECTED>
20:08.22orsonj_m___m________
20:17.03fungus-mobileIs there a law against irc while driving?
20:17.32orsonjprobably not specifically, but perhaps indirectly
20:17.39orsonjwould you like to buy a vowel
20:18.35fungus-mobileAwesome. ;)
20:21.55fungus-mobileNope. Mmm sounds just fine
20:51.44influxhttp://pastebin.com/sKB67ShK
20:52.09influxone sec
20:54.19fungusSELECT projectNumber,TIME(SUM(timeElapsed)), TIME_TO_SEC(TIME(SUM(timeElapsed))) FROM timesheet GROUP BY projectNumber
20:54.29fungusdon't need two queries
20:55.10fungusalso, by giving better names to your columns you can clean up the array ids
20:55.35fungusTIME(SUM(timeElapsed)) as `sum`
21:06.19influxfungus: I'm displaying time in standard format, as well as decimal format.
21:06.41fungusright, but you don't need to use two different queries to get both
21:06.46fungusone query can get both
21:08.04DexterTheDragonpretty sure you can do all 3 queries in 1
21:08.36fungusI don't think so, he's using group by in the first two, but not the 3rd
21:09.00DexterTheDragonbut he's looping through all 3 at the same time
21:09.47DexterTheDragonand its all from the same table. which makes me think the match ups are weird
21:10.16funguswow, I didn't catch that.  right.
21:11.13fungusThey shouldn't line up, unless the group by is unneeded
21:11.23fungus1 row per projectnumber?
21:12.03DexterTheDragonand its relying very heavily on the luck of the engine ordering the queries the same
21:14.17influxI think i may have noticed that. (haven't updated the code) I'm ordering, so far now, the first two queries by id.
21:14.58influxand now the third one as well.
21:15.18herlohow was geek lunch??
21:15.20influxI see what you're saying in your first response, fungus.
21:15.29influx<-- db nub
21:15.50fungusjust use two queries, one to get the sum, both time and decimal, and another for your main loop
21:15.55influxDoing okay for picking it up as I go along, I think.
21:16.11*** join/#uphpu mitchmorby (~Adium@166-70-210-180.ip.xmission.com)
21:16.12influxfungus: Right.
21:16.21influxI didn't know I could do that is all.
21:16.24influx:D
21:16.42fungusyay, another learning moment.  Ding!
21:17.07fungusI love those, especially my own.
21:17.18influxHeh.
21:18.04influxhow exactly does the GROUP BY effect the sums, if at all?
21:20.06fungusgroup by collapses records with identical values in the column you specify
21:20.10funguslike a summary
21:20.29fungusall rows with the same projectNumber are collapsed into one row.
21:20.48fungusand SUM() sums that time in all the collapsed rows.
21:40.46influxI need group by in order to sum up the values?
21:41.28fungusyes
21:41.43fungusbut using group by will reduce the number of returned rows
21:42.40fungusit will only return as many rows as you have unique projectNumbers
21:46.00*** join/#uphpu josephscott (~josephsco@74.200.246.169)
21:46.00*** mode/#UPHPU [+v josephscott] by ChanServ
21:47.23orsonjwow, _m___m________ + grep == short hangman games
21:48.45fungusecho _m___m________ | tr _ . | grep -f - /usr/share/dict/words
21:48.56fungusno kidding
21:51.43influxI'm printing all of this in table rows; I would like to have the sums display for every row associated with the project to which the sum belongs.
21:52.33fungusso you want the total project sum displayed on every row
21:52.35fungus?
21:52.43influxIt would be nice, but it's not critical.
21:53.07influxRight now it prints along with the most recent entry made to the particular project.
21:53.12fungusThey are still two separate queries, and must not be looped together
21:53.51fungusYou can loop through the first query and create a simple array from it.
21:54.07fungus$sum[projectNumber] = $sum
21:54.19fungusThen reference this array in your main loop
21:54.43influxaye
22:37.28*** join/#uphpu cro (~cro@166-70-222-105.ip.xmission.com)
22:41.36*** join/#uphpu fungus (~olsonl@bromine.sosstaffing.com)
22:41.36*** join/#uphpu jamund (~jamund@173-8-91-177-Utah.hfc.comcastbusiness.net)
22:41.36*** join/#uphpu cedwards (~christer@unaffiliated/zelut)
22:41.36*** join/#uphpu cycokilr (~cycokilr@216.112.116.6)
22:41.36*** mode/#UPHPU [+o fungus] by zelazny.freenode.net

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