| 00:01.10 | orsonj | interesting program, that pi.c |
| 00:08.31 | *** join/#uphpu swb (n=sheri@cpe-67-248-88-31.nycap.res.rr.com) |
| 00:08.31 | *** mode/#UPHPU [+v swb] by ChanServ |
| 00:28.39 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 00:28.54 | *** join/#uphpu _psychic__ (n=_psychic@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 00:28.56 | *** mode/#UPHPU [+v _psychic__] by ChanServ |
| 00:44.23 | mindjuju | ~seen beandog |
| 00:44.26 | ibot | beandog <n=steve@gentoo/developer/beandog> was last seen on IRC in channel #uphpu, 1h 48m 29s ago, saying: 'converting empty strings to NULL? That's evil.'. |
| 00:47.46 | SunSparc | night all |
| 00:50.31 | supernovia | see ya SunSparc (well, I guess he's gone now) |
| 00:53.25 | supernovia | mindjuju: beandog keeps talking about watching Galaxy Quest as a group |
| 00:53.35 | supernovia | think we could pull that off sometime? I think it'd be fun :-D |
| 00:59.34 | macnewbold | yeah, galaxy quest rocks |
| 01:00.02 | supernovia | I haven't seen it since it was in the dollar theaters :-/ But I loved it then |
| 01:00.33 | supernovia | and really I'm just bad at watching TV or movies unless there's some social aspect tied to it... |
| 01:03.35 | supernovia | oh hey, utahcon |
| 01:03.37 | supernovia | are you around? |
| 01:05.04 | mindjuju | galaxy quest would be cool! |
| 01:05.35 | supernovia | I think so :) |
| 01:08.34 | mindjuju | so when were yall going to have the party? |
| 01:08.36 | *** join/#uphpu ninnypants (n=Tyrel@69.169.155.194) |
| 01:33.30 | *** join/#uphpu redroy1 (n=Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 01:35.15 | *** join/#uphpu jnbek (n=jnbek@unaffiliated/jnbek) |
| 01:39.58 | *** join/#uphpu _psychic_ (n=_psychic@raisinbread.fttp.xmission.com) |
| 01:39.58 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 01:40.40 | *** join/#uphpu undertakingyou (n=will@undertakingyou.dsl.xmission.com) |
| 01:40.40 | *** mode/#UPHPU [+v undertakingyou] by ChanServ |
| 02:21.23 | *** join/#uphpu supernovia (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 02:47.43 | *** join/#uphpu redroy1 (n=Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 03:06.38 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 03:06.38 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 03:09.41 | *** join/#uphpu ninnypants (n=Tyrel@69.169.155.194.provo.static.broadweavenetworks.net) |
| 03:09.52 | beandog | supernovia: ping |
| 03:09.59 | supernovia | hey beandog |
| 03:10.07 | beandog | howsit |
| 03:10.20 | supernovia | It's all good, just watchin the sotu online |
| 03:10.25 | beandog | whats that |
| 03:10.32 | supernovia | state of the union |
| 03:10.34 | *** join/#uphpu blendmasternoid (n=blendmas@97-117-99-216.slkc.qwest.net) |
| 03:10.36 | beandog | oh |
| 03:10.44 | beandog | I was just watching Mr. Belvedere |
| 03:10.52 | supernovia | hehe that is awesome |
| 03:11.07 | supernovia | not sure how much of this is fact or fiction; we'll see |
| 03:31.00 | *** join/#uphpu cro (n=cro@166-70-222-105.ip.xmission.com) |
| 03:57.34 | *** join/#uphpu romanovic-afk (n=romanovi@c-67-161-208-14.hsd1.ut.comcast.net) |
| 04:01.30 | justincarmony | supernovia: how was the sotu? |
| 04:01.45 | supernovia | Well.. |
| 04:02.00 | *** part/#uphpu redroy1 (n=Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 04:02.38 | supernovia | Obama likes to call our attention to the little guys and that makes his speeches fairly touching |
| 04:03.13 | supernovia | lots of big promises too |
| 04:03.31 | supernovia | but he said it himself, there's a lack of trust and big fancy speeches don't fix that |
| 04:03.49 | supernovia | I also was a bit put off by how many times he said we're not going to allow so and so to do this and that |
| 04:05.09 | supernovia | not sure what that means exactly so I will have to go look at the different bills |
| 04:06.00 | supernovia | there's talk of making schools more responsible, taking funding from the ones that fail |
| 04:06.29 | supernovia | but as we've seen with no child left behind, success in elementary education can be difficult to measure |
| 04:07.00 | supernovia | you end up with teachers who only teach their kids to pass the different measurement tests |
| 04:07.55 | supernovia | I am all for more school responsibility but I think parents are better at measuring how well their own children are doing |
| 04:09.56 | supernovia | I did like his comments on supporting clean energy technology in the states - not because I necessarily believe in the "overwhelming evidence" of global warming but because I think energy independence is a great goal |
| 04:12.17 | *** join/#uphpu _psychic_ (n=_psychic@raisinbread.fttp.xmission.com) |
| 04:12.17 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 04:15.27 | herlo | hi |
| 04:15.39 | supernovia | hi herlo |
| 04:15.43 | herlo | supernovia: hi |
| 04:15.52 | herlo | I watched most of the SOTU too |
| 04:16.56 | herlo | small businesses can get good loans from the $90b he wants to put into making sure they cna get loans and I am excited about that too. |
| 04:17.17 | supernovia | Cool |
| 04:17.17 | herlo | supernovia: how's things? |
| 04:17.48 | ninnypants | what's you business |
| 04:18.12 | macnewbold | nunya |
| 04:18.18 | supernovia | lol |
| 04:18.37 | supernovia | things are ok herlo |
| 04:19.01 | supernovia | wait a sec.. somebody ping me - pidgin is wiggin |
| 04:19.31 | *** part/#uphpu supernovia (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 04:19.38 | herlo | kk |
| 04:19.46 | *** join/#uphpu supernovia (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 04:19.58 | supernovia | ping? |
| 04:20.48 | *** part/#uphpu supernovia (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 04:20.59 | *** join/#uphpu supernovia (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 04:22.10 | herlo | pong? |
| 04:22.28 | supernovia | weird |
| 04:22.36 | herlo | what does? |
| 04:22.40 | herlo | what is weird, I mean |
| 04:22.51 | supernovia | pidgin was just being odd |
| 04:24.02 | supernovia | anyway yah things are OK herlo |
| 04:25.46 | herlo | cool |
| 04:27.41 | supernovia | where are you headed? |
| 04:27.45 | herlo | raleigh |
| 04:27.51 | supernovia | and did you mention what your new business will be? |
| 04:28.09 | herlo | going to work on a project with Fedora |
| 04:28.35 | herlo | improving events and the software to recordd meetings/presentations/etc |
| 04:29.14 | supernovia | coolio :) |
| 04:31.44 | supernovia | if I were in Raleigh I would drive to goldsboro and have some bbq :) |
| 04:32.07 | ninnypants | any idea how many times I can run an md5 on a string before performance affected? |
| 04:38.42 | herlo | supernovia: nice |
| 04:38.50 | herlo | ninnypants: performance of what? |
| 04:44.28 | ninnypants | script run time mostly |
| 04:46.09 | herlo | 3 |
| 04:49.22 | ninnypants | hmm I was actually thinking I was going to need to use it mor than I did but I got it done in 3 |
| 04:49.34 | *** part/#uphpu supernovia (n=Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 04:50.20 | herlo | :) |
| 04:57.15 | ninnypants | yeah I know but 3 md5s and a couple sha1s are good enough |
| 05:07.36 | *** join/#uphpu _psychic_ (n=_psychic@raisinbread.fttp.xmission.com) |
| 05:07.36 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 05:31.59 | *** join/#uphpu _psychic_ (n=_psychic@raisinbread.fttp.xmission.com) |
| 05:31.59 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 06:30.33 | *** join/#uphpu undertak1ngyou (n=will@undertakingyou.dsl.xmission.com) |
| 06:50.19 | *** join/#uphpu brasto (n=brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 06:50.19 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 10:44.42 | *** join/#uphpu ibot (i=ibot@rikers.org) |
| 10:44.42 | *** topic/#uphpu is Utah PHP Users Group | uphpu.org | Geek Lunch, Friday 1/29, Indian food - see #utos for details |
| 10:44.42 | *** mode/#UPHPU [+v ibot] by ChanServ |
| 13:55.32 | *** join/#uphpu jgiboney (n=jgiboney@67.199.185.19) |
| 13:56.05 | jgiboney | Wade, did that sql work for you? |
| 14:13.32 | *** join/#uphpu jtsnow (n=chatzill@VDSL-151-118-129-72.DNVR.QWEST.NET) |
| 15:20.44 | *** join/#uphpu josephscott (n=josephsc@75-169-244-123.slkc.qwest.net) |
| 15:20.44 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 15:47.49 | *** join/#uphpu influx (n=influx@li46-69.members.linode.com) |
| 16:04.12 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 16:04.12 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 16:05.06 | *** join/#uphpu swb (n=sheri@16.sub-75-194-54.myvzw.com) |
| 16:05.07 | *** mode/#UPHPU [+v swb] by ChanServ |
| 16:05.19 | *** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com) |
| 16:05.19 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 16:14.42 | *** join/#uphpu _psychic_ (n=_psychic@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 16:14.42 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 16:21.04 | *** join/#uphpu thebigdog (n=thebigdo@dsl093-228-015.slc1.dsl.speakeasy.net) |
| 16:21.05 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 16:24.42 | *** join/#uphpu SunSparc (n=sparky@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 16:24.42 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 16:28.59 | *** join/#uphpu cro (n=cro@166-70-222-105.ip.xmission.com) |
| 17:15.01 | *** join/#uphpu ninnypants (n=Tyrel@69.169.155.194.provo.static.broadweavenetworks.net) |
| 17:24.54 | justincarmony | ok... |
| 17:25.22 | justincarmony | so I don't think they're going to put the i5 in a new macbook pro until this summer |
| 17:26.53 | justincarmony | so I think I'm going to order my new laptop today :P |
| 17:34.38 | josephscott | mindjuju: python user group meets at your place too? |
| 17:35.11 | SunSparc | justincarmony: I don't want to wait that long! :( |
| 17:35.25 | SunSparc | But I need to get a new one also. |
| 17:35.30 | justincarmony | yeah |
| 17:35.32 | justincarmony | well |
| 17:35.43 | justincarmony | I need to get my current laptop to apple to have it repaired |
| 17:37.01 | justincarmony | but I can't be out of a laptop that long, espcially doing iPhone stuff |
| 17:37.08 | SunSparc | My current laptop out of AppleCare. :( |
| 17:37.13 | justincarmony | so this way I'll have a nice, new laptop |
| 17:37.17 | justincarmony | and a backup Mac |
| 17:37.22 | SunSparc | Good call. |
| 17:38.32 | justincarmony | part of me was tempted to get an iMac or Mac Pro |
| 17:39.24 | justincarmony | but I've read the iMac is basically a MacBook Pro's internals built into a screen |
| 17:40.21 | justincarmony | and I don't have the funds for a Mac Pro that I want :P |
| 17:48.39 | *** join/#uphpu swb (n=sheri@113.sub-75-236-91.myvzw.com) |
| 17:48.40 | *** mode/#UPHPU [+v swb] by ChanServ |
| 17:54.55 | fungus | justincarmony, the iMac has an i5/i7 option! |
| 17:55.06 | justincarmony | yeah |
| 17:55.08 | fungus | with super graphics for gaming. |
| 17:55.10 | justincarmony | but I want a mobile one :P |
| 17:55.46 | mindjuju | are there games for the mac? |
| 17:55.56 | mindjuju | jk |
| 17:57.06 | thebigdog | mindjuju: you can play wow on mac |
| 17:57.10 | thebigdog | they call it iwow |
| 17:57.49 | mindjuju | :) |
| 17:58.01 | SunSparc | lol |
| 17:58.11 | SunSparc | I have an iPaladin |
| 17:58.11 | fungus | Sims 3, Spore, Dragon Age, ... |
| 17:59.41 | mindjuju | seems like every year they do some new expansive world, like wasn't last year the zombies |
| 17:59.44 | mindjuju | did they do one this year? |
| 17:59.58 | fungus | not every year. every two years |
| 18:00.02 | mgeary | ~welcome thebigdog |
| 18:00.03 | ibot | Howdy, thebigdog! |
| 18:00.07 | fungus | and the next one is later this year. |
| 18:00.17 | mindjuju | what is it? |
| 18:01.45 | fungus | mindjuju already has no life, there is nothing left for WoW to suck out. |
| 18:02.02 | mindjuju | true that |
| 18:02.09 | fungus | mindjuju needs to quit work and play wow full time. :) |
| 18:02.21 | mindjuju | though i saw steam had pyschonauts for $2 |
| 18:02.24 | mindjuju | so i bought it |
| 18:02.30 | mindjuju | seems like stderr said it was good |
| 18:02.55 | fungus | I have some games on Steam, but I never play them cause I don't have any windows machines. :( |
| 18:03.28 | fungus | I tried wine, it didn't work... |
| 18:03.52 | mgeary | okay, this is just so !@#%$@ idiotic, even for Microsoft, that i just have to hit my head against a wall. |
| 18:04.41 | mgeary | if your recipients can't open "winmail.dat" files, rather than, you know, you changing your email settings, the recommended action is that the recipient should download a program that can decode them |
| 18:05.02 | fungus | lol |
| 18:05.13 | wps | I hate it when I receive winmail.dat attachments |
| 18:05.34 | fungus | I just flame the sender. |
| 18:06.03 | wps | fungus, mgeary, anyone elseâ¦Â have a minute to help me get this query working (that I posted to the list about)? |
| 18:06.13 | wps | my client changed the requirements slightly (since posting) |
| 18:06.17 | wps | but I think it makes it easier |
| 18:06.25 | justincarmony | whew |
| 18:06.29 | justincarmony | its ordered! :) |
| 18:06.37 | wps | congrats, justincarmony |
| 18:07.05 | fungus | grats |
| 18:07.08 | mindjuju | josephscott - yup, my place rox! |
| 18:08.22 | SunSparc | justincarmony: Nice |
| 18:08.35 | justincarmony | hopefully I won't regret it ;) |
| 18:09.05 | SunSparc | If you do, you can just give it to me. :) |
| 18:35.59 | justincarmony | lol |
| 18:36.29 | wps | my inbox has 19 messages in it and hasn't been empty for a week |
| 18:36.34 | wps | I feel like I'm drowning |
| 18:41.30 | SunSparc | I have 11 accounts contributing to a total of 2961 messages in my inbox. |
| 18:42.10 | SunSparc | wps: hth |
| 18:42.39 | wps | I usually go to sleep each night with mine empty |
| 18:42.40 | wps | :) |
| 18:43.13 | SunSparc | The only way I see an empty inbox is when I create a new account. :) |
| 18:43.17 | SunSparc | My wife can't stand looking at my inbox. |
| 18:43.41 | wps | fungus: thank you |
| 18:43.46 | wps | I really appreciate your help |
| 18:44.06 | fungus | np, anytime |
| 18:44.22 | wps | it was almost what I needed |
| 18:44.33 | wps | the YEAR() functions were breaking it |
| 18:44.38 | wps | but once I removed those it gave me what I needed |
| 18:45.06 | wps | I needed to calculate against the whole date, not just the year |
| 18:45.38 | fungus | but how did the MOD function work with dates instead of integer years |
| 18:45.54 | wps | I have no idea :) |
| 18:45.57 | wps | what to see my query? |
| 18:47.40 | wps | here's what worked: http://drp.ly/inKdE |
| 18:47.54 | fungus | ahh, IC |
| 18:48.07 | fungus | Subtracting two dates returns an integer. |
| 18:48.13 | wps | ah |
| 18:48.19 | fungus | simple test. select '2010-05-05' - '2001-10-01'; |
| 18:48.33 | wps | ah |
| 18:48.38 | wps | I've never tried that |
| 18:48.47 | wps | I really like SQL |
| 18:49.03 | wps | I find it fascinating how powerful it is |
| 18:49.05 | fungus | but the YEAR() functions work too |
| 18:49.22 | wps | even though the anniversary is in the middle of the year? |
| 18:50.21 | fungus | wps how accurate did you need it? |
| 18:50.27 | wps | to the day |
| 18:50.43 | fungus | doh, you'll need to change it then. |
| 18:51.20 | fungus | MOD returns a remainder, as an integer. |
| 18:51.54 | fungus | er, not |
| 18:52.06 | fungus | crazy stuff |
| 18:52.24 | mindjuju | i'm going to need an rte, i'm thinking tinymce |
| 18:52.28 | mindjuju | anybody have something better? |
| 18:52.53 | fungus | oh, nvm yes it does return an int |
| 18:53.01 | fungus | wps, you are using slashes for dates! |
| 18:53.03 | fungus | that's bad |
| 18:53.10 | fungus | slashes are division operators |
| 18:53.19 | wps | normally notâ¦Â that was a typo |
| 18:53.25 | fungus | oh, ok. good |
| 18:53.36 | wps | I know dates should be dashed with MySQL |
| 18:53.51 | fungus | but you still have a problem, as the MOD is returning an int, it's not to the day accurate |
| 18:54.28 | fungus | Instead of finding the modulus you need the quotient, and add it to the signup date |
| 18:56.25 | wps | QUO() ? QUOTIENT() ? |
| 18:56.34 | wps | good isn't finding anything |
| 18:56.39 | wps | s/good/google/ |
| 18:57.00 | DexterTheDragon | mindjuju: there's http://ckeditor.com/ |
| 18:59.11 | fungus | wps, the quotient is what is returned by a division operation |
| 18:59.35 | fungus | remember math class? :) |
| 18:59.36 | fungus | j/k |
| 18:59.38 | wps | sorryâ¦Â it's been a while since math |
| 18:59.56 | mindjuju | it's been since yesterday at 8a for me |
| 19:00.32 | wps | do I still want to use INTERVAL? |
| 19:01.20 | fungus | yes, you are still changing a date |
| 19:01.48 | fungus | except now, instead of subtracting the remainder of years from now, you need to add the quotient of years to the signup date |
| 19:03.27 | fungus | signupdate + floor( (year of now - year of signup) / 3 ) |
| 19:03.46 | *** join/#uphpu _psychic__ (n=_psychic@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 19:03.46 | *** mode/#UPHPU [+v _psychic__] by ChanServ |
| 19:04.23 | fungus | oops, forgot to remultiply by number of periods |
| 19:04.30 | fungus | signupdate + floor( (year of now - year of signup) / 3 ) * 3 |
| 19:06.22 | wps | does YEAR() return the current year if you pass nothing in? |
| 19:06.41 | fungus | no |
| 19:06.44 | fungus | error |
| 19:06.54 | *** join/#uphpu bigdog_ut (n=thebigdo@dsl093-228-015.slc1.dsl.speakeasy.net) |
| 19:06.54 | *** mode/#UPHPU [+o bigdog_ut] by ChanServ |
| 19:08.07 | fungus | http://pastebin.com/m1335bbfb |
| 19:08.32 | wps | ahâ¦Â year(now()) |
| 19:09.32 | fungus | that will be to the second accurate |
| 19:10.44 | fungus | so it's more of a math problem than a SQL one. Figure out the math, then the SQL follows easy. |
| 19:10.50 | wps | hmmâ¦Â empty set |
| 19:12.34 | fungus | run you expression on the signup dates to make sure the expression is working |
| 19:13.04 | fungus | select u.sign_up_date + INTERVAL FLOOR((YEAR(NOW()) - YEAR(u.sign_up_date)) / 3) * 3 YEAR FROM users as u; |
| 19:13.11 | wps | I think I found the error |
| 19:14.49 | wps | is this how it should look? |
| 19:15.00 | wps | (translating your pseudo code into real) |
| 19:15.01 | wps | http://drp.ly/iopcC |
| 19:15.53 | wps | (the sign up date isn't in the database) |
| 19:16.01 | fungus | looks good, but with that sign-up date it won't show anything |
| 19:16.14 | fungus | it's in the future |
| 19:16.24 | wps | ah! |
| 19:16.26 | wps | ha ha ha ha ha |
| 19:16.32 | wps | no wonder my SUM in null |
| 19:16.36 | wps | awesome |
| 19:16.40 | wps | love it |
| 19:17.08 | wps | that's actually right, since the program won't start until this summer |
| 19:17.17 | wps | but for testing, I'll need to set a pretend date in the past |
| 19:18.06 | wps | hmmâ¦Â still null |
| 19:18.12 | wps | does the date need to be in quotes? |
| 19:18.27 | fungus | yes |
| 19:18.36 | fungus | otherwise it will subtract |
| 19:21.50 | wps | like that? |
| 19:21.50 | wps | http://drp.ly/iov6z |
| 19:22.24 | fungus | don't forget the other date |
| 19:23.11 | wps | kâ¦Â got something back nowâ¦Â but I don't think it's right |
| 19:23.15 | wps | at least it's something returned |
| 19:24.03 | wps | checking my data to see what should have been returned |
| 19:24.16 | fungus | wps not a very good test date since it is less than 3 years ago |
| 19:24.26 | wps | yeahâ¦Â I just changed it to 2000 |
| 19:24.44 | wps | I think it worked |
| 19:25.02 | wps | starting with 200, then current tri-annual anniversary is 1 aug 2009 |
| 19:25.09 | wps | and I only have one action after that |
| 19:25.14 | wps | and it returned sum of 1 |
| 19:25.45 | fungus | wps, good debugging tip. Select your expressions directly for testing. |
| 19:25.52 | fungus | select "2000-08-01" + INTERVAL FLOOR((YEAR(NOW()) - YEAR("2000-08-01")) / 3) * 3 YEAR; |
| 19:26.03 | fungus | returns 2009-08-01, as expected |
| 19:27.33 | fungus | oh neat, I found another tweak for you query to simplify. |
| 19:27.34 | fungus | DIV |
| 19:28.49 | fungus | "2000-08-01" + INTERVAL ((YEAR(NOW()) - YEAR("2000-08-01")) DIV 3) * 3 YEAR; |
| 19:29.44 | fungus | DIV is like / but with no remainder, no FLOOR needed |
| 19:30.33 | wps | something strange is happening |
| 19:30.43 | wps | I'm not sure if it's a bug or me just being confused though |
| 19:30.51 | wps | if I set the start date as 1999 I get results |
| 19:30.58 | wps | if I set it as 2001, I get none |
| 19:31.27 | wps | starting with 2001, the most recent anniversary should be 2007-08-01 |
| 19:31.41 | wps | and there are several actions with dates after that that should be returned |
| 19:35.59 | wps | I think I figured out the problem (not the solution yet) |
| 19:36.04 | wps | it isn't using the whole date |
| 19:36.07 | wps | it's just using the year |
| 19:37.02 | wps | so when I start with 2007, the period is 2007-01-01 - 2010-01-01 instead of 2007-08-08 - 2010-08-01 |
| 19:40.26 | fungus | ah, IC. Change the subtraction from years to days. |
| 19:40.35 | fungus | DATEDIFF(now(), "2001-08-01") DIV 365 /3 |
| 19:41.10 | fungus | err, DATEDIFF(now(), "2001-08-01") DIV 365 DIV 3 * 3 |
| 19:41.53 | *** join/#uphpu justincarmony (n=justinca@c-24-10-194-172.hsd1.ut.comcast.net) |
| 19:41.53 | *** mode/#UPHPU [+v justincarmony] by ChanServ |
| 19:43.07 | justincarmony | ... yeah... |
| 19:43.18 | justincarmony | I need that new laptop to get this one serviced |
| 19:49.43 | wps | sorry, fungus, but can you give me that in the context of the rest of the query? |
| 19:50.04 | wps | I have tried putting it in and can't get the syntax right (keep getting syntax error) |
| 19:50.28 | wps | I think I have a parenthesis in the wrong place or something, but I'm not sure |
| 19:50.30 | fungus | WHERE date >= "2008-08-01" + INTERVAL DATEDIFF(now(), "2008-08-01") DIV 365 DIV 3 * 3 YEAR; |
| 19:51.15 | wps | what does the YEAR on the very end do? |
| 19:51.30 | fungus | it's part of the INTERVAL clause |
| 19:51.42 | fungus | WHERE date >= "2008-08-01" + INTERVAL (DATEDIFF(now(), "2008-08-01") DIV 365 DIV 3 * 3) YEAR; |
| 19:51.48 | fungus | does that make it more clear? |
| 19:51.59 | wps | yes |
| 19:52.40 | fungus | although using 365 days per year could possibly generate weirdness based on leap years. |
| 19:53.00 | fungus | but it would be so extremely rare, it's probably not critical |
| 19:53.07 | wps | agreed |
| 19:53.49 | wps | syntax error resolved |
| 19:53.51 | wps | testing⦠|
| 19:54.38 | wps | PERFET |
| 19:54.42 | wps | PERFECT |
| 19:54.48 | wps | thanks a million, fungus |
| 19:54.56 | wps | I really, really appreciate your time |
| 19:55.04 | wps | I learned a bunch of new things today |
| 19:55.06 | fungus | np, I like fun math problems |
| 19:55.16 | wps | I need to brush up on my math |
| 19:55.24 | wps | very true that this really is more about math than code |
| 19:55.44 | wps | I have to present this to the client tomorrow and this result is a critical feature |
| 19:55.49 | wps | thanks |
| 19:56.07 | wps | I really like calculating this in SQL better than PHP |
| 19:56.51 | fungus | ?! |
| 19:56.57 | fungus | Ben Folds doing Dre? |
| 19:57.04 | utahcon | fungus: I have a DAAP give it a listen |
| 19:57.13 | fungus | k, I will |
| 19:57.52 | utahcon | I warn... completely uncensored. |
| 19:58.00 | fungus | lol, I don't care |
| 19:58.13 | fungus | rofl! dude! |
| 19:58.25 | utahcon | yeah pimp huh? |
| 19:58.31 | utahcon | I love covers |
| 19:58.32 | fungus | totally. |
| 20:03.31 | mgeary | ~rlart |
| 20:03.32 | ibot | whacks jsmith-away with the cluebat |
| 20:06.46 | mgeary | ~rip JD Salinger |
| 20:06.47 | ibot | ACTION takes JD Salinger and acts as Jack The Ripper |
| 20:06.52 | mgeary | uh, no |
| 20:10.29 | *** join/#uphpu _psychic_ (n=_psychic@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 20:10.29 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 20:25.19 | *** join/#uphpu JacobEdmondKerrU (n=JacobEdm@67.41.175.171) |
| 20:26.34 | JacobEdmondKerrU | Hey guys. I am trying to unlink a file that I had uploaded via PHP and the directories it's in is set to giver permission to all but keep getting this error :(. Warning: unlink(.) [function.unlink]: Operation not permitted in |
| 20:26.54 | JacobEdmondKerrU | dumb thing is it was working then it just stops for some stupid reason. |
| 20:31.29 | utahcon | JacobEdmondKerrU: what are the perms on the directory/file? Does the user your Apache/PHP run as have perms? |
| 20:32.21 | JacobEdmondKerrU | I think I figured it out. There was a bug in my code the directory was off :( |
| 20:40.49 | *** join/#uphpu mgeary_ (n=mgeary@166.70.44.49) |
| 20:40.50 | *** mode/#UPHPU [+v mgeary_] by ChanServ |
| 20:42.40 | wps | crazy that jan is almost over already |
| 20:45.07 | *** join/#uphpu SunSparc (n=sparky@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 20:45.08 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 20:45.18 | mgeary_ | wait, what?? |
| 20:49.17 | wps | being the recipient of mailing list admin messages is a very colorful experience |
| 20:53.02 | *** join/#uphpu _psychic_ (n=_psychic@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 20:53.03 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 20:54.38 | mgeary | anyone here ever tapped into google news rss feeds programmatically? |
| 20:57.31 | *** join/#uphpu _psychic_ (n=_psychic@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 20:57.31 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 21:03.20 | utahcon | I have a very serious case of dont-give-a-dang right now |
| 21:03.38 | utahcon | with 2 + hours left in the day this is not good |
| 21:09.13 | SunSparc | ~give utahcon a care |
| 21:09.13 | ibot | ACTION gives a care to utahcon |
| 21:25.27 | mgeary | i find it hard to believe google has no option for machine consumption of news articles |
| 21:25.50 | mgeary | their "description" output is a bunch of generically (poorly) formatted html that includes the title and link again |
| 21:26.00 | mgeary | parsing it automatically is annoying |
| 21:29.07 | utahcon | mgeary: where are you pulling this from? |
| 21:29.23 | mgeary | google news |
| 21:29.34 | utahcon | what are you trying to do? |
| 21:31.54 | DexterTheDragon | google news has an rss feed |
| 21:32.35 | DexterTheDragon | oh right the rss feed has html in it |
| 21:33.06 | mgeary | output the first line of the 'real' description |
| 21:33.09 | mgeary | yeah |
| 21:33.22 | mgeary | i mean, what the heck |
| 21:33.30 | DexterTheDragon | yeah I remember that. it was most awesome |
| 21:34.42 | DexterTheDragon | same with their blog search |
| 21:36.06 | mgeary | i take it you're being sarcastic |
| 21:36.09 | mgeary | 'awesome' |
| 21:38.58 | DexterTheDragon | yes |
| 21:39.18 | mgeary | i just can't believe that google wouldn't support plaintext descriptions |
| 21:39.27 | mgeary | ~boggle google |
| 21:39.28 | ibot | ACTION stares in flabbergasted astonishment at google |
| 21:40.53 | stderr | w/in 5 |
| 21:41.24 | *** join/#uphpu swb (n=sheri@cpe-67-248-88-31.nycap.res.rr.com) |
| 21:41.25 | *** mode/#UPHPU [+v swb] by ChanServ |
| 21:41.35 | mgeary | they don't even put ids on their nodes so you can extract the text |
| 21:47.50 | SunSparc | ~lart Google |
| 21:47.50 | ibot | slams Google against a large cement Tux |
| 22:13.26 | *** join/#uphpu ninnypants (n=Tyrel@69.169.155.194.provo.static.broadweavenetworks.net) |
| 22:16.00 | *** join/#uphpu PoeticIntensity (n=jason@67.214.232.162) |
| 22:16.00 | *** mode/#UPHPU [+v PoeticIntensity] by ChanServ |
| 22:24.20 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 22:24.20 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 22:26.29 | orsonj | re: http://www.cise.ufl.edu/~manuel/obfuscate/pi.c <-- that is a pretty cool program |
| 22:29.45 | mgeary | ~daylate orsonj |
| 22:29.57 | influx | ~lart mgeary orsonj |
| 22:29.57 | ibot | sends a legion of lawyers after mgeary orsonj's head |
| 22:30.06 | influx | cool |
| 22:41.20 | *** join/#uphpu cycokilr (n=cycokilr@216.112.116.6) |
| 22:41.29 | wps | hail |
| 22:41.58 | SunSparc | Ash? |
| 22:42.52 | SunSparc | Sure, I could have stayed in the past. I could have even been king. But in my own way, I *am* king. |
| 22:43.05 | wps | my daughter calls me king |
| 22:45.14 | *** join/#uphpu erik- (n=erikv@173-10-23-102-BusName-utah.ut.hfc.comcastbusiness.net) |
| 22:58.53 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 22:58.53 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 22:59.21 | *** join/#uphpu erikv (n=erikv@173-10-23-102-BusName-utah.ut.hfc.comcastbusiness.net) |
| 23:02.38 | *** join/#uphpu erik-v (n=erik-v@173-10-23-102-BusName-utah.ut.hfc.comcastbusiness.net) |
| 23:04.37 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 23:04.37 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 23:08.19 | beandog | I think my brain turned off |
| 23:08.22 | beandog | but I'm not sure |
| 23:08.26 | beandog | I can still breathe and watch youtube |
| 23:08.57 | SunSparc | ~wake beandog |
| 23:08.58 | ibot | ACTION throws a barrel-full of ice water on beandog and shouts "GOOD MORNING!!!!" |
| 23:09.03 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 23:09.03 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 23:09.08 | beandog | SunSparc, o thx |
| 23:09.14 | SunSparc | :) |
| 23:09.35 | beandog | SunSparc, whats the name of your hosting co again? and why do I keep forgetting the name? |
| 23:09.42 | SunSparc | he |
| 23:09.48 | beandog | ahah! |
| 23:09.51 | beandog | I rememberd |
| 23:10.15 | SunSparc | Something Sun Hosting something or other |
| 23:10.21 | beandog | heh |
| 23:10.23 | beandog | something like that. |
| 23:10.25 | SunSparc | :) |
| 23:10.30 | wps | it's blue right through your mind |
| 23:10.40 | beandog | Oy |
| 23:10.41 | wps | s/it's/it/ |
| 23:10.43 | SunSparc | :) |
| 23:15.46 | beandog | its so hard to find a host w/postgres |
| 23:15.47 | beandog | sheesh |
| 23:16.07 | DexterTheDragon | thats cause then they can't call it a lamp stack |
| 23:16.19 | influx | lapp stack sounds just as cool |
| 23:16.30 | wps | and a lapp stack just sounds weird |
| 23:16.48 | wps | sounds feminine to me |
| 23:17.08 | SunSparc | If you replace PHP with Ruby you have larp |
| 23:17.22 | erik-v | I ran across a list of postgres hosts: http://www.postgresql.org/support/professional_hosting_northamerica |
| 23:17.23 | influx | ... |
| 23:17.34 | influx | oh, yeah |
| 23:17.42 | influx | linux, apache, ruby, postgre |
| 23:17.53 | influx | ~influx-- |
| 23:17.57 | influx | ~influx- |
| 23:18.09 | mgeary | ladp |
| 23:18.24 | influx | what about an appl stack? |
| 23:19.58 | *** join/#uphpu mindjuju_ (n=mindjuju@mail.billgood.us) |
| 23:20.23 | SunSparc | :) |
| 23:20.37 | justincarmony | lol, larp... if that is the case, does that make them LARPers? :P |
| 23:21.04 | SunSparc | heh |
| 23:24.30 | stderr | most deploys are LIRM or LIRP |
| 23:24.50 | stderr | err, LNRM or LNRP |
| 23:37.19 | mindjuju_ | i didd? |
| 23:37.23 | mindjuju_ | oh |
| 23:38.30 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 23:43.06 | *** join/#uphpu thebigdog (n=thebigdo@dsl093-228-015.slc1.dsl.speakeasy.net) |
| 23:43.06 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 23:43.47 | thebigdog | what are some cms that people have used here that they would recommend to others? |
| 23:44.53 | mgeary | i haven't found any that i like much |
| 23:45.05 | mgeary | i think things like joomla and such are the devil |
| 23:45.25 | *** join/#uphpu JacobEdmondKerrU (n=JacobEdm@67.41.175.171) |
| 23:45.49 | jtsnow | thebigdog: Drupal is nice. |
| 23:45.56 | *** join/#uphpu josephscott (n=josephsc@75-169-244-123.slkc.qwest.net) |
| 23:45.56 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 23:46.00 | JacobEdmondKerrU | Hey hey. Does anyone know an awsome function that will remove the mid 2 characters from something like: 092010 |
| 23:46.26 | jtsnow | substr_replace? |
| 23:46.58 | beandog | wow, Ive never seen that one |
| 23:47.01 | JacobEdmondKerrU | awsome. |
| 23:47.06 | beandog | that is spanky |
| 23:47.15 | beandog | ~jtsnow++ |