<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.hoenzb
{mso-style-name:hoenzb;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi Engineer,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Can you please explain a little bit more what should the result look like, seems like it’s already a timestamp “</span>2012-10-19 09:00:00<span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>”! <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Do you mean to extract only the “09:00:00” part ! <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Regards,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Gohar<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> users-bounces@lists.opensips.org [mailto:users-bounces@lists.opensips.org] <b>On Behalf Of </b>Engineer Voip<br><b>Sent:</b> Friday, October 19, 2012 11:45 AM<br><b>To:</b> users@lists.opensips.org<br><b>Subject:</b> Re: [OpenSIPS-Users] Transfering a call by opensips<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>Hi,<o:p></o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'>Can we convert this time 2012-10-19 09:00:00 to timestamp in opensips.cfg without using an external script?<o:p></o:p></p><div><p class=MsoNormal>Cordialement. <o:p></o:p></p></div><p class=MsoNormal>Envoyé de mon iPhone<o:p></o:p></p></div><div><p class=MsoNormal style='margin-bottom:12.0pt'><br>Le 18 oct. 2012 à 17:51, Engineer voip <<a href="mailto:forvoip4@gmail.com">forvoip4@gmail.com</a>> a écrit :<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-family:"Comic Sans MS"'>Hi,<br>I have resolved my probleme, now i stocked this time 2012-10-18 17:50:00 in usr_preferences table <br>and i want to convert it to seconds<br>wa can convert the current time to secondes by using $Ts but i don't know if is possible to convert a precise that like 2012-10-18 17:50:00<br><br>someone know how do it?</span><o:p></o:p></p><div><p class=MsoNormal>2012/10/18 Engineer voip <<a href="mailto:forvoip4@gmail.com" target="_blank">forvoip4@gmail.com</a>><o:p></o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'>Hi,<br>I trying to do that with avpops module and usr_preferenses table.<br>my script is:<br><br>if ( avp_db_load("$ru/username","a") ) <br> {<br> xlog("L_INFO", " ------------- OFF LINE FORWARD phone number: $avp(s:callfwd)\n");<br> xlog("L_INFO", " ------------- OFF LINE FORWARD from time: $avp(s:from_time)\n");<br> xlog("L_INFO", " ------------- OFF LINE FORWARD TO time: $avp(s:to_time)\n");<br> xlog("L_INFO", "method <$rm> Transforwarding Call from <$fu> r-uri <$ru>\n");<br> <br> <br> if( avp_check("$avp(s:from_time)", "ge/s:10") ) <br> {<br> $ru = $avp(callfwd);<br> route(13);<br> }<br><br><br><br><o:p></o:p></p><div><p class=MsoNormal><b>but the result is: <br> </b><br> <b> ------------- OFF LINE FORWARD phone number: 12<br> ------------- OFF LINE FORWARD from time: 14<br> ------------- OFF LINE FORWARD TO time: <nul></b><br><br><b>Why i get 12 instead of callfwd value ??</b><o:p></o:p></p><div><div><p class=MsoNormal><br><br>2012/10/18 Engineer voip <<a href="mailto:forvoip4@gmail.com" target="_blank">forvoip4@gmail.com</a>><o:p></o:p></p><p class=MsoNormal>Hi Muhammad,<br><br>I think dynamic routing is used only to routing outgoing calls but me i want to routing an incomming calls to user C between 11h and 14h when the user A called him.<br><b> (user A is an external user and B is an User registred on My opensips)</b><o:p></o:p></p><div><div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>2012/10/18 Muhammad Shahzad <<a href="mailto:shaheryarkh@googlemail.com" target="_blank">shaheryarkh@googlemail.com</a>><o:p></o:p></p><p>Binan, avp db is usually used for temporary data storage e.g. To share some value between two call session etc. So while avp db can be used for this but then you need to make sure you never call avp db clear in your script.<o:p></o:p></p><p>Secondly you can use drouting to route any call, not just calls to gw. You need to create rule that call should not be routed to user B during 11h to 14h. So drouting lookup will fail. Then you check in alias db which will tell you user c is alias to user b and you can then route call to user c. This way you can create N x N drouting to alias rules.<o:p></o:p></p><p>Thank you.<o:p></o:p></p><div><div><p>On Oct 18, 2012 10:34 AM, "Binan AL Halabi" <<a href="mailto:binanalhalabi@yahoo.com" target="_blank">binanalhalabi@yahoo.com</a>> wrote:<br>><o:p></o:p></p><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><div><p class=MsoNormal><span style='font-size:10.0pt'>Hi,<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt'>Add them as Attribute and Value(opensipsctl avp add ....... ): Add them as two separate AVP. <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt'>Then load them in your script as AVP (avp_db_load function).<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt'>// Binan<o:p></o:p></span></p></div><div><p class=MsoNormal><span style='font-size:10.0pt'><o:p> </o:p></span></p></div><div><div><div><div class=MsoNormal align=center style='text-align:center'><span style='font-family:"Arial","sans-serif"'><hr size=1 width="100%" align=center></span></div><p class=MsoNormal><b><span style='font-family:"Arial","sans-serif"'>Från:</span></b><span style='font-family:"Arial","sans-serif"'> Engineer voip <<a href="mailto:forvoip4@gmail.com" target="_blank">forvoip4@gmail.com</a>><br><b>Till:</b> Binan AL Halabi <<a href="mailto:binanalhalabi@yahoo.com" target="_blank">binanalhalabi@yahoo.com</a>>; OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org" target="_blank">users@lists.opensips.org</a>> <br><b>Skickat:</b> torsdag, 18 oktober 2012 10:21<br><b>Ämne:</b> Re: [OpenSIPS-Users] Transfering a call by opensips</span><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal style='margin-bottom:12.0pt'>Hi,<br><br><span lang=EN>I don't have the fields in user_preferences table or i add them ?</span><o:p></o:p></p><div><p class=MsoNormal>2012/10/18 Binan AL Halabi <<a href="mailto:binanalhalabi@yahoo.com" target="_blank">binanalhalabi@yahoo.com</a>><o:p></o:p></p><div><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:10.0pt'>Hi,<br><br>Store in usr_preferences table the time_from and time_to<br>then read them in your script using avpops module <br>Take the hour of the call and compare it to the range you got it from database.<br><br><a href="http://www.opensips.org/html/docs/modules/1.7.x/avpops.html" target="_blank">http://www.opensips.org/html/docs/modules/1.7.x/avpops.html</a><br><br>// Binan <o:p></o:p></span></p><div><div><div><div class=MsoNormal align=center style='text-align:center'><span style='font-family:"Arial","sans-serif"'><hr size=1 width="100%" align=center></span></div><p class=MsoNormal><b><span style='font-family:"Arial","sans-serif"'>Från:</span></b><span style='font-family:"Arial","sans-serif"'> Engineer Voip <<a href="mailto:forvoip4@gmail.com" target="_blank">forvoip4@gmail.com</a>><br><b>Till:</b> <a href="mailto:users@lists.opensips.org" target="_blank">users@lists.opensips.org</a> <br><b>Skickat:</b> torsdag, 18 oktober 2012 8:53<br><b>Ämne:</b> [OpenSIPS-Users] Transfering a call by opensips</span><o:p></o:p></p></div><div><div><p class=MsoNormal><br>Hello all, <br>I want to transfert the call to user C when user A calls user B in interval of time for example: 11h-14h<br>I can do that by asterisk but i prefer to do it by opensips<br>It's possible to do that by opensips?<br><br>Cordialement. <br>Envoyé de mon iPhone<o:p></o:p></p></div></div><div><p class=MsoNormal style='margin-bottom:12.0pt'>_______________________________________________<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><o:p></o:p></p></div></div></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><br>_______________________________________________<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><o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><br><br clear=all><br>-- <br><span style='font-family:"Comic Sans MS";color:#663300'><br>Best Regards.<br><br></span><o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p></div></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><br>_______________________________________________<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><o:p></o:p></p></blockquote></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><br>_______________________________________________<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><o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><br><br clear=all><br>-- <br><span style='font-family:"Comic Sans MS";color:#663300'><br>Best Regards.<br><br></span><o:p></o:p></p></div></div></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='color:#888888'><br><br clear=all><br><span class=hoenzb>-- </span><br></span><span style='font-family:"Comic Sans MS";color:#663300'><br><span class=hoenzb>Best Regards.</span><br><br></span><o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><br><br clear=all><br>-- <br><span style='font-family:"Comic Sans MS";color:#663300'><br></span><span style='font-family:"Comic Sans MS";color:black'>Best Regards.</span><span style='font-family:"Comic Sans MS";color:#663300'><br><br></span><o:p></o:p></p></div></blockquote></div></body></html>