<h1>Project "FreeSWITCH Source" received a push.</h1>

<h2>branch: master updated</h2>
<pre>
       via: 080c5ae98167e590bebf698439c550bdb656925e (commit)
      from: 0806c3880104fff154802adb010713365ef6a0ed (commit)


</pre>= COMMIT LOG ===========================================================
<div class="highlight"><pre>committer: cypromis
comments: 
FS-1742 - Make Voicemail use 1 SQL query instead of 4 to get the message count use in MWI - Now also working on your more favourite and less favourite databases

<span style="color: #000080; font-weight: bold">diff --git a/src/mod/applications/mod_voicemail/mod_voicemail.c b/src/mod/applications/mod_voicemail/mod_voicemail.c</span>
<span style="color: #000080; font-weight: bold">index 80b011e..f868c3a 100644</span>
<span style="color: #A00000">--- a/src/mod/applications/mod_voicemail/mod_voicemail.c</span>
<span style="color: #00A000">+++ b/src/mod/applications/mod_voicemail/mod_voicemail.c</span>
<span style="color: #800080; font-weight: bold">@@ -1278,7 +1278,9 @@ static void message_count(vm_profile_t *profile, const char *id_in, const char *</span>
         myid = resolve_id(id_in, domain_name, &quot;message-count&quot;);
 
         switch_snprintf(sql, sizeof(sql),
<span style="color: #A00000">-                                        &quot;select read_epoch=0, read_flags, count(read_epoch) from voicemail_msgs where username=&#39;%s&#39; and domain=&#39;%s&#39; and in_folder=&#39;%s&#39; group by read_epoch=0,read_flags;&quot;,</span>
<span style="color: #00A000">+                                        &quot;select 1, read_flags, count(read_epoch) from voicemail_msgs where username=&#39;%s&#39; and domain=&#39;%s&#39; and in_folder=&#39;%s&#39; and read_epoch=0 group by read_flags </span>
<span style="color: #00A000">+                                        union </span>
<span style="color: #00A000">+                                        select 0, read_flags, count(read_epoch) from voicemail_msgs where username=&#39;%s&#39; and domain=&#39;%s&#39; and in_folder=&#39;%s&#39; and read_epoch&lt;&gt;0 group by read_flags;&quot;,        </span>
                                         myid, domain_name, myfolder);
 
         vm_execute_sql_callback(profile, profile-&gt;mutex, sql, message_count_callback, &amp;cbt);
</pre></div>
========================================================================<pre>

Summary of changes:
 src/mod/applications/mod_voicemail/mod_voicemail.c |    4 +++-
 1 files changed, 3 insertions(+), 1 deletions(-)
</pre>
<p>this email was generated because of /git/your-repo.git/hooks/post-receive by the file /git-core/contrib/hooks/post-receive-email<br />
For more info, see <a href="http://blog.chomperstomp.com/?p=630">http://blog.chomperstomp.com/?p=630</a>
-- <br />
FreeSWITCH Source</p>