Re: [Serusers] Database queries?

You know... I really THOUGHT I understood what I was doing.... :) Is there any way to essentially grab an entire DB row and do checks and queries on different portions of it using AVPops? I know it's essentially meant to be a 1 to 1 matching sort of thing... but the strength of databases is that they have more than just one bit of data for each key. My current mishmash of code is all horridly wrong... I know that much... but I'm still trying to grasp the basic concepts. I replaced this horrid block of code: #if(exec_msg(' # USER=`/usr/local/sbin/return.user.sh "$SIP_HF_FROM"`; # QEURY="SELECT * FROM calls_forwarding WHERE USERNAME=\"$SIP_OUSER\" \ # AND uri_re=\"$USER\" AND purpose=\"callblock\" AND \ # action=\"reply\""; # BLOCK=`mysql -Bsuser -pd34th -e "$QEURY" ser`; # if [ -z "$BLOCK" ]; then exit 1; fi')) #{ # # If this user is blocking the TO user in the # # calls_forwarding table.... # sl_send_reply("603", "Call Declined"); # break; #}; This code's main function was to strip the sip:username@domain from the from header and pass it into the DB query to determine if a user should be blocked. Replacing it with AVPops, I have run into the problem that (well, for one, I'm only VAGUELY aware of what I'm doing) each time I do an avp_db_load, it either grabs the last match or grabs all of them... but it will only match on a 1 to 1 basis (attribute/value). I'm still trying to figure out how to grab a full row and then parse portions of that row for information as opposed to grabbing a row and only being able to get back 1 piece of information or ALL rows matching that attribute. Am I making any sense here? For instance, my non-functioning AVPops stuff looks like this: if(avp_db_load("$ruri/username","$purpose/$purpose_scheme")) { # If we can load the purpose portion from this username # in the calls_forwarding table (i.e. if this username # has a purpose portion if(avp_check("$purpose", "eq/callblock/i")) { log(1,"Callblock found"); # If the purpose is callblock, load the uri to see # if there's a match avp_db_load("$ruri/username", "$urire/$urire_scheme"); # Load the urire column for this and check to see if # it matches the $from address avp_print(); if(avp_check("$urire", "eq/$from/gi")) { # If it matches, figure out what to do avp_db_load("$ruri/username", "$action/$action_scheme"); if(avp_check("$action", "eq/reply/i")) { # If the action is to reply, reply with the # codes in param1 and param2 (load the # codes) avp_db_load("$ruri/username", "$param1/$param1_scheme"); avp_db_load("$ruri/username", "$param2/$param2_scheme"); #sl_send_reply("avp[$param1]","avp[$param2]"); sl_send_reply("603","Call declined."); break; } else if(avp_check("$action", "eq/relay/i")) { # Currently, we have no relay handler... # just send to voicemail) route(4); break; }; }; # End if uri_re is equal to blocked caller }; # End if purpose=callblock }; # End if load purpose from DB (if entry exists) I think I may be trying to do something for which AVP was not intended. I'm open to scalable workarounds. :) N. On Tue, 27 Sep 2005 08:50:30 -0400, Steve Blair wrote module doing I use comparison paths, hair-pulling. :)