<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.3700.6699" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I am trying to create an external script using
exec_msg, such that the request uri is written based on the SIP_HF_FROM. I have
appended this below. Is it possible to have a rewriteuri within an exec_msg.
Please give your comments on the script below.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Deen</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><PRE>if (!exec_msg('</PRE><PRE><SPAN style="mso-tab-count: 1"> </SPAN>QUERY="select ouser from subscriber1 </PRE><PRE><SPAN style="mso-tab-count: 2"> </SPAN>where user=\"$SIP_HF_FROM\"";</PRE><PRE><SPAN style="mso-tab-count: 1"> </SPAN>OUSER1=`mysql<SPAN style="mso-spacerun: yes"> </SPAN>-Bsuser -pheslo -e "$QUERY" ser`;</PRE><PRE><SPAN style="mso-tab-count: 1"> </SPAN>Rewriteuri(“sip:$OUSER1@192.168.0.1”)')) {</PRE><PRE><SPAN style="mso-tab-count: 2"> </SPAN>sl_send_reply("404", "User does not exist");</PRE><PRE><SPAN style="mso-tab-count: 1"> </SPAN>} else {</PRE><PRE><SPAN style="mso-tab-count: 2"> </SPAN>sl_send_reply("600", "user exists");</PRE><PRE><SPAN style="mso-tab-count: 1"> </SPAN>};</PRE></FONT></DIV></BODY></HTML>