= DATE_SUB(NOW(), INTERVAL 24 HOUR)";
$session_result = mysqli_query($conn, $session_sql);
$active_sessions = mysqli_fetch_assoc($session_result)['total'];
// Get channel status
$channel_sql = "SELECT COUNT(*) as total,
SUM(CASE
WHEN status = 1 AND updated_at >= DATE_SUB(NOW(), INTERVAL 10 HOUR) THEN 1
ELSE 0 END) as active,
SUM(CASE
WHEN status = 1 AND updated_at < DATE_SUB(NOW(), INTERVAL 10 HOUR) AND updated_at >= DATE_SUB(NOW(), INTERVAL 12 HOUR) THEN 1
ELSE 0 END) as warning,
SUM(CASE
WHEN status = 0 OR updated_at < DATE_SUB(NOW(), INTERVAL 12 HOUR) THEN 1
ELSE 0 END) as inactive
FROM tk_page";
$channel_result = mysqli_query($conn, $channel_sql);
$channel_metrics = mysqli_fetch_assoc($channel_result);
// Get latest session details
$sessions_sql = "SELECT us.*, mpu.remark, mpu.username
FROM user_sessions us
LEFT JOIN multi_page_user mpu ON us.user_agent = mpu.uagent
WHERE us.access_time >= DATE_SUB(NOW(), INTERVAL 24 HOUR)
ORDER BY us.access_time DESC
LIMIT 10";
$sessions_result = mysqli_query($conn, $sessions_sql);
// Get channel details
$channel_details_sql = "SELECT filename, status, updated_at, remark
FROM tk_page
ORDER BY updated_at DESC";
$channel_details_result = mysqli_query($conn, $channel_details_sql);
?>
-
DASHBOARD
Total Users
Subscribed
Unsubscribed
Pending
| CHANNEL NAME |
STATUS |
LAST UPDATE |
REMARK |
36000 && $time_diff <= 43200) {
$status_class = 'text-warning';
$status_text = 'Warning';
} elseif ($time_diff > 43200 || $row["status"] == 0) {
$status_class = 'text-danger';
$status_text = 'Inactive';
}
?>
|
|
|
|
| # |
USERNAME |
USER AGENT |
IP ADDRESS |
LAST ACTIVITY |
DEVICE FINGERPRINT |
REMARK |
|
|
|
|
|
|
|