| 00:02.50 | *** join/#uphpu TuxToaster (~TuxToaste@c-67-186-238-165.hsd1.ut.comcast.net) |
| 00:15.45 | *** part/#uphpu mgeary (~mgeary@166.70.44.49) |
| 00:24.22 | *** join/#uphpu supernovia (~Adium@c-98-202-112-234.hsd1.ut.comcast.net) |
| 02:19.59 | *** join/#uphpu eco (~eco@gnuk.net) |
| 02:19.59 | *** mode/#UPHPU [+v eco] by ChanServ |
| 03:09.11 | *** join/#uphpu carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 03:09.12 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 03:41.05 | *** join/#uphpu thebigdog (~thebigdog@207.135.132.13) |
| 03:41.05 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 04:00.41 | *** join/#uphpu supernovia (~Adium@c-98-202-112-234.hsd1.ut.comcast.net) |
| 04:34.31 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 04:34.31 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 04:36.44 | *** part/#uphpu supernovia (~Adium@c-98-202-112-234.hsd1.ut.comcast.net) |
| 05:01.19 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 05:01.19 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 05:54.09 | *** join/#uphpu romanovic-afk (~romanovic@91.151.155.164) |
| 07:05.09 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net) |
| 09:25.53 | *** join/#uphpu romanovic (~romanovic@91.151.155.164) |
| 09:52.28 | *** join/#uphpu romanovic-afk (~romanovic@91.151.155.164) |
| 09:57.29 | *** join/#uphpu romanovic (~romanovic@91.151.155.164) |
| 13:05.22 | *** join/#uphpu cro (~cro@166-70-222-105.ip.xmission.com) |
| 13:50.19 | *** join/#uphpu thebigdog (~thebigdog@dsl093-228-015.slc1.dsl.speakeasy.net) |
| 13:50.19 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 14:13.54 | *** join/#uphpu brasto (~brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 14:17.48 | *** join/#uphpu brasto1 (~brasto@c-67-182-203-21.hsd1.ut.comcast.net) |
| 14:31.15 | *** join/#uphpu jamund (~jamund@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 14:53.00 | *** topic/#UPHPU by macnewbold -> Meeting This Thursday 2010-09-16: thebigdog presents "PHP Debugging" 7pm @ CG | Utah PHP Users Group | uphpu.org |
| 15:00.21 | *** join/#uphpu fungus (~olsonl@bromine.sosstaffing.com) |
| 15:00.21 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 15:14.21 | *** join/#uphpu supernovia (~supernovi@76.8.222.23) |
| 15:15.57 | wps | why oh why oh why do people think they have to paste a screenshot into a word doc before emailing it? |
| 15:17.20 | wps | actually, I just realized the answer |
| 15:17.25 | wps | it's microsoft's fault |
| 15:18.00 | wps | their OS doesn't provide a way to take a screenshot and save it out as a fileâ¦Â only to take one and have it placed on the clipboardâ¦Â so the user has to paste it somewhere |
| 15:18.19 | wps | stupid micrsoft |
| 15:20.50 | supernovia | Well, if they have word, chances are they have Outlook as well |
| 15:20.58 | supernovia | and they should be able to paste directly into that, at least... |
| 15:24.44 | thebigdog | technically they should paste it to paint right |
| 15:24.51 | thebigdog | and then convert it to a bmp |
| 15:25.17 | wps | that's what I'd do if I was using windows (paste it into MS Paint and then save it out as an image) |
| 15:27.30 | wps | or just use a hosted screenshot utility like Jing so that all I have to send is a URL |
| 15:27.57 | *** join/#uphpu mgeary (~mgeary@166.70.44.49) |
| 15:27.57 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:38.06 | wps | wowâ¦Â that takes me back |
| 15:38.11 | mgeary | there's comparatively not a lot of September songs in my playlist |
| 15:38.18 | mgeary | i've only got 3 |
| 15:38.35 | wps | I got the Hot August album for my birthday when I was eight I think |
| 15:38.41 | mgeary | whereas i have 21 October songs. Doesn't hurt that U2 has an album with that name |
| 15:38.53 | wps | s/Hot August/Hot August Night/ |
| 15:39.26 | mgeary | heh. i got The Rainbow Connection album for Christmas when I was 8 |
| 15:58.27 | *** join/#uphpu romanovic (~romanovic@91.151.155.164) |
| 16:10.57 | *** join/#uphpu redroy (~Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 16:15.12 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 16:15.12 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 16:16.56 | *** join/#uphpu romanovic-afk (~romanovic@91.151.155.164) |
| 16:20.15 | *** join/#uphpu cro (~cro@67.50.43.122) |
| 16:30.38 | *** join/#uphpu cro (~cro@67.50.43.122) |
| 16:31.38 | mgeary | ~congratulate romanovic |
| 16:31.38 | ibot | ACTION congratulates romanovic on being a new owner of a $500 brick. |
| 16:32.01 | romanovic | LOL |
| 16:32.05 | romanovic | fortunately no. |
| 16:32.44 | romanovic | I only needed to use a single iptables command to modify the ttl of incoming packets |
| 16:32.47 | romanovic | nothing too dangerous |
| 16:33.12 | romanovic | the result of a lot of googling, since i am not very network savvy |
| 16:34.57 | *** join/#uphpu Dezertol (~toph@63.224.147.97) |
| 16:43.29 | *** join/#uphpu redroy (~Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 16:48.17 | *** join/#uphpu carmony (~justin@c-24-10-194-172.hsd1.ut.comcast.net) |
| 16:48.17 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 16:51.12 | *** join/#uphpu cro1 (~cro@67.50.43.122) |
| 16:54.47 | *** join/#uphpu redroy (~Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 16:55.17 | carmony | wow, nginx... was super easy to seetup |
| 17:11.16 | *** join/#uphpu SunSparc (~sparky@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 17:11.16 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 17:17.37 | *** join/#uphpu Utah_Dave (~Utah_Dave@72-166-51-162.dia.static.qwest.net) |
| 17:17.37 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 17:20.40 | supernovia | Ever have that feeling that you're juggling too many balls already, but they're all in other people's courts? |
| 17:21.27 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 17:21.27 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 17:22.37 | fungus | I don't usually play with other people's balls. |
| 17:23.06 | fungus | It's much easier to just play with your own. |
| 17:24.18 | fungus | right, it's a lot less stressful not to worry about stuff you can't control. |
| 17:24.34 | fungus | methinks mindjuju had his mind in the gutter. :) |
| 17:25.47 | mindjuju | touche |
| 17:26.51 | carmony | lol, I think I've run into my first real "cool need for the Cloud" situation |
| 17:29.59 | carmony | when we do these key giveaways for game developers, and its a real hot items, we can have an increase of anywhere from 500-5,000 users slam the site, so we've engineered the ability to partition the game key giveaways off onto the cloud, and be able to spin up the needed resources for the three days or so the giveaway is active. |
| 17:33.11 | Dezertol | is today over yet |
| 17:33.46 | *** join/#uphpu jamund (~jamund@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 17:33.46 | Dezertol | which is better for file uploading from one php site to a content server curl or php streams? |
| 17:34.25 | Dezertol | curl seems to be a bit easier but.. I can't be 100% sure that curl will be installed on the remote servers |
| 17:34.31 | *** join/#uphpu SunSparc (~sparky@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 17:34.31 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 17:35.47 | PoeticIntensity | Yo... anyone here have experience with CakePHP's "contain" ModelBehavior? |
| 17:37.51 | PoeticIntensity | (possibly SunSparc ^^^) |
| 17:42.56 | *** join/#uphpu josephscott (~josephsco@74.200.246.169) |
| 17:42.56 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 17:47.23 | macnewbold | PoeticIntensity: we use it here at CG |
| 17:47.39 | macnewbold | i know it soem, and have some others here who know it better |
| 17:47.46 | macnewbold | DexterTheDragon knows it really well |
| 17:48.25 | PoeticIntensity | awesome... |
| 17:48.26 | PoeticIntensity | well... |
| 17:49.00 | PoeticIntensity | I've got a situation, where I'm not sure if it'd be best to use a raw query, or try to finagle Cake into getting the right results... |
| 17:49.07 | PoeticIntensity | Here's my query (and it works perfectly) |
| 17:49.15 | PoeticIntensity | select n.date_created, n.news_copy, a.display_name, (SELECT nickname FROM nicknames WHERE nicknames.author_id = a.id ORDER BY RANDOM() LIMIT 1) AS nickname FROM news n LEFT JOIN authors a ON n.author_id=a.id LIMIT 1 |
| 17:49.24 | SunSparc | PoeticIntensity: contain, yes, I played with it a little bit. Have not completely wrapped my mind around it. |
| 17:49.37 | PoeticIntensity | (thanks, SunSparc.. Hopefully you can help) |
| 17:49.53 | PoeticIntensity | authors HasMany news |
| 17:49.58 | SunSparc | I tried applying it to a couple situations and it did not seem to fit so I took other avenues. |
| 17:49.58 | PoeticIntensity | authors HasMany Nicknames |
| 17:50.26 | PoeticIntensity | I want to pull the 10 latest news items along with its associated authors... |
| 17:50.33 | PoeticIntensity | (so far, no problem.. cake does this perfectly) |
| 17:50.38 | PoeticIntensity | BUT.... |
| 17:50.49 | PoeticIntensity | I also want 1 random nickname pulled along with each news story... |
| 17:50.58 | PoeticIntensity | nicknames have no association with news items... |
| 17:51.16 | PoeticIntensity | So, getting a news story with its author, and one associated nickname has proven to be a bit of a headache. |
| 17:51.46 | PoeticIntensity | #cakephp directed me to "contains", and it seems it might work, but I haven't had any success yet. |
| 17:52.28 | PoeticIntensity | It's frustrating when I can whip up the raw SQL in less than 2 minutes to do precisely what I want, and it'll most likely take me hours to try to get cake to do it.... But I guess that's the learning curve. |
| 17:52.47 | PoeticIntensity | any help or direction would be awesome... |
| 17:53.01 | PoeticIntensity | I know I can just use "query" and get the job done quick, but - that won't teach me anything about cake. |
| 17:54.10 | PoeticIntensity | oh, looks like the SQL had a minor error. The last "LIMIT 1" is un-necssary. |
| 18:08.25 | *** join/#uphpu supernovia (~supernovi@76.8.222.23) |
| 18:44.47 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.194.provo.static.broadweavenetworks.net) |
| 19:30.31 | *** join/#uphpu Dezertol (~toph@63.224.147.97) |
| 20:09.23 | PoeticIntensity | Ya know... On 2nd thought, it might be better all around to just use raw SQL in this case, because unless I'm missing something (which is entirely possible)... |
| 20:09.40 | PoeticIntensity | most of the reasons to use cake's auto-sql magic stuff is so bad stuff doesn't get into your db... |
| 20:09.45 | PoeticIntensity | this one is entirely "select" |
| 20:10.17 | macnewbold | PoeticIntensity: the other nice thing about contains and friends is that they pull everything back in a cake-friendly way, so it's easy to use native functions to access/process it |
| 20:10.50 | PoeticIntensity | for sure... |
| 20:11.04 | PoeticIntensity | Cake is turning out to be quite the delightful beast. |
| 20:11.21 | macnewbold | you might be able to simply pull that subquery as a field in your find(), but i'm not sure |
| 20:11.42 | PoeticIntensity | that'd be awesome. |
| 20:11.47 | macnewbold | i'm not really sure why someone recommended a contains for this |
| 20:12.06 | macnewbold | generally contains is used for fine-grain control (better than recursive=2 or something) over which related objects you pull in |
| 20:14.06 | macnewbold | at least, that's how we use it |
| 20:17.14 | carmony | man, it astounds me just how... awesome, linux and ssh is |
| 20:17.38 | carmony | it blows my mind how easy some things are in linux where as on windows servers its a ---nightmare--- to try to do the same thing |
| 20:32.18 | mgeary | totally |
| 20:32.24 | mgeary | rsync+++ |
| 20:45.58 | macnewbold | amen brothas |
| 20:46.38 | macnewbold | Terminal.app and a native ssh client are some of my best friends on OSX and one of the main reasons I can stand it |
| 20:46.48 | macnewbold | a native X11 server doesn't hurt either... |
| 20:52.44 | mgeary | psh. OS X is awesome. Look at the spectrum of people that use it. You've got hardcore developers of all stripes right down to little old grandmas |
| 20:53.24 | mgeary | not to say there aren't things that bug me, but i wouldn't have my Grandma use any other flavor of *nix |
| 20:59.12 | thebigdog | macnewbold: iterm is really nice |
| 21:00.31 | stderr | Terminal.app + Visor |
| 21:01.08 | jsmith | Or, liked (past tense) |
| 21:01.45 | thebigdog | ~whip jsmith |
| 21:01.45 | ibot | ACTION takes jsmith outside to be thoroughly whipped by thebigdog |
| 21:02.24 | jsmith | thebigdog: My current employer decided I should have a ThinkPad instead |
| 21:04.23 | stderr | best alternative |
| 21:07.16 | jsmith | This is a killer machine... |
| 21:07.26 | jsmith | i7, lots of ram, big screen, oodles of battery |
| 21:09.27 | fungus | lol, it might be construed by others as a bit hypocritical if you continued to us OSX. |
| 21:11.33 | macnewbold | yeah, having apple hardware is one thing, but you'd have to boot linux on it and put a nice sticker over the glowing apple on the top |
| 21:11.47 | macnewbold | i've heard freebsd runs well on apple hardware, hint hint |
| 21:13.35 | PoeticIntensity | ~linux++ |
| 21:13.46 | PoeticIntensity | can't imagine using anything else... ssh is the bomb. |
| 21:13.49 | fungus | hehe, I think by virtue of the "dog food" argument, he's stuck with one choice. |
| 21:15.00 | thebigdog | but you can have ssh on almost everything |
| 21:19.03 | PoeticIntensity | also macnewbold, this (I think) may be why they offered contain as a solution. |
| 21:19.04 | PoeticIntensity | http://stackoverflow.com/questions/2516201/cakephp-multiple-nested-joins |
| 21:28.45 | SunSparc | jsmith: What do you like about Fedora? And have you compared it to Ubuntu and other flavors? |
| 21:29.48 | jsmith | SunSparc: Obviously :-) |
| 21:30.07 | jsmith | SunSparc: I like that I can use the same tools on my desktop that I do on my servers. |
| 21:30.23 | SunSparc | jsmith: Like what? |
| 21:31.20 | wps | I'd like some suggestions on how to store some data |
| 21:31.38 | macnewbold | PoeticIntensity: interesting |
| 21:31.46 | SunSparc | wps: Hanging files from Office Max? |
| 21:31.58 | wps | I'm building an app that has records that have a recurrence |
| 21:32.09 | wps | could be anything from every two days |
| 21:32.12 | wps | every other week |
| 21:32.28 | macnewbold | i'm with jsmith... that's part of what i like about running freebsd on my desktop as well as on my servers |
| 21:32.44 | wps | twice a year on the third tuesday and fourth friday of November |
| 21:32.49 | thebigdog | i'm with macnewbold ....that is why i like gentoo |
| 21:33.03 | macnewbold | i do different kinds of things on my desktop, and learn new tricks that are very useful on my servers but i would have never likely learned had it not been for needing it on my desktop first |
| 21:33.11 | SunSparc | jsmith: I am asking because I stopped using RedHat many years ago in favor of other flavors and have not had a desire to go back to it or any of it's derivatives. Just curious about what I am missing. |
| 21:33.30 | macnewbold | wps: kind of like a calendar or something? |
| 21:33.33 | wps | yeah |
| 21:33.42 | wps | they are tasks |
| 21:33.43 | macnewbold | have you tried google calendar? |
| 21:33.49 | macnewbold | (just kidding :-) ) |
| 21:33.51 | wps | yes, it's crap |
| 21:34.02 | macnewbold | have you tried www.gradefix.com for your tasks? |
| 21:34.19 | macnewbold | (just kidding :-) no need for the 'yes it's crap' comment) |
| 21:34.25 | *** join/#uphpu josephscott_ (~josephsco@74.200.246.169) |
| 21:34.25 | *** mode/#UPHPU [+v josephscott_] by ChanServ |
| 21:34.29 | thebigdog | yes it's crap |
| 21:34.34 | macnewbold | ~silence thebigdog |
| 21:34.34 | ibot | ACTION shoves an apple in thebigdog's mouth, shoves a spit through ... well, uhm, anyway ... then builds a nice fire and starts roasting |
| 21:34.53 | wps | well, "crap" might be a little strong, but I don't think that google calendar is a very well designed application |
| 21:35.00 | thebigdog | now that would have been really funny..had I been eating an apple |
| 21:35.43 | wps | anywayâ¦Â I'm struggling with how to store such data |
| 21:35.45 | macnewbold | wps: generally from what i understand, you've got to build the different ways in which things can recur/repeat - daily, weekly on selected days of the week, monthly by day of week (3rd thursday) or by date (15th), yearly (in selected months) |
| 21:36.00 | wps | that's where I'm headed |
| 21:36.09 | PoeticIntensity | ~thebigdog++ for gentoo. |
| 21:36.09 | macnewbold | there's not a terribly efficient way to do it afaik, just a field to say what type of repeat it is, then fields to store the other data |
| 21:36.21 | wps | I have a frequency (daily, weekly, monthly, yearly) |
| 21:36.36 | wps | and then a rate ("every 2") |
| 21:36.49 | SunSparc | PoeticIntensity: yeah, I am big Gentoo advocate also, though I have been enjoying Ubuntu recently. |
| 21:37.24 | wps | (a calendar is also different than a multi-user task management application) |
| 21:37.48 | wps | but the part that I'm struggling with is how to store "last saturday" or "first and seventeenth" |
| 21:37.59 | wps | the best I have come up with is to assign an integer to each option |
| 21:38.10 | wps | then store that integer as an int |
| 21:38.33 | wps | then I can look up the option and perform the necessary calculation (generate the new date) |
| 21:38.55 | PoeticIntensity | yeah, SunSparc... I'm not sure why, but I lost interest in using other distros about 5 years ago. unless something really cool happens with one distro that can't for gentoo, Imma stay with what I like... :) |
| 21:39.13 | SunSparc | :) that works |
| 21:40.49 | wps | the problem with that though is that the list of options would be quite big |
| 21:40.59 | wps | just days of the week would be seven to the seventh |
| 21:41.22 | wps | (at leastâ¦Â covering all available options) |
| 21:42.04 | thebigdog | what are you wanting to save in the db wps? |
| 21:42.14 | thebigdog | you can have them create the interval and should be able to run it |
| 21:42.25 | wps | a recurrence pattern |
| 21:42.35 | wps | (date) |
| 21:42.48 | SunSparc | What about the cron method? |
| 21:42.58 | wps | well, it's actually a regeneration rate |
| 21:43.02 | wps | how often a task will regenerate |
| 21:43.26 | SunSparc | wps: ^ |
| 21:43.30 | thebigdog | i woudl start out with specific options and then fk them |
| 21:43.33 | wps | you mark it complete and it will automatically regenerate itself with a due date that next meets the regeneration rule |
| 21:44.04 | thebigdog | macnewbold might have some better options |
| 21:44.11 | wps | what do you mean by "fk them?" |
| 21:44.12 | thebigdog | cron though for a user might be hard too handle |
| 21:44.16 | macnewbold | foreign key |
| 21:44.28 | wps | well, the user will have a very user-friendly interface for selecting the schedule |
| 21:44.33 | wps | I just need to figure out how to store it in the database |
| 21:44.40 | macnewbold | therein lies the rub |
| 21:44.48 | wps | ah |
| 21:44.51 | macnewbold | do you have a place where you show a list of upcoming tasks, |
| 21:44.55 | macnewbold | or a calendar view or anything? |
| 21:45.00 | wps | no calendar view |
| 21:45.06 | wps | I was thinking of putting it in another table |
| 21:45.08 | wps | fk |
| 21:45.09 | macnewbold | cause in many cases, you'll need to have multiple entries for the same task, due to the repetition |
| 21:45.21 | wps | just trying to determine if there was a more simple method |
| 21:45.29 | wps | that's probably the cleanest method though |
| 21:45.46 | wps | that's one thing I'm doing different than a calendar |
| 21:45.54 | wps | you don't ever see multiple entries |
| 21:46.03 | wps | in a calendar, if I have a recurring appointment, I see them all into the future |
| 21:46.20 | wps | with my app, it's not recurringâ¦Â it regenerates |
| 21:46.29 | wps | you mark the task complete and then it will regenerate |
| 21:47.34 | wps | the cron method cannot support this type of a recurrance, right? |
| 21:47.43 | wps | "every sunday and wednesday" |
| 21:47.54 | SunSparc | Sure it can. |
| 21:47.59 | SunSparc | cron can do anything. |
| 21:48.00 | SunSparc | :) |
| 21:48.18 | wps | hmmâ¦Â SunSparc will you show me an example? |
| 21:48.25 | SunSparc | k, hang on... |
| 21:48.44 | wps | what about "third thursday of each month"? |
| 21:49.41 | SunSparc | * * * * 0,3 /command/to/run <- every sunday and wednesday |
| 21:51.46 | wps | interesting |
| 21:51.50 | wps | I didn't know you could use comma |
| 21:51.55 | SunSparc | yep |
| 21:52.26 | SunSparc | man crontab is quite extensive and there are a ton of options most people never use or know about. |
| 21:52.30 | wps | can you do third thursday? |
| 21:52.44 | SunSparc | Yeah, finding it... |
| 21:52.57 | wps | ah |
| 21:53.16 | wps | I think I found it |
| 21:53.52 | SunSparc | */3 I think |
| 21:54.47 | thebigdog | third thursday would be a little tricker |
| 21:55.03 | wps | * * * sun/3 |
| 21:55.05 | wps | ? |
| 21:55.07 | thebigdog | you would probably do a range |
| 21:55.12 | thebigdog | on the dates |
| 21:55.16 | thebigdog | days |
| 21:55.48 | wps | I'm liking this cron method |
| 21:55.57 | thebigdog | 0 0 15-21 * 4 |
| 21:56.03 | thebigdog | that would be pretty close |
| 21:58.24 | wps | would this do it? |
| 21:58.30 | wps | 0 0 15-21 * sun |
| 21:58.53 | thebigdog | that would be pretty close |
| 21:59.01 | thebigdog | or for sun you can use 0 too |
| 21:59.09 | thebigdog | 0 0 15-21 * 0 |
| 21:59.11 | wps | yeah |
| 21:59.30 | wps | I wonder if this would be the same: |
| 21:59.37 | wps | * * * * 0/3 |
| 21:59.51 | wps | waitâ¦Â noâ¦Â that'd be every third sunday |
| 21:59.55 | wps | not the third of each month |
| 22:00.09 | thebigdog | you want the third day of the month |
| 22:00.22 | wps | I want the third sunday of each month |
| 22:00.34 | wps | (in this hypothetical example) |
| 22:00.50 | thebigdog | 0 0 15-21 * 0 |
| 22:00.52 | wps | I think that "0 0 15-21 * 0" is the answer |
| 22:00.59 | thebigdog | yes |
| 22:01.07 | wps | coolâ¦Â thanks SunSparc/thebigdog |
| 22:01.09 | thebigdog | 15-21 is the day of the month range |
| 22:01.11 | wps | I think that this will be a good solution |
| 22:01.17 | SunSparc | :) np |
| 22:01.39 | thebigdog | you can use the php date functions too |
| 22:02.45 | SunSparc | True, the date functions are actually fairly robust. |
| 22:03.17 | wps | does it support ranges? |
| 22:03.28 | wps | lists? step values? |
| 22:03.43 | wps | I've never seen that with date() |
| 22:04.09 | thebigdog | http://www.php.net/manual/en/ref.datetime.php |
| 22:04.39 | thebigdog | http://www.php.net/manual/en/dateinterval.format.php |
| 22:04.45 | thebigdog | those are some of the new ones |
| 22:05.41 | thebigdog | if i were doing it i would come up with some strings |
| 22:05.53 | thebigdog | like every 3rd thurday or something like that as an option |
| 22:06.01 | thebigdog | that you could pass the values to the dateinterval |
| 22:06.12 | thebigdog | but start out with some simple ones and test it out |
| 22:06.24 | thebigdog | that is what i was meaning about foreign key them |
| 22:06.43 | thebigdog | then for your task you fk to an interval or something like that |
| 22:07.03 | wps | but wouldn't that table of options be huge? |
| 22:07.07 | wps | every sunday |
| 22:07.11 | wps | every sunday, monday |
| 22:07.18 | wps | every sunday, monday, tuesday |
| 22:07.21 | thebigdog | it could be |
| 22:07.21 | wps | every sunday, tuesday |
| 22:07.25 | wps | it's go on and on |
| 22:07.39 | thebigdog | or you create a standard ui that gives you the proper values to pass to the function |
| 22:08.03 | thebigdog | so you dont have to fk them |
| 22:08.26 | wps | that's what I'm leaning towards⦠create a UI that's simple for the userâ¦Â that generates a cron timeâ¦Â I store that in the DBâ¦Â and then when the task is completed, I parse the cron time to determine when the next time should be |
| 22:08.54 | wps | there might even be a PHP library that already exists for parsing cron time strings |
| 22:10.01 | thebigdog | how do you plan to run your tasks though |
| 22:10.14 | wps | what do you mean? |
| 22:10.35 | thebigdog | what would you use the cron for? |
| 22:10.41 | thebigdog | that is usually to run something |
| 22:11.00 | wps | I'm not going to actually use cron |
| 22:11.13 | wps | I'm just using the cron-style time string |
| 22:12.16 | thebigdog | ok still unclear why not use the date format that i linked you |
| 22:12.31 | thebigdog | and just have it ready for php directly |
| 22:12.40 | wps | I open to better options, but I don't understand how I would use the PHP date |
| 22:12.43 | wps | can you give me an example? |
| 22:13.00 | thebigdog | http://www.php.net/manual/en/dateinterval.format.php |
| 22:13.23 | wps | how would I store something like "every sunday and wednesday" or "each month on the third sunday" in a database in PHP date format? |
| 22:13.34 | wps | I see that page, but don't understand how it helps me |
| 22:13.50 | thebigdog | that would be like your display text |
| 22:14.19 | thebigdog | then you have the format pattern as another column |
| 22:14.21 | thebigdog | or field |
| 22:14.29 | thebigdog | that is what you would pass to to the function |
| 22:14.36 | thebigdog | to help you determine the date |
| 22:15.35 | wps | sorry, but I'm still not following |
| 22:15.47 | wps | can you give me an example of the string you would store in the DB? |
| 22:16.05 | wps | (the string that would represent the recurrence pattern?) |
| 22:17.30 | thebigdog | http://www.php.net/manual/en/dateinterval.construct.php |
| 22:17.35 | thebigdog | that is the interval spec |
| 22:18.48 | thebigdog | then you can use the object to take a date and add the interval to it to give you a new date |
| 22:19.12 | thebigdog | or subtract or add intervals |
| 22:19.22 | wps | hmm⦠|
| 22:19.38 | thebigdog | does that help out |
| 22:19.42 | thebigdog | or did i confuse you more |
| 22:19.44 | wps | a little |
| 22:19.57 | thebigdog | well you want a interval |
| 22:19.58 | wps | having a built in PHP function to use would be awesome |
| 22:20.01 | thebigdog | and add that ot a date |
| 22:20.05 | thebigdog | right? |
| 22:20.08 | wps | yeah |
| 22:20.20 | wps | I can see how I could do "every year" (P1Y) |
| 22:20.26 | thebigdog | the interval spec would help you do that |
| 22:20.36 | stderr | http://stackoverflow.com/questions/1016170/how-would-one-represent-scheduled-events-in-an-rdbms |
| 22:20.45 | stderr | see the top answer |
| 22:20.55 | wps | or every 2 weeks (P2K)â¦Â but not "third thursday) |
| 22:21.05 | wps | thanks, stderr |
| 22:22.56 | stderr | http://martinfowler.com/apsupp/recurring.pdf also |
| 22:25.57 | thebigdog | wps mysql has some dates too that might help you |
| 22:28.52 | thebigdog | wps strtotime is another function you can check out |
| 22:29.39 | thebigdog | and read up on this - http://www.php.net/manual/en/datetime.formats.php |
| 22:29.41 | wps | that's what I'd use in my script that parses the cron time strings |
| 22:31.05 | thebigdog | what i am saying is that you might not need to have a cront time string |
| 22:31.28 | wps | just have an open text input for the user? |
| 22:31.29 | wps | :) |
| 22:31.38 | wps | they can type in "third thursday"? :) |
| 22:31.41 | wps | store that in varchar() |
| 22:31.45 | macnewbold | ew |
| 22:31.48 | wps | :) |
| 22:31.48 | macnewbold | eww |
| 22:31.51 | macnewbold | eeeewwww |
| 22:32.08 | macnewbold | ~fishslap wps with database normalization |
| 22:32.08 | ibot | ACTION slaps wps with database normalization up side the head with a wet fish. |
| 22:32.16 | thebigdog | no |
| 22:32.39 | thebigdog | you create the text from user input |
| 22:32.46 | thebigdog | come on now |
| 22:32.52 | wps | (I was just kidding) |
| 22:33.30 | wps | so, you're sayingâ¦Â having UI that allows the user to select what they wantâ¦Â and then store a string of text that strtotime() can understand in the database? |
| 22:34.01 | wps | that's not a bad idea |
| 22:34.38 | wps | strtotime() is really flexible |
| 22:34.45 | wps | (ie: it accepts a lot of stuff) |
| 22:35.29 | wps | hmmâ¦Â the "next wednesday or thursday" wouldn't work though |
| 22:36.10 | thebigdog | it might |
| 22:36.17 | thebigdog | next wednesday or next thursday |
| 22:36.37 | thebigdog | but wednesday would always come first |
| 22:37.22 | thebigdog | stderr gave some great examples on the table structure...then you have your intervals |
| 22:38.24 | wps | it's a lot to readâ¦Â but I'm willing to if you feel it's the better approach |
| 22:38.41 | wps | stderr: do you think that fk tables is a better approach than storing a cron-style time string? |
| 22:38.47 | thebigdog | that will give a good starting point for structure |
| 22:40.03 | thebigdog | really how many different intervals do you need to support |
| 22:40.15 | stderr | wps: yes, I do. |
| 22:40.54 | wps | what do you think about thebigdog's strototime() solution? |
| 22:41.09 | wps | it sure seems like a great solution if it can meet all my interval requirements |
| 22:41.47 | tierra | wps: WebCalendar is about the most extensive web-based open source calendar system I know of that's either mostly, or completely compatible with the iCal standard... here's the DB design for how they store events: http://webcalendar.cvs.sourceforge.net/viewvc/webcalendar/webcalendar/docs/WebCalendar-Database.html#webcal_entry |
| 22:42.03 | tierra | might be a little overkill for what you need though |
| 22:42.34 | wps | thanks, tierra |
| 22:42.40 | tierra | would have been nice if the iCal standard included a standard DB storage structure too |
| 22:42.44 | SunSparc | webcalendar is massive |
| 22:42.58 | SunSparc | But it has been around forever and has a big community. |
| 22:45.01 | tierra | I've personally written up something extremely close to a full iCal-compatible calendar event system in C++ using boost.datetime (a library which made doing so incredibly easy and efficient)... though I've never dealt with DB storage of that info, it was just serialized directly |
| 22:46.02 | *** join/#uphpu Utah_Dave (~Utah_Dave@72-166-51-162.dia.static.qwest.net) |
| 22:46.02 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 23:07.28 | *** join/#uphpu supernovia (~Adium@c-98-202-112-234.hsd1.ut.comcast.net) |
| 23:18.53 | *** join/#uphpu redroy (~Adium@c-174-52-217-149.hsd1.ut.comcast.net) |
| 23:50.51 | *** join/#uphpu brasto (~brasto@c-67-182-203-21.hsd1.ut.comcast.net) |