8 Nov
2005
8 Nov
'05
10:33 a.m.
Daryl,
Try something like this:
avp_db_load("$ruri/domain","i:/usr_preferences");
- loads all AVPs with ID from 'usr_preferences'
table for domain from RURI
Run that ONCE, then do all your AVP checks without using the avp_db_load
statements. This *should* work with SER and OpenSER, but definitely OpenSER.
Lenir
-----Original Message-----
From: serusers-bounces(a)iptel.org [mailto:serusers-bounces@lists.iptel.org] On
Behalf Of sip
Sent: Monday, November 07, 2005 2:57 PM
To: Daryl Sanders; SER Users; users(a)openser.org
Subject: Re: [Serusers] AVP Distinctive-Ring question
SER is severely limited on the passing of variables which ends up making
things like that string of queries necessary to perform some things.
OpenSER I think allows the use of tossing in pseudo variables here and
there,
so you could probably grab the value of the ringtone from the AVP and then
toss it into the Alert-Info header making it into one query instead of 5.
Not being an OpenSER user, however, this is only what I understand from my
cursory reading of its docs. You'd have to check on that with someone else,
I
think.
N.
On Mon, 7 Nov 2005 12:35:55 -0700, Daryl Sanders wrote
I am using AVPs for distinctive ring preferences. I
allows users to
store up to 5 phone numbers that can be assigned a custom ring. The
method below works fine but as you can see it requires 5 db queries.
There must be a better way to do this. Any ideas?
- Daryl
if (avp_db_load("$ruri/username", "s:ringone")) {
if (avp_check("s:ringone", "eq/$from/i")) {
append_hf("Alert-Info: Bellcore-r1\r\n");
};
};
if (avp_db_load("$ruri/username", "s:ringtwo")) {
if (avp_check("s:ringtwo", "eq/$from/i")) {
append_hf("Alert-Info: Bellcore-r2\r\n");
};
};
if (avp_db_load("$ruri/username", "s:ringthree")) {
if (avp_check("s:ringthree", "eq/$from/i")) {
append_hf("Alert-Info: Bellcore-r3\r\n");
};
};
if (avp_db_load("$ruri/username", "s:ringfour")) {
if (avp_check("s:ringfour", "eq/$from/i")) {
append_hf("Alert-Info: Bellcore-r4\r\n");
};
};
if (avp_db_load("$ruri/username", "s:ringfive")) {
if (avp_check("s:ringfive", "eq/$from/i")) {
append_hf("Alert-Info: Bellcore-r5\r\n");
};
};
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers
_______________________________________________
Serusers mailing list
serusers(a)lists.iptel.org
http://lists.iptel.org/mailman/listinfo/serusers