or for any kind of mysql query, you may use the "avp_db_query" function 
from avpops module:
    http://www.opensips.org/html/docs/modules/1.6.x/avpops.html#id271033

Regards,
Bogdan

Brett Nemeroff wrote:
> I personally would probably end up storing the users into memcache and
> checking against that.
>
> the userblacklist module might also do what you need..
> http://www.opensips.org/html/docs/modules/1.6.x/userblacklist.html#id227282
>
>
> On Fri, Apr 2, 2010 at 12:15 AM, CheeWii <quanwe...@gmail.com> wrote:
>   
>> Hi,
>>     I use Opensips as an SMS gateway. Now I need to check all message's
>> username firstly. If the username is in my mysql database,thus it belong to
>> the white name-list,then I realy it normally.If not ,I will drop it
>> directlly.
>>    So I think I should exec some some mysql commands to check the usename.
>> How can I accomplish it?
>>    Thanks a lot:)
>>
>> CheeWii
>>
>> _______________________________________________
>> Users mailing list
>> Users@lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>>     
>
> _______________________________________________
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>   


-- 
Bogdan-Andrei Iancu
www.voice-system.ro


_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to