[Serusers] SER+SERWEB - sr-users

14 Jul 2005


      hello,
according to method.get_missed_calls.php script
(serweb)
how can we set username and domaine in tables aliases
and missed_calls in order to display missed call from
serweb?
I set failure route for unavailable users
# -- tm params --
modparam("tm", "fr_inv_timer", 15)
modparam("tm", "fr_timer", 10)
t_on_failure("1"); in block for messages INVITE
failure_route[1] {
        ##########################
        #   Voicemail Handler    #
        ##########################
#       revert_uri(); # resend to voicemail with
original request URI
        rewritehostport("80.119.:10.595040");
}
//////////////////////////////////////////////////////
from: method.get_missed_calls.php
$q="(SELECT t1.from_uri,
t1.sip_from, t1.time, t1.sip_status  ".
                                        "FROM
".$config->data_sql->table_missed_calls." t1 ".
                                        "WHERE
t1.username='".$user->uname."' and
t1.domain='".$user->domain."' ) ".
                                "UNION ".
                                "(SELECT t1.from_uri,
t1.sip_from, t1.time, t1.sip_status ".
                                        "FROM
".$config->data_sql->table_missed_calls." t1,
".$config->data_sql->table_aliases." t2 ".
                                        "WHERE
'sip:".$user->uname."@".$user->domain."'".
"=t2.contact AND t2.username=t1.username AND
t2.domain=t1.domain ) ".
                                "ORDER BY time DESC ".
                                "limit
".$this->get_act_row().", ".$this->get_showed_rows(   
            }
///////////////////////////////////////////////////////
Harry
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com