via: 8c12162a9d92ceac55c6305f2336efcf7157b923 (commit)
from: bab7a2392f955facbb91d0f30512682e2b38773e (commit)
= COMMIT LOG ===========================================================
committer: Anthony Minessale
comments:
FS-3040
diff --git a/src/mod/applications/mod_voicemail/mod_voicemail.c b/src/mod/applications/mod_voicemail/mod_voicemail.c
index f829e57..bea8214 100644
--- a/src/mod/applications/mod_voicemail/mod_voicemail.c
+++ b/src/mod/applications/mod_voicemail/mod_voicemail.c
@@ -1277,9 +1277,14 @@ static void message_count(vm_profile_t *profile, const char *id_in, const char *
myid = resolve_id(id_in, domain_name, "message-count");
- switch_snprintf(sql, sizeof(sql), "select 1, read_flags, count(read_epoch) from voicemail_msgs where username='%s' and domain='%s' and in_folder='%s' "
- "and read_epoch=0 group by read_flags union select 0, read_flags, count(read_epoch) from voicemail_msgs where username='%s' "
- "and domain='%s' and in_folder='%s' and read_epoch<>0 group by read_flags;", myid, domain_name, myfolder);
+ switch_snprintf(sql, sizeof(sql), "select 1, read_flags, count(read_epoch) from voicemail_msgs where "
+ "username='%s' and domain='%s' and in_folder='%s' "
+ "and read_epoch=0 group by read_flags union select 0, read_flags, count(read_epoch) from voicemail_msgs where username='%s' "
+ "and domain='%s' and in_folder='%s' and read_epoch<>0 group by read_flags;",
+ myid, domain_name, myfolder, myid, domain_name, myfolder);
+
+
+
vm_execute_sql_callback(profile, profile->mutex, sql, message_count_callback, &cbt);
*total_new_messages = cbt.total_new_messages + cbt.total_new_urgent_messages;
Summary of changes: src/mod/applications/mod_voicemail/mod_voicemail.c | 11 ++++++++--- 1 files changed, 8 insertions(+), 3 deletions(-)
this email was generated because of /git/your-repo.git/hooks/post-receive by the file /git-core/contrib/hooks/post-receive-email
For more info, see http://blog.chomperstomp.com/?p=630
--
FreeSWITCH Source