| 04:13.31 | *** part/#uphpu mindjuju (n=mindjuju@65-121-75-195.dia.static.qwest.net) |
| 05:09.07 | *** join/#uphpu eco (n=eco@gnuk.net) |
| 05:09.07 | *** mode/#UPHPU [+v eco] by ChanServ |
| 05:09.09 | *** join/#uphpu tierra (n=tierra@ibaku.net) |
| 05:09.09 | *** mode/#UPHPU [+v tierra] by ChanServ |
| 05:48.15 | *** join/#uphpu mindjuju (n=mindjuju@65-121-75-195.dia.static.qwest.net) |
| 05:48.15 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 05:58.27 | *** join/#uphpu jnbek (n=jnbek@c-67-161-221-47.hsd1.ut.comcast.net) |
| 06:07.48 | herlo | hello? |
| 06:14.53 | mindjuju | hmmm, i either knocked him out with my Mad Buddah Eye Poke or he doesn't know i've responded |
| 06:14.57 | mindjuju | ~APB Herlo |
| 06:14.58 | jbot | ACTION hires Duane Lee to stake out Herlo |
| 06:15.06 | herlo | mindjuju: I'm here now |
| 06:15.24 | herlo | stupid proxy server was trying to block me out. Had to go through company vpn |
| 06:16.23 | herlo | ~APB mindjuju |
| 06:16.23 | jbot | ACTION calls Tim to rough up mindjuju |
| 06:17.04 | mindjuju | i'm here, just backing up database server on the middle screen |
| 06:17.40 | influx | ~APB O.J. Simpson |
| 06:17.41 | jbot | ACTION summons Dog the Bounty Hunter to find O.J. Simpson |
| 06:17.52 | mindjuju | sup influx |
| 06:18.02 | influx | not much. tooling around in reason for a bit before I go to bed. |
| 06:18.04 | herlo | mindjuju: hey man |
| 06:18.21 | mindjuju | yo |
| 06:18.34 | influx | you? |
| 06:18.40 | herlo | mindjuju: I am sooooo sleepy. |
| 06:19.04 | mindjuju | ugh, di.fm is playing crap tonight |
| 06:19.39 | mindjuju | seems like some days, it's so hard to get fresh squeezed techno |
| 06:20.06 | herlo | mindjuju: somafm.com |
| 06:20.33 | herlo | mindjuju: play beat blender |
| 06:21.05 | herlo | and the secret agent |
| 06:21.29 | herlo | mindjuju: you might like doomed if you like industrial. I don't like it as much as the others |
| 06:22.40 | mindjuju | i do like a lot of sound bytes in my techno |
| 06:22.59 | mindjuju | but i need something pretty fast cadence, have been in office since 12p, and I'll prolly leave at 6a |
| 06:23.09 | mindjuju | hot choco will only take you so far |
| 06:23.49 | herlo | mindjuju: I think there are some that are high tempo |
| 06:24.05 | mindjuju | yeah, looking at tag's trance trip |
| 06:41.06 | mindjuju | yup, that's not going to work |
| 13:54.49 | *** join/#uphpu justingiboney (n=justingi@71-35-211-140.slkc.qwest.net) |
| 13:54.55 | justingiboney | good morning uphpu |
| 14:16.49 | *** join/#uphpu gibba[w] (i=gibs@209-253-35-21.ip.mcleodusa.net) |
| 14:29.40 | *** join/#uphpu timinator (n=timinato@c-67-171-118-199.hsd1.ut.comcast.net) |
| 14:29.40 | *** mode/#UPHPU [+v timinator] by ChanServ |
| 14:31.45 | timinator | morning all |
| 14:32.21 | timinator | I'm pooped |
| 14:34.41 | *** join/#uphpu wps (n=wps@64.0.193.149) |
| 14:34.41 | *** mode/#UPHPU [+o wps] by ChanServ |
| 15:06.57 | justingiboney | What is the meeting about this Thursday? |
| 15:09.08 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 15:09.08 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:09.13 | mgeary | ~yow |
| 15:32.37 | justingiboney | I am trying to think of the best way to organize a sequels db in my movie website.... should i just make 7 fields and search all of them when looking for sequels |
| 15:34.35 | mgeary | "sequels db"? |
| 15:34.47 | mgeary | ah |
| 15:35.17 | wps | me too |
| 15:35.48 | justingiboney | i thought that it would happen |
| 15:35.49 | mgeary | not sure what you mean, justingiboney. where'd the # 7 come from ^ ? |
| 15:36.16 | justingiboney | well because star wars has six, so to be safe I thought seven would be good |
| 15:36.20 | mgeary | no |
| 15:36.22 | mgeary | don't do that |
| 15:36.53 | mgeary | one way that would be nicely normalized would be to simply have a recursive parent/child relationship |
| 15:37.08 | mgeary | so, each movie record can have exactly one parent |
| 15:37.25 | justingiboney | but then wouldn't you have to enter the info 6 times? |
| 15:37.31 | mgeary | what info? |
| 15:37.45 | justingiboney | what would be the parent? |
| 15:37.46 | mgeary | you'd enter SW1 (or 4, depending on your philosophy) |
| 15:37.55 | mgeary | then you'd enter SW2, and have it's parent be the ID of SW1 |
| 15:38.01 | mgeary | and then SW3's parent would be SW2, and so on |
| 15:38.09 | mgeary | now, this would make for some fun self-joins... |
| 15:38.24 | mgeary | but it gives you the flexibility to go as deep as you want |
| 15:38.45 | mgeary | i'm sure there are other valid approaches, but this is one. |
| 15:38.52 | justingiboney | okay, that makes sense, but how do I set up the query? |
| 15:38.57 | mgeary | to return what? |
| 15:39.07 | justingiboney | the movie ids for all 6 movies |
| 15:39.35 | justingiboney | say I am looking at SW4, I want SW1-3, SW5-6 to show up |
| 15:39.36 | mgeary | so, you want to, say, start with SW1 and get the IDs of all sequels? |
| 15:39.42 | mgeary | ok |
| 15:39.47 | justingiboney | ya |
| 15:39.58 | mgeary | well, you've got a pretty straightforward "chain" to follow |
| 15:40.09 | mgeary | the question becomes, do you try to do that in SQL, or do you let PHP help you out |
| 15:40.16 | mgeary | doing it all in SQL could get pretty hairy |
| 15:40.17 | justingiboney | either works |
| 15:40.26 | mgeary | but if PHP can help, it'd be pretty simple |
| 15:40.56 | mgeary | just thinking off the cuff, here's one approach-- initialize an empty array which will hold all the related movie IDs |
| 15:41.07 | justingiboney | okay |
| 15:41.23 | mgeary | then if the parent_id of your current movie != 0, work backwards, getting each successive parent movie |
| 15:41.31 | mgeary | with each iteration, add the id to your array |
| 15:41.45 | mgeary | once you hit zero, you stop, and then you work forward from the selected movie |
| 15:41.57 | mgeary | getting any movie(s) who have the current movie id as their parent_id |
| 15:42.28 | mgeary | this could be a many-to-one relationship, so you could choose whether to have a "chain" from sw1 to sw6, or if you wanted to have sw2-6 all point to sw1 |
| 15:43.47 | justingiboney | okay, but how do I explain this to a high schooler? When putting in sequels, always put a enter the movie id first then enter the id of the one that came before it? |
| 15:44.39 | mgeary | so, you're having highschoolers do your data entry? |
| 15:45.20 | justingiboney | no, but I have a 50 year old woman, who knows how to type |
| 15:45.23 | mgeary | you'll always want a hard (id) link between records, which suggests that you may not want to rely on hand-typed numbers, but might want to consider a dropdown menu |
| 15:45.38 | mgeary | now, i realize that for a movie DB, that might end up having thousands of rows |
| 15:45.46 | mgeary | so it might not scale well |
| 15:46.05 | justingiboney | ya, especially with actors =) 9000+ and counting |
| 15:46.23 | mgeary | so, maybe you should use a cool ajax "type-ahead" approach |
| 15:46.40 | mgeary | in any case, i'd recommend NOT relying on hand-typed entry for foreign key population |
| 15:47.02 | mgeary | so you could have a type-ahead widget ultimately populate a hidden field with an ID |
| 15:48.35 | justingiboney | ya the way i have been doing it is with multiple pages... enter id for movie.... is movie 'the movie title' the movie you wanted?.... add second movie id... add relationship between movie 'the movie title 1' and movie 'the movie title 2'? |
| 15:49.40 | mgeary | huh |
| 15:49.51 | mgeary | well, whatever works :) |
| 15:55.31 | justingiboney | What if I made a "series" table that had a series id and a series name and then linked each movie to that series? |
| 16:10.44 | mgeary | yeah, that'd be a good approach as well |
| 16:10.50 | mgeary | certainly be fewer joins |
| 16:28.23 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 16:28.23 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 16:40.54 | *** join/#uphpu SunSparc (n=sparky@66.7.114.125) |
| 17:03.30 | *** join/#uphpu thebigdog (n=bigdog@208.177.146.102.ptr.us.xo.net) |
| 17:03.30 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 17:20.47 | *** join/#uphpu cole_joplin (n=Cole@c-67-166-64-239.hsd1.ut.comcast.net) |
| 17:25.02 | *** join/#uphpu bradym (n=bradym@Qst4FC.quinstreet.com) |
| 17:25.02 | *** mode/#UPHPU [+v bradym] by ChanServ |
| 17:32.13 | *** join/#uphpu Utah_Dave (n=boucha@71.136.198.16) |
| 17:32.13 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 17:45.02 | wps | jim_anderson: welcome to my bubble |
| 17:45.42 | wps | we have free car washes, a soda fountain, and a slip and slide out back |
| 17:45.59 | beandog | http://erratasec.blogspot.com/2007/08/sql-injection-is-surpisingly-easy.html |
| 18:00.19 | *** join/#uphpu plif (n=no@32.97.119.187) |
| 18:06.43 | SunSparc | beandog: that is a good article. |
| 18:08.41 | beandog | :) |
| 18:08.43 | beandog | I likey. |
| 18:08.53 | beandog | People are soooooooooooooooo sloppy when writing SQL. |
| 18:09.12 | beandog | I shudder anytime I see SELECT and $_POST in the same line. |
| 18:10.15 | SunSparc | We should have a "Links" section on the uphpu.org web site so we can bookmark useful articles like that. |
| 18:10.53 | SunSparc | beandog: no kidding. I shudder to recall that I used to do that, back when I was a PHP kiddie. ;) |
| 18:11.15 | beandog | yah |
| 18:11.18 | beandog | me too |
| 18:12.04 | SunSparc | Well, when I was a PHP kiddie it was more like SELECT and $postedvalue (provided by register globals) |
| 18:12.05 | SunSparc | :) |
| 18:12.27 | SunSparc | wps: you still in charge of the web site? |
| 18:12.42 | wps | yes |
| 18:13.40 | SunSparc | Perhaps this has been requested before, but do you think it would be valuable at all to have a page of helpful web article links (such as the one above from beandog) listed on the uphpu site? |
| 18:14.24 | wps | hmm… a page dedicated to just links hasn't |
| 18:14.50 | wps | but you could definitely post an article on UPHPU that summarizes and discusses (and links to) that article! |
| 18:15.00 | wps | that's exactly the kind of content that we're trying to encourage |
| 18:19.42 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 18:20.41 | mgeary | i'd be interested to know if anyone could demonstrate a hack that circumvented this: |
| 18:20.58 | mgeary | $value_to_insert = mysql_real_escape_string($_POST["whatever"]) |
| 18:21.10 | mgeary | $sql = "insert into X set a='$value_to_insert' " |
| 18:21.23 | mgeary | as far as i know, that's essentially bulletproof |
| 18:21.36 | mgeary | but i'd love to know if i'm overlooking something |
| 18:22.57 | beandog | mgeary: I imagine thats okay |
| 18:23.53 | SunSparc | wps: I thought about adding an article and putting a link to that other article in it, but is seemed rather superfluous to do so. |
| 18:24.18 | wps | yeah, just an article with a link isn't worth much |
| 18:24.49 | wps | but if you got a lot of of the article and can post some thoughts of your own that it prompted, then it can be worthwhile |
| 18:25.02 | wps | s/lot of of/lot out of/ |
| 18:26.49 | bradym | a page of links divided by category with a brief category description and perhaps a summary of the articles could be helpful.. better than a list of links alone, and it also prevents writing an article just to post a link |
| 18:26.51 | SunSparc | true, but mostly what I got out of it was: "cool, that was interesting and I see what they mean" since the article was quite self explanatory. It just seems redundant to write a review of a review of an article. |
| 18:28.08 | SunSparc | bradym: Yes, exactly, but I also see what wps is wanting to encourage. Articles written by our members is a good thing for the site, otherwise we just have yet another indext of the Internet. |
| 18:28.26 | bradym | yup |
| 18:28.43 | bradym | just suggesting another option :) |
| 18:29.34 | SunSparc | A very good one, by the way. I am just debating outloud with myself as to whether or not it is worth our time to add a separate section for links. |
| 18:29.56 | *** join/#uphpu stout (n=no@32.97.119.187) |
| 18:30.00 | wps | I wouldn't want to put up a page with just one link, but if someone wanted to gather a bunch with descriptions and categories, then I sure don't have a problem with adding a page for that |
| 18:30.30 | SunSparc | Well, I am sure more would be added over time. Every list starts with one. |
| 18:30.44 | SunSparc | s/would/could/ |
| 18:30.56 | bradym | I've got a bunch of stuff in my yahoo bookmarks that could be categorized :) |
| 18:31.02 | SunSparc | Whether or not people actually would remains to be seen. |
| 18:31.47 | SunSparc | bradym: I am sure most of us do. Perhaps we could all chip in and create a really cool list of links... but would it be useful to others? |
| 18:31.49 | bradym | i bet if we got something started and e-mailed the list people woudl contribute |
| 18:32.57 | SunSparc | This idea reminds me of the social bookmarking sites like: http://ma.gnolia.com/ |
| 18:48.04 | bradym | yeah kinda |
| 18:59.49 | *** join/#uphpu SunSparc_ (n=sparky@66.7.114.125) |
| 19:15.49 | thebigdog | SunSparc_, and bradym i would contribute to the bookmarks too |
| 19:16.13 | thebigdog | we use to have a links section a couple of site revisions back that had some good stuff in it |
| 19:17.03 | bradym | with the variety of people, experience and expertise on the list, i think we could have a really useful links section if we get people to contribute |
| 19:20.57 | thebigdog | we sure could |
| 19:22.27 | *** join/#uphpu charvar (n=to@65.240.64.1) |
| 19:23.22 | thebigdog | wps, did we have links on like the first site we had? |
| 19:33.40 | *** join/#uphpu brettm (n=brettm@209.33.220.23) |
| 19:43.41 | *** join/#uphpu red_ (n=red@211.58.4.254) |
| 19:56.45 | red_ | anyone see the facebook frontpage source that was leaked? |
| 19:57.12 | mgeary | is it PHP? |
| 19:57.18 | red_ | yes |
| 20:08.15 | mgeary | any know how a Core2Duo 1.86GHz cpu compares with the CeleronD 3.33GHz and an AMD 64 3200 cpu? |
| 20:09.53 | Utah_Dave | I have a CoreDuo in my laptop and I've been VERY happy with hit |
| 20:09.56 | Utah_Dave | s/hit/it |
| 20:10.04 | mgeary | me too |
| 20:10.17 | mgeary | but i don't know anything about the other two |
| 20:10.23 | Utah_Dave | Ubuntu is very snappy |
| 20:10.25 | mgeary | a client is asking me about upgrading their server |
| 20:10.34 | mgeary | http://www.aplus.net/ |
| 20:10.37 | mgeary | oops |
| 20:10.42 | mgeary | http://servers.aplus.net/ |
| 20:10.57 | mgeary | wondering what the performance diff would be between the 4 cheapest scenarios |
| 20:11.10 | mgeary | don't need 64-bit.... |
| 20:15.00 | *** join/#uphpu SunSparc (n=sparky@66.7.114.125) |
| 20:19.19 | red_ | i would think a core2 duo would be better than the celeron for sure |
| 20:19.31 | red_ | as far as the amd64, i don't know |
| 20:19.47 | red_ | probably not worth it if you have no 65 bit apps |
| 20:19.48 | red_ | 64 |
| 20:19.58 | mgeary | yeah, that's what i'm thinking as well |
| 20:40.27 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 20:40.27 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 20:46.11 | thebigdog | you can run the amd64 in 32bit mode too |
| 20:46.23 | thebigdog | amd64 are nice...run hot though |
| 20:46.41 | thebigdog | i prefer intel xeon dualcore for servers though |
| 20:47.28 | thebigdog | just cause the xeons have been out for so long |
| 20:49.16 | thebigdog | dont do celeron with server though |
| 20:49.41 | red_ | none of the processors he listed are server based |
| 20:49.52 | mgeary | what are some reasons i can give my client for the "no celeron" approach? |
| 20:50.10 | red_ | its the low end intel, similar to amd duron when it was out |
| 20:50.28 | thebigdog | small cache on cpu |
| 20:50.34 | SunSparc | It sounds like "celery". |
| 20:50.38 | thebigdog | some lvls are removed |
| 20:50.54 | thebigdog | xeons are the server lvl cpus |
| 20:51.01 | thebigdog | if you are doing a server do a xeon |
| 20:51.44 | red_ | sun sparcs are nice for servers too :P |
| 20:51.59 | red_ | all expensive though |
| 20:51.59 | thebigdog | they are the best..but you are paying for the best |
| 20:52.19 | mgeary | client is way cheap |
| 20:52.28 | red_ | also, get a nice 15000 RPM hard drive with it |
| 20:52.34 | red_ | you'll like :) |
| 20:52.35 | SunSparc | Risc processors rock! :) |
| 20:53.45 | thebigdog | sun fire x2100 + gentoo = heaven on earth |
| 20:54.12 | thebigdog | make sure without the amd processor though |
| 20:54.55 | thebigdog | a v125 or v210 would be killer too |
| 20:55.37 | thebigdog | my last job i had a couple v440s that were really nice |
| 20:56.17 | thebigdog | mgeary, just tell them to dime up for a e6900 |
| 20:56.23 | thebigdog | that i all they will ever need |
| 20:57.39 | thebigdog | mgeary, i think you would be ok with an amd or intel...they are both good chips |
| 20:57.49 | thebigdog | i think it depends on what you are doing though imho |
| 20:58.53 | mgeary | sure |
| 20:59.59 | thebigdog | can i ask what they will be doing? |
| 21:00.24 | red_ | yea, don't spend $4000 on somthing that isint going to be that data intensive |
| 21:00.40 | mgeary | running a curriculum-enhancement web application |
| 21:00.49 | mgeary | not a huge db |
| 21:00.59 | mgeary | prolly hundreds of users per day |
| 21:01.44 | thebigdog | if i was looking at i would look at doing some type of dual core dual proc (4 cores total) with alot of ram |
| 21:01.55 | thebigdog | then offset that with a couple 10k scsi drives |
| 21:02.20 | red_ | curriculum enhancement means a lot of reads, few writes? |
| 21:02.34 | red_ | or are they submitting stuff a lot |
| 21:03.00 | mgeary | probably a ~8:1 read:write ratio |
| 21:04.00 | thebigdog | what do they currently have now? |
| 21:05.09 | red_ | i had hundreds of users once on a 1.8ghz single core P4 and it handled it decently, granted it was'nt that write intensive |
| 21:05.35 | red_ | just have to tweek stuff right :) |
| 21:05.44 | red_ | and it ran linux |
| 21:05.45 | thebigdog | optimization will play a big factor |
| 21:05.53 | red_ | slackware :P |
| 21:06.07 | thebigdog | also need to take into account growth |
| 21:09.24 | red_ | yes scalability |
| 21:09.52 | red_ | i think a decent low end server should do the job, i wouldnt spend over $2500 |
| 21:17.50 | herlo | ~abp mindjuju |
| 21:18.32 | herlo | ~apb mindjuju |
| 21:18.33 | jbot | ACTION hires Dog the Bounty Hunter to spray mace at mindjuju |
| 21:22.20 | cole_joplin | I've tried pinging him for days, must be on vacation |
| 21:22.43 | beandog | Dog? |
| 21:22.52 | cole_joplin | Mind |
| 21:23.48 | influx | !google lol |
| 21:23.52 | influx | ~google lol |
| 21:23.55 | influx | omgno |
| 21:26.04 | Utah_Dave | I was talking to mindjuju last night |
| 21:26.09 | Utah_Dave | ~seen mindjuju |
| 21:26.29 | jbot | mindjuju is currently on #uphpu (15h 38m 15s). Has said a total of 12 messages. Is idling for 14h 45m 23s, last said: 'yup, that's not going to work'. |
| 21:26.56 | SunSparc | ~seen SunSparc |
| 21:26.57 | jbot | sunsparc is currently on #uphpu (1h 11m 57s). Has said a total of 3 messages. Is idling for 1s, last said: '~seen SunSparc'. |
| 21:32.16 | SunSparc | ~seen a good movie recently. |
| 21:32.17 | jbot | SunSparc: i haven't seen 'a good movie recently.' |
| 21:32.23 | SunSparc | lol! |
| 21:39.05 | wps | ~seen ChanServ's arm hair |
| 21:39.06 | jbot | wps: i haven't seen 'chanserv's arm hair' |
| 21:39.21 | SunSparc | :) |
| 21:40.03 | wps | glad that that's resolved |
| 21:41.20 | SunSparc | No kidding. |
| 21:45.12 | wps | wow… what an eclectic mix |
| 21:45.30 | SunSparc | :) |
| 21:46.13 | wps | "oh… Pocahontas… I love you… but we just cannot be together… I am not allowed to day while here on the island" |
| 21:46.25 | wps | "perhaps I come back for you afterwards" |
| 21:46.33 | wps | —Elder Jon Smith |
| 21:46.43 | wps | s/day/date/ |
| 21:46.52 | SunSparc | lol |
| 22:13.38 | SunSparc | Here is your humor for today: http://rammygram.com/index.php/2007/08/13/a-texas-chili-contest/ |
| 22:16.42 | wps | that was great |
| 22:16.52 | SunSparc | :) |
| 22:21.10 | wps | Okay… so I said that when I was only have way through reading that. Now that I am done and have recovered… I about wet myself I was laughing so hard and could barely finish ready through my squinted, tear-filled eyes. |
| 22:21.23 | mindjuju | ~APB Herlo |
| 22:21.30 | jbot | ACTION calls Dog the Bounty Hunter to rough up Herlo |
| 22:22.03 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 22:22.03 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 22:22.14 | SunSparc | wps: Same here. When I was almost to the end a co-worker walked up to me to ask me a question and I had to take a moment to calm down. |
| 22:22.25 | mindjuju | ~seen _psychic_ |
| 22:22.48 | jbot | _psychic_ <n=_psychic@66.7.114.125> was last seen on IRC in channel #uphpu, 3d 2h 54m 32s ago, saying: 'congrats'. |
| 22:22.48 | SunSparc | mindjuju: At a conference |
| 22:22.48 | mindjuju | oh |
| 22:22.49 | mindjuju | had some more questions about red5 |
| 22:23.14 | SunSparc | I have put that on my servers a couple of times. Red5 is pretty sweet. |
| 22:23.20 | wps | Coda's split display freaking rocks |
| 22:23.31 | SunSparc | I have thought about adding hosting for it. |
| 22:23.45 | mindjuju | SunSparc, is that red5 on Win or Linux |
| 22:23.50 | SunSparc | Coda just plain rocks!! I finally paid for a copy the other day. |
| 22:23.57 | SunSparc | Coda++ |
| 22:24.15 | SunSparc | mindjuju: Unix (FreeBSD) |
| 22:24.56 | wps | my only wish is for a keystroke for "search and replace all" |
| 22:24.58 | mindjuju | so, for red5, .flv streaming (realtime) and live audio streaming are working aren't they? |
| 22:25.00 | SunSparc | Like I would put anything that requires a server on Windoze, much less use it without being required to after much protest. |
| 22:25.11 | wps | I love how you can specify the search for string and the replace with strings with keystrokes |
| 22:25.27 | wps | but then you have to use the mouse to initiate search-and-replace-all |
| 22:25.35 | SunSparc | wps: I have not used that feature yet, one more thing to look forward to. |
| 22:26.13 | timinator | Coda?!?! Isn't Coda just a tad to GUI for everyone? |
| 22:26.31 | SunSparc | mindjuju: Streaming realtime as in, people are viewing the FLV as it is being created? Yes, I believe so. |
| 22:26.37 | wps | no way… it's very, very lean |
| 22:26.49 | wps | just a nice, lean editor |
| 22:27.28 | SunSparc | timinator: I still use Eclipse, but I just can't stay away from Coda. It is pretty and so very functional and yet, as wps said, very lite. |
| 22:27.41 | influx | Big ups to Coda. |
| 22:27.57 | SunSparc | I think I will start using it instead of TextEdit |
| 22:28.01 | timinator | so what's keeping you from moving to Coda completely? |
| 22:28.38 | SunSparc | timinator: The IDE feature of Eclipse, like Subversion and other things. |
| 22:28.53 | SunSparc | s/feature/features/ |
| 22:29.08 | timinator | hmmmm..... cool |
| 22:29.33 | timinator | do you manage many sites? |
| 22:30.04 | SunSparc | timinator: You talking to me? |
| 22:30.10 | wps | if you were a spammer that lived outside of the US, why would you be so dumb as to not use a .com TLD to send your crap? |
| 22:30.37 | red_ | spammers dont care, they will use any box to spam as long as it is not theirs |
| 22:30.43 | timinator | I was... but anyone in the conversation could answer |
| 22:30.51 | wps | not that I want to encourage them… it's nice to just block everything from .ru, but I just find it strange that they're not smarter than that |
| 22:31.31 | SunSparc | timinator: By manage, do you mean do I have multiple sites that I continually edit and update in Eclipse and Coda? Yes. |
| 22:31.54 | tierra | What if a (legit) Russian wants to contact you? ;) |
| 22:32.07 | wps | Snailmail |
| 22:33.29 | timinator | Sunsparc: and it's handling the weight well, that's good |
| 22:33.29 | wps | I send all mail from .cz, .ru, .co, .ar, .ph, .nl, .fr, .ca, .uk, .jp, .id, .dk, .de, .be, .pl, .sg, .tr, .au, .br, .es straight to the trash |
| 22:34.05 | timinator | Gmail filters++ |
| 22:35.03 | tierra | for that matter, their spam filters as well as user-configurable filters rock |
| 22:35.10 | SunSparc | timinator: Yes, very well. There is a slight learning curve with Coda for dealing with multiple sites, but nothing to complain about as Coda handles things very well. |
| 22:35.32 | SunSparc | wps: I have also considered doing that. |
| 22:36.09 | wps | here here! |
| 22:39.49 | SunSparc | Perhaps I have put too much thought into the demise of spammers. ;) |
| 22:40.58 | SunSparc | There really needs to be a complete overhaul of the email system. It is such a convenient form of communication. I would hate to lose it and I refuse to be bullied into changing the email address that I have had for nearly 8 years now. |
| 22:41.37 | red_ | nothing is going to change people from clicking imaretard.exe |
| 22:41.49 | red_ | rehauling the email system cannot fix that |
| 22:41.52 | wps | :) |
| 22:41.55 | SunSparc | lol |
| 22:44.19 | herlo | ~APB mindjuju |
| 22:44.20 | jbot | ACTION summons Leland to spray mace at mindjuju |
| 22:49.36 | timinator | SunSparc: have you seen this: http://www.junkemailfilter.com/spam/ |
| 22:50.30 | SunSparc | I have not. Thanks, I will take a look at it. |
| 22:51.17 | timinator | It costs $$$ |
| 22:51.18 | timinator | http://www.junkemailfilter.com/spam/pricing.html |
| 22:53.21 | red_ | i would never trust a 3rd party to filter my email |
| 22:53.21 | red_ | lol |
| 22:53.57 | SunSparc | As powerful as filters are, I think they are at most a bandaid. |
| 22:54.00 | red_ | its a nice idea, but to many privacy issues |
| 22:57.20 | SunSparc | Have a good one all!! |
| 23:13.16 | wps | I'm scared of GnR |
| 23:13.24 | wps | oh… wait… |
| 23:13.29 | wps | I thought you said Gwar |
| 23:13.38 | mindjuju | heh |
| 23:13.56 | mindjuju | wps, did you see that Joan Rivers interview of GWAR from back in the 80s? |
| 23:13.59 | mindjuju | hilarious |
| 23:14.02 | wps | yeah |
| 23:14.04 | wps | nuts |
| 23:14.21 | wps | it was 20 years ago and she still looked 90 years old |
| 23:14.57 | mindjuju | yeah, i wonder what is holding her together |
| 23:15.55 | timinator | later guys |
| 23:16.13 | beandog | lol |
| 23:33.43 | Utah_Dave | later guys |
| 23:33.46 | *** part/#uphpu Utah_Dave (n=boucha@71.136.198.16) |
| 23:36.19 | red_ | looks like it ended bitterly. |
| 23:36.53 | red_ | but don't all bands |
| 23:37.58 | mindjuju | poor facebook - i bet somebody is going to do an allnighter changing code -- http://www.pcworld.com/article/id,135901-c,webservices/article.html |
| 23:38.13 | mindjuju | or at least checking code to see what was exposed |
| 23:38.49 | red_ | i have it in my editor right now |
| 23:39.05 | mgeary | just the one page? |
| 23:39.08 | mgeary | or the whole site? |
| 23:39.17 | mindjuju | they say a small portion of it |
| 23:39.21 | red_ | only the front page was leaked |
| 23:39.22 | mindjuju | what's the code look like? |
| 23:39.25 | red_ | which is a major component |
| 23:39.26 | mindjuju | is it anygood? |
| 23:39.41 | mgeary | OOP with good separation b/w app logic & display? :) |
| 23:39.49 | red_ | http://www.gnucitizen.org/blog/facebook-homepage-source-code-probably-leaked/ |
| 23:39.58 | red_ | looks like i got it before it went down :) |
| 23:40.38 | red_ | i have'nt finished seperating it yet, it was all1 line |
| 23:40.40 | mindjuju | oh, it's still here |
| 23:40.41 | mindjuju | http://facebooksecrets.blogspot.com/ |
| 23:41.06 | red_ | looks like what i have is a lot bigger than that |
| 23:41.24 | mgeary | looks like they at least use a template approach |
| 23:41.55 | red_ | yea thats only a portion |
| 23:41.57 | mgeary | but no object |
| 23:41.59 | red_ | or faked or somthing |
| 23:41.59 | mindjuju | i wonder how this leaked? |
| 23:42.04 | red_ | the thing i have is way bigger |
| 23:42.06 | mgeary | mindjuju: misconfigured server |
| 23:42.09 | red_ | but the dude took it off gnucitizen |
| 23:42.12 | mgeary | probably served php files as txt |
| 23:42.13 | mindjuju | yeah, but what does that mean? |
| 23:42.23 | mindjuju | yeah, but that would reveal all site code |
| 23:42.23 | red_ | misconfigued server could be anything |
| 23:42.34 | mgeary | you upgrade a server and then forget to enable PHP. that'll do it |
| 23:42.35 | mindjuju | i bet it was the ole' index.php.old |
| 23:42.48 | mindjuju | it's too funny to see how many people do that |
| 23:42.52 | red_ | while (!$photo && ($next_photos = array_slice($navids, $offset, 8))) { |
| 23:42.52 | red_ | $offset += 8; foreach ($next_photos as &$val) |
| 23:42.52 | red_ | { $val = array_combine(array('pid','user'), explode(',', $val)); } |
| 23:42.52 | red_ | unset($val); |
| 23:42.52 | red_ | $next_photos = multiget_photos($next_photos); |
| 23:42.52 | red_ | foreach ($next_photos as $val) { |
| 23:42.54 | red_ | if ($val) { $photo = $val; break; } |
| 23:42.56 | red_ | } |
| 23:42.58 | red_ | } |
| 23:43.00 | red_ | if ($photo) { redirect('photo.php?pid='.$photo['pid'].'&id='.$photo['user'].$photoqs); } } |
| 23:43.02 | red_ | exit_standard_error_page(array('pid' => $get_pid, 'aid' => |
| 23:43.04 | red_ | $get_aid, 'subj' => $get_subj, 'uid' => $get_id)); |
| 23:43.06 | red_ | like that |
| 23:43.08 | red_ | i dont see in that blogsite |
| 23:44.05 | mgeary | not a single object in sight |
| 23:44.09 | mgeary | disappointing |
| 23:45.09 | red_ | why would you need a bunch of objects for a myspace like site |
| 23:45.17 | red_ | seems like you could do it fine they way they are |
| 23:45.17 | red_ | lol |
| 23:45.29 | mgeary | you're kidding, right? |
| 23:46.03 | red_ | no I'm not |
| 23:46.05 | red_ | SELECT 1 AS is_deleted, `id`, `from`, `time`, `text` FROM `wall_deleted` WHERE `to` = %d AND `media_type` = %d AND `media_id` = %d UNION SELECT 0 AS is_deleted, `id`, `from`, `time`, `text` FROM `wall` WHERE `to` = %d AND `media_type` = %d AND `media_id` = %d ORDER BY `time`' |
| 23:46.29 | mindjuju | was that in the code? |
| 23:46.34 | red_ | yes |
| 23:46.35 | mindjuju | that was leaked? |
| 23:46.46 | mindjuju | your kidding! and the dude says it wasn't any big deal in the article |
| 23:46.57 | mindjuju | that's a HUGE FUBAR |
| 23:46.58 | red_ | nope they are trying to cover it up |
| 23:47.08 | red_ | i bet DMCA notices were sent |
| 23:47.45 | mindjuju | that is the thing that scares me the most, database schema leak |
| 23:47.57 | mindjuju | names of tables, fields, etc |
| 23:48.40 | red_ | they probably had a sql injection |
| 23:48.42 | red_ | who knows |
| 23:48.49 | red_ | or a disgruntled employee |
| 23:48.53 | mindjuju | i'd be looking for a butterknife to do sepuku |
| 23:48.55 | red_ | many possibilities |
| 23:48.57 | red_ | look at half life 2 |
| 23:49.00 | red_ | and gabe newell |
| 23:49.00 | mindjuju | i really would |
| 23:49.09 | red_ | his computer was a botnet zombie |
| 23:49.11 | mindjuju | i thought half life leak was from email virus |
| 23:49.20 | red_ | and the whole sorce for the game was leaked |
| 23:49.44 | red_ | how did the windows 2000 source leak |
| 23:49.49 | red_ | i still have that too :) |
| 23:51.02 | red_ | id post this source but I dont have an anonymous place to post it to |
| 23:51.55 | mindjuju | do you know where any online form processors are? You could email it to dodgeit.com |
| 23:52.07 | beandog | whats so bad about having your schema out? |
| 23:52.32 | beandog | if its designed right, you wont have any problems anyway. |
| 23:52.38 | mindjuju | well, first you shouldn't do ad hoc SQL statement in code |
| 23:52.49 | mindjuju | secondly, it makes sql inject that much easier |
| 23:53.07 | mgeary | mindjuju: btw, you missed my assertion earlier |
| 23:53.08 | beandog | well |
| 23:53.11 | red_ | well, IP |
| 23:53.13 | beandog | your code should be sql injection proof in the first place. |
| 23:53.21 | beandog | so |
| 23:53.21 | red_ | but it does'nt take a genius to make their table layout |
| 23:53.24 | mindjuju | nothing is inject proof |
| 23:53.25 | beandog | fix your code, leaks == no problem. |
| 23:53.33 | beandog | I dont believe that. |
| 23:53.39 | red_ | intelectual property |
| 23:53.44 | beandog | Its entirely possible to write, clean, secure, unbreakable code. |
| 23:53.45 | mgeary | i assert that a combination of mysql_real_escape() and single quotes around your values should prevent against any sql injection |
| 23:53.48 | beandog | barring security php issues. |
| 23:55.18 | mindjuju | strong arguments, but have yet to see flawless unbreakable code |
| 23:55.41 | mgeary | speaking of security issues, lemme get yer take on this-- |
| 23:55.59 | beandog | mindjuju: heh |
| 23:56.01 | beandog | mines unbreakable. |
| 23:56.02 | beandog | :) |
| 23:56.38 | beandog | its all in svn |
| 23:56.50 | beandog | well, the good stuff. |
| 23:56.51 | mgeary | if i've got server A which is an offsite backup location for servers B, C, and D, would you advocate having the cron backups be "push" scripts, running on B,C and D, pushing data on to A, or would you advocate that the scripts be "pull" scripts running on server A? |
| 23:56.53 | beandog | some of its crappy. |
| 23:57.08 | mgeary | i'm thinking that the pull scenario might be better |
| 23:57.49 | mindjuju | @ mgeary , i trust outbound more than i trust inbound |
| 23:57.57 | mindjuju | i |
| 23:58.03 | mgeary | yeah |
| 23:58.04 | mindjuju | i'd do the push across |
| 23:58.08 | beandog | http://spaceparanoids.org/trac/bend/browser/mplayer-resume |
| 23:58.11 | beandog | that should be pretty clean. |
| 23:58.17 | beandog | bah, Ive gotta fix up svn. |
| 23:58.18 | beandog | meh. |
| 23:58.44 | beandog | I agree with mgeary though |
| 23:58.51 | *** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com) |
| 23:58.53 | beandog | but I also throw in regexp formatting, so I know nothing bad can go in |
| 23:58.57 | beandog | So I'm gtg. |
| 23:59.07 | mgeary | what kind of regexp formatting? |
| 23:59.19 | beandog | mgeary: we went over this once upon a time, remember? |
| 23:59.29 | mgeary | ummmmm |
| 23:59.30 | beandog | Ive got a huge old function for lots of data types |
| 23:59.36 | beandog | wasnt too long ago |