Hi,<div><br></div><div>What im trying to do is:</div><div><br></div><div>For exemple, if somebody is trying to call Bob and its status is 'busy', then send the call to another entity. For that, it is necessary to enter to the Presentity table and read the file that is in the 'body' field to find the status of the user.</div>
<div><br></div><div>Thanks, i hope i made myself clear :) i really dont know what to do. My boss adviced me to create a new module but i think that would be very hard to do.</div><div><br></div><div>Pierina M.</div><div><br>
<br><div class="gmail_quote">2012/8/24 Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@googlemail.com" target="_blank">shaheryarkh@googlemail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Use AVPOPS module, you can connect to any database and runny any SQL on it from within opensips.cfg,<div><br></div><div><a href="http://www.opensips.org/html/docs/modules/1.8.x/avpops.html#id292750" target="_blank">http://www.opensips.org/html/docs/modules/1.8.x/avpops.html#id292750</a><br>
<div><br></div><div>However, using this method is mostly recommended for databases other then opensips own native database. If you can give some details about what you are trying to do then may be we can advise some OpenSIPs module or function to do the job without manually querying the native database.</div>
<div><br></div><div>Thank you.</div><div><br><br><div class="gmail_quote"><div><div class="h5">On Fri, Aug 24, 2012 at 1:54 PM, Pieri Mavarez <span dir="ltr"><<a href="mailto:pasaportefacil@gmail.com" target="_blank">pasaportefacil@gmail.com</a>></span> wrote:<br>
</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">Hi, im trying to read the content from the table Presentity, more specifically, i want to read the file from 'body' field and use this information. <div>
<br></div><div>How can i enter the database from the opensips.cfg file to use this info?</div>
<div><br></div><div>Thanks</div><div><br></div><div>Pierina M</div>
<br></div></div>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br>Muhammad Shahzad<br>-----------------------------------<br>CISCO Rich Media Communication Specialist (CRMCS)<br>
CISCO Certified Network Associate (CCNA)<br>
Cell: <a href="tel:%2B92%20334%20422%2040%2088" value="+923344224088" target="_blank">+92 334 422 40 88</a><br>MSN: <a href="mailto:shari_786pk@hotmail.com" target="_blank">shari_786pk@hotmail.com</a><br>Email: <a href="mailto:shaheryarkh@googlemail.com" target="_blank">shaheryarkh@googlemail.com</a><br>
</font></span></div></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>