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@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@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@another.domain.com. If I use the above, the avp_check test fails. If I put
if(avp_check("$urire", "eq/motherinlaw@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.