asterisk users - Jul 2010 - URgent - capturing 'answered'

Hello everyone.

I need a quick help on how to capture who answered the call with agi.

 

Here is an example:

 

    -- Zap/32-1 is ringing

    -- Zap/33-1 is ringing

    -- Zap/34-1 is ringing

    -- Zap/35-1 is ringing

    -- SIP/operator1-e77f answered Zap/23-1  

 

So how can I capture this value and write it to mysql?

 

I already have this:

 

                                                $my.query("UPDATE call_log
SET endtime = NOW() WHERE id = #{call_log_id}")

 

   And i needed to do something like:

 

 

                                                $my.query("UPDATE call_log
SET endtime = NOW(),answeredby= #{$agi.WHOANSWEREDTHEPHONE} WHERE id
#{call_log_id}")

 

And in above example it would write SIP/operator1-e77f into answeredby.

 

Any help is greatly appreciated!

 

 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100726/bebe3829/attachment.htm

You need to do it by manager interface

Regards,

Faisal Hanif

On 7/26/2010 3:41 PM, Zarko Zivanovic wrote:
>
> Hello everyone.
>
> I need a quick help on how to capture who answered the call with agi.
>
> Here is an example:
>
>     -- Zap/32-1 is ringing
>
>     -- Zap/33-1 is ringing
>
>     -- Zap/34-1 is ringing
>
>     -- Zap/35-1 is ringing
>
>     -- SIP/operator1-e77f answered Zap/23-1
>
> So how can I capture this value and write it to mysql?
>
> I already have this:
>
>                                                 $my.query("UPDATE 
> call_log SET endtime = NOW() WHERE id = #{call_log_id}")
>
>    And i needed to do something like:
>
>                                                 $my.query("UPDATE 
> call_log SET endtime = NOW(),answeredby= #{$agi.WHOANSWEREDTHEPHONE} 
> WHERE id = #{call_log_id}")
>
> And in above example it would write SIP/operator1-e77f into answeredby.
>
> Any help is greatly appreciated!
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus 
> signature database 5313 (20100726) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20100726/6b2ef386/attachment.htm