[Serusers] SERWEB

[harry gaillac]

Thanks,

sql log for missed call:
///////////////////////////////////////////////////////
050713 14:23:31     340 Connect    
ser at serveur1.home.net on
                    340 Init DB     ser
                    340 Init DB     ser
                    340 Query       select first_name,
last_name from subscriber where (username='bob' and
domain='nxs.yi.org')
                    340 Init DB     ser
                    340 Query       select timezone
from subscriber where (username='bob' and
domain='nxs.yi.org')
                    340 Init DB     ser
                    340 Query       SELECT count(*) 
FROM missed_calls t1 WHERE t1.username='bob' and
t1.domain='nxs.yi.org'
                    340 Init DB     ser
                    340 Query       SELECT count(*)
FROM missed_calls t1, aliases t2 WHERE
'sip:bob at nxs.yi.org'=t2.contact AND
t2.username=t1.username AND t2.domain=t1.domain
                    340 Init DB     ser
                    340 Query       (select
t1.from_uri as inv_to_uri,
                                               
t1.sip_from as inv_sip_to,
                                               
t1.sip_callid as inv_callid,
                                               
t1.time as inv_time,
                                               
t1.fromtag as inv_fromtag,
                                               
t1.sip_status as inv_status,
                                                null
as bye_to_uri,
                                                null
as bye_sip_to,
                                                null
as bye_callid,
                                                null
as bye_time,
                                                null
as bye_fromtag,
                                                null
as bye_totag,
                                                null
as bye_from_uri,
                                                null
as bye_sip_from,
                                                null
as length,
                                               
t1.time as ttime , 'missed' as call_type FROM
missed_calls t1 WHERE t1.username='bob' and
t1.domain='nxs.yi.org' ) UNION (select t1.from_uri as
inv_to_uri,
                                               
t1.sip_from as inv_sip_to,
                                               
t1.sip_callid as inv_callid,
                                               
t1.time as inv_time,
                                               
t1.fromtag as inv_fromtag,
                                               
t1.sip_status as inv_status,
                                                null
as bye_to_uri,
                                                null
as bye_sip_to,
                                                null
as bye_callid,
                                                null
as bye_time,
                                                null
as bye_fromtag,
                                                null
as bye_totag,
                                                null
as bye_from_uri,
                                                null
as bye_sip_from,
                                                null
as length,
                                               
t1.time as ttime , 'missed' as call_type FROM
missed_calls t1, aliases t2 WHERE
'sip:bob at nxs.yi.org'=t2.contact AND
t2.username=t1.username AND t2.domain=t1.domain )
order by ttime desc limit 0, 20
                    340 Quit
///////////////////////////////////////////////////////

missed_calls table:
mysql> select * from missed_calls;
+------------------------------------------------------+--------------------------------+-------------------+------------+-----------------------------------+------------------------+----------------------+------------------------------+----------------------------------------+----------+--------+-------------------+-------+---------------------+----------------+
| sip_from                                            
| sip_to                         | sip_status        |
sip_method | i_uri                             | o_uri
                 | from_uri             | to_uri      
                | sip_callid                         
| username | domain | fromtag           | totag | time
               | timestamp      |
+------------------------------------------------------+--------------------------------+-------------------+------------+-----------------------------------+------------------------+----------------------+------------------------------+----------------------------------------+----------+--------+-------------------+-------+---------------------+----------------+
| "alice" <sip:alice at nxs.yi.org>;tag=C7F9FEE3-D707AE46
| <sip:84 at nxs.yi.org;user=phone> | 482 Loop Detected |
INVITE     | sip:84 at nxs.yi.org:5060;user=phone |
sip:alice at 192.168.0.20 | sip:alice at nxs.yi.org |
sip:84 at nxs.yi.org;user=phone |
a75a9eaf-a34e6609-202b22c at 192.168.0.20 | n/a      |
n/a    | C7F9FEE3-D707AE46 | n/a   | 2005-07-13
11:24:23 | 20050713132423 |
+------------------------------------------------------+--------------------------------+-------------------+------------+-----------------------------------+------------------------+----------------------+------------------------------+----------------------------------------+----------+--------+-------------------+-------+---------------------+----------------+
1 row in set (0.00 sec)


Serweb reply "No missed calls"


Harry


	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com