<div dir="ltr">I use: <a href="http://wiki.freeswitch.org/wiki/Mod_odbc_query">mod_odbc_query</a> to query SQL directly in the dialplan -- it's from the contrib repository.<div><div>Then you could store a bunch of information about each number and you get each one as a channel variable.</div>
<div><br clear="all"><div><div dir="ltr"><span style="font-family:Verdana,Arial,Helvetica,sans-serif;font-size:small">-Avi</span></div></div><br><div class="gmail_quote">On Mon, Mar 18, 2013 at 10:49 PM, Nathan Neulinger <span dir="ltr"><<a href="mailto:nneul@mst.edu" target="_blank">nneul@mst.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I was thinking of using mod_blacklist as a way to define a table of short extension numbers to be able to "look up" an<br>
entry in a dialplan condition. i.e. defining a blacklist "local_ext_but_not_freeswitch" - or for distinguishing easily<br>
between sip and skinny phones (is_sip_ext, is_skinny_ext).<br>
<br>
Does this seem like a useful use of the (somewhat misnamed) mod_blacklist, or a bad approach?<br>
<br>
Reason for this is that I'll have approximately 1600 extensions, discontiguous - some of which will be on freeswitch,<br>
others which won't. For the ones that are on freeswitch, some of them will be on skinny phones, and others will be on<br>
SIP phones.<br>
<br>
I was leaning toward something like:<br>
<br>
<extension name="Local Ext Check"><br>
<condition field="${blacklist(check is_local_ext $1)}" expression="^true$"><br>
<condition field="destination_number" expression="^(\d\d\d\d)$"><br>
<br>
</condition><br>
</condition><br>
</extension><br>
<br>
<br>
The alternative was to build a new module very similar to mod_blacklist - i.e. 'mod_lookup', with the additional<br>
capability of having a value lookup and not just existence check.<br>
<br>
I realize I could rig something up with mod_hash, but I like the 'load straight from a file' capability.<br>
<br>
Thoughts?<br>
<br>
-- Nathan<br>
<br>
------------------------------------------------------------<br>
Nathan Neulinger <a href="mailto:nneul@mst.edu">nneul@mst.edu</a><br>
Missouri S&T Information Technology <a href="tel:%28573%29%20612-1412" value="+15736121412">(573) 612-1412</a><br>
System Administrator - Architect<br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</blockquote></div><br></div></div></div>