<p>Friendly Automation <strong>submitted</strong> this change.</p><p><a href="https://gerrit.asterisk.org/c/asterisk/+/13657">View Change</a></p><div style="white-space:pre-wrap">Approvals:
  George Joseph: Looks good to me, but someone else must approve
  Benjamin Keith Ford: Looks good to me, but someone else must approve
  Joshua Colp: Looks good to me, approved
  Friendly Automation: Approved for Submit

</div><pre style="font-family: monospace,monospace; white-space: pre-wrap;">func_odbc.conf.sample: Add example lookup<br><br>Change-Id: Ia05aab1f579597963d2ea23920d2210cfcb97c84<br>---<br>M configs/samples/func_odbc.conf.sample<br>1 file changed, 4 insertions(+), 4 deletions(-)<br><br></pre><pre style="font-family: monospace,monospace; white-space: pre-wrap;"><span>diff --git a/configs/samples/func_odbc.conf.sample b/configs/samples/func_odbc.conf.sample</span><br><span>index ca970e1..706b9ce 100644</span><br><span>--- a/configs/samples/func_odbc.conf.sample</span><br><span>+++ b/configs/samples/func_odbc.conf.sample</span><br><span>@@ -91,16 +91,16 @@</span><br><span> dsn=mysql1</span><br><span> readsql=${ARG1}</span><br><span> </span><br><span style="color: hsl(0, 100%, 40%);">-; ODBC_ANTIGF - A blacklist.</span><br><span style="color: hsl(0, 100%, 40%);">-[ANTIGF]</span><br><span style="color: hsl(120, 100%, 40%);">+; ODBC_ANTISOLICIT - A blacklist for known solicitors.</span><br><span style="color: hsl(120, 100%, 40%);">+[ANTISOLICIT]</span><br><span> dsn=mysql1,mysql2   ; Use mysql1 as the primary handle, but fall back to mysql2</span><br><span>                     ; if mysql1 is down.  Supports up to 5 comma-separated</span><br><span>                     ; DSNs.  "dsn" may also be specified as "readhandle" and</span><br><span>                     ; "writehandle", if it is important to separate reads and</span><br><span>                     ; writes to different databases.</span><br><span style="color: hsl(0, 100%, 40%);">-readsql=SELECT COUNT(*) FROM exgirlfriends WHERE callerid='${SQL_ESC(${ARG1})}'</span><br><span style="color: hsl(120, 100%, 40%);">+readsql=SELECT COUNT(*) FROM known_solicitors WHERE callerid='${SQL_ESC(${ARG1})}'</span><br><span> syntax=<callerid></span><br><span style="color: hsl(0, 100%, 40%);">-synopsis=Check if a specified callerid is contained in the ex-gf database</span><br><span style="color: hsl(120, 100%, 40%);">+synopsis=Check if a specified callerid is contained in the known solicitors database</span><br><span> </span><br><span> ; ODBC_PRESENCE - Retrieve and update presence</span><br><span> [PRESENCE]</span><br><span></span><br></pre><p>To view, visit <a href="https://gerrit.asterisk.org/c/asterisk/+/13657">change 13657</a>. To unsubscribe, or for help writing mail filters, visit <a href="https://gerrit.asterisk.org/settings">settings</a>.</p><div itemscope itemtype="http://schema.org/EmailMessage"><div itemscope itemprop="action" itemtype="http://schema.org/ViewAction"><link itemprop="url" href="https://gerrit.asterisk.org/c/asterisk/+/13657"/><meta itemprop="name" content="View Change"/></div></div>

<div style="display:none"> Gerrit-Project: asterisk </div>
<div style="display:none"> Gerrit-Branch: 17 </div>
<div style="display:none"> Gerrit-Change-Id: Ia05aab1f579597963d2ea23920d2210cfcb97c84 </div>
<div style="display:none"> Gerrit-Change-Number: 13657 </div>
<div style="display:none"> Gerrit-PatchSet: 1 </div>
<div style="display:none"> Gerrit-Owner: Sean Bright <sean.bright@gmail.com> </div>
<div style="display:none"> Gerrit-Reviewer: Benjamin Keith Ford <bford@digium.com> </div>
<div style="display:none"> Gerrit-Reviewer: Friendly Automation </div>
<div style="display:none"> Gerrit-Reviewer: George Joseph <gjoseph@digium.com> </div>
<div style="display:none"> Gerrit-Reviewer: Joshua Colp <jcolp@sangoma.com> </div>
<div style="display:none"> Gerrit-MessageType: merged </div>