| 00:00.22 | SunSparc | Laterz |
| 00:00.50 | *** join/#uphpu beandog (~steve@gentoo/developer/beandog) |
| 00:00.50 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 00:44.23 | *** part/#uphpu mgeary (~mgeary@166.70.44.49) |
| 02:58.16 | *** join/#uphpu ibot (ibot@rikers.org) |
| 02:58.17 | *** topic/#UPHPU is Utah PHP Users Group | uphpu.org |
| 02:58.17 | *** mode/#UPHPU [+v ibot] by ChanServ |
| 03:09.53 | *** join/#uphpu blendmasternoid (~blendmast@97-117-99-216.slkc.qwest.net) |
| 03:38.48 | *** join/#uphpu redroy1 (~Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 03:40.28 | *** join/#uphpu redroy1 (~Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 03:47.12 | *** join/#uphpu optikal (optikal@failcore.com) |
| 03:47.13 | *** mode/#UPHPU [+v optikal] by ChanServ |
| 04:15.52 | *** join/#uphpu wps (~wps@208.53.47.251) |
| 04:15.53 | *** mode/#UPHPU [+o wps] by ChanServ |
| 04:23.18 | *** join/#uphpu supernovia (~Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 04:53.10 | *** join/#uphpu ninnypants (~Tyrel@c-98-202-247-44.hsd1.ut.comcast.net) |
| 05:27.16 | *** join/#uphpu supernovia (~Velda@c-98-202-112-234.hsd1.ut.comcast.net) |
| 05:34.19 | wps | ha ha ha |
| 05:34.36 | supernovia | ? |
| 05:34.48 | wps | I love it when you ask someone to email you some instructions or details⦠|
| 05:35.03 | wps | and then open up a word pressor, type it up, and then attach it to a blank email |
| 05:35.29 | wps | ie: use email as an envelope |
| 05:35.36 | wps | instead of a postcard |
| 05:35.50 | wps | yes, they |
| 05:35.52 | wps | sorry |
| 05:36.04 | supernovia | it's all good. I was thinking, you love to do that? Jerk :-p |
| 05:36.05 | supernovia | hehe |
| 05:36.14 | wps | :) |
| 05:37.56 | supernovia | once when I was a teenager taking a lovely bubble bath, my mom pounded down the door about some problem with the computer's display |
| 05:38.13 | supernovia | so I told her "OK, just right-click on the desktop, and then click on properties." |
| 05:38.21 | supernovia | "I don't see properties!" |
| 05:38.28 | supernovia | "Did you right-click on the desktop?" |
| 05:38.31 | supernovia | "Yes!" |
| 05:39.08 | supernovia | long story short, eventually I had to leave the tub behind, only to find she'd opened wordperfect and typed "Click on the Desktop" |
| 05:40.24 | wps | nice |
| 05:40.41 | supernovia | "See, I wrote it and nothing happened." |
| 05:40.55 | wps | she needs a terminal |
| 05:41.00 | supernovia | She's gotten much savvier since then, thank goodness. |
| 05:41.13 | wps | my mom's improved a lot recently too actually |
| 05:41.27 | wps | finally got her to start using BCC |
| 05:41.35 | supernovia | actually that was only the 2nd computer we had with a gui |
| 05:41.45 | supernovia | Niiiice |
| 05:42.10 | wps | she still has FWD-itice though |
| 05:42.13 | supernovia | my mom really did do much better with a command prompt.. she could write macros and stuff like no other |
| 05:42.38 | supernovia | I have a client with fwd-itis |
| 05:43.46 | supernovia | I eventually used her lack of BCC to my advantage; I filter emails that are also sent to her friends :-p (especially the "send this to seven people in seven minutes or you'll die for seven years" (or something like that) kind) |
| 05:45.09 | supernovia | (oh, macros for very old wps, btw, not for the command prompt, but she got around just fine on that computer) |
| 05:46.34 | wps | doing a data migration for my client is taking longer than I anticipated :( |
| 05:46.42 | wps | (migrating them from Access to MySQL) |
| 05:46.48 | supernovia | ug |
| 05:47.46 | wps | I had them output a spreadsheetâ¦Â saved it as tab delimitedâ¦Â replaced the tabs with pipesâ¦Â and am writing a script to look through it all and insert it into the new database |
| 05:48.04 | wps | the new data spans many tables though so it's a complicated script |
| 05:48.22 | supernovia | holy cow |
| 05:48.48 | wps | not too big of a database so I won't have a problem reading it all into memory when I execute the script |
| 05:48.53 | wps | only 1300 records |
| 05:48.57 | wps | but still |
| 05:48.59 | wps | ug |
| 05:49.15 | wps | please don't tell me theirs an easier way to do this |
| 05:49.32 | supernovia | :x |
| 05:50.11 | wps | s/theirs/there's/ |
| 05:50.22 | wps | but do please pray that my typing will improve |
| 05:50.24 | wps | :) |
| 05:51.33 | supernovia | http://www.bullzip.com/products/a2m/info.php ? |
| 05:52.00 | supernovia | I have never used access; was thinking it would be more like mssql but it just isn't. this looks like it might help out though |
| 05:52.33 | wps | hmm |
| 05:52.46 | wps | it says you can select individual tables and fields |
| 05:52.58 | wps | but I wonder if you can have completely custom mapping |
| 05:53.11 | wps | because their current database is a single table with a column for everything |
| 05:53.16 | wps | (it's a dissaster) |
| 05:53.17 | supernovia | ah, didn't know you were mapping too |
| 05:53.24 | supernovia | oh goodness |
| 05:54.03 | supernovia | that makes my head hurt. But, it also means 1300 is really not huge at all |
| 05:54.10 | wps | and the new database has many tables |
| 05:54.14 | wps | yeah, not too bad |
| 05:54.17 | wps | I have it half done |
| 05:54.23 | supernovia | that is good |
| 05:54.34 | wps | it's mostly just being really thorough so that I don't have syntax errors |
| 05:54.44 | wps | and testing it thoroughly before I run the script |
| 05:54.44 | supernovia | welp. I have to figure out how to do this flex panorama or at least have a good head start on it for the am |
| 05:54.50 | wps | I've done it once before |
| 05:55.10 | supernovia | Well there you go then, you've done this conversion before? |
| 05:55.18 | wps | not _this_ one |
| 05:55.29 | wps | but this same process for a different project |
| 05:55.31 | supernovia | ah. but done one similar, got it |
| 06:01.52 | supernovia | what's the best-looking and still amazingly useful site you've been to recently? |
| 06:02.06 | wps | hmm⦠|
| 06:02.12 | supernovia | looking through my bookmarks, most of em are fairly plain jane |
| 06:02.40 | supernovia | or I should say they just don't stand out as being gorgeous |
| 06:02.58 | wps | my coworker just launched this: |
| 06:02.58 | wps | http://hulabalub.com/events/ |
| 06:03.19 | wps | not "gorgeous," but polished and well designed and definitely useful |
| 06:03.49 | supernovia | yeah that's more like what most of the designs I've bookmarked seem to look like |
| 06:04.07 | wps | I stumbled across this site earlier: http://jilion.com/ |
| 06:04.33 | supernovia | I have to try to find sites that display classic design principles and I just don't judge sites on that criteria |
| 06:05.04 | wps | perhaps this will inspire? |
| 06:05.05 | wps | http://net.tutsplus.com/articles/web-roundups/inspiration-35-wonderful-website-headers/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+nettuts+%28NETTUTS%29 |
| 06:09.02 | supernovia | thanks for that |
| 06:09.07 | wps | you bet |
| 09:24.19 | *** join/#uphpu burnin (~burnin@204-228-142-196.ip.xmission.com) |
| 09:24.20 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 11:16.33 | *** join/#uphpu mindjuju_ (~mindjuju@mail.billgood.us) |
| 13:52.47 | *** join/#uphpu jtsnow (~chatzilla@VDSL-151-118-129-72.DNVR.QWEST.NET) |
| 14:00.31 | *** join/#uphpu cro (~cro@166-70-222-105.ip.xmission.com) |
| 14:01.09 | *** join/#uphpu justincarmony (~justincar@c-24-10-194-172.hsd1.ut.comcast.net) |
| 14:01.09 | *** mode/#UPHPU [+v justincarmony] by ChanServ |
| 14:16.56 | *** join/#uphpu mindjuju (~mindjuju@mail.billgood.us) |
| 14:16.57 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 15:33.12 | *** join/#uphpu mindjuju (~mindjuju@mail.billgood.us) |
| 15:33.13 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 15:48.42 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 15:48.43 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 15:49.24 | *** join/#uphpu _psychic_ (~raisinbre@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 15:49.24 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 15:52.33 | *** join/#uphpu justincarmony (~justincar@174-23-200-123.slkc.qwest.net) |
| 15:52.33 | *** mode/#UPHPU [+v justincarmony] by ChanServ |
| 15:54.11 | justincarmony | good morning |
| 16:03.12 | utahcon | morning! |
| 16:04.58 | macnewbold | ~rlart |
| 16:04.59 | ibot | pries macnewbold's back open with a screwdriver and flashes a new bootldr to macnewbold |
| 16:05.02 | macnewbold | hm |
| 16:05.06 | macnewbold | that was stupid |
| 16:06.13 | macnewbold | hehe |
| 16:06.20 | macnewbold | morning funnies for everyone: http://thishelpdesk.com/iphone-xl/ |
| 16:11.39 | *** join/#uphpu SunSparc (~sparky@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 16:11.40 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 16:12.12 | *** join/#uphpu fungus (~olsonl@bromine.sosstaffing.com) |
| 16:12.12 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 16:32.27 | *** join/#uphpu mindjuju (~mindjuju@mail.billgood.us) |
| 16:32.28 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 16:32.40 | justincarmony | ~lart macnewbold |
| 16:32.40 | ibot | executes killall -TERM macnewbold |
| 16:34.52 | *** join/#uphpu mgeary (~mgeary@166.70.44.49) |
| 16:34.53 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 16:36.31 | *** join/#uphpu Utah_Dave (~David@72-166-51-162.dia.static.qwest.net) |
| 16:36.32 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 16:37.42 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 16:37.42 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 16:48.06 | *** join/#uphpu redroy (~Adium@66.60.105.178) |
| 16:52.13 | *** join/#uphpu cro (~cro@166-70-222-105.ip.xmission.com) |
| 16:54.34 | *** join/#uphpu ninnypants (~Rick@64.72.210.74) |
| 16:54.54 | wps | there is an MySQL function that will select a portion of a string |
| 16:55.01 | wps | but I can't remember it an am having trouble finding it via good |
| 16:55.08 | wps | google |
| 16:55.17 | wps | anyone know what it is? |
| 16:55.23 | josephscott | http://dev.mysql.com/doc/refman/5.0/en/string-functions.html |
| 16:55.28 | fungus | http://dev.mysql.com/doc/refman/5.0/en/string-functions.html |
| 16:55.33 | josephscott | http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substring |
| 16:55.42 | fungus | kek |
| 16:55.46 | wps | thank you |
| 16:55.51 | fungus | SUBSTR() |
| 16:57.55 | wps | seems so obvious :) |
| 16:58.07 | wps | I was up until nearly four am :( |
| 17:03.47 | *** join/#uphpu mindjuju (~mindjuju@mail.billgood.us) |
| 17:03.48 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 17:25.41 | wps | what the? |
| 17:26.07 | wps | why is MySQL's SUBSTR 1-indexed instead of zero? |
| 17:27.27 | wps | too many inconsistencies |
| 18:01.23 | *** join/#uphpu romanovic (~romanovic@c-67-161-208-14.hsd1.ut.comcast.net) |
| 18:03.26 | *** join/#uphpu mgeary (~mgeary@166.70.44.49) |
| 18:03.27 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 18:08.34 | *** join/#uphpu swb (~sheri@229.sub-75-195-73.myvzw.com) |
| 18:08.34 | *** mode/#UPHPU [+v swb] by ChanServ |
| 18:10.27 | utahcon | anyone here live in South Jordan? |
| 18:12.02 | PoeticIntensity | what's up, swb? |
| 18:12.25 | swb | hi PoeticIntensity, just fixin blogs :) |
| 18:14.50 | jtsnow | utahcon: I do |
| 18:15.22 | justincarmony | ok, here is a question |
| 18:15.30 | justincarmony | what do I do when du -sh . takes too long to run? |
| 18:15.42 | justincarmony | I need a good approximation on how massive a folder is |
| 18:16.11 | PoeticIntensity | nice! .... and I'm curious... swb, what does "fixing a blog" entail, exactly? |
| 18:16.38 | justincarmony | any ideas fungus, utahcon, josephscott? See question ^^^ |
| 18:16.39 | swb | mostly reporting bugs :) |
| 18:16.49 | swb | and patches |
| 18:17.54 | josephscott | du -d 1 just goes one level (on freebsd) |
| 18:18.25 | justincarmony | hrm |
| 18:18.35 | josephscott | there's a --max-depth option in Linux |
| 18:19.05 | justincarmony | but does it not measure the correct depth? |
| 18:19.11 | justincarmony | I mean |
| 18:19.22 | justincarmony | does it still get the right size? |
| 18:20.51 | fungus | du will check the size of all files. that takes a long time. |
| 18:21.06 | fungus | --max-depth only limits the display, doesn't make it any faster |
| 18:26.51 | DexterTheDragon | http://developers.facebook.com/news.php?blog=1&story=358 |
| 18:30.22 | jtsnow | wow |
| 18:31.27 | romanovic | Any dojo users here? How does it compare to jquery? |
| 18:43.54 | macnewbold | I use http://dojo.codegreene.com/ |
| 18:43.57 | macnewbold | and jquery |
| 18:44.02 | macnewbold | in fact, dojo.codegreene.com uses jquery |
| 18:45.10 | macnewbold | justincarmony: find might be able to help, but I don't know if it would be much faster - it has to examine every directory just like du does |
| 18:45.20 | macnewbold | i don't think there's a way to do it without examining every directory |
| 18:45.43 | macnewbold | though if the files are all owned by one user and quotas are enabled, quota would tell you how much space that user is using |
| 18:45.57 | macnewbold | but that covers everywhere in that filesystem, not just that folder |
| 18:47.51 | ninnypants | justincarmony: if you're looking at files in just one folder why not just use ls -l to give you the file sizes? |
| 19:05.34 | justincarmony | well, its about 40-50 GB (my guess) of jpgs |
| 19:05.42 | justincarmony | doing a little math, thats a LOT of files |
| 19:09.17 | *** join/#uphpu swb (~sheri@81.sub-75-194-67.myvzw.com) |
| 19:09.17 | *** mode/#UPHPU [+v swb] by ChanServ |
| 19:28.15 | *** join/#uphpu justincarmony (~justincar@174-23-200-123.slkc.qwest.net) |
| 19:28.15 | *** mode/#UPHPU [+v justincarmony] by ChanServ |
| 19:30.59 | *** join/#uphpu mindjuju_ (~mindjuju@mail.billgood.us) |
| 19:39.10 | wps | supernovia: while there are only 1300 rows, there are 120 columns :( |
| 19:44.18 | wps | :( |
| 19:44.42 | wps | I should have just hired someone to do this via data entry |
| 19:45.04 | josephscott | depends, how "big" are each column? 120 int columns is very different from 120 text/blob columns |
| 19:47.00 | justincarmony | 120 columns can be unweildly to manage from a programming aspect |
| 19:51.18 | macnewbold | justincarmony: if the files are all in one folder, run 'ls -l | head -1' |
| 19:51.32 | macnewbold | total is total blocks, which often is KB. |
| 20:03.20 | supernovia | nice wps |
| 20:03.41 | wps | I have 20 of 121 rows left to map |
| 20:03.59 | wps | thought I could do this in an hour |
| 20:04.03 | wps | it's taken my half a day :( |
| 20:04.09 | wps | s/my/me/ |
| 20:04.11 | supernovia | yikes |
| 20:04.31 | wps | my migration script is currently 500 liens |
| 20:04.34 | wps | sheesh |
| 20:04.37 | wps | my migration script is currently 500 lines |
| 20:14.01 | *** join/#uphpu cro (~cro@166-70-222-105.ip.xmission.com) |
| 20:14.33 | jsmith | wps: Nothing like the ancient oriental art of data massage... |
| 20:14.50 | supernovia | I could use some o that |
| 20:15.31 | supernovia | OK, if someone told you "we are no longer friends. You just ruined the curve!!!" would you think they were joking? I did |
| 20:16.12 | SunSparc | Depends on if you were friends in the first place or not. |
| 20:16.24 | ninnypants | I would though I have no Idea what the curve is |
| 20:18.06 | wps | I am never doing an Access to MySQL data migration again |
| 20:18.07 | wps | ever |
| 20:18.09 | wps | ever ever |
| 20:18.18 | wps | ever ever ever |
| 20:18.21 | mgeary | <PROTECTED> |
| 20:18.22 | supernovia | Not good friends my any means.. but I did think it was a joke |
| 20:18.31 | mgeary | supernovia... and it wasn't? |
| 20:18.46 | wps | at least with MSSQL to MySQL you could write SQL queries to push the data over, no? |
| 20:18.53 | supernovia | apparently not, lol |
| 20:19.05 | mgeary | wps: not that i've found |
| 20:19.08 | wps | ah |
| 20:19.12 | wps | this sucks |
| 20:19.32 | wps | especially since it wasn't included in the price of project :( |
| 20:20.08 | utahcon | supernovia: Don't worry, if you ruined the curve, she is too stupid to hang out with. |
| 20:20.29 | supernovia | heheh |
| 20:20.42 | supernovia | my unexpressed thoughts exactly |
| 20:21.00 | utahcon | I have ruined many a curve in my day |
| 20:21.56 | supernovia | This test isn't even graded on the curve :-p |
| 20:23.01 | supernovia | I guess that's mixing third and first person but whatever. |
| 20:24.19 | supernovia | heheh |
| 20:29.15 | mgeary | true |
| 20:29.30 | mgeary | remember when Meg goes into the 4th dimension and comes back "flipped"? |
| 20:29.49 | mgeary | so ketchup becomes an aphrodisiac |
| 20:29.50 | supernovia | I only read the first book |
| 20:29.55 | mgeary | ah |
| 20:30.11 | mgeary | i think that was in the 3rd |
| 20:30.13 | supernovia | and again recently, to my kids, over Christmas :) |
| 20:35.28 | SunSparc | wps: don't do it if it is not included in the project. Make the client find someone to do it or pay you do it. |
| 20:35.58 | wps | should have, yes |
| 20:36.02 | wps | too late now though |
| 20:36.08 | SunSparc | doh |
| 20:36.17 | SunSparc | ~console wps |
| 20:36.18 | ibot | ACTION gives wps the consolation moose |
| 20:38.53 | wps | I hate phpMyAdmin |
| 20:39.11 | utahcon | wps: why? |
| 20:39.20 | wps | let me rephrase |
| 20:39.39 | wps | I hate it when I don't have SSH access to a box and have to use phpMyAdmin instead of MySQL monitor |
| 20:41.07 | wps | I want to truncate a bunch of tables |
| 20:41.16 | wps | is that what the "empty" option in this menu does? |
| 20:41.42 | wps | http://screencast.com/t/NzQ4ODU3N |
| 20:43.49 | redroy | Yes, empty is truncate |
| 20:44.04 | redroy | it should warn you too |
| 20:44.13 | wps | so why don't they call it truncate? |
| 20:44.37 | redroy | cause they're dooshy |
| 20:49.19 | SunSparc | Druish? |
| 20:49.54 | justincarmony | A Druish Princess... |
| 20:50.03 | SunSparc | They like money, and power. |
| 20:50.19 | SunSparc | And I have both... |
| 20:50.26 | wps | I wrote a story about druids in junior high |
| 20:50.42 | wps | my teach told me that I had plagiarized it and gave me an F |
| 20:51.01 | wps | I run into him every now and then at Home Depot and give him the lazy eye |
| 20:51.31 | supernovia | the lazy eye? |
| 20:51.48 | DexterTheDragon | the oooolll' lazy eye |
| 20:52.00 | wps | it's a quote from a movie |
| 20:52.04 | wps | but I can't recall which |
| 20:52.10 | wps | any animated western |
| 20:52.16 | wps | s/any/an/ |
| 20:52.32 | DexterTheDragon | An American Tail: Fievel Goes West |
| 20:52.36 | wps | that sounds right |
| 20:52.46 | supernovia | Oh yeah, I remember that |
| 20:52.54 | wps | http://www.youtube.com/watch?v=0WLCSHoc4ZM |
| 20:53.02 | supernovia | I used to play that dreams song on the piano all the time :) |
| 20:53.17 | supernovia | (only because my best friend let me borrow her sheet music though) |
| 20:53.28 | wps | "hold onto your butts!" |
| 20:53.47 | SunSparc | wps: which story did he say you copied? |
| 20:54.01 | wps | I don't recall now |
| 20:55.37 | SunSparc | wps: Did you? Or was he just a jerk? |
| 20:55.45 | wps | I did not |
| 20:55.52 | wps | ohâ¦Â waitâ¦Â I just remembered |
| 20:55.56 | wps | it wasn't the druid story |
| 20:56.15 | wps | i wrote a story about a guy that lived in the forest and helped people secretly |
| 20:56.20 | wps | he said that I copied robin hood |
| 20:56.35 | wps | and I completely disagree that it was a copy of robin hood |
| 20:57.15 | SunSparc | I guess he thought only Robin Hood could live in a forest and help people. |
| 20:57.21 | SunSparc | Did you fight it? |
| 20:57.43 | supernovia | Wait, so that guy who lives in the park and helps people is NOT robin hood? |
| 20:57.55 | supernovia | theres a forest in the park.. so I thought he must be.. |
| 20:58.02 | SunSparc | lol |
| 20:58.09 | wps | I argued with him but didn't get anywhere |
| 20:58.26 | wps | he was a cranky old goat |
| 20:58.36 | SunSparc | You should have sent him to the principle's office. |
| 21:02.50 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net) |
| 21:03.11 | *** join/#uphpu trevynm (~trevynmey@173-116-216-127.pools.spcsdns.net) |
| 21:03.22 | trevynm | is there any way to |
| 21:03.28 | trevynm | do this: |
| 21:03.33 | *** join/#uphpu _psychic_ (~raisinbre@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 21:03.33 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 21:03.36 | trevynm | $sql = "INSERT INTO backup_logs( |
| 21:03.36 | trevynm | SELECT * |
| 21:03.37 | trevynm | FROM backup_configs |
| 21:03.37 | trevynm | WHERE id =$id ) ;"; |
| 21:03.50 | trevynm | with an auto incrimented ID |
| 21:04.27 | SunSparc | You can specify the id even if it is autoincrement. |
| 21:05.01 | trevynm | SunSparc: it says duplicate ID |
| 21:05.02 | SunSparc | insert into blah (id, blah) values (1, 'blah'); |
| 21:05.04 | trevynm | and wont insert |
| 21:05.08 | SunSparc | Yep, that is the problem |
| 21:05.11 | trevynm | When using an "INSERT INTO" statement, what should I put as the value for an auto incrementing cell? |
| 21:05.11 | trevynm | ex: "INSERT INTO content VALUES (' [auto-incrementing field] ', '$content')"; |
| 21:05.15 | SunSparc | If the id already exists. |
| 21:05.35 | trevynm | yeah, it does exists |
| 21:05.40 | trevynm | becuae im duplicating the data |
| 21:05.46 | Zelut | mysql_insert_id() returns the last auto-incremented ID, if that helps.. |
| 21:06.17 | trevynm | $sql = "INSERT INTO backup_logs( |
| 21:06.17 | supernovia | do you want to duplicate the data? |
| 21:06.17 | trevynm | SELECT * |
| 21:06.17 | trevynm | FROM backup_configs |
| 21:06.17 | trevynm | WHERE id =$id ) ;"; |
| 21:06.19 | Zelut | or maybe I'm not quite following.. |
| 21:06.37 | trevynm | supernovia: I do want to duplicate the data, with a new autoincriment ID |
| 21:07.28 | trevynm | INSERT log (SELECT * from config by $ID) |
| 21:07.50 | trevynm | should I remove the Auto Incriment off of the log table? |
| 21:08.11 | trevynm | id prefer not to |
| 21:09.05 | *** join/#uphpu jsmith (~nnnjsmith@234.81.233.72.static.reverse.ltdomains.com) |
| 21:09.16 | supernovia | can you start the auto-increment from a higher number? |
| 21:13.27 | trevynm | supernovia: yeah, but its trying to append the old ID, will that cuase a problem? |
| 21:13.41 | supernovia | what do you want it to do? |
| 21:14.04 | trevynm | I want to make a copy of the config record |
| 21:14.09 | trevynm | and store it in the log table |
| 21:14.16 | trevynm | with a unique ID each time id runs |
| 21:14.27 | trevynm | I guess I could add a new field |
| 21:14.51 | trevynm | but then it breaks the shortcut of doing the select insite the insert |
| 21:15.37 | supernovia | nothing else is going to be writing in new rows while you run this, right? |
| 21:16.47 | trevynm | supernovia: right |
| 21:17.29 | supernovia | and you just want it to auto increment starting from 1+the last id? |
| 21:19.03 | supernovia | sorry I guess I don't understand. I'm going to make some nachos :) |
| 21:19.43 | *** join/#uphpu jsmith (~nnnjsmith@asterisk/training-and-documentation-guru/jsmith) |
| 21:19.43 | *** mode/#UPHPU [+v jsmith] by ChanServ |
| 21:23.02 | trevynm | I just removed the auto incriment and index |
| 21:23.15 | trevynm | so that the log records are exact clones of the configs |
| 21:24.51 | *** join/#uphpu blendmaster1024 (~blendmast@unaffiliated/blendmaster1024) |
| 21:25.18 | *** part/#uphpu trevynm (~trevynmey@173-116-216-127.pools.spcsdns.net) |
| 21:29.44 | *** join/#uphpu Zelut (~christer@unaffiliated/zelut) |
| 21:36.24 | DexterTheDragon | ping josephscott |
| 21:36.33 | josephscott | DexterTheDragon: hi |
| 21:36.58 | DexterTheDragon | what does wordpress.org use for its irc logging? |
| 21:37.39 | josephscott | hmmm, good question. I know one of the guys has made several home grown bots for logging |
| 21:38.49 | DexterTheDragon | yeah I'm curious about what the irclogs site is using |
| 21:39.37 | josephscott | I think the CIA-55 bot is being used for wordpress-dev |
| 21:43.21 | fungus | DexterTheDragon, ibot does logging, and it's a lot of fun to play with too. |
| 21:43.26 | fungus | ~torture ibot |
| 21:43.27 | ibot | ACTION forces ibot to support Debian GNU/Hurd in production. |
| 21:43.56 | DexterTheDragon | yeah I more interested in the sire wordpress has for linking to the logs |
| 21:44.21 | DexterTheDragon | s/sire/site/ |
| 21:46.26 | wps | I'd be very interested in the following statistic: of the people that like flash and want it on portable Apple devices, how much do they use it for things other than video |
| 21:47.37 | fungus | I've always hated flash |
| 21:47.42 | cro | wps: probably lots of games |
| 21:48.03 | wps | but is that a high percentage? |
| 21:48.11 | supernovia | I think it's funny that my flex class loves apple so much |
| 21:48.31 | wps | and I bet that those gamers would prefer a native app version on their iPad over an in-browser, flash version |
| 21:49.06 | wps | s/I/I'd/ |
| 21:50.30 | wps | greatâ¦Â there are duplicate entries in the data I'm migrating and the fields in the new database require unique values |
| 21:52.20 | supernovia | you and trevyn should get together ;) |
| 21:57.50 | Zelut | i'm looking at output buffering. would it make sense, in a simple way, to create buffers for header, body, footer and flush the full buffer when all is done? |
| 22:11.16 | Zelut | do GET and POST always return strings? |
| 22:11.50 | wps | they contain arrays |
| 22:13.27 | Zelut | I guess what I mean is: if I have a form asking for name and phone, both $_POST['name'] and $_POST['phone'] will return true on is_string() ? |
| 22:14.22 | DexterTheDragon | yeah the values will be strings |
| 22:16.32 | Zelut | I'd like to validate my input a little better than that. would one of the ctype_ tests be better? |
| 22:23.21 | redroy | Zelut: why not regex? |
| 22:25.34 | redroy | regex for back-end and jquery masking for front end makes for a great, secure, user experience |
| 22:27.43 | Zelut | that is probably the best (correct) solution. in my situation this is for class notes and we haven't gotten to regex yet. |
| 22:44.55 | redroy | ah, I see... you could use is_string and is_numeric perhaps? |
| 22:46.28 | redroy | as well as strlen() |
| 22:48.54 | Zelut | won't POST/GET always return string though? not numeric, float, etc? |
| 23:06.25 | redroy | right, but is_numeric can tell if it's a numeric string http://php.net/manual/en/function.is-numeric.php |
| 23:07.43 | unum | hmmm |
| 23:07.50 | unum | what happend in #utah? |
| 23:08.43 | redroy | so something as simple as is_numeric(str_replace("-", "", $_POST['numer'])) could work |
| 23:14.22 | justincarmony | so.... I haven't see anyone talk about the PHP annoucement today! :P |
| 23:14.42 | mgeary | hey fungus |
| 23:14.45 | wps | that's because it came from Facebook and has a stupid name |
| 23:14.57 | unum | I can't talk in #utah |
| 23:14.57 | justincarmony | lol |
| 23:15.02 | justincarmony | it could be way worse |
| 23:15.04 | fungus | mgeary, yeh |
| 23:15.04 | romanovic | unum, neither can i |
| 23:15.09 | wps | besides that, it sounds pretty cool |
| 23:15.12 | _psychic_ | justincarmony: I think you mean the C++ announcement |
| 23:15.23 | romanovic | did someone ban our ip range? |
| 23:15.24 | mgeary | fungus: how can i debug a slave NS that's in disagreement with the master? |
| 23:15.35 | justincarmony | it could be called GNU/PTCCFW or something weird |
| 23:15.42 | fungus | mgeary, logs |
| 23:15.47 | mgeary | i just incremented the master zone file and restarted both nameservers... |
| 23:16.27 | fungus | also, compare serial numbers on both. |
| 23:16.46 | fungus | dig soa domain.com @ns1; dig soa domain.com @ns2 |
| 23:17.03 | mgeary | i can confirm that the serial #s disagree |
| 23:17.14 | fungus | but is the slave > master? |
| 23:17.20 | fungus | it's an integer comparison |
| 23:17.20 | mgeary | no |
| 23:17.28 | mgeary | slave is much older than master |
| 23:17.45 | mgeary | slave: 2009111001, master: 2010020201 |
| 23:18.25 | fungus | k, same number of digits... now check logs for errors |
| 23:18.35 | mgeary | trying to remember where the bind logs are on OS X |
| 23:18.48 | mgeary | it's a funky location |
| 23:18.52 | mgeary | what is the log usually named? |
| 23:18.57 | fungus | isn't everything directed to /var/log/system.log on OSX |
| 23:19.02 | mgeary | no |
| 23:19.06 | fungus | bummer |
| 23:20.02 | mgeary | what is the log usually named? |
| 23:20.04 | mgeary | by default? |
| 23:20.54 | fungus | goes to syslog |
| 23:21.05 | mgeary | <PROTECTED> |
| 23:21.41 | mgeary | so, the master logs seem fine |
| 23:29.17 | romanovic | unum: how long have we been banned from #utah? I'm never very vocal in #utah but I noticed it yesterday morning |
| 23:29.57 | unum | romanovic: I didn't try until just now |
| 23:29.58 | justincarmony | huh, I can talk just fine in utah. |
| 23:30.08 | justincarmony | did they ban people out-of-state? |
| 23:30.11 | unum | maybe I just need to register |
| 23:30.15 | unum | I'm in state |
| 23:30.18 | justincarmony | yeah |
| 23:30.18 | romanovic | dunno. i'm in state too |
| 23:30.21 | justincarmony | probably |
| 23:30.24 | romanovic | comcast? |
| 23:30.28 | unum | actaully I'm pretty sure I'm registered |
| 23:30.29 | justincarmony | thats what I thought |
| 23:30.34 | unum | they might be doing +v |
| 23:30.41 | unum | I'm not on comast |
| 23:30.43 | unum | oh wait |
| 23:30.45 | *** join/#uphpu beandog (~steve@gentoo/developer/beandog) |
| 23:30.46 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 23:30.46 | unum | I'm not in state |
| 23:30.55 | unum | forgot I connected from linode |
| 23:31.41 | romanovic | ah. I identified, can speak now |
| 23:32.00 | romanovic | I usually don't identify, but it hasn't been an issue till this week |
| 23:48.59 | beandog | what would you guys recommend for a simple bug tracker? |
| 23:49.04 | beandog | Im thinking about just using trac |
| 23:49.19 | beandog | hmm, I wonder if it supports git. |
| 23:52.45 | DexterTheDragon | beandog: I'm a fan of redmine |
| 23:52.46 | *** part/#uphpu Utah_Dave (~David@72-166-51-162.dia.static.qwest.net) |
| 23:53.01 | beandog | Everyone wants me to switch to git |
| 23:53.18 | DexterTheDragon | git is the best |
| 23:53.25 | beandog | DexterTheDragon, why? |
| 23:53.40 | DexterTheDragon | better workflow than svn |
| 23:53.46 | beandog | Like, how would you compare it to svn |
| 23:54.43 | DexterTheDragon | more powerful |
| 23:55.01 | DexterTheDragon | the ability to branch and merge without a full day of planning is worth it alone |
| 23:55.08 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net) |
| 23:56.36 | beandog | "allowing full functionality when disconnected from the network" |
| 23:56.37 | beandog | Okay |
| 23:56.40 | beandog | That about sells me right there. |
| 23:57.00 | DexterTheDragon | distributed ftw |
| 23:58.45 | beandog | Hmm |
| 23:58.46 | beandog | Okies. |
| 23:58.54 | beandog | DexterTheDragon, redmine looks nice ... |
| 23:58.59 | beandog | a lot simpler than trac |
| 23:59.16 | DexterTheDragon | yeah I think its a lot easier to understand then trac |
| 23:59.49 | DexterTheDragon | can do multiple projects, has integration with like all VCS's |