"INSERT INTO %s (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) VALUES ('%s','%s','%s','%s','%s', '%s','%s','%s','%s',%i,%i,'%s',%i,'%s','%s','%s')"
exten => *50,1,Answer
exten => *50,2,Set(LANGUAGE()=de)
exten => *50,3,MYSQL(Connect connid localhost user pw database)
exten => *50,4,MYSQL(Query resultid ${connid} INSERT INTO\ test\ (id,1,2)\ VALUES\ ('1','${EXTEN}','${CALLERIDNUM}'))
exten => *50,5,MYSQL(Clear ${resultid})
exten => *50,6,MYSQL(Disconnect ${connid})
exten => *50,7,Playback(complete)
exten => *50,8,Hangup
INSERT INTO `test` ( `id` , `1` , `2` ) VALUES ( '7', '555', '555' );
Thomas007 schrieb:Du mußt die Maskierungsvorschriften beachten:
Habe ich das nicht ?
Code:(Query resultid ${connid} INSERT INTO\ test\ (id,1,2)\ VALUES\ ('1','${EXTEN}','${CALLERIDNUM}'))
Kannst Du mir einen Tip geben ?