| 00:04.04 | *** join/#uphpu influx^^ (i=influx@67.137.218.51) |
| 00:04.04 | *** mode/#UPHPU [+v influx^^] by ChanServ |
| 00:15.02 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 00:15.02 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 00:29.36 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 00:59.03 | *** join/#uphpu wps (n=wps@208.53.47.251) |
| 00:59.03 | *** mode/#UPHPU [+o wps] by ChanServ |
| 01:30.25 | *** join/#uphpu thebigdog (n=thebigdo@zeus.thebigdog.biz) |
| 01:30.26 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 01:52.21 | thebigdog | is everyone at home now |
| 02:31.28 | *** join/#uphpu josephscott (n=josephsc@63-228-200-73.slkc.qwest.net) |
| 02:31.29 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 02:58.23 | *** join/#uphpu Jacob_Kerr (n=Jacob_Ke@72.25.165.83) |
| 03:02.25 | Jacob_Kerr | Hey guys! Is it possible to do a mathmatical equation in a MySQL query? Can I do something like: SELECT * FROM items WHERE price/quantity>.65 (so that's price divided by quantity is greater then .65) :) |
| 03:13.52 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 03:13.52 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 03:26.08 | thebigdog | Jacob_Kerr: you should be able to do something like that |
| 03:26.27 | Jacob_Kerr | K, thanx.. |
| 03:26.28 | thebigdog | you might need to do (price/quantity) > .65 |
| 03:26.48 | Jacob_Kerr | MySQL is so much more poweful then I use to think it was.. |
| 03:26.57 | thebigdog | you should try pgsql |
| 03:27.07 | thebigdog | there is real power :) |
| 03:27.24 | Jacob_Kerr | Yeah I may after I get MySQL down.. |
| 03:27.42 | Jacob_Kerr | I need to get joins down, those rock! |
| 03:27.46 | Jacob_Kerr | save me a lot of time.. |
| 03:30.01 | thebigdog | yeah ping us here with your questions |
| 03:30.28 | beandog | thebigdog++ |
| 03:30.36 | thebigdog | hehe |
| 03:30.57 | orsonj | does that make it thebiggerdog? |
| 03:32.00 | thebigdog | the biggest dog |
| 03:32.05 | Jacob_Kerr | Well I almost have my join down but I am working on a cart that setup their categories for an item like this: 7->0|8->0|21->0 |
| 03:32.21 | thebigdog | what is that |
| 03:32.31 | thebigdog | man sometimes i wonder what is up wiht developers |
| 03:32.43 | Jacob_Kerr | The first number before the arrow is the cat number.. |
| 03:32.52 | Jacob_Kerr | which is all I need to mess with right now.. |
| 03:33.11 | Jacob_Kerr | so the example I gave means that product is in cat number: 7,8 and 21 |
| 03:33.48 | Jacob_Kerr | is it even possible to break that down and make it work with this query: SELECT * FROM items INNER JOIN itemattributes ON table1.itemid=table2.id WHERE table1.categories |
| 03:34.43 | Jacob_Kerr | see I do not even know what to do after table1.categories LOL. I was going to try to use a LIKE statement but I do not think that will do the trick. |
| 03:35.00 | beandog | where cat in (1,2,3)? |
| 03:35.06 | beandog | is that what you want |
| 03:35.30 | Jacob_Kerr | This is how the cats are saved: 7->0|8->0|21->0 |
| 03:35.48 | Jacob_Kerr | so that item is in cat: 7,8 and 21 |
| 03:36.27 | Jacob_Kerr | do you know of a way to break that down in a MySQL query? |
| 03:39.43 | beandog | uh, dunno, Im kinda lost. |
| 03:44.05 | Jacob_Kerr | Well I'm outa here.. |
| 03:44.13 | Jacob_Kerr | Thanx for your help :) Take care you guys.. |
| 03:48.20 | wps | that's whacked |
| 03:48.31 | wps | it looks like the developer was saving arrays in a DB |
| 03:50.42 | thebigdog | really weird |
| 03:51.13 | beandog | yah I wasnt sure if I was reading that right |
| 03:51.21 | beandog | dont really have the energy to find out |
| 03:51.45 | thebigdog | some developers have some crazy ideas about storing data in a db |
| 03:53.39 | *** join/#uphpu mindjuj1 (n=mindjuju@76.8.222.130) |
| 03:55.50 | *** join/#uphpu ChanServ (ChanServ@services.) |
| 03:55.50 | *** mode/#UPHPU [+o ChanServ] by irc.freenode.net |
| 03:59.15 | beandog | thebigdog, I think its more just along the lines of being a noob |
| 03:59.32 | thebigdog | that too |
| 03:59.38 | thebigdog | i hate fixing stuff like that |
| 04:20.05 | *** join/#uphpu undertakingyou (n=will@undertakingyou.dsl.xmission.com) |
| 09:43.31 | *** join/#uphpu ChanServ (ChanServ@services.) |
| 09:43.32 | *** mode/#UPHPU [+o ChanServ] by irc.freenode.net |
| 12:47.58 | *** join/#uphpu nei_rauni (n=nei@201.22.63.117.adsl.gvt.net.br) |
| 14:09.13 | *** join/#uphpu mrkrow (n=Chad@166.70.178.114) |
| 14:22.59 | *** join/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 14:22.59 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 14:26.35 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 14:26.35 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 14:43.09 | Utah_Dave | Wow. Our internal network doesn't touch the internet. Our shop has been hard coding IP addresses into everything for years. From long before I got here. |
| 14:43.45 | Utah_Dave | We just moved and upgrade a bunch of servers and our "Network Admin" came up with this great idea of putting the IP address in our DNS |
| 14:44.02 | Utah_Dave | "It will make moving the users over to the new server so much easier!" he said |
| 14:44.14 | Utah_Dave | "just switch the IP in the DNS!" |
| 14:44.43 | Utah_Dave | I told him he should have invented that like 20 years ago! |
| 14:46.59 | orsonj | heh |
| 14:49.39 | *** part/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 14:49.45 | *** join/#uphpu Utah_Dave (n=David_Bo@72-166-51-162.dia.static.qwest.net) |
| 14:49.45 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 14:51.08 | *** join/#uphpu fungus (n=olsonl@fungus.broker.freenet6.net) |
| 14:51.08 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 14:51.31 | *** join/#uphpu thebigdog (n=thebigdo@0006yE-Yn.dsl.xmission.com) |
| 14:51.31 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 14:53.54 | *** join/#uphpu Jacob_Kerr (n=Jacob_Ke@72.25.165.83) |
| 14:55.23 | Jacob_Kerr | Does anyone know a good REGEXP for finding 35 in 5->0|35->0|22->0 (35 can be anyone of the before the ->) and it can not match 235 or 035 etc.. :) |
| 14:58.29 | *** join/#uphpu wps (n=wps@64.0.192.94) |
| 14:58.29 | *** mode/#UPHPU [+o wps] by ChanServ |
| 15:06.16 | Jacob_Kerr | I have a solution to my above questions... |
| 15:06.23 | orsonj | is that "5->0|35->0|22->0" or array("5->0","35->0","22->0) or array('5'=>'0','35'=>'0','22'=>'0') |
| 15:06.32 | orsonj | oh, what did you do? |
| 15:07.16 | orsonj | kick the person who wrote it in the pants? |
| 15:09.11 | *** join/#uphpu brasto (n=brasto@166.70.44.49) |
| 15:09.11 | *** mode/#UPHPU [+v brasto] by ChanServ |
| 15:16.48 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 15:16.48 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:17.28 | brasto | moanin, yawl |
| 15:20.31 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 15:20.31 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 15:21.28 | Jacob_Kerr | Hey guys do I have to escape anything when using the following expression with REGEXP?? [^0-9]*35-> |
| 15:25.44 | mgeary | don't think so |
| 15:25.50 | mgeary | not working the way you want? |
| 15:26.26 | Jacob_Kerr | Do you guys think this query will work :) SELECT * FROM items INNER JOIN itemattributes ON table1.itemid=table2.id WHERE table1.categories REGEXP '[^0-9]*35->' |
| 15:26.56 | mgeary | well, not like that it won't |
| 15:27.13 | Jacob_Kerr | dang, sigh.... |
| 15:27.15 | mgeary | because your select tables aren't in your FROM |
| 15:27.18 | jsmith | Don't you want to replace table1 with items and table2 with itemattributes |
| 15:27.22 | mgeary | right |
| 15:28.50 | Jacob_Kerr | OH I C so like this? SELECT * FROM items INNER JOIN itemattributes ON items.itemid=itemattributes.id WHERE items.categories REGEXP '[^0-9]*35->' |
| 15:29.17 | mgeary | better |
| 15:29.25 | Jacob_Kerr | I still have lots to learn about MySQL hehe... |
| 15:29.36 | Jacob_Kerr | thanx. |
| 15:39.53 | *** join/#uphpu SunSparc (n=sparky@66.7.114.125) |
| 15:39.53 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 15:43.09 | macnewbold | ~celebrate |
| 15:43.10 | jbot | ACTION dances around firing six-shooters in the air |
| 15:45.27 | macnewbold | so if Code Greene were to host some "Geek Fun" or "Family Fun" times here at the office, what times and days of the week would best allow those interested to attend? |
| 15:45.33 | macnewbold | ~seen mindjuju |
| 15:45.36 | jbot | mindjuju <n=mindjuju@76.8.222.130> was last seen on IRC in channel #uphpu, 17h 35m ago, saying: 'here you guys, this may help - http://www.youtube.com/watch?v=1FeIF-7fhkE'. |
| 15:45.46 | macnewbold | ~rename mindjuj1 |
| 15:51.15 | *** join/#uphpu thinbegin (n=thinbegi@206.71.78.158) |
| 15:52.02 | *** join/#uphpu _psychic_ (n=_psychic@66.7.114.125) |
| 15:52.02 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 15:58.46 | *** join/#uphpu josephscott (n=josephsc@63-228-200-73.slkc.qwest.net) |
| 15:58.46 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 16:00.10 | Utah_Dave | macnewbold: Thursday evening or a Friday afternoon would work great for me! |
| 16:05.46 | *** join/#uphpu swb (n=designsi@box324.bluehost.com) |
| 16:05.46 | *** mode/#UPHPU [+v swb] by ChanServ |
| 16:06.29 | swb | is there a way to do a mysql query that will show a count of how many times each field is blank? |
| 16:06.43 | mgeary | blank? or null? |
| 16:06.51 | swb | both actually |
| 16:06.51 | thebigdog | yes |
| 16:07.11 | mgeary | you've got a schema that allows for both blanks AND nulls in a field? that's not good |
| 16:07.16 | thebigdog | select field from table where field == null or field == ''; |
| 16:07.27 | swb | the only way I know how to do it is select count(*) where fieldname = '' or fieldname is null |
| 16:07.29 | thebigdog | select (count) |
| 16:07.30 | swb | oh |
| 16:07.55 | mgeary | um, thebigdog, does mysql support == ? |
| 16:07.55 | thebigdog | you are correct |
| 16:08.04 | thebigdog | hehe no |
| 16:08.13 | thebigdog | im in the programming mind set still |
| 16:08.26 | mgeary | it *would* be nice if they were consistent |
| 16:09.34 | *** join/#uphpu timinator (n=timothy@c-98-202-102-189.hsd1.ut.comcast.net) |
| 16:09.35 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 16:09.56 | swb | what I really want is one query to show counts for all fieldnames that are blank (i.e. returns field 1 has 4 blanks, field 2 has 10 blanks, etc) |
| 16:10.23 | swb | I think I have to do a select count() for each field separately though, yes? |
| 16:13.24 | SunSparc | You can do count's on multiple fields at one time |
| 16:13.47 | SunSparc | Although probably not with the results you are hoping for. |
| 16:13.55 | swb | okay |
| 16:14.01 | swb | thnx guys |
| 16:15.03 | mgeary | swb: try doing a group by on that field |
| 16:15.20 | mgeary | oh |
| 16:15.30 | mgeary | yeah, if you're looking for multiple fields, it gets more complicated |
| 16:18.17 | thebigdog | you could do a union on the queries |
| 16:47.23 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 16:47.23 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 17:16.07 | *** join/#uphpu mindjuju (n=mindjuju@76.8.222.130) |
| 17:16.07 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 17:18.02 | mindjuju | ~APB macnewbold |
| 17:18.03 | jbot | ACTION calls Leland to spray mace at macnewbold |
| 17:24.32 | macnewbold | ~bonk mindjuju |
| 17:24.33 | jbot | ACTION bonks mindjuju over the head |
| 17:24.40 | macnewbold | how's it going? |
| 17:25.06 | mindjuju | going tired, you? |
| 17:25.13 | macnewbold | Utah_Dave: Thurs and Friday sound good to me too |
| 17:25.40 | macnewbold | if you're looking for fun on a Friday afternoon and want to stop by, please do! Even if we're not expecting company our guys are always up for a break. |
| 17:26.04 | Utah_Dave | sweet! |
| 17:26.15 | mindjuju | that is cool! |
| 17:26.34 | mindjuju | macnewbold PM |
| 17:28.41 | macnewbold | k |
| 17:33.20 | macnewbold | if anyone is bored after about 4pm today, and wants to drop by, we've guy a guy bringing in a Wii to use with the big screen hdtv+surroundsound |
| 17:33.29 | macnewbold | a little smash bros. and some wii sports at least |
| 17:44.40 | orsonj | Jacob_Kerr: perhaps REGEXP '^35->|[|]35->' |
| 17:46.30 | Jacob_Kerr | I found a good REGEXP, but thanx man :) |
| 17:46.56 | Jacob_Kerr | Working on a dif project now :) Force type directive search.. |
| 17:47.26 | orsonj | It looks like the one you mentioned would fail if it were at the beginning of the string. |
| 17:48.07 | orsonj | no, sorry, it might still let 035 or 235 in. |
| 17:48.40 | orsonj | but if it works in your tests, I guess that is what counts |
| 17:48.42 | Jacob_Kerr | Yeah REGEXP '[[:<:]]" . $category . "[[:>:]]-' |
| 17:49.04 | orsonj | ah, that would probably work. |
| 17:49.46 | Jacob_Kerr | Yeah I got it from someone in the MySQL room, I put togethe a query that saved me a ton of time. I'm starting to fall in love with MySQL tehehehe.... |
| 17:51.44 | Jacob_Kerr | Now I'm scratching my head trying to figure out how to pull data from one column and put them all into an array but I do not want any duplicates. For instances there's a body field for all these cars that are saved in the database and I want to print out all the body types but each row has a body type set in it which is dumb I think but whatever... |
| 17:52.02 | Jacob_Kerr | there's a DISTINCT or something right? |
| 17:53.52 | orsonj | I'm not too hot on sql myself, but the regex caught my attention. |
| 17:57.49 | *** join/#uphpu bradym (n=bradym@63-197-255-78.ded.pacbell.net) |
| 17:57.49 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 18:13.37 | mindjuju | for you email admins - Good News - if you have ORDB in your blacklist, you're clients aren't going to get any more email! - http://isc.sans.org/diary.html?storyid=4198&rss |
| 18:13.58 | unum | mindjuju: the sllug server was using that |
| 18:14.13 | mindjuju | heh |
| 18:14.35 | wps | how nice |
| 18:22.53 | mindjuju | for those who need a good laugh during lunch read this article about the top brass at MS and their reaction to Vista - http://tinyurl.com/29fr2g |
| 18:32.17 | mgeary | @$@#$@%!!@@@!! |
| 18:32.42 | mgeary | just as i got to the top of the queue in Auth.net's support, i suddenly got a 404 |
| 18:32.45 | mgeary | !@#@#@$%!@#! |
| 18:33.05 | mgeary | and now i'm back in... at 28 |
| 18:33.14 | mgeary | ~lart authorize.net yet again |
| 18:33.15 | jbot | drops a baby grand on authorize.net yet again |
| 18:38.59 | mindjuju | sorry to hear that mgeary! i've usually not had any problems with them |
| 18:39.18 | mgeary | just happened again |
| 18:42.15 | *** join/#uphpu mrkrow (n=Chad@166.70.178.114) |
| 18:43.06 | Jacob_Kerr | hey can you label a constructor __constructornator? |
| 18:43.19 | Jacob_Kerr | it can be any name as long as it has __ in front of it right? |
| 18:43.40 | Jacob_Kerr | oh and does this sound like a dial up to you? E OOO WEEE A A A A OOOO WEEEEE! |
| 18:44.06 | Jacob_Kerr | that's me connecting to my database. |
| 18:44.25 | mindjuju | nope, to me that sounds like an ambulance |
| 18:44.30 | Jacob_Kerr | LOL.. |
| 18:44.42 | Jacob_Kerr | what's a good dial up? |
| 18:45.41 | mindjuju | dial up sounds like <dialtone> beep beep chirp - beep beep beep beep <ring> // handshake commences |
| 18:45.41 | mindjuju | pshhhhhhhhhhhhhhhhh^^^^^^^^^ (same sound but one tone up) |
| 18:46.09 | mindjuju | then modem full connects and everything goes silent |
| 18:46.47 | Jacob_Kerr | LOL>. |
| 18:48.08 | Jacob_Kerr | Perfect.. |
| 18:59.14 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 19:08.31 | *** part/#uphpu mindjuju (n=mindjuju@76.8.222.130) |
| 19:10.03 | wps | I can't ever eat pudding without hearing Bill Cosby's voice in my head |
| 19:11.29 | *** join/#uphpu jnbek (n=jnbek@72.8.114.252) |
| 19:23.59 | SunSparc | Of all the voices you could have in your head, I would say that one is a good one to have. |
| 19:26.55 | wps | "mmm⦠da pudd'n" |
| 19:28.06 | SunSparc | :D |
| 19:28.23 | SunSparc | Bill Cosby for President! |
| 19:28.46 | wps | I'd probably actually vote for him |
| 19:29.16 | SunSparc | Cosby vs Obama -> Cosby+++ |
| 19:30.17 | SunSparc | If you had to pick one woman to be the next president, who would you pick? |
| 19:30.48 | wps | any besides someone who says that they were fired upon by snipers and actually wasn't |
| 19:31.34 | SunSparc | LOL, yeah, I saw that video. Oops! :) |
| 19:31.36 | wps | and especially anyone besides someone who says that they were fired upon by snipers and actually wasn't and then says that they "misspoke" when called out about it |
| 19:32.13 | _psychic_ | and so does the media |
| 19:32.21 | SunSparc | Ok, rephrased: If you had to pick one female movie star to be the next president, who would you pick? |
| 19:32.48 | wps | Kate Hudson |
| 19:33.10 | SunSparc | Just for hawtness factor or political views? |
| 19:33.17 | wps | she's hot |
| 19:33.30 | wps | I don't have a clue what she stands for |
| 19:33.35 | SunSparc | hehe, yeah, that is all that really matters in a woman president anyway. |
| 19:33.56 | SunSparc | (That was a joke, in case anyone takes it otherwise.) |
| 19:34.34 | wps | I doubt we would agree on political views thoughâ¦Â to make an assumption off of a generalization of the views of most stars |
| 19:36.26 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 19:36.26 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 19:37.56 | SunSparc | Most likely. |
| 19:45.19 | pelaofeli1 | PHP/mysqli question for y'all -- I've got a script that pulls a couple of hundred thousand rows from a table and iterates through 'em to dump data to a text file. Total data size is around 40MB. Simple, right? |
| 19:45.19 | pelaofeli1 | Here's my question: my PHP memory_limit is 2MB, yet it runs fine without complaint. Linux says the php process is using 50% of the 256 MB available memory. Do result sets not count as used memory? |
| 19:46.02 | pelaofeli1 | I'm not using the USE_RESULT result mode |
| 19:46.51 | wps | are you storing the entire thing in memory and then writing it out to the file at once or are you writing to the file line-by-line?? |
| 19:48.02 | pelaofeli1 | I'm just pulling the records in one at a time... but the data is still stored in memory as part of the result object |
| 19:48.17 | pelaofeli1 | ...I think? |
| 19:49.38 | pelaofeli1 | That's where my confusion comes in -- PHP seems to think it's not using that memory, but Linux says it is... I think PHP is lying somehow |
| 19:49.51 | beandog | no, that seems right |
| 19:49.58 | beandog | well, Im not sure. |
| 19:50.05 | beandog | the recordset should be the whole thing |
| 19:50.12 | beandog | well, hmm. |
| 19:50.31 | beandog | thats a good question. Fetching the row is a call to the database |
| 19:50.41 | beandog | I think. |
| 19:50.43 | beandog | who knows. |
| 19:50.50 | beandog | just use get_memory_usage() and find out |
| 19:51.06 | beandog | memory_get_usage() |
| 19:51.09 | pelaofeli1 | well, if you use the USE_RESULT method, it goes to the DB to get the next record |
| 19:51.09 | beandog | I always get that mixed up. |
| 19:51.41 | pelaofeli1 | ....but if you use STORE_RESULT, the entire result set comes over at once |
| 19:52.07 | pelaofeli1 | yeah -- memory_get_usage shows about 1 MB in use for the duration of the script |
| 19:52.23 | pelaofeli1 | ...which makes sense why the 2MB limit doesn't cause the script to die |
| 19:52.37 | beandog | ini_set('memory_limit', -1) |
| 19:52.39 | beandog | :) |
| 19:52.57 | pelaofeli1 | but I'm pretty sure the entire result set is coming over, and Linux seems to say so, too |
| 19:56.04 | *** join/#uphpu mgeary (n=mgeary@72.8.120.115) |
| 19:56.04 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 20:06.14 | macnewbold | ~seen herlo |
| 20:06.17 | jbot | herlo is currently on #utos #utah #uphpu #ubuntu-us-ut. Has said a total of 222 messages. Is idling for 1h 28m 17s, last said: 'Zelut: pm'. |
| 20:06.22 | macnewbold | ~seen Heartsbane |
| 20:06.23 | jbot | heartsbane is currently on #utos #utah #ubuntu-us-ut. Has said a total of 117 messages. Is idling for 1h 33m 32s, last said: 'Damn funniest thing I have heard all day logn'. |
| 20:08.50 | wps | anyone see anything wrong with my rewrites? |
| 20:08.50 | wps | http://rafb.net/p/H9SNs679.html |
| 20:08.57 | wps | I am getting an internal server error |
| 20:10.00 | SunSparc | wps: Try removing them one by one and see which one(s) is affecting you. |
| 20:11.13 | wps | weird |
| 20:11.28 | wps | it appears that the stuff in the brackets (conditions I think they are called) |
| 20:11.32 | wps | â¦cannot have spaces |
| 20:12.15 | SunSparc | You mean, "L, "? |
| 20:12.34 | wps | yeah |
| 20:12.46 | SunSparc | Good to know. Did the fix your problem? |
| 20:12.57 | wps | still errors, but it fixed one |
| 20:13.06 | SunSparc | Cool, good job |
| 20:13.32 | wps | it doesn't like this |
| 20:13.32 | wps | RewriteCond %{HTTP_cookie} cms_site_lang !^[1-11] |
| 20:15.02 | SunSparc | Is [1-11] a range between 1 and 11? |
| 20:15.21 | wps | any number between 1 and 11 |
| 20:15.34 | jsmith | Hmmmn... that's not a valid regex |
| 20:15.39 | jsmith | I thought it had to be a regex |
| 20:15.45 | wps | it does |
| 20:15.53 | SunSparc | Yeah, I was going to say, that does not seem like good regex, but I could be wrong |
| 20:16.08 | wps | oh, I think I need the slashes |
| 20:16.10 | wps | does this look better? |
| 20:16.11 | wps | !^/[1-11]/ |
| 20:16.24 | jsmith | No, it's the [1-11] that worries me |
| 20:16.39 | SunSparc | Can you do that? Or can it only be 0-9? |
| 20:16.41 | jsmith | It might work... it just doesn't look right to me |
| 20:17.06 | jsmith | You could try ([0-9]|10|11) |
| 20:17.08 | wps | The - (dash) inside square brackets is the 'range separator' and allows us to define a range, in our example above of [0123456789] we could rewrite it as [0-9 |
| 20:17.15 | wps | (from my cheatsheet |
| 20:17.20 | jsmith | wps: Right... but that's a *single digit* |
| 20:17.26 | wps | oh! |
| 20:17.30 | jsmith | wps: That saying a single digit is between 0 and 9 |
| 20:17.32 | wps | I see what you're waying |
| 20:17.34 | wps | saying |
| 20:17.34 | SunSparc | Yeah, I understand that, and you understand that.... |
| 20:17.35 | SunSparc | Right |
| 20:17.38 | wps | hmm |
| 20:17.39 | jsmith | right |
| 20:17.49 | jsmith | Try ([0-9]|10|11) |
| 20:19.48 | beandog | or ou could do 1?\d |
| 20:20.06 | wps | still barfs on: |
| 20:20.06 | wps | RewriteCond %{HTTP_cookie} cms_site_lang !^/([0-9]|10|11)/ |
| 20:20.22 | SunSparc | Take out those forward slashes |
| 20:20.38 | wps | still barfs |
| 20:21.00 | jsmith | take out the parentheses |
| 20:21.06 | jsmith | (and the slashes) |
| 20:21.15 | wps | still barfs |
| 20:21.20 | wps | sheesh |
| 20:21.28 | SunSparc | Is forward slash the proper escape character instead of backward slashes? |
| 20:21.46 | wps | ah-hah! |
| 20:21.48 | wps | found it |
| 20:21.49 | SunSparc | Forward slashes are usually reserved |
| 20:21.52 | wps | once again, it was the space |
| 20:21.57 | wps | RewriteCond %{HTTP_cookie} cms_site_lang!^([0-9]|10|11) |
| 20:22.06 | wps | the space between the cookie name and the bang |
| 20:22.24 | SunSparc | Makes sense, dealing with URL's. |
| 20:22.26 | SunSparc | Cool |
| 20:22.37 | wps | note to selfâ¦Â no spaces in .htaccess |
| 20:23.31 | jsmith | Dang... I was gonna solve it another way :-( |
| 20:23.34 | jsmith | Oh well... |
| 20:23.56 | SunSparc | ~cookie jsmith |
| 20:24.44 | SunSparc | hehe |
| 20:26.05 | orsonj | s/next/nest/ |
| 20:26.42 | wps | :) |
| 20:29.56 | *** join/#uphpu _psychic_ (n=_psychic@66.7.114.125) |
| 20:29.56 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 20:34.35 | swb | wps, so no spaces fixed your RewriteCond? |
| 20:36.17 | wps | noâ¦Â still getting errors |
| 20:36.29 | wps | but I'm getting closer |
| 20:37.12 | swb | are you trying to match HTTP_cookie for cms_site_lang0 through cms_site_lang11? |
| 20:37.40 | wps | oh, sorry, that part is fixed |
| 20:37.45 | wps | onto another line |
| 20:37.46 | wps | :) |
| 20:37.54 | swb | okay |
| 20:37.56 | swb | :) |
| 20:37.58 | jsmith | wps: Please share your pain ;-) |
| 20:38.08 | wps | RewriteCond %{REQUEST_URI} ^de\/ |
| 20:38.09 | wps | RewriteCond %{HTTP_cookie} cms_site_lang!=2 |
| 20:38.09 | wps | RewriteRule ^/(.*)\/$ /$1 [L,cookie=cms_site_lang:2:.omniture.com:525600] |
| 20:38.18 | wps | why would the first line of that not match this URL? |
| 20:38.23 | wps | http://omniture.com/de/ |
| 20:39.58 | SunSparc | "Damn it, Bones, you're a doctor. You know that pain and guilt can't be taken away with a wave of a magic wand. They're the things we carry with us, the things that make us who we are. If we lose them, we lose ourselves. I don't want my pain taken away. I need my pain. " |
| 20:40.11 | swb | I think it should be RewriteCond %{REQUEST_URI} ^/de/ |
| 20:41.21 | wps | didn't work |
| 20:41.24 | bradym | shouldn't need the first / |
| 20:41.40 | wps | here's one I have that works |
| 20:41.40 | swb | oh, I thought request_uri started with a / |
| 20:41.40 | wps | RewriteCond %{HTTP_HOST} ^omtr\.com [NC] |
| 20:41.41 | wps | RewriteRule ^(.*)$ http://omtr.omniture.com [R=301,NC,L] |
| 20:42.22 | bradym | oh, you're probably right swb.. i don't usually use request_uri |
| 20:43.29 | bradym | wps: have you tried - RewriteCond $1 ^dev/ |
| 20:46.39 | wps | I'm not sure what you're asking/suggestiong, bradym |
| 20:47.22 | bradym | replace RewriteCond %{REQUEST_URI} ^de\/ with RewriteCond $1 ^dev/ |
| 20:47.31 | bradym | er.. de/ - not dev/ |
| 20:48.00 | wps | where does $1 get it's value from? |
| 20:48.16 | wps | didn't work |
| 20:51.00 | wps | what is [NC] mean/for ? |
| 20:51.18 | wps | do I need one of those after each condition? |
| 20:51.31 | bradym | nc = not case sensitive |
| 20:51.58 | bradym | and yes, you'd need it for each one if you want it to be case insensitive |
| 20:52.40 | wps | is it better to use that instead of i in your regex? |
| 20:53.29 | SunSparc | wps: For your future reference -> http://httpd.apache.org/docs/2.0/mod/mod_rewrite.html#rewriteflags |
| 20:53.35 | bradym | dunno.. i've never used the i in my regex |
| 20:53.42 | bradym | always do [NC] |
| 20:53.55 | bradym | i like it cause it requires less thought to process the regex ;) |
| 20:57.22 | swb | RewriteRule ^/(.*)\/$ /$1 <- I don't think you need to escape the 2nd / (do you guys agree?) |
| 20:57.52 | swb | do you need to escape forward slashes in RewriteRules? did you guys already cover that? |
| 20:58.53 | SunSparc | jbot rewriteflags is http://httpd.apache.org/docs/2.0/mod/mod_rewrite.html#rewriteflags |
| 20:58.54 | jbot | SunSparc: okay |
| 21:01.14 | *** part/#uphpu thinbegin (n=thinbegi@206.71.78.158) |
| 21:38.38 | *** join/#uphpu _psychic__ (n=_psychic@66.7.114.125) |
| 21:54.25 | timinator | I'm out.... later guys |
| 21:58.02 | Jacob_Kerr | Whats the best way to check and see if a variable hold a float value? |
| 21:59.37 | *** join/#uphpu cycokilr (n=cycokilr@216.112.116.6.ptr.us.xo.net) |
| 22:15.25 | mgeary | hey, how do i add a user to a group in linux? editing /etc/group doesn't seem to do it... |
| 22:17.28 | mgeary | usermod -G <groupname> <username> |
| 22:21.43 | wps | if you're on a redhat/centos/fedora flavor, it's adduser |
| 22:22.24 | wps | adduser -d /path/to/home/ -s /bin/false -c "John Doe" username |
| 22:28.03 | SunSparc | Everyone had their Zombo for the day? |
| 22:28.28 | SunSparc | ~zombo |
| 22:28.42 | SunSparc | jbot zombo is http://zombo.com/ |
| 22:28.43 | jbot | SunSparc: okay |
| 22:47.08 | fungus | mgeary: editing /etc/group does do it, but it won't take effect during the current login session,. |
| 22:47.19 | mgeary | ah |
| 23:08.21 | *** part/#uphpu mrkrow (n=Chad@166.70.178.114) |
| 23:16.49 | Jacob_Kerr | The MySQL room can not figure this out, do you guys see anything wrong with this query? SELECT DISTINCT body FROM vehicle WHERE condition = 'new' |
| 23:17.55 | pelaofeli1 | Jacob_Kerr: what's the response? |
| 23:18.30 | Jacob_Kerr | Just the plain old check you manual you do not know what your doing error.. |
| 23:18.41 | Jacob_Kerr | You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition = new' at line 1 |
| 23:19.03 | Jacob_Kerr | so it's not liking the WHERE or something.. |
| 23:19.08 | pelaofeli1 | ah |
| 23:19.19 | pelaofeli1 | 'condition' is a reserved word |
| 23:19.31 | pelaofeli1 | try this: SELECT DISTINCT body FROM vehicle WHERE `condition` = 'new' |
| 23:20.03 | *** part/#uphpu brasto (n=brasto@166.70.44.49) |
| 23:21.02 | Jacob_Kerr | GENIUS!!' |
| 23:21.05 | Jacob_Kerr | thanx man |
| 23:21.09 | pelaofeli1 | yep |
| 23:26.33 | *** part/#uphpu mgeary (n=mgeary@72.8.120.115) |
| 23:51.18 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 23:51.18 | *** mode/#UPHPU [+v burnin] by ChanServ |