Dear Iñaki Thank you for your reply. Can you please provide an example about the Group Module ? Thanks -----Original Message----- From: users-bounces@lists.openser.org [mailto:users-bounces@lists.openser.org] On Behalf Of Iñaki Baz Castillo Sent: Monday, June 09, 2008 12:20 PM To: users@lists.openser.org Subject: Re: [OpenSER-Users] AVPOPS Issue
El Monday 09 June 2008 11:06:09 Ali Jawad escribió:
Hi All
I have added a column called status to the subscriber table. I want to check that column in the route() function and act according to it's value.
In the global settings I put
# ----- AVP params --------
modparam("avpops", "avp_url", "mysql://openser:ccccc@cccccc/openser")
modparam("avpops","avp_table","subscriber")
modparam("avpops","db_scheme", "scheme1:username_col=username;value_col=status;value_type=string;table= subscriber")
You use "username" column (that just stores the USERNAME without @domain)...
And In the route statement I put
if (avp_db_load("$ru","$avp(s:disabled)/$scheme1"))
...but here you look for the entire Request-URI ($ru). Maybe you mean $rU ?
BTW, I think is much better using "group" module for the purpose you want.