Hello,
My missed_calls table :
why serweb don't display missed calls ???????????
Harry
Database changed 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=50BB137A-817519BD | sip:85@nxs.yi.org;user=phone | 408 Request Timeout | INVITE | sip:85@nxs.yi.org:5060;user=phone | sip:bob@192.168.0.21 | sip:alice@nxs.yi.org | sip:85@nxs.yi.org;user=phone | adb4092e-a342085c-3cc75107@192.168.0.20 | n/a | n/a | 50BB137A-817519BD | n/a | 2005-07-11 19:59:27 | 20050711215927 | | "alice" sip:alice@nxs.yi.org;tag=58B3DFF7-D9F2FCDE | sip:bob@nxs.yi.org | 408 Request Timeout | INVITE | sip:bob@nxs.yi.org:5060 | sip:bob@192.168.0.21 | sip:alice@nxs.yi.org | sip:bob@nxs.yi.org | 81fb0c1b-22f91c71-913d7ca0@192.168.0.20 | n/a | n/a | 58B3DFF7-D9F2FCDE | n/a | 2005-07-11 20:00:39 | 20050711220039 | | "alice" sip:alice@nxs.yi.org;tag=C64ECD60-736973DB | sip:85@nxs.yi.org;user=phone | 408 Request Timeout | INVITE | sip:85@nxs.yi.org:5060;user=phone | sip:bob@192.168.0.21 | sip:alice@nxs.yi.org | sip:85@nxs.yi.org;user=phone | f3aa8034-44a4ec12-263ca735@192.168.0.20 | n/a | n/a | C64ECD60-736973DB | n/a | 2005-07-11 20:14:07 | 20050711221407 | | "alice" sip:alice@nxs.yi.org;tag=1C1BEC5D-3CA00B7C | sip:bob@nxs.yi.org | 408 Request Timeout | INVITE | sip:bob@nxs.yi.org:5060 | sip:bob@192.168.0.21 | sip:alice@nxs.yi.org | sip:bob@nxs.yi.org | c660cda1-a8c17ea7-1ccca34e@192.168.0.20 | n/a | n/a | 1C1BEC5D-3CA00B7C | n/a | 2005-07-11 20:22:23 | 20050711222223 | | "alice" sip:alice@nxs.yi.org;tag=270B9E3F-91BEA3C6 | sip:85@nxs.yi.org;user=phone;tag=275C18EB-7F246064 | 486 Busy Here | INVITE | sip:85@nxs.yi.org:5060;user=phone | sip:bob@192.168.0.21 | sip:alice@nxs.yi.org | sip:85@nxs.yi.org;user=phone | c6178fe3-361d479-30c5c848@192.168.0.20 | n/a | n/a | 270B9E3F-91BEA3C6 | 275C18EB-7F246064 | 2005-07-11 21:16:53 | 20050711231653 | | "alice" sip:alice@nxs.yi.org;tag=C9CA532F-3DECF576 | sip:bob@nxs.yi.org;tag=3BC100E0-65228A29 | 486 Busy Here | INVITE | sip:bob@nxs.yi.org:5060 | sip:bob@192.168.0.21 | sip:alice@nxs.yi.org | sip:bob@nxs.yi.org | e6d681d3-cfdf49e9-7f651478@192.168.0.20 | n/a | n/a | C9CA532F-3DECF576 | 3BC100E0-65228A29 | 2005-07-11 21:17:21 | 20050711231721 | | "alice" sip:alice@nxs.yi.org;tag=428D7F3B-FF325EF2 | sip:bob@nxs.yi.org;tag=4C783763-93E0625C | 486 Busy Here | INVITE | sip:bob@nxs.yi.org:5060 | sip:bob@192.168.0.21 | sip:alice@nxs.yi.org | sip:bob@nxs.yi.org | e29c741f-a6a36795-c372ac14@192.168.0.20 | n/a | n/a | 428D7F3B-FF325EF2 | 4C783763-93E0625C | 2005-07-11 21:18:56 | 20050711231856 | | "alice" sip:alice@nxs.yi.org;tag=2A96F9FF-DBB61286 | sip:85@nxs.yi.org;user=phone;tag=4B1A44D8-B81CC9A1 | 486 Busy Here | INVITE | sip:85@nxs.yi.org:5060;user=phone | sip:bob@192.168.0.21 | sip:alice@nxs.yi.org | sip:85@nxs.yi.org;user=phone | d6955fa3-7faff239-b34be108@192.168.0.20 | n/a | n/a | 2A96F9FF-DBB61286 | 4B1A44D8-B81CC9A1 | 2005-07-11 21:20:16 | 20050711232016 | +------------------------------------------------------+------------------------------------------------------+---------------------+------------+-----------------------------------+----------------------+----------------------+------------------------------+-----------------------------------------+----------+--------+-------------------+-------------------+---------------------+----------------+ 8 rows in set (0.00 sec)
___________________________________________________________________________ Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger Téléchargez cette version sur http://fr.messenger.yahoo.com