| 00:04.17 | fungus | Asterisk uses 7 |
| 00:04.41 | timinator | crazy vids... TY mindjuju |
| 00:04.54 | mindjuju | yeah, i'm listening to The Cure now |
| 00:04.56 | mindjuju | how depressing |
| 00:09.17 | timinator | later guys |
| 00:29.34 | *** part/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 00:58.18 | *** join/#uphpu RedHeron (n=RedHeron@c-98-202-56-80.hsd1.ut.comcast.net) |
| 01:10.03 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 01:17.12 | bradym | Any sql guys around? |
| 01:22.05 | macnewbold | bradym: sup? |
| 01:22.19 | macnewbold | I'm here for a bit until I head over to herlo's |
| 01:22.42 | herlo | macnewbold: woohoo |
| 01:22.57 | macnewbold | yeah, I'm pumped |
| 01:23.07 | bradym | I've got a table with multiple indexes and i'm trying to figure out how to make my query use a specific index |
| 01:23.35 | bradym | apparently you put "USE INDEX index_name" but i can't get it working |
| 01:25.41 | macnewbold | it's mysql, right? |
| 01:25.45 | bradym | yep |
| 01:25.56 | macnewbold | I've never asked it to use a specific index, but you can use explain to see what it's been doing |
| 01:26.05 | macnewbold | usually it will choose the right one |
| 01:26.47 | bradym | yeah, doing the explain shows that it's using both indexes - one of which is a combination of two fields, so it will never match for this query |
| 01:27.41 | macnewbold | so what are the two fields, and the two indexes? |
| 01:27.51 | macnewbold | and what types are the fields? |
| 01:30.43 | macnewbold | if you've got a create table or something, I can recreate it and try some things maybe |
| 01:31.21 | macnewbold | when you say you can't get the use index working, is it a syntax error, or it just still isn't using that index? |
| 01:32.26 | macnewbold | ~cookie |
| 01:32.33 | bradym | sorry, being asked other questions.. |
| 01:32.48 | bradym | no syntax error, just not using the index - it's using both indexes |
| 01:33.22 | macnewbold | so is it going too slow or something? |
| 01:36.13 | bradym | mac: http://dpaste.com/36988/ |
| 01:36.52 | bradym | yeah.. taking 2 seconds for something that should be a few miliseconds with an index |
| 01:37.33 | bradym | hmm.. maybe that's not the problem |
| 01:37.44 | bradym | just removed the other index and it's still taking just as long |
| 01:39.25 | macnewbold | so what's wrong with the index it is using? A prefix of an index (entity) is as good as a whole index itself |
| 01:40.02 | macnewbold | you might need an index for reference though |
| 01:40.48 | macnewbold | btw, what's the type of your tentity.id ? It's using a "ref" type, but probably it should be an "eq_ref" shouldn't it? |
| 01:40.59 | macnewbold | anyway, I'm hitting the road to head over to herlos |
| 01:41.14 | macnewbold | good luck |
| 01:41.30 | bradym | thanks, think i'm just gonna take a different approach to this problem ;) |
| 02:09.42 | *** join/#uphpu wps (n=wps@208.53.47.251) |
| 02:09.42 | *** mode/#UPHPU [+o wps] by ChanServ |
| 02:15.43 | *** join/#uphpu Utah_Dave (n=David_Bo@c-67-172-225-211.hsd1.ut.comcast.net) |
| 02:15.43 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 02:15.55 | mindjuju | sup utah_dave |
| 02:16.15 | Utah_Dave | how's it going, mindjuju? |
| 02:16.28 | mindjuju | going well, you? |
| 02:16.48 | Utah_Dave | pretty good! |
| 02:17.14 | mindjuju | awesome! do you get to be in town this week? |
| 02:17.16 | Utah_Dave | I've been busy learning a new language. It's been fun |
| 02:17.25 | Utah_Dave | Yeah, I'm here for the next couple of weeks |
| 02:17.35 | mindjuju | what language? |
| 02:18.15 | Utah_Dave | erlang |
| 02:19.01 | Utah_Dave | Don't worry, I'm not giving up PHP! It's for a project I'm going to be working on |
| 02:19.26 | mindjuju | nah, not worried... was just reading the wiki on erlang |
| 02:20.33 | Utah_Dave | This is what got me to decide on it. |
| 02:20.34 | Utah_Dave | http://www.sics.se/~joe/apachevsyaws.html |
| 02:21.15 | Utah_Dave | yaws is a webserver written in erlang. In this test it handled 80,000 parallel connections as opposed to 4,000 that apache handled |
| 02:22.12 | mindjuju | that's awesome! |
| 02:24.01 | Utah_Dave | yeah, I thought so, too. |
| 02:42.53 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 02:42.53 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 03:07.24 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 03:07.24 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 03:22.29 | *** join/#uphpu Utah_Dave (n=David_Bo@75-169-181-251.slkc.qwest.net) |
| 03:22.29 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 03:24.27 | Utah_Dave | wps: you around? |
| 03:52.40 | wps | am now |
| 04:37.35 | *** part/#uphpu Utah_Dave (n=David_Bo@75-169-181-251.slkc.qwest.net) |
| 05:07.49 | *** join/#uphpu josephscott (n=josephsc@63-228-200-73.slkc.qwest.net) |
| 05:07.49 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 06:04.34 | *** join/#uphpu RedHeron (n=RedHeron@c-98-202-56-80.hsd1.ut.comcast.net) |
| 06:40.32 | *** join/#uphpu mgeary (n=mgeary@72.8.120.115) |
| 06:40.32 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 07:16.59 | *** part/#uphpu mgeary (n=mgeary@72.8.120.115) |
| 09:17.32 | *** join/#uphpu roham[rt] (n=roham@91.184.77.165) |
| 12:45.54 | *** part/#uphpu roham[rt] (n=roham@91.184.77.165) |
| 13:54.17 | *** join/#uphpu jnbek (n=jnbek@72.8.114.148) |
| 14:13.05 | *** join/#uphpu nei_rauni (n=nei@201.22.37.226.adsl.gvt.net.br) |
| 14:34.27 | *** join/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 14:34.28 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 14:46.38 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 14:46.38 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 15:24.48 | *** join/#uphpu timinator (n=timothy@c-98-202-102-189.hsd1.ut.comcast.net) |
| 15:24.49 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 15:25.47 | timinator | morning guys |
| 15:28.48 | *** join/#uphpu jnbek (n=jnbek@72.8.114.148) |
| 15:39.11 | *** join/#uphpu SunSparc (n=sparky@66.7.114.125) |
| 15:39.18 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 15:39.26 | SunSparc | Thanks, I think I will. |
| 15:50.23 | *** join/#uphpu jnbek (n=jnbek@72.8.114.148) |
| 15:57.04 | timinator | LOL |
| 15:58.16 | *** join/#uphpu fungus (n=olsonl@fungus.broker.freenet6.net) |
| 15:58.16 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 16:02.17 | *** join/#uphpu wps (n=wps@64.0.192.94) |
| 16:02.17 | *** mode/#UPHPU [+o wps] by ChanServ |
| 16:02.30 | *** join/#uphpu _psychic_ (n=_psychic@66.7.114.125) |
| 16:02.30 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 16:03.35 | *** join/#uphpu thebigdog (n=thebigdo@0006yE-Yn.dsl.xmission.com) |
| 16:03.35 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 16:11.27 | *** join/#uphpu dataw0lf (n=stderr@adsl-75-14-203-206.dsl.renocs.sbcglobal.net) |
| 16:11.27 | *** mode/#UPHPU [+v dataw0lf] by ChanServ |
| 16:22.29 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 16:22.29 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 16:24.08 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 16:24.08 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 16:30.24 | *** join/#uphpu josephscott (n=josephsc@63-228-200-73.slkc.qwest.net) |
| 16:30.24 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 16:43.00 | mgeary | ~ping fungus |
| 16:43.00 | jbot | pong fungus |
| 16:43.11 | fungus | ~pong |
| 16:43.12 | jbot | PING! |
| 16:43.35 | mgeary | heya |
| 16:44.03 | mgeary | i've got a follow-up postfix question/issue. I changed the recipient_delimiter to the default (+), and everything worked as expected... |
| 16:44.31 | mgeary | however, upon consideration, i decided that the plus sign isn't a great delimiter for a number of reasons. I'd prefer the delimiter to be a period (.).... |
| 16:44.48 | mgeary | i changed it, reloaded postfix, and all went well when i tested my *own* email address |
| 16:44.59 | mgeary | which is firstname.lastname@company.com |
| 16:45.13 | fungus | Then firstname is the username it looks for |
| 16:45.16 | mgeary | that is, i tested firstname.lastname.test@company.com and it went just fine |
| 16:45.49 | mgeary | doesn't it *first* look for firstname.lastname.test, and *then* for firstname.lastname, and *then* for just firstname ? |
| 16:45.59 | mgeary | or does it work front-to-end? |
| 16:46.12 | fungus | I think it will just look for firstname |
| 16:46.45 | mgeary | well, that actually would be consistent with what i'm seeing, though i read something last night which seemed to contradict that... <checks for link> |
| 16:48.01 | fungus | I could be wrong though... |
| 16:48.10 | mgeary | from the docs: |
| 16:48.17 | mgeary | The separator between user names and address extensions (user+foo). See canonical(5), local(8), relocated(5) and virtual(5) for the effects this has on aliases, canonical, virtual, relocated and on .forward file lookups. Basically, the software tries user+foo and .forward+foo before trying user and .forward. |
| 16:48.53 | mgeary | now, that suggests that it first looks for the complete email (with delimiter), but it does not directly state that it will regress through each delimiter... |
| 16:48.58 | mgeary | ....i guess that was my assumption |
| 16:49.53 | fungus | Personally I only use those delimiters for special addresses. |
| 16:50.07 | fungus | for things like first.last I use a real alias to my username |
| 16:50.59 | mgeary | yeah |
| 16:51.29 | mgeary | my thinking here, though, is that if we want to use this as a spam control/tracking mechanism, the plus isn't a good delimiter because: |
| 16:51.34 | mgeary | 1) many email validators reject it |
| 16:51.50 | mgeary | 2) it's obvious what you're doing, should anyone wish to abuse your "direct" email addy |
| 16:52.03 | mgeary | 3) users unfamiliar with this technique could get confused by a plus |
| 16:52.15 | mgeary | whereas many people are familiar with periods in emails |
| 16:53.40 | fungus | makes sense, then just use a period |
| 16:54.07 | fungus | as long as usernames don't have periods you don't have to worry about which user it will resolve to. |
| 16:54.09 | mgeary | except that it doesn't seem to reduce through multiple delimiters. it appears to do what you suggested initially |
| 16:54.13 | mgeary | exactly |
| 16:54.39 | fungus | ahh. You want first.last<delim>tag |
| 16:55.00 | mgeary | yeah |
| 16:55.25 | fungus | maybe a - (dash) |
| 16:55.29 | fungus | ? |
| 16:55.35 | mgeary | yeah, i'm currently using underscore |
| 16:55.40 | mgeary | but i do like that period |
| 16:55.54 | mgeary | i might just rework my aliases to make it work. |
| 16:55.54 | beandog | just use spaces as a delimiter. duh. |
| 16:56.00 | mgeary | heh |
| 16:56.01 | beandog | bean dog @ foo bar.com |
| 16:56.03 | beandog | :) |
| 16:57.48 | beandog | mmm, Twix for breakfast. |
| 16:57.53 | beandog | Its how you start a day. |
| 16:58.12 | mgeary | ugh |
| 17:17.32 | olds | _psychic_: looks like we signed Dr Goals |
| 17:17.37 | olds | from Scotland |
| 17:18.35 | _psychic_ | yessir |
| 17:18.44 | _psychic_ | he's got one on YouTube |
| 17:18.49 | _psychic_ | that's pretty decent |
| 17:18.52 | _psychic_ | gutsy short side shot |
| 17:19.40 | olds | yea |
| 17:19.47 | olds | big guy |
| 17:19.51 | olds | for once |
| 17:20.19 | _psychic_ | yeah exactly |
| 17:20.29 | _psychic_ | maybe someone will finally be able to get a head on that ball |
| 17:20.32 | _psychic_ | besides Eddie |
| 17:20.41 | olds | yea |
| 17:20.47 | _psychic_ | especially given how crappy our corners are |
| 17:20.50 | olds | maybe we'll score more than 2 goals off of corners |
| 17:21.06 | olds | in the 2006 season I think we had 1 goal off of a corner |
| 17:21.17 | olds | I think it was 3 or 4 last season |
| 17:21.54 | _psychic_ | this dude scored like 10 last season I think |
| 17:22.03 | _psychic_ | for Div I scottish team |
| 17:22.04 | olds | yea |
| 17:22.08 | olds | good pick up |
| 17:22.43 | dataw0lf | you guys see the debate last night |
| 17:23.06 | PoeticIntensity | nah.... was it good |
| 17:23.06 | PoeticIntensity | ? |
| 17:23.20 | dataw0lf | yea, I loved it |
| 17:23.27 | jsmith | I heard Hillary got all huffy |
| 17:23.51 | dataw0lf | yea she did |
| 17:23.57 | mindjuju | did Nader participate? |
| 17:23.59 | dataw0lf | it was Obama's best debate to date |
| 17:24.01 | olds | lol |
| 17:24.09 | _psychic_ | nader.. |
| 17:24.54 | dataw0lf | Nader isn't of any consequence |
| 17:25.10 | dataw0lf | He barely was a blip on the radar in 2004. He'll be even less of one come the 08 general election. |
| 17:25.13 | unum | he's not a democrat so he wouldn't be in the democratic debate |
| 17:25.33 | dataw0lf | yea I think it was a joke unum. |
| 17:26.52 | PoeticIntensity | I might be opening up a can-o-worms, here, but the question is honest.... |
| 17:26.59 | PoeticIntensity | dataw0lf, what do you think of national health care? |
| 17:27.36 | dataw0lf | I believe everyone should be provided a way to get healthcare, either by driving down costs or mandating it. |
| 17:27.55 | PoeticIntensity | hehe.... |
| 17:28.00 | dataw0lf | that's not even my position, that's my Mother's position as a doctor, and I respect her expertise in dealing with HMOs and healthcare |
| 17:28.14 | PoeticIntensity | understood. |
| 17:28.24 | PoeticIntensity | that's a tough one for me, personally... |
| 17:28.35 | PoeticIntensity | I believe it should be much, much easier to get it than it currently is... |
| 17:29.09 | PoeticIntensity | but going with national health care, to me, in the long term would bring system's standards lower. |
| 17:29.58 | PoeticIntensity | and more than anything now, I'm concerned with the way the feds are *completely* disgregarding any sort of budgeting practice... |
| 17:30.31 | PoeticIntensity | spending like they're rich, when in fact, we're so far in the hole, we're almost coming out the other side. :) |
| 17:30.41 | dataw0lf | you can balance the budget and still provide an easy means for healthcare |
| 17:30.51 | PoeticIntensity | too true.... |
| 17:31.05 | dataw0lf | remember, it took a democrat to balance the budget last time.... and a republican to completely ruin it... |
| 17:31.36 | dataw0lf | http://www.tnr.com/politics/story.html?id=4d40a39e-8f57-4054-bd99-94bc9d19be1a |
| 17:31.37 | PoeticIntensity | anywho, I just thought I'd pry a bit. |
| 17:31.44 | dataw0lf | Excellent story on Obama's economic strategy |
| 17:31.50 | _psychic_ | speciallly when you've just blown 3 trillion bux on killing iraqis |
| 17:32.20 | dataw0lf | and billions on developing advanced new nextgen weapon systems while your soldiers STILL DON'T HAVE ARMOR |
| 17:32.46 | _psychic_ | exactly |
| 17:32.56 | _psychic_ | that rail gun is pretty freaking cool though :) |
| 17:33.00 | dataw0lf | I mean is that the republican legacy? You handout cash to defense corporations and screw the foot soldiers?? |
| 17:33.06 | dataw0lf | so p.o.ed about that |
| 17:33.11 | _psychic_ | it's the GW legacy at least |
| 17:33.30 | dataw0lf | well McCain is coming sharply in line with the Bush presidency on about every issue |
| 17:33.34 | dataw0lf | and he's the republican nominee |
| 17:33.35 | dataw0lf | so... |
| 17:33.41 | beandog | theres no way a rep is gonna win |
| 17:33.47 | dataw0lf | oh, no doubt |
| 17:33.52 | beandog | thank goodness. |
| 17:33.57 | dataw0lf | unless Hillary can somehow pull the nom and even then it's a long shot |
| 17:34.55 | _psychic_ | I wonder why people can't realize that coming in line with the Bush administration is political suicide. |
| 17:34.58 | dataw0lf | but unless Obama personally flies over to Afghanistan, picks up 100 Al-Qaida suicide bombers, and looses them on the streets of Washington D.C., he'll destroy McCain |
| 17:35.03 | _psychic_ | lol |
| 17:35.16 | dataw0lf | actually, it'd probably have to be 1000 suicide bombers |
| 17:43.14 | unum | aaah but dc can't vote |
| 17:43.30 | unum | now if released them on new york... |
| 17:43.37 | SunSparc | thebigdog: In case you need some mana -> http://www.thinkgeek.com/caffeine/drinks/a273/?cpg=68T |
| 17:44.01 | dataw0lf | well I think an attack by 1000 terrorists on D.C. would have an overarcing effect on the election as a whole |
| 17:45.11 | *** join/#uphpu bradym (n=bradym@63-197-255-78.ded.pacbell.net) |
| 17:45.11 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 17:51.29 | timinator | that mana is freakin' cool man!!! |
| 17:53.39 | SunSparc | :) |
| 17:53.40 | SunSparc | hehe |
| 17:54.38 | SunSparc | Use it wisely. If you drink it too quick you may not have enough to replenish your mana at a critical point during combat. |
| 17:54.39 | SunSparc | ;) |
| 17:57.04 | timinator | LOL fo sho |
| 17:57.41 | influx^^ | muh? |
| 17:57.48 | timinator | anyone want to go in w/ me on a case? |
| 17:57.55 | influx^^ | Case of mana? |
| 17:57.59 | timinator | I'd like to try one out |
| 17:58.00 | influx^^ | Blue, red or black? |
| 17:58.00 | timinator | ya |
| 17:58.05 | timinator | whatever |
| 17:58.08 | influx^^ | or green or white? |
| 17:58.09 | timinator | doesn't matter to me |
| 17:58.42 | timinator | LOL |
| 17:59.30 | influx^^ | ... |
| 18:00.46 | mgeary | hey, timinator was it you that tipped me off to T-mobile's prepaid phone plan? |
| 18:01.31 | mgeary | you guys might enjoy this: my wife's phone went through the laundry (don't ask). So she needed a replacement. So the other night, i swing my the T-mobile store on my way home |
| 18:02.19 | mgeary | so, my contract has run it's course, so we're eligible for the full "discount" on any phone they have. so i say, "look, i believe a phone should just be a phone, so what's the simplest, cheapest phone i can get with my discount?" |
| 18:02.40 | timinator | don't think so.... I've heard of it, but don't remember recommending it to anyone |
| 18:02.43 | timinator | *shrug |
| 18:02.48 | mgeary | the guy says, "well, we've got a stripped down one that is $69.95 with your discount" |
| 18:03.12 | mgeary | then i say, "ok, hey, so i've been thinking of getting one of those prepaid phone plans...uh, for my sister. Tell me about those" |
| 18:03.40 | mgeary | he says, "ah, ok, well you can get a starter kit for $29. It comes with 10 minutes and the phone, and there's no contract, and you just buy more minutes whenever you want" |
| 18:04.10 | mgeary | so i say, "humm, okay. Well, yeah, look, i need a replacement SIM for my wife's phone" |
| 18:04.16 | mgeary | no problem. i get the replacement SIM |
| 18:04.39 | mgeary | then i say, "yeah, so i'm gonna hold off on getting a new phone, but i think i will go ahead and get a prepaid phone thing... for my sister" |
| 18:05.39 | _psychic_ | hehe |
| 18:05.54 | _psychic_ | mobile phone plans are a racket |
| 18:06.08 | _psychic_ | people that give me free voice minutes but charge for text messaging |
| 18:06.12 | _psychic_ | you gotta be joking |
| 18:09.51 | PoeticIntensity | phone plans are all about the gimmicks. |
| 18:09.56 | orsonj | that was me that mentioned it to you |
| 18:10.00 | orsonj | awsome deal |
| 18:10.01 | mgeary | orsonj: ah, right |
| 18:10.06 | mgeary | but you got yours for $10, no? |
| 18:10.12 | orsonj | $20 |
| 18:10.18 | mgeary | by opting out of the minutes? |
| 18:10.37 | orsonj | probably just a different store pricing |
| 18:10.43 | mgeary | ah |
| 18:11.05 | mgeary | anyway, it was almost sad the the sales guy didn't see what i was doing |
| 18:11.11 | orsonj | heh |
| 18:11.12 | SunSparc | mgeary: That is ridiculous that their cheapest was $70 yet they sell a kit for $30 that has a phone in it. |
| 18:11.17 | mgeary | exactly |
| 18:11.36 | orsonj | $70 _with_ the discount. |
| 18:11.47 | SunSparc | Did you make the switch in front of him? that would be funny |
| 18:11.58 | mgeary | heh. no |
| 18:14.41 | tierra | I'm confused... what happened? |
| 18:16.24 | mgeary | ? |
| 18:18.38 | orsonj | tierra: he asked how much it would cost to get a replacement phone for his wife ($70), then how much to get a prepaid phone ($30). He got the prepaid, then switched sim cards. saved $40. |
| 18:19.12 | orsonj | he also has a phone number he can use for <10min phone prank calls. |
| 18:19.18 | mgeary | woot |
| 18:19.37 | tierra | with the sim from the broken phone? |
| 18:19.44 | orsonj | no, from the prepaid |
| 18:19.51 | mgeary | right. i got the broken sim replaced for free |
| 18:20.54 | tierra | ah |
| 18:21.55 | orsonj | http://www.youtube.com/watch?v=154gkNGmRaM <- my wife just sent me this (Bands/cheerleaders goofing up) |
| 18:23.53 | orsonj | the last one is the best |
| 18:24.50 | _psychic_ | ouch |
| 18:26.07 | SunSparc | ouch is right |
| 18:29.17 | wps | nothing like a little wet grass to make things exciting |
| 18:30.36 | PoeticIntensity | ROFL |
| 18:30.39 | PoeticIntensity | oh man..... |
| 18:30.42 | PoeticIntensity | that was hilarious... |
| 18:30.48 | PoeticIntensity | thanks, orsonj ! |
| 18:31.01 | orsonj | your welcome |
| 18:32.25 | orsonj | s/your/you're better |
| 19:03.12 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 19:03.12 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 19:05.12 | *** join/#uphpu fungus_ (n=fungus@bromine.sosstaffing.com) |
| 19:15.28 | *** join/#uphpu opapo (n=root@www.alpine.k12.ut.us) |
| 19:15.40 | opapo | how do you install phpize? |
| 19:15.55 | opapo | I type phpize and it says command not found |
| 19:17.13 | dataw0lf | opapo: what type of system? |
| 19:17.20 | dataw0lf | it's usually in a php dev package |
| 19:17.29 | dataw0lf | php5-dev contains it on Ubuntu/Debian systems. |
| 19:18.44 | dataw0lf | (also, connecting to IRC as root, if that's indeed what you're doing, is not smrt) |
| 19:18.44 | *** join/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 19:18.44 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 19:21.08 | opapo | ubuntu 7.10 |
| 19:21.13 | opapo | php5 |
| 19:21.20 | opapo | I will look at php5-dev |
| 19:23.37 | dataw0lf | there you go |
| 19:24.03 | mgeary | yeah, you need php-dev |
| 19:35.31 | mindjuju | where be cole_joplin ? |
| 19:37.34 | mgeary | and brasto |
| 19:37.50 | mindjuju | yeah, where is brasto? |
| 19:38.01 | mindjuju | heya mgeary - quick question |
| 19:38.03 | mgeary | ? |
| 19:38.17 | mindjuju | how hard would it be to build a flash countdown timer in flash |
| 19:38.29 | mindjuju | where i specify the time to countdown from, from a param |
| 19:38.49 | mgeary | i've got one of those around here somewheres |
| 19:39.09 | mindjuju | oh cool! i was googling for some tuts |
| 19:39.14 | mindjuju | but hadn't found anything quite yet |
| 19:39.31 | mgeary | do you have some flexibility as to how the reference date is specified/passed to flash? |
| 19:39.47 | mindjuju | yeah |
| 19:40.05 | mgeary | http://dpaste.com/37086/ |
| 19:40.33 | mgeary | counts down in days, hours, minutes & secs |
| 19:40.43 | mindjuju | awesome! thx! |
| 19:40.54 | mgeary | you use it like this, iirc: |
| 19:41.28 | mgeary | var countdown_obj = new Countdown(reference_to_dynamic_text_instance,flash_compliant_date) |
| 19:41.48 | mgeary | and then you need to call startCountdown() when you want it actually start |
| 19:41.53 | mgeary | fwiw |
| 19:42.32 | mindjuju | i really need to stop putting off learning AS3 and just get it done |
| 19:42.45 | mindjuju | especially with Air launching yesterday |
| 19:42.53 | mgeary | heh. likewise :) |
| 19:45.39 | SunSparc | Very cool stuff. |
| 20:05.17 | synic | they need to release flex for linux already |
| 20:06.53 | SunSparc | Eclipse |
| 20:07.01 | SunSparc | Already works on Linux |
| 20:19.33 | synic | yeah, and there's a beta plugin for flex development, but it's nothing compared to what you can get on winders |
| 20:23.10 | mgeary | anyone aware of a 2-way hash from the mhash extension? |
| 20:23.26 | mgeary | or the hash extension |
| 20:24.03 | mgeary | looks like they're all one-way |
| 20:25.18 | jsmith | mgeary: rot13! |
| 20:25.22 | mgeary | totally |
| 20:25.50 | mgeary | thought i had mcrypt on my dev machine. turns out i don't. grrrr |
| 20:35.59 | *** join/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 20:52.16 | wps | anyone know why 'clear' doesn't work within MySQL monitor? |
| 20:52.31 | wps | it's listed as a command within the help doc, but doesn't work |
| 21:04.25 | *** join/#uphpu swb (n=designsi@box324.bluehost.com) |
| 21:04.25 | *** mode/#UPHPU [+v swb] by ChanServ |
| 21:06.50 | swb | herlo, what was that irssi plugin you were showing me before? |
| 21:09.08 | olds | irssi++ |
| 21:13.48 | mgeary | wps: have you tried just doing Ctrl-L |
| 21:13.48 | mgeary | ? |
| 21:15.08 | wps | I'm on Mac OS |
| 21:15.16 | mgeary | so am i |
| 21:15.30 | wps | oh… look at that |
| 21:15.32 | wps | :) |
| 21:15.33 | wps | it works |
| 21:15.36 | wps | thanks man |
| 21:15.55 | mgeary | CMD-K is also useful. it completely clears the terminal buffer |
| 21:16.06 | wps | yeah, I use command + k a lot |
| 21:16.27 | wps | but some times you just want to clear the screen and not the entire buffer |
| 21:16.45 | mgeary | right |
| 21:32.49 | swb | is it better to use <?php vs <? in general, or are they exactly the same? |
| 21:36.09 | bradym | for code portability, <?php is better as it is possible to turn off <? in php.ini |
| 21:36.38 | swb | thanks bradym |
| 21:36.54 | bradym | np |
| 21:42.39 | PoeticIntensity | swb, I agree with bradym |
| 21:42.48 | PoeticIntensity | <?php is the better choice. |
| 21:43.11 | PoeticIntensity | and if you use <? alone, you won't know it's bad until it breaks the code. |
| 21:43.21 | swb | thanks PoeticIntensity |
| 21:43.44 | swb | it makes sense |
| 21:43.45 | PoeticIntensity | how goes the new job, anyway, swb? |
| 21:43.51 | swb | very good! |
| 21:43.54 | PoeticIntensity | first week, eh'? |
| 21:43.56 | PoeticIntensity | awesome! |
| 21:44.18 | swb | just trying to get a handle on everything... I am new to ecomm on a large scale |
| 21:44.54 | swb | also, am used to be able to do things how I want w/o having to jump into someone else's code |
| 21:45.18 | swb | but I LOVE having another developer to work with (am used to coding alone) |
| 21:47.16 | swb | you guys heard of pandora.com? |
| 21:47.37 | wps | yeah… pretty cool |
| 21:47.37 | SunSparc | pandora.com rocks |
| 21:47.47 | SunSparc | Although, mindjuju thinks it is scary. |
| 21:48.42 | SunSparc | Team coding is awesome. Once you get into it, it is hard to go back. |
| 21:48.48 | *** join/#uphpu nickwebcoukok (n=chatzill@host86-163-17-247.range86-163.btcentralplus.com) |
| 21:48.54 | nickwebcoukok | a quick one for ya's - im setting up a webpage, with 8 submit bottons, all individually named. im retrieving a list of user permissions from mysql, in the form of 11001011, where 1 is allowed, and 0 is not allowed. Whats the best way to dump that into a split array, so that each button carries a if 0 echo disabled, if 1 do nothing? |
| 21:49.22 | swb | SunSparc, yeah, I think it will really help my developer skills grow |
| 21:49.37 | SunSparc | swb: It really helped mine. |
| 21:50.18 | unum | wait you have all of the premisions in a char column? |
| 21:50.20 | nickwebcoukok | hang on, i think explode could do it for me :D |
| 21:51.15 | bradym | you're trying to explode 11001011? |
| 21:51.33 | unum | if str_split() is what you think you want |
| 21:51.46 | bradym | don't think that will work as is, need some kind of delimiter for explode |
| 21:52.26 | bradym | yeah, what unum said, str_split |
| 21:54.17 | nickwebcoukok | yeah, just realised that, |
| 21:54.23 | herlo | swb: probably nicklist |
| 21:54.30 | nickwebcoukok | gunna put it into the database as 1,1,1,0,0,1,0,1 etc |
| 21:54.33 | swb | herlo, that's it |
| 21:54.36 | swb | thanks |
| 21:54.44 | herlo | :) |
| 21:54.45 | nickwebcoukok | its primative, but it works :D |
| 21:54.46 | herlo | np |
| 21:54.48 | nickwebcoukok | thanks! |
| 21:57.21 | unum | nickwebcoukok: you really should rethink that |
| 21:57.35 | unum | what's wrong with 8 bool columns |
| 21:57.36 | wps | yeah, that sounds like a pain in the butt |
| 21:57.49 | wps | having to explode and implode that ever time |
| 21:57.50 | wps | yuck |
| 21:58.19 | wps | and what if you need to search by or order by one of the items |
| 21:58.31 | unum | plus having to read the documentation to figure out which one goes to which one |
| 21:58.35 | nickwebcoukok | unum: its for expandability - in case I, say, decide to add another button - i wont have to modify the db cause i'll fill that array with 0 unless theres a 1... |
| 21:58.44 | nickwebcoukok | hmm |
| 21:58.46 | nickwebcoukok | yeah |
| 21:58.48 | unum | you should modify the db |
| 21:58.48 | nickwebcoukok | maybes |
| 21:58.54 | mindjuju | dataw0lf, you around |
| 21:59.05 | unum | there's nothing wrong with adding a column later |
| 21:59.09 | unum | afaik |
| 21:59.18 | unum | I guess I'm not really a database expert |
| 21:59.29 | unum | but I do read thedailywtf :) |
| 21:59.33 | nickwebcoukok | in not either - or even a php one. lol |
| 22:00.21 | nickwebcoukok | so the best reccomendation is to add extra colums to the db - and just check each value. only one set of user permissions is retrieved. |
| 22:00.53 | nickwebcoukok | and then if a new colum is added, just modify the check? I'll prob write a quick function so i dont have a mass of php code at the end of each submit button. lol |
| 22:01.10 | dataw0lf | mindjuju: what up |
| 22:01.52 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 22:02.10 | mindjuju | hey - saw nickwebcoukok security schema, reminded me about something you talked about a long time ago. it was something mask, can't remember |
| 22:02.16 | mindjuju | but researched it and thought it was cool |
| 22:02.21 | mindjuju | what was that called? |
| 22:02.40 | mindjuju | when you have 1011001 as the security profile |
| 22:02.43 | unum | nickwebcoukok: you can select all of the columns at once and they are automatically an array |
| 22:02.52 | mindjuju | where each col was an off or on for a particular web area |
| 22:02.56 | mindjuju | v extensible |
| 22:02.59 | unum | assuming you use the right function to the query |
| 22:07.11 | nickwebcoukok | hmm |
| 22:07.14 | nickwebcoukok | mask? |
| 22:07.26 | mindjuju | yeah, comes from C |
| 22:07.58 | mindjuju | like you say, v extensible, but AFAIK not commonly used |
| 22:08.06 | dataw0lf | mindjuju: BITMASK? |
| 22:08.15 | mindjuju | yup, that was it, bitmask |
| 22:08.22 | dataw0lf | yea, easy binary arithmetic for security bitmasks |
| 22:08.38 | dataw0lf | that's the way, uh huh uh huh, I like it! |
| 22:09.39 | mindjuju | nickwebcoukok - there is a really good wiki article on it |
| 22:09.52 | nickwebcoukok | jus googled it |
| 22:09.53 | mindjuju | and i might have a web page on it that dataw0lf sent over on how to implement |
| 22:10.14 | mindjuju | but, if i had had the time, I would have implemented it |
| 22:12.41 | mindjuju | nickwebcoukok - if you get a chance, read this on bit mask - http://en.wikipedia.org/wiki/Bit_mask |
| 22:12.47 | mindjuju | it gives good background |
| 22:13.01 | mindjuju | wasn't able to find the tut on bit mask and PHP, but i'm sure they are out there |
| 22:16.46 | nickwebcoukok | yup |
| 22:16.54 | nickwebcoukok | read that, and im reading some other documents now. |
| 22:17.16 | nickwebcoukok | looks slightly complicated, but something I think will stand good in the long run (if only to look even 1337'er.. lmao!) |
| 22:17.21 | mindjuju | i love that intro where they talk about extracting that info out of the fifth col without having to explode or anything |
| 22:26.37 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 22:26.37 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 22:52.47 | *** part/#uphpu cole_joplin (n=cjoplin@gw.helius.com) |
| 22:53.13 | Utah_Dave | mindjuju: I use bitmasks every day in PHP |
| 22:53.18 | Utah_Dave | They rock |
| 22:53.35 | mindjuju | yeah, they look really cool |
| 22:54.04 | Utah_Dave | we keep user rights and stuff in there. Makes it really easy and fast for our admin/authntication library |
| 23:12.32 | nickwebcoukok | Utah_Dave: how difficult was it for you to impliment? |
| 23:15.24 | macnewbold | bitmasks rock, and they're easy |
| 23:16.03 | nickwebcoukok | http://www.phpbuilder.com/columns/eric_potvin20060809.php3 <-according to that, theyre VERY easy |
| 23:16.30 | mindjuju | hmmm PHP and Bit Masks - the sexy side of life :: a presentation by Mac Newbold |
| 23:16.38 | mindjuju | what do you think macnewbold ? |
| 23:17.45 | macnewbold | they're most useful when you are really needing to save space |
| 23:18.07 | macnewbold | for example, a bit mask is really just a set of boolean (true/false or 0/1) values |
| 23:18.24 | macnewbold | you can fit 8 of those in a short integer, or 16 in a 2-byte integer |
| 23:18.44 | macnewbold | or you could do them each as tiny ints (8 bits, 1 byte) and give them a name, |
| 23:18.55 | macnewbold | or you can pack a bunch of switches into a bit field, and fit 8 switches in 1 byte |
| 23:19.51 | macnewbold | bit 1 is the 1's place, 0 or 1, bit 2 is the twos slot, 0 or 2, bit 3 is the four slot, 0 or 4, then 0 or 8, 0 or 16, etc |
| 23:20.09 | macnewbold | so between 0 and 255 you can fit every possible combination of 8 independent switches |
| 23:20.20 | macnewbold | and all you have to do is look at the number, and see which bits are turned on |
| 23:20.33 | macnewbold | no, it's not enough to do a whole presentation on |
| 23:20.57 | mindjuju | i'm totally teasin' |
| 23:21.05 | macnewbold | but maybe you could convince someone to write up a short article or somethin and send it out to the list for discussion |
| 23:21.16 | macnewbold | or post it to the website if you don't want anyone to read it ;) |
| 23:21.48 | macnewbold | ~greet undertakingyou |
| 23:21.48 | jbot | ACTION dumps a bucket of cold oatmeal on undertakingyou |
| 23:26.50 | olds | we use them all the time |
| 23:27.34 | nickwebcoukok | what would be the limit on the ampount u could put in the bit field? i.e back to the problem. theres 10 buttons, a user can have permissions to click certain buttons, otherwise a disabled text is added to the button. So for 10 buttons, i would need 11 bits (One is always 0). reading thru some articles, it appears like theres a limit of 8 bits tho.. |
| 23:27.34 | olds | particularly with permissions |
| 23:28.38 | olds | don't think so |
| 23:28.55 | olds | I belive you don't need to be worried unless you're going above 32 bits |
| 23:31.52 | *** join/#uphpu mgeary (n=mgeary@72.8.120.115) |
| 23:31.52 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 23:32.00 | mgeary | heya |
| 23:32.09 | unum | heya |
| 23:33.16 | mgeary | i've got a mysql field that's a varchar that i need to reformat to a date field. The field has month/year values (07/09) and i need to convert them to, e.g. 2009-07-01. Anyone have a mysql-only tip before i write a php script? |
| 23:33.39 | beandog | Ive got a tip |
| 23:33.42 | beandog | use postgres. |
| 23:33.43 | beandog | :) |
| 23:33.48 | jsmith | beandog: Good one! |
| 23:33.54 | jsmith | ~highfive beandog |
| 23:33.59 | beandog | mgeary, you should be able to do substrings to replace the data |
| 23:34.02 | mgeary | ha. ha. |
| 23:34.02 | beandog | jsmith, ^5 |
| 23:34.18 | beandog | or you can do a split on the strong |
| 23:34.26 | beandog | string |
| 23:35.02 | beandog | mgeary, just look for the string manipluation things |
| 23:35.27 | mgeary | yeah |
| 23:38.25 | jsmith | And don't forget to wrap the whole thing in a transaction... |
| 23:40.10 | mgeary | select CONCAT(20,SUBSTR(cc_expire,4,2),'-',SUBSTR(cc_expire,1,2),'-01') from customers where cc_expire != '' |
| 23:40.26 | beandog | there ya go |
| 23:40.30 | beandog | assuming they are all padded. |
| 23:40.34 | mgeary | yep |
| 23:40.38 | mgeary | and yeah, the are |
| 23:40.42 | mgeary | s/the/they/ |
| 23:51.08 | nickwebcoukok | okies, using http://www.gen-x-design.com/archives/bitmasks-emulate-unix-permissions-in-php , i've pretty much got the hang of it in a practical sense, however i'll have to play about with it to figure out the real theory behind it. it works tho! lol. One quick question, in the example given, they list 0 as having a permission, ive ommited this from my code, cause i cant add 0 to a number, am... |
| 23:51.09 | nickwebcoukok | ...i right in doing that, or should i read up on it a bit more? |
| 23:56.05 | mgeary | how can i duplicate a line in vi? |
| 23:56.15 | SunSparc | yy then p |
| 23:56.32 | mgeary | thanks |
| 23:56.36 | SunSparc | np |