Thanks, sql log for missed call: /////////////////////////////////////////////////////// 050713 14:23:31 340 Connect ser(a)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(a)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