I'm able to make generic dialplan but don't know how to make subscriber based dialplan. Here is my generic dialplan sample config file and dialplan table;

----

loadmodule "avpops.so"
loadmodule "dialplan.so"

#------ avpops params -----
modparam("avpops", "db_url", "mysql://openser:openserrw@localhost/kamailio")
modparam("avpops", "avp_table", "usr_preferences")
#------ load the dpid field to a pseudo-variable $avp(s:dpid) ------
### modparam("auth_db", "load_credentials", "$avp(s:rpid)=rpid ;$avp(s:countrycode)=contrycode;$avp(s:areacode)=areacode")

modparam("dialplan", "db_url","mysql://openser:openserrw@localhost/kamailio")
## attribute of the matched line will be store in the $avp(s:dest)
modparam("dialplan", "attrs_pvar", "$avp(s:dest)")

if(!dp_translate("0","$rU/$rU")){
send_reply("420", "Invalid Destination");
exit;
}
xlog("$avp(s:dest)");
if ($avp(s:dest)=="pstn") {
#route to pstn
prefix("+90454");
enum_query();
$ru = "sip:" + $rU + "@" + $sel(cfg_get.pstn.gw_ip);
route(RELAY);
}

----

# kamctl db show dialplan
database engine 'MYSQL' loaded
Control engine 'FIFO' loaded
+----+------+----+----------+------------------+-----------+--------------------+----------+-------+
| id | dpid | pr | match_op | match_exp        | match_len | subst_exp          | repl_exp | attrs |
+----+------+----+----------+------------------+-----------+--------------------+----------+-------+
|  1 |    0 |  1 |        1 | ^[2-9][0-9]{6}.* |         0 | (^[2-9][0-9]{6}).* | 90212\1   | pstn  |
+----+------+----+----------+------------------+-----------+--------------------+----------+-------+


2012/1/31 Bayram Karagoz <karagoz.bayram@gmail.com>
Hi,

I'm trying to make when each subscriber dials 7 digits add subscriber based specific prefix to dialed number defined in subscriber or dialplan table. I know that it's possible with avp but I'm not professional about avp. could you send me a successful scenario and config example please? 



--
Bayram KARAGOZ
System Administrator

bayram@bayramkaragoz.org

www.bayramkaragoz.org