[OpenSER-Users] Not possible variables or AVP's in alias_db_lookup() ?

[Daniel-Constantin Mierla]

On 08/02/07 19:34, Iñaki Baz Castillo wrote:
> El Thursday 02 August 2007 18:15:58 Iñaki Baz Castillo escribió:
>   
>> El Thursday 02 August 2007 18:07:32 Daniel-Constantin Mierla escribió:
>>     
>>> Hello,
>>>
>>> if the alias translates in a single SIP user, it is easy to do it with
>>> avp_db_query() of avpops module. You load the result in avps and then
>>> push it to R-URI.
>>>       
>> Ok, I'll try that.
>>     
>
> Thanks, it works perfectly and I tell how it's finally:
>   
great, next is a beautification for 1.2.x:
>
> $avp(s:dominio) = $rd;
> avp_subst("$avp(s:dominio)", "/\./_/g");
> avp_db_query("select username,domain from dbaliases_$avp(s:dominio) where 
> alias_username='$rU' AND alias_domain='$rd'", "$avp(s:alias_username);
> $avp(s:alias_domain)");
>   

$ru = "sip:"+$avp(s:alias_username)+"@"+$avp(s:alias_domain);

and remove next two.

Daniel

> avp_pushto("$ru/username","$avp(s:alias_username)");
> avp_pushto("$ru/domain","$avp(s:alias_domain)");
>
>
> :)
>
>
>
>