#arpnetworks 2009-11-10,Tue

cool
so i have an sqlite database. site is decent
i need help with two things
a) i need it to take $bd_real, which is real date of birth.. and +3 +6 +9 days to it, wrapping on the correct days
b) i need it if the wrong birthday is selected twice, to update sql under locked.. to add 1
to lock the user

[14:47]

cablehead

what are you serving this behind, pretty sure sqlite should only be opened by a single process ..

[14:50]

jeev

yea, it's querying just fine
foreach($result as $row) {
$locked = $row[locked];
...
pretty ghetto
$bd_real = $row[dateofbirth]; //here goes the REAL birthday output
$bd_fake1 = "05/20/85";
$bd_fake2 = "09/13/85";
but i dont want to make it static fake birthdays

[14:51]

cablehead

jeev: does this help? http://www.php.net/manual/en/datetime.add.php
jeev: but i'm curious now .. what *are* you serving this behind? :)

[14:54]

jeev

what do you mean serving it behind
heh

[14:55]

cablehead

e.g. apache etc

[14:55]

jeev

yea, apache

[14:56]

cablehead

jeev: using threaded workers?

[14:56]

jeev

heh i'm using default apache installation
i dont know what you mean by that
i like mpm and workers/ i dunno

[14:57]

cablehead

just wondering how you're getting concurrent access to sqlite

[14:58]

jeev

is this gonna be a problem ?
i never thought of that

[14:58]

cablehead

should be ok with mpm
just discouraged
http://www.sqlite.org/faq.html#q6

[15:00]

jeev

thanks i'll look at that
but do you know what i should do about those two issues

[15:01]

cablehead

jeev: ah, the dateadd function doesn't help?
i'm guessing it does wrapping
available in 5.3 onwards .. looks like you can use date modify before that

[15:02]

jeev

trying date sub
date_sub($date, new DateInterval("P5D"));
echo '<br />'.$date->format("d-m-Y").' : 5 Days';
right
oh i need ad

[15:03]

cablehead

jeev: what's the issue with updating the lock variable?

[15:03]

jeev

let me try the date thing first
i dunno how to get started for that
http://expressionengine.com/forums/viewthread/119962/
lol
that doesn't even work
Today = 2009 11 10
Today + 4 months = 2009 09 01

[15:04]

cablehead

eeg

[15:09]

Thorgrimr

Still messing with that jeev?

[15:09]

jeev

yea just got back into it
lets do it!

[15:10]

Thorgrimr

fun fun

[15:10]

jeev

;>
i'm almost done man

[15:11]

Thorgrimr

Cool

[15:11]

jeev

any suggestions

[15:20]

.... (idle for 19mn)

[15:39]

.... (idle for 16mn)

up_the_irons

cablehead: what do you think of "Go" ?

[15:55]

cablehead

up_the_irons: i'm pretty interested ..
up_the_irons: just messing with it now

[15:55]

jeev

cablehead: how about $bd_fake1 = strtotime(date("mm-dd-yy", strtotime($bd_real)) . " +1 day");

[15:56]

cablehead

up_the_irons: what do you think?

[15:56]

up_the_irons

cablehead: i haven't got passed reading the article

[15:56]

cablehead

jeev: does it work?

[15:56]

up_the_irons

cablehead: some of the stuff Pike puts out I can agree with, some is very arcane

[15:56]

cablehead

cablehead: oh yeah?
oops
up_the_irons: oh yeah?

[15:57]

up_the_irons

cool
cablehead: ever tried Plan 9?

[15:57]

cablehead

up_the_irons: i only know of it by reputation .. you've tried it?

[15:57]

up_the_irons

cablehead: or IO?

[15:57]

cablehead

i don't know IO

[15:57]

up_the_irons

cablehead: no, but there was a dude at my last gig that tried to get IO running on Plan 9, or some weird ass shit like that; and he actually got Pike to accept a patch ;)

[15:58]

cablehead

damn, the compiler for this thing is 6g on 686 platforms, 8g for 386 platforms, named after the plan 9 c compilers
and then the linker is 6l or 8l respectively

[15:58]

jeev

nope cablehead
blank

[15:59]

up_the_irons

haha, sounds like something he'd do

[15:59]

cablehead

jeev: haha, then that's no good :)
up_the_irons: hehe
there's a package for a working http server .. seeing if i can get that going

[15:59]

up_the_irons

interesting

[16:01]

jeev

cablehead, ahhhh! what do i do

[16:02]

cablehead

jeev: really, date_add isn't working?
that's crazy
jeev: might be faster to re-implement in go

http://golang.org/pkg/time/

[16:04]

jeev

are you serious hehe

[16:06]

cablehead

haha

[16:06]

jeev

not using date_add

[16:06]

cablehead

nah
that is painful though if the builtin date add isn't working

[16:06]

jeev

ah shit
$bd_fake1 = strtotime(date("mm/dd/yyyy", strtotime($bd_real)) . " +1 day");
it should be like that

[16:06]

...... (idle for 26mn)

***

visinin has joined #arpnetworks

[16:33]

.......... (idle for 46mn)

visinin has quit IRC ("word")

[17:19]

................. (idle for 1h21mn)

jeev

cableheaD, THERE?
woops

[18:40]

.......... (idle for 48mn)

***

vxp has joined #arpnetworks

[19:28]

heavysixer has quit IRC ()
ballen has joined #arpnetworks
ChanServ sets mode: +o ballen

[19:42]

ballen

blah

[19:46]

***

vxp has quit IRC (Read error: 60 (Operation timed out))

[19:47]

jeev

i got it

[19:48]

***

vxp has joined #arpnetworks

[19:54]

ballen

got wha

[20:03]

toddf

his master faking birthday php sqlite fuzz to work

[20:03]

ballen

mmk

[20:04]

toddf

143619 < jeev> anyone got a moment to help with some php
164844 < jeev> so i have an sqlite database. site is decent
165218 < jeev> pretty ghetto
165234 < jeev> but i dont want to make it static fake birthdays
171046 < Thorgrimr> Still messing with that jeev?
171159 < jeev> i'm almost done man
175700 < jeev> cablehead: how about $bd_fake1 = strtotime(date("mm-dd-yy", strtotime($bd_real)) . " +1 day");
180733 < jeev> ah shit
180751 < jeev> $bd_fake1 = strtotime(date("mm/dd/yyyy", strtotime($bd_real)) . " +1 day");
180755 < jeev> it should be like that
214943 < jeev> i got it
some funny out of context exerps but you get the idea

[20:08]

........ (idle for 38mn)

ballen

heh yea

[20:48]

................... (idle for 1h32mn)

***

ballen has quit IRC ()
ballen has joined #arpnetworks
ChanServ sets mode: +o ballen

[22:20]

ballen

testing new os x irc clients
on to: http://limechat.net/mac/
Windows XP is so freakin lame

[22:22]