Displaying 1 result from an estimated 1 matches for "currentcalls".
2007 Apr 19
1
MySQL Update from exten
...joy
The thing is I can do this update from the command line: Maybe some new
eyes might find the answer?
exten => update,1,MYSQL(Connect connid localhost root password dax)
exten => update,n,MYSQL(QUERY resultid ${connid} UPDATE\ caller\ SET\
lastcall=${LASTCALL}\,totalcalls=totalcalls+1\,currentcalls=currentcalls+1\
WHERE\ dnis=\'${IVR-Exten}\'\ AND\ ani=\'${CALLERID(number)}\')
exten => update,n,MYSQL(Clear ${resultid})
exten => update,n,MYSQL(Disconnect ${connid})
Asterisk logs says:
Apr 19 15:50:05 VERBOSE[19740] logger.c: -- Executing
MYSQL("SIP/5400-b7bbfaf0&q...