search for: realdb_us

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 =

...xten => s,2,Set(MEETME_RECORDINGFILE=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...

...ssed to this macro as ${ARG1}. ; ; 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,...