I'm attempting to figure out how to use AVPops to grab data from the
calls_forwarding database table so I can avoid having to write my own module
to handle that sort of thing, and I can avoid doing what I'm CURRENTLY doing
which is using a pretty hideous exec_msg SQL query hack.
I've run into a snag that I can't figure a way around....
In the calls_forwarding table, I have these fields used in this fashion:
username == username
domain == domain
uri_re == username@domain information (for use in a couple of ways)
purpose == purpose for this entry (callblock, callfwd, screening, etc)
action == action to take (for callblock, could be reply or relay, etc)
param1 == option for the action above
param2 == additional option
So... if I have a call block entry, it would be like this:
username = bob
domain =
mydomain.com
uri_re = motherinlaw(a)another.domain.com
purpose = callblock
action = reply
param1 = 486
param2 = "Busy"
The logic would be along the lines of, when a call comes in for
bob(a)mydomain.com, I check to see if he has any callblock entries. If so, I
check those to see if any match the From user. If there's a match, take the
action in action (in this case reply with 486 - Busy... could be relay to
voicemail, etc).
The problem I'm having is in the grabbing of all the data from the DB and
comparing it to the right values. For instance, with this avpops query
avp_db_load("$ruri/username", "$urire/$urire_scheme");
# Load the urire column for this and check to see if
# it matches the $from address
if(avp_check("$urire", "eq/$from/I"))
{
send reply... take action... etc.
}
I'm calling from the number motherinlaw(a)another.domain.com. If I use the
above, the avp_check test fails. If I put
if(avp_check("$urire", "eq/motherinlaw(a)another.domain.com/I"))
{
send reply... take action... etc.
}
Then the test succeeds and the appropriate action is taken.
Any guesses as to what I'm missing here... why the test is failing when I use
the $from variable for AVPops, but not when I hard-code the $from address into
the test (which implies to me that it's grabbing the right data from the
database, but there's an issue in either the $from variable or the comparison
statement)?
I'd love a little shove in the right direction. I thought about writing a
module that returned what I need without the need for complex logical paths,
but my C is pretty rusty, and I'm trying to save myself the hair-pulling. :)
N.