query("SELECT count(*) as total FROM vicidial_live_agents");
$agents_logged = $q->fetch_assoc()['total'];
/* Agents in call */
$q = $conn->query("SELECT count(*) as total
FROM vicidial_live_agents
WHERE status='INCALL'");
$agents_incall = $q->fetch_assoc()['total'];
/* Calls waiting */
$q = $conn->query("SELECT count(*) as total
FROM vicidial_auto_calls
WHERE status='LIVE'");
$calls_waiting = $q->fetch_assoc()['total'];
/* Calls today */
$q = $conn->query("SELECT count(*) as total
FROM vicidial_log
WHERE call_date >= '$date 00:00:00'");
$calls_today = $q->fetch_assoc()['total'];
/* Answered calls */
$q = $conn->query("SELECT count(*) as total
FROM vicidial_log
WHERE status='ANSWER'
AND call_date >= '$date 00:00:00'");
$answered = $q->fetch_assoc()['total'];
/* Dropped calls */
$q = $conn->query("SELECT count(*) as total
FROM vicidial_log
WHERE status IN('DROP','XDROP')
AND call_date >= '$date 00:00:00'");
$dropped = $q->fetch_assoc()['total'];
?>
VICIdial Monitor
VICIdial Live Monitor