13 Aug
2007
13 Aug
'07
12:54 p.m.
Hello,
you can access the avps via index. Also, what you want can be achieved
via some recursive route calling. It is a bit complex, here is the
pseudo-algorithm:
- call the route where in first place check if $avp(s:priority) is null,
if yes, rename back all the avps (see next) and return false
- if not, do the checking you want and rename the current set of avps to
something else and run again the route if you need it
basically by renaming the avp you can iterate via calling routes
recursively until no more avps with initial name are in place. hope you
understand me, I will have in mind to add ability to provide the index
to an avp via another PV.
Cheers,
Daniel
On 08/13/07 13:19, Iñaki Baz Castillo wrote:
Hi, in order to implement a ACL system for incoming
calls I've
created a table "acl" with those columns:
- priority
- from_username
- from_domain
- to_username
- group_from
- group_to
- type | action
In that tables I store rules, and my idea is to work as a firewall:
the first match is ejecuted (action=ALLOW or action=REJECT) and exit.
But I can't do it since I don't know how to use all the AVP's JUST
for the first row, then for the second:
avp_db_query("SELECT
priority,from_username,from_domain,to_username,group_from,group_to,type,action FROM
acl",
"$avp(s:priority);$avp(s:from_username);$avp(s:from_domain);$avp(s:to_username);$avp(s:group_from);$avp(s:group_to);$avp(s:type);$avp(s:action)");
This query results in many rows, but I can't analize each row, I just
can compare each AVP with a value, but for that AVP they are possible
all the values of any row.
Because this I'm thinking in using the "exec" module to call a system
script. Is not possible to access to tjhe query result by rows?
Thanks for any help.