You can use the MYSQL function to just use an insert or update statement in your dialplan. Look at my example below. Instead of using <br><br>exten => s,2,MYSQL(Query resultid ${connid} SELECT\ callerid\ from\ blacklist\ where\ callerid=${ARG1} and blockenabled = 1)<br>
<br>You could use:<br><br>exten => s,2,MYSQL(Query resultid ${connid} INSERT INTO\ callerid\ (callerid,blockenabled)\ VALUES\ ('${CALLERID(num)}', '1')\ )<br><br>I find that using the ODBC function works best for inserting data into the MySQL databases.<br>
<br>Have a look at <a href="http://www.voip-info.org/wiki/index.php?page=Asterisk+func+func_odbc">http://www.voip-info.org/wiki/index.php?page=Asterisk+func+func_odbc</a>.<br><br><br><blockquote><p>[globals]<br>
realdb_host=hostnameformysqldb<br>
realdb_user=mysqldbuser<br>
realdb_pass=mysqldbpassword<br>
realdb_db=mysqldbthatcontainsthevoicemailusers</p>
<p>[macro-checkblacklist]<br>
; This Macro will check the blacklist table to see if the callerid of the<br>
; caller exist and blockenabled =1 (TRUE). If the callerid is listed, then<br>
; tell the caller they have been blacklisted and politely HangUp()<br>
;<br>
; ${ARG1} = CallerID of incoming call<br>
;<br>
exten => s,1,MYSQL(Connect connid ${realdb_host} ${realdb_user} ${realdb_pass} ${realdb_db})<br>
exten => s,2,MYSQL(Query resultid ${connid} SELECT\ callerid\ from\ blacklist\ where\ callerid=${ARG1} and blockenabled = 1)<br>
exten => s,3,MYSQL(Fetch fetchid ${resultid} blacklistid)<br>
exten => s,4,MYSQL(Clear ${resultid})<br>
exten => s,5,MYSQL(Disconnect ${connid})<br>
exten => s,6,GoToIf($[”${blacklistid}” = “”]?7:fail,1)<br>
exten => s,7,NoOp(${blacklistid})<br>
; If the callerid is listed in the database, then send to blacklistednumber<br>
; context<br>
;<br>
exten => fail,1,NoOp(${blacklistid})<br>
exten => fail,2,GoTo(blacklistednumber,s,1)</p>
<p>[blacklistednumber]<br>
; This is where a call will land if the macro-checkblacklist decides that<br>
; the number should not be allowed to dial the company.<br>
exten => s,1,Wait(2)<br>
exten => s,2,Playback(privacy-you-are-blacklisted)<br>
exten => s,3,Zapateller()<br>
exten => s,4,HangUp()</p></blockquote><br><br><div class="gmail_quote">On Wed, Feb 25, 2009 at 3:40 PM, Elliot Murdock <span dir="ltr"><<a href="mailto:murdocke@gmail.com">murdocke@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello Everyone!<br>
<br>
According to <a href="http://voip-info.org" target="_blank">voip-info.org</a> the correcy syntax for the realtime function is:<br>
<br>
REALTIME(family|fieldmatch[|value[|delim1[|delim2]]]) on read<br>
REALTIME(family|fieldmatch|value|field) on write<br>
<br>
It seems from the syntax that it is only possible to retrieve a full<br>
row according to the value of only of column. This translates in SQL<br>
language as Select * from family where fieldmath = value.<br>
<br>
Is there any way to have more control over the realtime function?<br>
<br>
Also, regarding the MYSQL function, I only saw documentation to query<br>
a database. Is there any way to update a database using that<br>
function?<br>
<br>
Thanks!<br>
Elliot<br>
<br>
_______________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>***<br>Forrest Beck<br>IAXTEL: 17002871718<br><a href="mailto:jonforrest.beck@gmail.com">jonforrest.beck@gmail.com</a><br><a href="http://www.shift8.biz">http://www.shift8.biz</a><br>