Displaying 3 results from an estimated 3 matches for "realdb_db".
2009 Feb 25
1
Realtime database function help
Hello Everyone!
According to voip-info.org the correcy syntax for the realtime function is:
REALTIME(family|fieldmatch[|value[|delim1[|delim2]]]) on read
REALTIME(family|fieldmatch|value|field) on write
It seems from the syntax that it is only possible to retrieve a full
row according to the value of only of column. This translates in SQL
language as Select * from family where fieldmath =
2008 Jan 17
0
Paging Recording File
...INGFILE=custom/paging/${EPOCH})
exten => s,3,System(/bin/echo "${STRFTIME(${EPOCH},,%Y%m%d-%H%M%S)} $
{MEETME_RECORDINGFORMAT} ${MEETME_RECORDINGFILE}" >> /var/log/asterisk/
pagemacro_var.log)
exten => s,4,MYSQL(Connect connid ${realdb_host} ${realdb_user} $
{realdb_pass} ${realdb_db})
exten => s,5,MYSQL(Query resultid ${connid} SELECT\ name\ FROM\ sip\
WHERE\ name\ LIKE\ "'${ARG1}%'")
exten => s,6,MYSQL(Fetch fetchid ${resultid} number)
exten => s,7,GoToIf($["${fetchid}" = "1"]?8:10)
exten => s,8,Set(pagedevice=${pagedevice}&...
2007 Sep 20
1
Paging MEETME_RECORDINGFILE Variable
...; ARG1 = The first digit of the phones to be paged (6=US
Campus, 4=MS, 2=LS)
; ARG2 = Device for the PA system. If the user selected to
; page the PA system. That will be included.
;
exten => s,1,MYSQL(Connect connid ${realdb_host} ${realdb_user} $
{realdb_pass} ${realdb_db})
exten => s,2,MYSQL(Query resultid ${connid} SELECT\ name\ FROM\ sip\
WHERE\ name\ LIKE\ "'${ARG1}%'")
exten => s,3,MYSQL(Fetch fetchid ${resultid} number)
exten => s,4,GoToIf($["${fetchid}" = "1"]?5:7)
exten => s,5,Set(pagedevice=${pagedevice}&a...