login | register
Tue 02 of Dec, 2008 [12:35 UTC]

voip-info.org

Discuss [0] History

Asterisk cmd RealTimeUpdate

Created by: kjcsb,Last modification on Fri 12 of Oct, 2007 [11:35 UTC] by chandave
Synopsis
Realtime Data Rewrite

Description
Use the RealTime config handler system to update a value
RealTimeUpdate(<family>|<colmatch>|<value>|<newcol>|<newval>)

The column <newcol> in 'family' matching column <colmatch>=<value> will be updated to <newval>

For example assume the following:
extconfig.conf
sipusers => mysql,asterisk,asterisk_sip

extensions.conf
exten => 11223344,n,RealTimeUpdate(sipusers|name|44332211|username|bob)

This will execute the following SQL on the asterisk_sip table in the asterisk database:
UPDATE asterisk_sip SET username = 'bob' WHERE name = '44332211'


Asterisk | Applications | Functions | Variables | Expressions | Asterisk FAQ


Comments