Debug mode 5
<p>SELECT c.user_name, pi.fio, c.nas_port_id, c.framed_ip_address, SEC_TO_TIME(UNIX_TIMESTAMP() - UNIX_TIMESTAMP(c.started)), c.acct_input_octets + 4294967296 * acct_input_gigawords, c.acct_output_octets + 4294967296 * acct_output_gigawords, c.ex_input_octets, c.ex_output_octets, c.lupdated - UNIX_TIMESTAMP(c.started),
pi.phone,
INET_NTOA(c.framed_ip_address),
u.uid,
INET_NTOA(c.nas_ip_address),
if(company.name IS NULL, b.deposit, cb.deposit),
u.credit,
if(date_format(c.started, '%Y-%m-%d')=curdate(), date_format(c.started, '%H:%i:%s'), c.started),
UNIX_TIMESTAMP()-c.lupdated,
c.status,
c.nas_id,
c.user_name,
c.nas_port_id,
c.acct_session_id,
c.CID,
dv.tp_id
FROM dv_calls c
LEFT JOIN users u ON (u.id=user_name)
LEFT JOIN dv_main dv ON (dv.uid=u.uid)
LEFT JOIN users_pi pi ON (pi.uid=u.uid)
LEFT JOIN bills b ON (u.bill_id=b.id)
LEFT JOIN companies company ON (u.company_id=company.id)
LEFT JOIN bills cb ON (company.bill_id=cb.id)
ORDER BY 1 ;</p>
==> check_lines
NAS IP: 192.168.4.2
NAS_TYPE: mpd4
STATUS: 0
Alive: 200/
Alarm clock: 14