[Users] Woo hoo! (was: The usrloc table, Oracle, and Asterisk)

[Juan Carlos Castro y Castro]

Bogdan-Andrei Iancu escreveu:
> first of all, instead of using Oracle triggers you can log this info 
> directly from OpenSER using  avp_db_query
>       http://www.openser.org/docs/modules/1.2.x/avpops.html#AEN268
> and pseudo-variables to get the src_ip ($si), src_port ($sp) and 
> expire header. See
>       http://www.openser.org/dokuwiki/doku.php/pseudovariables:devel

avp_db_query("UPDATE sipfriends SET ipaddr='$si', port='$sp', 
regseconds=$Ts+$hdr(expires) WHERE name='$au'");

makes me a happy man! Unified registry for OpenSER and Asterisk. Y-EAH!