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