<div dir="ltr">It wasn&#39;t working because i was using <div><br></div><div>$fn = $avp(user)</div><div><br></div><div>My string was double quote like &quot;10000001&quot;  because of that it won&#39;t comparing true result with blacklist table and result was &quot;false&quot;  when i strip out &quot;&quot; from $fn then it works!   </div><div><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, May 4, 2015 at 5:34 AM, Liviu Chircu <span dir="ltr">&lt;<a href="mailto:liviu@opensips.org" target="_blank">liviu@opensips.org</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div 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&#39;s not working for you.<br>
      <br>
      So, proper way of usage:<br>
    </tt><tt>$avp(user) = &quot;10000001&quot;;<br>
      <br>
      Best regards,<br>
    </tt>
    <pre cols="72">Liviu Chircu
OpenSIPS Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre><div><div class="h5">
    <div>On 30.04.2015 23:34, Satish Patel
      wrote:<br>
    </div>
    </div></div><blockquote type="cite"><div><div class="h5">
      <div dir="ltr"><br>
        <div>
          <div>mysql&gt; select * from userblacklist;</div>
          <div>+----+--------------+--------+--------+-----------+</div>
          <div>| id | username     | domain | prefix | whitelist |</div>
          <div>+----+--------------+--------+--------+-----------+</div>
          <div>|  1 | 10000001   |        |        |         0 |</div>
          <div>|  2 | <a 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) = <a href="tel:9198362323" value="+19198362323" target="_blank">9198362323</a>;   doesn&#39;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) = <a href="tel:9198362323" value="+19198362323" target="_blank">9198362323</a>;  </div>
          <div>  </div>
          <div>        if (!check_user_blacklist(&quot;$avp(user)&quot;, <span style="color:rgb(0,0,0);background-color:rgb(254,254,238)">&quot;$avp(i:82)&quot;))
              {</span></div>
          <div>                sl_send_reply(&quot;403&quot;, &quot;User Blocked&quot;);</div>
          <div>                exit;</div>
          <div>        };</div>
          <div>}</div>
        </div>
        <div><br>
        </div>
        <div><br>
        </div>
        <div><br>
        </div>
      </div>
      <br>
      <fieldset></fieldset>
      <br>
      </div></div><pre>_______________________________________________
Users mailing list
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </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>