Thanks Zeeshan, but i don't use (and understand) AEL :) Any regular examples out there? :)
regards, Remco On 06/29/2010 05:27 PM, Zeeshan Zakaria wrote: > Let me make it simple for you: > > Add a column to your table, e.g. `my column`. > > In the dialplan do the following (AEL example): > > MYSQL(Connect connid localhost username password database); > MYSQL(Query resultid ${connid} INSERT INTO `cdr` > (`mycolumn`) VALUES('${SIPCHANINFO(ip)}')); > MYSQL(Disconnect ${connid}); > > -- > Zeeshan > > On Tue, Jun 29, 2010 at 10:32 AM, Gareth Blades > <list-aster...@skycomuk.com <mailto:list-aster...@skycomuk.com>> wrote: > > Remco Bressers wrote: > > Hi, > > > > Sorry, but i forgot to notice that i am already using the 'userfield' > > column so that's not a possibility. Is there any way i can add the IP > > address to a custom MySQL field in CDR? With AGI possibly? The problem > > is, that the CDR entry is written in MySQL when the call is > hungup, so i > > have no possibility to write the IP address after a call. > > > > Regards, > > > > Remco > > > > See my earlier post. You can certenly write the information after the > call is hung up by using the 'h' extension. I do this myself to write > the calculated call cost to a custom column in the mysql table. > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > New to Asterisk? Join us for a live introductory webinar every Thurs: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > > > > -- > Zeeshan A Zakaria > -- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users