[OpenSIPS-Users] MySQL Insert Statement

[Schneur Rosenberg]

Look at the avp_db_query function.

On Mon, Apr 30, 2018, 2:27 AM Alexander Perkins <
alexanderhenryperkins at gmail.com> wrote:

> Hi.  I've been trying to figure out how to insert a statement into MySQL
> from the opensips.cfg file and I am having a hard time.  Basically, I am
> checking the userblacklist and would like to insert into a MySQL table when
> that number is attempted.  Is that possible?  I've already successfully
> loaded the db_mysql module.  Here's the line I am referring to:
>
>         if (check_blacklist("BlackList"))
>                 sl_send_reply("403", "Forbidden");
>                 #I would like to have something here like INSERT INTO
> Attempts(User) Value($rU)
>         exit;
>
> Any help is appreciated,
> Alex
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20180430/4ae361e4/attachment.html>