26 Mar
2003
26 Mar
'03
2:30 p.m.
here is how i get the information of calls made by a user as identified
by the user's nai (username + realm) from radius accounting records that
i store in mysql database.
-- juha
/* Get call records of a user */
function vsp_getCalls($nai) {
$calls = array();
$call = array();
vsp_connect();
$result = mysql_query("SELECT t1.fromUri, t1.toUri, t1.date,
(sec_to_time(unix_timestamp(t2.date)-unix_timestamp(t1.date))) AS duration FROM radacct AS
t1, radacct AS t2 WHERE t1.nai = '$nai' AND t1.method = 'INVITE' AND
t2.method = 'BYE' and t1.callId = t2.callId ORDER BY t1.date DESC") or die
("<h1 align=center>Cannot access accounting information!</h1>");
while ( $call = mysql_fetch_array( $result ) ) {
$calls[] = $call;
}
// print_r(array_values($calls));
vsp_close();
return $calls;
}