9 Jun
2008
9 Jun
'08
12:20 p.m.
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.
--
Iñaki Baz Castillo
ibc(a)in.ilimit.es