Re: [Serusers] SERWEB - sr-users

13 Jul 2005


      Thanks,
sql log for missed call:
///////////////////////////////////////////////////////
050713 14:23:31     340 Connect    
ser@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@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@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@nxs.yi.org;tag=C7F9FEE3-D707AE46
| sip:84@nxs.yi.org;user=phone | 482 Loop Detected |
INVITE     | sip:84@nxs.yi.org:5060;user=phone |
sip:alice@192.168.0.20 | sip:alice@nxs.yi.org |
sip:84@nxs.yi.org;user=phone |
a75a9eaf-a34e6609-202b22c@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