| 01:35.16 | leifmadsen | Juggie: ping |
| 03:57.42 | *** join/#asterisk-doc leifmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 03:57.43 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 04:15.36 | Juggie | leifmadsen, arnt you gone to bed! |
| 04:27.37 | leifmadsen | soooooooon :) |
| 04:28.02 | leifmadsen | I was thinking about some stuff about how to solve transferring to another agent, but keeping the talk_time going |
| 04:31.18 | leifmadsen | oooo! I might have just figured something out |
| 04:38.19 | leifmadsen | too bad 'endbeforehexten' doesn't actually work... grrrr |
| 04:39.58 | leifmadsen | oh there it goes! |
| 04:40.01 | leifmadsen | guess I needed to restart |
| 04:42.06 | leifmadsen | sweet, now I just need a marker to say, "add these values to the TRANSFER event in the events table" |
| 04:51.11 | Juggie | hehe |
| 04:51.19 | Juggie | cant sleep brain wont stop |
| 04:52.42 | Juggie | that unique id trunecating bug wont get fixed on 1.4/abe i dont think |
| 04:52.58 | leifmadsen | ya, I noticed that |
| 04:53.01 | leifmadsen | Juggie: ping |
| 04:53.05 | Juggie | pong |
| 04:53.08 | Juggie | you knew i was here :p |
| 04:53.10 | leifmadsen | hey for an update (sql) |
| 04:53.17 | leifmadsen | I didn't see the timestamp till after :) |
| 04:53.40 | leifmadsen | can I do: UPDATE events SET hold_time = hold_time + 5 WHERE foo = bar; ? |
| 04:54.18 | Juggie | yes |
| 04:54.22 | leifmadsen | awesome |
| 04:54.38 | leifmadsen | I'll show you my solution to the transfer + record extra time problem |
| 04:54.42 | leifmadsen | once I show that it works |
| 04:58.34 | leifmadsen | YES! |
| 04:58.36 | leifmadsen | it works! |
| 04:58.47 | leifmadsen | I think I have all these scenarios figured out now |
| 04:58.56 | leifmadsen | and no more modifications to your SQL |
| 04:59.05 | Juggie | nice nice |
| 04:59.14 | Juggie | that sql is not that complicated :0 |
| 04:59.22 | leifmadsen | not too bad |
| 04:59.30 | Juggie | just joins |
| 04:59.42 | leifmadsen | ya, it's been a while since I've done multiple joins |
| 04:59.44 | leifmadsen | I've done them before though |
| 04:59.45 | Juggie | which are the type of joins that should be done anyways |
| 04:59.50 | Juggie | doing joins in where are lazy joins :) |
| 05:00.05 | leifmadsen | heh :) |
| 05:00.59 | Juggie | i bitch at people at work all the time for what i call 'lazy code' |
| 05:01.16 | Juggie | if you write the same loop etc logic more then a few times then it belongs in a function :) |
| 05:01.16 | leifmadsen | so I modified it so that if you want to transfer to someone internally, but keep the time going, then you just transfers to _4XXX* instead of _4XXX which sets a variable on the channel, to tell the system to write to the database to update the TRANSFER field with the value from Q_CALLID (which is a var with the original Queues uniqueid) |
| 05:01.56 | Juggie | icic |
| 05:02.22 | leifmadsen | worked pretty good since most of the information had already been setup for me previously (by myself) |
| 05:02.39 | Juggie | everything is doable :P |
| 05:02.43 | leifmadsen | just created a new func_odbc function to do the talk_time = talk_time + ${ARG1} |
| 05:02.48 | leifmadsen | haha... not everything :) |
| 05:02.52 | Juggie | almost everything |
| 05:02.56 | leifmadsen | almost :) |
| 05:03.18 | leifmadsen | transfers + recordings + call control is impossible in a couple of scenarios |
| 05:03.28 | leifmadsen | but we had this discussion already :) |
| 05:03.46 | Juggie | ya |
| 05:03.59 | Juggie | you going to *con this year? |
| 05:04.41 | leifmadsen | hope so |
| 05:04.47 | leifmadsen | I submitted a speaking proposal |
| 05:04.59 | Juggie | ah so digium has to approve and fly you |
| 05:07.05 | leifmadsen | basically ya |
| 05:07.08 | Juggie | ok sleep, talk to you tomorow. |
| 05:07.11 | leifmadsen | unless I decide to fly myself |
| 05:07.16 | Juggie | 1am need to get up early to get blood work done. |
| 05:07.23 | leifmadsen | fun stuff, I have one more thing to fix here |
| 05:07.38 | Juggie | meh, just getting checked for iron,calcium, etc |
| 05:07.38 | leifmadsen | going to put this select statement into a view, then figure out how to update it because I need to modify the billsec too |
| 05:07.44 | leifmadsen | that's good |
| 05:07.50 | leifmadsen | I had some bloodwork done recently for insurance |
| 05:07.51 | Juggie | updateable views? |
| 05:08.20 | Juggie | you want to modify the billsec on the view? |
| 05:12.02 | leifmadsen | yep, and it works automatically in mysql |
| 05:12.23 | leifmadsen | just need to keep the numbers accurate on those certain kinds of transfers |
| 05:13.23 | leifmadsen | haha doh! I need to make sure I have a column for the callid |
| 05:13.38 | leifmadsen | or else I won't have anything unique to update on |
| 05:14.54 | leifmadsen | that was easy :) |
| 05:19.01 | *** join/#asterisk-doc snuff-home (n=snuffy@203-219-29-182-bri-ts6-2600.tpgi.com.au) |
| 05:23.46 | leifmadsen | Juggie: looks like I have a scenario where this isn't working quite right, so ping me tomorrow whenever you have a couple mins. |
| 06:01.17 | *** join/#asterisk-doc oej (n=olle@ns.webway.se) |
| 07:51.23 | *** join/#asterisk-doc ToTo (n=ToTo@62.120.143.36) |
| 08:08.00 | *** join/#asterisk-doc ToTo (n=ToTo@62.120.143.36) |
| 09:08.40 | *** join/#asterisk-doc Rochdi (n=sysadmin@196.203.51.17) |
| 09:10.41 | *** part/#asterisk-doc Rochdi (n=sysadmin@196.203.51.17) |
| 10:29.53 | *** join/#asterisk-doc snuff-home (n=snuffy@203-219-29-182-bri-ts6-2600.tpgi.com.au) |
| 11:15.16 | *** join/#asterisk-doc snuff-ho1e (n=snuffy@203-219-29-182-bri-ts6-2600.tpgi.com.au) |
| 12:31.55 | *** join/#asterisk-doc RobH_ (n=RobH@cpe-72-184-206-177.tampabay.res.rr.com) |
| 12:35.10 | *** join/#asterisk-doc RobH_ (n=RobH@cpe-72-184-206-177.tampabay.res.rr.com) |
| 12:58.41 | *** join/#asterisk-doc ctooley_ (n=ctooley@c-76-22-158-92.hsd1.tn.comcast.net) |
| 13:51.07 | *** join/#asterisk-doc leifmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 13:51.07 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 13:52.39 | leifmadsen | morning all! |
| 13:52.57 | jsmith | Morning leifmadsen... how 'bout my Caps, eh? |
| 13:53.11 | jsmith | Federov for the win! |
| 13:53.50 | *** join/#asterisk-doc RobH (n=RobH@208.80.152.135) |
| 13:54.53 | leifmadsen | booooooooooo :) |
| 13:55.28 | jsmith | leifmadsen: Oh, and did you see how the team you were bragging on (New Jersey) is no longer in the playoffs? |
| 13:55.31 | jsmith | ducks |
| 14:24.42 | leifmadsen | jsmith: I did see that, but I was cheering for the Canes :) |
| 14:24.57 | leifmadsen | (I like Paul Maurice, the coach who used to coach Toronto last year) |
| 14:25.28 | jsmith | leifmadsen: Yeah... I was actually cheering for NJ, just because I wanted them to beat the canes |
| 14:25.34 | leifmadsen | heh |
| 14:25.41 | leifmadsen | I'm not cheering for Boston :) |
| 14:25.44 | leifmadsen | errr |
| 14:26.27 | leifmadsen | now |
| 14:26.27 | leifmadsen | I'm now cheering for Boston |
| 14:26.27 | leifmadsen | jsmith: did I tell you I'm moving in with the g/f... |
| 14:26.27 | leifmadsen | like... this week? :) |
| 14:26.28 | jsmith | You told me it was a possibility.... but I didn't realize it was a done deal |
| 14:26.38 | leifmadsen | well, it is now, heh |
| 14:26.44 | leifmadsen | I even have my place rented for a month |
| 14:27.00 | leifmadsen | so I'm moving my server and phones today |
| 14:27.07 | jsmith | Oh happy day! |
| 14:27.24 | leifmadsen | heh |
| 14:27.32 | leifmadsen | ya, so I'll have to change the DNS over at some point |
| 14:27.59 | leifmadsen | should just bug file to let him host his website on his servers :D |
| 14:28.27 | file | BRING IT ON |
| 14:28.49 | leifmadsen | lol |
| 14:28.55 | leifmadsen | bug bug bug bug bug.... |
| 14:29.24 | leifmadsen | actually... could I? :) It's just some html and php |
| 14:30.52 | file | email me. |
| 14:31.51 | leifmadsen | okie! |
| 14:32.20 | leifmadsen | first_name@first_name-last_name.com ? |
| 14:32.58 | file | jcolp@joshua-colp.com |
| 14:33.13 | leifmadsen | does joshua work? |
| 14:33.22 | leifmadsen | I think I had this problem last time :) |
| 14:33.45 | leifmadsen | resent to jcolp |
| 14:33.47 | file | I doubt it. |
| 14:34.23 | leifmadsen | aha, yep, just got the rejection |
| 14:36.45 | file | Your request will be processed in approximately 24 hours. |
| 14:36.51 | leifmadsen | nice :) |
| 14:37.24 | file | you can change the DNS over to quark now if you want |
| 14:45.07 | *** join/#asterisk-doc RobH (n=RobH@cpe-72-184-206-177.tampabay.res.rr.com) |
| 14:48.55 | leifmadsen | file: okie, where should I point that at? |
| 14:49.01 | leifmadsen | quark.joshua-colp.net ? |
| 14:49.09 | leifmadsen | (the IP of which) |
| 14:49.25 | file | quark.joshua-colp.com |
| 14:49.30 | leifmadsen | errr.com |
| 14:49.32 | leifmadsen | ya |
| 14:49.39 | file | 216.237.124.26 |
| 14:51.35 | leifmadsen | done! |
| 14:57.41 | Juggie | leifmadsen: you rang |
| 14:58.32 | Juggie | leifmadsen: who hosts your dns? |
| 15:04.45 | leifmadsen | lol |
| 15:04.53 | leifmadsen | file: my dns is already changed for juggie :) |
| 15:05.10 | Juggie | i'm using opendns |
| 15:05.13 | Juggie | if that matters :) |
| 15:05.18 | leifmadsen | zoneedit for me |
| 15:05.33 | Juggie | leifmadsen, i use everydns i like it. |
| 15:05.39 | Juggie | but i guess if zone edit works :) |
| 15:05.41 | Juggie | no point in changing |
| 15:05.46 | leifmadsen | heh, ya it works |
| 15:06.12 | Juggie | you have free service though right? |
| 15:06.16 | Juggie | does it let you do mx entries etc |
| 15:06.38 | Juggie | indeed it does :) |
| 15:07.53 | leifmadsen | Juggie: yep! that's how I have mail.leifmadsen.com at google |
| 15:11.54 | Juggie | nice nice |
| 15:12.04 | Juggie | google makes everything easy :) |
| 15:12.07 | Juggie | except girls |
| 15:15.37 | leifmadsen | totally |
| 15:15.42 | leifmadsen | especially not girls |
| 15:19.27 | Juggie | file, how much does it cost you for your hosting w/ subnet etc. |
| 15:19.57 | file | quark is $69/mth |
| 15:29.36 | Juggie | really for like 8 ips and a server |
| 15:29.39 | Juggie | thats not too bad |
| 15:29.49 | Juggie | or do you have multiple boxes |
| 15:31.15 | file | I have 2 |
| 15:31.17 | file | quark and neutrino |
| 15:32.02 | file | 5 usable IPs on each. |
| 15:32.20 | file | 2TB of bandwidth on each. |
| 15:33.04 | jsmith | Not bad... where's the colo? |
| 15:33.11 | jsmith | should install a box or two there |
| 15:33.20 | file | San Jose, California |
| 15:33.40 | file | mine are just dedicated servers, dunno if they do colo |
| 15:33.48 | file | http://meganetserve.com/ |
| 15:33.49 | jsmith | Oh, that price is for a *dedicated* box? |
| 15:33.52 | file | yes |
| 15:33.59 | jsmith | That beats what I'm paying |
| 15:34.03 | jsmith | Decent server specs? |
| 15:34.19 | file | these are from 2 years ago |
| 15:34.40 | file | 2.4GHz Celeron-Ds with 512MB and 1GB of RAM |
| 15:35.28 | file | I've been happy with them. |
| 16:03.50 | leifmadsen | damn... maybe I should just do the same :) |
| 16:05.41 | leifmadsen | file: I think you're getting a better deal than what they are charging now :) |
| 16:05.56 | file | shrugs |
| 16:06.11 | leifmadsen | still not a bad deal there though |
| 16:13.50 | Juggie | i share an account w/ a friend |
| 16:13.59 | Juggie | its like 5$/mo for unlimited everything and shell access |
| 16:28.40 | leifmadsen | oh yay.... the Tamil Tigers are out marching on the street |
| 17:11.41 | Juggie | some group was protesting in front of the us embassay this morning too |
| 17:11.44 | Juggie | blowing horns etc |
| 17:32.33 | seanbright | last time i was in toronto some hippies were blocking traffic for some kind of "don't drive" day |
| 17:32.45 | seanbright | we nearly ran over this chick on a bike |
| 17:32.47 | seanbright | it was awesome |
| 17:35.58 | seanbright | my apologies to any hippies in the room |
| 17:46.30 | Juggie | hah |
| 18:01.44 | *** join/#asterisk-doc RobH (n=RobH@cpe-72-184-206-177.tampabay.res.rr.com) |
| 18:09.23 | leifmadsen | Juggie: that's the Tamil protestors |
| 18:09.30 | leifmadsen | they have pretty much shut down part of Toronto |
| 18:22.18 | *** join/#asterisk-doc ctooley_ (n=ctooley@c-76-22-158-92.hsd1.tn.comcast.net) |
| 18:33.46 | *** join/#asterisk-doc oej (n=olle@ns.webway.se) |
| 18:47.40 | *** join/#asterisk-doc Khratos (n=khratos@190.166.103.111) |
| 20:02.29 | *** part/#asterisk-doc Juggie (n=Juggie@CPE001601df17fb-CM001ceac25ada.cpe.net.cable.rogers.com) |
| 20:02.43 | *** join/#asterisk-doc Juggie (n=Juggie@CPE001601df17fb-CM001ceac25ada.cpe.net.cable.rogers.com) |
| 21:45.32 | *** join/#asterisk-doc leifmadsen (n=Leif@CPE001d7e2f9574-CM0018c0b39444.cpe.net.cable.rogers.com) |
| 21:45.36 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 21:47.59 | *** join/#asterisk-doc leifmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 21:47.59 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 22:57.03 | *** join/#asterisk-doc leifmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 22:57.03 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |