On Thursday 07 June 2007 21:21, Zahid Mehmood wrote:
Would it be relatively easier to provide the option for db mode again?
You can get the same -and more- functionality by using db_query, creating a list of destinations in the format and avp that next_gw() expects. ie sip:|0@destination;transport=udp which can be stored directly in the db or use a CONCAT or similar to create it from separate fields.
modparam("lcr", "gw_uri_avp", "1400") modparam("lcr", "ruri_user_avp", "1402")
if not avp_db_query("SELECT uri FROM pstn_gw WHERE '$(fU{s.escape.common})' LIKE callerid ORDER BY callerid DESC", "$avp(i:1400)") { INFO("Can't find PSTN gateways"); sl_send_reply("500", "Cannot load gateways"); return; } next_gw(); t_relay(); ...
Performance will be very dependent on the complexity of the query.