14 Jul
2005
14 Jul
'05
12:32 p.m.
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