История изменений [назад]

правильно смотрите func_odbc.conf

правильно смотрите func_odbc.conf

; ODBC_PRESENCE - Retrieve and update presence
[PRESENCE]
dsn=mysql1
read=SELECT location FROM presence WHERE id='${SQL_ESC(${ARG1})}'
write=UPDATE presence SET location='${SQL_ESC(${VAL1})}' WHERE id='${SQL_ESC(${ARG1})}'
;prefix=OFFICE          ; Changes this function from ODBC_PRESENCE to OFFICE_PRESENCE
;escapecommas=no        ; Normally, commas within a field are escaped such that each
                        ; field may be separated into individual variables with ARRAY.
                        ; This option turns that behavior off [default=yes].

exten=> s,1,Set(presence=${ODBC_PRESENCE(11111)}

правильно смотрите func_odbc.conf

там есть примеры вобщемто.

; ODBC_PRESENCE - Retrieve and update presence
[PRESENCE]
dsn=mysql1
read=SELECT location FROM presence WHERE id='${SQL_ESC(${ARG1})}'
write=UPDATE presence SET location='${SQL_ESC(${VAL1})}' WHERE id='${SQL_ESC(${ARG1})}'
;prefix=OFFICE          ; Changes this function from ODBC_PRESENCE to OFFICE_PRESENCE
;escapecommas=no        ; Normally, commas within a field are escaped such that each
                        ; field may be separated into individual variables with ARRAY.
                        ; This option turns that behavior off [default=yes].

вот для примера с PRESENCE вызов будет вот так

exten=> s,1,Set(presence=${ODBC_PRESENCE(11111)}
s,1,Set(presence=${ODBC_PRESENCE(11111)})