Revision
17296
Author
brian
Date
2010-04-14 19:01:54 -0500 (Wed, 14 Apr 2010)

Log Message

set appearance-index in update statement for SLA

Modified Paths

Diff

Modified: freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c (17295 => 17296)


--- freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c	2010-04-14 23:29:26 UTC (rev 17295)
+++ freeswitch/trunk/src/mod/endpoints/mod_sofia/sofia_presence.c	2010-04-15 00:01:54 UTC (rev 17296)
@@ -614,12 +614,12 @@
 #endif
 
 			if (uuid) {
-				sql = switch_mprintf("update sip_dialogs set call_info_state='%q' where hostname='%q' and uuid='%q'",
-									 call_info_state, mod_sofia_globals.hostname, uuid);
+				sql = switch_mprintf("update sip_dialogs set call_info='%q',call_info_state='%q' where hostname='%q' and uuid='%q'",
+									 call_info, call_info_state, mod_sofia_globals.hostname, uuid);
 			} else {
-				sql = switch_mprintf("update sip_dialogs set call_info_state='%q' where hostname='%q' and sip_dialogs.sip_from_user='%q' "
+				sql = switch_mprintf("update sip_dialogs set call_info='%q', call_info_state='%q' where hostname='%q' and sip_dialogs.sip_from_user='%q' "
 									 "and sip_dialogs.sip_from_host='%q' and call_info='%q'",
-									 call_info_state, mod_sofia_globals.hostname, euser, host, call_info);
+									 call_info, call_info_state, mod_sofia_globals.hostname, euser, host, call_info);
 
 			}