<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Hi Satish,<br>
<br>
Whether you use integers or string there, performance should be
similar. However, integers are limited to 4294967295 before
overflowing - hence why it's not working for you.<br>
<br>
So, proper way of usage:<br>
</tt><tt>$avp(user) = "10000001";<br>
<br>
Best regards,<br>
</tt>
<pre class="moz-signature" cols="72">Liviu Chircu
OpenSIPS Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
<div class="moz-cite-prefix">On 30.04.2015 23:34, Satish Patel
wrote:<br>
</div>
<blockquote
cite="mid:CAPgF-frEUGUSOF4vOzurPjTgQzAfyh4eTq5CyDX6WFBkjOWTTg@mail.gmail.com"
type="cite">
<div dir="ltr"><br>
<div>
<div>mysql> select * from userblacklist;</div>
<div>+----+--------------+--------+--------+-----------+</div>
<div>| id | username | domain | prefix | whitelist |</div>
<div>+----+--------------+--------+--------+-----------+</div>
<div>| 1 | 10000001 | | | 0 |</div>
<div>| 2 | <a moz-do-not-send="true" href="tel:9198362323"
value="+19198362323" target="_blank">9198362323</a> |
| | 0 |</div>
<div>+----+--------------+--------+--------+-----------+</div>
</div>
<div><br>
</div>
<div>If i set $avp(user) = 10000001; then it works! </div>
<div><br>
</div>
<div>but if i set $avp(user) = 9198362323; doesn't work what
is the problem ? </div>
<div><br>
</div>
<div><br>
</div>
<div>
<div>route[user_blacklist] {</div>
<div><br>
</div>
<div> $avp(user) = 9198362323; </div>
<div> </div>
<div> if (!check_user_blacklist("$avp(user)", <span
style="color:rgb(0,0,0);background-color:rgb(254,254,238)">"$avp(i:82)"))
{</span></div>
<div> sl_send_reply("403", "User Blocked");</div>
<div> exit;</div>
<div> };</div>
<div>}</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</body>
</html>